superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
48 rows where MNG_AGENCY = 543 and MNG_AG_LEV = 3 sorted by map descending
This data as json, copyable, CSV (advanced)
Link | rowid | id | map ▲ | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
264 | 264 | 263 | {"type": "Polygon", "coordinates": [[[-121.50093, 38.38366], [-121.50055, 38.40726], [-121.48383, 38.4073], [-121.48084, 38.39263], [-121.48044, 38.39052], [-121.48034, 38.38942], [-121.48005, 38.38793], [-121.47955, 38.38591], [-121.47905, 38.38352], [-121.50093, 38.38366]]]} | Open Access 1 | Stone Lakes | http://www.regionalparks.saccounty.net/Parks/OpenSpaces/Pages/StoneLakesNationalWildlifeRefuge.aspx | 1757 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 1095.215 | Stone Lakes | |
1867 | 1867 | 1866 | {"type": "Polygon", "coordinates": [[[-121.49409, 38.57564], [-121.49312, 38.57765], [-121.48768, 38.57619], [-121.48856, 38.57417], [-121.49409, 38.57564]]]} | Open Access 1 | Capitol Park | 16837 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 29.709 | Capitol Park | ||
9987 | 9987 | 9986 | {"type": "Polygon", "coordinates": [[[-121.48774, 38.4088], [-121.48772, 38.40888], [-121.48765, 38.40901], [-121.48756, 38.4091], [-121.48745, 38.40917], [-121.48727, 38.40925], [-121.48678, 38.40939], [-121.48637, 38.40956], [-121.48599, 38.40978], [-121.48562, 38.41006], [-121.48534, 38.41036], [-121.48511, 38.41068], [-121.48492, 38.41107], [-121.48483, 38.4114], [-121.48435, 38.4089], [-121.48598, 38.40887], [-121.48656, 38.40882], [-121.48774, 38.4088]]]} | Restricted Access 2 | Stone Lakes | 25873 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 7.901 | Stone Lakes | ||
8299 | 8299 | 8298 | {"type": "Polygon", "coordinates": [[[-121.47555, 38.71878], [-121.47552, 38.72178], [-121.46828, 38.72174], [-121.46826, 38.72114], [-121.46717, 38.72113], [-121.46676, 38.72043], [-121.4667, 38.71688], [-121.46714, 38.71688], [-121.4703, 38.71814], [-121.47269, 38.71821], [-121.47338, 38.71804], [-121.47357, 38.71801], [-121.47382, 38.71806], [-121.47385, 38.71834], [-121.47392, 38.71846], [-121.47403, 38.71853], [-121.47462, 38.71871], [-121.47493, 38.71874], [-121.47515, 38.71868], [-121.47536, 38.71871], [-121.47555, 38.71878]]]} | Open Access 1 | Ponderosa Farm Community Park | 23885 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 77.179 | Ponderosa Farm Community Park | ||
5709 | 5709 | 5708 | {"type": "Polygon", "coordinates": [[[-121.45132, 38.38301], [-121.45064, 38.38333], [-121.45063, 38.38332], [-121.45032, 38.38293], [-121.44997, 38.38258], [-121.44967, 38.38233], [-121.44924, 38.38204], [-121.44983, 38.3814], [-121.45112, 38.3813], [-121.45132, 38.38301]]]} | Restricted Access 2 | Kenneth Way Drainage | 20610 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 6.272 | Kenneth Way Drainage | ||
5232 | 5232 | 5231 | {"type": "Polygon", "coordinates": [[[-121.45044, 38.37471], [-121.44978, 38.3747], [-121.44966, 38.37342], [-121.45028, 38.37338], [-121.45044, 38.37471]]]} | Restricted Access 2 | Hood-Franklin Drainage | 20071 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 2.024 | Hood-Franklin Drainage | ||
5882 | 5882 | 5881 | {"type": "Polygon", "coordinates": [[[-121.45011, 38.40646], [-121.45004, 38.40688], [-121.4499, 38.40688], [-121.44976, 38.40685], [-121.44963, 38.40679], [-121.44953, 38.40671], [-121.44945, 38.40661], [-121.44942, 38.40654], [-121.44941, 38.40643], [-121.44943, 38.40612], [-121.44612, 38.40611], [-121.44611, 38.40534], [-121.44083, 38.40532], [-121.44083, 38.405], [-121.44983, 38.40499], [-121.44995, 38.40507], [-121.45002, 38.40514], [-121.4501, 38.40525], [-121.45014, 38.40538], [-121.45014, 38.40551], [-121.45, 38.40639], [-121.45004, 38.40645], [-121.45011, 38.40646]]]} | Restricted Access 2 | Laguna Lake Drainage | 20858 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 15.925 | Laguna Lake Drainage | ||
6427 | 6427 | 6426 | {"type": "Polygon", "coordinates": [[[-121.44882, 38.38398], [-121.44574, 38.38469], [-121.44561, 38.38473], [-121.44549, 38.38479], [-121.44535, 38.38492], [-121.44535, 38.38427], [-121.44879, 38.38348], [-121.44879, 38.38397], [-121.44882, 38.38398]]]} | Restricted Access 2 | Lotus Pond Drainage | 21545 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 4.29 | Lotus Pond Drainage | ||
1651 | 1651 | 1650 | {"type": "Polygon", "coordinates": [[[-121.39798, 38.71663], [-121.39679, 38.71662], [-121.39676, 38.71656], [-121.39668, 38.71625], [-121.39666, 38.71594], [-121.39669, 38.71563], [-121.39678, 38.71532], [-121.39678, 38.71519], [-121.39741, 38.71519], [-121.39736, 38.71531], [-121.39736, 38.71542], [-121.39743, 38.71553], [-121.39768, 38.71574], [-121.39785, 38.71583], [-121.39795, 38.71602], [-121.39798, 38.71663]]]} | Restricted Access 2 | Atreule Et Al Community Plan | 15676 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 3.539 | Atreule Et Al Community Plan | ||
14273 | 14273 | 14272 | {"type": "Polygon", "coordinates": [[[-121.3533, 38.45594], [-121.35327, 38.45596], [-121.35327, 38.45636], [-121.35226, 38.45636], [-121.35227, 38.45624], [-121.3523, 38.45613], [-121.35236, 38.456], [-121.35243, 38.45591], [-121.35251, 38.45582], [-121.35281, 38.45567], [-121.35311, 38.4556], [-121.35318, 38.45561], [-121.35321, 38.45564], [-121.3533, 38.45594]]]} | Restricted Access 2 | Unnamed site - Sacramento, County of | 28659 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 1.452 | |||
3401 | 3401 | 3400 | {"type": "Polygon", "coordinates": [[[-121.35327, 38.45636], [-121.35322, 38.45992], [-121.35131, 38.45992], [-121.3513, 38.45977], [-121.35097, 38.45977], [-121.35102, 38.45972], [-121.35104, 38.45966], [-121.35101, 38.45955], [-121.35101, 38.45909], [-121.35105, 38.45881], [-121.35101, 38.45853], [-121.35101, 38.45828], [-121.35103, 38.45815], [-121.35115, 38.45772], [-121.35118, 38.45754], [-121.35122, 38.45751], [-121.35151, 38.45747], [-121.35171, 38.4574], [-121.3519, 38.45729], [-121.35207, 38.45714], [-121.35219, 38.45698], [-121.35227, 38.45677], [-121.35228, 38.45663], [-121.35226, 38.45636], [-121.35327, 38.45636]]]} | Restricted Access 2 | D R Horton Inc Sacramento | 17889 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 15.775 | D R Horton Inc Sacramento | ||
7972 | 7972 | 7971 | {"type": "Polygon", "coordinates": [[[-121.33145, 38.71873], [-121.33142, 38.71879], [-121.33142, 38.71883], [-121.33145, 38.71887], [-121.33142, 38.7189], [-121.3314, 38.71911], [-121.33136, 38.71934], [-121.33134, 38.71943], [-121.33129, 38.71946], [-121.33127, 38.7195], [-121.33129, 38.71958], [-121.33118, 38.71982], [-121.33113, 38.7199], [-121.3311, 38.71991], [-121.33097, 38.72016], [-121.33083, 38.72055], [-121.33067, 38.72078], [-121.33057, 38.72077], [-121.33048, 38.72082], [-121.33047, 38.72085], [-121.33047, 38.7209], [-121.33043, 38.72091], [-121.33017, 38.72138], [-121.33011, 38.72139], [-121.33005, 38.72143], [-121.33003, 38.72148], [-121.33005, 38.72154], [-121.32969, 38.72203], [-121.32962, 38.72204], [-121.32956, 38.72209], [-121.32955, 38.72216], [-121.3296, 38.72223], [-121.32938, 38.72244], [-121.32905, 38.72285], [-121.32891, 38.7229], [-121.32899, 38.72315], [-121.32859, 38.72322], [-121.3282, 38.72325], [-121.32776, 38.72325], [-121.32767, 38.72323], [-121.32765, 38.72319], [-121.32765, 38.72284], [-121.32812, 38.72284], [-121.32841, 38.72278], [-121.32864, 38.72258], [-121.32892, 38.72216], [-121.32891, 38.72212], [-121.32897, 38.72207], [-121.32899, 38.72201], [-121.32903, 38.722], [-121.32939, 38.72153], [-121.32938, 38.7215], [-121.32945, 38.72145], [-121.32946, 38.72138], [-121.3295, 38.72137], [-121.32985, 38.72089], [-121.32984, 38.72086], [-121.32991, 38.72081], [-121.32992, 38.72074], [-121.32996, 38.72073], [-121.33032, 38.72021], [-121.33065, 38.7198], [-121.3308, 38.71951], [-121.33089, 38.7192], [-121.33091, 38.71901], [-121.33091, 38.71878], [-121.33095, 38.71869], [-121.33093, 38.71864], [-121.3309, 38.71859], [-121.33094, 38.71855], [-121.33094, 38.71809], [-121.33142, 38.71808], [-121.33142, 38.7187], [-121.33145, 38.71873]]]} | Open Access 1 | Parkway Greens | 23460 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 8.038 | Parkway Greens | ||
8246 | 8246 | 8245 | {"type": "Polygon", "coordinates": [[[-121.32403, 38.45886], [-121.32211, 38.45886], [-121.32212, 38.45801], [-121.32285, 38.45764], [-121.3229, 38.45763], [-121.32403, 38.45886]]]} | Open Access 1 | Silver Leaf Park | 25490 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 3.642 | Silver Leaf Park | ||
14395 | 14395 | 14394 | {"type": "Polygon", "coordinates": [[[-121.29822, 38.56886], [-121.29831, 38.56987], [-121.29827, 38.56998], [-121.29811, 38.57016], [-121.29803, 38.57031], [-121.29801, 38.57042], [-121.29796, 38.57085], [-121.29785, 38.57059], [-121.29782, 38.57044], [-121.29777, 38.57032], [-121.29766, 38.57021], [-121.29744, 38.57006], [-121.29737, 38.56997], [-121.29734, 38.5699], [-121.29716, 38.5679], [-121.29813, 38.56784], [-121.29822, 38.56886]]]} | Open Access 1 | Unknown park - Sacramento, County of | 33604 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 5.538 | |||
1229 | 1229 | 1228 | {"type": "Polygon", "coordinates": [[[-121.29786, 38.49822], [-121.29733, 38.49802], [-121.2969, 38.49796], [-121.29661, 38.49799], [-121.29634, 38.49832], [-121.29629, 38.49874], [-121.29647, 38.49922], [-121.29644, 38.49953], [-121.29651, 38.49981], [-121.29676, 38.49992], [-121.29701, 38.49988], [-121.29784, 38.49901], [-121.29783, 38.50332], [-121.29735, 38.50321], [-121.29689, 38.50305], [-121.29688, 38.50306], [-121.29691, 38.50315], [-121.29703, 38.50325], [-121.29748, 38.50354], [-121.29428, 38.50352], [-121.29385, 38.50329], [-121.29323, 38.50315], [-121.29275, 38.50326], [-121.29239, 38.50351], [-121.28867, 38.50348], [-121.28869, 38.50214], [-121.2923, 38.50215], [-121.29546, 38.49847], [-121.29544, 38.49627], [-121.29762, 38.49629], [-121.29774, 38.49637], [-121.29785, 38.49753], [-121.29786, 38.49822]], [[-121.29623, 38.50255], [-121.29625, 38.50253], [-121.29618, 38.50232], [-121.29606, 38.50211], [-121.29589, 38.50192], [-121.29566, 38.50176], [-121.2954, 38.50164], [-121.29512, 38.50157], [-121.29483, 38.50154], [-121.29453, 38.50156], [-121.29425, 38.50162], [-121.29398, 38.50173], [-121.29374, 38.50176], [-121.29351, 38.50182], [-121.2933, 38.50192], [-121.29313, 38.50205], [-121.29301, 38.50218], [-121.29302, 38.5022], [-121.29326, 38.50215], [-121.29354, 38.50213], [-121.29382, 38.50215], [-121.29409, 38.50221], [-121.29464, 38.50225], [-121.29519, 38.50231], [-121.29572, 38.50242], [-121.29623, 38.50255]]]} | Restricted Access 2 | Arroyo Seco (florin Mitigation Bank) | 15628 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 66.257 | Arroyo Seco (florin Mitigation Bank) | ||
10790 | 10790 | 10789 | {"type": "Polygon", "coordinates": [[[-121.28865, 38.49607], [-121.27955, 38.49606], [-121.27946, 38.48155], [-121.28863, 38.48158], [-121.28865, 38.49607]]]} | Restricted Access 2 | Vernal Pool Prairie Preserve Area | 27000 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316.995 | Vernal Pool Prairie Preserve Area | ||
8404 | 8404 | 8403 | {"type": "Polygon", "coordinates": [[[-121.2872, 38.42303], [-121.28685, 38.42315], [-121.28643, 38.42337], [-121.28619, 38.42353], [-121.2858, 38.42385], [-121.28542, 38.4236], [-121.28471, 38.42421], [-121.28261, 38.42406], [-121.28154, 38.42496], [-121.28143, 38.42489], [-121.28175, 38.42462], [-121.28187, 38.42447], [-121.28205, 38.42431], [-121.28253, 38.42403], [-121.28272, 38.42397], [-121.28303, 38.42393], [-121.28323, 38.42385], [-121.28393, 38.42367], [-121.28429, 38.4236], [-121.28452, 38.42349], [-121.28487, 38.42338], [-121.28505, 38.42325], [-121.28543, 38.42302], [-121.286, 38.42263], [-121.28628, 38.42252], [-121.28663, 38.42231], [-121.2872, 38.42303]]]} | Restricted Access 2 | Preston Hanford | 23996 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 6.915 | Preston Hanford | ||
15067 | 15067 | 15066 | {"type": "Polygon", "coordinates": [[[-121.26874, 38.53018], [-121.2687, 38.53502], [-121.26111, 38.53502], [-121.26109, 38.54475], [-121.26089, 38.54464], [-121.26087, 38.54413], [-121.25886, 38.54414], [-121.25633, 38.54454], [-121.25597, 38.54464], [-121.25564, 38.54479], [-121.25542, 38.54493], [-121.25426, 38.54579], [-121.2541, 38.54594], [-121.25402, 38.54608], [-121.25397, 38.54623], [-121.25397, 38.54664], [-121.25227, 38.54904], [-121.25131, 38.55024], [-121.25199, 38.55102], [-121.25238, 38.55116], [-121.25363, 38.55257], [-121.25416, 38.55259], [-121.25423, 38.55434], [-121.25474, 38.55457], [-121.25778, 38.55443], [-121.25843, 38.55461], [-121.25845, 38.55481], [-121.25863, 38.55486], [-121.25868, 38.55468], [-121.25898, 38.55476], [-121.25975, 38.55439], [-121.26094, 38.5544], [-121.26093, 38.55672], [-121.26216, 38.55957], [-121.26093, 38.55956], [-121.26091, 38.55945], [-121.25463, 38.5594], [-121.25465, 38.55926], [-121.25463, 38.55909], [-121.2546, 38.55895], [-121.25454, 38.55879], [-121.25444, 38.55864], [-121.25434, 38.55852], [-121.2542, 38.55839], [-121.25404, 38.55828], [-121.25374, 38.55814], [-121.25337, 38.55805], [-121.2528, 38.55794], [-121.251, 38.55763], [-121.25056, 38.5575], [-121.25019, 38.55734], [-121.24995, 38.55721], [-121.24972, 38.55706], [-121.24562, 38.55413], [-121.24536, 38.5539], [-121.24523, 38.55376], [-121.24482, 38.55281], [-121.24492, 38.55137], [-121.24467, 38.54633], [-121.24474, 38.5401], [-121.2446, 38.53844], [-121.24457, 38.52893], [-121.24472, 38.52761], [-121.24488, 38.52634], [-121.24503, 38.52572], [-121.25181, 38.52564], [-121.26099, 38.52833], [-121.26874, 38.53018]]]} | Open Access 1 | Mather Regional Park | http://www.regionalparks.saccounty.net/Parks/RegionalParksDetails/Pages/MatherRegionalPark.aspx | 9992 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 1144.642 | Mather RP | |
7342 | 7342 | 7341 | {"type": "Polygon", "coordinates": [[[-121.2683, 38.7177], [-121.26769, 38.71781], [-121.26746, 38.71783], [-121.26736, 38.71789], [-121.26714, 38.71792], [-121.26714, 38.71772], [-121.26729, 38.71769], [-121.26752, 38.71753], [-121.2683, 38.71752], [-121.2683, 38.7177]]]} | Restricted Access 2 | Nevinshire | 22705 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 0.662 | Nevinshire | ||
4721 | 4721 | 4720 | {"type": "Polygon", "coordinates": [[[-121.26584, 38.41176], [-121.26406, 38.41179], [-121.26392, 38.41155], [-121.26373, 38.41107], [-121.26365, 38.41082], [-121.2645, 38.41003], [-121.26465, 38.41], [-121.26491, 38.41005], [-121.26516, 38.4102], [-121.26531, 38.41033], [-121.2654, 38.41046], [-121.26549, 38.41072], [-121.26554, 38.41094], [-121.26582, 38.41152], [-121.26584, 38.41165], [-121.26584, 38.41176]]]} | Unknown Access 4 | Green Rd Subdivision Map | 19466 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 6.619 | Green Rd Subdivision Map |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);