New answers tagged

1

Since you know the coordinates for your pixels, I'll assume that your data are georeferenced. In general the workflow would go like this: 1) Create a shapefile containing the common area. You can do that manually by using any gis software package, or programmatically by using the BBoxes of your datasets. 2) Use that shapefile to cookie-cut your datasets ...


1

Do you mean you want a boundingbox? Then read the record, draw the first point with the VertexCreator, add the second point with another VertexCreator and replace the geometry with the BoundingBoxReplacer.


2

I did port the Python code to php: <?php function parseFloat($ptString) { if (strlen($ptString) == 0) { return false; } $pString = str_replace(" ", "", $ptString); if (substr_count($pString, ",") > 1) $pString = str_replace(",", "", $pString); if ...


2

Check ST_Transform from the very helpful PostGIS docs: SELECT ST_AsText(ST_Transform(ST_GeomFromText('POLYGON((-71.1776585052917 42.3902909739571,-71.1776820268866 42.3903701743239, -71.1776063012595 42.3903825660754,-71.1775826583081 42.3903033653531,-71.1776585052917 42.3902909739571))',4326),2249)) As wgs_geom;


0

Download the state boundary shapefiles from US Census bureau. Load the polygon shapefiles into SQL using Shape2SQL. If you don't already have a geography column on your points table, add it. Do a spatial join using code similar to this.



Top 50 recent answers are included