units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
220 rows where MNG_AGENCY = 534 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: PARK_URL, YR_EST, GAP_STS
DES_TP 10
- Local Park 192
- Local Recreation Area 18
- Local Conservation Area 3
- Local Other or Unknown 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency 220
MNG_AGENCY 1
- Sacramento, City of · 220 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17028 | 17028 | 17027 | {"type": "Polygon", "coordinates": [[[-121.4802, 38.47983], [-121.48019, 38.48034], [-121.48016, 38.48082], [-121.48016, 38.48122], [-121.48014, 38.48126], [-121.48008, 38.48127], [-121.48008, 38.48132], [-121.47963, 38.48133], [-121.47962, 38.48127], [-121.47841, 38.48128], [-121.4784, 38.48134], [-121.47683, 38.48135], [-121.47683, 38.47983], [-121.4802, 38.47983]]]} | Open Access 1 | 21239 | Pannell / Meadowview Community Center Park | 23388 | 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.904 | Pannell / Meadowview Community Ctr. Park | 0 | Local Recreation Area 3 | 4 | |
17027 | 17027 | 17026 | {"type": "Polygon", "coordinates": [[[-121.51167, 38.52299], [-121.51127, 38.52385], [-121.51106, 38.52434], [-121.51102, 38.52436], [-121.50753, 38.52435], [-121.50683, 38.52435], [-121.50651, 38.52439], [-121.50624, 38.52446], [-121.50627, 38.52396], [-121.50634, 38.52347], [-121.5064, 38.52341], [-121.50646, 38.52338], [-121.50657, 38.52337], [-121.50664, 38.52341], [-121.5068, 38.52376], [-121.50686, 38.52383], [-121.50704, 38.52384], [-121.50716, 38.52382], [-121.50788, 38.52353], [-121.50803, 38.52351], [-121.50815, 38.52353], [-121.50816, 38.52389], [-121.50873, 38.52389], [-121.50874, 38.52388], [-121.50872, 38.52355], [-121.50877, 38.52349], [-121.50894, 38.52351], [-121.50924, 38.52359], [-121.50959, 38.5236], [-121.50977, 38.52349], [-121.50977, 38.52335], [-121.50983, 38.52313], [-121.50989, 38.5231], [-121.51084, 38.52326], [-121.51093, 38.52326], [-121.51108, 38.52321], [-121.51122, 38.5231], [-121.51127, 38.52299], [-121.51167, 38.52299]]]} | Open Access 1 | 21201 | Belle Cooledge Community Center Park | 15982 | 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.444 | Belle Cooledge Community Ctr. Park | 0 | Local Recreation Area 3 | 4 | |
16749 | 16749 | 16748 | {"type": "Polygon", "coordinates": [[[-121.44432, 38.44752], [-121.44402, 38.44743], [-121.44376, 38.44729], [-121.44143, 38.44517], [-121.44122, 38.44501], [-121.44097, 38.44484], [-121.4405, 38.44461], [-121.43876, 38.44396], [-121.43738, 38.44311], [-121.43728, 38.44316], [-121.43711, 38.44301], [-121.43685, 38.44284], [-121.43659, 38.44271], [-121.4363, 38.4426], [-121.43604, 38.44253], [-121.43581, 38.4425], [-121.43441, 38.4424], [-121.43404, 38.44235], [-121.43378, 38.44227], [-121.4336, 38.4422], [-121.43303, 38.44189], [-121.43274, 38.44176], [-121.43245, 38.44167], [-121.43207, 38.44161], [-121.43174, 38.4416], [-121.43117, 38.44162], [-121.43091, 38.44166], [-121.43065, 38.44173], [-121.43048, 38.44172], [-121.43014, 38.44175], [-121.42893, 38.44195], [-121.42871, 38.44197], [-121.42848, 38.44196], [-121.42828, 38.44192], [-121.42713, 38.44181], [-121.42536, 38.44167], [-121.42363, 38.43929], [-121.42337, 38.43899], [-121.42303, 38.43868], [-121.42265, 38.43842], [-121.42221, 38.43819], [-121.42171, 38.43801], [-121.42444, 38.43799], [-121.42551, 38.43985], [-121.42569, 38.44004], [-121.42591, 38.44018], [-121.42616, 38.44026], [-121.42659, 38.44032], [-121.42669, 38.44035], [-121.42677, 38.44035], [-121.43071, 38.44083], [-121.43156, 38.43987], [-121.43156, 38.43964], [-121.43139, 38.4395], [-121.4315, 38.43935], [-121.43154, 38.43917], [-121.43153, 38.43844], [-121.43154, 38.43836], [-121.43153, 38.43831], [-121.43149, 38.43827], [-121.43149, 38.43794], [-121.43614, 38.4379], [-121.43617, 38.44146], [-121.43814, 38.44147], [-121.43848, 38.44194], [-121.43862, 38.44206], [-121.43877, 38.44214], [-121.43878, 38.44232], [-121.43895, 38.44252], [-121.43909, 38.44264], [-121.43934, 38.44279], [-121.43959, 38.44287], [-121.43984, 38.44292], [-121.43993, 38.44296], [-121.44008, 38.44293], [-121.44102, 38.44293], [-121.44125, 38.44294], [-121.4415, 38.44301], [-121.44173, 38.44314], [-121.44189, 38.44328], [-121.44291, 38.44461], [-121.44299, 38.4447], [-121.44312, 38.44479], [-121.44324, 38.44485], [-121.44338, 38.44489], [-121.44361, 38.44492], [-121.44367, 38.44495], [-121.44365, 38.44546], [-121.44361, 38.44554], [-121.4436, 38.44558], [-121.44391, 38.4459], [-121.44431, 38.44623], [-121.44432, 38.44752]]]} | Open Access 1 | 21254 | North Laguna Creek Wildlife Area | 22828 | 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 | 111.625 | North Laguna Creek Wildlife Area | 0 | Local Conservation Area 4 | 2 | |
16367 | 16367 | 16366 | {"type": "MultiPolygon", "coordinates": [[[[-121.38138, 38.63987], [-121.38132, 38.64069], [-121.38048, 38.64048], [-121.3791, 38.64071], [-121.37843, 38.6411], [-121.37685, 38.64253], [-121.37584, 38.64298], [-121.37292, 38.64406], [-121.37237, 38.6445], [-121.37201, 38.6446], [-121.37165, 38.64452], [-121.37031, 38.64352], [-121.36696, 38.64393], [-121.36672, 38.64436], [-121.36645, 38.64449], [-121.36556, 38.64378], [-121.36557, 38.6436], [-121.36622, 38.64308], [-121.36644, 38.64294], [-121.36673, 38.64278], [-121.36723, 38.64256], [-121.36848, 38.64217], [-121.37178, 38.6412], [-121.37542, 38.64008], [-121.37779, 38.63927], [-121.38036, 38.6383], [-121.38138, 38.63987]]], [[[-121.40097, 38.63756], [-121.39996, 38.63792], [-121.39972, 38.63804], [-121.39941, 38.63824], [-121.39796, 38.63953], [-121.3966, 38.64082], [-121.39624, 38.64114], [-121.39557, 38.64167], [-121.39525, 38.64189], [-121.39447, 38.64233], [-121.39261, 38.64273], [-121.39227, 38.64182], [-121.39188, 38.64199], [-121.38973, 38.64316], [-121.38949, 38.64327], [-121.38921, 38.64338], [-121.38891, 38.64345], [-121.38835, 38.64354], [-121.38809, 38.64356], [-121.38806, 38.64359], [-121.38804, 38.64364], [-121.38779, 38.64362], [-121.38775, 38.6436], [-121.38738, 38.64354], [-121.38634, 38.64328], [-121.3862, 38.64322], [-121.38598, 38.6431], [-121.38591, 38.6431], [-121.38571, 38.64299], [-121.38567, 38.64295], [-121.38518, 38.64265], [-121.38486, 38.64252], [-121.38465, 38.64248], [-121.3842, 38.64244], [-121.3834, 38.64232], [-121.38341, 38.64166], [-121.38358, 38.64163], [-121.38363, 38.64095], [-121.38412, 38.63958], [-121.3842, 38.6394], [-121.38434, 38.63921], [-121.38487, 38.63866], [-121.38657, 38.63709], [-121.38786, 38.63673], [-121.38866, 38.63728], [-121.38859, 38.63753], [-121.38821, 38.6379], [-121.38805, 38.63812], [-121.38811, 38.63825], [-121.38824, 38.63837], [-121.38852, 38.63877], [-121.38849, 38.639], [-121.38839, 38.63929], [-121.388, 38.63972], [-121.38775, 38.63982], [-121.3875, 38.63999], [-121.38746, 38.64011], [-121.38749, 38.64026], [-121.38759, 38.64039], [-121.38784, 38.64051], [-121.38838, 38.64059], [-121.38942, 38.64064], [-121.38974, 38.64072], [-121.39015, 38.64075], [-121.39082, 38.64075], [-121.39146, 38.6407], [-121.39199, 38.64066], [-121.39247, 38.64056], [-121.39308, 38.64054], [-121.39444, 38.64055], [-121.39482, 38.6405], [-121.39524, 38.64033], [-121.39606, 38.64003], [-121.39645, 38.63969], [-121.39689, 38.63946], [-121.39721, 38.63917], [-121.3975, 38.63872], [-121.39804, 38.6384], [-121.39897, 38.63771], [-121.39945, 38.63746], [-121.39986, 38.63736], [-121.4004, 38.63744], [-121.40097, 38.63756]]]]} | Open Access 1 | 21262 | Del Paso Regional Park | 18046 | 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 | 188.665 | Del Paso RP | 0 | Local Park 2 | 4 | |
16366 | 16366 | 16365 | {"type": "Polygon", "coordinates": [[[-121.39984, 38.54573], [-121.39674, 38.54558], [-121.39674, 38.54595], [-121.3921, 38.54463], [-121.39237, 38.54404], [-121.39241, 38.53989], [-121.39266, 38.53987], [-121.40022, 38.53983], [-121.40183, 38.53972], [-121.40689, 38.53969], [-121.40688, 38.54052], [-121.40667, 38.54054], [-121.40662, 38.54524], [-121.40612, 38.54526], [-121.40609, 38.54695], [-121.40454, 38.54676], [-121.40324, 38.54663], [-121.402, 38.54655], [-121.40091, 38.54651], [-121.40091, 38.54601], [-121.40051, 38.546], [-121.40049, 38.54572], [-121.39984, 38.54573]]]} | Open Access 1 | 21165 | Granite Regional Park | 9807 | 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/granite_map.htm | Sacramento 41 | 209.846 | Granite RP | 0 | Local Park 2 | 4 |
16170 | 16170 | 16169 | {"type": "Polygon", "coordinates": [[[-121.46189, 38.5431], [-121.46127, 38.5431], [-121.46127, 38.54227], [-121.46073, 38.54226], [-121.46073, 38.54214], [-121.46126, 38.54214], [-121.46127, 38.5419], [-121.46189, 38.54189], [-121.46189, 38.5431]]]} | Open Access 1 | 21178 | Oak Park Open Space | 23005 | 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.96 | Oak Park OS | 0 | Local Recreation Area 3 | 4 | |
16169 | 16169 | 16168 | {"type": "Polygon", "coordinates": [[[-121.55005, 38.66466], [-121.54694, 38.6659], [-121.54689, 38.66578], [-121.54685, 38.66564], [-121.54679, 38.66557], [-121.54683, 38.66554], [-121.54681, 38.66549], [-121.5491, 38.66457], [-121.55005, 38.66416], [-121.55005, 38.66466]]]} | Open Access 1 | 21125 | Egret Park Open Space | 18469 | 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.605 | Egret Park OS | 0 | Local Recreation Area 3 | 4 | |
16168 | 16168 | 16167 | {"type": "Polygon", "coordinates": [[[-121.51824, 38.51159], [-121.5182, 38.51174], [-121.51816, 38.5118], [-121.51811, 38.51183], [-121.51788, 38.51178], [-121.51782, 38.5118], [-121.51776, 38.51185], [-121.51769, 38.51194], [-121.51766, 38.51207], [-121.51765, 38.51224], [-121.51778, 38.51238], [-121.51778, 38.51255], [-121.5176, 38.51306], [-121.51753, 38.51316], [-121.51741, 38.51329], [-121.51728, 38.51334], [-121.51711, 38.51334], [-121.51691, 38.51331], [-121.51659, 38.51334], [-121.51645, 38.5134], [-121.51629, 38.51343], [-121.51615, 38.51342], [-121.51608, 38.51339], [-121.51603, 38.51334], [-121.51599, 38.5133], [-121.5161, 38.51061], [-121.51603, 38.51034], [-121.51594, 38.50953], [-121.51557, 38.50957], [-121.51556, 38.5095], [-121.51595, 38.50945], [-121.516, 38.50921], [-121.51578, 38.50873], [-121.51597, 38.50872], [-121.51654, 38.50876], [-121.51675, 38.50876], [-121.51729, 38.50933], [-121.51746, 38.50944], [-121.51748, 38.50952], [-121.51763, 38.50978], [-121.51768, 38.5099], [-121.51778, 38.51001], [-121.51781, 38.51006], [-121.51779, 38.51017], [-121.51798, 38.51019], [-121.51806, 38.51027], [-121.51809, 38.51037], [-121.51809, 38.51047], [-121.51807, 38.51059], [-121.51799, 38.51066], [-121.518, 38.51069], [-121.51803, 38.51074], [-121.51797, 38.51087], [-121.51804, 38.51104], [-121.51801, 38.51115], [-121.51805, 38.5113], [-121.51824, 38.51159]]]} | Open Access 1 | 21077 | Joseph Reichmuth Park Open Space | 20499 | 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 | 18.866 | Joseph Reichmuth Park OS | 0 | Local Recreation Area 3 | 4 | |
15715 | 15715 | 15714 | {"type": "Polygon", "coordinates": [[[-121.41975, 38.62346], [-121.4198, 38.62372], [-121.41981, 38.62399], [-121.41977, 38.62426], [-121.41968, 38.62453], [-121.41958, 38.62472], [-121.41944, 38.62492], [-121.41881, 38.62563], [-121.40843, 38.63518], [-121.40815, 38.63532], [-121.40714, 38.63543], [-121.40592, 38.63611], [-121.40545, 38.6363], [-121.40506, 38.63644], [-121.40444, 38.63661], [-121.40337, 38.63678], [-121.40288, 38.6369], [-121.40098, 38.63755], [-121.4004, 38.63744], [-121.39986, 38.63736], [-121.39945, 38.63746], [-121.39897, 38.63771], [-121.39804, 38.6384], [-121.3975, 38.63872], [-121.39721, 38.63917], [-121.39689, 38.63946], [-121.39644, 38.63969], [-121.39606, 38.64003], [-121.39524, 38.64033], [-121.39482, 38.6405], [-121.39444, 38.64055], [-121.39308, 38.64054], [-121.39247, 38.64056], [-121.39199, 38.64066], [-121.39146, 38.6407], [-121.39082, 38.64075], [-121.39015, 38.64075], [-121.38974, 38.64072], [-121.38942, 38.64064], [-121.38838, 38.64059], [-121.38784, 38.64051], [-121.38759, 38.64039], [-121.38749, 38.64026], [-121.38746, 38.64011], [-121.3875, 38.63999], [-121.38775, 38.63982], [-121.388, 38.63972], [-121.38839, 38.63929], [-121.38849, 38.639], [-121.38852, 38.63878], [-121.38824, 38.63837], [-121.38811, 38.63825], [-121.38805, 38.63812], [-121.38821, 38.6379], [-121.38859, 38.63753], [-121.38866, 38.63728], [-121.38786, 38.63673], [-121.38864, 38.63583], [-121.38938, 38.63532], [-121.39025, 38.63492], [-121.39709, 38.6323], [-121.39865, 38.63406], [-121.39906, 38.63434], [-121.39973, 38.63413], [-121.40058, 38.63399], [-121.40101, 38.63387], [-121.40159, 38.6336], [-121.4014, 38.63335], [-121.4013, 38.63319], [-121.40123, 38.633], [-121.4012, 38.63276], [-121.40121, 38.63258], [-121.40125, 38.6324], [-121.4015, 38.63185], [-121.40152, 38.63171], [-121.40153, 38.63152], [-121.40182, 38.63153], [-121.40428, 38.62982], [-121.40454, 38.62967], [-121.40525, 38.6293], [-121.40598, 38.62895], [-121.4106, 38.62717], [-121.41287, 38.62613], [-121.41367, 38.6258], [-121.4179, 38.62414], [-121.41858, 38.62384], [-121.41921, 38.62353], [-121.41975, 38.62346]]]} | Restricted Access 2 | 34932 | Haggin Oaks Golf Course | 33101 | 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 | 407.841 | Haggin Oaks GC | 0 | Local Recreation Area 3 | 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 |
14674 | 14674 | 14673 | {"type": "Polygon", "coordinates": [[[-121.5578, 38.65543], [-121.55595, 38.65546], [-121.55593, 38.65492], [-121.55599, 38.65492], [-121.55604, 38.65499], [-121.55611, 38.65503], [-121.55632, 38.65504], [-121.55638, 38.65503], [-121.55644, 38.65499], [-121.55649, 38.65494], [-121.5565, 38.65489], [-121.55648, 38.65446], [-121.55643, 38.65405], [-121.55633, 38.65365], [-121.55621, 38.65325], [-121.55595, 38.65267], [-121.55548, 38.65187], [-121.55526, 38.65142], [-121.55486, 38.65042], [-121.5548, 38.6502], [-121.55477, 38.64995], [-121.55469, 38.64975], [-121.55457, 38.64959], [-121.55441, 38.64946], [-121.55427, 38.64938], [-121.55407, 38.64929], [-121.55396, 38.64921], [-121.55387, 38.64911], [-121.55382, 38.64901], [-121.5538, 38.64891], [-121.5538, 38.6488], [-121.55395, 38.64848], [-121.55398, 38.64826], [-121.55396, 38.64769], [-121.55393, 38.64752], [-121.55384, 38.64732], [-121.55333, 38.64648], [-121.55242, 38.64482], [-121.55236, 38.64477], [-121.55228, 38.64475], [-121.5522, 38.64476], [-121.55205, 38.64481], [-121.552, 38.64485], [-121.55196, 38.6449], [-121.55196, 38.64494], [-121.55197, 38.645], [-121.55192, 38.64502], [-121.55163, 38.64479], [-121.55185, 38.64462], [-121.55194, 38.64452], [-121.55201, 38.64437], [-121.55204, 38.64422], [-121.55201, 38.64405], [-121.55187, 38.64377], [-121.55178, 38.64364], [-121.55165, 38.64352], [-121.55141, 38.6434], [-121.55044, 38.64309], [-121.55027, 38.643], [-121.55022, 38.64299], [-121.55015, 38.643], [-121.55009, 38.64304], [-121.55005, 38.64313], [-121.5499, 38.64332], [-121.54975, 38.64346], [-121.54958, 38.64358], [-121.54937, 38.64369], [-121.54921, 38.64375], [-121.549, 38.6438], [-121.5488, 38.64383], [-121.54843, 38.64384], [-121.5482, 38.64381], [-121.54801, 38.64377], [-121.54765, 38.64362], [-121.54733, 38.64343], [-121.54724, 38.64336], [-121.54713, 38.64334], [-121.54705, 38.64337], [-121.547, 38.64344], [-121.54692, 38.64351], [-121.54636, 38.64384], [-121.5459, 38.64417], [-121.54571, 38.64427], [-121.54544, 38.64432], [-121.54433, 38.64434], [-121.54408, 38.64439], [-121.54399, 38.64436], [-121.54382, 38.64412], [-121.54359, 38.6439], [-121.54336, 38.64375], [-121.54305, 38.6436], [-121.54074, 38.64294], [-121.54036, 38.64288], [-121.53986, 38.64287], [-121.53984, 38.64283], [-121.53984, 38.64233], [-121.54182, 38.643], [-121.54315, 38.64333], [-121.54372, 38.64357], [-121.54509, 38.64385], [-121.54629, 38.6436], [-121.54632, 38.64308], [-121.54656, 38.64288], [-121.54706, 38.64294], [-121.54799, 38.64325], [-121.54852, 38.64336], [-121.54913, 38.64326], [-121.54949, 38.64294], [-121.5498, 38.64235], [-121.55017, 38.64227], [-121.55094, 38.6425], [-121.5522, 38.64321], [-121.5531, 38.6451], [-121.5538, 38.64639], [-121.5547, 38.64791], [-121.5545, 38.64835], [-121.55498, 38.64935], [-121.55531, 38.65028], [-121.55584, 38.65162], [-121.55617, 38.65217], [-121.55665, 38.6529], [-121.5568, 38.65357], [-121.55703, 38.65396], [-121.5578, 38.65543]]]} | Open Access 1 | 44944 | Fisherman's Lake Parkway and Open Space | 18922 | 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 | 33.711 | Fisherman's Lake Parkway and OS | 0 | Local Recreation Area 3 | 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 | |
14212 | 14212 | 14211 | {"type": "Polygon", "coordinates": [[[-121.49653, 38.54876], [-121.49596, 38.55049], [-121.49243, 38.54982], [-121.49273, 38.54884], [-121.493, 38.54889], [-121.4931, 38.54873], [-121.49326, 38.54876], [-121.49334, 38.54854], [-121.49353, 38.54857], [-121.49363, 38.54821], [-121.49653, 38.54876]]]} | Restricted Access 2 | 44078 | McClatchy School Park | 21999 | 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 | 14.624 | McClatchy School 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 | |
13665 | 13665 | 13664 | {"type": "Polygon", "coordinates": [[[-121.51621, 38.53667], [-121.51548, 38.53708], [-121.51409, 38.53819], [-121.51411, 38.53822], [-121.51315, 38.53912], [-121.51236, 38.54029], [-121.51175, 38.54103], [-121.51167, 38.54115], [-121.51161, 38.54114], [-121.51156, 38.54127], [-121.5113, 38.54174], [-121.51126, 38.54192], [-121.51118, 38.5421], [-121.51111, 38.54232], [-121.51083, 38.54287], [-121.51059, 38.54344], [-121.51055, 38.54362], [-121.51054, 38.54384], [-121.51047, 38.54423], [-121.51048, 38.54436], [-121.51045, 38.54454], [-121.51046, 38.54484], [-121.51054, 38.54526], [-121.51054, 38.54538], [-121.5105, 38.54548], [-121.51051, 38.54555], [-121.51053, 38.54563], [-121.51059, 38.54571], [-121.51067, 38.54603], [-121.51066, 38.54613], [-121.5106, 38.54622], [-121.51073, 38.54632], [-121.51076, 38.54636], [-121.51078, 38.54648], [-121.51086, 38.54676], [-121.51088, 38.54703], [-121.51098, 38.54723], [-121.51104, 38.54753], [-121.51103, 38.54759], [-121.51095, 38.54764], [-121.51085, 38.54763], [-121.51078, 38.54757], [-121.5107, 38.54754], [-121.51048, 38.54752], [-121.51041, 38.54755], [-121.5103, 38.54764], [-121.51034, 38.54794], [-121.51041, 38.54828], [-121.5105, 38.54851], [-121.51074, 38.54849], [-121.51072, 38.54793], [-121.51114, 38.54779], [-121.51175, 38.54909], [-121.51176, 38.54917], [-121.51176, 38.54926], [-121.51177, 38.5493], [-121.51179, 38.54932], [-121.51186, 38.54931], [-121.51193, 38.54954], [-121.51201, 38.54996], [-121.51191, 38.55041], [-121.51191, 38.55056], [-121.51194, 38.55064], [-121.51201, 38.55071], [-121.51221, 38.55081], [-121.51231, 38.55089], [-121.51237, 38.55097], [-121.5124, 38.55105], [-121.51254, 38.55165], [-121.51257, 38.55203], [-121.5126, 38.55213], [-121.5127, 38.5523], [-121.51274, 38.55241], [-121.51278, 38.55279], [-121.51307, 38.55344], [-121.51323, 38.55394], [-121.51339, 38.55419], [-121.5134, 38.55431], [-121.51362, 38.55502], [-121.51369, 38.55533], [-121.5139, 38.55594], [-121.51392, 38.55606], [-121.51398, 38.55618], [-121.51408, 38.55658], [-121.51421, 38.55687], [-121.51426, 38.55714], [-121.51431, 38.55723], [-121.51438, 38.55743], [-121.51444, 38.55749], [-121.51446, 38.55756], [-121.51429, 38.55754], [-121.51428, 38.55756], [-121.51446, 38.55808], [-121.51476, 38.55866], [-121.51468, 38.55865], [-121.51467, 38.55866], [-121.51491, 38.55911], [-121.51466, 38.55917], [-121.51418, 38.55818], [-121.51385, 38.55738], [-121.51371, 38.55697], [-121.51354, 38.55635], [-121.51323, 38.55533], [-121.513, 38.55454], [-121.51268, 38.55367], [-121.51232, 38.55289], [-121.51149, 38.55139], [-121.51101, 38.55044], [-121.51065, 38.54957], [-121.51024, 38.54848], [-121.5101, 38.54796], [-121.51003, 38.54762], [-121.51001, 38.54721], [-121.51003, 38.54681], [-121.50998, 38.54643], [-121.50994, 38.54622], [-121.50987, 38.54601], [-121.50978, 38.5458], [-121.50966, 38.54558], [-121.50969, 38.54514], [-121.50971, 38.54516], [-121.50972, 38.54515], [-121.50968, 38.54493], [-121.50967, 38.5446], [-121.50972, 38.54423], [-121.50983, 38.54392], [-121.51135, 38.54107], [-121.5113, 38.54104], [-121.51147, 38.54082], [-121.5115, 38.54082], [-121.5121, 38.54011], [-121.51245, 38.53953], [-121.5128, 38.53904], [-121.51443, 38.53752], [-121.51488, 38.53719], [-121.51533, 38.53693], [-121.51587, 38.53642], [-121.51621, 38.53667]]]} | Open Access 1 | 36030 | Sacramento River Parkway Land Park Area | 24772 | 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 | 33.337 | Sacramento River Parkway Land Park Area | None 1175 | |||
13661 | 13661 | 13660 | {"type": "Polygon", "coordinates": [[[-121.48467, 38.63479], [-121.48396, 38.63479], [-121.48395, 38.63064], [-121.4839, 38.62766], [-121.48398, 38.62738], [-121.48398, 38.62447], [-121.48392, 38.6202], [-121.48391, 38.61572], [-121.48158, 38.60961], [-121.48066, 38.60731], [-121.48155, 38.60756], [-121.48223, 38.60934], [-121.48292, 38.60918], [-121.48295, 38.61127], [-121.48461, 38.61565], [-121.4846, 38.62039], [-121.48463, 38.62196], [-121.48465, 38.63205], [-121.48467, 38.63479]]]} | Open Access 1 | 36027 | Ninos Parkway | 22764 | 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 | 47.816 | Ninos Parkway | 0 | Local Recreation Area 3 | 4 | |
13660 | 13660 | 13659 | {"type": "MultiPolygon", "coordinates": [[[[-121.50422, 38.61644], [-121.50421, 38.61606], [-121.50427, 38.6151], [-121.50376, 38.61442], [-121.50357, 38.61436], [-121.50332, 38.61406], [-121.50336, 38.61375], [-121.50361, 38.61361], [-121.50363, 38.61358], [-121.50374, 38.61358], [-121.5038, 38.61353], [-121.50424, 38.61352], [-121.50418, 38.61324], [-121.50408, 38.61312], [-121.50394, 38.61304], [-121.50383, 38.61292], [-121.50482, 38.61296], [-121.5049, 38.61299], [-121.50491, 38.61302], [-121.50489, 38.6134], [-121.50491, 38.61364], [-121.50496, 38.61384], [-121.50509, 38.61422], [-121.50515, 38.61442], [-121.50518, 38.61467], [-121.50519, 38.61495], [-121.50524, 38.61523], [-121.50533, 38.61551], [-121.50542, 38.61569], [-121.50558, 38.61595], [-121.50579, 38.61619], [-121.5058, 38.61621], [-121.50577, 38.61626], [-121.50565, 38.61635], [-121.50551, 38.6164], [-121.5054, 38.61643], [-121.50422, 38.61644]]], [[[-121.50603, 38.61927], [-121.50594, 38.61935], [-121.5059, 38.61944], [-121.50591, 38.6199], [-121.50594, 38.61998], [-121.50601, 38.62004], [-121.50599, 38.62007], [-121.50599, 38.62064], [-121.50591, 38.6207], [-121.50587, 38.6208], [-121.50588, 38.62085], [-121.50591, 38.62093], [-121.50591, 38.62118], [-121.50589, 38.6212], [-121.50585, 38.62122], [-121.50558, 38.62121], [-121.50558, 38.62063], [-121.50556, 38.62059], [-121.50562, 38.62053], [-121.50566, 38.62046], [-121.50566, 38.61997], [-121.50563, 38.61989], [-121.50554, 38.61982], [-121.50556, 38.6198], [-121.50556, 38.61926], [-121.50553, 38.61923], [-121.50559, 38.61918], [-121.50562, 38.61911], [-121.50562, 38.61862], [-121.50559, 38.61855], [-121.50551, 38.61849], [-121.50542, 38.61847], [-121.50522, 38.61847], [-121.50519, 38.6182], [-121.50508, 38.61819], [-121.50508, 38.61793], [-121.50517, 38.61793], [-121.50523, 38.61789], [-121.50526, 38.61783], [-121.50524, 38.61777], [-121.50544, 38.61755], [-121.5054, 38.61746], [-121.50484, 38.61717], [-121.50487, 38.61711], [-121.50487, 38.61705], [-121.5048, 38.61691], [-121.50477, 38.61678], [-121.50477, 38.61664], [-121.50481, 38.61659], [-121.5052, 38.61658], [-121.5052, 38.61685], [-121.50544, 38.61692], [-121.5058, 38.61712], [-121.50577, 38.61717], [-121.50578, 38.61722], [-121.50587, 38.61731], [-121.5059, 38.61738], [-121.5059, 38.61853], [-121.50594, 38.61862], [-121.50603, 38.61868], [-121.50602, 38.61924], [-121.50603, 38.61927]]], [[[-121.50593, 38.62452], [-121.50574, 38.62452], [-121.50568, 38.62449], [-121.50567, 38.62409], [-121.50564, 38.62402], [-121.50556, 38.62396], [-121.50557, 38.62394], [-121.50557, 38.62339], [-121.50556, 38.62337], [-121.50563, 38.62331], [-121.50567, 38.62322], [-121.50567, 38.62276], [-121.50564, 38.62269], [-121.50557, 38.62264], [-121.50559, 38.62261], [-121.50559, 38.62232], [-121.50559, 38.62205], [-121.50557, 38.62202], [-121.50563, 38.62197], [-121.50566, 38.62191], [-121.50567, 38.62144], [-121.50569, 38.62141], [-121.50573, 38.6214], [-121.50591, 38.62142], [-121.50593, 38.62452]]], [[[-121.5058, 38.62731], [-121.50574, 38.6273], [-121.5057, 38.62725], [-121.50569, 38.62622], [-121.50566, 38.62615], [-121.50558, 38.62608], [-121.50559, 38.62606], [-121.50559, 38.6255], [-121.50557, 38.62548], [-121.50564, 38.62542], [-121.50568, 38.62536], [-121.50568, 38.62473], [-121.5057, 38.62469], [-121.50575, 38.62467], [-121.50578, 38.62467], [-121.5058, 38.62731]]]]} | Open Access 1 | 36026 | Bannon Creek Parkway | 15800 | 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 | 18.591 | Bannon Creek Parkway | 0 | Local Recreation Area 3 | 4 | |
13659 | 13659 | 13658 | {"type": "Polygon", "coordinates": [[[-121.42447, 38.441], [-121.42427, 38.44108], [-121.4241, 38.44111], [-121.42304, 38.44103], [-121.42281, 38.44122], [-121.4226, 38.44135], [-121.42233, 38.44147], [-121.4221, 38.44152], [-121.42195, 38.44149], [-121.42175, 38.44139], [-121.42124, 38.44106], [-121.42109, 38.44103], [-121.42096, 38.44104], [-121.42084, 38.44107], [-121.42063, 38.44118], [-121.4202, 38.44142], [-121.41979, 38.44174], [-121.41976, 38.44175], [-121.41971, 38.44174], [-121.41911, 38.44137], [-121.41894, 38.44131], [-121.41871, 38.44158], [-121.41854, 38.44171], [-121.41828, 38.44184], [-121.418, 38.44191], [-121.41759, 38.44267], [-121.41759, 38.4429], [-121.41749, 38.4429], [-121.41748, 38.44285], [-121.41745, 38.44282], [-121.41736, 38.44279], [-121.41729, 38.4428], [-121.4172, 38.44286], [-121.41714, 38.44288], [-121.4153, 38.44286], [-121.41524, 38.44283], [-121.41523, 38.44274], [-121.41508, 38.44292], [-121.41501, 38.44293], [-121.41501, 38.44335], [-121.41399, 38.44336], [-121.41327, 38.44342], [-121.41121, 38.44344], [-121.41093, 38.44348], [-121.40932, 38.44348], [-121.40906, 38.44363], [-121.40901, 38.44362], [-121.40897, 38.44363], [-121.40879, 38.44356], [-121.40872, 38.44357], [-121.40872, 38.44297], [-121.40873, 38.44301], [-121.40877, 38.44305], [-121.40886, 38.44307], [-121.40893, 38.44306], [-121.40897, 38.44303], [-121.40935, 38.44293], [-121.40975, 38.4429], [-121.40985, 38.44293], [-121.40999, 38.44289], [-121.41014, 38.44289], [-121.41037, 38.44292], [-121.41066, 38.44301], [-121.41089, 38.44305], [-121.41094, 38.44307], [-121.41115, 38.44307], [-121.4112, 38.44306], [-121.41215, 38.44305], [-121.41245, 38.44302], [-121.41295, 38.44286], [-121.41322, 38.44281], [-121.41411, 38.4428], [-121.41423, 38.44282], [-121.41431, 38.44281], [-121.4144, 38.44276], [-121.41442, 38.44269], [-121.4146, 38.44269], [-121.41475, 38.44257], [-121.41509, 38.44241], [-121.41524, 38.44242], [-121.41529, 38.44244], [-121.41585, 38.44235], [-121.41592, 38.44219], [-121.41597, 38.44212], [-121.41604, 38.44207], [-121.41615, 38.44203], [-121.41615, 38.44165], [-121.41758, 38.44165], [-121.418, 38.44119], [-121.41806, 38.44117], [-121.41811, 38.44112], [-121.4182, 38.44078], [-121.41824, 38.44073], [-121.4183, 38.44071], [-121.41856, 38.4407], [-121.41878, 38.44086], [-121.41922, 38.44072], [-121.41963, 38.44066], [-121.41979, 38.4404], [-121.41997, 38.44031], [-121.42003, 38.44031], [-121.42008, 38.44033], [-121.42035, 38.44052], [-121.42045, 38.44065], [-121.42109, 38.44061], [-121.42135, 38.44062], [-121.42256, 38.44068], [-121.42405, 38.4408], [-121.42411, 38.44079], [-121.42427, 38.44072], [-121.42447, 38.441]]]} | Open Access 1 | 36035 | Jacinto Creek Parkway | 20299 | 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 | 24.716 | Jacinto Creek Parkway | 0 | Local Recreation Area 3 | 4 | |
13644 | 13644 | 13643 | {"type": "MultiPolygon", "coordinates": [[[[-121.44956, 38.5861], [-121.44954, 38.5864], [-121.44955, 38.58802], [-121.44936, 38.58792], [-121.4492, 38.58787], [-121.44913, 38.58782], [-121.44894, 38.58773], [-121.44885, 38.58766], [-121.4487, 38.58762], [-121.44846, 38.58746], [-121.4483, 38.5874], [-121.44784, 38.58717], [-121.4482, 38.58685], [-121.44865, 38.58653], [-121.44913, 38.58628], [-121.44956, 38.5861]]], [[[-121.46355, 38.58344], [-121.46215, 38.58683], [-121.46184, 38.58692], [-121.46141, 38.58712], [-121.46114, 38.58726], [-121.46079, 38.58738], [-121.46041, 38.58758], [-121.46024, 38.58765], [-121.45999, 38.58773], [-121.45976, 38.58783], [-121.45965, 38.5879], [-121.45951, 38.58792], [-121.45935, 38.58799], [-121.45887, 38.58812], [-121.45856, 38.58826], [-121.45831, 38.58832], [-121.45816, 38.58841], [-121.45787, 38.58852], [-121.45762, 38.58859], [-121.45712, 38.58871], [-121.45676, 38.58886], [-121.45656, 38.58889], [-121.45634, 38.58902], [-121.45611, 38.58907], [-121.4558, 38.58918], [-121.45557, 38.58921], [-121.45536, 38.58927], [-121.45514, 38.58926], [-121.45503, 38.58927], [-121.45478, 38.58938], [-121.45421, 38.5894], [-121.45392, 38.58948], [-121.45354, 38.58946], [-121.45327, 38.58955], [-121.45241, 38.58956], [-121.45215, 38.58947], [-121.45183, 38.58944], [-121.45163, 38.58929], [-121.45135, 38.5898], [-121.45077, 38.58953], [-121.45073, 38.58877], [-121.45066, 38.58876], [-121.45063, 38.58827], [-121.45067, 38.5878], [-121.45113, 38.58571], [-121.45191, 38.58557], [-121.45271, 38.58546], [-121.45391, 38.58533], [-121.45575, 38.58518], [-121.45829, 38.58509], [-121.45864, 38.58506], [-121.45907, 38.58501], [-121.45958, 38.5849], [-121.45999, 38.58477], [-121.46046, 38.58459], [-121.46091, 38.58437], [-121.46132, 38.58411], [-121.4617, 38.58382], [-121.46203, 38.5835], [-121.46236, 38.58311], [-121.46355, 38.58344]]]]} | Open Access 1 | 36002 | Sutters Landing Regional Park | 26087 | 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 | 108.631 | Sutters Landing RP | 0 | Local Park 2 | 4 | |
13165 | 13165 | 13164 | {"type": "Polygon", "coordinates": [[[-121.51037, 38.57485], [-121.50985, 38.57539], [-121.50935, 38.57602], [-121.50931, 38.57602], [-121.509, 38.57653], [-121.50884, 38.57687], [-121.50862, 38.57681], [-121.5094, 38.57517], [-121.50959, 38.57464], [-121.51037, 38.57485]]]} | Open Access 1 | 48822 | Pioneer Landing Park | 33541 | 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/Pioneer-Landing | Sacramento 41 | 2.346 | Pioneer Landing 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]);