units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
220 rows where MNG_AGENCY = 534 sorted by YR_EST
This data as json, copyable, CSV (advanced)
Suggested facets: 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
PARK_URL 6 ✖
- http://www.cityofsacramento.org/parksandrecreation/parks/sites/ueda_parkway.htm 2
- http://www.cityofsacramento.org/parksandrecreation/parks/sites/granite_map.htm 1
- https://www.cityofsacramento.org/ParksandRec/Parks/Park-Directory/Central-City/Brooks-Truitt-Park 1
- https://www.cityofsacramento.org/ParksandRec/Parks/Park-Directory/Central-City/Pioneer-Landing 1
- https://www.cityofsacramento.org/ParksandRec/Parks/Park-Directory/Fruitridge-Broadway/ArtivioGuerreroPark 1
- https://www.cityofsacramento.org/ParksandRec/Parks/Park-Directory/South-Sacramento/LeVar-Burton-Park 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |
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 |
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]);