units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
101 rows where DES_TP = 2 and 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
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency 101
MNG_AGENCY 1
- Long Beach, City of · 101 ✖
DES_TP 1
- Local Park · 101 ✖
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 | |
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 | |
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 | |
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 | |
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 | |
7307 | 7307 | 7306 | {"type": "Polygon", "coordinates": [[[-118.21529, 33.8152], [-118.21119, 33.81519], [-118.21119, 33.81407], [-118.21528, 33.81406], [-118.21529, 33.8152]]]} | Open Access 1 | 6592 | Silverado Park | 25498 | 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 | 11.725 | Silverado 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 | |
7309 | 7309 | 7308 | {"type": "Polygon", "coordinates": [[[-118.19207, 33.84232], [-118.19185, 33.84231], [-118.19149, 33.84239], [-118.18788, 33.84325], [-118.18769, 33.84342], [-118.18738, 33.84539], [-118.1872, 33.84545], [-118.18698, 33.84535], [-118.18657, 33.84521], [-118.18617, 33.84512], [-118.18618, 33.84367], [-118.18513, 33.84366], [-118.18513, 33.84305], [-118.18873, 33.84219], [-118.19167, 33.84121], [-118.19207, 33.84232]]]} | Open Access 1 | 6596 | Scherer Park | 25183 | 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 | 21.821 | Scherer Park | 0 | Local Park 2 | 4 | |
969 | 969 | 968 | {"type": "MultiPolygon", "coordinates": [[[[-118.19734, 33.76719], [-118.19543, 33.76709], [-118.19542, 33.76707], [-118.19499, 33.76705], [-118.19499, 33.76694], [-118.19543, 33.76696], [-118.1963, 33.76696], [-118.19734, 33.76699], [-118.19734, 33.76719]]], [[[-118.19792, 33.767], [-118.19792, 33.76721], [-118.19746, 33.7672], [-118.19745, 33.76699], [-118.19792, 33.767]]], [[[-118.19929, 33.76702], [-118.19929, 33.76707], [-118.19921, 33.76714], [-118.19825, 33.76714], [-118.19821, 33.7671], [-118.1982, 33.76721], [-118.19814, 33.76721], [-118.19814, 33.76703], [-118.19929, 33.76702]]], [[[-118.20049, 33.76703], [-118.20049, 33.76709], [-118.20043, 33.76714], [-118.19954, 33.76714], [-118.19949, 33.76707], [-118.19949, 33.76702], [-118.20049, 33.76703]]], [[[-118.20174, 33.76703], [-118.20174, 33.76709], [-118.20167, 33.76714], [-118.20076, 33.76714], [-118.2007, 33.76709], [-118.2007, 33.76703], [-118.20174, 33.76703]]]]} | Open Access 1 | 6608 | Santa Cruz Park | 25082 | 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.096 | Santa Cruz Park | 0 | Local Park 2 | 4 | |
2951 | 2951 | 2950 | {"type": "Polygon", "coordinates": [[[-118.16535, 33.78974], [-118.16492, 33.78974], [-118.16342, 33.78877], [-118.16342, 33.78849], [-118.16535, 33.78974]]]} | Open Access 1 | 20230 | Rotary Centennial Park | 24683 | 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.209 | Rotary Centennial Park | 0 | Local Park 2 | 4 | |
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 |
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 | |
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 |
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]);