Skip to content

Instantly share code, notes, and snippets.

@dshook

dshook/zipcode_geojson.sql

Created September 24, 2014 03:35
Show Gist options
  • Save dshook/fe2593623666c1759457 to your computer and use it in GitHub Desktop.
Save dshook/fe2593623666c1759457 to your computer and use it in GitHub Desktop.
Download ZIP
zipcode geojson table
Raw
zipcode_geojson.sql
CREATE TABLE dbo.zipcode_geojson
(
zip NVARCHAR (5) NOT NULL
, geoJSON VARCHAR (max) NOT NULL
, latitude DECIMAL (18, 10) NOT NULL
, longitude DECIMAL (18, 10) NOT NULL
, point GEOGRAPHY NULL
, CONSTRAINT PK_zipcode_geojson PRIMARY KEY (zip)
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment