units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
123 rows where ACCESS_TYP = 1 and MNG_AGENCY = 533
This data as json, copyable, CSV (advanced)
DES_TP 8
- Local Park 52
- Local Other or Unknown 43
- Local Recreation Area 4
- Local Conservation Area 1
- None 1
- None 1
- None 1
- None 1
MNG_AG_TYP 1
- City Agency 104
MNG_AGENCY 1
- Roseville, City of · 104 ✖
ACCESS_TYP 1
- Open Access · 104 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3664 | 3664 | 3663 | {"type": "Polygon", "coordinates": [[[-121.3465, 38.79539], [-121.3411, 38.79543], [-121.3411, 38.79542], [-121.34159, 38.79537], [-121.34265, 38.79521], [-121.34315, 38.7951], [-121.34381, 38.79492], [-121.34428, 38.79475], [-121.34485, 38.79451], [-121.34613, 38.79383], [-121.34649, 38.79424], [-121.3465, 38.79539]]]} | Open Access 1 | 29635 | Veterans Memorial Park | 27032 | 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.926 | Veterans Memorial 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 | |
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 | |
4096 | 4096 | 4095 | {"type": "Polygon", "coordinates": [[[-121.36411, 38.77865], [-121.36211, 38.77865], [-121.36211, 38.77832], [-121.36206, 38.77773], [-121.36206, 38.77704], [-121.36204, 38.77703], [-121.36206, 38.77698], [-121.36209, 38.77695], [-121.36214, 38.77694], [-121.36326, 38.77694], [-121.36351, 38.77693], [-121.36375, 38.77689], [-121.36411, 38.77678], [-121.36411, 38.77865]]]} | Open Access 1 | 44551 | Fred Festersen Park | 19074 | 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 | 8.398 | Fred Festersen 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 | |
4814 | 4814 | 4813 | {"type": "Polygon", "coordinates": [[[-121.22585, 38.76387], [-121.22532, 38.76402], [-121.22495, 38.76411], [-121.22456, 38.76418], [-121.22408, 38.76423], [-121.22418, 38.76363], [-121.22563, 38.76349], [-121.22577, 38.76368], [-121.22585, 38.76387]]]} | Open Access 1 | 48764 | Unknown Park - Roseville, City of | 33491 | 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.092 | 0 | Local Other or Unknown 14 | 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 | |
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 | |
5036 | 5036 | 5035 | {"type": "Polygon", "coordinates": [[[-121.34655, 38.7663], [-121.34587, 38.76643], [-121.34525, 38.76661], [-121.34472, 38.76681], [-121.34337, 38.76736], [-121.34293, 38.76751], [-121.34259, 38.76761], [-121.34201, 38.76774], [-121.34154, 38.76782], [-121.34095, 38.76788], [-121.34047, 38.7679], [-121.34009, 38.7679], [-121.34009, 38.76633], [-121.33548, 38.76634], [-121.33547, 38.76823], [-121.33303, 38.76848], [-121.33213, 38.76853], [-121.33153, 38.76852], [-121.33111, 38.76849], [-121.33038, 38.76849], [-121.33031, 38.76847], [-121.33025, 38.76843], [-121.33021, 38.76839], [-121.33019, 38.76833], [-121.33019, 38.76766], [-121.33014, 38.76716], [-121.33015, 38.76655], [-121.3302, 38.76608], [-121.33028, 38.76552], [-121.33041, 38.76496], [-121.33057, 38.7644], [-121.33077, 38.76386], [-121.33485, 38.76387], [-121.33486, 38.76544], [-121.34009, 38.76526], [-121.34011, 38.76633], [-121.34655, 38.7663]]]} | Open Access 1 | 20857 | Mahany Park | 21686 | 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 | 79.555 | Mahany Park | 0 | Local Park 2 | 4 | |
5354 | 5354 | 5353 | {"type": "MultiPolygon", "coordinates": [[[[-121.27808, 38.76655], [-121.27727, 38.76671], [-121.27706, 38.76678], [-121.27681, 38.76692], [-121.27676, 38.76693], [-121.27669, 38.7669], [-121.27662, 38.76679], [-121.27658, 38.76669], [-121.27657, 38.76656], [-121.27808, 38.76655]]], [[[-121.27819, 38.76686], [-121.27801, 38.76687], [-121.27729, 38.76695], [-121.27733, 38.76685], [-121.27735, 38.76684], [-121.27815, 38.76669], [-121.27819, 38.7667], [-121.27822, 38.76673], [-121.27822, 38.76677], [-121.27819, 38.76686]]]]} | Open Access 1 | 36420 | Roseville holding 29 | 24648 | 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.864 | Roseville holding 29 | 0 | Local Other or Unknown 14 | 4 | |
5385 | 5385 | 5384 | {"type": "Polygon", "coordinates": [[[-121.28307, 38.78], [-121.28264, 38.78022], [-121.28219, 38.78039], [-121.28199, 38.78005], [-121.28182, 38.77989], [-121.28146, 38.77964], [-121.28221, 38.77939], [-121.28307, 38.78]]]} | Open Access 1 | 36418 | Roseville holding 31 | 24651 | 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 | 1.841 | Roseville holding 31 | 0 | Local Other or Unknown 14 | 4 | |
5386 | 5386 | 5385 | {"type": "Polygon", "coordinates": [[[-121.31243, 38.80095], [-121.3121, 38.80123], [-121.31177, 38.801], [-121.31176, 38.80095], [-121.31148, 38.80074], [-121.31191, 38.80058], [-121.31243, 38.80095]]]} | Open Access 1 | 36419 | Roseville holding 30 | 24650 | 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.7 | Roseville holding 30 | 0 | Local Other or Unknown 14 | 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 | |
10897 | 10897 | 10896 | {"type": "Polygon", "coordinates": [[[-121.33607, 38.80579], [-121.33607, 38.80666], [-121.33435, 38.80665], [-121.33415, 38.80581], [-121.33417, 38.80577], [-121.33422, 38.80574], [-121.33466, 38.80568], [-121.33501, 38.80567], [-121.33549, 38.80569], [-121.33607, 38.80579]]]} | Open Access 1 | 20851 | Leonard Davis Park | 21173 | 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.123 | Leonard Davis Park | 0 | Local Park 2 | 4 | |
10900 | 10900 | 10899 | {"type": "Polygon", "coordinates": [[[-121.33031, 38.75424], [-121.33027, 38.75428], [-121.32987, 38.75429], [-121.32986, 38.75538], [-121.32913, 38.75519], [-121.32896, 38.75513], [-121.32875, 38.75502], [-121.32837, 38.75476], [-121.32797, 38.7546], [-121.32792, 38.75455], [-121.32793, 38.7545], [-121.32819, 38.75407], [-121.32825, 38.75403], [-121.32874, 38.75417], [-121.32889, 38.75419], [-121.3291, 38.75419], [-121.32942, 38.75414], [-121.32993, 38.75394], [-121.32997, 38.75396], [-121.33016, 38.75414], [-121.33031, 38.75424]]]} | Open Access 1 | 20891 | James A. Hall Park | 20341 | 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.361 | James A. Hall Park | 0 | Local Park 2 | 4 | |
10901 | 10901 | 10900 | {"type": "Polygon", "coordinates": [[[-121.31804, 38.75775], [-121.31713, 38.75822], [-121.31682, 38.75837], [-121.31629, 38.75858], [-121.31573, 38.75875], [-121.31504, 38.75891], [-121.31443, 38.759], [-121.31396, 38.75904], [-121.31348, 38.75905], [-121.31343, 38.75904], [-121.31339, 38.759], [-121.31341, 38.75865], [-121.31345, 38.7585], [-121.3135, 38.75837], [-121.31358, 38.75823], [-121.31369, 38.75809], [-121.31397, 38.75784], [-121.31458, 38.75829], [-121.31596, 38.7574], [-121.31702, 38.75682], [-121.31804, 38.75775]]]} | Open Access 1 | 20892 | JAMES W. WANISH PARK | 20354 | 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.213 | JAMES W. WANISH PARK | None 950 | |||
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 | |
10904 | 10904 | 10903 | {"type": "MultiPolygon", "coordinates": [[[[-121.29959, 38.76962], [-121.2993, 38.7698], [-121.29923, 38.76987], [-121.29918, 38.76996], [-121.29916, 38.77015], [-121.29909, 38.77023], [-121.29902, 38.77026], [-121.29895, 38.77027], [-121.29852, 38.77021], [-121.29834, 38.77026], [-121.29781, 38.77063], [-121.29753, 38.77099], [-121.29743, 38.77103], [-121.2973, 38.77105], [-121.29728, 38.77091], [-121.29738, 38.77088], [-121.29763, 38.77055], [-121.2982, 38.77014], [-121.29832, 38.77009], [-121.29848, 38.77006], [-121.29861, 38.77006], [-121.29888, 38.7701], [-121.29892, 38.7701], [-121.29896, 38.77006], [-121.29897, 38.76993], [-121.29901, 38.76983], [-121.29912, 38.76971], [-121.29946, 38.76949], [-121.29959, 38.76962]]], [[[-121.30131, 38.76977], [-121.30109, 38.7698], [-121.30087, 38.76974], [-121.30077, 38.77001], [-121.30059, 38.76995], [-121.30061, 38.7699], [-121.30055, 38.76978], [-121.30029, 38.76952], [-121.30004, 38.76946], [-121.29992, 38.76945], [-121.29981, 38.76947], [-121.29971, 38.76953], [-121.29926, 38.76909], [-121.29925, 38.76904], [-121.29938, 38.76892], [-121.2995, 38.76884], [-121.29964, 38.76879], [-121.2998, 38.76875], [-121.29992, 38.76929], [-121.30018, 38.76932], [-121.30025, 38.76925], [-121.30036, 38.76927], [-121.30039, 38.76931], [-121.30056, 38.76939], [-121.30083, 38.76944], [-121.30096, 38.76948], [-121.30126, 38.76949], [-121.30131, 38.76977]]], [[[-121.30185, 38.76993], [-121.3015, 38.76993], [-121.30142, 38.76957], [-121.30177, 38.76954], [-121.30185, 38.76993]]], [[[-121.30413, 38.77028], [-121.30379, 38.77055], [-121.30374, 38.77063], [-121.30374, 38.77072], [-121.30321, 38.77073], [-121.30284, 38.77079], [-121.30276, 38.77077], [-121.30273, 38.77074], [-121.30268, 38.77062], [-121.30253, 38.77014], [-121.3024, 38.76965], [-121.30229, 38.7691], [-121.30254, 38.76925], [-121.30251, 38.76928], [-121.30251, 38.7693], [-121.30256, 38.76932], [-121.3026, 38.76928], [-121.30314, 38.76959], [-121.30365, 38.76993], [-121.30413, 38.77028]]], [[[-121.31662, 38.77171], [-121.31619, 38.77188], [-121.31577, 38.77201], [-121.31578, 38.77177], [-121.31574, 38.77155], [-121.31561, 38.77139], [-121.31544, 38.77098], [-121.31523, 38.77076], [-121.31513, 38.77063], [-121.31501, 38.77051], [-121.31481, 38.77039], [-121.31453, 38.77035], [-121.31411, 38.77017], [-121.31393, 38.77022], [-121.31359, 38.77046], [-121.3134, 38.7704], [-121.31309, 38.76999], [-121.31309, 38.76967], [-121.31335, 38.76963], [-121.31368, 38.76973], [-121.31377, 38.76979], [-121.3139, 38.76983], [-121.3141, 38.76979], [-121.31416, 38.76971], [-121.31426, 38.76966], [-121.31466, 38.76978], [-121.31496, 38.76993], [-121.31529, 38.77021], [-121.31581, 38.77084], [-121.31587, 38.77099], [-121.3163, 38.77142], [-121.31639, 38.77154], [-121.31662, 38.77171]]], [[[-121.33001, 38.76511], [-121.32991, 38.76563], [-121.32982, 38.76636], [-121.32569, 38.76637], [-121.32568, 38.76502], [-121.32375, 38.76509], [-121.32375, 38.76473], [-121.32414, 38.76503], [-121.32558, 38.76498], [-121.32561, 38.76492], [-121.3256, 38.76477], [-121.32609, 38.76474], [-121.3261, 38.7649], [-121.32612, 38.76496], [-121.32932, 38.76485], [-121.32934, 38.76513], [-121.33001, 38.76511]]]]} | Open Access 1 | 20881 | Welands | 27335 | 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 | 26.924 | Welands | None 951 | |||
10905 | 10905 | 10904 | {"type": "MultiPolygon", "coordinates": [[[[-121.31267, 38.77031], [-121.31263, 38.77031], [-121.3125, 38.77038], [-121.31217, 38.77046], [-121.31183, 38.77081], [-121.3114, 38.77111], [-121.30965, 38.7717], [-121.30851, 38.77124], [-121.30799, 38.77124], [-121.30753, 38.77115], [-121.30707, 38.77137], [-121.30682, 38.77201], [-121.30648, 38.77217], [-121.30611, 38.77171], [-121.30565, 38.77121], [-121.30515, 38.77073], [-121.30467, 38.77032], [-121.30418, 38.76994], [-121.30367, 38.76958], [-121.30314, 38.76924], [-121.30221, 38.76872], [-121.30205, 38.76789], [-121.30196, 38.7676], [-121.30187, 38.76736], [-121.30311, 38.76736], [-121.30298, 38.7674], [-121.30284, 38.7676], [-121.303, 38.76893], [-121.3037, 38.76936], [-121.30598, 38.76938], [-121.3064, 38.76955], [-121.30657, 38.7693], [-121.30715, 38.76953], [-121.30743, 38.7696], [-121.30734, 38.76991], [-121.30771, 38.7699], [-121.30779, 38.77007], [-121.30887, 38.7708], [-121.30921, 38.77094], [-121.30975, 38.77097], [-121.31093, 38.77067], [-121.31205, 38.76981], [-121.31267, 38.76981], [-121.31267, 38.77031]]], [[[-121.30817, 38.76946], [-121.30796, 38.76949], [-121.30769, 38.76949], [-121.30747, 38.76947], [-121.3073, 38.76942], [-121.30727, 38.76937], [-121.30734, 38.76919], [-121.30734, 38.76901], [-121.3077, 38.76894], [-121.30776, 38.76907], [-121.30817, 38.76946]]]]} | Open Access 1 | 20882 | Rube Nelson Park | 24719 | 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 | 27.657 | Rube Nelson Park | 0 | Local Park 2 | 4 | |
10906 | 10906 | 10905 | {"type": "Polygon", "coordinates": [[[-121.30716, 38.75279], [-121.30714, 38.75468], [-121.30669, 38.75477], [-121.30648, 38.75479], [-121.3063, 38.75479], [-121.30601, 38.75474], [-121.30582, 38.75473], [-121.30319, 38.75473], [-121.30315, 38.75472], [-121.30313, 38.75469], [-121.30314, 38.75393], [-121.3034, 38.75392], [-121.30343, 38.75346], [-121.30456, 38.75345], [-121.30457, 38.75284], [-121.30485, 38.75284], [-121.30487, 38.7526], [-121.30597, 38.75261], [-121.30599, 38.75276], [-121.30716, 38.75279]]]} | Open Access 1 | 20889 | Kaseberg Park | 20556 | 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 | 16.595 | Kaseberg Park | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);