units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
130 rows where MNG_AGENCY = 533 and MNG_AG_TYP = 2 sorted by SUID_NMA
This data as json, copyable, CSV (advanced)
DES_TP 9
- Local Park 67
- Local Other or Unknown 46
- Local Recreation Area 9
- Local Conservation Area 3
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency · 130 ✖
MNG_AGENCY 1
- Roseville, City of · 130 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3633 | 3633 | 3632 | {"type": "Polygon", "coordinates": [[[-121.33483, 38.79171], [-121.33446, 38.79171], [-121.3334, 38.79087], [-121.3337, 38.79064], [-121.33377, 38.79063], [-121.33391, 38.79064], [-121.33401, 38.7906], [-121.33406, 38.79053], [-121.33406, 38.79047], [-121.33402, 38.79041], [-121.33395, 38.79036], [-121.33403, 38.7903], [-121.33414, 38.79038], [-121.3343, 38.79046], [-121.3344, 38.79055], [-121.33482, 38.79077], [-121.33483, 38.79171]]]} | Open Access 1 | 29447 | Adam V. Baquera Park | 15257 | 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 | 2.668 | Adam V. Baquera Park | 0 | Local Park 2 | 4 | |
4276 | 4276 | 4275 | {"type": "Polygon", "coordinates": [[[-121.36832, 38.78194], [-121.36963, 38.78194], [-121.36975, 38.78195], [-121.36987, 38.78199], [-121.37, 38.78209], [-121.37005, 38.78218], [-121.37006, 38.78232], [-121.37003, 38.78241], [-121.36996, 38.7825], [-121.36982, 38.78258], [-121.3697, 38.78261], [-121.3683, 38.78261], [-121.36826, 38.78259], [-121.36824, 38.78254], [-121.36824, 38.78201], [-121.36826, 38.78197], [-121.36832, 38.78194]]]} | Open Access 1 | 45270 | Alberto and Carmen Heredia Park | 15340 | 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 | 2.744 | Alberto and Carmen Heredia Park | 0 | Local Park 2 | 4 | |
5033 | 5033 | 5032 | {"type": "Polygon", "coordinates": [[[-121.28497, 38.79373], [-121.28355, 38.79373], [-121.28355, 38.7922], [-121.28497, 38.7922], [-121.28497, 38.79373]]]} | Open Access 1 | 20877 | Aldo Pineschi Sr. Park | 15350 | 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 | 5.163 | Aldo Pineschi Sr. Park | 0 | Local Park 2 | 4 | |
11671 | 11671 | 11670 | {"type": "Polygon", "coordinates": [[[-121.3401, 38.76633], [-121.34009, 38.76786], [-121.33924, 38.76787], [-121.33874, 38.76789], [-121.33547, 38.76823], [-121.33548, 38.76634], [-121.3401, 38.76633]]]} | Open Access 1 | 29445 | Bear Dog Park | 15925 | 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 | 18.408 | Bear Dog Park | 0 | Local Park 2 | 4 | |
12617 | 12617 | 12616 | {"type": "Polygon", "coordinates": [[[-121.35653, 38.7572], [-121.35652, 38.75723], [-121.35638, 38.75744], [-121.35619, 38.75768], [-121.35508, 38.75889], [-121.35308, 38.75775], [-121.35457, 38.75615], [-121.3546, 38.75621], [-121.35466, 38.75625], [-121.35474, 38.75626], [-121.35483, 38.75624], [-121.35492, 38.75626], [-121.3565, 38.75716], [-121.35653, 38.7572]]]} | Open Access 1 | 29443 | Bill Santucci Park | 16112 | 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 | 11.977 | Bill Santucci Park | 0 | Local Park 2 | 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 | |
10902 | 10902 | 10901 | {"type": "MultiPolygon", "coordinates": [[[[-121.33139, 38.7838], [-121.33161, 38.78383], [-121.33183, 38.7839], [-121.33292, 38.78439], [-121.33295, 38.78442], [-121.33295, 38.78445], [-121.33282, 38.78464], [-121.33261, 38.78488], [-121.33216, 38.78532], [-121.33161, 38.78575], [-121.33096, 38.78617], [-121.33096, 38.78595], [-121.33088, 38.78577], [-121.33067, 38.78559], [-121.33021, 38.78538], [-121.32944, 38.78538], [-121.32903, 38.78529], [-121.32873, 38.78513], [-121.32873, 38.78294], [-121.32899, 38.78294], [-121.32901, 38.783], [-121.32904, 38.78303], [-121.32916, 38.78306], [-121.32922, 38.78304], [-121.32934, 38.78295], [-121.32953, 38.78294], [-121.32953, 38.78317], [-121.32956, 38.78331], [-121.32964, 38.78348], [-121.32973, 38.78362], [-121.32986, 38.78376], [-121.33003, 38.78388], [-121.33019, 38.78397], [-121.33038, 38.78404], [-121.33058, 38.78409], [-121.33081, 38.78411], [-121.33102, 38.78411], [-121.33153, 38.78405], [-121.33154, 38.78404], [-121.33139, 38.7838]]], [[[-121.33561, 38.78584], [-121.33453, 38.78693], [-121.33485, 38.78711], [-121.33428, 38.78774], [-121.33475, 38.78801], [-121.33413, 38.78864], [-121.33423, 38.78908], [-121.33448, 38.78911], [-121.33453, 38.78917], [-121.33461, 38.7892], [-121.3347, 38.78918], [-121.33476, 38.78913], [-121.33514, 38.78916], [-121.33493, 38.79025], [-121.33467, 38.79003], [-121.33458, 38.78978], [-121.33469, 38.78943], [-121.33462, 38.78933], [-121.33451, 38.78928], [-121.33403, 38.78925], [-121.33382, 38.78927], [-121.33367, 38.78913], [-121.3335, 38.78905], [-121.33321, 38.78898], [-121.33257, 38.78873], [-121.33232, 38.78855], [-121.3323, 38.78845], [-121.33238, 38.78827], [-121.33298, 38.78786], [-121.33313, 38.78767], [-121.33308, 38.78735], [-121.33291, 38.7872], [-121.33275, 38.78714], [-121.33254, 38.78716], [-121.3324, 38.78726], [-121.3323, 38.78749], [-121.33217, 38.78755], [-121.3321, 38.78755], [-121.33202, 38.78752], [-121.332, 38.78744], [-121.33147, 38.78716], [-121.33131, 38.78704], [-121.33132, 38.78699], [-121.33141, 38.78694], [-121.33149, 38.78687], [-121.33151, 38.78676], [-121.33155, 38.78675], [-121.33183, 38.78675], [-121.33192, 38.78672], [-121.3319, 38.7866], [-121.33182, 38.78645], [-121.33198, 38.78622], [-121.33204, 38.78604], [-121.33198, 38.78606], [-121.33186, 38.78618], [-121.33174, 38.78624], [-121.33163, 38.78627], [-121.33158, 38.78635], [-121.33168, 38.78652], [-121.33162, 38.78658], [-121.33106, 38.78671], [-121.33095, 38.78657], [-121.33095, 38.78645], [-121.33176, 38.78593], [-121.33203, 38.78573], [-121.33238, 38.78544], [-121.33277, 38.78506], [-121.33319, 38.78456], [-121.33323, 38.78454], [-121.33329, 38.78454], [-121.33437, 38.78503], [-121.33561, 38.78584]]]]} | Open Access 1 | 20855 | Blue Oaks Park | 16184 | 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 | 42.568 | Blue Oaks Park | 0 | Local Park 2 | 4 | |
4095 | 4095 | 4094 | {"type": "Polygon", "coordinates": [[[-121.37638, 38.77648], [-121.37582, 38.7765], [-121.3749, 38.77687], [-121.37462, 38.7772], [-121.37463, 38.77749], [-121.37493, 38.77792], [-121.37493, 38.7783], [-121.37526, 38.77842], [-121.37505, 38.77852], [-121.37501, 38.7786], [-121.37492, 38.77859], [-121.37481, 38.77862], [-121.3737, 38.77862], [-121.37369, 38.77609], [-121.37453, 38.77609], [-121.37638, 38.77648]]]} | Open Access 1 | 44549 | Bud Nichols Park | 16479 | 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 | 7.988 | Bud Nichols Park | 0 | Local Park 2 | 4 | |
3045 | 3045 | 3044 | {"type": "Polygon", "coordinates": [[[-121.30116, 38.77832], [-121.30101, 38.77845], [-121.30094, 38.77862], [-121.30091, 38.77879], [-121.30009, 38.77873], [-121.29953, 38.7787], [-121.29772, 38.77868], [-121.29774, 38.77679], [-121.30098, 38.77681], [-121.30094, 38.77822], [-121.30115, 38.77823], [-121.30116, 38.77832]]]} | Open Access 1 | 20875 | Buljan Park | 16500 | 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 | 14.845 | Buljan Park | 0 | Local Park 2 | 4 | |
4094 | 4094 | 4093 | {"type": "Polygon", "coordinates": [[[-121.36163, 38.78195], [-121.36202, 38.78195], [-121.36207, 38.78197], [-121.3621, 38.78202], [-121.3621, 38.78293], [-121.36208, 38.78302], [-121.36204, 38.78311], [-121.36196, 38.78318], [-121.36186, 38.78322], [-121.36173, 38.78325], [-121.36153, 38.78324], [-121.36138, 38.78317], [-121.36128, 38.78306], [-121.36125, 38.78293], [-121.36125, 38.782], [-121.36127, 38.78196], [-121.36133, 38.78195], [-121.36163, 38.78195]]]} | Open Access 1 | 44548 | C. Doulton Burner Park | 16626 | 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 | 2.505 | C. Doulton Burner Park | 0 | Local Park 2 | 4 | |
5034 | 5034 | 5033 | {"type": "Polygon", "coordinates": [[[-121.2388, 38.76523], [-121.23847, 38.76535], [-121.23837, 38.76531], [-121.23826, 38.76531], [-121.23819, 38.76535], [-121.23815, 38.76541], [-121.23814, 38.76548], [-121.23818, 38.76554], [-121.23789, 38.7657], [-121.2375, 38.76574], [-121.23744, 38.76562], [-121.23735, 38.76551], [-121.23723, 38.76541], [-121.23707, 38.76532], [-121.23704, 38.76527], [-121.23718, 38.76505], [-121.23735, 38.76483], [-121.23754, 38.76463], [-121.23784, 38.76438], [-121.23858, 38.76499], [-121.23871, 38.76512], [-121.2388, 38.76523]]]} | Open Access 1 | 20837 | Cambria Park | 16749 | 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 | 3.001 | Cambria Park | 0 | Local Park 2 | 4 | |
3046 | 3046 | 3045 | {"type": "Polygon", "coordinates": [[[-121.27975, 38.78866], [-121.27802, 38.79079], [-121.27802, 38.79158], [-121.27738, 38.79117], [-121.27687, 38.7909], [-121.27644, 38.79071], [-121.27466, 38.79], [-121.27461, 38.78994], [-121.27462, 38.78989], [-121.27478, 38.78965], [-121.27698, 38.78962], [-121.27697, 38.78808], [-121.27663, 38.78743], [-121.27717, 38.78714], [-121.27771, 38.7868], [-121.27778, 38.7868], [-121.27783, 38.78683], [-121.27793, 38.78698], [-121.27816, 38.78726], [-121.2783, 38.78738], [-121.27856, 38.78767], [-121.27887, 38.78798], [-121.2793, 38.78833], [-121.27975, 38.78866]]]} | Open Access 1 | 20878 | Central Park | 17058 | 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 | 22.886 | Central Park | 0 | Local Park 2 | 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 | |
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 | |
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 | |
10913 | 10913 | 10912 | {"type": "Polygon", "coordinates": [[[-121.29803, 38.7269], [-121.29665, 38.7269], [-121.29661, 38.72687], [-121.29659, 38.72684], [-121.29664, 38.72603], [-121.29671, 38.72579], [-121.29673, 38.72567], [-121.29803, 38.72567], [-121.29803, 38.7269]]]} | Open Access 1 | 20916 | Cresthaven Park | 17806 | 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 | 4.084 | Cresthaven Park | 0 | Local Park 2 | 4 | |
12648 | 12648 | 12647 | {"type": "Polygon", "coordinates": [[[-121.25289, 38.7212], [-121.25269, 38.72121], [-121.25269, 38.72142], [-121.25255, 38.72143], [-121.25255, 38.72224], [-121.25093, 38.72224], [-121.25087, 38.72221], [-121.25085, 38.72076], [-121.25288, 38.72077], [-121.25289, 38.7212]]]} | Open Access 1 | 29485 | Crestmont Park | 17809 | 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.387 | Crestmont Park | 0 | Local Park 2 | 4 | |
10889 | 10889 | 10888 | {"type": "Polygon", "coordinates": [[[-121.22636, 38.76641], [-121.22597, 38.76681], [-121.22581, 38.76691], [-121.22564, 38.76699], [-121.22522, 38.76711], [-121.22482, 38.76726], [-121.22478, 38.76716], [-121.22476, 38.76704], [-121.22476, 38.7666], [-121.22479, 38.76644], [-121.22488, 38.76626], [-121.22507, 38.76605], [-121.22515, 38.76594], [-121.22521, 38.76584], [-121.22525, 38.76571], [-121.22601, 38.76549], [-121.22606, 38.76579], [-121.22614, 38.76606], [-121.22613, 38.76612], [-121.22604, 38.76622], [-121.22603, 38.76627], [-121.22604, 38.76632], [-121.2261, 38.76638], [-121.22617, 38.76641], [-121.22626, 38.76641], [-121.22634, 38.76638], [-121.22636, 38.76641]]]} | Open Access 1 | 20836 | David Uribe Park | 17945 | 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 | 3.999 | David Uribe Park | 0 | Local Park 2 | 4 | |
3636 | 3636 | 3635 | {"type": "Polygon", "coordinates": [[[-121.2735, 38.793], [-121.2735, 38.793], [-121.27194, 38.79238], [-121.27218, 38.79202], [-121.2723, 38.79191], [-121.27246, 38.79182], [-121.27265, 38.79175], [-121.27284, 38.79173], [-121.27305, 38.79174], [-121.27326, 38.79179], [-121.27343, 38.79187], [-121.27359, 38.792], [-121.2737, 38.79214], [-121.27376, 38.79231], [-121.27377, 38.79243], [-121.27374, 38.7926], [-121.27369, 38.7927], [-121.2735, 38.793]]]} | Open Access 1 | 29460 | Del Stephenson Park | 18056 | 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 | 3.526 | Del Stephenson Park | 0 | Local Park 2 | 4 | |
2641 | 2641 | 2640 | {"type": "Polygon", "coordinates": [[[-121.3441, 38.77738], [-121.34408, 38.77766], [-121.34393, 38.77766], [-121.34396, 38.77738], [-121.3441, 38.77738]]]} | Open Access 1 | 20860 | Diamond Oaks | 18143 | 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 | 0.102 | Diamond Oaks | None 218 |
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]);