superunits_with_maps

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

124 rows where MNG_AGENCY = 533

View and edit SQL

MNG_AG_TYP

MNG_AGENCY

  • Roseville, City of · 124
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
427 426 {"type": "Polygon", "coordinates": [[[-121.23271, 38.75219], [-121.23154, 38.75352], [-121.23155, 38.75354], [-121.23185, 38.75369], [-121.23132, 38.75434], [-121.23097, 38.75418], [-121.23058, 38.75403], [-121.23016, 38.75392], [-121.22977, 38.75386], [-121.22993, 38.75339], [-121.23034, 38.75345], [-121.2304, 38.75322], [-121.23049, 38.75273], [-121.23059, 38.7527], [-121.23064, 38.75263], [-121.23064, 38.75259], [-121.23062, 38.75255], [-121.23053, 38.7525], [-121.2306, 38.75219], [-121.23271, 38.75219]]]} Open Access 1 Waltrip Park https://www.roseville.ca.us/cms/One.aspx?portalId=7964922&pageId=10993299 33490 1285 Roseville, City of 533 City 2 City Agency 2 http://www.roseville.ca.us/parks/default.asp City 2 7.781 Waltrip Park  
1128 1127 {"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 Aldo Pineschi Sr. Park   15350 1285 Roseville, City of 533 City 2 City Agency 2 http://www.roseville.ca.us/parks/default.asp City 2 5.162 Aldo Pineschi Sr. Park  
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  
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  
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  
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  
2084 2083 {"type": "MultiPolygon", "coordinates": [[[[-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.78305], [-121.32922, 38.78304], [-121.32934, 38.78295], [-121.32953, 38.78294], [-121.32953, 38.78316], [-121.32956, 38.78331], [-121.32964, 38.78348], [-121.32973, 38.78361], [-121.32987, 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.7841], [-121.33153, 38.78405], [-121.33153, 38.78403], [-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.33561, 38.78584], [-121.33454, 38.78692], [-121.33454, 38.78693], [-121.33485, 38.78711], [-121.33429, 38.78774], [-121.33475, 38.78801], [-121.33413, 38.78864], [-121.33424, 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.33461, 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.33253, 38.78717], [-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.33203, 38.78605], [-121.33198, 38.78606], [-121.33186, 38.78618], [-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 Blue Oaks Park   16184 1285 Roseville, City of 533 City 2 City Agency 2 http://www.roseville.ca.us/parks/default.asp City 2 42.584 Blue Oaks Park  
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  
2351 2350 {"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.77821], [-121.30115, 38.77823], [-121.30116, 38.77832]]]} Open Access 1 Buljan Park   16500 1285 Roseville, City of 533 City 2 City Agency 2 http://www.roseville.ca.us/parks/default.asp City 2 14.846 Buljan Park  
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  
2545 2544 {"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 Cambria Park   16749 1285 Roseville, City of 533 City 2 City Agency 2 http://www.roseville.ca.us/parks/default.asp City 2 3.001 Cambria Park  
2774 2773 {"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.27697, 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.78725], [-121.2783, 38.78738], [-121.27856, 38.78767], [-121.27887, 38.78798], [-121.2793, 38.78834], [-121.27975, 38.78866]]]} Open Access 1 Central Park   17058 1285 Roseville, City of 533 City 2 City Agency 2 http://www.roseville.ca.us/parks/default.asp City 2 22.901 Central Park  
3322 3321 {"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.7258], [-121.29673, 38.72567], [-121.29803, 38.72567], [-121.29803, 38.7269]]]} Open Access 1 Cresthaven Park   17806 1285 Roseville, City of 533 City 2 City Agency 2 http://www.roseville.ca.us/parks/default.asp City 2 4.083 Cresthaven Park  
3325 3324 {"type": "Polygon", "coordinates": [[[-121.25289, 38.7212], [-121.25269, 38.72121], [-121.25269, 38.72142], [-121.25255, 38.72144], [-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 Crestmont Park   17809 1285 Roseville, City of 533 City 2 City Agency 2 http://www.roseville.ca.us/parks/default.asp City 2 6.39 Crestmont Park  
3457 3456 {"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.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 David Uribe Park   17945 1285 Roseville, City of 533 City 2 City Agency 2 http://www.roseville.ca.us/parks/default.asp City 2 4.0 David Uribe Park  
3542 3541 {"type": "Polygon", "coordinates": [[[-121.27351, 38.793], [-121.2735, 38.793], [-121.27194, 38.79238], [-121.27218, 38.79201], [-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.27351, 38.793]]]} Open Access 1 Del Stephenson Park   18056 1285 Roseville, City of 533 City 2 City Agency 2 http://www.roseville.ca.us/parks/default.asp City 2 3.525 Del Stephenson Park  
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  
3607 3606 {"type": "Polygon", "coordinates": [[[-121.28134, 38.7654], [-121.28136, 38.76557], [-121.28134, 38.76592], [-121.28135, 38.76634], [-121.28132, 38.76649], [-121.28128, 38.76661], [-121.28125, 38.76663], [-121.2812, 38.76664], [-121.28086, 38.76661], [-121.27972, 38.76663], [-121.27971, 38.76655], [-121.27919, 38.76655], [-121.27893, 38.76649], [-121.2789, 38.76545], [-121.27895, 38.76545], [-121.27897, 38.76551], [-121.27901, 38.76555], [-121.27913, 38.76557], [-121.27922, 38.76554], [-121.27926, 38.7655], [-121.27927, 38.76545], [-121.27968, 38.76545], [-121.27969, 38.76543], [-121.28089, 38.76547], [-121.28134, 38.7654]]]} Open Access 1 Diamond Oaks Park   18146 1285 Roseville, City of 533 City 2 City Agency 2 http://www.roseville.ca.us/parks/default.asp City 2 6.558 Diamond Oaks Park  
3699 3698 {"type": "Polygon", "coordinates": [[[-121.33004, 38.80349], [-121.33001, 38.80378], [-121.32951, 38.80379], [-121.3295, 38.80433], [-121.32959, 38.80456], [-121.32963, 38.80473], [-121.3293, 38.80473], [-121.32924, 38.80478], [-121.32924, 38.80497], [-121.32934, 38.8054], [-121.32933, 38.80565], [-121.329, 38.80558], [-121.32867, 38.80546], [-121.32716, 38.80474], [-121.32736, 38.80433], [-121.32762, 38.80403], [-121.32763, 38.80356], [-121.32678, 38.803], [-121.3267, 38.80301], [-121.32645, 38.80324], [-121.32646, 38.80331], [-121.32634, 38.80335], [-121.32604, 38.80315], [-121.32597, 38.80315], [-121.32549, 38.80366], [-121.32526, 38.80412], [-121.32454, 38.80436], [-121.32429, 38.80448], [-121.32406, 38.80461], [-121.32365, 38.80493], [-121.32348, 38.80511], [-121.32333, 38.80531], [-121.32283, 38.80627], [-121.3226, 38.80646], [-121.32225, 38.80658], [-121.32206, 38.8068], [-121.32204, 38.80704], [-121.32242, 38.80775], [-121.32257, 38.8078], [-121.32256, 38.80784], [-121.32257, 38.80789], [-121.32265, 38.80794], [-121.32258, 38.80806], [-121.32274, 38.80834], [-121.323, 38.80861], [-121.32324, 38.80865], [-121.32327, 38.80863], [-121.32337, 38.80866], [-121.32344, 38.80865], [-121.32351, 38.8086], [-121.32354, 38.80852], [-121.32357, 38.80848], [-121.32375, 38.80834], [-121.32381, 38.80832], [-121.32415, 38.80851], [-121.32439, 38.80861], [-121.32468, 38.80869], [-121.32494, 38.80874], [-121.32532, 38.80876], [-121.32666, 38.8087], [-121.32671, 38.80873], [-121.32672, 38.80881], [-121.32671, 38.80922], [-121.32668, 38.80928], [-121.32668, 38.80934], [-121.32674, 38.80942], [-121.32685, 38.80946], [-121.32675, 38.80972], [-121.3268, 38.80977], [-121.32693, 38.80985], [-121.3271, 38.80988], [-121.32987, 38.80987], [-121.32987, 38.81003], [-121.32676, 38.81004], [-121.32606, 38.80908], [-121.32259, 38.80908], [-121.32238, 38.80893], [-121.32239, 38.80784], [-121.32198, 38.80731], [-121.32199, 38.80648], [-121.32291, 38.80567], [-121.32328, 38.80497], [-121.32275, 38.80452], [-121.32311, 38.80415], [-121.32451, 38.8043], [-121.32501, 38.80412], [-121.32596, 38.80303], [-121.32666, 38.80275], [-121.32756, 38.80283], [-121.32832, 38.80358], [-121.3298, 38.80359], [-121.32983, 38.80315], [-121.33004, 38.80349]]]} Open Access 1 Dr Paul J Dugan Park   18263 1285 Roseville, City of 533 City 2 City Agency 2 http://www.roseville.ca.us/parks/default.asp City 2 22.172 Dr Paul J Dugan Park  
3816 3815 {"type": "Polygon", "coordinates": [[[-121.27901, 38.73239], [-121.2788, 38.73232], [-121.27874, 38.73244], [-121.27892, 38.73251], [-121.27869, 38.73277], [-121.27831, 38.73283], [-121.2775, 38.73351], [-121.27583, 38.73453], [-121.27563, 38.73434], [-121.27536, 38.73447], [-121.27526, 38.73461], [-121.27509, 38.73456], [-121.27482, 38.73439], [-121.27458, 38.73409], [-121.2743, 38.73402], [-121.27367, 38.73381], [-121.27264, 38.73401], [-121.27218, 38.73396], [-121.27218, 38.73383], [-121.27261, 38.73373], [-121.27368, 38.73368], [-121.27409, 38.73372], [-121.27464, 38.73387], [-121.27487, 38.73406], [-121.27508, 38.73426], [-121.2757, 38.73391], [-121.27698, 38.73311], [-121.27697, 38.7331], [-121.27618, 38.7331], [-121.27618, 38.73276], [-121.27621, 38.73272], [-121.27623, 38.73267], [-121.27618, 38.73256], [-121.27616, 38.73239], [-121.27618, 38.73213], [-121.2762, 38.73209], [-121.27624, 38.73208], [-121.27728, 38.73207], [-121.27747, 38.73203], [-121.27776, 38.73191], [-121.2778, 38.73193], [-121.278, 38.7321], [-121.27828, 38.73226], [-121.27835, 38.73232], [-121.27843, 38.73235], [-121.27851, 38.73235], [-121.27858, 38.73234], [-121.27865, 38.73229], [-121.27868, 38.73225], [-121.2787, 38.73217], [-121.27882, 38.73201], [-121.27888, 38.73194], [-121.27899, 38.73186], [-121.27901, 38.73239]], [[-121.27652, 38.73375], [-121.27652, 38.73373], [-121.27648, 38.73371], [-121.27632, 38.73384], [-121.27636, 38.73386], [-121.27652, 38.73375]]]} Open Access 1 Eastwood Park   18403 1285 Roseville, City of 533 City 2 City Agency 2 http://www.roseville.ca.us/parks/default.asp City 2 11.174 Eastwood Park  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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]);
Powered by Datasette · Query took 48.959ms · Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette