I have a column named "Coordinates" with x,y data with the word POINTZ before the coordinate.
Example: POINT Z (-113.807295690 52.269077310 842.30)
I would like to put just the values in seperate columns (X & Y) containing no text.....
Once I have the x,y in seperate columns i'm assuming its easy to convert the .csv to a .shp
Any thoughts
There are several ways, I would use a StringSearcher with these settings:
Attribute: Coordinates
Regular Expression: ^.*\\(([^\\s]+)\\s+([^\\s]+)\\s+([^\\s]+)\\)$
Matched Parts Attribute: _coord
The StringSearcher adds a list attribute (coord{}) to each feature.
If "Coordinates" is "POINT Z (-113.807295690 52.269077310 842.30), for example, the list elements will be:
_coord{0} = -113.807295690
_coord{1} = 52.269077310
_coord{2} = 842.30
Takashi
the text looks to be in the WKT format. If so, you could use a GeometryReplacer (with "OGC Well Known Text" as format) to convert the text into a geometry. Then use a CoordinateExtractor to get the individual values.
David
I do not see the list Attributes that the StringSearcher is supposed to create? _coord{0}
I'm a little lost when going from the StringSearcher to the GeoMedia SQL Server Warehouse.
Also not sure how to implement this code into the the StringSearcher parameters?
--Do I use Constant
--Do I use multiple StringSearcher Transformers?
--Where do you set the _coord{0} . . . ?
Tyler
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
