superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
33 rows where MNG_AGENCY = 242 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: ACRES
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9745 | 9745 | 9744 | {"type": "Polygon", "coordinates": [[[-118.38198, 33.8634], [-118.38162, 33.86356], [-118.38151, 33.8634], [-118.38168, 33.8634], [-118.38198, 33.8634]]]} | Open Access 1 | Sneary Parkette | 25580 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 0.098 | Sneary Parkette | ||
4305 | 4305 | 4304 | {"type": "Polygon", "coordinates": [[[-118.38535, 33.86841], [-118.38506, 33.86854], [-118.38499, 33.86842], [-118.38527, 33.86828], [-118.38535, 33.86841]]]} | Open Access 1 | Ford Parkette | 18988 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 0.115 | Ford Parkette | ||
5808 | 5808 | 5807 | {"type": "Polygon", "coordinates": [[[-118.3842, 33.86131], [-118.38404, 33.86131], [-118.38403, 33.86103], [-118.38419, 33.86103], [-118.3842, 33.86131]]]} | Open Access 1 | McNeill Parkette | 22065 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 0.115 | McNeill Parkette | ||
14257 | 14257 | 14256 | {"type": "Polygon", "coordinates": [[[-118.37521, 33.81927], [-118.37481, 33.81924], [-118.37482, 33.81911], [-118.37521, 33.81914], [-118.37521, 33.81927]]]} | Open Access 1 | Massena Parkette | 21945 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 0.136 | Massena Parkette | ||
1154 | 1154 | 1153 | {"type": "Polygon", "coordinates": [[[-118.38008, 33.86755], [-118.37992, 33.86755], [-118.37992, 33.86714], [-118.38008, 33.86714], [-118.38008, 33.86755]]]} | Open Access 1 | Beverly Parkette | 16058 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 0.168 | Beverly Parkette | ||
4087 | 4087 | 4086 | {"type": "Polygon", "coordinates": [[[-118.38235, 33.86755], [-118.38219, 33.86754], [-118.38219, 33.86714], [-118.38235, 33.86714], [-118.38235, 33.86755]]]} | Open Access 1 | General Eaton #1 Parkette | 19253 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 0.168 | General Eaton #1 Parkette | ||
10431 | 10431 | 10430 | {"type": "Polygon", "coordinates": [[[-118.3671, 33.86571], [-118.3671, 33.86611], [-118.36694, 33.86612], [-118.36694, 33.8657], [-118.3671, 33.86571]]]} | Open Access 1 | Townsend Parkette | 26498 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 0.168 | Townsend Parkette | ||
5307 | 5307 | 5306 | {"type": "Polygon", "coordinates": [[[-118.37992, 33.86807], [-118.37992, 33.86849], [-118.37975, 33.86849], [-118.37976, 33.86808], [-118.37992, 33.86807]]]} | Open Access 1 | Huntington Parkette | 20158 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 0.17 | Huntington Parkette | ||
4037 | 4037 | 4036 | {"type": "Polygon", "coordinates": [[[-118.38316, 33.85905], [-118.38291, 33.85906], [-118.38291, 33.85878], [-118.38315, 33.85878], [-118.38316, 33.85905]]]} | Open Access 1 | Ensenada Parkette | 18681 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 0.176 | Ensenada Parkette | ||
4726 | 4726 | 4725 | {"type": "Polygon", "coordinates": [[[-118.37763, 33.86101], [-118.37763, 33.86143], [-118.37747, 33.86143], [-118.37746, 33.86101], [-118.37763, 33.86101]]]} | Open Access 1 | La Paz Parkette | 20785 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 0.176 | La Paz Parkette | ||
6758 | 6758 | 6757 | {"type": "Polygon", "coordinates": [[[-118.3775, 33.87385], [-118.3775, 33.87426], [-118.37734, 33.87426], [-118.37733, 33.87385], [-118.3775, 33.87385]]]} | Open Access 1 | Mathews Parkette | 21952 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 0.177 | Mathews Parkette | ||
4710 | 4710 | 4709 | {"type": "Polygon", "coordinates": [[[-118.37797, 33.86434], [-118.37796, 33.86475], [-118.37764, 33.86475], [-118.37763, 33.86434], [-118.37797, 33.86434]]]} | Open Access 1 | Gregg Parkette | 19500 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 0.343 | Gregg Parkette | ||
4219 | 4219 | 4218 | {"type": "Polygon", "coordinates": [[[-118.38219, 33.86754], [-118.38219, 33.86796], [-118.38186, 33.86796], [-118.38186, 33.86755], [-118.38219, 33.86754]]]} | Open Access 1 | General Eaton #2 Parkette | 19254 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 0.347 | General Eaton #2 Parkette | ||
13507 | 13507 | 13506 | {"type": "Polygon", "coordinates": [[[-118.39791, 33.85232], [-118.3975, 33.85245], [-118.39733, 33.85227], [-118.39724, 33.85212], [-118.3973, 33.85209], [-118.39724, 33.85198], [-118.3973, 33.85196], [-118.39735, 33.85207], [-118.39742, 33.85206], [-118.39747, 33.8521], [-118.39767, 33.85213], [-118.3978, 33.85208], [-118.39791, 33.85232]]]} | Open Access 1 | Gateway Parkette | 32663 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 0.422 | Gateway Parkette | 2015 | |
8096 | 8096 | 8095 | {"type": "Polygon", "coordinates": [[[-118.37572, 33.8587], [-118.37493, 33.8587], [-118.37492, 33.85844], [-118.37497, 33.85841], [-118.37568, 33.85841], [-118.37571, 33.85844], [-118.37572, 33.8587]]]} | Open Access 1 | Perry Allison Playfield | 23612 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 0.582 | Perry Allison Playfield | ||
10902 | 10902 | 10901 | {"type": "MultiPolygon", "coordinates": [[[[-118.38413, 33.84424], [-118.3838, 33.84437], [-118.38362, 33.84405], [-118.3836, 33.84397], [-118.38363, 33.8439], [-118.38368, 33.84385], [-118.38376, 33.84383], [-118.38386, 33.84383], [-118.38392, 33.84387], [-118.38397, 33.84393], [-118.38413, 33.84424]]], [[[-118.38438, 33.84494], [-118.38429, 33.84499], [-118.3841, 33.84497], [-118.38404, 33.8449], [-118.38388, 33.84456], [-118.38423, 33.84445], [-118.38441, 33.84478], [-118.38441, 33.84486], [-118.38438, 33.84494]]]]} | Open Access 1 | Vincent Park | 27128 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 0.924 | Vincent Park | ||
3406 | 3406 | 3405 | {"type": "Polygon", "coordinates": [[[-118.36599, 33.88112], [-118.3656, 33.8815], [-118.3656, 33.88015], [-118.36599, 33.88015], [-118.36599, 33.88112]]]} | Open Access 1 | Dale Page Park | 17894 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1.163 | Dale Page Park | ||
1492 | 1492 | 1491 | {"type": "Polygon", "coordinates": [[[-118.38047, 33.86996], [-118.38045, 33.87099], [-118.38003, 33.87098], [-118.38003, 33.87073], [-118.37996, 33.87071], [-118.37997, 33.87005], [-118.38047, 33.86996]]]} | Open Access 1 | Andrews Park | 15486 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1.185 | Andrews Park | ||
4451 | 4451 | 4450 | {"type": "Polygon", "coordinates": [[[-118.3727, 33.86126], [-118.37269, 33.86142], [-118.37262, 33.86173], [-118.3726, 33.86177], [-118.37254, 33.86182], [-118.37209, 33.86205], [-118.37203, 33.86204], [-118.37195, 33.8619], [-118.37193, 33.86179], [-118.37193, 33.86126], [-118.3727, 33.86126]]]} | Open Access 1 | Fulton Playfield | 19148 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1.216 | Fulton Playfield | ||
7185 | 7185 | 7184 | {"type": "Polygon", "coordinates": [[[-118.39965, 33.84813], [-118.39896, 33.84828], [-118.39862, 33.84723], [-118.39869, 33.84718], [-118.39878, 33.84709], [-118.39886, 33.84712], [-118.39892, 33.84715], [-118.39965, 33.84813]]]} | Open Access 1 | Moonstone Park | 22456 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1.46 | Moonstone 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]);