units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
29 rows where DES_TP = 2 and MNG_AGENCY = 242 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, ACRES, LABEL_NAME, YR_EST
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency 29
MNG_AGENCY 1
- Redondo Beach, City of · 29 ✖
DES_TP 1
- Local Park · 29 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13285 | 13285 | 13284 | {"type": "Polygon", "coordinates": [[[-118.3602, 33.86163], [-118.35988, 33.86163], [-118.35987, 33.86189], [-118.359, 33.86189], [-118.359, 33.8606], [-118.3602, 33.8606], [-118.3602, 33.86163]]]} | Open Access 1 | 44082 | Franklin Park | 19065 | 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 | 3.734 | Franklin Park | 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 | |
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 | |
7065 | 7065 | 7064 | {"type": "Polygon", "coordinates": [[[-118.37876, 33.85826], [-118.37549, 33.85827], [-118.37533, 33.85747], [-118.37817, 33.85819], [-118.37871, 33.85802], [-118.37876, 33.85826]]]} | Open Access 1 | 6063 | Dominguez Park | 18197 | 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 | 3.188 | Dominguez Park | 0 | Local Park 2 | 4 | |
7064 | 7064 | 7063 | {"type": "Polygon", "coordinates": [[[-118.37871, 33.85802], [-118.37817, 33.85819], [-118.37533, 33.85747], [-118.37531, 33.85739], [-118.37483, 33.85727], [-118.37483, 33.85698], [-118.3749, 33.85669], [-118.37504, 33.85641], [-118.37523, 33.85615], [-118.37538, 33.85602], [-118.37564, 33.85587], [-118.37587, 33.85577], [-118.37813, 33.85513], [-118.37871, 33.85802]]]} | Open Access 1 | 6062 | Dominguez Park | 18197 | 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 | 19.662 | Dominguez Park | 0 | Local Park 2 | 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 | |
7062 | 7062 | 7061 | {"type": "Polygon", "coordinates": [[[-118.39221, 33.84318], [-118.39195, 33.84326], [-118.39175, 33.84296], [-118.39143, 33.84308], [-118.39148, 33.84336], [-118.39129, 33.84302], [-118.39096, 33.84321], [-118.39075, 33.84337], [-118.39058, 33.84352], [-118.39056, 33.8436], [-118.39061, 33.84369], [-118.39061, 33.84375], [-118.39059, 33.8438], [-118.39043, 33.84398], [-118.39023, 33.84413], [-118.38996, 33.84388], [-118.38956, 33.84345], [-118.38975, 33.84342], [-118.39001, 33.84333], [-118.3903, 33.8432], [-118.39059, 33.84304], [-118.39088, 33.8428], [-118.39107, 33.84259], [-118.39119, 33.84237], [-118.39121, 33.84231], [-118.39121, 33.84223], [-118.39135, 33.84218], [-118.39163, 33.84271], [-118.39191, 33.84262], [-118.39193, 33.84266], [-118.39197, 33.84265], [-118.39221, 33.84318]]]} | Open Access 1 | 6060 | Czuleger Park | 17888 | 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 | 3.659 | Czuleger Park | 0 | Local Park 2 | 4 | |
7060 | 7060 | 7059 | {"type": "Polygon", "coordinates": [[[-118.39016, 33.83762], [-118.3901, 33.83809], [-118.39011, 33.83828], [-118.38943, 33.8384], [-118.38927, 33.83835], [-118.38905, 33.83822], [-118.38874, 33.8381], [-118.38848, 33.83805], [-118.38825, 33.83803], [-118.3882, 33.83799], [-118.3882, 33.83797], [-118.38822, 33.83796], [-118.38818, 33.83755], [-118.38853, 33.83753], [-118.38853, 33.83748], [-118.38861, 33.83736], [-118.38858, 33.83687], [-118.38873, 33.83674], [-118.38844, 33.83659], [-118.38857, 33.83643], [-118.38878, 33.83623], [-118.38948, 33.83623], [-118.38949, 33.83646], [-118.38952, 33.83644], [-118.38956, 33.83627], [-118.38974, 33.83628], [-118.38984, 33.83639], [-118.38996, 33.83657], [-118.39003, 33.83675], [-118.39016, 33.83762]], [[-118.3886, 33.8377], [-118.38858, 33.83767], [-118.3883, 33.83774], [-118.38837, 33.8379], [-118.38843, 33.83798], [-118.38868, 33.83786], [-118.3886, 33.8377]]]} | Open Access 1 | 6058 | Veterans Park | 27048 | 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 | 7.833 | Veterans Park | 0 | Local Park 2 | 4 | |
7057 | 7057 | 7056 | {"type": "Polygon", "coordinates": [[[-118.38032, 33.83008], [-118.38014, 33.83049], [-118.38004, 33.83074], [-118.37953, 33.83259], [-118.37946, 33.83264], [-118.37939, 33.83263], [-118.37864, 33.83203], [-118.37849, 33.83189], [-118.37858, 33.83155], [-118.37918, 33.82935], [-118.3792, 33.82933], [-118.37923, 33.82933], [-118.37961, 33.82944], [-118.37995, 33.82962], [-118.38006, 33.8297], [-118.37989, 33.82988], [-118.37983, 33.82998], [-118.38032, 33.83008]]]} | Restricted Access 2 | 6052 | Alta Vista Park | 31602 | 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 | http://www.redondo.org/depts/public_works/parks/altavista.asp | Los Angeles 6 | 8.546 | Alta Vista Park | 0 | Local Park 2 | 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 | |
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 | |
2021 | 2021 | 2020 | {"type": "Polygon", "coordinates": [[[-118.37269, 33.88366], [-118.37002, 33.88368], [-118.37002, 33.88279], [-118.37268, 33.88279], [-118.37268, 33.88285], [-118.37269, 33.88366]]]} | Open Access 1 | 6086 | Anderson Park | 15477 | 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 | 5.94 | Anderson Park | 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
1974 | 1974 | 1973 | {"type": "Polygon", "coordinates": [[[-118.37053, 33.86995], [-118.36856, 33.86996], [-118.36856, 33.86914], [-118.37053, 33.86913], [-118.37053, 33.86995]]]} | Open Access 1 | 6078 | Perry Park | 23614 | 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 | 4.107 | Perry Park | 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 |
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]);