Feature Overlay

Overlay features from one PostGIS layer onto another PostGIS layer and return the results
Service URL: 
Service Arguments: 
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
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">
	<column name="pid">11111111</column>
	<column name="precno">201</column>


Sample JSON Output



Sample KML Output

    <?xml version="1.0" encoding="utf-8"?>
    <kml xmlns="http://www.opengis.net/kml/2.2">
          <name>Monroe Middle School</name>
            <Data name="name">
              <value>Monroe Middle School</value>