superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
218 rows where MNG_AGENCY = 534 sorted by SUID_NMA
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4589 | 4589 | 4588 | {"type": "Polygon", "coordinates": [[[-121.42737, 38.57959], [-121.42638, 38.58052], [-121.42618, 38.5804], [-121.42616, 38.5804], [-121.42426, 38.57908], [-121.42522, 38.57816], [-121.42737, 38.57959]]]} | Open Access 1 | Glen Hall Park | 19321 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 8.14 | Glen Hall Park | ||
4595 | 4595 | 4594 | {"type": "Polygon", "coordinates": [[[-121.39164, 38.55995], [-121.3911, 38.55993], [-121.39004, 38.55998], [-121.38947, 38.56007], [-121.38911, 38.56017], [-121.38888, 38.56026], [-121.38882, 38.56025], [-121.38841, 38.55986], [-121.38834, 38.55976], [-121.3883, 38.55966], [-121.38821, 38.55925], [-121.38817, 38.55916], [-121.3881, 38.55904], [-121.38785, 38.5588], [-121.38778, 38.55871], [-121.38776, 38.55867], [-121.38775, 38.55857], [-121.38769, 38.55851], [-121.3877, 38.55849], [-121.38762, 38.55817], [-121.38966, 38.55791], [-121.3915, 38.55772], [-121.39164, 38.55995]]]} | Open Access 1 | Glenbrook Park | 19327 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 17.876 | Glenbrook Park | ||
3678 | 3678 | 3677 | {"type": "Polygon", "coordinates": [[[-121.53484, 38.68257], [-121.53481, 38.68262], [-121.53481, 38.68311], [-121.53416, 38.68311], [-121.53411, 38.68309], [-121.53409, 38.68305], [-121.53409, 38.68196], [-121.5341, 38.68193], [-121.53416, 38.68191], [-121.53472, 38.68191], [-121.53477, 38.68193], [-121.53479, 38.68197], [-121.53479, 38.68236], [-121.53476, 38.68247], [-121.53479, 38.68253], [-121.53484, 38.68257]]]} | Open Access 1 | Golden Poppy Park Site | 19370 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 2.034 | Golden Poppy Park Site | ||
3782 | 3782 | 3781 | {"type": "Polygon", "coordinates": [[[-121.43954, 38.54796], [-121.43925, 38.54796], [-121.43924, 38.54707], [-121.43947, 38.54706], [-121.43948, 38.5472], [-121.43953, 38.54721], [-121.43954, 38.54796]]]} | Open Access 1 | Greenfair Park | 19476 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 0.599 | Greenfair Park | ||
4833 | 4833 | 4832 | {"type": "Polygon", "coordinates": [[[-121.43618, 38.62808], [-121.43618, 38.62871], [-121.43489, 38.6287], [-121.43487, 38.62944], [-121.43165, 38.6294], [-121.43221, 38.62774], [-121.43232, 38.62747], [-121.4337, 38.62751], [-121.43618, 38.62808]]]} | Open Access 1 | Hagginwood Park | 19596 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 15.441 | Hagginwood Park | ||
4864 | 4864 | 4863 | {"type": "Polygon", "coordinates": [[[-121.47081, 38.48702], [-121.47078, 38.48705], [-121.47072, 38.48707], [-121.47052, 38.48708], [-121.47021, 38.48715], [-121.46988, 38.48728], [-121.46965, 38.48732], [-121.46956, 38.48731], [-121.46952, 38.48726], [-121.4695, 38.48712], [-121.46919, 38.48628], [-121.46912, 38.486], [-121.46909, 38.48575], [-121.46909, 38.48545], [-121.46913, 38.4853], [-121.46919, 38.48519], [-121.46927, 38.4851], [-121.46943, 38.48499], [-121.46967, 38.48486], [-121.46981, 38.48475], [-121.46995, 38.48456], [-121.46999, 38.4844], [-121.4706, 38.48441], [-121.47057, 38.48522], [-121.46971, 38.48524], [-121.46969, 38.48578], [-121.46976, 38.48586], [-121.46981, 38.48586], [-121.46981, 38.48614], [-121.46988, 38.48616], [-121.46988, 38.48622], [-121.46993, 38.48628], [-121.47001, 38.4863], [-121.47006, 38.4863], [-121.47011, 38.48629], [-121.47021, 38.48623], [-121.47033, 38.48622], [-121.47072, 38.48625], [-121.47076, 38.48629], [-121.47081, 38.48655], [-121.47081, 38.48702]]]} | Open Access 1 | Hampton Park | 19632 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 6.639 | Hampton Park | ||
4882 | 4882 | 4881 | {"type": "Polygon", "coordinates": [[[-121.47543, 38.66991], [-121.46604, 38.66983], [-121.46605, 38.66945], [-121.46608, 38.66228], [-121.4661, 38.66], [-121.46631, 38.6599], [-121.4664, 38.65943], [-121.46793, 38.65892], [-121.4686, 38.65854], [-121.47094, 38.65833], [-121.4715, 38.65781], [-121.47227, 38.6578], [-121.47285, 38.65813], [-121.4737, 38.65896], [-121.47466, 38.65919], [-121.47541, 38.66402], [-121.47543, 38.66991]]]} | Open Access 1 | Hansen Ranch Park Site | 19651 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 245.785 | Hansen Ranch Park Site | ||
4917 | 4917 | 4916 | {"type": "Polygon", "coordinates": [[[-121.53347, 38.65284], [-121.53295, 38.65303], [-121.533, 38.65368], [-121.53229, 38.65259], [-121.53287, 38.6529], [-121.5334, 38.65271], [-121.53347, 38.65284]]]} | Open Access 1 | Harrier Park | 19692 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 0.744 | Harrier Park | ||
5083 | 5083 | 5082 | {"type": "Polygon", "coordinates": [[[-121.51362, 38.66933], [-121.51356, 38.66936], [-121.51352, 38.66965], [-121.51202, 38.66965], [-121.51203, 38.66902], [-121.51201, 38.66897], [-121.51196, 38.66892], [-121.51187, 38.66888], [-121.51187, 38.66863], [-121.51362, 38.66862], [-121.51363, 38.66917], [-121.5136, 38.66928], [-121.51362, 38.66933]]]} | Open Access 1 | Heron Park | 19879 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 3.956 | Heron Park | ||
5190 | 5190 | 5189 | {"type": "Polygon", "coordinates": [[[-121.43874, 38.46569], [-121.43819, 38.46739], [-121.43747, 38.46762], [-121.43732, 38.46733], [-121.43733, 38.46729], [-121.43736, 38.46728], [-121.43753, 38.46725], [-121.43749, 38.46696], [-121.43743, 38.46676], [-121.43722, 38.46628], [-121.43718, 38.46612], [-121.43718, 38.46587], [-121.43722, 38.46565], [-121.43727, 38.46551], [-121.43742, 38.46554], [-121.43747, 38.46543], [-121.43874, 38.46569]]]} | Open Access 1 | Hite Park | 20009 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 5.38 | Hite Park | ||
5299 | 5299 | 5298 | {"type": "Polygon", "coordinates": [[[-121.52692, 38.63473], [-121.52678, 38.63528], [-121.52555, 38.63509], [-121.52553, 38.63504], [-121.52557, 38.63475], [-121.52557, 38.6345], [-121.52553, 38.63432], [-121.52544, 38.63404], [-121.52544, 38.634], [-121.52549, 38.63396], [-121.52665, 38.63367], [-121.52679, 38.63402], [-121.52678, 38.63406], [-121.52678, 38.63411], [-121.52684, 38.6342], [-121.52688, 38.63452], [-121.52686, 38.63464], [-121.52687, 38.63468], [-121.52692, 38.63473]]]} | Open Access 1 | Hummingbird Park | 20149 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 4.292 | Hummingbird Park | ||
5386 | 5386 | 5385 | {"type": "Polygon", "coordinates": [[[-121.49051, 38.58452], [-121.49031, 38.58498], [-121.49032, 38.58499], [-121.49039, 38.58502], [-121.49021, 38.58543], [-121.48985, 38.58533], [-121.49004, 38.58488], [-121.48986, 38.58482], [-121.49005, 38.58439], [-121.49051, 38.58452]]]} | Open Access 1 | J. Neely Johnson Park | 20292 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 0.969 | J. Neely Johnson Park | ||
5431 | 5431 | 5430 | {"type": "Polygon", "coordinates": [[[-121.40888, 38.44576], [-121.4061, 38.44611], [-121.406, 38.44602], [-121.40602, 38.44602], [-121.40602, 38.446], [-121.4057, 38.44561], [-121.40562, 38.44542], [-121.40568, 38.44537], [-121.40622, 38.44522], [-121.40717, 38.44514], [-121.40731, 38.44516], [-121.40741, 38.44512], [-121.40745, 38.44507], [-121.40746, 38.44502], [-121.40741, 38.4449], [-121.40736, 38.44452], [-121.40738, 38.44446], [-121.4073, 38.44379], [-121.40735, 38.44376], [-121.40786, 38.44372], [-121.408, 38.44374], [-121.40811, 38.4437], [-121.40815, 38.44365], [-121.40816, 38.44359], [-121.4081, 38.44347], [-121.40799, 38.44284], [-121.40804, 38.4428], [-121.40865, 38.44276], [-121.4087, 38.44278], [-121.40872, 38.44281], [-121.40873, 38.44529], [-121.40888, 38.4453], [-121.40888, 38.44576]]]} | Open Access 1 | Jacinto Creek Park | 20298 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 11.721 | Jacinto Creek Park | ||
5434 | 5434 | 5433 | {"type": "Polygon", "coordinates": [[[-121.42447, 38.441], [-121.42427, 38.44108], [-121.4241, 38.44111], [-121.42304, 38.44103], [-121.42281, 38.44122], [-121.4226, 38.44135], [-121.42233, 38.44147], [-121.4221, 38.44152], [-121.42195, 38.44149], [-121.42175, 38.44139], [-121.42124, 38.44106], [-121.42109, 38.44103], [-121.42096, 38.44104], [-121.42084, 38.44107], [-121.42063, 38.44118], [-121.4202, 38.44142], [-121.41979, 38.44174], [-121.41976, 38.44175], [-121.41971, 38.44174], [-121.41912, 38.44137], [-121.41894, 38.44131], [-121.41871, 38.44158], [-121.41854, 38.44171], [-121.41828, 38.44184], [-121.418, 38.44191], [-121.41759, 38.44266], [-121.41759, 38.4429], [-121.41749, 38.4429], [-121.41748, 38.44285], [-121.41745, 38.44282], [-121.41736, 38.44279], [-121.41729, 38.4428], [-121.4172, 38.44286], [-121.41714, 38.44288], [-121.4153, 38.44286], [-121.41524, 38.44283], [-121.41522, 38.44275], [-121.41508, 38.44292], [-121.41501, 38.44293], [-121.41501, 38.44335], [-121.41399, 38.44336], [-121.41327, 38.44342], [-121.41121, 38.44344], [-121.41093, 38.44348], [-121.40932, 38.44348], [-121.40906, 38.44363], [-121.40901, 38.44362], [-121.40897, 38.44363], [-121.40879, 38.44356], [-121.40872, 38.44357], [-121.40872, 38.44297], [-121.40873, 38.44301], [-121.40877, 38.44305], [-121.40886, 38.44307], [-121.40893, 38.44306], [-121.40897, 38.44303], [-121.40935, 38.44293], [-121.40975, 38.4429], [-121.40985, 38.44293], [-121.40999, 38.44289], [-121.41014, 38.44289], [-121.41037, 38.44292], [-121.41066, 38.44301], [-121.41094, 38.44307], [-121.41115, 38.44307], [-121.4112, 38.44306], [-121.41215, 38.44305], [-121.41245, 38.44302], [-121.41295, 38.44286], [-121.41322, 38.44281], [-121.41411, 38.4428], [-121.41423, 38.44282], [-121.41431, 38.44281], [-121.4144, 38.44276], [-121.41442, 38.44269], [-121.4146, 38.44268], [-121.41475, 38.44257], [-121.41509, 38.44241], [-121.4153, 38.44244], [-121.41585, 38.44235], [-121.41592, 38.44219], [-121.41597, 38.44212], [-121.41604, 38.44207], [-121.41615, 38.44203], [-121.41615, 38.44165], [-121.41758, 38.44164], [-121.418, 38.44119], [-121.41806, 38.44117], [-121.41811, 38.44113], [-121.4182, 38.44078], [-121.41824, 38.44073], [-121.4183, 38.44071], [-121.41856, 38.4407], [-121.41878, 38.44086], [-121.41922, 38.44072], [-121.41963, 38.44066], [-121.41979, 38.4404], [-121.41997, 38.44031], [-121.42003, 38.44031], [-121.42009, 38.44033], [-121.42035, 38.44052], [-121.42045, 38.44065], [-121.42109, 38.44061], [-121.42135, 38.44062], [-121.42256, 38.44068], [-121.42405, 38.4408], [-121.42411, 38.44079], [-121.42427, 38.44072], [-121.42447, 38.441]]]} | Open Access 1 | Jacinto Creek Parkway | 20299 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 24.724 | Jacinto Creek Parkway | ||
5442 | 5442 | 5441 | {"type": "Polygon", "coordinates": [[[-121.45893, 38.6102], [-121.45821, 38.61059], [-121.45821, 38.61059], [-121.45818, 38.6102], [-121.45893, 38.6102]]]} | Open Access 1 | Jack Rea Park | 20307 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 0.344 | Jack Rea Park | ||
4378 | 4378 | 4377 | {"type": "Polygon", "coordinates": [[[-121.49277, 38.52179], [-121.4893, 38.52182], [-121.48924, 38.52186], [-121.48924, 38.52201], [-121.48922, 38.52204], [-121.48918, 38.52206], [-121.48769, 38.52207], [-121.48765, 38.52206], [-121.48763, 38.52202], [-121.48763, 38.52128], [-121.49274, 38.52117], [-121.49277, 38.52179]]]} | Open Access 1 | James Mangan Park | 20348 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 8.116 | James Mangan Park | ||
4381 | 4381 | 4380 | {"type": "Polygon", "coordinates": [[[-121.47037, 38.57427], [-121.46999, 38.57514], [-121.46892, 38.57486], [-121.4693, 38.57398], [-121.47037, 38.57427]]]} | Open Access 1 | James W. Marshall Park | 20353 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 2.513 | James W. Marshall Park | ||
5530 | 5530 | 5529 | {"type": "Polygon", "coordinates": [[[-121.50648, 38.59414], [-121.50589, 38.59413], [-121.50489, 38.59417], [-121.5049, 38.59365], [-121.50497, 38.5932], [-121.50516, 38.59117], [-121.50526, 38.59069], [-121.50529, 38.59069], [-121.50538, 38.59115], [-121.5057, 38.59113], [-121.50574, 38.59129], [-121.50532, 38.59132], [-121.50531, 38.59134], [-121.50604, 38.59332], [-121.50643, 38.59332], [-121.50642, 38.59372], [-121.50644, 38.59396], [-121.50648, 38.59414]]]} | Open Access 1 | Jibboom Street Park | 20410 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 6.288 | Jibboom Street Park | ||
5547 | 5547 | 5546 | {"type": "Polygon", "coordinates": [[[-121.49759, 38.49088], [-121.49558, 38.49166], [-121.495, 38.49083], [-121.49492, 38.49067], [-121.49489, 38.49056], [-121.49493, 38.49051], [-121.49532, 38.49044], [-121.49563, 38.49034], [-121.49655, 38.49], [-121.4966, 38.49002], [-121.49676, 38.49022], [-121.49701, 38.49045], [-121.49759, 38.49088]]]} | Open Access 1 | John Cabrillo Park | 20431 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 5.681 | John Cabrillo Park | ||
5556 | 5556 | 5555 | {"type": "Polygon", "coordinates": [[[-121.48973, 38.5708], [-121.48934, 38.57169], [-121.48827, 38.5714], [-121.48865, 38.57051], [-121.48973, 38.5708]]]} | Open Access 1 | John Fremont Park | 20442 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 2.561 | John Fremont Park |
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]);