units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
220 rows where MNG_AGENCY = 534 and MNG_AG_TYP = 2 sorted by AGNCY_NAME
This data as json, copyable, CSV (advanced)
DES_TP 9
- Local Park 175
- Local Recreation Area 16
- Local Conservation Area 3
- Local Other or Unknown 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3069 | 3069 | 3068 | {"type": "Polygon", "coordinates": [[[-121.45028, 38.52731], [-121.45035, 38.52733], [-121.4514, 38.52853], [-121.45141, 38.52857], [-121.45138, 38.52861], [-121.45006, 38.52916], [-121.45001, 38.52914], [-121.44926, 38.5281], [-121.44925, 38.52806], [-121.44927, 38.52803], [-121.44994, 38.52763], [-121.4501, 38.52749], [-121.45024, 38.52733], [-121.45028, 38.52731]]]} | Open Access 1 | 21198 | Lawrence Park | 21117 | 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.073 | Lawrence Park | 0 | Local Park 2 | 4 | |
3072 | 3072 | 3071 | {"type": "Polygon", "coordinates": [[[-121.48428, 38.48829], [-121.48427, 38.48823], [-121.48421, 38.48816], [-121.48413, 38.48811], [-121.48405, 38.4881], [-121.48271, 38.48809], [-121.48271, 38.48641], [-121.48428, 38.4864], [-121.48428, 38.48829]]]} | Open Access 1 | 21230 | Mark Hopkins Park | 21870 | 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.367 | Mark Hopkins Park | 0 | Local Park 2 | 4 | |
3073 | 3073 | 3072 | {"type": "Polygon", "coordinates": [[[-121.54386, 38.47907], [-121.5413, 38.48076], [-121.53988, 38.47961], [-121.53967, 38.47947], [-121.54192, 38.47755], [-121.54295, 38.47837], [-121.54336, 38.47881], [-121.54386, 38.47907]]]} | Open Access 1 | 21240 | Garcia Bend Park | 19191 | 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.601 | Garcia Bend Park | 0 | Local Park 2 | 4 | |
3076 | 3076 | 3075 | {"type": "Polygon", "coordinates": [[[-121.43065, 38.44173], [-121.43038, 38.44183], [-121.43018, 38.44193], [-121.42994, 38.44208], [-121.42974, 38.44226], [-121.42779, 38.44444], [-121.42753, 38.44467], [-121.42719, 38.44487], [-121.4268, 38.44501], [-121.42653, 38.44506], [-121.42632, 38.44509], [-121.42605, 38.44509], [-121.42598, 38.44506], [-121.42597, 38.44502], [-121.42595, 38.44305], [-121.42592, 38.44275], [-121.42584, 38.44245], [-121.42573, 38.4422], [-121.42562, 38.44203], [-121.42536, 38.44167], [-121.42713, 38.44181], [-121.42868, 38.44197], [-121.42893, 38.44195], [-121.43014, 38.44175], [-121.43048, 38.44172], [-121.43065, 38.44173]]]} | Open Access 1 | 21255 | North Laguna Creek Park | 22827 | 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 | 21.437 | North Laguna Creek Park | 0 | Local Park 2 | 4 | |
3077 | 3077 | 3076 | {"type": "Polygon", "coordinates": [[[-121.40888, 38.44576], [-121.4061, 38.44611], [-121.406, 38.44602], [-121.40602, 38.44602], [-121.40603, 38.44601], [-121.4057, 38.44561], [-121.40562, 38.44542], [-121.40567, 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.4453], [-121.40888, 38.4453], [-121.40888, 38.44576]]]} | Open Access 1 | 21256 | Jacinto Creek Park | 20298 | 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.72 | Jacinto Creek Park | 0 | Local Park 2 | 4 | |
3078 | 3078 | 3077 | {"type": "Polygon", "coordinates": [[[-121.5365, 38.65112], [-121.53707, 38.65112], [-121.53713, 38.65115], [-121.53714, 38.65221], [-121.53713, 38.65224], [-121.53708, 38.65226], [-121.53664, 38.65228], [-121.53536, 38.65229], [-121.53531, 38.65226], [-121.53527, 38.65204], [-121.53507, 38.65134], [-121.53509, 38.65128], [-121.53513, 38.65127], [-121.53597, 38.65116], [-121.5365, 38.65112]]]} | Open Access 1 | 21258 | Quail Park | 24046 | 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.192 | Quail Park | 0 | Local Park 2 | 4 | |
3081 | 3081 | 3080 | {"type": "Polygon", "coordinates": [[[-121.50685, 38.65057], [-121.50685, 38.65314], [-121.50629, 38.65314], [-121.50594, 38.6531], [-121.50561, 38.65302], [-121.50509, 38.65281], [-121.5051, 38.65069], [-121.50522, 38.65066], [-121.50527, 38.65062], [-121.50529, 38.65057], [-121.50685, 38.65057]]]} | Open Access 1 | 21263 | River Birch Park Site | 24406 | 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.39 | River Birch Park Site | 0 | Local Park 2 | 4 | |
3082 | 3082 | 3081 | {"type": "Polygon", "coordinates": [[[-121.50672, 38.66802], [-121.50672, 38.66802], [-121.50395, 38.66804], [-121.50412, 38.66774], [-121.50423, 38.66746], [-121.5043, 38.66714], [-121.50431, 38.66685], [-121.50529, 38.66685], [-121.50671, 38.66684], [-121.50672, 38.66802]]]} | Open Access 1 | 21265 | North Natomas Park Nature Area | 22833 | 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.099 | North Natomas Park Nature Area | 0 | Local Conservation Area 4 | 2 | |
3083 | 3083 | 3082 | {"type": "Polygon", "coordinates": [[[-121.53606, 38.63461], [-121.53596, 38.63488], [-121.53508, 38.63486], [-121.53466, 38.63481], [-121.53425, 38.63471], [-121.53391, 38.6346], [-121.53349, 38.63441], [-121.5332, 38.63424], [-121.53245, 38.63373], [-121.5321, 38.63354], [-121.53166, 38.63337], [-121.5312, 38.63325], [-121.53123, 38.63315], [-121.53128, 38.63315], [-121.5329, 38.63256], [-121.53289, 38.62786], [-121.53361, 38.62786], [-121.53367, 38.6278], [-121.53477, 38.62836], [-121.53478, 38.6346], [-121.53606, 38.63461]]]} | Open Access 1 | 21266 | San Juan Reservoir Park | 24921 | 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 | 32.901 | San Juan Reservoir Park | 0 | Local Park 2 | 4 | |
3231 | 3231 | 3230 | {"type": "Polygon", "coordinates": [[[-121.47466, 38.65919], [-121.47371, 38.65896], [-121.47285, 38.65813], [-121.47227, 38.6578], [-121.47151, 38.65781], [-121.47094, 38.65833], [-121.4686, 38.65854], [-121.46793, 38.65892], [-121.46641, 38.65943], [-121.46631, 38.65991], [-121.46611, 38.66], [-121.4661, 38.65939], [-121.46612, 38.65884], [-121.47039, 38.65736], [-121.47083, 38.65724], [-121.47124, 38.65718], [-121.47212, 38.65717], [-121.47402, 38.6572], [-121.47408, 38.65713], [-121.47429, 38.65715], [-121.47432, 38.65722], [-121.47435, 38.65723], [-121.47466, 38.65919]]]} | Open Access 1 | 22297 | Ueda Parkway | 9929 | 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 | http://www.cityofsacramento.org/parksandrecreation/parks/sites/ueda_parkway.htm | Sacramento 41 | 18.855 | Ueda Parkway | 0 | Local Recreation Area 3 | 4 |
3909 | 3909 | 3908 | {"type": "MultiPolygon", "coordinates": [[[[-121.40358, 38.44966], [-121.40323, 38.44988], [-121.40321, 38.44992], [-121.40314, 38.44992], [-121.40308, 38.44995], [-121.40305, 38.44999], [-121.40304, 38.45003], [-121.40298, 38.45003], [-121.40187, 38.45093], [-121.40186, 38.45097], [-121.40176, 38.45101], [-121.40172, 38.45108], [-121.40166, 38.45109], [-121.40142, 38.45128], [-121.4011, 38.45103], [-121.40134, 38.45084], [-121.40134, 38.45079], [-121.40144, 38.45076], [-121.40147, 38.45072], [-121.40148, 38.45068], [-121.40154, 38.45068], [-121.40272, 38.44975], [-121.40272, 38.4497], [-121.40282, 38.44966], [-121.40285, 38.44962], [-121.40286, 38.44959], [-121.40291, 38.44958], [-121.40325, 38.44934], [-121.40358, 38.44966]]], [[[-121.40435, 38.44886], [-121.4041, 38.44915], [-121.40398, 38.44968], [-121.40393, 38.4497], [-121.4036, 38.44935], [-121.40317, 38.44901], [-121.40321, 38.44897], [-121.4038, 38.44891], [-121.40417, 38.44871], [-121.40435, 38.44886]]]]} | Open Access 1 | 36023 | Fales Park | 18829 | 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.798 | Fales Park | 0 | Local Park 2 | 4 | |
4450 | 4450 | 4449 | {"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.49005, 38.58487], [-121.48986, 38.58482], [-121.49005, 38.58439], [-121.49051, 38.58452]]]} | Open Access 1 | 21120 | J. Neely Johnson Park | 20292 | 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.967 | J. Neely Johnson Park | 0 | Local Park 2 | 4 | |
4451 | 4451 | 4450 | {"type": "Polygon", "coordinates": [[[-121.47503, 38.58406], [-121.47465, 38.58494], [-121.47365, 38.58467], [-121.47404, 38.58379], [-121.47503, 38.58406]]]} | Open Access 1 | 21121 | Ulysses S. Grant Park | 26649 | 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.344 | Ulysses S. Grant Park | 0 | Local Park 2 | 4 | |
4452 | 4452 | 4451 | {"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.50531, 38.59133], [-121.50531, 38.59134], [-121.50604, 38.59333], [-121.50643, 38.59332], [-121.50642, 38.59372], [-121.50644, 38.59396], [-121.50648, 38.59414]]]} | Open Access 1 | 21122 | Jibboom Street Park | 20410 | 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.283 | Jibboom Street Park | 0 | Local Park 2 | 4 | |
4453 | 4453 | 4452 | {"type": "Polygon", "coordinates": [[[-121.44917, 38.58392], [-121.44878, 38.58454], [-121.448, 38.58423], [-121.44844, 38.58351], [-121.44894, 38.58377], [-121.44917, 38.58392]]]} | Open Access 1 | 21126 | River Park | 24418 | 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.582 | River Park | 0 | Local Park 2 | 4 | |
4454 | 4454 | 4453 | {"type": "Polygon", "coordinates": [[[-121.46704, 38.58193], [-121.46665, 38.58281], [-121.46646, 38.58276], [-121.46641, 38.58286], [-121.46554, 38.58263], [-121.46597, 38.58164], [-121.46704, 38.58193]]]} | Open Access 1 | 21128 | Leland Stanford Park | 21147 | 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.762 | Leland Stanford 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 | |
4461 | 4461 | 4460 | {"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 | 21138 | James W. Marshall Park | 20353 | 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.513 | James W. Marshall Park | 0 | Local Park 2 | 4 | |
4462 | 4462 | 4461 | {"type": "Polygon", "coordinates": [[[-121.49798, 38.57299], [-121.49759, 38.57389], [-121.49652, 38.5736], [-121.49691, 38.57271], [-121.49798, 38.57299]]]} | Open Access 1 | 21139 | Theodore Roosevelt Park | 26300 | 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.555 | Theodore Roosevelt Park | 0 | Local Park 2 | 4 | |
4796 | 4796 | 4795 | {"type": "Polygon", "coordinates": [[[-121.38313, 38.64166], [-121.38312, 38.64229], [-121.38237, 38.64219], [-121.38248, 38.64206], [-121.38216, 38.64167], [-121.38223, 38.64159], [-121.38189, 38.64137], [-121.38288, 38.64043], [-121.38306, 38.64097], [-121.38306, 38.64164], [-121.38313, 38.64166]]]} | No Public Access 3 | 48339 | Unnamed Site - Sacramento, City of | 32902 | 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.149 | 0 | Local Other or Unknown 14 | 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]);