{"version":"1.0","type":"rich","title":"Downloads a double-zipped shapefile from NYC Socrata, separates it, and uploads to CartoDB","description":"This shell script downloads a double-zipped shapefile of New York City building data from the Socrata open-data API, unpacks it, and uploads the two resulting shapefiles to CartoDB as separate map layers. It uses `curl` for all HTTP requests, `unzip` and `zip` for archive manipulation, and the CartoDB SQL and Import APIs to drop existing tables, submit each zipped shapefile, and poll job status until import completion. The script handles platform-specific `sed` syntax for Darwin and Linux.","provider_name":"VizHub AI Studio","provider_url":"https://next.vizhub.com","html":"<iframe src=\"https://next.vizhub.com/viz/gist-da97eedfd6428d2ef5f1?mode=embed\" width=\"960\" height=\"500\" scrolling=\"no\" frameborder=\"1\"></iframe>","width":960,"height":500,"cache_age":3600}