It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+51- Celebrity
- 2077 replies
Hello @pbiffar
If I understood your doubt, you want to read a CSV file and extract lat and long, by last geospatial these points, correct?
If yes, you can use the transformer VertexCreator to Replace with Point.
Thanks,
Danilo
take the csv lat lon and create point geom, I think I found that it does that automatically?
Here is a more complex question.
I have csv A and csv B of the same data columns. Let's say A is from July issue of data and B is August issue date. Some of the data is the same in both, some is updated, some is new in B, some is in A but not in B
Assume data has a unique id numbers.
Is there one or a combination of transformers which identify.
- what rows are in A but not in B
- what rows are in B not in A
- what is identical in A and B
- what rows have changed in A versus B, ideally which fields of the row have changed
- 7843 replies
Hi @pbiffar , as @danilo_fme suggested, you can use the VertexCreator to create a point from the two column values - lat and lon.
Alternatively you can also create a point geometry directly from the two column values for each record if you specify attribute types "x_coord" and "y_coord" for the two columns through the reader parameters dialog when adding the CSV reader, as in:
Regarding the second question, the ChangeDetector transformer might help you.