superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where ACRES = "5.623"
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AGENCY
MNG_AG_TYP 1
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4632 | 4632 | 4631 | {"type": "Polygon", "coordinates": [[[-122.46871, 37.75071], [-122.46863, 37.75066], [-122.46858, 37.7506], [-122.4685, 37.75044], [-122.46845, 37.75026], [-122.46847, 37.74986], [-122.46844, 37.74971], [-122.4684, 37.74959], [-122.4684, 37.74951], [-122.46844, 37.74939], [-122.46856, 37.74928], [-122.46867, 37.74925], [-122.46886, 37.74927], [-122.469, 37.7493], [-122.46927, 37.74943], [-122.46944, 37.74949], [-122.4696, 37.74951], [-122.4699, 37.74951], [-122.47004, 37.74953], [-122.47016, 37.74958], [-122.47025, 37.74964], [-122.47035, 37.74973], [-122.4704, 37.74982], [-122.47044, 37.74994], [-122.47045, 37.75002], [-122.47044, 37.75012], [-122.4704, 37.75021], [-122.47022, 37.75044], [-122.47, 37.7506], [-122.46986, 37.75066], [-122.4697, 37.75069], [-122.46886, 37.75074], [-122.46871, 37.75071]]]} | Open Access 1 | Golden Heights Park | 19362 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 5.623 | Golden Heights Park | ||
5254 | 5254 | 5253 | {"type": "Polygon", "coordinates": [[[-117.01414, 32.61769], [-117.01344, 32.61788], [-117.01304, 32.61797], [-117.01237, 32.61806], [-117.01228, 32.61774], [-117.01213, 32.6177], [-117.01211, 32.6176], [-117.01192, 32.61744], [-117.01175, 32.61716], [-117.01195, 32.6171], [-117.01211, 32.61698], [-117.01287, 32.61676], [-117.01339, 32.61675], [-117.01374, 32.61665], [-117.01414, 32.61769]]]} | Open Access 1 | Horizon Park | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/horizon-park | 20092 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 5.623 | Horizon Park | |
14122 | 14122 | 14121 | {"type": "Polygon", "coordinates": [[[-117.85818, 34.19361], [-117.85655, 34.19631], [-117.85599, 34.19646], [-117.85577, 34.1973], [-117.85578, 34.19593], [-117.85608, 34.19585], [-117.85744, 34.1936], [-117.85818, 34.19361]]]} | No Public Access 3 | Unnamed Site - Pasadena Department of Water and Power | 33667 | 1720 | Pasadena Department of Water and Power 1099 | City 2 | City Agency 2 | https://ww5.cityofpasadena.net/water-and-power/ | City 2 | 5.623 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);