I used ESRI to create a point feature class using linear referencing, loading the data into an SDE database on SQL server. The resulting data set would not display in QGIS. I checked the SRID, validated the geometry, and narrowed the results.<\/p>\n
I have seen issues with Line feature classes in QGIS where the line has measure values in ESRI. These wont display. Could this be the same issue with these points?<\/p>\n
Yep. Of all the stupid things for ESRI to do, the points have measures<\/strong>.<\/p>\n Here are the properties of the point feature class:<\/p>\n By including the measures in the points, ESRI is forced to provide a value for the Z when adding the records to SQL. This is due to a requirement that data is loaded in X,Y,Z,M where each value is space delineated. <\/p>\n So an example point looks like this: There is no way to add the measure without adding a placeholder for the Z.<\/p>\n As for the lines, I am going to have to say that it is a bug to not display correctly in QGIS for the same reason.<\/p>\n UPDATE:<\/strong> Thanks QGIS contributors! This is now fixed to handle this data. <\/p>\n Finally, to examine your data you can use these MSSQL methods:<\/p>\n I used ESRI to create a point feature class using linear referencing, loading the data into an SDE database on SQL server. The resulting data set would not display in QGIS. I checked the SRID, validated the geometry, and narrowed the results. I have seen issues with Line feature classes in QGIS where the line … Continue reading Creating a point feature class with linear referencing in ESRI wierdness<\/span> Feature Type: Simple
\nGeometry Type: Point
\nCoordinates have Z values: No
\nCoordinates have measures: Yes <\/code><\/p>\n
\nPOINT (1199100.2299588919 880237.32388755679 NULL 4.2200000000011642)<\/code><\/p>\nShape.AsTextZM()
\nor
\nShape.ToString()
\n<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"