superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
124 rows where MNG_AGENCY = 533 sorted by ACRES
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
8978 | 8978 | 8977 | {"type": "Polygon", "coordinates": [[[-121.23075, 38.73105], [-121.23072, 38.73117], [-121.23009, 38.73106], [-121.2296, 38.73098], [-121.2291, 38.73094], [-121.22858, 38.73092], [-121.22853, 38.73091], [-121.22849, 38.73087], [-121.22848, 38.73076], [-121.22853, 38.73076], [-121.22857, 38.73079], [-121.22917, 38.73081], [-121.22976, 38.73086], [-121.23029, 38.73095], [-121.23075, 38.73105]]]} | Open Access 1 | Roseville holding 26 | 24645 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 0.734 | Roseville holding 26 | ||
7561 | 7561 | 7560 | {"type": "Polygon", "coordinates": [[[-121.29641, 38.73769], [-121.29608, 38.7377], [-121.29606, 38.73671], [-121.29639, 38.7367], [-121.29641, 38.73769]]]} | Open Access 1 | Roseville holding 3 | 24649 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 0.764 | Roseville holding 3 | ||
8960 | 8960 | 8959 | {"type": "Polygon", "coordinates": [[[-121.2971, 38.73345], [-121.2966, 38.73345], [-121.29659, 38.73255], [-121.297, 38.73265], [-121.29693, 38.73288], [-121.29693, 38.73301], [-121.29691, 38.73305], [-121.29698, 38.73309], [-121.29695, 38.73312], [-121.29697, 38.73321], [-121.29706, 38.73322], [-121.29707, 38.73327], [-121.29709, 38.73331], [-121.2971, 38.73345]]]} | Open Access 1 | Roseville holding 15 | 24633 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 0.802 | Roseville holding 15 | ||
9423 | 9423 | 9422 | {"type": "Polygon", "coordinates": [[[-121.26237, 38.75515], [-121.26208, 38.75534], [-121.26154, 38.75545], [-121.26146, 38.75549], [-121.26132, 38.75524], [-121.26189, 38.75488], [-121.26206, 38.75493], [-121.26237, 38.75515]]]} | Open Access 1 | Sculpture Park | 25220 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 0.814 | Sculpture Park | ||
8981 | 8981 | 8980 | {"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.27822, 38.76673], [-121.27822, 38.76677], [-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]]]]} | Open Access 1 | Roseville holding 29 | 24648 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 0.863 | Roseville holding 29 | ||
5717 | 5717 | 5716 | {"type": "Polygon", "coordinates": [[[-121.27803, 38.72429], [-121.27768, 38.72463], [-121.27752, 38.7245], [-121.27731, 38.72422], [-121.27719, 38.72411], [-121.27719, 38.72409], [-121.27725, 38.72397], [-121.27728, 38.72386], [-121.2778, 38.72386], [-121.27781, 38.72414], [-121.27803, 38.72429]]]} | Open Access 1 | Kenwood Oaks Park | 20623 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 0.887 | Kenwood Oaks Park | ||
8990 | 8990 | 8989 | {"type": "Polygon", "coordinates": [[[-121.29545, 38.73776], [-121.2948, 38.73776], [-121.29479, 38.73737], [-121.29512, 38.73736], [-121.29511, 38.73671], [-121.29543, 38.73671], [-121.29545, 38.73776]]]} | Open Access 1 | Roseville holding 4 | 24660 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1.117 | Roseville holding 4 | ||
8996 | 8996 | 8995 | {"type": "Polygon", "coordinates": [[[-121.31744, 38.76323], [-121.31744, 38.76338], [-121.31446, 38.76336], [-121.31446, 38.76316], [-121.31737, 38.76318], [-121.31742, 38.7632], [-121.31744, 38.76323]]]} | Open Access 1 | Roseville holding 6 | 24666 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1.416 | Roseville holding 6 | ||
8963 | 8963 | 8962 | {"type": "Polygon", "coordinates": [[[-121.24543, 38.72224], [-121.24452, 38.72224], [-121.24452, 38.72086], [-121.2452, 38.72192], [-121.24543, 38.72224]]]} | Open Access 1 | Roseville holding 18 | 24636 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1.477 | Roseville holding 18 | ||
8977 | 8977 | 8976 | {"type": "Polygon", "coordinates": [[[-121.23523, 38.75113], [-121.23505, 38.75109], [-121.23504, 38.75101], [-121.23499, 38.75097], [-121.23494, 38.75095], [-121.23488, 38.75095], [-121.23476, 38.751], [-121.2347, 38.75101], [-121.23432, 38.75095], [-121.23409, 38.75093], [-121.23388, 38.75094], [-121.23365, 38.75098], [-121.23352, 38.75077], [-121.23394, 38.75056], [-121.23461, 38.75054], [-121.23479, 38.7506], [-121.23497, 38.75064], [-121.2352, 38.75064], [-121.23523, 38.75113]]]} | Open Access 1 | Roseville holding 25 | 24644 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1.497 | Roseville holding 25 | ||
8964 | 8964 | 8963 | {"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 | Roseville holding 31 | 24651 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1.841 | Roseville holding 31 | ||
8971 | 8971 | 8970 | {"type": "Polygon", "coordinates": [[[-121.30605, 38.7367], [-121.30638, 38.73688], [-121.3065, 38.73698], [-121.30655, 38.73705], [-121.30659, 38.73715], [-121.3066, 38.73731], [-121.30657, 38.73739], [-121.30652, 38.73748], [-121.30642, 38.7376], [-121.30633, 38.73765], [-121.30622, 38.73769], [-121.30611, 38.7377], [-121.30599, 38.73768], [-121.30561, 38.73748], [-121.30557, 38.73749], [-121.30532, 38.73734], [-121.3056, 38.73713], [-121.30595, 38.73672], [-121.30599, 38.7367], [-121.30605, 38.7367]]]} | Open Access 1 | Roseville holding 2 | 24638 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1.86 | Roseville holding 2 | ||
11076 | 11076 | 11075 | {"type": "Polygon", "coordinates": [[[-121.29155, 38.75104], [-121.29139, 38.75143], [-121.29139, 38.75183], [-121.29041, 38.75183], [-121.29043, 38.75127], [-121.29054, 38.75131], [-121.29097, 38.75085], [-121.29122, 38.75095], [-121.29155, 38.75104]]]} | Open Access 1 | Weber Park | 27325 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1.904 | Weber Park | ||
5575 | 5575 | 5574 | {"type": "Polygon", "coordinates": [[[-121.2488, 38.75554], [-121.24795, 38.75599], [-121.24775, 38.75603], [-121.24729, 38.75548], [-121.24815, 38.75497], [-121.24838, 38.7552], [-121.2488, 38.75554]]]} | Open Access 1 | John Piches Park | 20462 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1.981 | John Piches 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 | ||
14389 | 14389 | 14388 | {"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 | Unknown Park - Roseville, City of | 33491 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 2.091 | |||
8956 | 8956 | 8955 | {"type": "Polygon", "coordinates": [[[-121.30877, 38.73764], [-121.30787, 38.73762], [-121.30771, 38.73765], [-121.30725, 38.73783], [-121.30706, 38.73799], [-121.30698, 38.73822], [-121.30677, 38.73808], [-121.30682, 38.73795], [-121.30676, 38.7379], [-121.30653, 38.738], [-121.30648, 38.73795], [-121.30646, 38.73789], [-121.30648, 38.73782], [-121.30669, 38.73758], [-121.30677, 38.73745], [-121.30717, 38.73751], [-121.30758, 38.73729], [-121.30827, 38.73728], [-121.30855, 38.73732], [-121.30877, 38.73732], [-121.30877, 38.73764]]]} | Open Access 1 | Roseville holding 11 | 24629 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 2.131 | Roseville holding 11 | ||
8975 | 8975 | 8974 | {"type": "Polygon", "coordinates": [[[-121.27192, 38.72489], [-121.27154, 38.72489], [-121.27165, 38.72472], [-121.27164, 38.72427], [-121.27117, 38.72371], [-121.27131, 38.72364], [-121.27155, 38.72304], [-121.2716, 38.72267], [-121.27184, 38.72267], [-121.27188, 38.72269], [-121.27191, 38.72273], [-121.27192, 38.72489]]]} | Open Access 1 | Roseville holding 23 | 24642 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 2.208 | Roseville holding 23 | ||
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 |
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]);