Hi Laura, I believe that if the values are left to default then the spatial domain of the new table is created by the spatial domain of the first feature class that is read. Therefore, if it happens to be your Canada or US feature classes then any features with coordinates outside of that will cause the translation to fail. My belief is partly based on what is is said here (from FMEPedia):
Please also note that when creating a new feature class in a translation FME creates the table and defines the spatial domain when it attempts to write the first feature for a feature class. Subsequent attempts to load data may fail if the initial attempt defined any of the spatial domain parameters incorrectly. Deleting the feature class will allow FME to create new tables with revised parameters. For this reason, I think you are better off to manually set the minimum X value to -180, the minimum Y value to -90, and the Scale to 1,000,000 (giving you 6 decimal places) I hope this helps, Grant Huntington GIS Analyst Dynamic Risk Assessment Systems Calgary, AB --- In [email protected], "Laura Cerquozzi" <[EMAIL PROTECTED]> wrote: > > Hello! > > > > I'm hoping that someone can help me. I have three layers - one that > contains points in Canada, one with points in the US, and one with > points around the rest of the world. I'm trying to combine these layers > together and import them into SDE as a feature class. I've defined the > output projection (from ESRI) as: > > > > Angular Unit: Degree (0.017453292519943295) > > Prime Meridian: Greenwich (0.000000000000000000) > > Datum: D_WGS_1984 > > Spheroid: WGS_1984 > > Semimajor Axis: 6378137.000000000000000000 > > Semiminor Axis: 6356752.314245179300000000 > > Inverse Flattening: 298.257223563000030000 > > > > When I run the tool (spatial ETL tool in ArcGIS 9.2), I get the > following error: > > > > Error while generating point shape for Table 'PPN'.:SDE_ERROR_CODE(-139) > The specified coordinate exceeds the valid coordinate range > > > > The table does not exist in the SDE and I have left all the default > parameters for the output. I have full admin rights on the SDE database. > > > > Thanks again for your help! > > > > > > Laura Cerquozzi > > GIS & Profiling Coordinator > > The Weather Network > > (905) 829-1159 ext. 1216 > > [EMAIL PROTECTED] >
