units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
148 rows where MNG_AGENCY = 294 sorted by ACRES
This data as json, copyable, CSV (advanced)
DES_TP 19
- Local Park 86
- Local Recreation Area 22
- Local Historic or Cultural Area 3
- Local Conservation Area 2
- Local Other or Unknown 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
AGNCY_TYP 4 ✖
- City Agency 124
- County Agency 2
- Flood District 1
- Utility 1
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency 128
MNG_AGENCY 1
- Long Beach, City of · 128 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5166 | 5166 | 5165 | {"type": "Polygon", "coordinates": [[[-118.07283, 33.81486], [-118.07254, 33.81515], [-118.07246, 33.81527], [-118.07239, 33.81542], [-118.07195, 33.8153], [-118.07283, 33.81486]]]} | Open Access 1 | 6690 | Lilly Park | 21238 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.332 | Lilly Park | 0 | Local Park 2 | 4 | |
15388 | 15388 | 15387 | {"type": "Polygon", "coordinates": [[[-118.1174, 33.75277], [-118.11739, 33.75279], [-118.11726, 33.75277], [-118.11703, 33.7527], [-118.11686, 33.75264], [-118.11541, 33.75191], [-118.11518, 33.75192], [-118.11462, 33.75214], [-118.11459, 33.75211], [-118.11517, 33.75188], [-118.11542, 33.75187], [-118.11678, 33.75255], [-118.11739, 33.75274], [-118.1174, 33.75277]]]} | Open Access 1 | 46607 | Corso di Oro Parkway | 29916 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.34 | Corso di Oro Parkway | 0 | Local Recreation Area 3 | 4 | |
15118 | 15118 | 15117 | {"type": "MultiPolygon", "coordinates": [[[[-118.17635, 33.78748], [-118.17633, 33.78757], [-118.17628, 33.78756], [-118.17628, 33.78748], [-118.17635, 33.78748]]], [[[-118.17644, 33.78717], [-118.17637, 33.78741], [-118.17628, 33.78741], [-118.17628, 33.78713], [-118.17644, 33.78717]]], [[[-118.17668, 33.78631], [-118.17646, 33.78703], [-118.17643, 33.78703], [-118.17643, 33.78631], [-118.17668, 33.78631]]]]} | Open Access 1 | 45925 | Rosa Parks Park | 29001 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/park-and-facilities/directory/rosa-parks-park/ | Los Angeles 6 | 0.348 | Rosa Parks Park | 0 | Local Park 2 | 4 |
7354 | 7354 | 7353 | {"type": "MultiPolygon", "coordinates": [[[[-118.18761, 33.80427], [-118.18745, 33.80427], [-118.18686, 33.80389], [-118.18692, 33.80382], [-118.18716, 33.80389], [-118.1873, 33.80394], [-118.18759, 33.80413], [-118.18761, 33.80416], [-118.18761, 33.80427]]], [[[-118.18785, 33.80426], [-118.18769, 33.80427], [-118.18769, 33.80415], [-118.18769, 33.80415], [-118.18785, 33.80426]]]]} | Open Access 1 | 6679 | Fellowship Park | 18869 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.365 | Fellowship Park | 0 | Local Park 2 | 4 | |
7328 | 7328 | 7327 | {"type": "Polygon", "coordinates": [[[-118.12344, 33.75467], [-118.1234, 33.75459], [-118.1234, 33.75451], [-118.12344, 33.75443], [-118.12352, 33.75438], [-118.12362, 33.75435], [-118.12371, 33.75437], [-118.1238, 33.75441], [-118.12385, 33.75448], [-118.12387, 33.75455], [-118.12385, 33.75462], [-118.12381, 33.75468], [-118.12374, 33.75473], [-118.12367, 33.75475], [-118.12358, 33.75475], [-118.1235, 33.75472], [-118.12344, 33.75467]]]} | Open Access 1 | 6654 | La Bella Fontana Di Napoli | 20741 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.369 | La Bella Fontana Di Napoli | None 605 | |||
7325 | 7325 | 7324 | {"type": "Polygon", "coordinates": [[[-118.18561, 33.78421], [-118.18515, 33.78421], [-118.18515, 33.78386], [-118.18561, 33.78387], [-118.18561, 33.78421]]]} | Open Access 1 | 6636 | Peace Park | 23539 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.401 | Peace Park | 0 | Local Park 2 | 4 | |
7330 | 7330 | 7329 | {"type": "MultiPolygon", "coordinates": [[[[-118.1632, 33.76891], [-118.16311, 33.76896], [-118.16311, 33.76887], [-118.16315, 33.76889], [-118.1632, 33.76891]]], [[[-118.16334, 33.77076], [-118.16323, 33.77082], [-118.16314, 33.7709], [-118.16315, 33.77079], [-118.16313, 33.77068], [-118.16334, 33.77076]]], [[[-118.16428, 33.76891], [-118.16414, 33.769], [-118.16403, 33.76911], [-118.16392, 33.769], [-118.16378, 33.76891], [-118.16392, 33.76882], [-118.16403, 33.76871], [-118.16414, 33.76882], [-118.16428, 33.76891]]], [[[-118.16441, 33.77044], [-118.16441, 33.77044], [-118.16398, 33.77055], [-118.16404, 33.77047], [-118.16408, 33.77039], [-118.1641, 33.7703], [-118.1641, 33.7702], [-118.16423, 33.77032], [-118.16441, 33.77044]]]]} | Open Access 1 | 6643 | Carroll Parks | 16919 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.426 | Carroll Parks | None 606 | |||
15089 | 15089 | 15088 | {"type": "Polygon", "coordinates": [[[-118.19096, 33.844], [-118.1907, 33.84409], [-118.19069, 33.84339], [-118.19096, 33.84339], [-118.19096, 33.844]]]} | Open Access 1 | 45871 | Arbor Street Park | 28932 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.43 | Arbor Street Park | 0 | Local Park 2 | 4 | |
4500 | 4500 | 4499 | {"type": "Polygon", "coordinates": [[[-118.14894, 33.76065], [-118.14889, 33.76086], [-118.14849, 33.76069], [-118.14818, 33.7606], [-118.14798, 33.76055], [-118.14796, 33.76053], [-118.14796, 33.76047], [-118.14799, 33.76044], [-118.14804, 33.76043], [-118.14818, 33.76043], [-118.14894, 33.76065]]]} | Open Access 1 | 6605 | Unknown park - Long Beach, City of | 29921 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.432 | 0 | Local Other or Unknown 14 | 4 | ||
10797 | 10797 | 10796 | {"type": "Polygon", "coordinates": [[[-118.1182, 33.75324], [-118.11816, 33.75325], [-118.11796, 33.75306], [-118.11778, 33.75291], [-118.11766, 33.75284], [-118.11739, 33.75275], [-118.11803, 33.75272], [-118.11813, 33.75268], [-118.11813, 33.75273], [-118.11819, 33.75279], [-118.1182, 33.75293], [-118.1182, 33.75324]]]} | Open Access 1 | 20229 | Overlook Park (Naples Plaza) | 23275 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.466 | Overlook Park (Naples Plaza) | None 943 | |||
15107 | 15107 | 15106 | {"type": "Polygon", "coordinates": [[[-118.11478, 33.75315], [-118.11414, 33.75364], [-118.11355, 33.7531], [-118.11356, 33.7529], [-118.11459, 33.75211], [-118.11469, 33.75221], [-118.11463, 33.75219], [-118.11458, 33.75219], [-118.11362, 33.75292], [-118.11361, 33.75308], [-118.11414, 33.75356], [-118.11474, 33.75311], [-118.11478, 33.75315]]]} | Open Access 1 | 45907 | Lookout Park | 28983 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.467 | Lookout Park | 0 | Local Park 2 | 4 | |
15114 | 15114 | 15113 | {"type": "Polygon", "coordinates": [[[-118.19095, 33.76861], [-118.19046, 33.7686], [-118.19046, 33.76819], [-118.19095, 33.76819], [-118.19095, 33.76861]]]} | Open Access 1 | 45919 | Promenade Square | 28993 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.516 | Promenade Square | 0 | Local Park 2 | 4 | |
11515 | 11515 | 11514 | {"type": "Polygon", "coordinates": [[[-118.17797, 33.79308], [-118.17745, 33.79307], [-118.17745, 33.79266], [-118.17796, 33.79266], [-118.17797, 33.79275], [-118.17797, 33.79308]]]} | Restricted Access 2 | 48221 | Martin Luther King Jr. Park | 32772 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.547 | Martin Luther King Jr. Park | 0 | Local Park 2 | 4 | |
7332 | 7332 | 7331 | {"type": "Polygon", "coordinates": [[[-118.15701, 33.77703], [-118.15704, 33.77713], [-118.15703, 33.77723], [-118.15697, 33.77732], [-118.15687, 33.77738], [-118.15675, 33.7774], [-118.15663, 33.77737], [-118.15653, 33.77731], [-118.15647, 33.77722], [-118.15646, 33.77713], [-118.15649, 33.77705], [-118.15655, 33.77698], [-118.15664, 33.77693], [-118.15674, 33.77691], [-118.15685, 33.77692], [-118.15694, 33.77696], [-118.15701, 33.77703]]]} | Open Access 1 | 6646 | Rose Park | 24612 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.559 | Rose Park | 0 | Local Park 2 | 4 | |
15398 | 15398 | 15397 | {"type": "Polygon", "coordinates": [[[-118.13217, 33.7536], [-118.13193, 33.75398], [-118.13149, 33.75376], [-118.13174, 33.75337], [-118.13217, 33.7536]]]} | Open Access 1 | 46614 | Bayshore Park | 29912 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.568 | Bayshore Park | 1934 | Local Park 2 | 4 | |
15097 | 15097 | 15096 | {"type": "Polygon", "coordinates": [[[-118.20433, 33.79158], [-118.20409, 33.79158], [-118.20409, 33.79103], [-118.20419, 33.79102], [-118.20419, 33.7909], [-118.2041, 33.79089], [-118.2041, 33.79048], [-118.20433, 33.79048], [-118.20433, 33.79158]]]} | Open Access 1 | 45883 | Cressa Park | 28960 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.615 | Cressa Park | 0 | Local Park 2 | 4 | |
7343 | 7343 | 7342 | {"type": "Polygon", "coordinates": [[[-118.13132, 33.78375], [-118.13112, 33.78358], [-118.13112, 33.78353], [-118.13131, 33.78342], [-118.13151, 33.78334], [-118.13174, 33.78331], [-118.13181, 33.78335], [-118.13182, 33.7834], [-118.1318, 33.78348], [-118.13176, 33.78363], [-118.1317, 33.78373], [-118.13156, 33.7839], [-118.1315, 33.7839], [-118.13132, 33.78375]]]} | Open Access 1 | 6662 | Los Altos Plaza Park | 21475 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.638 | Los Altos Plaza Park | 0 | Local Park 2 | 4 | |
15399 | 15399 | 15398 | {"type": "Polygon", "coordinates": [[[-118.18285, 33.87975], [-118.18285, 33.88002], [-118.18185, 33.88002], [-118.18185, 33.87975], [-118.18285, 33.87975]]]} | Open Access 1 | 46616 | North Community Gardens | 29930 | 6073 | Southern California Edison 655 | Private 7 | Utility 21 | https://www.sce.com | Private 14 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.68 | North Community Gardens | 0 | Local Park 2 | 4 | |
7333 | 7333 | 7332 | {"type": "MultiPolygon", "coordinates": [[[[-118.12869, 33.78809], [-118.12813, 33.78802], [-118.12762, 33.788], [-118.12762, 33.78783], [-118.12856, 33.78792], [-118.12866, 33.78798], [-118.12869, 33.78809]]], [[[-118.12949, 33.78801], [-118.12946, 33.78827], [-118.12881, 33.78811], [-118.12876, 33.78794], [-118.12949, 33.78801]]]]} | Open Access 1 | 6664 | Bouton Creek Park | 16303 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.77 | Bouton Creek Park | 0 | Local Park 2 | 4 | |
15090 | 15090 | 15089 | {"type": "Polygon", "coordinates": [[[-118.1524, 33.78869], [-118.15241, 33.78971], [-118.1524, 33.78972], [-118.15195, 33.78972], [-118.15193, 33.78965], [-118.15193, 33.78958], [-118.15201, 33.78931], [-118.15211, 33.78912], [-118.15227, 33.7889], [-118.1524, 33.78869]]]} | Open Access 1 | 45872 | Plaza Zaferia | 28943 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.788 | Plaza Zaferia | None 1310 |
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]);