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.
This function uses the census If you have not loaded your state data yet and want these additional tables loaded, do the following UPDATE tiger.loader_lookuptables SET load = true WHERE load = false AND lookup_name IN('tract', 'bg', 'tabblock'); then they will be included by the Loader_Generate_Script. |
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