units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
148 rows where MNG_AGENCY = 294 sorted by LABEL_NAME descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, YR_EST, GAP_STS
DES_TP 21
- Local Park 101
- Local Recreation Area 25
- 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
- None 1
- None 1
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency 148
MNG_AGENCY 1
- Long Beach, City of · 148 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15400 | 15400 | 15399 | {"type": "Polygon", "coordinates": [[[-118.20264, 33.82045], [-118.20248, 33.82045], [-118.20153, 33.81926], [-118.20157, 33.81922], [-118.2021, 33.81932], [-118.20229, 33.81937], [-118.2023, 33.81941], [-118.20247, 33.81946], [-118.20248, 33.81943], [-118.20264, 33.81948], [-118.20264, 33.82045]]]} | Open Access 1 | 46617 | Wrigley Heights Dog Park | 29932 | 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.703 | Wrigley Heights Dog Park | 2014 | Local Park 2 | 4 | |
15125 | 15125 | 15124 | {"type": "Polygon", "coordinates": [[[-118.18058, 33.80621], [-118.18059, 33.80984], [-118.18057, 33.81046], [-118.18041, 33.81046], [-118.17969, 33.81087], [-118.17885, 33.81087], [-118.17885, 33.81152], [-118.1774, 33.81152], [-118.1774, 33.81136], [-118.17753, 33.81135], [-118.17753, 33.81108], [-118.17786, 33.8108], [-118.17854, 33.8108], [-118.17874, 33.81064], [-118.17874, 33.81009], [-118.17754, 33.81009], [-118.17753, 33.80951], [-118.17641, 33.8095], [-118.17642, 33.80662], [-118.1766, 33.80662], [-118.17681, 33.80621], [-118.18058, 33.80621]]]} | Open Access 1 | 45937 | Willow Springs Park | 29012 | 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 | 44.552 | Willow Springs Park | 2012 | Local Park 2 | 4 | |
15383 | 15383 | 15382 | {"type": "Polygon", "coordinates": [[[-118.2044, 33.80427], [-118.20253, 33.80427], [-118.2025, 33.80426], [-118.20249, 33.80421], [-118.20246, 33.80421], [-118.20246, 33.80405], [-118.20248, 33.80403], [-118.20428, 33.80403], [-118.20428, 33.80418], [-118.2044, 33.80427]]]} | Open Access 1 | 46599 | Willow & Golden S | 29904 | 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.117 | Willow & Golden S | None 1358 | |||
7351 | 7351 | 7350 | {"type": "MultiPolygon", "coordinates": [[[[-118.20441, 33.8045], [-118.20433, 33.8046], [-118.20414, 33.8046], [-118.20413, 33.80458], [-118.20401, 33.80458], [-118.204, 33.8046], [-118.20355, 33.8046], [-118.20349, 33.80463], [-118.20345, 33.80467], [-118.20344, 33.80477], [-118.2025, 33.80477], [-118.20246, 33.80475], [-118.20246, 33.8046], [-118.20249, 33.8046], [-118.20249, 33.80452], [-118.20251, 33.8045], [-118.20441, 33.8045]]], [[[-118.20458, 33.81893], [-118.20429, 33.81892], [-118.20427, 33.81165], [-118.20428, 33.81154], [-118.20428, 33.80838], [-118.20426, 33.80766], [-118.20426, 33.80502], [-118.20428, 33.80502], [-118.20431, 33.80542], [-118.20447, 33.80664], [-118.20455, 33.80772], [-118.20454, 33.81285], [-118.20458, 33.81507], [-118.20457, 33.81568], [-118.20458, 33.81609], [-118.20454, 33.81631], [-118.20458, 33.81654], [-118.20453, 33.81736], [-118.20458, 33.81893]]]]} | Open Access 1 | 6673 | Willow & Golden N | 29903 | 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 | 9.937 | Willow & Golden N | None 608 | |||
7955 | 7955 | 7954 | {"type": "MultiPolygon", "coordinates": [[[[-118.13185, 33.7681], [-118.13155, 33.76841], [-118.13116, 33.76817], [-118.13149, 33.76786], [-118.13185, 33.7681]]], [[[-118.13275, 33.76887], [-118.13275, 33.76923], [-118.1317, 33.76851], [-118.13201, 33.7682], [-118.13242, 33.76845], [-118.13275, 33.76887]]]]} | Open Access 1 | 6657 | Will Rogers Mini Park | 27529 | 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.644 | Will Rogers MP | 0 | Local Park 2 | 4 | |
7342 | 7342 | 7341 | {"type": "MultiPolygon", "coordinates": [[[[-118.12325, 33.78716], [-118.12277, 33.78723], [-118.12268, 33.78743], [-118.12306, 33.78799], [-118.12258, 33.788], [-118.12258, 33.7886], [-118.12109, 33.78861], [-118.12109, 33.78634], [-118.12322, 33.78711], [-118.12325, 33.78716]]], [[[-118.1223, 33.78891], [-118.12247, 33.78918], [-118.12251, 33.78926], [-118.12253, 33.7894], [-118.12249, 33.78951], [-118.1223, 33.78983], [-118.12206, 33.79013], [-118.12186, 33.79032], [-118.12163, 33.79051], [-118.12159, 33.79052], [-118.12155, 33.79051], [-118.12126, 33.79023], [-118.12117, 33.7901], [-118.12112, 33.78997], [-118.1211, 33.7898], [-118.1211, 33.78893], [-118.12117, 33.78888], [-118.12223, 33.78888], [-118.1223, 33.78891]]]]} | Open Access 1 | 6661 | Whaley Park | 27449 | 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 | 12.86 | Whaley Park | 0 | Local Park 2 | 4 | |
7353 | 7353 | 7352 | {"type": "Polygon", "coordinates": [[[-118.12999, 33.81894], [-118.12997, 33.82212], [-118.12801, 33.82211], [-118.12799, 33.8221], [-118.12797, 33.82208], [-118.12797, 33.82135], [-118.12799, 33.81897], [-118.12804, 33.81894], [-118.12999, 33.81894]]]} | Open Access 1 | 6677 | Wardlow Park | 27258 | 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 | 16.103 | Wardlow Park | 0 | Local Park 2 | 4 | |
3980 | 3980 | 3979 | {"type": "Polygon", "coordinates": [[[-118.12082, 33.75099], [-118.12081, 33.75102], [-118.12061, 33.75101], [-118.12037, 33.75104], [-118.12012, 33.75112], [-118.11995, 33.75121], [-118.11979, 33.75134], [-118.11882, 33.75237], [-118.11861, 33.75252], [-118.11819, 33.75271], [-118.11817, 33.75267], [-118.11847, 33.75255], [-118.11862, 33.75247], [-118.11878, 33.75235], [-118.11892, 33.75223], [-118.11977, 33.75131], [-118.11991, 33.75119], [-118.12011, 33.75109], [-118.12036, 33.751], [-118.12058, 33.75098], [-118.12082, 33.75099]]]} | Open Access 1 | 46618 | Vista del Golfo Parkway | 29933 | 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.273 | Vista del Golfo Parkway | 0 | Local Recreation Area 3 | 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 | |
7350 | 7350 | 7349 | {"type": "Polygon", "coordinates": [[[-118.19306, 33.80927], [-118.19306, 33.8111], [-118.19251, 33.81108], [-118.19251, 33.8112], [-118.19208, 33.81133], [-118.1906, 33.80809], [-118.19282, 33.80809], [-118.19281, 33.80926], [-118.19306, 33.80927]]]} | Open Access 1 | 6672 | Veterans Park | 27045 | 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 | 13.027 | Veterans Park | 0 | Local Park 2 | 4 | |
15123 | 15123 | 15122 | {"type": "Polygon", "coordinates": [[[-118.15198, 33.76322], [-118.15204, 33.763], [-118.15207, 33.76299], [-118.15224, 33.76336], [-118.15223, 33.76338], [-118.1522, 33.76339], [-118.15197, 33.76334], [-118.15196, 33.7633], [-118.15198, 33.76322]]]} | Open Access 1 | 45935 | Trolley Park | 29010 | 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.15 | Trolley Park | 0 | Local Park 2 | 4 | |
977 | 977 | 976 | {"type": "Polygon", "coordinates": [[[-118.1256, 33.75282], [-118.12556, 33.75298], [-118.12512, 33.75279], [-118.1256, 33.75282], [-118.1256, 33.75282]]]} | Open Access 1 | 6656 | Treasure Island Park | 26519 | 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.102 | Treasure Island Park | 0 | Local Park 2 | 4 | |
15378 | 15378 | 15377 | {"type": "Polygon", "coordinates": [[[-118.14144, 33.77431], [-118.14144, 33.77465], [-118.13728, 33.77198], [-118.13729, 33.77178], [-118.13753, 33.77178], [-118.14144, 33.77431]]]} | Open Access 1 | 46621 | The Long Beach Greenbelt | 29941 | 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.662 | The Long Beach Greenbelt | 0 | Local Recreation Area 3 | 4 | |
15122 | 15122 | 15121 | {"type": "Polygon", "coordinates": [[[-118.1242, 33.75299], [-118.12413, 33.75324], [-118.12382, 33.75319], [-118.12388, 33.75293], [-118.1242, 33.75299]]]} | Open Access 1 | 45934 | The Colonnade | 29009 | 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/the-colonnade/ | Los Angeles 6 | 0.211 | The Colonnade | None 1317 | ||
2714 | 2714 | 2713 | {"type": "MultiPolygon", "coordinates": [[[[-118.21183, 33.82355], [-118.21117, 33.82355], [-118.21118, 33.82341], [-118.21183, 33.82341], [-118.21183, 33.82355]]], [[[-118.21441, 33.82237], [-118.21313, 33.8242], [-118.21309, 33.82422], [-118.21282, 33.82418], [-118.21282, 33.82385], [-118.21441, 33.82237]]]]} | Open Access 1 | 6689 | Tanaka Park | 26179 | 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.624 | Tanaka Park | 0 | Local Park 2 | 4 | |
7347 | 7347 | 7346 | {"type": "Polygon", "coordinates": [[[-118.14052, 33.79614], [-118.1405, 33.79962], [-118.13617, 33.79961], [-118.13624, 33.79913], [-118.13625, 33.79772], [-118.13796, 33.79772], [-118.13796, 33.79668], [-118.13769, 33.79667], [-118.13769, 33.79613], [-118.14052, 33.79614]]]} | Open Access 1 | 6669 | Stearns Champions Park | 25814 | 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 | 31.225 | Stearns Champions Park | 0 | Local Park 2 | 4 | |
1126 | 1126 | 1125 | {"type": "MultiPolygon", "coordinates": [[[[-118.19262, 33.86033], [-118.1925, 33.86059], [-118.19247, 33.86057], [-118.19244, 33.8605], [-118.1922, 33.86042], [-118.19216, 33.86047], [-118.19211, 33.86043], [-118.19206, 33.86043], [-118.19206, 33.86014], [-118.19229, 33.86016], [-118.19238, 33.86019], [-118.19262, 33.86033]]], [[[-118.19495, 33.86197], [-118.1949, 33.86207], [-118.19487, 33.86207], [-118.19485, 33.86197], [-118.1935, 33.86102], [-118.19314, 33.86081], [-118.19274, 33.86062], [-118.19263, 33.86064], [-118.19277, 33.86047], [-118.19278, 33.86047], [-118.19475, 33.86186], [-118.19494, 33.86194], [-118.19494, 33.86196], [-118.19495, 33.86197]]], [[[-118.19511, 33.86172], [-118.19507, 33.86179], [-118.195, 33.86182], [-118.19478, 33.86171], [-118.19288, 33.86037], [-118.19326, 33.86055], [-118.19364, 33.86077], [-118.195, 33.86172], [-118.19508, 33.86171], [-118.19511, 33.86172]]]]} | Open Access 1 | 6601 | South Street Parkway | 25680 | 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.42 | South Street Parkway | 0 | Local Recreation Area 3 | 4 | |
1124 | 1124 | 1123 | {"type": "Polygon", "coordinates": [[[-118.17408, 33.83155], [-118.17408, 33.83229], [-118.1721, 33.83229], [-118.1721, 33.83155], [-118.17408, 33.83155]]]} | Open Access 1 | 6590 | Somerset Park | 25602 | 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.726 | Somerset Park | 0 | Local Park 2 | 4 | |
15121 | 15121 | 15120 | {"type": "Polygon", "coordinates": [[[-118.19844, 33.84148], [-118.19809, 33.84159], [-118.1981, 33.84183], [-118.19442, 33.8431], [-118.194, 33.8431], [-118.19803, 33.8417], [-118.19805, 33.84167], [-118.19804, 33.84148], [-118.198, 33.84136], [-118.19796, 33.84133], [-118.19797, 33.84132], [-118.19827, 33.84145], [-118.19844, 33.84148]]]} | Open Access 1 | 45929 | Sleepy Hollow Greenbelt | 29005 | 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/sleepy-hollow-greenbelt/ | Los Angeles 6 | 1.576 | Sleepy Hollow Greenbelt | 0 | Local Recreation Area 3 | 4 |
15407 | 15407 | 15406 | {"type": "MultiPolygon", "coordinates": [[[[-118.19258, 33.84372], [-118.18742, 33.84551], [-118.1873, 33.84546], [-118.18731, 33.84541], [-118.18836, 33.84504], [-118.18837, 33.84497], [-118.18857, 33.84497], [-118.18981, 33.84454], [-118.18982, 33.84458], [-118.19067, 33.84429], [-118.19068, 33.84423], [-118.19254, 33.8436], [-118.19258, 33.84372]]], [[[-118.19442, 33.8431], [-118.19291, 33.84361], [-118.19283, 33.84363], [-118.19279, 33.84352], [-118.194, 33.8431], [-118.19442, 33.8431]]]]} | No Public Access 3 | 46631 | Sleepy Hollow Greenbelt | 29956 | 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.297 | Sleepy Hollow Greenbelt | 0 | Local Recreation Area 3 | 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]);