superunits_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: YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12738 | 12738 | 12737 | {"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.20231, 33.81941], [-118.20247, 33.81946], [-118.20248, 33.81943], [-118.20264, 33.81948], [-118.20264, 33.82045]]]} | Open Access 1 | Wrigley Heights Dog Park | 29932 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1.703 | Wrigley Heights Dog Park | 2014 | |
12085 | 12085 | 12084 | {"type": "Polygon", "coordinates": [[[-118.18058, 33.80621], [-118.18059, 33.80984], [-118.18057, 33.81046], [-118.18041, 33.81046], [-118.17969, 33.81087], [-118.17886, 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.17873, 33.81064], [-118.17874, 33.8101], [-118.17754, 33.81009], [-118.17752, 33.80951], [-118.17641, 33.8095], [-118.17642, 33.80662], [-118.1766, 33.80661], [-118.17681, 33.80621], [-118.18058, 33.80621]]]} | Open Access 1 | Willow Springs Park | 29012 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 44.578 | Willow Springs Park | 2012 | |
11259 | 11259 | 11258 | {"type": "Polygon", "coordinates": [[[-118.2044, 33.80427], [-118.20253, 33.80427], [-118.2025, 33.80426], [-118.20249, 33.80422], [-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 | Willow & Golden S | 29904 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1.118 | Willow & Golden S | ||
11258 | 11258 | 11257 | {"type": "MultiPolygon", "coordinates": [[[[-118.20441, 33.8045], [-118.20433, 33.8046], [-118.20414, 33.8046], [-118.20412, 33.80458], [-118.20402, 33.80458], [-118.204, 33.8046], [-118.20355, 33.8046], [-118.20349, 33.80463], [-118.20346, 33.80467], [-118.20344, 33.80477], [-118.2025, 33.80477], [-118.20246, 33.80475], [-118.20246, 33.8046], [-118.20249, 33.80459], [-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 | Willow & Golden N | 29903 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 9.936 | Willow & Golden N | ||
735 | 735 | 734 | {"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 | Will Rogers Mini Park | 27529 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1.644 | Will Rogers MP | ||
11172 | 11172 | 11171 | {"type": "MultiPolygon", "coordinates": [[[[-118.12325, 33.78716], [-118.12277, 33.78723], [-118.12268, 33.78742], [-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.78917], [-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.12118, 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 | Whaley Park | 27449 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 12.868 | Whaley Park | ||
11022 | 11022 | 11021 | {"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 | Wardlow Park | 27258 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 16.102 | Wardlow Park | ||
12739 | 12739 | 12738 | {"type": "Polygon", "coordinates": [[[-118.12082, 33.75099], [-118.12081, 33.75102], [-118.12061, 33.75101], [-118.12036, 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 | Vista del Golfo Parkway | 29933 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.273 | Vista del Golfo Parkway | ||
10873 | 10873 | 10872 | {"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.18509, 33.76602], [-118.18623, 33.76612]]], [[[-118.18771, 33.76633], [-118.18769, 33.76657], [-118.1865, 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.19371, 33.76698], [-118.19369, 33.76701], [-118.19251, 33.76694], [-118.19251, 33.76664], [-118.19323, 33.7667], [-118.19325, 33.76684], [-118.19356, 33.76686], [-118.19358, 33.76678], [-118.1937, 33.76678], [-118.19371, 33.76687], [-118.19417, 33.76689], [-118.19419, 33.7668], [-118.19486, 33.76683]]]]} | Open Access 1 | Victory Park | 27089 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 5.711 | Victory Park | ||
10827 | 10827 | 10826 | {"type": "Polygon", "coordinates": [[[-118.19306, 33.80927], [-118.19306, 33.8111], [-118.19252, 33.81108], [-118.19251, 33.8112], [-118.19208, 33.81133], [-118.1906, 33.80809], [-118.19282, 33.80809], [-118.19281, 33.80925], [-118.19306, 33.80927]]]} | Open Access 1 | Veterans Park | 27045 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 13.03 | Veterans Park | ||
12084 | 12084 | 12083 | {"type": "Polygon", "coordinates": [[[-118.15224, 33.76336], [-118.15223, 33.76338], [-118.1522, 33.76339], [-118.15197, 33.76334], [-118.15196, 33.7633], [-118.15205, 33.763], [-118.15207, 33.76299], [-118.15224, 33.76336]]]} | Open Access 1 | Trolley Park | 29010 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.149 | Trolley Park | ||
10451 | 10451 | 10450 | {"type": "Polygon", "coordinates": [[[-118.1256, 33.75282], [-118.12556, 33.75298], [-118.12512, 33.75279], [-118.12512, 33.75279], [-118.1256, 33.75282]]]} | Open Access 1 | Treasure Island Park | 26519 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.102 | Treasure Island Park | ||
12754 | 12754 | 12753 | {"type": "Polygon", "coordinates": [[[-118.14144, 33.77431], [-118.14144, 33.77465], [-118.13729, 33.77198], [-118.13729, 33.77178], [-118.13753, 33.77178], [-118.14144, 33.77431]]]} | Open Access 1 | The Long Beach Greenbelt | 29941 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 3.661 | The Long Beach Greenbelt | ||
12083 | 12083 | 12082 | {"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 | The Colonnade | http://www.longbeach.gov/park/park-and-facilities/directory/the-colonnade/ | 29009 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.211 | The Colonnade | |
10221 | 10221 | 10220 | {"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 | Tanaka Park | 26179 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1.623 | Tanaka Park | ||
9938 | 9938 | 9937 | {"type": "Polygon", "coordinates": [[[-118.14052, 33.79614], [-118.1405, 33.79962], [-118.13617, 33.79961], [-118.13624, 33.79913], [-118.13625, 33.79772], [-118.13795, 33.79772], [-118.13796, 33.79668], [-118.13769, 33.79667], [-118.13769, 33.79613], [-118.14052, 33.79614]]]} | Open Access 1 | Stearns Champions Park | 25814 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 31.24 | Stearns Champions Park | ||
9818 | 9818 | 9817 | {"type": "MultiPolygon", "coordinates": [[[[-118.19262, 33.86033], [-118.1925, 33.86059], [-118.19247, 33.86057], [-118.19243, 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.19484, 33.86197], [-118.1935, 33.86102], [-118.19314, 33.86081], [-118.19274, 33.86062], [-118.19263, 33.86064], [-118.19276, 33.86047], [-118.19278, 33.86047], [-118.19475, 33.86186], [-118.19494, 33.86194], [-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.19499, 33.86172], [-118.19508, 33.86171], [-118.19511, 33.86172]]]]} | Open Access 1 | South Street Parkway | 25680 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1.422 | South Street Parkway | ||
9762 | 9762 | 9761 | {"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 | Somerset Park | 25602 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 3.725 | Somerset Park | ||
11320 | 11320 | 11319 | {"type": "MultiPolygon", "coordinates": [[[[-118.19258, 33.84372], [-118.18742, 33.84551], [-118.1873, 33.84546], [-118.18731, 33.84541], [-118.18835, 33.84504], [-118.18837, 33.84497], [-118.18857, 33.84497], [-118.18981, 33.84454], [-118.18983, 33.84457], [-118.19066, 33.8443], [-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 | Sleepy Hollow Greenbelt | 29956 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 2.298 | Sleepy Hollow Greenbelt | ||
12080 | 12080 | 12079 | {"type": "Polygon", "coordinates": [[[-118.19844, 33.84148], [-118.19809, 33.84159], [-118.1981, 33.84183], [-118.19442, 33.8431], [-118.194, 33.8431], [-118.19802, 33.84171], [-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 | Sleepy Hollow Greenbelt | http://www.longbeach.gov/park/park-and-facilities/directory/sleepy-hollow-greenbelt/ | 29005 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1.577 | Sleepy Hollow Greenbelt |
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]);