Hot answers tagged sql-server
ArcGIS doesn't like fieldnames with spaces, or any other non-alphanumeric character for that matter (other than the underscore _) The Esri FAQ What characters should not be used in ArcGIS for field names and table names? says Eliminate any characters that are not alphanumeric character or an underscore. Do not start field or table names with an ...
Esri's Attribute Assistant has a tool called Generate ID which will automatically generate a new ID whenever a new feature is created. These IDs can be created per feature class to generate different IDs for different feature classes, and can be created based on a specific template if required.
Problem solved. There was a wrong row in the "spatial_ref_sys" table of the SQL Server database, which was referring to an unexisting SRS. I've replaced it with the following row for WGS84 SRS. srid:4326 auth_name:EPSG auth_srid:4326 srtext:GEOGCS["WGS 84",DATUM["WGS_1984",SPHEROID["WGS ...
SQL Server spatial functions implementation is in its current state not able to reproject or transform between different coordinate reference systems. The spatial data types are nothing more than a CLR (Coomon Language Runtime) data type implementation of the OGC Simple Feature Access specification plus some extended functions plus the spatial index. You can ...
Only top voted, non community-wiki answers of a minimum length are eligible