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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2077 | 2077 | 2076 | {"type": "Polygon", "coordinates": [[[-121.5211, 38.67146], [-121.52034, 38.6716], [-121.52019, 38.6711], [-121.52096, 38.67095], [-121.5211, 38.67146]]]} | Open Access 1 | Blue Oak Park | 16180 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 0.981 | Blue Oak Park | ||
2271 | 2271 | 2270 | {"type": "MultiPolygon", "coordinates": [[[[-121.4915, 38.54409], [-121.49131, 38.54436], [-121.49116, 38.54469], [-121.49106, 38.54476], [-121.49097, 38.54478], [-121.49093, 38.54475], [-121.49092, 38.54471], [-121.49115, 38.54402], [-121.4912, 38.54398], [-121.49145, 38.54403], [-121.49149, 38.54405], [-121.4915, 38.54409]]], [[[-121.49155, 38.54385], [-121.49153, 38.54389], [-121.49148, 38.5439], [-121.49126, 38.54386], [-121.49122, 38.54381], [-121.49141, 38.54321], [-121.49146, 38.54318], [-121.49151, 38.54319], [-121.49154, 38.54322], [-121.49158, 38.54335], [-121.49154, 38.54364], [-121.49155, 38.54385]]]]} | Open Access 1 | Brockway Park | 16413 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 0.923 | Brockway Park | ||
2360 | 2360 | 2359 | {"type": "Polygon", "coordinates": [[[-121.51929, 38.67551], [-121.51923, 38.67555], [-121.51859, 38.67566], [-121.51808, 38.6758], [-121.51802, 38.67579], [-121.51799, 38.67577], [-121.51793, 38.67564], [-121.51786, 38.67546], [-121.51772, 38.67469], [-121.51768, 38.67457], [-121.51756, 38.67438], [-121.51739, 38.67423], [-121.51718, 38.67412], [-121.51691, 38.67406], [-121.51659, 38.67406], [-121.51653, 38.67403], [-121.51653, 38.67391], [-121.51658, 38.67379], [-121.51691, 38.67323], [-121.51705, 38.67309], [-121.51706, 38.67302], [-121.51701, 38.67294], [-121.51708, 38.67287], [-121.51713, 38.67286], [-121.51715, 38.67284], [-121.51715, 38.67283], [-121.51711, 38.6728], [-121.51729, 38.67262], [-121.51766, 38.67279], [-121.51799, 38.67289], [-121.51843, 38.67298], [-121.51893, 38.67301], [-121.51897, 38.67304], [-121.51896, 38.67377], [-121.51898, 38.67406], [-121.51905, 38.67455], [-121.51929, 38.67547], [-121.51929, 38.67551]]]} | Open Access 1 | Burberry Community Park | 16512 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 11.799 | Burberry Community Park | ||
2449 | 2449 | 2448 | {"type": "Polygon", "coordinates": [[[-121.47119, 38.54916], [-121.46908, 38.54859], [-121.46921, 38.54825], [-121.4674, 38.54775], [-121.46783, 38.54674], [-121.47117, 38.54673], [-121.47119, 38.54916]]]} | Open Access 1 | C.K. McClatchy Park | 16629 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 15.193 | C.K. McClatchy Park | ||
2464 | 2464 | 2463 | {"type": "Polygon", "coordinates": [[[-121.51769, 38.52549], [-121.51733, 38.52654], [-121.51561, 38.52607], [-121.51615, 38.52487], [-121.51653, 38.52496], [-121.51707, 38.52504], [-121.51708, 38.52545], [-121.51769, 38.52549]]]} | Restricted Access 2 | Cabrillo School Park | 16644 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 5.006 | Cabrillo School Park | ||
2519 | 2519 | 2518 | {"type": "Polygon", "coordinates": [[[-121.49698, 38.67214], [-121.49581, 38.67215], [-121.49575, 38.6712], [-121.49575, 38.67097], [-121.49576, 38.67093], [-121.49582, 38.67091], [-121.49682, 38.67091], [-121.49682, 38.67126], [-121.49686, 38.6716], [-121.49692, 38.67192], [-121.49698, 38.67214]]]} | Open Access 1 | California Lilac Park | 16718 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 3.244 | California Lilac Park | ||
1811 | 1811 | 1810 | {"type": "Polygon", "coordinates": [[[-121.41952, 38.50592], [-121.41951, 38.5072], [-121.41886, 38.5072], [-121.41886, 38.50592], [-121.41952, 38.50592]]]} | Open Access 1 | Camellia Park | 16757 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 2.007 | Camellia Park | ||
2813 | 2813 | 2812 | {"type": "Polygon", "coordinates": [[[-121.49463, 38.58074], [-121.49425, 38.58162], [-121.49317, 38.58133], [-121.49355, 38.58045], [-121.49463, 38.58074]]]} | Open Access 1 | Cesar E. Chavez Plaza | 17105 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 2.536 | Cesar E. Chavez Plaza | ||
2851 | 2851 | 2850 | {"type": "Polygon", "coordinates": [[[-121.45969, 38.63169], [-121.45705, 38.63166], [-121.45705, 38.63023], [-121.45968, 38.63026], [-121.45969, 38.63169]]]} | Open Access 1 | Charles Robertson Park | 17142 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 9.052 | Charles Robertson Park | ||
2855 | 2855 | 2854 | {"type": "Polygon", "coordinates": [[[-121.50622, 38.50363], [-121.50617, 38.50614], [-121.50582, 38.50614], [-121.50585, 38.50608], [-121.50596, 38.50602], [-121.50599, 38.50597], [-121.50598, 38.50588], [-121.50591, 38.50584], [-121.50581, 38.50584], [-121.50575, 38.50587], [-121.50572, 38.50591], [-121.50558, 38.50591], [-121.50563, 38.50416], [-121.50568, 38.50412], [-121.50591, 38.50363], [-121.50622, 38.50363]]]} | Open Access 1 | Charlie Jensen Park | 17146 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 3.128 | Charlie Jensen Park | ||
2860 | 2860 | 2859 | {"type": "Polygon", "coordinates": [[[-121.54287, 38.48454], [-121.54187, 38.48493], [-121.54142, 38.48517], [-121.54135, 38.48511], [-121.54076, 38.48491], [-121.54058, 38.48492], [-121.54054, 38.48497], [-121.54054, 38.48505], [-121.54053, 38.48508], [-121.54043, 38.48514], [-121.54036, 38.48515], [-121.54031, 38.4851], [-121.54038, 38.48394], [-121.54034, 38.48386], [-121.54044, 38.48383], [-121.54282, 38.4844], [-121.54287, 38.48454]]]} | Open Access 1 | Charter Pointe Park | 17152 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 4.869 | Charter Pointe Park | ||
2899 | 2899 | 2898 | {"type": "Polygon", "coordinates": [[[-121.53019, 38.52879], [-121.53015, 38.52925], [-121.52935, 38.53048], [-121.52854, 38.53097], [-121.52849, 38.53092], [-121.52904, 38.53014], [-121.52869, 38.52987], [-121.52878, 38.52961], [-121.52873, 38.52846], [-121.52867, 38.52796], [-121.52852, 38.52757], [-121.52833, 38.52725], [-121.52782, 38.52648], [-121.52739, 38.52607], [-121.52728, 38.52599], [-121.52778, 38.52564], [-121.52884, 38.52658], [-121.52956, 38.52731], [-121.53, 38.52791], [-121.52998, 38.5285], [-121.53019, 38.52879]]]} | Open Access 1 | Chicory Bend Park | 17193 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 12.718 | Chicory Bend Park | ||
2928 | 2928 | 2927 | {"type": "Polygon", "coordinates": [[[-121.4893, 38.63101], [-121.48854, 38.63146], [-121.48832, 38.63121], [-121.48812, 38.63094], [-121.4879, 38.63059], [-121.48776, 38.63033], [-121.4876, 38.62998], [-121.48751, 38.62973], [-121.4874, 38.62935], [-121.48738, 38.62926], [-121.4874, 38.62922], [-121.48744, 38.6292], [-121.4876, 38.62918], [-121.48856, 38.62911], [-121.48898, 38.63034], [-121.48917, 38.63085], [-121.48921, 38.63092], [-121.4893, 38.63101]]]} | Open Access 1 | Chuckwagon Park | 17237 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 5.955 | Chuckwagon Park | ||
3106 | 3106 | 3105 | {"type": "Polygon", "coordinates": [[[-121.45137, 38.55665], [-121.45077, 38.55797], [-121.44992, 38.55774], [-121.45051, 38.55641], [-121.45137, 38.55665]]]} | Open Access 1 | Coloma Park | 17525 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 3.043 | Coloma Park | ||
598 | 598 | 597 | {"type": "Polygon", "coordinates": [[[-121.44431, 38.5343], [-121.4443, 38.53526], [-121.44337, 38.53526], [-121.44337, 38.5343], [-121.44431, 38.5343]]]} | Open Access 1 | Colonial Park | 17531 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 2.156 | Colonial Park | ||
3156 | 3156 | 3155 | {"type": "Polygon", "coordinates": [[[-121.54229, 38.48581], [-121.54226, 38.48585], [-121.54184, 38.48591], [-121.5417, 38.48591], [-121.54162, 38.48595], [-121.54159, 38.486], [-121.54102, 38.48588], [-121.54172, 38.48551], [-121.54172, 38.48543], [-121.54229, 38.48517], [-121.54225, 38.48521], [-121.54223, 38.48526], [-121.54226, 38.48535], [-121.54225, 38.48555], [-121.54229, 38.48581]]]} | Open Access 1 | Cool Wind Way Park | 17618 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1.159 | Cool Wind Way Park | ||
3208 | 3208 | 3207 | {"type": "MultiPolygon", "coordinates": [[[[-121.54638, 38.60138], [-121.54637, 38.60333], [-121.54595, 38.60333], [-121.54563, 38.60336], [-121.54532, 38.60343], [-121.54502, 38.60353], [-121.54564, 38.60269], [-121.54556, 38.60254], [-121.54638, 38.60138]]], [[[-121.54666, 38.59963], [-121.54579, 38.60083], [-121.54517, 38.60174], [-121.54517, 38.59971], [-121.54559, 38.59963], [-121.54591, 38.5996], [-121.54632, 38.5996], [-121.54666, 38.59963]]]]} | Open Access 1 | Costa Park Site | 17672 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 6.741 | Costa Park Site | ||
3210 | 3210 | 3209 | {"type": "Polygon", "coordinates": [[[-121.42814, 38.45798], [-121.42812, 38.45801], [-121.42806, 38.45802], [-121.42748, 38.45801], [-121.42639, 38.45801], [-121.42559, 38.45798], [-121.42546, 38.45681], [-121.42785, 38.45651], [-121.42814, 38.45798]]]} | Open Access 1 | Cosumnes River College Park | 17674 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 8.069 | Cosumnes River College Park | ||
3230 | 3230 | 3229 | {"type": "Polygon", "coordinates": [[[-121.49696, 38.65967], [-121.49671, 38.65975], [-121.49648, 38.65985], [-121.49626, 38.65998], [-121.49606, 38.66013], [-121.496, 38.66013], [-121.4959, 38.66007], [-121.49574, 38.65996], [-121.49561, 38.65983], [-121.49545, 38.65962], [-121.49537, 38.65947], [-121.49531, 38.65928], [-121.49528, 38.65912], [-121.49528, 38.65855], [-121.49533, 38.65852], [-121.49581, 38.65851], [-121.49618, 38.65848], [-121.49656, 38.65842], [-121.49671, 38.65837], [-121.49673, 38.65902], [-121.49685, 38.65933], [-121.49696, 38.65967]]]} | Open Access 1 | Cottonwood Park | 17691 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 4.986 | Cottonwood Park | ||
3313 | 3313 | 3312 | {"type": "Polygon", "coordinates": [[[-121.46115, 38.56625], [-121.46113, 38.56629], [-121.46094, 38.5663], [-121.46078, 38.56628], [-121.46062, 38.56624], [-121.46046, 38.56617], [-121.46033, 38.56608], [-121.46035, 38.56603], [-121.46115, 38.56625]]]} | Open Access 1 | Crescent Park | 17796 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 0.208 | Crescent 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]);