I am using the cb_2013_us_zcta510_500k shapefile to push zipcode polygons. I have the shapefile, and a SQL Server table loaded where the polygon is loaded in the GEOG data type.
What I need is to create a table with adjacent zip codes.
What I need is:
zip_code, Adj_Zip_CodeI have tried:
select Z1.ZCTA5CE10 as SourceZIP, Z2.ZCTA5CE10 as TGTZIPfrom REF_ZIP_GEOG Z1join REF_ZIP_GEOG Z2on Z1.GEOG.STDistance(Z2.GEOG) = 0to no avail. I have also tried STTouches, and apparently I'm told it's a GEOM data function, not a GEOG.
I also have QGIS, but I am remiss on how to perform this action.
Has anyone seen this? I would love a bit of wisdom here.Thanks
أكثر...
What I need is to create a table with adjacent zip codes.
What I need is:
zip_code, Adj_Zip_CodeI have tried:
select Z1.ZCTA5CE10 as SourceZIP, Z2.ZCTA5CE10 as TGTZIPfrom REF_ZIP_GEOG Z1join REF_ZIP_GEOG Z2on Z1.GEOG.STDistance(Z2.GEOG) = 0to no avail. I have also tried STTouches, and apparently I'm told it's a GEOM data function, not a GEOG.
I also have QGIS, but I am remiss on how to perform this action.
Has anyone seen this? I would love a bit of wisdom here.Thanks
أكثر...