Skip to main content
Solved

How can I extract groups of 50 rows and create N polygons with attributes from a text file?

  • January 14, 2020
  • 2 replies
  • 16 views

The output feature class based on the sample data should have 3 features (one per file) and 50 columns named and populated from all lines which include the symbol “=”, e.g line 7: LIDAR POINT COUNT=35,391,512, where the ColumnName is "LIDAR POINT COUNT" and the Value is "35,391,512".

The polygon should be created using the UPPER LEFT X, UPPER LEFT Y, LOWER RIGHT X and LOWER RIGHT Y.

The number of features will vary from file to file; another file might result in 312 features.

I have managed to extract the desired rows and aggregate them into the requisite 3 features (see attached 2017 fmw), but am now stuck as to how to pull the attributes back apart and build the polygons...

Best answer by cdalessandro

One way to doso was to create and reread a csv temp file. i wrote a workspace for You. This shold be the result You were looking for.

group_counter.zip

This post is closed to further activity.
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.

2 replies

cdalessandro
Contributor
Forum|alt.badge.img+4
  • Contributor
  • 19 replies
  • Best Answer
  • January 14, 2020

One way to doso was to create and reread a csv temp file. i wrote a workspace for You. This shold be the result You were looking for.

group_counter.zip


  • Author
  • 1 reply
  • January 14, 2020

@cdalessandro Thanks!