units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
135 rows where ACCESS_TYP = 1 and MNG_AGENCY = 294 sorted by rowid descending
This data as json, copyable, CSV (advanced)
DES_TP 16
- Local Park 88
- Local Recreation Area 11
- Local Conservation Area 2
- Local Historic or Cultural 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
MNG_AG_TYP 1
- City Agency 115
MNG_AGENCY 1
- Long Beach, City of · 115 ✖
ACCESS_TYP 1
- Open Access · 115 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15119 | 15119 | 15118 | {"type": "Polygon", "coordinates": [[[-118.13488, 33.82336], [-118.13487, 33.82495], [-118.13413, 33.82494], [-118.13407, 33.82489], [-118.13408, 33.82335], [-118.13488, 33.82336]]]} | Open Access 1 | 45926 | Rosie the Riveter Park | 29002 | 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/rosie-the-riveter-park/ | Los Angeles 6 | 3.243 | Rosie the Riveter Park | 0 | Local Park 2 | 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 |
15117 | 15117 | 15116 | {"type": "Polygon", "coordinates": [[[-118.18086, 33.77419], [-118.18085, 33.77523], [-118.18052, 33.77524], [-118.18052, 33.77509], [-118.18039, 33.77509], [-118.18051, 33.77465], [-118.18065, 33.77429], [-118.18076, 33.7742], [-118.18086, 33.77419]]]} | Open Access 1 | 45924 | Gumbiner Park | 32574 | 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/gumbiner-park/ | Los Angeles 6 | 0.856 | Gumbiner Park | 0 | Local Park 2 | 4 |
15115 | 15115 | 15114 | {"type": "Polygon", "coordinates": [[[-118.19242, 33.76315], [-118.19221, 33.7635], [-118.19212, 33.76343], [-118.19211, 33.76333], [-118.19198, 33.76331], [-118.19182, 33.76314], [-118.19171, 33.76307], [-118.19137, 33.76305], [-118.19121, 33.76293], [-118.19116, 33.76292], [-118.19075, 33.76293], [-118.19061, 33.76292], [-118.19056, 33.76288], [-118.19027, 33.76264], [-118.19008, 33.76263], [-118.18992, 33.76273], [-118.18992, 33.76276], [-118.19036, 33.76313], [-118.19038, 33.76317], [-118.19037, 33.76321], [-118.19011, 33.76342], [-118.1901, 33.76358], [-118.19007, 33.76361], [-118.19003, 33.76363], [-118.18995, 33.76364], [-118.18965, 33.76363], [-118.18933, 33.7636], [-118.18921, 33.76356], [-118.18911, 33.76352], [-118.18887, 33.76336], [-118.18872, 33.7633], [-118.18859, 33.76327], [-118.18845, 33.76326], [-118.18832, 33.76327], [-118.18795, 33.76334], [-118.18788, 33.76333], [-118.18768, 33.76327], [-118.18742, 33.7633], [-118.187, 33.76284], [-118.18703, 33.76282], [-118.18701, 33.76277], [-118.18703, 33.76273], [-118.18725, 33.76257], [-118.18759, 33.76238], [-118.18795, 33.76223], [-118.18827, 33.76214], [-118.18862, 33.76208], [-118.18898, 33.76205], [-118.18935, 33.76205], [-118.1899, 33.76213], [-118.19042, 33.76227], [-118.19238, 33.76306], [-118.19242, 33.76315]]]} | Open Access 1 | 45921 | Rainbow Lagoon Park | 28995 | 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/rainbow-lagoon/ | Los Angeles 6 | 11.696 | Rainbow Lagoon 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 | |
15113 | 15113 | 15112 | {"type": "MultiPolygon", "coordinates": [[[[-118.18106, 33.78938], [-118.18106, 33.78974], [-118.18078, 33.78974], [-118.18077, 33.78939], [-118.18106, 33.78938]]], [[[-118.18486, 33.78965], [-118.18486, 33.78969], [-118.18481, 33.78973], [-118.18452, 33.78974], [-118.18452, 33.78965], [-118.18486, 33.78965]]]]} | Open Access 1 | 45918 | Poly High Gateway Park | 28992 | 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.326 | Poly High Gateway Park | 0 | Local Park 2 | 4 | |
15112 | 15112 | 15111 | {"type": "Polygon", "coordinates": [[[-118.18768, 33.79411], [-118.18768, 33.79425], [-118.18729, 33.79425], [-118.18728, 33.79411], [-118.18768, 33.79411]]]} | Open Access 1 | 45917 | Officer Daryle W Black Memorial Park | 28991 | 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/daryle-black-park/ | Los Angeles 6 | 0.138 | Officer Daryle W Black Memorial Park | 0 | Local Park 2 | 4 |
15111 | 15111 | 15110 | {"type": "Polygon", "coordinates": [[[-118.18059, 33.7985], [-118.18058, 33.7996], [-118.17972, 33.79907], [-118.17956, 33.79901], [-118.17869, 33.79843], [-118.17851, 33.79836], [-118.17851, 33.79822], [-118.17966, 33.79895], [-118.18042, 33.79895], [-118.18045, 33.7985], [-118.18059, 33.7985]]]} | Open Access 1 | 45916 | NAACP Freedom Park | 28989 | 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.384 | NAACP Freedom Park | 0 | Local Park 2 | 4 | |
15110 | 15110 | 15109 | {"type": "Polygon", "coordinates": [[[-118.11318, 33.75143], [-118.11287, 33.75143], [-118.11283, 33.75139], [-118.11283, 33.75133], [-118.11296, 33.75122], [-118.11318, 33.75143]]]} | Open Access 1 | 45912 | Maurice 'Mossy' Kent Park | 28987 | 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/mossy-kent-park/ | Los Angeles 6 | 0.108 | Maurice 'Mossy' Kent Park | 0 | Local Park 2 | 4 |
15109 | 15109 | 15108 | {"type": "Polygon", "coordinates": [[[-118.21483, 33.79305], [-118.21483, 33.79341], [-118.21466, 33.79341], [-118.21466, 33.79305], [-118.21483, 33.79305]]]} | Open Access 1 | 45911 | Mary Molina Community Garden | 28986 | 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.152 | Mary Molina Community Garden | 0 | Local Park 2 | 4 | |
15108 | 15108 | 15107 | {"type": "Polygon", "coordinates": [[[-118.12176, 33.759], [-118.1204, 33.75905], [-118.12026, 33.75893], [-118.12025, 33.75889], [-118.12011, 33.75885], [-118.11987, 33.75871], [-118.11979, 33.75864], [-118.11957, 33.75836], [-118.11919, 33.75805], [-118.11881, 33.75768], [-118.11836, 33.75736], [-118.11801, 33.75714], [-118.11791, 33.75712], [-118.11782, 33.75706], [-118.11758, 33.7568], [-118.11728, 33.75668], [-118.11767, 33.75657], [-118.11775, 33.75657], [-118.1179, 33.75667], [-118.11806, 33.75674], [-118.11829, 33.75677], [-118.11919, 33.75681], [-118.11948, 33.75691], [-118.12176, 33.759]]]} | Open Access 1 | 45910 | Marine Park (Mother's Beach) | 28985 | 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/Marine-Park-(Mothers-Beach)/ | Los Angeles 6 | 9.237 | Marine Park (Mother's Beach) | None 1315 | ||
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 | |
15105 | 15105 | 15104 | {"type": "Polygon", "coordinates": [[[-118.20065, 33.78135], [-118.20033, 33.78157], [-118.20014, 33.78173], [-118.20008, 33.78169], [-118.20031, 33.7815], [-118.2005, 33.78127], [-118.20065, 33.78135]]]} | Open Access 1 | 45901 | Loma Vista Park | 28977 | 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.143 | Loma Vista Park | 0 | Local Park 2 | 4 | |
15104 | 15104 | 15103 | {"type": "Polygon", "coordinates": [[[-118.11965, 33.7608], [-118.11701, 33.75838], [-118.11694, 33.75835], [-118.1168, 33.75835], [-118.11668, 33.7584], [-118.1165, 33.75853], [-118.1164, 33.75854], [-118.11633, 33.75852], [-118.11608, 33.75832], [-118.11531, 33.75762], [-118.11531, 33.7576], [-118.11527, 33.75757], [-118.11514, 33.75749], [-118.11501, 33.75745], [-118.11529, 33.7574], [-118.11572, 33.75726], [-118.11599, 33.75708], [-118.11976, 33.76053], [-118.1198, 33.76062], [-118.11979, 33.76069], [-118.11975, 33.76074], [-118.11965, 33.7608]]]} | Open Access 1 | 45900 | Davies Launch Ramp | 28975 | 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 | 6.061 | Davies Launch Ramp | None 1313 | |||
15103 | 15103 | 15102 | {"type": "Polygon", "coordinates": [[[-118.19355, 33.77787], [-118.19355, 33.77801], [-118.19333, 33.77801], [-118.19333, 33.77787], [-118.19355, 33.77787]]]} | Open Access 1 | 45897 | K-9 Corner Dog Park | 28973 | 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/K-9-Corner-Dog-Park/ | Los Angeles 6 | 0.076 | K-9 Corner Dog Park | 0 | Local Park 2 | 4 |
15102 | 15102 | 15101 | {"type": "Polygon", "coordinates": [[[-118.17621, 33.79705], [-118.17208, 33.79435], [-118.17208, 33.79407], [-118.1762, 33.79673], [-118.17621, 33.79705]]]} | Open Access 1 | 45896 | Jenni Rivera Memorial Park | 28972 | 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.157 | Jenni Rivera Memorial Park | 0 | Local Park 2 | 4 | |
15101 | 15101 | 15100 | {"type": "Polygon", "coordinates": [[[-118.17048, 33.8517], [-118.17005, 33.8517], [-118.16998, 33.8517], [-118.17048, 33.85153], [-118.17048, 33.8517]]]} | Open Access 1 | 45895 | Jackson Street Dog Park | 28971 | 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.111 | Jackson Street Dog 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 | |||
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 |
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 |
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]);