superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where ACRES = "4.181"
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AGENCY
MNG_AG_TYP 2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3685 | 3685 | 3684 | {"type": "Polygon", "coordinates": [[[-118.48061, 34.03614], [-118.47995, 34.03667], [-118.47845, 34.03539], [-118.47912, 34.03486], [-118.48061, 34.03614]]]} | Open Access 1 | Douglas Park | 18246 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 4.181 | Douglas Park | ||
7002 | 7002 | 7001 | {"type": "Polygon", "coordinates": [[[-121.58063, 37.01244], [-121.57971, 37.01271], [-121.57897, 37.01108], [-121.5799, 37.0108], [-121.58063, 37.01244]]]} | Open Access 1 | Miller Park | 22243 | 1118 | Gilroy, City of 401 | City 2 | City Agency 2 | http://www.cityofgilroy.org/cityofgilroy/community/parks/default.aspx | City 2 | 4.181 | Miller Park | ||
9234 | 9234 | 9233 | {"type": "Polygon", "coordinates": [[[-117.81912, 33.68019], [-117.81907, 33.68027], [-117.8185, 33.68063], [-117.81825, 33.68088], [-117.81797, 33.68124], [-117.81784, 33.68148], [-117.81769, 33.68187], [-117.81763, 33.68217], [-117.81752, 33.68216], [-117.8176, 33.68182], [-117.81769, 33.68157], [-117.81785, 33.68125], [-117.81811, 33.68089], [-117.81718, 33.68001], [-117.81756, 33.67973], [-117.81773, 33.67964], [-117.81796, 33.67958], [-117.81821, 33.67958], [-117.81834, 33.67959], [-117.8185, 33.67963], [-117.81864, 33.67971], [-117.81877, 33.67979], [-117.81912, 33.68019]]]} | Restricted Access 2 | San Paulo Park | 24970 | 6032 | Westpark Maintenance District 863 | Private 7 | Home Owners Association 15 | http://www.westparkmd.com/ | Private 14 | 4.181 | San Paulo Park |
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]);