units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
220 rows where MNG_AGENCY = 534 and MNG_AG_TYP = 2 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
DES_TP 10
- Local Park 172
- 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 · 200 ✖
MNG_AGENCY 1
- Sacramento, City of · 200 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10986 | 10986 | 10985 | {"type": "Polygon", "coordinates": [[[-121.52956, 38.66067], [-121.52955, 38.66072], [-121.52948, 38.66087], [-121.52941, 38.66097], [-121.52928, 38.6611], [-121.52909, 38.66123], [-121.52871, 38.66144], [-121.52841, 38.66169], [-121.52837, 38.66171], [-121.52832, 38.6617], [-121.52805, 38.66156], [-121.52784, 38.66147], [-121.52694, 38.66117], [-121.52668, 38.66105], [-121.52641, 38.6609], [-121.52742, 38.65991], [-121.52769, 38.66005], [-121.5281, 38.66022], [-121.52851, 38.66037], [-121.52948, 38.66061], [-121.52953, 38.66063], [-121.52956, 38.66067]]]} | Open Access 1 | 21051 | Kokomo Park | 20714 | 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.167 | Kokomo Park | 0 | Local Park 2 | 4 | |
10987 | 10987 | 10986 | {"type": "Polygon", "coordinates": [[[-121.49696, 38.65967], [-121.49671, 38.65975], [-121.49648, 38.65985], [-121.49626, 38.65998], [-121.49606, 38.66013], [-121.496, 38.66013], [-121.4959, 38.66007], [-121.49574, 38.65996], [-121.49561, 38.65983], [-121.49545, 38.65962], [-121.49537, 38.65947], [-121.49531, 38.65928], [-121.49528, 38.65912], [-121.49528, 38.65855], [-121.49533, 38.65852], [-121.49581, 38.65851], [-121.49618, 38.65848], [-121.49656, 38.65842], [-121.49671, 38.65837], [-121.49673, 38.65902], [-121.49685, 38.65933], [-121.49696, 38.65967]]]} | Open Access 1 | 21052 | Cottonwood Park | 17691 | 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.986 | Cottonwood Park | 0 | Local Park 2 | 4 | |
10988 | 10988 | 10987 | {"type": "Polygon", "coordinates": [[[-121.45975, 38.65632], [-121.45979, 38.65635], [-121.45981, 38.65646], [-121.45983, 38.65691], [-121.4598, 38.65703], [-121.45975, 38.65714], [-121.45968, 38.65724], [-121.4596, 38.65733], [-121.45949, 38.65741], [-121.45936, 38.65748], [-121.4591, 38.65756], [-121.4589, 38.65759], [-121.45847, 38.65759], [-121.45842, 38.65756], [-121.4584, 38.65753], [-121.4584, 38.65736], [-121.45844, 38.65721], [-121.4585, 38.65709], [-121.45866, 38.65689], [-121.45871, 38.65689], [-121.45906, 38.65697], [-121.45946, 38.65698], [-121.4596, 38.65704], [-121.45966, 38.65703], [-121.45972, 38.657], [-121.45974, 38.65697], [-121.45975, 38.65692], [-121.45979, 38.65692], [-121.4598, 38.65685], [-121.45978, 38.6565], [-121.45975, 38.65632]]]} | Open Access 1 | 21053 | North Pointe Park | 22848 | 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.723 | North Pointe Park | 0 | Local Park 2 | 4 | |
10989 | 10989 | 10988 | {"type": "Polygon", "coordinates": [[[-121.54805, 38.65366], [-121.54371, 38.65373], [-121.54371, 38.65373], [-121.54373, 38.65347], [-121.54381, 38.6532], [-121.5441, 38.65269], [-121.54414, 38.65266], [-121.54417, 38.65266], [-121.54447, 38.65269], [-121.54786, 38.65266], [-121.54803, 38.65268], [-121.54805, 38.65366]]]} | Open Access 1 | 21054 | Blackbird Park Site | 16141 | 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.178 | Blackbird Park Site | 0 | Local Park 2 | 4 | |
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 | |||
10991 | 10991 | 10990 | {"type": "Polygon", "coordinates": [[[-121.45414, 38.64776], [-121.45415, 38.64788], [-121.45418, 38.64797], [-121.45423, 38.64806], [-121.45438, 38.6482], [-121.45444, 38.64835], [-121.45444, 38.64941], [-121.4544, 38.64945], [-121.45002, 38.64941], [-121.45003, 38.64768], [-121.45347, 38.64772], [-121.45348, 38.64775], [-121.45414, 38.64776]]]} | Open Access 1 | 21056 | Robla Community Park | 24504 | 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 | 17.837 | Robla Community Park | 0 | Local Park 2 | 4 | |
10992 | 10992 | 10991 | {"type": "Polygon", "coordinates": [[[-121.54774, 38.6485], [-121.5477, 38.64854], [-121.54769, 38.64858], [-121.5477, 38.64918], [-121.54773, 38.64925], [-121.54759, 38.64935], [-121.5476, 38.6497], [-121.54756, 38.64976], [-121.54748, 38.64975], [-121.54687, 38.64977], [-121.54666, 38.64982], [-121.54646, 38.64992], [-121.54643, 38.64804], [-121.54763, 38.64803], [-121.54764, 38.64837], [-121.54774, 38.6485]]]} | Open Access 1 | 21057 | Warbler Park Site | 27253 | 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.085 | Warbler Park Site | 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 | |
10993 | 10993 | 10992 | {"type": "Polygon", "coordinates": [[[-121.42536, 38.6435], [-121.42493, 38.64382], [-121.42471, 38.64363], [-121.42514, 38.64332], [-121.42536, 38.6435]]]} | Open Access 1 | 21059 | Verano Creek Park | 26984 | 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.355 | Verano Creek Park | 0 | Local Park 2 | 4 | |
10994 | 10994 | 10993 | {"type": "Polygon", "coordinates": [[[-121.5125, 38.64237], [-121.51095, 38.64268], [-121.51095, 38.64222], [-121.51094, 38.64193], [-121.51087, 38.64153], [-121.51079, 38.64126], [-121.5108, 38.64122], [-121.51085, 38.6412], [-121.51203, 38.64094], [-121.5125, 38.64237]]]} | Open Access 1 | 21060 | Linden Park | 21293 | 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.92 | Linden Park | 0 | Local Park 2 | 4 | |
10995 | 10995 | 10994 | {"type": "Polygon", "coordinates": [[[-121.53208, 38.63853], [-121.53194, 38.63857], [-121.5318, 38.63858], [-121.53175, 38.63862], [-121.53171, 38.63865], [-121.53169, 38.63865], [-121.531, 38.63886], [-121.5309, 38.63885], [-121.53077, 38.6389], [-121.53058, 38.63894], [-121.53032, 38.63896], [-121.53027, 38.63895], [-121.53025, 38.63893], [-121.53019, 38.63878], [-121.52943, 38.63721], [-121.52943, 38.63716], [-121.52947, 38.63713], [-121.52997, 38.63699], [-121.53012, 38.63697], [-121.53017, 38.63694], [-121.53021, 38.6369], [-121.53023, 38.63691], [-121.53092, 38.6367], [-121.53104, 38.63671], [-121.53117, 38.63665], [-121.53208, 38.63853]]]} | Open Access 1 | 21061 | Witter Ranch Park | 27664 | 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.032 | Witter Ranch Park | 0 | Local Park 2 | 4 | |
10982 | 10982 | 10981 | {"type": "Polygon", "coordinates": [[[-121.51646, 38.63672], [-121.51648, 38.63675], [-121.51663, 38.63716], [-121.51669, 38.63723], [-121.51674, 38.63726], [-121.51682, 38.63726], [-121.51726, 38.63713], [-121.51731, 38.63714], [-121.51734, 38.63716], [-121.51743, 38.63744], [-121.51747, 38.63769], [-121.51747, 38.63788], [-121.51742, 38.6383], [-121.5174, 38.63835], [-121.51735, 38.63837], [-121.5163, 38.63837], [-121.51622, 38.63835], [-121.51612, 38.63836], [-121.51601, 38.63829], [-121.51469, 38.63829], [-121.51467, 38.63694], [-121.51469, 38.6369], [-121.51479, 38.63683], [-121.5158, 38.63681], [-121.51646, 38.63672]]]} | Open Access 1 | 21062 | Airfield Park Site | 15300 | 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.219 | Airfield Park Site | 0 | Local Park 2 | 4 | |
10984 | 10984 | 10983 | {"type": "Polygon", "coordinates": [[[-121.52692, 38.63473], [-121.52678, 38.63528], [-121.52555, 38.63509], [-121.52553, 38.63504], [-121.52557, 38.63475], [-121.52557, 38.6345], [-121.52553, 38.63432], [-121.52544, 38.63404], [-121.52544, 38.634], [-121.52549, 38.63396], [-121.52665, 38.63367], [-121.52679, 38.63402], [-121.52678, 38.63406], [-121.52678, 38.63411], [-121.52684, 38.6342], [-121.52688, 38.63452], [-121.52686, 38.63464], [-121.52687, 38.63468], [-121.52692, 38.63473]]]} | Open Access 1 | 21063 | Hummingbird Park | 20149 | 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.292 | Hummingbird Park | 0 | Local Park 2 | 4 | |
10996 | 10996 | 10995 | {"type": "MultiPolygon", "coordinates": [[[[-121.44157, 38.63372], [-121.44112, 38.63372], [-121.44112, 38.63475], [-121.44009, 38.63474], [-121.4401, 38.63351], [-121.44112, 38.63351], [-121.44113, 38.6331], [-121.44157, 38.6331], [-121.44157, 38.63372]]], [[[-121.44223, 38.6338], [-121.44223, 38.63476], [-121.44176, 38.63476], [-121.44175, 38.63375], [-121.44179, 38.6338], [-121.44223, 38.6338]]]]} | Open Access 1 | 21064 | Mama Marks Park | 21715 | 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.786 | Mama Marks Park | 0 | Local Park 2 | 4 | |
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 | |||
10998 | 10998 | 10997 | {"type": "Polygon", "coordinates": [[[-121.45969, 38.63169], [-121.45705, 38.63166], [-121.45705, 38.63023], [-121.45968, 38.63026], [-121.45969, 38.63169]]]} | Open Access 1 | 21067 | Charles Robertson Park | 17142 | 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.054 | Charles Robertson Park | 0 | Local Park 2 | 4 | |
10999 | 10999 | 10998 | {"type": "Polygon", "coordinates": [[[-121.4893, 38.63101], [-121.48854, 38.63146], [-121.48832, 38.63121], [-121.48812, 38.63094], [-121.4879, 38.63059], [-121.48776, 38.63033], [-121.4876, 38.62998], [-121.48751, 38.62973], [-121.4874, 38.62935], [-121.48738, 38.62926], [-121.4874, 38.62922], [-121.48744, 38.6292], [-121.4876, 38.62918], [-121.48856, 38.62911], [-121.48898, 38.63034], [-121.48917, 38.63085], [-121.48921, 38.63092], [-121.4893, 38.63101]]]} | Open Access 1 | 21068 | Chuckwagon Park | 17237 | 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.955 | Chuckwagon Park | 0 | Local Park 2 | 4 | |
11000 | 11000 | 10999 | {"type": "Polygon", "coordinates": [[[-121.52717, 38.62977], [-121.5291, 38.62977], [-121.52914, 38.62983], [-121.52914, 38.63054], [-121.52917, 38.63073], [-121.52914, 38.63075], [-121.52898, 38.63077], [-121.52857, 38.6308], [-121.52711, 38.63079], [-121.52709, 38.63076], [-121.5271, 38.62983], [-121.52712, 38.62979], [-121.52717, 38.62977]]]} | Open Access 1 | 21069 | Redtail Hawk Park | 24244 | 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.97 | Redtail Hawk Park | 0 | Local Park 2 | 4 | |
11001 | 11001 | 11000 | {"type": "Polygon", "coordinates": [[[-121.45473, 38.62895], [-121.45476, 38.62896], [-121.45478, 38.629], [-121.45478, 38.62935], [-121.45482, 38.62944], [-121.4549, 38.62949], [-121.45515, 38.62952], [-121.45534, 38.62959], [-121.45551, 38.62971], [-121.45562, 38.62984], [-121.45568, 38.62995], [-121.45571, 38.63009], [-121.4557, 38.63023], [-121.45566, 38.63035], [-121.45556, 38.63049], [-121.45544, 38.6306], [-121.45527, 38.63069], [-121.45511, 38.63074], [-121.45498, 38.63076], [-121.45386, 38.63075], [-121.45385, 38.62985], [-121.45392, 38.62982], [-121.45397, 38.62978], [-121.454, 38.62967], [-121.45398, 38.6296], [-121.45385, 38.62944], [-121.45385, 38.62894], [-121.45473, 38.62895]]]} | Open Access 1 | 21070 | Nuevo Park | 22936 | 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.193 | Nuevo Park | 0 | Local Park 2 | 4 | |
11002 | 11002 | 11001 | {"type": "Polygon", "coordinates": [[[-121.43618, 38.62808], [-121.43618, 38.62871], [-121.43489, 38.6287], [-121.43487, 38.62944], [-121.43165, 38.6294], [-121.43221, 38.62774], [-121.43232, 38.62747], [-121.4337, 38.62751], [-121.43618, 38.62808]]]} | Open Access 1 | 21071 | Hagginwood Park | 19596 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 15.435 | Hagginwood 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]);