Get_Tract

Get_Tract
Prev	13.1. Tiger Geocoder	Next

Name

Get_Tract — Returns census tract or field from tract table of where the geometry is located. Default to returning short name of tract.

text get_tract ( geometry loc_geom , text output_field=name ) ;

Given a geometry will return the census tract location of that geometry. NAD 83 long lat is assumed if no spatial ref sys is specified.

Availability: 2.0.0

SELECT get_tract(ST_Point(-71.101375, 42.31376) ) As tract_name;
tract_name
---------
1203.01

--this one returns the tiger geoid
SELECT get_tract(ST_Point(-71.101375, 42.31376), 'tract_id' ) As tract_id;
tract_id
---------
25025120301

Prev	Up	Next
Get_Geocode_Setting	Home	Install_Missing_Indexes