superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where LABEL_NAME = "Imperial Park"
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AG_TYP, LABEL_NAME
MNG_AGENCY 3
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
575 | 575 | 574 | {"type": "MultiPolygon", "coordinates": [[[[-118.09212, 34.05593], [-118.09212, 34.05677], [-118.09073, 34.05761], [-118.09073, 34.05676], [-118.09212, 34.05593]]], [[[-118.09348, 34.05514], [-118.09348, 34.05597], [-118.09344, 34.05597], [-118.09227, 34.05668], [-118.09227, 34.05583], [-118.09266, 34.0556], [-118.09267, 34.05556], [-118.09273, 34.05556], [-118.09341, 34.05514], [-118.09348, 34.05514]]]]} | Open Access 1 | Imperial Park | 32676 | 1284 | Rosemead, City of 127 | City 2 | City Agency 2 | http://www.cityofrosemead.org/index.aspx?page=74 | City 2 | 5.588 | Imperial Park | ||
5331 | 5331 | 5330 | {"type": "Polygon", "coordinates": [[[-117.79041, 33.84386], [-117.79042, 33.8439], [-117.79042, 33.844], [-117.79036, 33.84435], [-117.79019, 33.84484], [-117.7899, 33.8448], [-117.78946, 33.84472], [-117.78895, 33.84457], [-117.78843, 33.84461], [-117.7881, 33.84458], [-117.78783, 33.8445], [-117.78762, 33.84446], [-117.78755, 33.84562], [-117.78626, 33.84563], [-117.78627, 33.84548], [-117.78631, 33.84538], [-117.78653, 33.84498], [-117.78658, 33.8448], [-117.78659, 33.84467], [-117.78657, 33.84451], [-117.78645, 33.84425], [-117.78646, 33.84421], [-117.78666, 33.84415], [-117.78687, 33.8441], [-117.7873, 33.84408], [-117.78763, 33.84412], [-117.78765, 33.8441], [-117.78775, 33.84414], [-117.7882, 33.8442], [-117.78851, 33.84421], [-117.78875, 33.8442], [-117.7889, 33.84418], [-117.78998, 33.84393], [-117.79026, 33.84386], [-117.79028, 33.84384], [-117.79035, 33.84383], [-117.79041, 33.84386]]]} | Open Access 1 | Imperial Park | 20180 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 8.219 | Imperial Park | ||
5332 | 5332 | 5331 | {"type": "Polygon", "coordinates": [[[-122.47915, 37.65481], [-122.47904, 37.65494], [-122.47891, 37.65513], [-122.4788, 37.65535], [-122.47874, 37.65553], [-122.4787, 37.65572], [-122.47868, 37.65593], [-122.47873, 37.65638], [-122.47847, 37.6564], [-122.47839, 37.65644], [-122.47835, 37.6565], [-122.47835, 37.65658], [-122.47844, 37.65679], [-122.4785, 37.65723], [-122.47845, 37.65725], [-122.47845, 37.65751], [-122.4784, 37.65751], [-122.47841, 37.65737], [-122.47837, 37.65722], [-122.47829, 37.657], [-122.47819, 37.6568], [-122.47642, 37.65406], [-122.47623, 37.65399], [-122.47603, 37.65407], [-122.47569, 37.65354], [-122.47566, 37.65343], [-122.47544, 37.65311], [-122.47401, 37.65227], [-122.4739, 37.65226], [-122.47331, 37.65141], [-122.47338, 37.65139], [-122.4742, 37.65218], [-122.47431, 37.65227], [-122.47444, 37.65235], [-122.47592, 37.65297], [-122.47624, 37.65306], [-122.47657, 37.65309], [-122.47655, 37.65355], [-122.47718, 37.65405], [-122.47732, 37.65412], [-122.47749, 37.65416], [-122.47765, 37.65418], [-122.47784, 37.65417], [-122.47786, 37.65422], [-122.47819, 37.65419], [-122.47822, 37.6543], [-122.47831, 37.65438], [-122.47835, 37.65456], [-122.47867, 37.65453], [-122.47871, 37.65467], [-122.47887, 37.65465], [-122.47915, 37.65481]]]} | Open Access 1 | Imperial Park | 20181 | 1239 | Pacifica, City of 403 | City 2 | City Agency 2 | http://www.cityofpacifica.org/depts/rec_department/default.asp | City 2 | 12.751 | Imperial 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]);