units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
37 rows where MNG_AGENCY = 242 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, ACRES, LABEL_NAME, YR_EST, GAP_STS
Link | rowid | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES ▼ | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1995 | 1995 | 1994 | {"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 | 6084 | Sneary Parkette | 25580 | 1270 | Redondo Beach, City of 246 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | Los Angeles 6 | 0.098 | Sneary Parkette | 0 | Local Park 2 | 4 | |
974 | 974 | 973 | {"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 | 6092 | Ford Parkette | 18988 | 1270 | Redondo Beach, City of 246 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | Los Angeles 6 | 0.115 | Ford Parkette | 0 | Local Park 2 | 4 | |
1977 | 1977 | 1976 | {"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 | 6080 | McNeill Parkette | 22065 | 1270 | Redondo Beach, City of 246 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | Los Angeles 6 | 0.115 | McNeill Parkette | 0 | Local Park 2 | 4 | |
6868 | 6868 | 6867 | {"type": "Polygon", "coordinates": [[[-118.38545, 33.86935], [-118.38521, 33.86935], [-118.38521, 33.86898], [-118.38541, 33.86928], [-118.38545, 33.86935]]]} | Open Access 1 | 6091 | Redondo Beach Open Space | 24239 | 1270 | Redondo Beach, City of 246 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | Los Angeles 6 | 0.118 | Redondo Beach OS | 0 | Local Recreation Area 3 | 4 | |
6303 | 6303 | 6302 | {"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 | 5993 | Massena Parkette | 21945 | 1270 | Redondo Beach, City of 246 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | Los Angeles 6 | 0.136 | Massena Parkette | 0 | Local Park 2 | 4 | |
966 | 966 | 965 | {"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 | 6068 | General Eaton #1 Parkette | 19253 | 1270 | Redondo Beach, City of 246 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | Los Angeles 6 | 0.168 | General Eaton #1 Parkette | 0 | Local Park 2 | 4 | |
1973 | 1973 | 1972 | {"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 | 6077 | Townsend Parkette | 26498 | 1270 | Redondo Beach, City of 246 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | Los Angeles 6 | 0.169 | Townsend Parkette | 0 | Local Park 2 | 4 | |
1978 | 1978 | 1977 | {"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 | 6081 | Beverly Parkette | 16058 | 1270 | Redondo Beach, City of 246 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | Los Angeles 6 | 0.169 | Beverly Parkette | 0 | Local Park 2 | 4 | |
1988 | 1988 | 1987 | {"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 | 6083 | Huntington Parkette | 20158 | 1270 | Redondo Beach, City of 246 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | Los Angeles 6 | 0.17 | Huntington Parkette | 0 | Local Park 2 | 4 | |
1971 | 1971 | 1970 | {"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 | 6072 | La Paz Parkette | 20785 | 1270 | Redondo Beach, City of 246 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | Los Angeles 6 | 0.176 | La Paz Parkette | 0 | Local Park 2 | 4 | |
1997 | 1997 | 1996 | {"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 | 6085 | Ensenada Parkette | 18681 | 1270 | Redondo Beach, City of 246 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | Los Angeles 6 | 0.176 | Ensenada Parkette | 0 | Local Park 2 | 4 | |
1987 | 1987 | 1986 | {"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 | 6082 | Mathews Parkette | 21952 | 1270 | Redondo Beach, City of 246 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | Los Angeles 6 | 0.177 | Mathews Parkette | 0 | Local Park 2 | 4 | |
15862 | 15862 | 15861 | {"type": "Polygon", "coordinates": [[[-118.37894, 33.85955], [-118.37878, 33.85955], [-118.37878, 33.85915], [-118.37876, 33.85914], [-118.37876, 33.85884], [-118.37894, 33.85875], [-118.37894, 33.85955]]]} | Open Access 1 | 6071 | Redondo Beach Open Space | 24239 | 1270 | Redondo Beach, City of 246 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | Los Angeles 6 | 0.325 | Redondo Beach OS | 0 | Local Recreation Area 3 | 4 | |
849 | 849 | 848 | {"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 | 6074 | Gregg Parkette | 19500 | 1270 | Redondo Beach, City of 246 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | Los Angeles 6 | 0.343 | Gregg Parkette | 0 | Local Park 2 | 4 | |
7066 | 7066 | 7065 | {"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 | 6069 | General Eaton #2 Parkette | 19254 | 1270 | Redondo Beach, City of 246 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | Los Angeles 6 | 0.347 | General Eaton #2 Parkette | 0 | Local Park 2 | 4 | |
11441 | 11441 | 11440 | {"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 | 48136 | Gateway Parkette | 32663 | 1270 | Redondo Beach, City of 246 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | Los Angeles 6 | 0.421 | Gateway Parkette | 2015 | Local Park 2 | 4 | |
1975 | 1975 | 1974 | {"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 | 6079 | Perry Allison Playfield | 23612 | 1270 | Redondo Beach, City of 246 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | Los Angeles 6 | 0.583 | Perry Allison Playfield | 0 | Local Recreation Area 3 | 4 | |
7063 | 7063 | 7062 | {"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 | 6061 | Vincent Park | 27128 | 1270 | Redondo Beach, City of 246 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | Los Angeles 6 | 0.925 | Vincent Park | 0 | Local Park 2 | 4 | |
3563 | 3563 | 3562 | {"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 | 28354 | Dale Page Park | 17894 | 1270 | Redondo Beach, City of 246 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | Los Angeles 6 | 1.163 | Dale Page Park | 0 | Local Park 2 | 4 | |
1970 | 1970 | 1969 | {"type": "Polygon", "coordinates": [[[-118.38047, 33.86996], [-118.38045, 33.87099], [-118.38003, 33.87098], [-118.38003, 33.87072], [-118.37996, 33.87071], [-118.37997, 33.87005], [-118.38047, 33.86996]]]} | Open Access 1 | 6070 | Andrews Park | 15486 | 1270 | Redondo Beach, City of 246 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | Los Angeles 6 | 1.185 | Andrews Park | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);