units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
192 rows where DES_TP = 2 and MNG_AGENCY = 534 sorted by LABEL_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
ACCESS_TYP 2
- Open Access 190
- Restricted Access 2
MNG_AG_TYP 1
- City Agency 192
MNG_AGENCY 1
- Sacramento, City of · 192 ✖
DES_TP 1
- Local Park · 192 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11068 | 11068 | 11067 | {"type": "MultiPolygon", "coordinates": [[[[-121.48235, 38.49361], [-121.48044, 38.49362], [-121.48044, 38.4925], [-121.48046, 38.49243], [-121.4805, 38.49238], [-121.48056, 38.49235], [-121.48062, 38.49233], [-121.48066, 38.49234], [-121.48097, 38.49259], [-121.48202, 38.49327], [-121.48222, 38.49346], [-121.48235, 38.49361]]], [[[-121.48082, 38.49178], [-121.48186, 38.49179], [-121.48203, 38.49183], [-121.48215, 38.49187], [-121.48238, 38.49202], [-121.48249, 38.49213], [-121.48255, 38.49223], [-121.48261, 38.49243], [-121.48261, 38.49309], [-121.48258, 38.49318], [-121.48252, 38.49327], [-121.48247, 38.4933], [-121.48241, 38.49329], [-121.48215, 38.49307], [-121.48118, 38.49244], [-121.48098, 38.49229], [-121.4808, 38.4921], [-121.48065, 38.49188], [-121.48065, 38.49185], [-121.48068, 38.49181], [-121.48082, 38.49178]]]]} | Open Access 1 | 21267 | 24th Street Bypass Park | 15186 | 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 | 7.38 | 24th Street Bypass Park | 0 | Local Park 2 | 4 | |
10982 | 10982 | 10981 | {"type": "Polygon", "coordinates": [[[-121.51646, 38.63672], [-121.51648, 38.63675], [-121.51663, 38.63716], [-121.51669, 38.63723], [-121.51674, 38.63726], [-121.51682, 38.63726], [-121.51726, 38.63713], [-121.51731, 38.63714], [-121.51734, 38.63716], [-121.51743, 38.63744], [-121.51747, 38.63769], [-121.51747, 38.63788], [-121.51742, 38.6383], [-121.5174, 38.63835], [-121.51735, 38.63837], [-121.5163, 38.63837], [-121.51622, 38.63835], [-121.51612, 38.63836], [-121.51601, 38.63829], [-121.51469, 38.63829], [-121.51467, 38.63694], [-121.51469, 38.6369], [-121.51479, 38.63683], [-121.5158, 38.63681], [-121.51646, 38.63672]]]} | Open Access 1 | 21062 | Airfield Park Site | 15300 | 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.219 | Airfield Park Site | 0 | Local Park 2 | 4 | |
2685 | 2685 | 2684 | {"type": "MultiPolygon", "coordinates": [[[[-121.48293, 38.51018], [-121.48097, 38.51019], [-121.48096, 38.50922], [-121.4829, 38.50921], [-121.48293, 38.51018]]], [[[-121.48293, 38.51026], [-121.48294, 38.51071], [-121.48292, 38.51075], [-121.48286, 38.51077], [-121.48266, 38.5107], [-121.48201, 38.51037], [-121.48198, 38.51032], [-121.482, 38.51028], [-121.48205, 38.51027], [-121.48293, 38.51026]]], [[[-121.48603, 38.50975], [-121.48435, 38.50907], [-121.48421, 38.50905], [-121.48314, 38.50905], [-121.48311, 38.50825], [-121.48452, 38.50824], [-121.48455, 38.50891], [-121.48602, 38.50891], [-121.48603, 38.50975]]]]} | Open Access 1 | 21162 | Airport Little League Park | 15302 | 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.948 | Airport Little League Park | 0 | Local Park 2 | 4 | |
5660 | 5660 | 5659 | {"type": "Polygon", "coordinates": [[[-121.47373, 38.56654], [-121.47334, 38.56743], [-121.47227, 38.56714], [-121.47265, 38.56625], [-121.47373, 38.56654]]]} | Open Access 1 | 21143 | Albert Winn Park | 15339 | 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.556 | Albert Winn Park | 0 | Local Park 2 | 4 | |
10964 | 10964 | 10963 | {"type": "Polygon", "coordinates": [[[-121.49616, 38.68143], [-121.4964, 38.68163], [-121.49674, 38.68182], [-121.49676, 38.68185], [-121.49676, 38.68189], [-121.49665, 38.68204], [-121.49654, 38.68216], [-121.49628, 38.68236], [-121.49596, 38.6825], [-121.49562, 38.68257], [-121.49562, 38.68167], [-121.49581, 38.6816], [-121.49608, 38.68144], [-121.49616, 38.68143]]]} | Open Access 1 | 21031 | Alder Park | 15347 | 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.029 | Alder Park | 0 | Local Park 2 | 4 | |
4853 | 4853 | 4852 | {"type": "Polygon", "coordinates": [[[-121.46925, 38.47035], [-121.46923, 38.47237], [-121.46889, 38.47237], [-121.46888, 38.47244], [-121.46842, 38.47244], [-121.46844, 38.4715], [-121.46663, 38.47146], [-121.46663, 38.47066], [-121.46925, 38.47035]]]} | Open Access 1 | 21246 | Anthony Park | 15517 | 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 | 7.874 | Anthony Park | 0 | Local Park 2 | 4 | |
14274 | 14274 | 14273 | {"type": "Polygon", "coordinates": [[[-121.50527, 38.51694], [-121.50526, 38.51771], [-121.50495, 38.51773], [-121.50492, 38.51813], [-121.5048, 38.51819], [-121.50397, 38.51815], [-121.50311, 38.51796], [-121.50321, 38.5176], [-121.50323, 38.51723], [-121.50436, 38.51724], [-121.50438, 38.5169], [-121.50527, 38.51694]]]} | Open Access 1 | 44200 | Argonaut Park | 15582 | 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.779 | Argonaut Park | 0 | Local Park 2 | 4 | |
2705 | 2705 | 2704 | {"type": "Polygon", "coordinates": [[[-121.39499, 38.51299], [-121.39497, 38.51489], [-121.39072, 38.51491], [-121.39071, 38.51296], [-121.39129, 38.51296], [-121.39136, 38.513], [-121.39499, 38.51299]]]} | Open Access 1 | 21277 | Army Depot Park | 15599 | 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 | 19.501 | Army Depot Park | 0 | Local Park 2 | 4 | |
14715 | 14715 | 14714 | {"type": "Polygon", "coordinates": [[[-121.43457, 38.51775], [-121.4334, 38.51776], [-121.4334, 38.51687], [-121.43456, 38.51684], [-121.43457, 38.51775]]]} | Open Access 1 | 45063 | Artivio Guerrero Park | 32031 | 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/Fruitridge-Broadway/ArtivioGuerreroPark | Sacramento 41 | 2.508 | Artivio Guerrero Park | 0 | Local Park 2 | 4 |
10970 | 10970 | 10969 | {"type": "Polygon", "coordinates": [[[-121.51727, 38.6794], [-121.51682, 38.67957], [-121.51652, 38.67972], [-121.51614, 38.67998], [-121.51586, 38.68024], [-121.5158, 38.68025], [-121.51564, 38.68016], [-121.5155, 38.68003], [-121.5148, 38.67896], [-121.51483, 38.67892], [-121.51502, 38.67885], [-121.51578, 38.67857], [-121.51596, 38.67854], [-121.5167, 38.67847], [-121.51727, 38.6794]]]} | Open Access 1 | 21036 | Autumn Meadow Park | 15717 | 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 | 6.067 | Autumn Meadow Park | 0 | Local Park 2 | 4 | |
4460 | 4460 | 4459 | {"type": "Polygon", "coordinates": [[[-121.44418, 38.57641], [-121.44386, 38.57722], [-121.44264, 38.57692], [-121.44285, 38.57644], [-121.44297, 38.57628], [-121.44312, 38.57613], [-121.44418, 38.57641]]]} | Open Access 1 | 21135 | Bertha Henschel Park | 16039 | 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.544 | Bertha Henschel Park | 0 | Local Park 2 | 4 | |
5679 | 5679 | 5678 | {"type": "Polygon", "coordinates": [[[-121.41842, 38.53594], [-121.41841, 38.53668], [-121.41809, 38.53668], [-121.41811, 38.53715], [-121.41717, 38.53715], [-121.41717, 38.53667], [-121.41657, 38.53666], [-121.41657, 38.53593], [-121.41842, 38.53594]]]} | Open Access 1 | 21181 | Bill Bean Jr. Memorial Park | 16101 | 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.334 | Bill Bean Jr. Memorial Park | 0 | Local Park 2 | 4 | |
10989 | 10989 | 10988 | {"type": "Polygon", "coordinates": [[[-121.54805, 38.65366], [-121.54371, 38.65373], [-121.54371, 38.65373], [-121.54373, 38.65347], [-121.54381, 38.6532], [-121.5441, 38.65269], [-121.54414, 38.65266], [-121.54417, 38.65266], [-121.54447, 38.65269], [-121.54786, 38.65266], [-121.54803, 38.65268], [-121.54805, 38.65366]]]} | Open Access 1 | 21054 | Blackbird Park Site | 16141 | 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 | 10.178 | Blackbird Park Site | 0 | Local Park 2 | 4 | |
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 |
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]);