Skip to main content
Question

Map data with fields that have no coordinates

chris_acc
Contributor
Forum|alt.badge.img+5

Hi,

I have a CSV file which i would like to convert to Shape file so that it can be mapped. Within the data there are Easting and Northing fields with coordinates and can convert successfully but there are some records that have no coordinates.

The records with no coordinates do have zipcodes/postcodes however and I hope to match to their centroid as I have the postcode data with centroids to hand.

I figure I need to somehow identify the Easting and Northing fields that contain no values then match them using the Postcode in a stand alone table that has the centroid coordinates then join all the data back up again to generate a single shape file.

Not used FME very much at all and rather confused as to which Transformers etc. required. Thanks in advance.FME_CSV2SHP

3 replies

nielsgerrits
VIP

The GeometryFilter can check if the CSV reader could read Easting / Northing.

The FeatureMerger can join the Postcode table to the features without geometry.

The VertexCreator can create points from Easting / Northing.

rahulsharma
Safer
Forum|alt.badge.img+10

Hi @chris_acc​ as @nielsgerrits​ mentioned you can use Vertex creator or simply set the x and y values in the CSV reader itself. You will definitely require FeatureMerger to perform a join.

1 Attachments
chris_acc
Contributor
Forum|alt.badge.img+5
  • chris_accContributor
  • Author
  • Contributor
  • June 10, 2021

Thank you @rahulsharma​ @nielsgerrits​ 

I have added the Feature Merger and and the CSV file I have created that contains each Postcode and a coordinate for each.

CSV_FeatureMerger1I'm struggling to understand the Properties required in Feature Merger however

FME_FeatureMerger2I think I would then have to create a writer to output matched records?

The idea I have is below, I just don't understand the process. Hopefully someone can help please.

HMO_Process_Flow

Reply


Helpful Members This Week

Community Stats

30,938
Posts
117,250
Replies
38,740
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.