topic Writing data with deprecated coordinate systems with FME Workbench? in Data Management Questions https://community.esri.com/t5/data-management-questions/writing-data-with-deprecated-coordinate-systems/m-p/530715#M30084 <HTML><HEAD></HEAD><BODY><P>All,</P><P></P><P>I recently fired up FME 2015 (through the Data Interoperability Extension) and when trying to write data from PostGIS (in EPSG:3426) to MSSQL Spatial in CO State Plane (EPSG:2877), I get a warning that the coordinate system is deprecated and no SRID can be set on the data.</P><P></P><P>I'm using the ESRI Reprojector to set the parameters, and they have worked fine in the past.</P><P></P><P>What is strange, however, is when writing to ArcSDE Feature Classes using the same source and destination coordinate systems and reprojection parameters, there is no warning about the deprecated coordinate system and the data runs fine.</P><P></P><P>Any thoughts on the difference in behaviour between these two source formats when using the EPSG:2877 (DEPRECATED) coordinate system?</P><P></P><P>Thanks!</P></BODY></HTML> Tue, 07 Jun 2016 21:23:16 GMT MatthewBaker2 2016-06-07T21:23:16Z Writing data with deprecated coordinate systems with FME Workbench? https://community.esri.com/t5/data-management-questions/writing-data-with-deprecated-coordinate-systems/m-p/530715#M30084 <HTML><HEAD></HEAD><BODY><P>All,</P><P></P><P>I recently fired up FME 2015 (through the Data Interoperability Extension) and when trying to write data from PostGIS (in EPSG:3426) to MSSQL Spatial in CO State Plane (EPSG:2877), I get a warning that the coordinate system is deprecated and no SRID can be set on the data.</P><P></P><P>I'm using the ESRI Reprojector to set the parameters, and they have worked fine in the past.</P><P></P><P>What is strange, however, is when writing to ArcSDE Feature Classes using the same source and destination coordinate systems and reprojection parameters, there is no warning about the deprecated coordinate system and the data runs fine.</P><P></P><P>Any thoughts on the difference in behaviour between these two source formats when using the EPSG:2877 (DEPRECATED) coordinate system?</P><P></P><P>Thanks!</P></BODY></HTML> Tue, 07 Jun 2016 21:23:16 GMT https://community.esri.com/t5/data-management-questions/writing-data-with-deprecated-coordinate-systems/m-p/530715#M30084 MatthewBaker2 2016-06-07T21:23:16Z Re: Writing data with deprecated coordinate systems with FME Workbench? https://community.esri.com/t5/data-management-questions/writing-data-with-deprecated-coordinate-systems/m-p/530716#M30085 <HTML><HEAD></HEAD><BODY><P>hmmm does this make any sense to you <A href="https://www.epsg-registry.org/" title="https://www.epsg-registry.org/">EPSG Geodetic Parameter Registry</A> </P><P>I will flag <A href="https://community.esri.com/migrated-users/3120">Melita Kennedy</A>​ to provide some guidance as well</P></BODY></HTML> Tue, 07 Jun 2016 21:32:26 GMT https://community.esri.com/t5/data-management-questions/writing-data-with-deprecated-coordinate-systems/m-p/530716#M30085 DanPatterson_Retired 2016-06-07T21:32:26Z Re: Writing data with deprecated coordinate systems with FME Workbench? https://community.esri.com/t5/data-management-questions/writing-data-with-deprecated-coordinate-systems/m-p/530717#M30086 <HTML><HEAD></HEAD><BODY><P>I don't think it's an ESRI problem as much as it is an FME problem... I posted to their forum but no one has replied...</P><P></P><P>The workaround is to use:</P><P></P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_14653368247821987 jive_text_macro" data-renderedposition="112_8_1332_16" jivemacro_uid="_14653368247821987" modifiedtitle="true"><P>update schema.tableName set shape.STSrid = '2877'</P></PRE><P></P><P>...which you can do from sql server management studio or in the 'sql to run after translation' option in FME.</P></BODY></HTML> Tue, 07 Jun 2016 22:00:37 GMT https://community.esri.com/t5/data-management-questions/writing-data-with-deprecated-coordinate-systems/m-p/530717#M30086 MatthewBaker2 2016-06-07T22:00:37Z Re: Writing data with deprecated coordinate systems with FME Workbench? https://community.esri.com/t5/data-management-questions/writing-data-with-deprecated-coordinate-systems/m-p/530718#M30087 <HTML><HEAD></HEAD><BODY><P>Hey Matt, </P><P></P><P>How are you doing?</P><P></P><P>Well, this is interesting because my original answer was going to be along the lines of we don't normally check whether a WKID is deprecated or not beyond looking up the "current" WKID. However, when I check the EPSG registry, 2877 (NAD83(HARN) / Colorado Central (ftUS)) is still valid, not deprecated.</P><P></P><P>I thought maybe the number had been marked deprecated by mistake but none of the Colorado zones have ever been deprecated. I looked quickly through the deprecation table, but the closest numbers that have been deprecated recently are 2857 and 2867. Both are areas, not coordinate reference systems.</P><P></P><P>Melita</P></BODY></HTML> Tue, 07 Jun 2016 22:18:47 GMT https://community.esri.com/t5/data-management-questions/writing-data-with-deprecated-coordinate-systems/m-p/530718#M30087 MelitaKennedy 2016-06-07T22:18:47Z Re: Writing data with deprecated coordinate systems with FME Workbench? https://community.esri.com/t5/data-management-questions/writing-data-with-deprecated-coordinate-systems/m-p/530719#M30088 <HTML><HEAD></HEAD><BODY><P>Hey Melita!</P><P></P><P>That is super helpful and I will pass it on to the FME folks - do you happen to know where that deprecation table is?</P><P></P><P>Otherwise, we're great here in Denver! Both busy at home and work... hope you an Colin and the family are doing well!!!</P><P></P><P>Thanks again!!!</P></BODY></HTML> Wed, 08 Jun 2016 14:43:07 GMT https://community.esri.com/t5/data-management-questions/writing-data-with-deprecated-coordinate-systems/m-p/530719#M30088 MatthewBaker2 2016-06-08T14:43:07Z Re: Writing data with deprecated coordinate systems with FME Workbench? https://community.esri.com/t5/data-management-questions/writing-data-with-deprecated-coordinate-systems/m-p/530720#M30089 <HTML><HEAD></HEAD><BODY><P>You can download an Access database of the EPSG dataset and/or various sql or other formats. You have to set up an account, but you'll only get emails about the dataset, nothing else. It's not 100% up-to-date as it's released twice a year (approximately April and October) whereas the online registry continually updates.</P><P></P><P><A href="http://www.epsg-registry.org/">http://www.epsg-registry.org</A> : to export in GML, SQL, or WKT (WKT for CRS and transformations only)</P><P><A href="http://www.epsg.org/">http://www.epsg.org</A> : Access database</P><P></P><P>Melita</P></BODY></HTML> Wed, 08 Jun 2016 19:02:00 GMT https://community.esri.com/t5/data-management-questions/writing-data-with-deprecated-coordinate-systems/m-p/530720#M30089 MelitaKennedy 2016-06-08T19:02:00Z Re: Writing data with deprecated coordinate systems with FME Workbench? https://community.esri.com/t5/data-management-questions/writing-data-with-deprecated-coordinate-systems/m-p/530721#M30090 <HTML><HEAD></HEAD><BODY><P>Thanks, Melita!</P></BODY></HTML> Wed, 08 Jun 2016 20:08:54 GMT https://community.esri.com/t5/data-management-questions/writing-data-with-deprecated-coordinate-systems/m-p/530721#M30090 MatthewBaker2 2016-06-08T20:08:54Z