units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
220 rows where AGNCY_LEV = 2 and MNG_AGENCY = 534 sorted by GAP_STS
This data as json, copyable, CSV (advanced)
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2708 | 2708 | 2707 | {"type": "Polygon", "coordinates": [[[-121.49106, 38.57115], [-121.49087, 38.57158], [-121.49048, 38.57147], [-121.49066, 38.57105], [-121.49106, 38.57115]]]} | Open Access 1 | 21287 | Fremont Community Garden | 19097 | 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.453 | Fremont Community Garden | 0 | Local Park 2 | 4 | |
3060 | 3060 | 3059 | {"type": "Polygon", "coordinates": [[[-121.45678, 38.62592], [-121.45678, 38.62592], [-121.45334, 38.62588], [-121.45427, 38.62553], [-121.45533, 38.62505], [-121.4557, 38.62501], [-121.45639, 38.62499], [-121.45673, 38.62501], [-121.45678, 38.62592]]]} | Open Access 1 | 21082 | Gateway Park | 19239 | 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.014 | Gateway Park | 0 | Local Park 2 | 4 | |
3063 | 3063 | 3062 | {"type": "Polygon", "coordinates": [[[-121.44839, 38.60939], [-121.44839, 38.60953], [-121.44794, 38.60953], [-121.44795, 38.60939], [-121.44839, 38.60939]]]} | Open Access 1 | 21124 | Dixieanne Tot Lot | 18171 | 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.152 | Dixieanne Tot Lot | 0 | Local Recreation Area 3 | 4 | |
3064 | 3064 | 3063 | {"type": "Polygon", "coordinates": [[[-121.48248, 38.58238], [-121.4821, 38.58326], [-121.48143, 38.58308], [-121.48181, 38.5822], [-121.48248, 38.58238]]]} | Open Access 1 | 21127 | Washington Park | 27279 | 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.583 | Washington Park | 0 | Local Park 2 | 4 | |
3065 | 3065 | 3064 | {"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 | 21159 | Greenfair Park | 19476 | 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.599 | Greenfair Park | 0 | Local Park 2 | 4 | |
3066 | 3066 | 3065 | {"type": "Polygon", "coordinates": [[[-121.41515, 38.51494], [-121.41466, 38.51496], [-121.41407, 38.51503], [-121.41356, 38.51513], [-121.41332, 38.51521], [-121.41296, 38.51529], [-121.41284, 38.5153], [-121.41283, 38.51274], [-121.41469, 38.51273], [-121.4147, 38.51291], [-121.41515, 38.51292], [-121.41515, 38.51494]]]} | Open Access 1 | 21208 | George Sim Park | 19273 | 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.774 | George Sim Park | 0 | Local Park 2 | 4 | |
3067 | 3067 | 3066 | {"type": "Polygon", "coordinates": [[[-121.41932, 38.54467], [-121.41929, 38.54649], [-121.41847, 38.54648], [-121.41702, 38.54466], [-121.41932, 38.54467]]]} | Open Access 1 | 21168 | Tahoe Tallac Park | 26168 | 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.775 | Tahoe Tallac 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 | |
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 | |
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 |
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]);