exporting x&y values (coordinates) from graph builder once jmp automatically finds centroid points for a polygon

fever

How can I export x&y coordinates for the centroid points jmp automatically finds within my polygons (n=2455) on a graph builder map? I would like to make lat/long columns for these points in order to make contour and heat maps, but all I have currently are the many vertices coordinates for the mapshape polygons. These are municipalities in Mexico, so there is no determined point location (city) for the ad on to find (if it could), but the centroid points jmp finds is perfect for me. I don't know how to write script.

johnmoore

Fever,

 

Here is a quick script I wrote to find the centroids based on the XY shape file.  Please try and let me know how it works for you.

dt = Current Data Table();
shapeList = Associative Array( Column( dt, "Shape ID" ) << get values ) << get keys;
dtCentroids = New Table("Centroids", New Column( "Shape ID", numeric, continuous ),
	New Column( "X", numeric continuous ),
	New Column( "Y", numeric, continuous )
);
For( i = 1, i <= N Items( shapeList ), i++,
	targetRows = dt << get rows where( Column( dt, "Shape ID" )[Row()] == shapeList[i] );
	centroid = Polygon Centroid( Column( dt, "X" )[targetRows], Column( dt, "Y" )[targetRows] );
	dtCentroids << add rows( 1, "at end" );
	Column( dtCentroids, "Shape ID" )[i] = i;
	Column( dtCentroids, "X" )[i] = centroid[1];
	Column( dtCentroids, "Y" )[i] = centroid[2];
);