QGIS with MSSQLSpatial : no geometry. OgrInfo Corrupt dataFixing corrupt shapefile?ogrinfo SQL GROUP BY...
What is the command to reset a PC without deleting any files
What typically incentivizes a professor to change jobs to a lower ranking university?
Why is this code 6.5x slower with optimizations enabled?
Why is "Reports" in sentence down without "The"
How is the claim "I am in New York only if I am in America" the same as "If I am in New York, then I am in America?
Calculus Optimization - Point on graph closest to given point
Extreme, but not acceptable situation and I can't start the work tomorrow morning
How is the relation "the smallest element is the same" reflexive?
Draw simple lines in Inkscape
How do I create uniquely male characters?
least quadratic residue under GRH: an EXPLICIT bound
Circuitry of TV splitters
Prevent a directory in /tmp from being deleted
Can Medicine checks be used, with decent rolls, to completely mitigate the risk of death from ongoing damage?
Closed subgroups of abelian groups
"which" command doesn't work / path of Safari?
Infinite past with a beginning?
How can bays and straits be determined in a procedurally generated map?
New order #4: World
Why is an old chain unsafe?
Is there a familial term for apples and pears?
Are white and non-white police officers equally likely to kill black suspects?
A newer friend of my brother's gave him a load of baseball cards that are supposedly extremely valuable. Is this a scam?
How can the DM most effectively choose 1 out of an odd number of players to be targeted by an attack or effect?
QGIS with MSSQLSpatial : no geometry. OgrInfo Corrupt data
Fixing corrupt shapefile?ogrinfo SQL GROUP BY Clauseogrinfo bash script failureHow to get EPSG with OGRinfo?ogrinfo sql exampleC# ogrinfo with virtual vector source doesn't work GDAL 1.10How do you use ogrinfo with a SQL Server database?Create empty geometry in QGIS with pythonConverting SQL geometry data queries into R spatial dataframesSQL WKT draws well with geometry, but not with geography data type
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}
I am having this issue while I am trying to connect to my MSSQLSpatial database.
So, I've created this features with just one record with geometry. I can see this feature on Microsoft Management Studio as well on GIS Desktop (Geomedia). My goal is to perfom a connection from this database to QGIS. In fact, I can connect all my tables into QGIS (QGIS version 3.6.0-Noosa) and see their attributes but unfortunately the geometry doesn't show up.
I check the orginfo and you may see the logs as the following:
ogrinfo -al "MSSQL:server=MYSPATIALSERVENAME;database=MYSPATIALDATABASE;tables=MYTABLE;trusted_connection=yes" -fid 1
Result:
Layer name: MYTABLE
Geometry: Unknown (any)
Feature Count: 1
ERROR 1: GetNextRawFeature(): Corrupt data
Layer SRS WKT:
PROJCS["NZGD2000 / New Zealand Transverse Mercator 2000",
GEOGCS["NZGD2000",
DATUM["New_Zealand_Geodetic_Datum_2000",
SPHEROID["GRS 1980",6378137,298.257222101,
AUTHORITY["EPSG","7019"]],
TOWGS84[0,0,0,0,0,0,0],
AUTHORITY["EPSG","6167"]],
PRIMEM["Greenwich",0,
AUTHORITY["EPSG","8901"]],
UNIT["degree",0.0174532925199433,
AUTHORITY["EPSG","9122"]],
AUTHORITY["EPSG","4167"]],
PROJECTION["Transverse_Mercator"],
PARAMETER["latitude_of_origin",0],
PARAMETER["central_meridian",173],
PARAMETER["scale_factor",0.9996],
PARAMETER["false_easting",1600000],
PARAMETER["false_northing",10000000],
UNIT["metre",1,
AUTHORITY["EPSG","9001"]],
AUTHORITY["EPSG","2193"]]
FID Column = ID
Geometry Column = Geometry_SPA
Name: String (50.0)
Geometry: Binary (0.0)
ERROR 1: GetNextRawFeature(): Corrupt data
OGRFeature(testFeature):1
Name (String) = test1
Geometry (Binary) = C8FFD20FBC8CCF11ABDE08003601B7696898B09D44DA35418295C131AA06534100000000...
It shows this error: ERROR 1: GetNextRawFeature(): Corrupt data
I also tried with a different table and the same happens. What am I missing here? Why is giving me this corrupt data?
qgis-3 ogr sql-server-spatial
asked 13 mins ago
ePascoalePascoal
4761418
add a comment |
I am having this issue while I am trying to connect to my MSSQLSpatial database.
So, I've created this features with just one record with geometry. I can see this feature on Microsoft Management Studio as well on GIS Desktop (Geomedia). My goal is to perfom a connection from this database to QGIS. In fact, I can connect all my tables into QGIS (QGIS version 3.6.0-Noosa) and see their attributes but unfortunately the geometry doesn't show up.
I check the orginfo and you may see the logs as the following:
ogrinfo -al "MSSQL:server=MYSPATIALSERVENAME;database=MYSPATIALDATABASE;tables=MYTABLE;trusted_connection=yes" -fid 1
Result:
Layer name: MYTABLE
Geometry: Unknown (any)
Feature Count: 1
ERROR 1: GetNextRawFeature(): Corrupt data
Layer SRS WKT:
PROJCS["NZGD2000 / New Zealand Transverse Mercator 2000",
GEOGCS["NZGD2000",
DATUM["New_Zealand_Geodetic_Datum_2000",
SPHEROID["GRS 1980",6378137,298.257222101,
AUTHORITY["EPSG","7019"]],
TOWGS84[0,0,0,0,0,0,0],
AUTHORITY["EPSG","6167"]],
PRIMEM["Greenwich",0,
AUTHORITY["EPSG","8901"]],
UNIT["degree",0.0174532925199433,
AUTHORITY["EPSG","9122"]],
AUTHORITY["EPSG","4167"]],
PROJECTION["Transverse_Mercator"],
PARAMETER["latitude_of_origin",0],
PARAMETER["central_meridian",173],
PARAMETER["scale_factor",0.9996],
PARAMETER["false_easting",1600000],
PARAMETER["false_northing",10000000],
UNIT["metre",1,
AUTHORITY["EPSG","9001"]],
AUTHORITY["EPSG","2193"]]
FID Column = ID
Geometry Column = Geometry_SPA
Name: String (50.0)
Geometry: Binary (0.0)
ERROR 1: GetNextRawFeature(): Corrupt data
OGRFeature(testFeature):1
Name (String) = test1
Geometry (Binary) = C8FFD20FBC8CCF11ABDE08003601B7696898B09D44DA35418295C131AA06534100000000...
It shows this error: ERROR 1: GetNextRawFeature(): Corrupt data
I also tried with a different table and the same happens. What am I missing here? Why is giving me this corrupt data?
qgis-3 ogr sql-server-spatial
asked 13 mins ago
ePascoalePascoal
4761418
add a comment |
I am having this issue while I am trying to connect to my MSSQLSpatial database.
So, I've created this features with just one record with geometry. I can see this feature on Microsoft Management Studio as well on GIS Desktop (Geomedia). My goal is to perfom a connection from this database to QGIS. In fact, I can connect all my tables into QGIS (QGIS version 3.6.0-Noosa) and see their attributes but unfortunately the geometry doesn't show up.
I check the orginfo and you may see the logs as the following:
ogrinfo -al "MSSQL:server=MYSPATIALSERVENAME;database=MYSPATIALDATABASE;tables=MYTABLE;trusted_connection=yes" -fid 1
Result:
Layer name: MYTABLE
Geometry: Unknown (any)
Feature Count: 1
ERROR 1: GetNextRawFeature(): Corrupt data
Layer SRS WKT:
PROJCS["NZGD2000 / New Zealand Transverse Mercator 2000",
GEOGCS["NZGD2000",
DATUM["New_Zealand_Geodetic_Datum_2000",
SPHEROID["GRS 1980",6378137,298.257222101,
AUTHORITY["EPSG","7019"]],
TOWGS84[0,0,0,0,0,0,0],
AUTHORITY["EPSG","6167"]],
PRIMEM["Greenwich",0,
AUTHORITY["EPSG","8901"]],
UNIT["degree",0.0174532925199433,
AUTHORITY["EPSG","9122"]],
AUTHORITY["EPSG","4167"]],
PROJECTION["Transverse_Mercator"],
PARAMETER["latitude_of_origin",0],
PARAMETER["central_meridian",173],
PARAMETER["scale_factor",0.9996],
PARAMETER["false_easting",1600000],
PARAMETER["false_northing",10000000],
UNIT["metre",1,
AUTHORITY["EPSG","9001"]],
AUTHORITY["EPSG","2193"]]
FID Column = ID
Geometry Column = Geometry_SPA
Name: String (50.0)
Geometry: Binary (0.0)
ERROR 1: GetNextRawFeature(): Corrupt data
OGRFeature(testFeature):1
Name (String) = test1
Geometry (Binary) = C8FFD20FBC8CCF11ABDE08003601B7696898B09D44DA35418295C131AA06534100000000...
It shows this error: ERROR 1: GetNextRawFeature(): Corrupt data
I also tried with a different table and the same happens. What am I missing here? Why is giving me this corrupt data?
qgis-3 ogr sql-server-spatial
asked 13 mins ago
ePascoalePascoal
4761418
I am having this issue while I am trying to connect to my MSSQLSpatial database.
So, I've created this features with just one record with geometry. I can see this feature on Microsoft Management Studio as well on GIS Desktop (Geomedia). My goal is to perfom a connection from this database to QGIS. In fact, I can connect all my tables into QGIS (QGIS version 3.6.0-Noosa) and see their attributes but unfortunately the geometry doesn't show up.
I check the orginfo and you may see the logs as the following:
ogrinfo -al "MSSQL:server=MYSPATIALSERVENAME;database=MYSPATIALDATABASE;tables=MYTABLE;trusted_connection=yes" -fid 1
Result:
Layer name: MYTABLE
Geometry: Unknown (any)
Feature Count: 1
ERROR 1: GetNextRawFeature(): Corrupt data
Layer SRS WKT:
PROJCS["NZGD2000 / New Zealand Transverse Mercator 2000",
GEOGCS["NZGD2000",
DATUM["New_Zealand_Geodetic_Datum_2000",
SPHEROID["GRS 1980",6378137,298.257222101,
AUTHORITY["EPSG","7019"]],
TOWGS84[0,0,0,0,0,0,0],
AUTHORITY["EPSG","6167"]],
PRIMEM["Greenwich",0,
AUTHORITY["EPSG","8901"]],
UNIT["degree",0.0174532925199433,
AUTHORITY["EPSG","9122"]],
AUTHORITY["EPSG","4167"]],
PROJECTION["Transverse_Mercator"],
PARAMETER["latitude_of_origin",0],
PARAMETER["central_meridian",173],
PARAMETER["scale_factor",0.9996],
PARAMETER["false_easting",1600000],
PARAMETER["false_northing",10000000],
UNIT["metre",1,
AUTHORITY["EPSG","9001"]],
AUTHORITY["EPSG","2193"]]
FID Column = ID
Geometry Column = Geometry_SPA
Name: String (50.0)
Geometry: Binary (0.0)
ERROR 1: GetNextRawFeature(): Corrupt data
OGRFeature(testFeature):1
Name (String) = test1
Geometry (Binary) = C8FFD20FBC8CCF11ABDE08003601B7696898B09D44DA35418295C131AA06534100000000...
It shows this error: ERROR 1: GetNextRawFeature(): Corrupt data
I also tried with a different table and the same happens. What am I missing here? Why is giving me this corrupt data?
qgis-3 ogr sql-server-spatial
qgis-3 ogr sql-server-spatial
asked 13 mins ago
ePascoalePascoal
4761418
asked 13 mins ago
ePascoalePascoal
4761418
asked 13 mins ago
ePascoalePascoal
4761418
asked 13 mins ago
ePascoalePascoal
4761418
asked 13 mins ago
ePascoalePascoal
4761418
4761418
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "79"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f318070%2fqgis-with-mssqlspatial-no-geometry-ogrinfo-corrupt-data%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Geographic Information Systems Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f318070%2fqgis-with-mssqlspatial-no-geometry-ogrinfo-corrupt-data%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
