superunits_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)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6174 | 6174 | 6173 | {"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 | Lilly Park | 21238 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.332 | Lilly Park | ||
12742 | 12742 | 12741 | {"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 | Corso di Oro Parkway | 29916 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.341 | Corso di Oro Parkway | ||
12078 | 12078 | 12077 | {"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.17667, 33.78631], [-118.17646, 33.78703], [-118.17643, 33.78703], [-118.17643, 33.78631], [-118.17667, 33.78631]]]]} | Open Access 1 | Rosa Parks Park | http://www.longbeach.gov/park/park-and-facilities/directory/rosa-parks-park/ | 29001 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.348 | Rosa Parks Park | |
4202 | 4202 | 4201 | {"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 | Fellowship Park | 18869 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.365 | Fellowship Park | ||
5794 | 5794 | 5793 | {"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 | La Bella Fontana Di Napoli | 20741 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.369 | La Bella Fontana Di Napoli | ||
6811 | 6811 | 6810 | {"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 | Peace Park | 23539 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.401 | Peace Park | ||
2664 | 2664 | 2663 | {"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 | Carroll Parks | 16919 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.426 | Carroll Parks | ||
14318 | 14318 | 14317 | {"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 | Arbor Street Park | 28932 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.43 | Arbor Street Park | ||
14333 | 14333 | 14332 | {"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.14803, 33.76043], [-118.14818, 33.76043], [-118.14894, 33.76065]]]} | Open Access 1 | Unknown park - Long Beach, City of | 29921 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.432 | |||
7822 | 7822 | 7821 | {"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 | Overlook Park (Naples Plaza) | 23275 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.466 | Overlook Park (Naples Plaza) | ||
12065 | 12065 | 12064 | {"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.11457, 33.7522], [-118.11362, 33.75292], [-118.11361, 33.75307], [-118.11414, 33.75356], [-118.11474, 33.75311], [-118.11478, 33.75315]]]} | Open Access 1 | Lookout Park | 28983 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.474 | Lookout Park | ||
12070 | 12070 | 12069 | {"type": "Polygon", "coordinates": [[[-118.19095, 33.7686], [-118.19046, 33.7686], [-118.19046, 33.76819], [-118.19095, 33.76819], [-118.19095, 33.7686]]]} | Open Access 1 | Promenade Square | 28993 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.516 | Promenade Square | ||
13566 | 13566 | 13565 | {"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 | Martin Luther King Jr. Park | 32772 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.547 | Martin Luther King Jr. Park | ||
8942 | 8942 | 8941 | {"type": "Polygon", "coordinates": [[[-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], [-118.15704, 33.77713]]]} | Open Access 1 | Rose Park | 24612 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.559 | Rose Park | ||
12734 | 12734 | 12733 | {"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 | Bayshore Park | 29912 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.568 | Bayshore Park | 1934 | |
12050 | 12050 | 12049 | {"type": "Polygon", "coordinates": [[[-118.20433, 33.79158], [-118.20409, 33.79158], [-118.20409, 33.79103], [-118.20419, 33.79101], [-118.20418, 33.7909], [-118.2041, 33.79089], [-118.2041, 33.79048], [-118.20433, 33.79048], [-118.20433, 33.79158]]]} | Open Access 1 | Cressa Park | 28960 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.616 | Cressa Park | ||
5317 | 5317 | 5316 | {"type": "Polygon", "coordinates": [[[-118.1318, 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.13112, 33.78358], [-118.13112, 33.78353], [-118.13131, 33.78342], [-118.1315, 33.78334], [-118.13174, 33.78331], [-118.1318, 33.78335]]]} | Open Access 1 | Los Altos Plaza Park | 21475 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.637 | Los Altos Plaza Park | ||
12736 | 12736 | 12735 | {"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 | North Community Gardens | 29930 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.68 | North Community Gardens | ||
2173 | 2173 | 2172 | {"type": "MultiPolygon", "coordinates": [[[[-118.12869, 33.78809], [-118.12814, 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 | Bouton Creek Park | 16303 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.769 | Bouton Creek Park | ||
12053 | 12053 | 12052 | {"type": "Polygon", "coordinates": [[[-118.15241, 33.78971], [-118.1524, 33.78972], [-118.15195, 33.78972], [-118.15193, 33.78964], [-118.15193, 33.78958], [-118.15201, 33.7893], [-118.15211, 33.78912], [-118.15227, 33.7889], [-118.1524, 33.78869], [-118.15241, 33.78971]]]} | Open Access 1 | Plaza Zaferia | 28943 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.788 | Plaza Zaferia |
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]);