Feature Overlay

Description: 
Overlay features from one PostGIS layer onto another PostGIS layer and return the results
Service URL: 
http://gis.drcog.org/REST/v1/ws_geo_featureoverlay.php?
Service Arguments: 
PARAMETER DESCRIPTION
from_geotable The geotable that has the feature(s) to overlay. Example: If you want
to overlay a parcel on another layer, you would set tax_parcels as the
from_geotable.
to_geotable The geotable that has the features you want selected by the selected
feature(s) of the from_geotable.
fields Comma delimited list of fields to be returned. Fields from the to_geotable
should be given the prefix 't', like t.precno, while fields from the
from_geotable should have a prefix of 'f', like f.pid.
parameters SQL where parameters. Parameters for the from_table
must have a 'f' prefix, and parameters for the to_table must have a 't'
prefix. Example: f.pid = '11111111'.
format Format for the output. Value is either 'xml' for xml output, 'kml' for kml output, or
'json' for JSON output.
Service Output: 

Service output is entirely dependant upon the fields parameter.

Sample Output: 

Sample XML Output


	<rows total-rows="1">
	<row>
	<column name="pid">11111111</column>
	<column name="precno">201</column>
	</row>
	</rows>

        

Sample JSON Output

      
	{"total_rows":"1","rows":[{"row":{"pid":"11111111","precno":"201"}}]}

       

Sample KML Output


    <?xml version="1.0" encoding="utf-8"?>
    <kml xmlns="http://www.opengis.net/kml/2.2">
      <Document>
        <Placemark>
          <name>Monroe Middle School</name>
          <Point>
            <coordinates>-80.538976082676783,34.973003351596738</coordinates>
          </Point>
          <ExtendedData>
            <Data name="name">
              <value>Monroe Middle School</value>
            </Data>
          </ExtendedData>
        </Placemark>
      </Document>
    </kml>