superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
117 rows where ACCESS_TYP = 1 and MNG_AGENCY = 533 sorted by map descending
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 117
MNG_AGENCY 1
- Roseville, City of · 117 ✖
ACCESS_TYP 1
- Open Access · 117 ✖
Link | rowid | id | map ▲ | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2336 | 2336 | 2335 | {"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 | Bud Nichols Park | 16479 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 7.991 | Bud Nichols Park | ||
13266 | 13266 | 13265 | {"type": "Polygon", "coordinates": [[[-121.37341, 38.77033], [-121.37244, 38.77128], [-121.3699, 38.76952], [-121.37086, 38.76865], [-121.37341, 38.77033]]]} | Open Access 1 | Mahan Park | https://www.roseville.ca.us/government/departments/parks/parks_places/mahan_park | 33489 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 9.504 | Mahan Park | |
1436 | 1436 | 1435 | {"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 | Alberto and Carmen Heredia Park | 15340 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 2.743 | Alberto and Carmen Heredia Park | ||
7416 | 7416 | 7415 | {"type": "Polygon", "coordinates": [[[-121.36549, 38.78949], [-121.36537, 38.78765], [-121.3654, 38.78776], [-121.36547, 38.78786], [-121.36562, 38.78798], [-121.36575, 38.78803], [-121.36596, 38.78806], [-121.36754, 38.78805], [-121.36768, 38.78807], [-121.36781, 38.7881], [-121.36793, 38.78816], [-121.36803, 38.78824], [-121.36813, 38.78839], [-121.36816, 38.78856], [-121.36812, 38.78872], [-121.368, 38.78887], [-121.36783, 38.78897], [-121.36769, 38.78901], [-121.36755, 38.78903], [-121.36607, 38.78903], [-121.36594, 38.78905], [-121.36575, 38.78911], [-121.36564, 38.78919], [-121.36553, 38.78933], [-121.36549, 38.78949]]]} | Open Access 1 | Norm Fratis Park | 22792 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 6.308 | Norm Fratis Park | ||
4370 | 4370 | 4369 | {"type": "Polygon", "coordinates": [[[-121.36411, 38.77865], [-121.36211, 38.77865], [-121.36211, 38.77832], [-121.36206, 38.77773], [-121.36206, 38.77704], [-121.36205, 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 | Fred Festersen Park | 19074 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 8.396 | Fred Festersen Park | ||
2447 | 2447 | 2446 | {"type": "Polygon", "coordinates": [[[-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.36202, 38.78195], [-121.36207, 38.78197]]]} | Open Access 1 | C. Doulton Burner Park | 16626 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 2.505 | C. Doulton Burner Park | ||
2021 | 2021 | 2020 | {"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 | Bill Santucci Park | 16112 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 11.977 | Bill Santucci Park | ||
4919 | 4919 | 4918 | {"type": "Polygon", "coordinates": [[[-121.35242, 38.80565], [-121.35241, 38.80569], [-121.35202, 38.8062], [-121.35196, 38.80623], [-121.35189, 38.80623], [-121.35125, 38.80594], [-121.35112, 38.80583], [-121.35107, 38.80568], [-121.35108, 38.80556], [-121.35112, 38.80548], [-121.35118, 38.8054], [-121.35127, 38.80534], [-121.35139, 38.8053], [-121.35152, 38.80528], [-121.35165, 38.80529], [-121.35177, 38.80533], [-121.35238, 38.8056], [-121.35242, 38.80565]]]} | Open Access 1 | Harrigan Greens | 19695 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1.997 | Harrigan Greens | ||
6895 | 6895 | 6894 | {"type": "Polygon", "coordinates": [[[-121.34706, 38.80492], [-121.34706, 38.80536], [-121.34699, 38.80571], [-121.34697, 38.80589], [-121.34696, 38.80708], [-121.34535, 38.8071], [-121.34535, 38.80677], [-121.34526, 38.80672], [-121.34528, 38.80667], [-121.34526, 38.8066], [-121.34535, 38.80656], [-121.34536, 38.8059], [-121.34527, 38.80585], [-121.34529, 38.8058], [-121.34527, 38.80573], [-121.34536, 38.80568], [-121.34537, 38.80468], [-121.34541, 38.80462], [-121.34578, 38.80474], [-121.34612, 38.80482], [-121.34652, 38.80487], [-121.347, 38.80487], [-121.34704, 38.80489], [-121.34706, 38.80492]]]} | Open Access 1 | Mel Hamel Park | 22106 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 9.035 | Mel Hamel Park | ||
6534 | 6534 | 6533 | {"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.34008, 38.76633], [-121.33549, 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 | Mahany Park | 21686 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 79.617 | Mahany Park | ||
3604 | 3604 | 3603 | {"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 | Diamond Oaks | 18143 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 0.101 | Diamond Oaks | ||
4822 | 4822 | 4821 | {"type": "Polygon", "coordinates": [[[-121.34235, 38.75638], [-121.34232, 38.75641], [-121.34232, 38.75703], [-121.34234, 38.75706], [-121.34229, 38.75713], [-121.3423, 38.75721], [-121.34225, 38.75724], [-121.34225, 38.75766], [-121.34206, 38.75775], [-121.34193, 38.75784], [-121.34169, 38.75804], [-121.34127, 38.75784], [-121.34105, 38.75768], [-121.34084, 38.75747], [-121.34068, 38.75721], [-121.34061, 38.75702], [-121.34057, 38.75681], [-121.34058, 38.75567], [-121.34062, 38.75563], [-121.34066, 38.75562], [-121.34232, 38.75563], [-121.34232, 38.7562], [-121.34235, 38.75623], [-121.34232, 38.75631], [-121.34235, 38.75638]]]} | Open Access 1 | H.C. Elliot Park | 19583 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 8.628 | H.C. Elliot Park | ||
1337 | 1337 | 1336 | {"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 | Bear Dog Park | 15925 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 18.407 | Bear Dog Park | ||
8958 | 8958 | 8957 | {"type": "Polygon", "coordinates": [[[-121.3399, 38.77607], [-121.33948, 38.77588], [-121.33948, 38.77588], [-121.33969, 38.77582], [-121.3399, 38.77607]]]} | Open Access 1 | Roseville holding 13 | 24631 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 0.081 | Roseville holding 13 | ||
8997 | 8997 | 8996 | {"type": "Polygon", "coordinates": [[[-121.33947, 38.77588], [-121.33905, 38.77566], [-121.33905, 38.77566], [-121.33934, 38.77566], [-121.33947, 38.77588]]]} | Open Access 1 | Roseville holding 9 | 24669 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 0.076 | Roseville holding 9 | ||
11236 | 11236 | 11235 | {"type": "Polygon", "coordinates": [[[-121.33746, 38.80162], [-121.33738, 38.80161], [-121.33727, 38.80178], [-121.33702, 38.80169], [-121.33682, 38.80167], [-121.33667, 38.8017], [-121.33646, 38.80179], [-121.33611, 38.80189], [-121.3357, 38.80158], [-121.33558, 38.80162], [-121.33532, 38.80198], [-121.33521, 38.80219], [-121.33504, 38.80276], [-121.33491, 38.80291], [-121.33476, 38.80304], [-121.3346, 38.80308], [-121.3345, 38.80316], [-121.33439, 38.80316], [-121.33402, 38.80308], [-121.33371, 38.8032], [-121.33356, 38.80327], [-121.3333, 38.8033], [-121.3332, 38.80335], [-121.3332, 38.80336], [-121.33327, 38.8034], [-121.33342, 38.80353], [-121.33327, 38.80373], [-121.33341, 38.80391], [-121.33373, 38.80471], [-121.33429, 38.80553], [-121.33418, 38.80554], [-121.33364, 38.80475], [-121.33336, 38.8042], [-121.33317, 38.80392], [-121.33319, 38.80381], [-121.33317, 38.80369], [-121.333, 38.80339], [-121.333, 38.80329], [-121.33291, 38.80317], [-121.33277, 38.80312], [-121.33252, 38.8032], [-121.3322, 38.8032], [-121.33214, 38.80307], [-121.33211, 38.80285], [-121.33204, 38.80268], [-121.33186, 38.80262], [-121.33179, 38.80252], [-121.33154, 38.80243], [-121.33135, 38.80239], [-121.33112, 38.80246], [-121.3307, 38.80269], [-121.3306, 38.80269], [-121.33038, 38.80264], [-121.33002, 38.80262], [-121.32972, 38.80215], [-121.33008, 38.80202], [-121.33031, 38.80215], [-121.33057, 38.80222], [-121.33078, 38.80224], [-121.33111, 38.8022], [-121.33128, 38.8022], [-121.33193, 38.8023], [-121.33194, 38.80232], [-121.33213, 38.80231], [-121.33239, 38.80227], [-121.33265, 38.80219], [-121.33299, 38.80201], [-121.33313, 38.80191], [-121.33326, 38.80176], [-121.33334, 38.80158], [-121.33336, 38.80138], [-121.33332, 38.80121], [-121.33325, 38.80108], [-121.33315, 38.80096], [-121.33271, 38.80058], [-121.33251, 38.80045], [-121.33297, 38.8002], [-121.3329, 38.79994], [-121.33309, 38.79935], [-121.33297, 38.79919], [-121.33319, 38.79911], [-121.33374, 38.79925], [-121.3338, 38.79908], [-121.33396, 38.79895], [-121.33426, 38.79901], [-121.33435, 38.7988], [-121.33426, 38.79856], [-121.33422, 38.79829], [-121.33428, 38.798], [-121.33453, 38.79801], [-121.33476, 38.79804], [-121.33495, 38.79809], [-121.33516, 38.79817], [-121.33688, 38.79907], [-121.3371, 38.79922], [-121.33729, 38.7994], [-121.33738, 38.79952], [-121.33747, 38.79968], [-121.33754, 38.79988], [-121.33757, 38.80005], [-121.33759, 38.80119], [-121.33755, 38.80141], [-121.33746, 38.80162]]]} | Open Access 1 | William "Bill" Hughes Park | 27535 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 44.266 | William "Bill" Hughes Park | ||
6110 | 6110 | 6109 | {"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 | Leonard Davis Park | 21173 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 4.122 | Leonard Davis Park | ||
8828 | 8828 | 8827 | {"type": "Polygon", "coordinates": [[[-121.33558, 38.77485], [-121.33557, 38.77538], [-121.33532, 38.77535], [-121.33505, 38.77534], [-121.33478, 38.77535], [-121.33455, 38.7754], [-121.3343, 38.77547], [-121.33406, 38.77557], [-121.33384, 38.77569], [-121.33364, 38.77585], [-121.33255, 38.77481], [-121.33216, 38.77437], [-121.33272, 38.77405], [-121.33283, 38.77395], [-121.33295, 38.77379], [-121.33326, 38.77379], [-121.33351, 38.77377], [-121.33386, 38.7745], [-121.33399, 38.77449], [-121.334, 38.77464], [-121.33474, 38.77469], [-121.33477, 38.77456], [-121.33508, 38.77459], [-121.33509, 38.77466], [-121.33525, 38.77467], [-121.3354, 38.77477], [-121.33547, 38.77477], [-121.33558, 38.77485]]]} | Open Access 1 | Robert L. Doyle Park | 24490 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 7.992 | Robert L. Doyle Park | ||
1410 | 1410 | 1409 | {"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.79059], [-121.33406, 38.79053], [-121.33406, 38.79046], [-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 | Adam V. Baquera Park | 15257 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 2.667 | Adam V. Baquera Park | ||
8991 | 8991 | 8990 | {"type": "Polygon", "coordinates": [[[-121.33095, 38.77505], [-121.3309, 38.77508], [-121.33064, 38.77475], [-121.33058, 38.77475], [-121.33055, 38.77471], [-121.33058, 38.77467], [-121.33037, 38.77434], [-121.33022, 38.77407], [-121.33005, 38.77369], [-121.32995, 38.77341], [-121.32979, 38.77341], [-121.32965, 38.77334], [-121.32966, 38.77266], [-121.32976, 38.77265], [-121.32982, 38.77269], [-121.32991, 38.77309], [-121.32999, 38.77336], [-121.3301, 38.77364], [-121.33022, 38.77392], [-121.33036, 38.7742], [-121.33057, 38.77455], [-121.33095, 38.77505]]]} | Open Access 1 | Roseville holding 40 | 24661 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 0.732 | Roseville holding 40 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);