USA-zipcode-boundary

How to get USA zipcode boundaries Link to article

step 1:

download cb_2018_us_zcta510_500k.zip

if you want to keep them in mysql

In your mysql create a db of name :spatialdata

EPSG:4683 this is epsg is for philiphines i should have used USA epsg that is EPSG:2163. Doesn't matter cuz it still worked

run this command

ogr2ogr -f "MySQL" MYSQL:"spatialdata,host=localhost,user=root" -nln "map" -a_srs "EPSG:4683" cb_2018_us_zcta510_500k.shp -overwrite -addfields -fieldTypeToString All -lco ENGINE=MyISAM

ogr2ogr is a tool

i uploaded the file on github USAspatialdata.zip

In your "spatialdata db" there will be 2 table named map & geometry_columns .

In 'map' there will be a column named "shape". shape column is of type "geometry" and it contains polygon/multipolygon files
In 'geometry_columns' there will will be srid(in my case it was 4683) defined

how to check if point falls in the polygon

SELECT * FROM map WHERE ST_Contains( map.SHAPE, ST_GeomFromText( 'POINT(63.39550 -148.89730 )', 4683 ) )

and want to show boundary on a map

select `zcta5ce10` as `zipcode`, ST_AsGeoJSON(`SHAPE`) sh from `map` where ST_Contains( map.SHAPE, ST_GeomFromText( 'POINT(34.1116 -85.6092 )', 4683 ) )`

"ST_AsGeoJSON" this returns spatial data as geojson. Use http://geojson.tools/

if you want to generate topojson

mapshaper converts shapefile to topojson (no need to convert it to kml file)

npx -p mapshaper mapshaper-xl cb_2018_us_zcta510_500k.shp snap -simplify 0.1% -filter-fields ZCTA5CE10 -rename-fields zip=ZCTA5CE10 -o format=topojson cb_2018_us_zcta510_500k.json

If you want to convert shapefile to kml

ogr2ogr -f KML tl_2019_us_zcta510.kml -mapFieldType Integer64=Real tl_2019_us_zcta510.shp

I have used mapbox gl to display 2 zipcodes

example: Map I made

example 2 with states,counties,zipcode (credits to this map : Darssh) he used api ,uploaded the data in mapbox and then fetched it

example 3 Using turf js to check if coordinates fall in geofence

Converted turf.js to php function

you'll find code here :https://github.com/sahilkashyap64/USA-zipcode-boundary

If there are more ways(opensource) to do this kindly share them