units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9 rows where AGNCY_TYP = 2, DES_TP = 3 and MNG_AGENCY = 533
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME
ACCESS_TYP 3
MNG_AG_TYP 1
MNG_AGENCY 1
- Roseville, City of · 9 ✖
DES_TP 1
- Local Recreation Area · 9 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3638 | 3638 | 3637 | {"type": "Polygon", "coordinates": [[[-121.26288, 38.75472], [-121.26165, 38.75576], [-121.26024, 38.75636], [-121.2599, 38.75658], [-121.25957, 38.75693], [-121.25942, 38.7572], [-121.25928, 38.75719], [-121.25913, 38.75715], [-121.25811, 38.75675], [-121.2583, 38.75636], [-121.25846, 38.75613], [-121.25865, 38.75607], [-121.25897, 38.75611], [-121.25927, 38.75602], [-121.25879, 38.75582], [-121.25853, 38.75577], [-121.25864, 38.75568], [-121.25905, 38.75576], [-121.2594, 38.75588], [-121.25963, 38.7556], [-121.2597, 38.75563], [-121.25996, 38.75532], [-121.26004, 38.75535], [-121.2604, 38.75492], [-121.26036, 38.75477], [-121.26023, 38.7547], [-121.26041, 38.75449], [-121.26063, 38.75445], [-121.26067, 38.75462], [-121.26083, 38.75481], [-121.2612, 38.75475], [-121.26116, 38.75458], [-121.26112, 38.75458], [-121.26108, 38.75438], [-121.26112, 38.75435], [-121.26136, 38.75427], [-121.26158, 38.75423], [-121.26148, 38.75381], [-121.26193, 38.75408], [-121.2621, 38.75415], [-121.26238, 38.75435], [-121.2627, 38.75464], [-121.26288, 38.75472]], [[-121.26236, 38.75516], [-121.26236, 38.75514], [-121.26206, 38.75493], [-121.26189, 38.75488], [-121.26133, 38.75524], [-121.26147, 38.75549], [-121.26154, 38.75545], [-121.26208, 38.75534], [-121.26236, 38.75516]]]} | Open Access 1 | 29478 | Miner's Ravine Trail | 22260 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 12.44 | Miner's Ravine Trail | 0 | Local Recreation Area 3 | 4 | |
| 7658 | 7658 | 7657 | {"type": "MultiPolygon", "coordinates": [[[[-121.33318, 38.77738], [-121.33108, 38.77841], [-121.33128, 38.77895], [-121.32992, 38.7806], [-121.32992, 38.78173], [-121.32873, 38.78173], [-121.32872, 38.78055], [-121.32156, 38.78053], [-121.32156, 38.78087], [-121.31946, 38.7809], [-121.31879, 38.78159], [-121.31752, 38.78178], [-121.31706, 38.78176], [-121.3164, 38.78152], [-121.31639, 38.78104], [-121.3168, 38.78104], [-121.3168, 38.7806], [-121.31722, 38.7806], [-121.31721, 38.78027], [-121.31757, 38.78019], [-121.31786, 38.78005], [-121.31832, 38.77973], [-121.31895, 38.77946], [-121.31997, 38.77946], [-121.32051, 38.77928], [-121.32092, 38.77882], [-121.32092, 38.77742], [-121.32062, 38.77657], [-121.32031, 38.77607], [-121.32023, 38.77564], [-121.32045, 38.77546], [-121.32045, 38.77538], [-121.32093, 38.77498], [-121.32143, 38.77515], [-121.32183, 38.77515], [-121.3221, 38.77615], [-121.32251, 38.77655], [-121.32444, 38.77695], [-121.32498, 38.77669], [-121.3249, 38.77644], [-121.32469, 38.77602], [-121.32503, 38.7745], [-121.32453, 38.77439], [-121.32468, 38.77396], [-121.32476, 38.7738], [-121.32488, 38.77368], [-121.32526, 38.77338], [-121.32555, 38.77359], [-121.32614, 38.77315], [-121.32665, 38.77183], [-121.32719, 38.77085], [-121.3268, 38.77069], [-121.32705, 38.77029], [-121.32804, 38.77073], [-121.32803, 38.77237], [-121.3275, 38.77302], [-121.32701, 38.77395], [-121.32698, 38.77427], [-121.32751, 38.77437], [-121.32754, 38.77479], [-121.32806, 38.77504], [-121.32944, 38.775], [-121.32978, 38.77527], [-121.3301, 38.77531], [-121.33058, 38.77524], [-121.33095, 38.77505], [-121.33119, 38.77532], [-121.33147, 38.7756], [-121.33217, 38.77619], [-121.33252, 38.77653], [-121.33288, 38.77695], [-121.33318, 38.77738]]], [[[-121.32686, 38.77028], [-121.32641, 38.77099], [-121.32599, 38.77096], [-121.32596, 38.77099], [-121.3258, 38.77099], [-121.32524, 38.7708], [-121.32443, 38.77075], [-121.32303, 38.77032], [-121.32255, 38.77025], [-121.32223, 38.7704], [-121.3222, 38.77056], [-121.32222, 38.77062], [-121.32204, 38.77086], [-121.32161, 38.77117], [-121.32166, 38.77172], [-121.32211, 38.77178], [-121.3224, 38.77186], [-121.32331, 38.77204], [-121.32351, 38.77226], [-121.32406, 38.77263], [-121.32457, 38.77327], [-121.32485, 38.77349], [-121.3247, 38.77361], [-121.32459, 38.77376], [-121.32404, 38.77348], [-121.32353, 38.77337], [-121.32313, 38.77319], [-121.32279, 38.77313], [-121.32193, 38.77286], [-121.32157, 38.77278], [-121.32101, 38.77276], [-121.32085, 38.77268], [-121.32073, 38.77252], [-121.3205, 38.77187], [-121.32023, 38.77153], [-121.31978, 38.77114], [-121.3196, 38.77066], [-121.31904, 38.77035], [-121.31941, 38.76996], [-121.31985, 38.76957], [-121.32034, 38.76922], [-121.32088, 38.76892], [-121.32141, 38.76868], [-121.32202, 38.76846], [-121.32265, 38.7683], [-121.32326, 38.76819], [-121.32342, 38.76966], [-121.32506, 38.76974], [-121.32589, 38.76986], [-121.32631, 38.77008], [-121.32686, 38.77028]]]]} | Restricted Access 2 | 20863 | Woodcreek Oaks Golf Course | 33075 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 208.072 | Woodcreek Oaks GC | 0 | Local Recreation Area 3 | 4 | |
| 11487 | 11487 | 11486 | {"type": "Polygon", "coordinates": [[[-121.31032, 38.73631], [-121.30904, 38.73645], [-121.30901, 38.73417], [-121.31032, 38.73417], [-121.31032, 38.73631]]]} | Open Access 1 | 29436 | City Open Space | 17336 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 6.835 | City OS | 0 | Local Recreation Area 3 | 4 | |
| 15649 | 15649 | 15648 | {"type": "Polygon", "coordinates": [[[-121.3511, 38.76936], [-121.35087, 38.76985], [-121.35114, 38.77007], [-121.35125, 38.77023], [-121.3518, 38.77151], [-121.35183, 38.77167], [-121.35183, 38.77183], [-121.35163, 38.77305], [-121.35152, 38.77339], [-121.35119, 38.77436], [-121.35103, 38.77453], [-121.3508, 38.77497], [-121.35097, 38.77518], [-121.35045, 38.77584], [-121.35017, 38.77592], [-121.3503, 38.77639], [-121.3487, 38.77643], [-121.34813, 38.77596], [-121.34778, 38.77596], [-121.34696, 38.77662], [-121.34565, 38.77699], [-121.34531, 38.77704], [-121.34509, 38.77697], [-121.34401, 38.77703], [-121.34354, 38.77692], [-121.3426, 38.77646], [-121.3424, 38.77648], [-121.34228, 38.77598], [-121.34223, 38.77574], [-121.34219, 38.77504], [-121.34242, 38.77501], [-121.34265, 38.77495], [-121.34418, 38.77441], [-121.34435, 38.77437], [-121.34483, 38.77434], [-121.34527, 38.77444], [-121.34545, 38.77446], [-121.34613, 38.77434], [-121.34651, 38.77432], [-121.34796, 38.77444], [-121.34819, 38.77448], [-121.34814, 38.77413], [-121.34805, 38.77409], [-121.34806, 38.77403], [-121.34803, 38.77397], [-121.34812, 38.77392], [-121.34803, 38.77332], [-121.34794, 38.77328], [-121.34795, 38.77322], [-121.34792, 38.77316], [-121.348, 38.77311], [-121.34796, 38.77278], [-121.34722, 38.7729], [-121.34694, 38.77243], [-121.34714, 38.77234], [-121.34718, 38.77226], [-121.34716, 38.77217], [-121.34742, 38.77199], [-121.34759, 38.77214], [-121.34783, 38.77198], [-121.34783, 38.77188], [-121.34791, 38.77186], [-121.34796, 38.77182], [-121.34804, 38.77185], [-121.34818, 38.7718], [-121.34835, 38.77167], [-121.34835, 38.77163], [-121.34821, 38.77149], [-121.34799, 38.77136], [-121.34781, 38.77128], [-121.34737, 38.77115], [-121.34699, 38.77117], [-121.34702, 38.77149], [-121.34681, 38.77155], [-121.3467, 38.77143], [-121.34657, 38.77135], [-121.3464, 38.7714], [-121.34645, 38.77113], [-121.34612, 38.77108], [-121.34602, 38.77115], [-121.34596, 38.77111], [-121.34588, 38.77111], [-121.34581, 38.77113], [-121.34577, 38.77117], [-121.34556, 38.77108], [-121.34495, 38.7714], [-121.34472, 38.77144], [-121.34451, 38.7714], [-121.34301, 38.77062], [-121.34263, 38.77035], [-121.34226, 38.77003], [-121.34187, 38.76999], [-121.34189, 38.76971], [-121.34183, 38.76899], [-121.34193, 38.76886], [-121.34208, 38.76876], [-121.34193, 38.76852], [-121.34204, 38.76848], [-121.34208, 38.76844], [-121.34211, 38.76839], [-121.3421, 38.76833], [-121.34206, 38.76826], [-121.342, 38.76805], [-121.34199, 38.76805], [-121.34199, 38.768], [-121.34202, 38.76797], [-121.34264, 38.76781], [-121.34311, 38.76768], [-121.34345, 38.76756], [-121.34445, 38.76715], [-121.34543, 38.76681], [-121.34557, 38.76677], [-121.34566, 38.76677], [-121.34575, 38.7668], [-121.34581, 38.76686], [-121.34593, 38.76719], [-121.34607, 38.76739], [-121.34624, 38.76754], [-121.3465, 38.7677], [-121.34723, 38.76797], [-121.34801, 38.76839], [-121.34849, 38.76859], [-121.3511, 38.76936]]]} | Restricted Access 2 | 20859 | City of Roseville Public Golf Courses | 33074 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 139.53 | City of Roseville Public GC | 0 | Local Recreation Area 3 | 4 | |
| 15713 | 15713 | 15712 | {"type": "Polygon", "coordinates": [[[-121.2973, 38.77105], [-121.29627, 38.77371], [-121.29594, 38.77403], [-121.29577, 38.77402], [-121.29576, 38.77359], [-121.29542, 38.77352], [-121.29546, 38.77342], [-121.29591, 38.77321], [-121.29601, 38.77268], [-121.2955, 38.77257], [-121.29562, 38.77115], [-121.29349, 38.77107], [-121.29137, 38.77075], [-121.29084, 38.77092], [-121.29032, 38.77139], [-121.28966, 38.77215], [-121.28931, 38.77274], [-121.28892, 38.77308], [-121.28835, 38.77325], [-121.28818, 38.77293], [-121.28885, 38.77244], [-121.28935, 38.77178], [-121.28959, 38.77131], [-121.28809, 38.7716], [-121.28649, 38.77128], [-121.28652, 38.77291], [-121.28546, 38.77328], [-121.28462, 38.77144], [-121.28459, 38.76955], [-121.28436, 38.76929], [-121.28281, 38.77027], [-121.28139, 38.7708], [-121.28093, 38.7708], [-121.28071, 38.77166], [-121.28002, 38.77322], [-121.27909, 38.77296], [-121.27906, 38.77121], [-121.27965, 38.77107], [-121.27963, 38.76941], [-121.27856, 38.76711], [-121.27973, 38.76678], [-121.28008, 38.76721], [-121.28113, 38.76857], [-121.28131, 38.76955], [-121.28279, 38.76867], [-121.28443, 38.76812], [-121.28496, 38.76747], [-121.28522, 38.76753], [-121.28546, 38.76755], [-121.28633, 38.76749], [-121.28662, 38.7675], [-121.28693, 38.76756], [-121.28685, 38.76785], [-121.28844, 38.76817], [-121.29064, 38.76944], [-121.2926, 38.76935], [-121.29565, 38.76984], [-121.29572, 38.76949], [-121.29698, 38.76923], [-121.2973, 38.77105]]]} | Restricted Access 2 | 29458 | Diamond Oaks Golf Course | 33092 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 121.659 | Diamond Oaks GC | 0 | Local Recreation Area 3 | 4 | |
| 16167 | 16167 | 16166 | {"type": "MultiPolygon", "coordinates": [[[[-121.24491, 38.74107], [-121.24485, 38.74123], [-121.24457, 38.74138], [-121.24422, 38.74146], [-121.24418, 38.74154], [-121.24404, 38.74157], [-121.24404, 38.74167], [-121.24388, 38.74162], [-121.24361, 38.74174], [-121.24349, 38.74176], [-121.24336, 38.74188], [-121.24332, 38.74202], [-121.24326, 38.74209], [-121.24321, 38.74212], [-121.24305, 38.74211], [-121.24296, 38.74207], [-121.24284, 38.74199], [-121.24319, 38.74176], [-121.24334, 38.74147], [-121.24352, 38.74144], [-121.24416, 38.74138], [-121.24431, 38.74114], [-121.24424, 38.74094], [-121.24427, 38.74082], [-121.24421, 38.74072], [-121.24491, 38.74107]]], [[[-121.24785, 38.7396], [-121.24782, 38.73969], [-121.24773, 38.73968], [-121.24758, 38.73961], [-121.2475, 38.73967], [-121.24747, 38.73977], [-121.24742, 38.73982], [-121.24707, 38.73982], [-121.24693, 38.73977], [-121.2465, 38.73989], [-121.24636, 38.73987], [-121.24623, 38.74001], [-121.24596, 38.74004], [-121.24564, 38.74004], [-121.24543, 38.74002], [-121.2452, 38.73997], [-121.2451, 38.73998], [-121.24492, 38.74025], [-121.24486, 38.7404], [-121.2448, 38.74051], [-121.2447, 38.74063], [-121.24456, 38.74056], [-121.24477, 38.74033], [-121.24497, 38.73995], [-121.24464, 38.73963], [-121.2447, 38.7396], [-121.24482, 38.73963], [-121.24575, 38.73969], [-121.2459, 38.73964], [-121.24624, 38.73959], [-121.24647, 38.73948], [-121.24652, 38.73948], [-121.24659, 38.73955], [-121.24687, 38.73948], [-121.24703, 38.7395], [-121.24713, 38.73947], [-121.24715, 38.73941], [-121.2471, 38.73924], [-121.24711, 38.73914], [-121.24716, 38.7391], [-121.24725, 38.73908], [-121.24717, 38.73902], [-121.24718, 38.73889], [-121.24706, 38.73873], [-121.24772, 38.73942], [-121.24785, 38.7396]]], [[[-121.25347, 38.7387], [-121.25355, 38.7387], [-121.25361, 38.73874], [-121.25361, 38.73897], [-121.25358, 38.73925], [-121.25344, 38.73991], [-121.25342, 38.74016], [-121.25343, 38.74087], [-121.25342, 38.7409], [-121.25337, 38.74092], [-121.25329, 38.74093], [-121.2533, 38.74014], [-121.2531, 38.73997], [-121.25273, 38.73983], [-121.2527, 38.73961], [-121.2524, 38.73945], [-121.2523, 38.73954], [-121.25222, 38.73951], [-121.25215, 38.73951], [-121.25212, 38.73945], [-121.2502, 38.73947], [-121.24987, 38.73937], [-121.25006, 38.73908], [-121.25045, 38.73908], [-121.25053, 38.73904], [-121.25061, 38.73907], [-121.25072, 38.73906], [-121.2508, 38.73911], [-121.25117, 38.73907], [-121.25138, 38.73892], [-121.25157, 38.73883], [-121.25181, 38.73889], [-121.25204, 38.73889], [-121.25226, 38.73886], [-121.25227, 38.73884], [-121.25246, 38.73889], [-121.25272, 38.73904], [-121.25279, 38.73904], [-121.25282, 38.7391], [-121.25288, 38.73914], [-121.25299, 38.73915], [-121.25303, 38.7392], [-121.25341, 38.73932], [-121.25348, 38.73891], [-121.25347, 38.7387]]]]} | Open Access 1 | 20937 | City Open Space | 17336 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 9.82 | City OS | 0 | Local Recreation Area 3 | 4 | |
| 16191 | 16191 | 16190 | {"type": "MultiPolygon", "coordinates": [[[[-121.33096, 38.78617], [-121.33052, 38.78646], [-121.33031, 38.78629], [-121.33019, 38.78624], [-121.33002, 38.78623], [-121.32975, 38.78626], [-121.32967, 38.78625], [-121.32955, 38.78626], [-121.32951, 38.78624], [-121.32941, 38.7862], [-121.32908, 38.78617], [-121.3289, 38.7861], [-121.32886, 38.78612], [-121.32881, 38.78609], [-121.32877, 38.78602], [-121.32873, 38.78601], [-121.32873, 38.78513], [-121.32903, 38.78529], [-121.32944, 38.78538], [-121.33021, 38.78538], [-121.33067, 38.7856], [-121.33088, 38.78576], [-121.33096, 38.78595], [-121.33096, 38.78617]]], [[[-121.344, 38.79455], [-121.34327, 38.79478], [-121.3428, 38.7949], [-121.34244, 38.79496], [-121.34115, 38.79514], [-121.34068, 38.79517], [-121.34013, 38.79518], [-121.34012, 38.79475], [-121.33983, 38.79472], [-121.33961, 38.79465], [-121.33921, 38.7946], [-121.33896, 38.79456], [-121.33872, 38.79445], [-121.33852, 38.79431], [-121.33819, 38.79398], [-121.33813, 38.79379], [-121.33817, 38.7937], [-121.33812, 38.79364], [-121.33812, 38.79354], [-121.33779, 38.79329], [-121.33774, 38.79317], [-121.33748, 38.79307], [-121.33718, 38.79307], [-121.3373, 38.79295], [-121.33743, 38.79294], [-121.3378, 38.793], [-121.33782, 38.79304], [-121.33792, 38.79307], [-121.33801, 38.79305], [-121.33802, 38.79298], [-121.33773, 38.79247], [-121.33769, 38.79248], [-121.33755, 38.7924], [-121.33727, 38.79201], [-121.33727, 38.79174], [-121.33719, 38.79167], [-121.33679, 38.79137], [-121.33633, 38.79124], [-121.33559, 38.79124], [-121.33517, 38.79112], [-121.33498, 38.79096], [-121.33482, 38.79084], [-121.33482, 38.79077], [-121.3344, 38.79055], [-121.3343, 38.79046], [-121.33414, 38.79038], [-121.33403, 38.7903], [-121.33384, 38.79007], [-121.33354, 38.78987], [-121.33338, 38.78983], [-121.3332, 38.78973], [-121.33299, 38.78951], [-121.33273, 38.78949], [-121.33265, 38.7895], [-121.33216, 38.78943], [-121.33206, 38.78939], [-121.33186, 38.78946], [-121.33124, 38.78922], [-121.33126, 38.78903], [-121.33132, 38.78898], [-121.33145, 38.78891], [-121.33151, 38.78877], [-121.33144, 38.78861], [-121.33138, 38.78823], [-121.33121, 38.78791], [-121.33127, 38.78787], [-121.33129, 38.78779], [-121.33105, 38.78762], [-121.33097, 38.78751], [-121.33086, 38.78743], [-121.33066, 38.78699], [-121.33065, 38.78695], [-121.33056, 38.7867], [-121.33095, 38.78645], [-121.33095, 38.78657], [-121.33106, 38.78671], [-121.33162, 38.78658], [-121.33168, 38.78652], [-121.33157, 38.78635], [-121.33163, 38.78626], [-121.33174, 38.78624], [-121.33186, 38.78618], [-121.33198, 38.78606], [-121.33205, 38.78603], [-121.33198, 38.78622], [-121.33182, 38.78645], [-121.3319, 38.7866], [-121.33193, 38.78672], [-121.33183, 38.78675], [-121.33152, 38.78676], [-121.33149, 38.78687], [-121.33132, 38.78699], [-121.33131, 38.78704], [-121.33147, 38.78716], [-121.332, 38.78745], [-121.33202, 38.78752], [-121.3321, 38.78755], [-121.33218, 38.78755], [-121.33229, 38.78749], [-121.3324, 38.78726], [-121.33254, 38.78716], [-121.33275, 38.78714], [-121.33291, 38.7872], [-121.33308, 38.78736], [-121.33313, 38.78768], [-121.33298, 38.78786], [-121.33238, 38.78827], [-121.3323, 38.78844], [-121.33232, 38.78855], [-121.33257, 38.78873], [-121.33321, 38.78898], [-121.3335, 38.78905], [-121.33367, 38.78913], [-121.33382, 38.78927], [-121.33403, 38.78925], [-121.33451, 38.78928], [-121.33462, 38.78933], [-121.33469, 38.78942], [-121.33458, 38.78978], [-121.33467, 38.79003], [-121.33492, 38.79024], [-121.33494, 38.79023], [-121.33519, 38.78892], [-121.33527, 38.78895], [-121.33537, 38.78884], [-121.33515, 38.78844], [-121.33545, 38.78814], [-121.33549, 38.78812], [-121.33555, 38.78813], [-121.33571, 38.78823], [-121.3359, 38.78831], [-121.33632, 38.78846], [-121.33662, 38.78863], [-121.3368, 38.78871], [-121.33707, 38.78879], [-121.3374, 38.78884], [-121.33743, 38.78887], [-121.33744, 38.78901], [-121.33748, 38.78913], [-121.33759, 38.78932], [-121.33778, 38.78949], [-121.3379, 38.78957], [-121.33806, 38.78965], [-121.33834, 38.78971], [-121.33859, 38.78973], [-121.33885, 38.78969], [-121.33921, 38.78959], [-121.33937, 38.78957], [-121.33946, 38.78958], [-121.33949, 38.78963], [-121.33949, 38.79017], [-121.33905, 38.79018], [-121.33906, 38.79099], [-121.33944, 38.791], [-121.3394, 38.79104], [-121.33938, 38.7911], [-121.33939, 38.79116], [-121.33943, 38.79121], [-121.33906, 38.79145], [-121.33906, 38.79173], [-121.34011, 38.79174], [-121.34012, 38.79303], [-121.34096, 38.79326], [-121.34094, 38.79355], [-121.34114, 38.79372], [-121.34133, 38.79379], [-121.34156, 38.7938], [-121.34185, 38.79366], [-121.34193, 38.79355], [-121.34321, 38.79411], [-121.3436, 38.79433], [-121.34385, 38.79429], [-121.344, 38.79455]]]]} | Open Access 1 | 29446 | Blue Oaks Open Space | 16183 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 69.837 | Blue Oaks OS | 0 | Local Recreation Area 3 | 4 | |
| 16198 | 16198 | 16197 | {"type": "MultiPolygon", "coordinates": [[[[-121.34941, 38.79537], [-121.34798, 38.79538], [-121.34717, 38.79574], [-121.34689, 38.7957], [-121.3466, 38.79572], [-121.34636, 38.79581], [-121.34598, 38.79589], [-121.34575, 38.79591], [-121.34553, 38.79633], [-121.34539, 38.79642], [-121.34546, 38.79651], [-121.34533, 38.79656], [-121.34503, 38.79653], [-121.34482, 38.79647], [-121.34463, 38.79639], [-121.3443, 38.79618], [-121.34403, 38.79595], [-121.34386, 38.79578], [-121.34362, 38.79541], [-121.34649, 38.79539], [-121.34649, 38.79424], [-121.34613, 38.79383], [-121.34831, 38.79267], [-121.34883, 38.79244], [-121.3494, 38.79224], [-121.34941, 38.79537]]], [[[-121.35801, 38.79652], [-121.35705, 38.79746], [-121.35665, 38.79764], [-121.35666, 38.79765], [-121.35697, 38.79762], [-121.35696, 38.79774], [-121.35703, 38.79776], [-121.35705, 38.7978], [-121.35693, 38.79835], [-121.35683, 38.79867], [-121.35669, 38.79897], [-121.35642, 38.79941], [-121.35463, 38.7994], [-121.35463, 38.79941], [-121.3554, 38.80031], [-121.35405, 38.80103], [-121.35391, 38.8008], [-121.35328, 38.79965], [-121.3533, 38.7996], [-121.35353, 38.79945], [-121.35364, 38.79932], [-121.35372, 38.79919], [-121.35377, 38.79905], [-121.35364, 38.79904], [-121.35357, 38.7992], [-121.35348, 38.79933], [-121.35336, 38.79943], [-121.35313, 38.79954], [-121.35287, 38.7996], [-121.35269, 38.7996], [-121.35251, 38.79957], [-121.35235, 38.79951], [-121.35213, 38.79937], [-121.35199, 38.79919], [-121.35172, 38.79852], [-121.35169, 38.79835], [-121.35168, 38.79824], [-121.35161, 38.79817], [-121.3515, 38.79816], [-121.35015, 38.79832], [-121.3494, 38.79846], [-121.34939, 38.7984], [-121.3487, 38.79854], [-121.34812, 38.79871], [-121.34791, 38.79878], [-121.34731, 38.79909], [-121.34697, 38.79912], [-121.34689, 38.79916], [-121.34667, 38.79889], [-121.34614, 38.79806], [-121.34599, 38.79788], [-121.34656, 38.79754], [-121.34683, 38.79753], [-121.34706, 38.79734], [-121.34744, 38.79725], [-121.34749, 38.79719], [-121.3479, 38.79713], [-121.34798, 38.79701], [-121.34794, 38.79683], [-121.348, 38.79653], [-121.34805, 38.79653], [-121.34824, 38.79633], [-121.34851, 38.79618], [-121.34862, 38.796], [-121.34879, 38.79586], [-121.34941, 38.79566], [-121.34942, 38.79647], [-121.35801, 38.79652]]], [[[-121.3539, 38.80109], [-121.35254, 38.80165], [-121.35206, 38.80044], [-121.35202, 38.80031], [-121.35203, 38.80017], [-121.35208, 38.80001], [-121.35231, 38.79968], [-121.35239, 38.79965], [-121.35266, 38.7997], [-121.35285, 38.7997], [-121.35306, 38.79968], [-121.35311, 38.7997], [-121.35375, 38.80085], [-121.3539, 38.80109]]]]} | No Public Access 3 | 29577 | Veterans Memorial Park Open Space | 27036 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 95.757 | Veterans Memorial Park OS | 0 | Local Recreation Area 3 | 4 | |
| 16204 | 16204 | 16203 | {"type": "Polygon", "coordinates": [[[-121.23553, 38.74068], [-121.23539, 38.74086], [-121.23514, 38.74106], [-121.23489, 38.74119], [-121.23435, 38.74156], [-121.23407, 38.7416], [-121.23393, 38.74169], [-121.23375, 38.74167], [-121.23358, 38.74188], [-121.23352, 38.74209], [-121.23333, 38.74225], [-121.23302, 38.74237], [-121.23287, 38.74239], [-121.23276, 38.74249], [-121.23248, 38.74254], [-121.23238, 38.74274], [-121.23176, 38.74268], [-121.23136, 38.74271], [-121.2312, 38.74277], [-121.23094, 38.74266], [-121.23083, 38.74274], [-121.23059, 38.74277], [-121.2302, 38.74297], [-121.22966, 38.74303], [-121.22909, 38.74307], [-121.22908, 38.7427], [-121.22927, 38.74277], [-121.22951, 38.74278], [-121.23, 38.74251], [-121.23004, 38.74238], [-121.23036, 38.7422], [-121.2305, 38.74232], [-121.23084, 38.74228], [-121.2314, 38.74228], [-121.23169, 38.7422], [-121.23181, 38.74208], [-121.23207, 38.74207], [-121.23242, 38.742], [-121.23269, 38.74192], [-121.23315, 38.74164], [-121.23324, 38.7414], [-121.23344, 38.74119], [-121.23374, 38.74106], [-121.2342, 38.74085], [-121.2344, 38.74083], [-121.23447, 38.74069], [-121.23465, 38.74057], [-121.23471, 38.74048], [-121.23472, 38.74022], [-121.23454, 38.74011], [-121.23439, 38.73991], [-121.23418, 38.73977], [-121.23403, 38.73974], [-121.23367, 38.73958], [-121.23347, 38.73954], [-121.23328, 38.73946], [-121.23307, 38.73953], [-121.23289, 38.73952], [-121.23197, 38.7393], [-121.23187, 38.73941], [-121.23173, 38.73944], [-121.23159, 38.73962], [-121.23135, 38.73959], [-121.2307, 38.73978], [-121.2304, 38.73988], [-121.23003, 38.73988], [-121.22985, 38.73978], [-121.22921, 38.73951], [-121.22858, 38.73909], [-121.22824, 38.73905], [-121.2281, 38.73914], [-121.22757, 38.73919], [-121.22729, 38.73924], [-121.22708, 38.73921], [-121.22685, 38.73904], [-121.22673, 38.73886], [-121.2266, 38.73885], [-121.22655, 38.73895], [-121.22645, 38.73898], [-121.22619, 38.73895], [-121.22611, 38.73895], [-121.22604, 38.73787], [-121.22607, 38.73754], [-121.22607, 38.73741], [-121.2263, 38.73732], [-121.22674, 38.73728], [-121.22707, 38.73733], [-121.22751, 38.73732], [-121.22773, 38.73735], [-121.2279, 38.73746], [-121.228, 38.73757], [-121.22818, 38.73759], [-121.22841, 38.73789], [-121.22864, 38.73809], [-121.22878, 38.73829], [-121.22911, 38.73851], [-121.22931, 38.73872], [-121.22965, 38.73897], [-121.22984, 38.73919], [-121.22965, 38.7393], [-121.22956, 38.73944], [-121.23024, 38.73974], [-121.23203, 38.73923], [-121.23264, 38.7393], [-121.23264, 38.73865], [-121.23316, 38.73897], [-121.23339, 38.73894], [-121.23351, 38.73884], [-121.23378, 38.73876], [-121.23407, 38.73883], [-121.23455, 38.73912], [-121.23461, 38.7395], [-121.23479, 38.73937], [-121.23492, 38.73933], [-121.23519, 38.7394], [-121.23543, 38.73936], [-121.23545, 38.7401], [-121.23553, 38.74068]]]} | Open Access 1 | 31300 | City Open Space | 17336 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 28.048 | City OS | 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]);