units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
220 rows where MNG_AGENCY = 534 sorted by PARK_URL 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11073 | 11073 | 11072 | {"type": "Polygon", "coordinates": [[[-121.49612, 38.47412], [-121.4957, 38.47412], [-121.49569, 38.47406], [-121.49534, 38.47406], [-121.49534, 38.47373], [-121.49529, 38.47367], [-121.49522, 38.47363], [-121.49445, 38.47365], [-121.4944, 38.47363], [-121.49437, 38.47359], [-121.49437, 38.47308], [-121.49435, 38.47289], [-121.49436, 38.47286], [-121.49441, 38.47283], [-121.49467, 38.47279], [-121.49482, 38.47279], [-121.49491, 38.47272], [-121.49494, 38.47263], [-121.49518, 38.47266], [-121.49612, 38.47412]]]} | Open Access 1 | 21274 | LaVar Burton Park | 33228 | 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/South-Sacramento/LeVar-Burton-Park | Sacramento 41 | 3.151 | LaVar Burton Park | 2019 | 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 |
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 |
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 |
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 |
11025 | 11025 | 11024 | {"type": "MultiPolygon", "coordinates": [[[[-121.45673, 38.62431], [-121.45673, 38.62501], [-121.45639, 38.62499], [-121.4557, 38.62501], [-121.45533, 38.62505], [-121.45427, 38.62553], [-121.45334, 38.62588], [-121.44766, 38.62582], [-121.44766, 38.62491], [-121.44814, 38.62481], [-121.44854, 38.62477], [-121.44913, 38.62477], [-121.45093, 38.62501], [-121.45128, 38.62503], [-121.4519, 38.62501], [-121.45313, 38.62488], [-121.45314, 38.62485], [-121.45347, 38.62479], [-121.45367, 38.62471], [-121.45385, 38.62461], [-121.45401, 38.62449], [-121.45404, 38.62444], [-121.45415, 38.62434], [-121.45438, 38.62418], [-121.4546, 38.62405], [-121.45475, 38.62399], [-121.45501, 38.62391], [-121.45592, 38.6237], [-121.45641, 38.62361], [-121.45673, 38.62357], [-121.45673, 38.62431]]], [[[-121.44729, 38.625], [-121.44729, 38.62596], [-121.4464, 38.62624], [-121.44634, 38.62625], [-121.44628, 38.6261], [-121.44628, 38.62557], [-121.44629, 38.62543], [-121.44729, 38.625]]], [[[-121.44602, 38.62595], [-121.44601, 38.62596], [-121.44601, 38.62623], [-121.44593, 38.62642], [-121.4455, 38.6266], [-121.44535, 38.62665], [-121.44451, 38.62683], [-121.44409, 38.62705], [-121.44374, 38.62732], [-121.44346, 38.6275], [-121.44318, 38.62764], [-121.4429, 38.62774], [-121.44252, 38.62781], [-121.44242, 38.62782], [-121.44241, 38.62783], [-121.44206, 38.62787], [-121.44164, 38.62784], [-121.44164, 38.62722], [-121.4419, 38.62722], [-121.44221, 38.6272], [-121.44236, 38.62717], [-121.44253, 38.62713], [-121.44305, 38.62691], [-121.44323, 38.6268], [-121.44375, 38.62636], [-121.44395, 38.62624], [-121.44414, 38.62617], [-121.44491, 38.62604], [-121.44512, 38.62596], [-121.44597, 38.62557], [-121.44602, 38.62567], [-121.44602, 38.62595]]], [[[-121.44144, 38.6278], [-121.44088, 38.62773], [-121.44074, 38.62773], [-121.44052, 38.62776], [-121.4399, 38.62803], [-121.43989, 38.62805], [-121.43947, 38.62817], [-121.43924, 38.62822], [-121.43924, 38.62825], [-121.43876, 38.62833], [-121.43858, 38.62805], [-121.43834, 38.6281], [-121.43849, 38.62837], [-121.43793, 38.62843], [-121.4374, 38.62842], [-121.43669, 38.62838], [-121.43668, 38.62837], [-121.43651, 38.62835], [-121.4365, 38.62831], [-121.43618, 38.62826], [-121.43618, 38.62808], [-121.4337, 38.62751], [-121.43232, 38.62747], [-121.43244, 38.62719], [-121.43318, 38.62719], [-121.43389, 38.62726], [-121.43473, 38.62747], [-121.43486, 38.62752], [-121.43608, 38.62783], [-121.43632, 38.62787], [-121.43703, 38.62786], [-121.43704, 38.62785], [-121.43747, 38.62791], [-121.43781, 38.62791], [-121.43842, 38.62786], [-121.43887, 38.62776], [-121.43918, 38.62767], [-121.43944, 38.62757], [-121.44023, 38.62719], [-121.44043, 38.62714], [-121.44045, 38.62716], [-121.44077, 38.62714], [-121.44144, 38.6272], [-121.44144, 38.6278]]], [[[-121.46612, 38.65884], [-121.4661, 38.65939], [-121.46611, 38.65985], [-121.46604, 38.65988], [-121.46567, 38.65996], [-121.46496, 38.66027], [-121.46398, 38.66053], [-121.46276, 38.66085], [-121.46211, 38.66098], [-121.46164, 38.661], [-121.46113, 38.66126], [-121.46039, 38.66171], [-121.4593, 38.66245], [-121.45828, 38.663], [-121.45774, 38.66342], [-121.45719, 38.66373], [-121.45652, 38.66384], [-121.45571, 38.66368], [-121.45534, 38.66383], [-121.45448, 38.66478], [-121.45411, 38.66504], [-121.4535, 38.66517], [-121.45313, 38.66536], [-121.45265, 38.66589], [-121.45245, 38.66594], [-121.45176, 38.6671], [-121.45155, 38.66773], [-121.45097, 38.66816], [-121.45041, 38.66816], [-121.44965, 38.6681], [-121.44935, 38.66811], [-121.44936, 38.66696], [-121.45095, 38.66696], [-121.45129, 38.66678], [-121.45187, 38.66607], [-121.45221, 38.66538], [-121.45259, 38.66512], [-121.45323, 38.66485], [-121.45391, 38.66454], [-121.45435, 38.66417], [-121.45466, 38.66378], [-121.45503, 38.66351], [-121.45642, 38.6632], [-121.45659, 38.66286], [-121.4571, 38.66238], [-121.45778, 38.66216], [-121.45825, 38.66207], [-121.4587, 38.6619], [-121.46042, 38.66095], [-121.46153, 38.66051], [-121.46432, 38.65945], [-121.46612, 38.65884]]], [[[-121.48584, 38.68491], [-121.48432, 38.68491], [-121.48428, 38.67469], [-121.48407, 38.67458], [-121.47764, 38.67178], [-121.47749, 38.67085], [-121.47697, 38.67085], [-121.47565, 38.66401], [-121.47541, 38.66402], [-121.47435, 38.65723], [-121.47404, 38.65554], [-121.47339, 38.65223], [-121.47227, 38.64637], [-121.46891, 38.62863], [-121.46841, 38.62606], [-121.4674, 38.62064], [-121.46734, 38.62063], [-121.46729, 38.62071], [-121.46642, 38.62119], [-121.46531, 38.62187], [-121.46482, 38.62212], [-121.46414, 38.62244], [-121.46366, 38.62271], [-121.46322, 38.62289], [-121.46293, 38.62305], [-121.46264, 38.62316], [-121.46144, 38.62373], [-121.46098, 38.62391], [-121.46073, 38.62399], [-121.46026, 38.62419], [-121.46004, 38.62427], [-121.45986, 38.6244], [-121.45942, 38.62517], [-121.45934, 38.62525], [-121.45924, 38.62531], [-121.45884, 38.6254], [-121.45883, 38.62546], [-121.45871, 38.62551], [-121.4585, 38.62546], [-121.45719, 38.62503], [-121.45717, 38.62349], [-121.45778, 38.6235], [-121.45779, 38.62349], [-121.45834, 38.62348], [-121.45901, 38.62341], [-121.45947, 38.6233], [-121.46002, 38.62312], [-121.4602, 38.62305], [-121.46333, 38.62138], [-121.46688, 38.61945], [-121.4669, 38.6195], [-121.46717, 38.61943], [-121.46637, 38.61515], [-121.46604, 38.61328], [-121.466, 38.61294], [-121.46596, 38.61222], [-121.46599, 38.61114], [-121.46612, 38.61007], [-121.46629, 38.60912], [-121.46658, 38.60812], [-121.46682, 38.60742], [-121.46697, 38.60713], [-121.46713, 38.60673], [-121.46726, 38.60637], [-121.46753, 38.60592], [-121.46759, 38.60575], [-121.46833, 38.60539], [-121.46752, 38.60752], [-121.4672, 38.60846], [-121.46699, 38.60917], [-121.46689, 38.60958], [-121.46682, 38.61], [-121.46672, 38.61073], [-121.46669, 38.61123], [-121.46811, 38.61125], [-121.4681, 38.6119], [-121.46812, 38.61226], [-121.46818, 38.61261], [-121.47043, 38.62426], [-121.47083, 38.62607], [-121.47085, 38.62688], [-121.4715, 38.63026], [-121.46995, 38.63024], [-121.46994, 38.63026], [-121.46997, 38.63038], [-121.47151, 38.63038], [-121.47209, 38.63327], [-121.47327, 38.63939], [-121.47359, 38.64072], [-121.47325, 38.64098], [-121.47201, 38.64114], [-121.472, 38.64115], [-121.47208, 38.6416], [-121.47326, 38.64148], [-121.47374, 38.64166], [-121.4751, 38.64941], [-121.47499, 38.64942], [-121.47499, 38.64943], [-121.47611, 38.65515], [-121.47526, 38.65522], [-121.4747, 38.6553], [-121.47472, 38.65546], [-121.4753, 38.65538], [-121.47604, 38.65533], [-121.47707, 38.66058], [-121.47747, 38.66284], [-121.47756, 38.66322], [-121.47754, 38.66652], [-121.47798, 38.66954], [-121.4782, 38.67071], [-121.47825, 38.67084], [-121.47843, 38.67084], [-121.4786, 38.67117], [-121.47881, 38.67145], [-121.47902, 38.67164], [-121.47934, 38.67185], [-121.47958, 38.67197], [-121.48423, 38.67403], [-121.4846, 38.67422], [-121.4849, 38.67443], [-121.48516, 38.67468], [-121.48536, 38.67497], [-121.4855, 38.67523], [-121.48557, 38.67544], [-121.48561, 38.67567], [-121.48584, 38.68491]]]]} | Open Access 1 | 21117 | 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 | 475.439 | Ueda Parkway | 0 | Local Recreation Area 3 | 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 |
2665 | 2665 | 2664 | {"type": "Polygon", "coordinates": [[[-121.53615, 38.64507], [-121.53571, 38.64508], [-121.53503, 38.64517], [-121.53497, 38.64516], [-121.53493, 38.64514], [-121.5347, 38.6449], [-121.53466, 38.64487], [-121.53466, 38.64452], [-121.53611, 38.64454], [-121.53615, 38.64458], [-121.53615, 38.64507]]]} | Open Access 1 | 21058 | Sundance Park | 25987 | 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.989 | Sundance Park | 0 | Local Park 2 | 4 | |
2674 | 2674 | 2673 | {"type": "Polygon", "coordinates": [[[-121.53643, 38.60495], [-121.5364, 38.60499], [-121.53641, 38.60504], [-121.53643, 38.60509], [-121.53649, 38.60514], [-121.53653, 38.60523], [-121.53656, 38.60544], [-121.53661, 38.60557], [-121.53659, 38.60561], [-121.5363, 38.60571], [-121.53578, 38.60588], [-121.53557, 38.60592], [-121.53531, 38.60596], [-121.53528, 38.60562], [-121.53516, 38.60525], [-121.53586, 38.60506], [-121.53639, 38.60489], [-121.53643, 38.60495]]]} | Open Access 1 | 21111 | Shorebird Park | 25423 | 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 | Shorebird Park | 0 | Local Park 2 | 4 | |
2675 | 2675 | 2674 | {"type": "Polygon", "coordinates": [[[-121.51817, 38.60479], [-121.5172, 38.60577], [-121.51702, 38.60566], [-121.51683, 38.60557], [-121.51663, 38.6055], [-121.5164, 38.60546], [-121.51635, 38.60539], [-121.51626, 38.60539], [-121.51624, 38.60546], [-121.51483, 38.60563], [-121.51464, 38.60564], [-121.51449, 38.60563], [-121.51427, 38.6056], [-121.51409, 38.60555], [-121.51365, 38.60537], [-121.51361, 38.60531], [-121.51382, 38.60492], [-121.51392, 38.60467], [-121.51404, 38.60429], [-121.5141, 38.60395], [-121.5162, 38.60423], [-121.51815, 38.60453], [-121.51817, 38.60479]]]} | Open Access 1 | 21112 | Natomas Oaks Park | 22669 | 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 | 13.064 | Natomas Oaks Park | 0 | Local Park 2 | 4 | |
2676 | 2676 | 2675 | {"type": "Polygon", "coordinates": [[[-121.54546, 38.59936], [-121.54545, 38.59952], [-121.54517, 38.59959], [-121.54484, 38.59969], [-121.54458, 38.59979], [-121.54429, 38.59994], [-121.54083, 38.60212], [-121.54085, 38.60157], [-121.54092, 38.60144], [-121.54138, 38.60116], [-121.54185, 38.60075], [-121.54239, 38.60014], [-121.54291, 38.59938], [-121.54318, 38.59929], [-121.54346, 38.59928], [-121.54382, 38.59914], [-121.54408, 38.59894], [-121.54425, 38.59872], [-121.54453, 38.59892], [-121.54453, 38.59899], [-121.54482, 38.5989], [-121.54506, 38.59937], [-121.54546, 38.59936]]]} | Open Access 1 | 21113 | Sand Cove Park | 25011 | 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.844 | Sand Cove Park | 0 | Local Park 2 | 4 | |
2677 | 2677 | 2676 | {"type": "MultiPolygon", "coordinates": [[[[-121.50733, 38.59675], [-121.50729, 38.59681], [-121.50738, 38.5972], [-121.5074, 38.59761], [-121.50734, 38.59781], [-121.50723, 38.59811], [-121.50701, 38.59849], [-121.50643, 38.59867], [-121.50581, 38.59925], [-121.50554, 38.59901], [-121.50556, 38.59898], [-121.50513, 38.59848], [-121.5052, 38.59849], [-121.50527, 38.59847], [-121.50562, 38.59814], [-121.50573, 38.59807], [-121.50586, 38.59795], [-121.50595, 38.59773], [-121.50603, 38.59761], [-121.50614, 38.59752], [-121.50621, 38.5974], [-121.50633, 38.59728], [-121.5065, 38.59703], [-121.5066, 38.59676], [-121.50669, 38.59664], [-121.5069, 38.59658], [-121.50696, 38.59655], [-121.50697, 38.59646], [-121.50718, 38.59646], [-121.50733, 38.59675]]], [[[-121.50573, 38.59935], [-121.50523, 38.5996], [-121.50524, 38.59896], [-121.50539, 38.59909], [-121.50543, 38.59908], [-121.50573, 38.59935]]]]} | Open Access 1 | 21114 | Tiscornia Park | 26374 | 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.43 | Tiscornia 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 | |
2683 | 2683 | 2682 | {"type": "Polygon", "coordinates": [[[-121.50573, 38.5653], [-121.50536, 38.56616], [-121.50299, 38.56552], [-121.50337, 38.56466], [-121.50573, 38.5653]]]} | Open Access 1 | 21146 | O'Neil Field | 22952 | 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.437 | O'Neil Field | 0 | Local Recreation Area 3 | 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 | |
2701 | 2701 | 2700 | {"type": "Polygon", "coordinates": [[[-121.45446, 38.46679], [-121.45412, 38.46688], [-121.45281, 38.46727], [-121.45257, 38.46736], [-121.45202, 38.46639], [-121.45205, 38.46634], [-121.45383, 38.4655], [-121.45404, 38.46575], [-121.45425, 38.46607], [-121.45446, 38.46679]]]} | Open Access 1 | 21249 | Mesa Grande Park | 22173 | 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.291 | Mesa Grande 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 | |
2707 | 2707 | 2706 | {"type": "Polygon", "coordinates": [[[-121.52471, 38.66639], [-121.52415, 38.6664], [-121.52377, 38.66637], [-121.52105, 38.66592], [-121.52068, 38.66588], [-121.52038, 38.66587], [-121.52008, 38.66587], [-121.51964, 38.66591], [-121.51819, 38.66616], [-121.51766, 38.66622], [-121.51741, 38.66624], [-121.51736, 38.66621], [-121.51734, 38.66617], [-121.51722, 38.66618], [-121.51719, 38.66623], [-121.51713, 38.66625], [-121.51641, 38.66623], [-121.51587, 38.66617], [-121.51534, 38.66608], [-121.5141, 38.66582], [-121.51406, 38.66579], [-121.51404, 38.66573], [-121.51392, 38.66571], [-121.51388, 38.66574], [-121.51382, 38.66576], [-121.5132, 38.66564], [-121.51264, 38.66559], [-121.51005, 38.66559], [-121.50956, 38.66557], [-121.50921, 38.66554], [-121.50876, 38.66546], [-121.50825, 38.66534], [-121.50821, 38.66531], [-121.5082, 38.66528], [-121.50832, 38.66502], [-121.50852, 38.66467], [-121.50914, 38.66401], [-121.51124, 38.66184], [-121.51129, 38.66182], [-121.51135, 38.66183], [-121.51204, 38.6622], [-121.51203, 38.66197], [-121.5115, 38.66167], [-121.51147, 38.66165], [-121.51146, 38.66161], [-121.51175, 38.66121], [-121.51194, 38.66089], [-121.51207, 38.66062], [-121.5122, 38.66028], [-121.51228, 38.65993], [-121.51232, 38.65965], [-121.51234, 38.6593], [-121.51234, 38.65876], [-121.51237, 38.65871], [-121.51242, 38.6587], [-121.51335, 38.65877], [-121.51356, 38.65881], [-121.51386, 38.65889], [-121.51409, 38.65898], [-121.51427, 38.65908], [-121.51539, 38.65983], [-121.51565, 38.65997], [-121.51594, 38.66007], [-121.51618, 38.66013], [-121.51642, 38.66017], [-121.51677, 38.66017], [-121.51702, 38.66015], [-121.51726, 38.6601], [-121.51762, 38.65999], [-121.52123, 38.65832], [-121.52144, 38.65826], [-121.5216, 38.65826], [-121.52173, 38.65827], [-121.52202, 38.65836], [-121.52202, 38.65892], [-121.52197, 38.65932], [-121.52191, 38.65954], [-121.52183, 38.65976], [-121.52165, 38.66014], [-121.52183, 38.66047], [-121.52218, 38.66086], [-121.52241, 38.66106], [-121.52265, 38.66125], [-121.52311, 38.66155], [-121.52375, 38.66189], [-121.52412, 38.66215], [-121.52431, 38.66233], [-121.52449, 38.66256], [-121.52463, 38.66277], [-121.52473, 38.66299], [-121.52483, 38.66333], [-121.52486, 38.66368], [-121.52483, 38.664], [-121.52466, 38.66456], [-121.52462, 38.66488], [-121.52462, 38.66506], [-121.52465, 38.66527], [-121.52477, 38.6657], [-121.52476, 38.66579], [-121.52473, 38.66586], [-121.52475, 38.66613], [-121.52471, 38.66639]]]} | Open Access 1 | 21286 | North Natomas Regional Park | 22834 | 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 | 211.13 | North Natomas RP | 0 | Local Park 2 | 4 | |
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 |
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]);