How I get esri gdb data ready for Leaflet maps
In my case, data source of truth lives in an ArcSDE geodatabase on PostgreSQL using EPSG:2229 projection
- export from ArcCatalog to shapefile ... I filtered by utility type and left out the abandoned line info
- a typical ogr2ogr command looked like this
ogr2ogr -f GeoJSON -t_srs EPSG:4326 ut_watr_node.geojson UT_watr_act_node.shp
- then from geojson to topojson to reduce size and cleanup some unnecessary attributes
topojson -o ut_watr_link.topojson -p util_type,size,material,lat_main ut_watr_link.geojson
topojson -o ut_watr_node.topojson -p util_type,yr_insta,node_type,size ut_watr_node.geojson