units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
220 rows where MNG_AGENCY = 534 sorted by DES_TP descending
This data as json, copyable, CSV (advanced)
Suggested facets: PARK_URL, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
11029 | 11029 | 11028 | {"type": "Polygon", "coordinates": [[[-121.51491, 38.5236], [-121.51465, 38.5244], [-121.51462, 38.52444], [-121.51421, 38.52441], [-121.513, 38.5244], [-121.51288, 38.52318], [-121.51325, 38.52319], [-121.51337, 38.52321], [-121.51388, 38.5234], [-121.51491, 38.5236]]]} | Open Access 1 | 21202 | Bell Cooledge Park (south) | 15972 | 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.601 | Bell Cooledge Park (south) | None 960 | |||
10997 | 10997 | 10996 | {"type": "Polygon", "coordinates": [[[-121.51392, 38.63205], [-121.51336, 38.63205], [-121.51335, 38.63264], [-121.5129, 38.63264], [-121.51246, 38.63303], [-121.51246, 38.63319], [-121.50842, 38.63319], [-121.50831, 38.63318], [-121.50821, 38.63312], [-121.50813, 38.6331], [-121.50804, 38.63313], [-121.508, 38.63319], [-121.50812, 38.63272], [-121.5082, 38.63249], [-121.50841, 38.63205], [-121.50864, 38.63169], [-121.50884, 38.63142], [-121.50919, 38.63103], [-121.5096, 38.63068], [-121.50997, 38.6304], [-121.51355, 38.63043], [-121.51356, 38.63051], [-121.5139, 38.63052], [-121.51392, 38.63205]]]} | Open Access 1 | 21066 | Tanzanite Community Park (basin 6A) | 26182 | 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 | 31.878 | Tanzanite Community Park (basin 6A) | None 959 | |||
10990 | 10990 | 10989 | {"type": "Polygon", "coordinates": [[[-121.50807, 38.65056], [-121.5089, 38.65056], [-121.50903, 38.6506], [-121.50914, 38.65069], [-121.50921, 38.6508], [-121.50932, 38.6511], [-121.50937, 38.65132], [-121.50943, 38.65145], [-121.5095, 38.65157], [-121.50991, 38.65206], [-121.50993, 38.65214], [-121.50991, 38.65222], [-121.50988, 38.6523], [-121.50982, 38.65237], [-121.50966, 38.65247], [-121.50906, 38.65269], [-121.50882, 38.65279], [-121.50858, 38.65286], [-121.50834, 38.65289], [-121.50809, 38.6529], [-121.50777, 38.65294], [-121.50727, 38.65294], [-121.50727, 38.65162], [-121.50807, 38.65162], [-121.50807, 38.65056]]]} | Open Access 1 | 21055 | Park 5-A | 23422 | 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.142 | Park 5-A | None 958 | |||
5676 | 5676 | 5675 | {"type": "Polygon", "coordinates": [[[-121.49013, 38.54356], [-121.4908, 38.54367], [-121.49083, 38.54372], [-121.49075, 38.54397], [-121.49072, 38.54399], [-121.49068, 38.544], [-121.49002, 38.54389], [-121.48999, 38.54384], [-121.49006, 38.5436], [-121.49009, 38.54358], [-121.49013, 38.54356]]]} | Open Access 1 | 21175 | Plaza Cervantes | 23777 | 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.628 | Plaza Cervantes | None 459 | |||
3061 | 3061 | 3060 | {"type": "Polygon", "coordinates": [[[-121.42484, 38.62521], [-121.42456, 38.62529], [-121.42179, 38.62553], [-121.42179, 38.6252], [-121.42157, 38.62521], [-121.42156, 38.62529], [-121.42154, 38.6253], [-121.42156, 38.62555], [-121.42073, 38.62562], [-121.42073, 38.62533], [-121.42219, 38.62387], [-121.42285, 38.62325], [-121.42376, 38.62411], [-121.42484, 38.62521]]]} | Open Access 1 | 21084 | John Mackey Park At Kenwood Oaks | 20453 | 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.547 | John Mackey Park At Kenwood Oaks | None 250 | |||
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 | ||
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 | |
11022 | 11022 | 11021 | {"type": "Polygon", "coordinates": [[[-121.50608, 38.60857], [-121.50599, 38.60901], [-121.50599, 38.60912], [-121.50602, 38.60919], [-121.50591, 38.60958], [-121.50573, 38.60985], [-121.50543, 38.61018], [-121.50549, 38.61022], [-121.50499, 38.61022], [-121.50473, 38.6102], [-121.50492, 38.60947], [-121.50493, 38.60813], [-121.50453, 38.60802], [-121.50453, 38.60744], [-121.50521, 38.60734], [-121.50479, 38.60784], [-121.5053, 38.60811], [-121.50575, 38.60838], [-121.50598, 38.60832], [-121.50608, 38.60857]]]} | Open Access 1 | 21107 | Bannon Creek Preserve | 15801 | 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.638 | Bannon Creek Preserve | 0 | Local Conservation Area 4 | 2 | |
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 | |
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 | |
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 | |
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 |
5673 | 5673 | 5672 | {"type": "Polygon", "coordinates": [[[-121.54627, 38.51423], [-121.54497, 38.5146], [-121.54474, 38.51413], [-121.54556, 38.51393], [-121.54592, 38.51391], [-121.54607, 38.51387], [-121.54627, 38.51423]]]} | Open Access 1 | 21209 | North Point Way River Access | 22847 | 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.532 | North Point Way River Access | 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 |
11026 | 11026 | 11025 | {"type": "MultiPolygon", "coordinates": [[[[-121.41422, 38.53219], [-121.41307, 38.5322], [-121.41293, 38.53216], [-121.41289, 38.53211], [-121.41292, 38.53205], [-121.41299, 38.53202], [-121.41418, 38.53201], [-121.41422, 38.53203], [-121.41423, 38.53216], [-121.41422, 38.53219]]], [[[-121.41671, 38.53219], [-121.41443, 38.53219], [-121.41441, 38.53218], [-121.41439, 38.53203], [-121.41442, 38.53202], [-121.41666, 38.53202], [-121.4167, 38.53204], [-121.41671, 38.53219]]], [[[-121.41912, 38.53205], [-121.41898, 38.53229], [-121.4189, 38.53231], [-121.41792, 38.53231], [-121.4169, 38.5322], [-121.41688, 38.53218], [-121.41688, 38.53204], [-121.41691, 38.53202], [-121.41909, 38.53202], [-121.41912, 38.53205]]], [[[-121.42107, 38.53205], [-121.42106, 38.53229], [-121.42104, 38.53231], [-121.41918, 38.5323], [-121.41933, 38.53204], [-121.41937, 38.53202], [-121.42105, 38.53202], [-121.42107, 38.53205]]], [[[-121.42604, 38.53216], [-121.42604, 38.53227], [-121.42601, 38.53228], [-121.42297, 38.53227], [-121.42248, 38.53232], [-121.42127, 38.53231], [-121.42124, 38.53229], [-121.42125, 38.53205], [-121.42128, 38.53203], [-121.42312, 38.53203], [-121.42419, 38.53215], [-121.42604, 38.53216]]], [[[-121.42712, 38.53223], [-121.42711, 38.53225], [-121.42691, 38.53224], [-121.42678, 38.53228], [-121.42624, 38.53228], [-121.42622, 38.53227], [-121.42623, 38.53217], [-121.42624, 38.53215], [-121.42663, 38.53217], [-121.42712, 38.53223]]], [[[-121.4294, 38.53226], [-121.42938, 38.53227], [-121.42797, 38.53227], [-121.42796, 38.53226], [-121.42797, 38.53225], [-121.42818, 38.53225], [-121.4284, 38.53221], [-121.42899, 38.53215], [-121.42939, 38.53214], [-121.4294, 38.53226]]], [[[-121.43268, 38.53204], [-121.43268, 38.53227], [-121.43264, 38.5323], [-121.43224, 38.5323], [-121.43202, 38.53227], [-121.4296, 38.53227], [-121.42959, 38.53226], [-121.42959, 38.53215], [-121.42962, 38.53214], [-121.43036, 38.53214], [-121.43129, 38.53203], [-121.43265, 38.53202], [-121.43268, 38.53204]]], [[[-121.43516, 38.5322], [-121.43456, 38.53227], [-121.43288, 38.5323], [-121.43286, 38.53229], [-121.43286, 38.53204], [-121.43289, 38.53201], [-121.43512, 38.53199], [-121.43515, 38.53201], [-121.43518, 38.53217], [-121.43516, 38.5322]]], [[[-121.43863, 38.53196], [-121.43864, 38.53198], [-121.43853, 38.53212], [-121.43848, 38.53213], [-121.43566, 38.53216], [-121.4354, 38.53219], [-121.43537, 38.53217], [-121.43533, 38.53201], [-121.43535, 38.53198], [-121.43863, 38.53196]]], [[[-121.44204, 38.53208], [-121.44201, 38.53209], [-121.43875, 38.53213], [-121.43874, 38.53211], [-121.43884, 38.53197], [-121.43888, 38.53195], [-121.44129, 38.53192], [-121.44158, 38.53195], [-121.44202, 38.53194], [-121.44204, 38.53195], [-121.44204, 38.53208]]], [[[-121.44318, 38.53193], [-121.44319, 38.53196], [-121.44319, 38.53205], [-121.44317, 38.53206], [-121.44224, 38.53209], [-121.44222, 38.53208], [-121.44222, 38.53196], [-121.44224, 38.53194], [-121.44318, 38.53193]]], [[[-121.44435, 38.53195], [-121.44434, 38.53204], [-121.44432, 38.53206], [-121.44339, 38.53206], [-121.44337, 38.53204], [-121.44338, 38.53195], [-121.4434, 38.53194], [-121.44435, 38.53195]]], [[[-121.44543, 38.53192], [-121.44542, 38.53194], [-121.4452, 38.53199], [-121.4449, 38.53204], [-121.44455, 38.53206], [-121.44453, 38.53203], [-121.44453, 38.53195], [-121.44456, 38.53193], [-121.44543, 38.53192]]]]} | Open Access 1 | 21183 | 21st Avenue Parkway | 15182 | 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.339 | 21st Avenue Parkway | 0 | Local Recreation Area 3 | 4 | |
11062 | 11062 | 11061 | {"type": "Polygon", "coordinates": [[[-121.50388, 38.47366], [-121.50333, 38.47379], [-121.50177, 38.47267], [-121.50092, 38.47195], [-121.49951, 38.47026], [-121.50037, 38.47018], [-121.50197, 38.47008], [-121.50247, 38.46999], [-121.50248, 38.47001], [-121.50318, 38.47002], [-121.50333, 38.47075], [-121.50354, 38.47147], [-121.50361, 38.47179], [-121.50388, 38.47366]]]} | Open Access 1 | 21245 | Bill Conlin Youth Regional Sports Complex | 16104 | 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.629 | Bill Conlin Youth Reg. Sports Complex | 0 | Local Recreation Area 3 | 4 | |
11081 | 11081 | 11080 | {"type": "Polygon", "coordinates": [[[-121.4988, 38.63277], [-121.49883, 38.63292], [-121.49884, 38.63318], [-121.49883, 38.63338], [-121.49878, 38.6336], [-121.49867, 38.63386], [-121.49859, 38.63399], [-121.49844, 38.6342], [-121.49831, 38.63433], [-121.49805, 38.63455], [-121.49788, 38.63465], [-121.49544, 38.636], [-121.49481, 38.63503], [-121.49437, 38.63503], [-121.49437, 38.63481], [-121.49491, 38.6348], [-121.4949, 38.63397], [-121.49559, 38.63396], [-121.49559, 38.63277], [-121.4988, 38.63277]]]} | Open Access 1 | 21284 | Natomas Baseball Complex | 22667 | 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 | 20.133 | Natomas Baseball Complex | 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 | |
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 |
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]);