When manipulating a spatial database using SQL statements, there are many cases where the syntax requires SRID (Spatial Reference System Identifier). If you are going to use such SQL statements with the SQLExecutor, will have to find a proper SRID from a documentation. It might be convenient if there was a transformer which can be used to interpret any FME Coordinate System to the corresponding SRID.
Ability to interpret FME Coordinate System to SRID
FME Form
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Hi Takashi,
The CoordinateSystemDescriptionConverter can do exactly what you are asking for (assuming you can work with EPSG or Oracle SRIDs).
Cheers!
Oh, I didn't know that the CoordinateSystemDescriptionConverter has the ability to convert FME coordinate system to EPSG or Oracle SRID. Thanks for your feed back.
I frequently use PostGIS database and also sometimes use MS SQL Server. Their SRIDs seem to match EPSG numbers. If so, the transformer is sufficient to get SRID for major DBMSs.