units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
220 rows where MNG_AGENCY = 534 sorted by LABEL_NAME
This data as json, copyable, CSV (advanced)
DES_TP 8
- Local Park 179
- Local Recreation Area 14
- Local Conservation Area 2
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 2
- Open Access 197
- Restricted Access 3
MNG_AG_TYP 1
- City Agency 200
MNG_AGENCY 1
- Sacramento, City of · 200 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10976 | 10976 | 10975 | {"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 | 21043 | Blue Oak Park | 16180 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 0.981 | Blue Oak Park | 0 | Local Park 2 | 4 | |
11075 | 11075 | 11074 | {"type": "MultiPolygon", "coordinates": [[[[-121.4912, 38.54398], [-121.49146, 38.54403], [-121.49149, 38.54405], [-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.49146, 38.54318], [-121.49151, 38.54319], [-121.49154, 38.54322], [-121.49159, 38.54335], [-121.49154, 38.54364], [-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]]]]} | Open Access 1 | 21278 | Brockway Park | 16413 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 0.923 | Brockway Park | 0 | Local Park 2 | 4 | |
13121 | 13121 | 13120 | {"type": "Polygon", "coordinates": [[[-121.48561, 38.56902], [-121.48543, 38.56942], [-121.48476, 38.56924], [-121.48504, 38.56859], [-121.48522, 38.56878], [-121.48533, 38.56887], [-121.48561, 38.56902]]]} | Open Access 1 | 48821 | Brooks Truitt Park | 33540 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | https://www.cityofsacramento.org/ParksandRec/Parks/Park-Directory/Central-City/Brooks-Truitt-Park | Sacramento 41 | 0.896 | Brooks Truitt Park | 0 | Local Park 2 | 4 |
10972 | 10972 | 10971 | {"type": "Polygon", "coordinates": [[[-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], [-121.51927, 38.67554], [-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]]]} | Open Access 1 | 21038 | Burberry Community Park | 16512 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 11.799 | Burberry Community Park | 0 | Local Park 2 | 4 | |
5671 | 5671 | 5670 | {"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 | 21157 | C.K. McClatchy Park | 16629 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 15.191 | C.K. McClatchy Park | 0 | Local Park 2 | 4 | |
14208 | 14208 | 14207 | {"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.51707, 38.52545], [-121.51769, 38.52549]]]} | Restricted Access 2 | 44071 | Cabrillo School Park | 16644 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 5.003 | Cabrillo School Park | 0 | Local Park 2 | 4 | |
10975 | 10975 | 10974 | {"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 | 21042 | California Lilac Park | 16718 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 3.244 | California Lilac Park | 0 | Local Park 2 | 4 | |
11038 | 11038 | 11037 | {"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 | 21214 | Camellia Park | 16757 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 2.007 | Camellia Park | 0 | Local Park 2 | 4 | |
5645 | 5645 | 5644 | {"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 | 21129 | Cesar E. Chavez Plaza | 17105 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 2.537 | Cesar E. Chavez Plaza | 0 | Local Park 2 | 4 | |
10998 | 10998 | 10997 | {"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 | 21067 | Charles Robertson Park | 17142 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 9.054 | Charles Robertson Park | 0 | Local Park 2 | 4 | |
11077 | 11077 | 11076 | {"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.50596], [-121.50598, 38.50589], [-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.50413], [-121.50591, 38.50363], [-121.50622, 38.50363]]]} | Open Access 1 | 21280 | Charlie Jensen Park | 17146 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 3.128 | Charlie Jensen Park | 0 | Local Park 2 | 4 | |
11053 | 11053 | 11052 | {"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.48491], [-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 | 21236 | Charter Pointe Park | 17152 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 4.868 | Charter Pointe Park | 0 | Local Park 2 | 4 | |
3068 | 3068 | 3067 | {"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.52962], [-121.52873, 38.52845], [-121.52867, 38.52797], [-121.52852, 38.52758], [-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 | 21197 | Chicory Bend Park | 17193 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 12.713 | Chicory Bend Park | 0 | Local Park 2 | 4 | |
10999 | 10999 | 10998 | {"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 | 21068 | Chuckwagon Park | 17237 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 5.955 | Chuckwagon Park | 0 | Local Park 2 | 4 | |
5668 | 5668 | 5667 | {"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 | 21153 | Coloma Park | 17525 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 3.044 | Coloma Park | 0 | Local Park 2 | 4 | |
5680 | 5680 | 5679 | {"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 | 21182 | Colonial Park | 17531 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 2.157 | Colonial Park | 0 | Local Park 2 | 4 | |
11052 | 11052 | 11051 | {"type": "Polygon", "coordinates": [[[-121.54229, 38.48517], [-121.54225, 38.48521], [-121.54223, 38.48526], [-121.54226, 38.48535], [-121.54225, 38.48555], [-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]]]} | Open Access 1 | 21235 | Cool Wind Way Park | 17618 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 1.159 | Cool Wind Way Park | 0 | Local Park 2 | 4 | |
2678 | 2678 | 2677 | {"type": "Polygon", "coordinates": [[[-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 | 21115 | Costa Park Site | 17672 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 3.74 | Costa Park Site | 0 | Local Park 2 | 4 | |
11070 | 11070 | 11069 | {"type": "Polygon", "coordinates": [[[-121.54638, 38.60138], [-121.54637, 38.60333], [-121.54595, 38.60333], [-121.54563, 38.60336], [-121.54533, 38.60343], [-121.54502, 38.60353], [-121.54565, 38.60268], [-121.54556, 38.60254], [-121.54638, 38.60138]]]} | Open Access 1 | 21271 | Costa Park Site | 17672 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 3.0 | Costa Park Site | 0 | Local Park 2 | 4 | |
11060 | 11060 | 11059 | {"type": "Polygon", "coordinates": [[[-121.42785, 38.45651], [-121.42815, 38.45794], [-121.42814, 38.45798], [-121.42812, 38.45801], [-121.42806, 38.45802], [-121.42748, 38.45801], [-121.4264, 38.45801], [-121.42559, 38.45798], [-121.42546, 38.45681], [-121.42785, 38.45651]]]} | Open Access 1 | 21251 | Cosumnes River College Park | 17674 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 8.086 | Cosumnes River College 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]);