units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
148 rows where MNG_AGENCY = 294
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
11432 | 11432 | 11431 | {"type": "Polygon", "coordinates": [[[-118.19075, 33.79976], [-118.19062, 33.79976], [-118.19062, 33.79951], [-118.19075, 33.79951], [-118.19075, 33.79976]]]} | Open Access 1 | 48115 | Locust Tot Lot | 32630 | 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/locust-tot-lot/ | Los Angeles 6 | 0.085 | Locust Tot Lot | 2016 | Local Recreation Area 3 | 4 |
11444 | 11444 | 11443 | {"type": "Polygon", "coordinates": [[[-118.20162, 33.84535], [-118.20155, 33.84639], [-118.20035, 33.8464], [-118.20034, 33.84535], [-118.20162, 33.84535]]]} | Open Access 1 | 48111 | C. David Molina Park | 32623 | 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 | 3.293 | C. David Molina Park | 0 | Local Park 2 | 4 | |
11512 | 11512 | 11511 | {"type": "Polygon", "coordinates": [[[-118.0907, 33.82486], [-118.09069, 33.82685], [-118.09002, 33.82684], [-118.09001, 33.82754], [-118.08923, 33.8273], [-118.08925, 33.82484], [-118.0907, 33.82486]]]} | No Public Access 3 | 48217 | El Dorado East Regional Park | 32766 | 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 | 8.523 | El Dorado East RP | 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 | |
12241 | 12241 | 12240 | {"type": "Polygon", "coordinates": [[[-118.19767, 33.78476], [-118.19649, 33.78476], [-118.19649, 33.78394], [-118.19754, 33.78395], [-118.19755, 33.78438], [-118.19761, 33.78443], [-118.19767, 33.78443], [-118.19767, 33.78476]]]} | Open Access 1 | 25446 | Seaside Park | 25266 | 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 | 2.299 | Seaside Park | 0 | Local Park 2 | 4 | |
12702 | 12702 | 12701 | {"type": "MultiPolygon", "coordinates": [[[[-118.18623, 33.76612], [-118.18623, 33.76639], [-118.18362, 33.76606], [-118.18363, 33.76601], [-118.18358, 33.76598], [-118.18357, 33.76595], [-118.18361, 33.76583], [-118.18508, 33.76598], [-118.18508, 33.76602], [-118.18623, 33.76612]]], [[[-118.18771, 33.76633], [-118.18769, 33.76657], [-118.18649, 33.76642], [-118.18649, 33.76615], [-118.18771, 33.76633]]], [[[-118.18858, 33.76645], [-118.18857, 33.76669], [-118.18779, 33.76659], [-118.18781, 33.76634], [-118.18858, 33.76645]]], [[[-118.19218, 33.7666], [-118.19218, 33.76692], [-118.19006, 33.76681], [-118.19006, 33.76657], [-118.19103, 33.76655], [-118.19218, 33.7666]]], [[[-118.19486, 33.76683], [-118.19486, 33.76704], [-118.1937, 33.76698], [-118.19369, 33.76701], [-118.19251, 33.76694], [-118.19251, 33.76664], [-118.19323, 33.7667], [-118.19324, 33.76684], [-118.19356, 33.76686], [-118.19357, 33.76678], [-118.1937, 33.76678], [-118.1937, 33.76687], [-118.19418, 33.7669], [-118.19419, 33.7668], [-118.19486, 33.76683]]]]} | Open Access 1 | 29706 | Victory Park | 27089 | 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 | 5.708 | Victory Park | 0 | Local Park 2 | 4 | |
14743 | 14743 | 14742 | {"type": "Polygon", "coordinates": [[[-118.2041, 33.77812], [-118.20413, 33.77876], [-118.20407, 33.77891], [-118.20398, 33.77907], [-118.20386, 33.77925], [-118.20372, 33.7794], [-118.2035, 33.77958], [-118.20334, 33.77968], [-118.20106, 33.78128], [-118.20102, 33.78137], [-118.2007, 33.78153], [-118.20044, 33.7817], [-118.20015, 33.78197], [-118.19976, 33.78248], [-118.19955, 33.78248], [-118.19977, 33.78213], [-118.20005, 33.78181], [-118.20033, 33.78157], [-118.20115, 33.78099], [-118.20119, 33.78077], [-118.20134, 33.7806], [-118.20151, 33.78056], [-118.20132, 33.78016], [-118.20165, 33.78003], [-118.20194, 33.77984], [-118.20211, 33.77969], [-118.20269, 33.7791], [-118.20278, 33.77899], [-118.20298, 33.77911], [-118.20318, 33.77899], [-118.20318, 33.77898], [-118.20309, 33.77895], [-118.20314, 33.77882], [-118.20323, 33.77885], [-118.20344, 33.77871], [-118.20348, 33.77853], [-118.2035, 33.77836], [-118.20347, 33.77806], [-118.20393, 33.778], [-118.20395, 33.77813], [-118.2041, 33.77812]]]} | Open Access 1 | 45117 | Drake/Chavez Soccer Fields and Parkway | 27996 | 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 | 7.964 | Drake/Chavez Soccer Fields and Parkway | 2018 | Local Recreation Area 3 | 4 | |
14942 | 14942 | 14941 | {"type": "Polygon", "coordinates": [[[-118.11811, 33.76285], [-118.11631, 33.76422], [-118.11624, 33.76415], [-118.11618, 33.76418], [-118.11611, 33.76416], [-118.11597, 33.76427], [-118.11571, 33.76358], [-118.11587, 33.76352], [-118.1161, 33.76331], [-118.11638, 33.76318], [-118.11666, 33.76312], [-118.1168, 33.76307], [-118.11682, 33.76311], [-118.11628, 33.7633], [-118.11636, 33.76346], [-118.11659, 33.76339], [-118.11663, 33.76345], [-118.11677, 33.76341], [-118.11675, 33.76333], [-118.11691, 33.76328], [-118.1169, 33.76324], [-118.117, 33.7632], [-118.11694, 33.76308], [-118.11685, 33.76311], [-118.11683, 33.76306], [-118.11754, 33.76277], [-118.11791, 33.76267], [-118.11811, 33.76285]]]} | Open Access 1 | 45541 | Jack Nichol Park | 28370 | 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 | 3.508 | Jack Nichol Park | 2007 | Local Park 2 | 4 | |
15087 | 15087 | 15086 | {"type": "Polygon", "coordinates": [[[-118.18754, 33.76911], [-118.18704, 33.76911], [-118.18704, 33.76904], [-118.18754, 33.76904], [-118.18754, 33.76911]]]} | Open Access 1 | 45886 | East Village Arts Park | 28962 | 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/East-Village-Arts-Park/ | Los Angeles 6 | 0.086 | East Village Arts Park | 0 | Local Park 2 | 4 |
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 | |
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 | |||
15091 | 15091 | 15090 | {"type": "Polygon", "coordinates": [[[-118.20273, 33.82355], [-118.20253, 33.8243], [-118.2024, 33.82419], [-118.20128, 33.82355], [-118.20273, 33.82355]]]} | Open Access 1 | 45874 | Baker Street Park | 28945 | 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 | 1.332 | Baker Street Park | 0 | Local Park 2 | 4 | |
15094 | 15094 | 15093 | {"type": "Polygon", "coordinates": [[[-118.10508, 33.83028], [-118.10508, 33.83056], [-118.10362, 33.83055], [-118.10362, 33.83028], [-118.10508, 33.83028]]]} | Open Access 1 | 45881 | Birdcage Park | 28957 | 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/Birdcage-Park/ | Los Angeles 6 | 1.034 | Birdcage Park | 0 | Local Park 2 | 4 |
15095 | 15095 | 15094 | {"type": "Polygon", "coordinates": [[[-118.17739, 33.77764], [-118.17739, 33.77777], [-118.17643, 33.77777], [-118.17643, 33.77764], [-118.17739, 33.77764]]]} | Open Access 1 | 45882 | Craftsman Village Park | 28959 | 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.craftsmanvillage.org/ | Los Angeles 6 | 0.33 | Craftsman Village Park | 0 | Local Park 2 | 4 |
15096 | 15096 | 15095 | {"type": "MultiPolygon", "coordinates": [[[[-118.09888, 33.79874], [-118.09877, 33.79897], [-118.09852, 33.7992], [-118.09829, 33.79944], [-118.09804, 33.79961], [-118.0977, 33.79975], [-118.09743, 33.7998], [-118.09713, 33.7998], [-118.09686, 33.79988], [-118.09656, 33.80001], [-118.09637, 33.80014], [-118.09597, 33.80071], [-118.09587, 33.80097], [-118.0958, 33.80124], [-118.09568, 33.80195], [-118.09561, 33.80217], [-118.09551, 33.80237], [-118.09538, 33.80256], [-118.09473, 33.80327], [-118.09458, 33.80348], [-118.09451, 33.80361], [-118.09362, 33.80386], [-118.09289, 33.804], [-118.0921, 33.80403], [-118.09141, 33.804], [-118.09101, 33.79591], [-118.09679, 33.79593], [-118.09701, 33.7961], [-118.09718, 33.79627], [-118.09735, 33.79656], [-118.09753, 33.79691], [-118.09762, 33.79721], [-118.09817, 33.79721], [-118.09858, 33.79781], [-118.09869, 33.79802], [-118.09879, 33.7984], [-118.09886, 33.7985], [-118.09888, 33.79874]]], [[[-118.09543, 33.80984], [-118.09439, 33.81005], [-118.09343, 33.81003], [-118.0925, 33.81009], [-118.09177, 33.80986], [-118.0917, 33.80987], [-118.09143, 33.80443], [-118.0916, 33.80443], [-118.09162, 33.80455], [-118.09184, 33.80467], [-118.09209, 33.80476], [-118.09211, 33.8049], [-118.09249, 33.80501], [-118.09295, 33.8052], [-118.09376, 33.80564], [-118.09427, 33.80609], [-118.0948, 33.80682], [-118.09547, 33.8085], [-118.09543, 33.80984]]]]} | Restricted Access 2 | 45888 | El Dorado Park Golf Course | 33114 | 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.eldoradoparkgc.com/ | Los Angeles 6 | 154.986 | El Dorado Park GC | 0 | Local Recreation Area 3 | 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 | |
15098 | 15098 | 15097 | {"type": "Polygon", "coordinates": [[[-118.1915, 33.75965], [-118.19129, 33.75965], [-118.19107, 33.75873], [-118.19099, 33.75844], [-118.19075, 33.75812], [-118.18989, 33.75769], [-118.18933, 33.75744], [-118.18928, 33.75747], [-118.18899, 33.75735], [-118.18895, 33.75728], [-118.18806, 33.75691], [-118.18783, 33.75686], [-118.18752, 33.7568], [-118.18691, 33.75676], [-118.18649, 33.75684], [-118.18604, 33.75696], [-118.18557, 33.75715], [-118.18512, 33.75736], [-118.18436, 33.75765], [-118.18401, 33.75776], [-118.18401, 33.75778], [-118.18416, 33.75802], [-118.18368, 33.75822], [-118.1834, 33.75784], [-118.18597, 33.75681], [-118.18695, 33.75659], [-118.18787, 33.75663], [-118.18835, 33.75679], [-118.18882, 33.75698], [-118.18948, 33.7573], [-118.19059, 33.75777], [-118.19073, 33.75785], [-118.19087, 33.75794], [-118.19107, 33.75815], [-118.1912, 33.7584], [-118.19125, 33.75857], [-118.19126, 33.75874], [-118.1915, 33.75965]]]} | Open Access 1 | 45884 | Downtown Marina Mole | 28961 | 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 | 5.133 | Downtown Marina Mole | None 1311 | |||
15099 | 15099 | 15098 | {"type": "Polygon", "coordinates": [[[-118.09898, 33.80692], [-118.09897, 33.80754], [-118.09893, 33.80755], [-118.09861, 33.80755], [-118.09855, 33.80754], [-118.0985, 33.80752], [-118.09845, 33.80743], [-118.09845, 33.807], [-118.09847, 33.80695], [-118.09853, 33.80691], [-118.0986, 33.8069], [-118.09893, 33.8069], [-118.09898, 33.80692]]]} | Open Access 1 | 45891 | Good Neighbor Park | 28968 | 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/Good-Neighbor-Park/ | Los Angeles 6 | 0.84 | Good Neighbor Park | 0 | Local Park 2 | 4 |
15100 | 15100 | 15099 | {"type": "Polygon", "coordinates": [[[-118.19153, 33.77061], [-118.19153, 33.77074], [-118.19112, 33.77074], [-118.19111, 33.77071], [-118.19104, 33.77071], [-118.19104, 33.77074], [-118.19091, 33.77074], [-118.19091, 33.77061], [-118.19153, 33.77061]]]} | Open Access 1 | 45892 | Harvey Milk Promenade | 28969 | 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.204 | Harvey Milk Promenade | None 1312 |
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]);