units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
56 rows where MNG_AGENCY = 543 and MNG_AG_TYP = 3 sorted by UNIT_ID descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, YR_EST, GAP_STS
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6291 | 6291 | 6290 | {"type": "Polygon", "coordinates": [[[-121.24447, 38.2956], [-121.24433, 38.29571], [-121.24395, 38.2959], [-121.24332, 38.29626], [-121.24327, 38.29627], [-121.24321, 38.29625], [-121.24323, 38.29563], [-121.24327, 38.29546], [-121.24333, 38.29535], [-121.24343, 38.29529], [-121.24365, 38.29521], [-121.24382, 38.29521], [-121.24402, 38.29524], [-121.24425, 38.29534], [-121.24431, 38.29542], [-121.24444, 38.29556], [-121.24447, 38.2956]]]} | Open Access 1 | 48884 | Herald Park | 33605 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | https://regionalparks.saccounty.net/SpecialEventsReservations/Pages/HeraldPark.aspx | Sacramento 41 | 1.953 | Herald Park | 0 | Local Park 2 | 4 |
4818 | 4818 | 4817 | {"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.57043], [-121.29777, 38.57032], [-121.29767, 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 | 48883 | Unknown park - Sacramento, County of | 33604 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 5.539 | 0 | Local Other or Unknown 14 | 4 | ||
4679 | 4679 | 4678 | {"type": "Polygon", "coordinates": [[[-121.3533, 38.45594], [-121.35327, 38.45595], [-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 | 43001 | Unnamed site - Sacramento, County of | 28659 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 1.452 | 0 | Local Other or Unknown 14 | 4 | ||
13639 | 13639 | 13638 | {"type": "Polygon", "coordinates": [[[-121.26874, 38.53018], [-121.2687, 38.53502], [-121.26111, 38.53501], [-121.26109, 38.54475], [-121.26089, 38.54464], [-121.26088, 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.2513, 38.55025], [-121.25199, 38.55103], [-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.25864, 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.26092, 38.55945], [-121.25463, 38.5594], [-121.25465, 38.55926], [-121.25464, 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.25171, 38.52563], [-121.25181, 38.52564], [-121.26099, 38.52833], [-121.26874, 38.53018]]]} | Open Access 1 | 36000 | Mather Regional Park | 9992 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.regionalparks.saccounty.net/Parks/RegionalParksDetails/Pages/MatherRegionalPark.aspx | Sacramento 41 | 1144.635 | Mather RP | 0 | Local Park 2 | 4 |
12721 | 12721 | 12720 | {"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.47537, 38.71871], [-121.47555, 38.71878]]]} | Open Access 1 | 29740 | Ponderosa Farm Community Park | 23885 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 77.173 | Ponderosa Farm Community Park | 0 | Local Park 2 | 4 | |
12673 | 12673 | 12672 | {"type": "Polygon", "coordinates": [[[-121.09228, 38.49266], [-121.09217, 38.49275], [-121.09165, 38.49255], [-121.09152, 38.49227], [-121.09165, 38.49217], [-121.09228, 38.49266]]]} | Open Access 1 | 29637 | Cosumnes River Parkway | 17676 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 0.435 | Cosumnes River Parkway | 0 | Local Recreation Area 3 | 4 | |
11682 | 11682 | 11681 | {"type": "MultiPolygon", "coordinates": [[[[-121.51094, 38.60405], [-121.5106, 38.60425], [-121.51027, 38.60446], [-121.50982, 38.60483], [-121.50931, 38.60524], [-121.50896, 38.60548], [-121.50836, 38.60585], [-121.50815, 38.60596], [-121.50791, 38.60606], [-121.50747, 38.6062], [-121.50675, 38.60635], [-121.5053, 38.60676], [-121.50183, 38.60755], [-121.501, 38.60771], [-121.50003, 38.60784], [-121.49221, 38.60846], [-121.49169, 38.60849], [-121.49111, 38.60848], [-121.49106, 38.60848], [-121.49105, 38.60845], [-121.49086, 38.60844], [-121.49079, 38.60645], [-121.49076, 38.60584], [-121.49055, 38.60484], [-121.48962, 38.60369], [-121.48936, 38.60362], [-121.48882, 38.60314], [-121.48878, 38.60289], [-121.48945, 38.60288], [-121.49042, 38.60303], [-121.49253, 38.6032], [-121.49398, 38.60318], [-121.49463, 38.60311], [-121.49673, 38.60306], [-121.49721, 38.60314], [-121.49758, 38.60311], [-121.49796, 38.60314], [-121.49831, 38.60305], [-121.49879, 38.60306], [-121.4991, 38.60293], [-121.49947, 38.60287], [-121.49987, 38.60268], [-121.50035, 38.60255], [-121.50076, 38.60238], [-121.50115, 38.60236], [-121.50133, 38.6023], [-121.50162, 38.60225], [-121.50177, 38.60219], [-121.50203, 38.60214], [-121.50227, 38.60204], [-121.50287, 38.6019], [-121.50309, 38.60179], [-121.50347, 38.60171], [-121.50381, 38.60158], [-121.50409, 38.60153], [-121.50431, 38.6014], [-121.50462, 38.60126], [-121.50475, 38.60119], [-121.50494, 38.60113], [-121.50505, 38.60106], [-121.50588, 38.60082], [-121.5062, 38.60064], [-121.50647, 38.60031], [-121.50665, 38.60018], [-121.51094, 38.60405]]], [[[-121.51419, 38.60293], [-121.51377, 38.60304], [-121.51376, 38.6037], [-121.51311, 38.6036], [-121.51273, 38.60359], [-121.51236, 38.60361], [-121.51204, 38.60366], [-121.51168, 38.60375], [-121.51143, 38.60384], [-121.51107, 38.60399], [-121.50675, 38.6001], [-121.50695, 38.6], [-121.50742, 38.59953], [-121.50811, 38.59915], [-121.50865, 38.59889], [-121.50897, 38.59886], [-121.50902, 38.59867], [-121.50911, 38.5994], [-121.51017, 38.6007], [-121.51023, 38.60064], [-121.51119, 38.6014], [-121.51186, 38.60189], [-121.51268, 38.60228], [-121.51419, 38.60293]]]]} | Open Access 1 | 23977 | American River Parkway - Discovery Park | 9959 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.regionalparks.saccounty.net/Parks/Pages/DiscoveryPark.aspx | Sacramento 41 | 272.747 | American River Parkway - Discovery Park | 0 | Local Park 2 | 4 |
10615 | 10615 | 10614 | {"type": "Polygon", "coordinates": [[[-121.20472, 38.7035], [-121.2046, 38.70349], [-121.20457, 38.70342], [-121.20458, 38.70338], [-121.20455, 38.70317], [-121.20444, 38.70303], [-121.2044, 38.70283], [-121.20439, 38.70266], [-121.2044, 38.70262], [-121.20442, 38.70261], [-121.20446, 38.70223], [-121.20448, 38.7022], [-121.20452, 38.70221], [-121.20453, 38.70223], [-121.20449, 38.70252], [-121.20448, 38.70283], [-121.20455, 38.70305], [-121.20463, 38.70314], [-121.20463, 38.70331], [-121.20464, 38.70339], [-121.20472, 38.7035]]]} | Open Access 1 | 22294 | 9101 Sunset Ave | 15222 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 0.246 | 9101 Sunset Ave | None 934 | |||
16641 | 16641 | 16640 | {"type": "Polygon", "coordinates": [[[-121.16941, 38.69857], [-121.16888, 38.69857], [-121.16885, 38.69983], [-121.16707, 38.69983], [-121.16698, 38.69882], [-121.16667, 38.69756], [-121.16679, 38.69664], [-121.16671, 38.69636], [-121.16673, 38.69612], [-121.16755, 38.69261], [-121.16755, 38.69204], [-121.16816, 38.692], [-121.16938, 38.69204], [-121.16946, 38.69624], [-121.16941, 38.69857]]]} | Open Access 1 | 22260 | Folsom Lake State Recreation Area | 18970 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 42.957 | Folsom Lake SRA | 1956 | Local Recreation Area 3 | 4 | |
11411 | 11411 | 11410 | {"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 | 22248 | Lotus Pond Drainage | 21545 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 4.291 | Lotus Pond Drainage | 0 | Local Other or Unknown 14 | 4 | |
11410 | 11410 | 11409 | {"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 | 22247 | Kenneth Way Drainage | 20610 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 6.273 | Kenneth Way Drainage | None 1008 | |||
3224 | 3224 | 3223 | {"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 | 22246 | Hood-Franklin Drainage | 20071 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 2.025 | Hood-Franklin Drainage | None 266 | |||
11174 | 11174 | 11173 | {"type": "Polygon", "coordinates": [[[-121.20529, 38.35592], [-121.20528, 38.35682], [-121.20307, 38.35681], [-121.20308, 38.3559], [-121.20529, 38.35592]]]} | Restricted Access 2 | 22245 | Terry Parker Et Al | 26269 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 4.819 | Terry Parker Et Al | None 975 | |||
2877 | 2877 | 2876 | {"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.42359], [-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 | 22244 | Preston Hanford | 23996 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 6.909 | Preston Hanford | None 241 | |||
2876 | 2876 | 2875 | {"type": "Polygon", "coordinates": [[[-121.25202, 38.40904], [-121.25157, 38.40901], [-121.25157, 38.40891], [-121.25154, 38.40884], [-121.25164, 38.40866], [-121.25175, 38.40863], [-121.25192, 38.40869], [-121.25202, 38.40883], [-121.25202, 38.40904]]]} | Unknown Access 4 | 22243 | Schnabel Tentative Parcel Map | 25185 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 0.366 | Schnabel Tentative Parcel Map | None 240 | |||
11422 | 11422 | 11421 | {"type": "Polygon", "coordinates": [[[-121.23657, 38.39513], [-121.23642, 38.3951], [-121.23642, 38.39505], [-121.23657, 38.39498], [-121.23657, 38.39513]]]} | Unknown Access 4 | 22242 | Harrison Larry L/Tonya A | 19699 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 0.036 | Harrison Larry L/Tonya A | None 1012 | |||
11421 | 11421 | 11420 | {"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 | 22240 | Vernal Pool Prairie Preserve Area | 27000 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 317.004 | Vernal Pool Prairie Preserve Area | 0 | Local Conservation Area 4 | 2 | |
11420 | 11420 | 11419 | {"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 | 22238 | Silver Leaf Park | 25490 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 3.643 | Silver Leaf Park | 0 | Local Park 2 | 4 | |
11419 | 11419 | 11418 | {"type": "MultiPolygon", "coordinates": [[[[-121.17476, 38.47876], [-121.1741, 38.47839], [-121.17414, 38.47832], [-121.17425, 38.47823], [-121.1744, 38.47819], [-121.17462, 38.47819], [-121.1747, 38.47821], [-121.17479, 38.47825], [-121.17487, 38.47832], [-121.17491, 38.47838], [-121.17494, 38.47845], [-121.17494, 38.47852], [-121.17492, 38.47859], [-121.17488, 38.47866], [-121.17476, 38.47876]]], [[[-121.18136, 38.48039], [-121.17757, 38.48451], [-121.17626, 38.48377], [-121.17616, 38.48373], [-121.1764, 38.48358], [-121.17654, 38.48355], [-121.1767, 38.48368], [-121.17694, 38.48382], [-121.17721, 38.48387], [-121.17772, 38.48405], [-121.17783, 38.48404], [-121.17789, 38.4839], [-121.17787, 38.48367], [-121.17769, 38.48322], [-121.1774, 38.48282], [-121.17692, 38.48233], [-121.17676, 38.48229], [-121.17665, 38.4824], [-121.17654, 38.48285], [-121.17645, 38.48293], [-121.17635, 38.4829], [-121.17613, 38.48274], [-121.17599, 38.48253], [-121.17581, 38.48233], [-121.17552, 38.48218], [-121.17543, 38.48206], [-121.17538, 38.48181], [-121.17528, 38.48159], [-121.17534, 38.48144], [-121.17562, 38.48154], [-121.17575, 38.4815], [-121.17586, 38.4815], [-121.17602, 38.48147], [-121.17606, 38.48133], [-121.1764, 38.48101], [-121.17652, 38.48078], [-121.17658, 38.48057], [-121.17699, 38.48017], [-121.17716, 38.47992], [-121.17721, 38.47974], [-121.17708, 38.47969], [-121.17694, 38.47958], [-121.1769, 38.47949], [-121.17689, 38.47938], [-121.17685, 38.47928], [-121.17671, 38.4792], [-121.17666, 38.47914], [-121.17662, 38.47906], [-121.17661, 38.47899], [-121.17662, 38.47891], [-121.17666, 38.47882], [-121.17673, 38.47874], [-121.17688, 38.47867], [-121.17704, 38.47866], [-121.17717, 38.4787], [-121.17727, 38.47877], [-121.1774, 38.47883], [-121.17747, 38.4789], [-121.17752, 38.47901], [-121.17769, 38.47923], [-121.17773, 38.47937], [-121.17772, 38.47949], [-121.17809, 38.47959], [-121.17837, 38.47932], [-121.17837, 38.47916], [-121.17828, 38.479], [-121.17802, 38.47876], [-121.1773, 38.47844], [-121.1772, 38.47833], [-121.17719, 38.47824], [-121.17704, 38.47828], [-121.1768, 38.47827], [-121.17663, 38.47821], [-121.1765, 38.47812], [-121.17641, 38.47801], [-121.17635, 38.47791], [-121.17632, 38.47778], [-121.17632, 38.47771], [-121.17635, 38.47764], [-121.17648, 38.47752], [-121.17741, 38.47806], [-121.17733, 38.47817], [-121.1774, 38.47817], [-121.17763, 38.47827], [-121.18136, 38.48039]]]]} | Restricted Access 2 | 22235 | Silva Et Al | 25480 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 41.21 | Silva Et Al | None 1011 | |||
11418 | 11418 | 11417 | {"type": "Polygon", "coordinates": [[[-121.20133, 38.43685], [-121.20134, 38.43694], [-121.20132, 38.43704], [-121.20014, 38.43829], [-121.20013, 38.4383], [-121.20006, 38.4383], [-121.20003, 38.43827], [-121.20001, 38.43824], [-121.20036, 38.4379], [-121.20048, 38.43773], [-121.20071, 38.43749], [-121.20119, 38.43684], [-121.20129, 38.43682], [-121.20133, 38.43685]]]} | Restricted Access 2 | 22230 | John H Friend | 20444 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 0.684 | John H Friend | None 1010 |
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]);