units_with_maps

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

130 rows where MNG_AGENCY = 533

View and edit SQL

Suggested facets: GAP_STS

MNG_AG_TYP

MNG_AGENCY

  • 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
2640 2639 {"type": "Polygon", "coordinates": [[[-121.33746, 38.80162], [-121.33738, 38.8016], [-121.33727, 38.80178], [-121.33701, 38.80169], [-121.33682, 38.80167], [-121.33667, 38.8017], [-121.33646, 38.80179], [-121.33611, 38.80189], [-121.33569, 38.80158], [-121.33557, 38.80162], [-121.33532, 38.80198], [-121.33521, 38.8022], [-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.33403, 38.80308], [-121.33371, 38.8032], [-121.33356, 38.80327], [-121.3333, 38.8033], [-121.33319, 38.80335], [-121.33319, 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.3318, 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.80175], [-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.33298, 38.80021], [-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.79902], [-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 20852 William "Bill" Hughes Park 27535 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 44.252 William "Bill" Hughes Park 0 Local Park 2 4
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  
2645 2644 {"type": "Polygon", "coordinates": [[[-121.27306, 38.75203], [-121.27181, 38.75204], [-121.27181, 38.75184], [-121.27082, 38.75101], [-121.27076, 38.75092], [-121.27152, 38.75045], [-121.2716, 38.75057], [-121.27169, 38.75052], [-121.27177, 38.75059], [-121.27186, 38.75064], [-121.27206, 38.75069], [-121.27228, 38.75067], [-121.27264, 38.75054], [-121.27306, 38.75203]]]} Open Access 1 20901 Lincoln Estates Park 21248 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.411 Lincoln Estates Park 0 Local Park 2 4
3043 3042 {"type": "Polygon", "coordinates": [[[-121.34941, 38.79537], [-121.34941, 38.79566], [-121.34879, 38.79586], [-121.34862, 38.796], [-121.34851, 38.79618], [-121.34824, 38.79633], [-121.34805, 38.79653], [-121.348, 38.79653], [-121.34794, 38.79683], [-121.34798, 38.79701], [-121.3479, 38.79713], [-121.34749, 38.79719], [-121.34744, 38.79725], [-121.34706, 38.79734], [-121.34683, 38.79753], [-121.34656, 38.79754], [-121.34599, 38.79788], [-121.34581, 38.79771], [-121.34565, 38.7976], [-121.34545, 38.79749], [-121.34529, 38.79741], [-121.34533, 38.79735], [-121.34552, 38.7966], [-121.34538, 38.79642], [-121.34553, 38.79633], [-121.34575, 38.79591], [-121.34598, 38.79589], [-121.34636, 38.79581], [-121.34659, 38.79572], [-121.34689, 38.7957], [-121.34717, 38.79574], [-121.34798, 38.79538], [-121.34941, 38.79537]]]} Open Access 1 20854 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 12.582 Veterans Memorial Park 0 Local Park 2 4
3044 3043 {"type": "Polygon", "coordinates": [[[-121.28919, 38.77703], [-121.28863, 38.77744], [-121.28813, 38.77795], [-121.28803, 38.778], [-121.28791, 38.778], [-121.28718, 38.77778], [-121.28651, 38.77763], [-121.28655, 38.77743], [-121.28663, 38.7774], [-121.28669, 38.77746], [-121.28679, 38.77747], [-121.28692, 38.77744], [-121.28769, 38.7774], [-121.2879, 38.77737], [-121.28811, 38.77731], [-121.28847, 38.77715], [-121.28875, 38.77697], [-121.28886, 38.77692], [-121.28892, 38.77686], [-121.289, 38.77688], [-121.28919, 38.77703]]]} Open Access 1 20876 Twinwood Park 26624 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.59 Twinwood Park 0 Local Park 2 4
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
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
3047 3046 {"type": "Polygon", "coordinates": [[[-121.28534, 38.77566], [-121.2842, 38.77584], [-121.28385, 38.7743], [-121.2848, 38.77407], [-121.28497, 38.77405], [-121.28534, 38.77566]]]} Open Access 1 20880 Sylvia Besana Park 26154 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.479 Sylvia Besana Park 0 Local Park 2 4
3050 3049 {"type": "MultiPolygon", "coordinates": [[[[-121.24452, 38.72086], [-121.24452, 38.72174], [-121.24392, 38.72198], [-121.24348, 38.72211], [-121.243, 38.72216], [-121.24087, 38.72215], [-121.24088, 38.72187], [-121.24142, 38.72131], [-121.24229, 38.72048], [-121.2424, 38.72035], [-121.24247, 38.72024], [-121.24255, 38.72001], [-121.24256, 38.71981], [-121.24243, 38.71901], [-121.24317, 38.71934], [-121.24452, 38.72086]]], [[[-121.24324, 38.72673], [-121.24287, 38.72694], [-121.24263, 38.72659], [-121.24242, 38.72641], [-121.24196, 38.72561], [-121.24212, 38.7254], [-121.24228, 38.7254], [-121.24235, 38.72544], [-121.24262, 38.72546], [-121.24261, 38.72582], [-121.24268, 38.72605], [-121.24282, 38.72626], [-121.24324, 38.72673]]], [[[-121.24705, 38.72776], [-121.24669, 38.72806], [-121.24614, 38.7276], [-121.24538, 38.7271], [-121.24461, 38.72713], [-121.24464, 38.72905], [-121.24408, 38.72926], [-121.24395, 38.72917], [-121.24386, 38.72913], [-121.24372, 38.7291], [-121.24358, 38.7291], [-121.24358, 38.72874], [-121.24324, 38.72824], [-121.24342, 38.72813], [-121.24353, 38.72797], [-121.24366, 38.72722], [-121.24366, 38.72705], [-121.24361, 38.7269], [-121.24353, 38.7268], [-121.2429, 38.72609], [-121.24281, 38.72588], [-121.2428, 38.7257], [-121.24283, 38.72526], [-121.24329, 38.72527], [-121.24334, 38.72506], [-121.2433, 38.72484], [-121.24337, 38.72448], [-121.24365, 38.72414], [-121.24385, 38.72389], [-121.24388, 38.72355], [-121.24381, 38.72292], [-121.24399, 38.72224], [-121.24462, 38.72224], [-121.24462, 38.72236], [-121.24444, 38.72249], [-121.24437, 38.72277], [-121.24432, 38.72287], [-121.2443, 38.72308], [-121.24453, 38.72352], [-121.24447, 38.72389], [-121.24432, 38.7242], [-121.24392, 38.72447], [-121.2439, 38.72451], [-121.24388, 38.72482], [-121.24388, 38.72589], [-121.24392, 38.72603], [-121.24398, 38.72612], [-121.2441, 38.72622], [-121.24423, 38.72622], [-121.24505, 38.72665], [-121.2456, 38.72668], [-121.2461, 38.72696], [-121.24705, 38.72776]]], [[[-121.24936, 38.72958], [-121.24879, 38.72974], [-121.24869, 38.72944], [-121.2471, 38.72837], [-121.24684, 38.72817], [-121.24721, 38.72788], [-121.24746, 38.72807], [-121.24913, 38.72919], [-121.24936, 38.72958]]]]} Open Access 1 20932 Flood Control 18952 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 37.251 Flood Control 0 Local Other or Unknown 14 4
3303 3302 {"type": "MultiPolygon", "coordinates": [[[[-121.29299, 38.78675], [-121.29281, 38.78695], [-121.29151, 38.78601], [-121.29153, 38.7857], [-121.29165, 38.78561], [-121.29166, 38.78556], [-121.29165, 38.78546], [-121.29178, 38.78527], [-121.29243, 38.78543], [-121.29257, 38.78589], [-121.29299, 38.78675]]], [[[-121.32257, 38.76796], [-121.32255, 38.76799], [-121.32252, 38.76801], [-121.32191, 38.76817], [-121.32101, 38.76854], [-121.32076, 38.76804], [-121.32034, 38.76803], [-121.32019, 38.76737], [-121.32083, 38.76704], [-121.32074, 38.76639], [-121.31577, 38.76639], [-121.31578, 38.76596], [-121.31577, 38.76578], [-121.31572, 38.76558], [-121.31564, 38.76537], [-121.31596, 38.76536], [-121.31607, 38.76549], [-121.31619, 38.76559], [-121.31638, 38.76567], [-121.31656, 38.76571], [-121.3173, 38.76572], [-121.31743, 38.76571], [-121.31756, 38.76568], [-121.31769, 38.76562], [-121.31793, 38.76545], [-121.31798, 38.76544], [-121.31832, 38.7656], [-121.3186, 38.76569], [-121.31891, 38.76575], [-121.31922, 38.76576], [-121.31959, 38.76571], [-121.3198, 38.76566], [-121.31999, 38.76559], [-121.32028, 38.76544], [-121.32042, 38.76534], [-121.32056, 38.76522], [-121.32175, 38.76518], [-121.32181, 38.76503], [-121.32197, 38.76507], [-121.322, 38.76509], [-121.32201, 38.76513], [-121.32185, 38.76559], [-121.32182, 38.76576], [-121.32181, 38.76597], [-121.32183, 38.76617], [-121.3219, 38.76638], [-121.32224, 38.76714], [-121.32257, 38.76796]]]]} No Public Access 3 29576 Proposed Park 24017 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 23.324 Proposed Park 0 Local Park 2 4
3539 3538 {"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 36403 Roseville holding 13 24631 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.081 Roseville holding 13 0 Local Other or Unknown 14 4
3547 3546 {"type": "Polygon", "coordinates": [[[-121.32679, 38.76689], [-121.3266, 38.76689], [-121.3266, 38.76659], [-121.32679, 38.76659], [-121.32679, 38.76689]]]} Open Access 1 36445 Roseville holding 1 24627 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.139 Roseville holding 1 0 Local Other or Unknown 14 4
3598 3597 {"type": "Polygon", "coordinates": [[[-121.29155, 38.75104], [-121.29139, 38.75143], [-121.29139, 38.75183], [-121.29041, 38.75183], [-121.29043, 38.75127], [-121.29053, 38.75131], [-121.29097, 38.75085], [-121.29122, 38.75095], [-121.29155, 38.75104]]]} Open Access 1 29457 Weber Park 27325 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.903 Weber Park 0 Local Park 2 4
3625 3624 {"type": "Polygon", "coordinates": [[[-121.23567, 38.76043], [-121.23447, 38.76115], [-121.23515, 38.76186], [-121.23484, 38.762], [-121.23451, 38.76206], [-121.23424, 38.76215], [-121.23403, 38.76226], [-121.23382, 38.76241], [-121.23376, 38.76241], [-121.23359, 38.76234], [-121.23358, 38.7624], [-121.23339, 38.76233], [-121.23322, 38.76224], [-121.23306, 38.7621], [-121.23248, 38.76151], [-121.23439, 38.76039], [-121.23427, 38.75995], [-121.23329, 38.75891], [-121.23395, 38.75854], [-121.23567, 38.76043]]]} Open Access 1 29473 George Goto Park 19266 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.672 George Goto Park 0 Local Park 2 4
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
3634 3633 {"type": "Polygon", "coordinates": [[[-121.22558, 38.7212], [-121.22557, 38.7219], [-121.22553, 38.72195], [-121.22548, 38.72198], [-121.22526, 38.72199], [-121.22513, 38.72187], [-121.22478, 38.72139], [-121.22457, 38.72123], [-121.22431, 38.72121], [-121.22422, 38.72114], [-121.22423, 38.72105], [-121.22416, 38.72097], [-121.22398, 38.72088], [-121.2239, 38.72082], [-121.22374, 38.72084], [-121.22354, 38.72096], [-121.22332, 38.72098], [-121.22298, 38.72116], [-121.22292, 38.72124], [-121.22288, 38.72142], [-121.22282, 38.72152], [-121.22271, 38.72153], [-121.22255, 38.72147], [-121.22237, 38.72146], [-121.22219, 38.72152], [-121.22204, 38.72162], [-121.22177, 38.7216], [-121.2216, 38.72165], [-121.22148, 38.72164], [-121.22137, 38.7217], [-121.22125, 38.72169], [-121.2211, 38.72161], [-121.22101, 38.72163], [-121.22093, 38.72169], [-121.22074, 38.72166], [-121.22053, 38.72148], [-121.22003, 38.72149], [-121.21996, 38.72158], [-121.21974, 38.72164], [-121.21954, 38.72159], [-121.21951, 38.72151], [-121.21914, 38.72146], [-121.21894, 38.72145], [-121.21868, 38.72137], [-121.21833, 38.72157], [-121.21802, 38.72159], [-121.21762, 38.72151], [-121.21739, 38.7215], [-121.2174, 38.7216], [-121.21726, 38.72169], [-121.21709, 38.72167], [-121.21694, 38.72156], [-121.21655, 38.72139], [-121.21655, 38.72104], [-121.21688, 38.72108], [-121.21712, 38.72103], [-121.21734, 38.72088], [-121.21758, 38.7208], [-121.2179, 38.72074], [-121.21812, 38.72076], [-121.21845, 38.72069], [-121.21894, 38.72064], [-121.21924, 38.72057], [-121.21953, 38.72046], [-121.21968, 38.72042], [-121.21984, 38.72049], [-121.21999, 38.72059], [-121.22014, 38.72063], [-121.22027, 38.72061], [-121.22046, 38.72065], [-121.22072, 38.72076], [-121.22085, 38.72077], [-121.22142, 38.72073], [-121.22148, 38.72067], [-121.22156, 38.72054], [-121.22169, 38.7205], [-121.22184, 38.72055], [-121.22202, 38.72072], [-121.22213, 38.72076], [-121.2223, 38.72068], [-121.2225, 38.72054], [-121.22275, 38.72043], [-121.22297, 38.72037], [-121.22298, 38.72028], [-121.22489, 38.72032], [-121.22489, 38.72043], [-121.22501, 38.72055], [-121.22501, 38.72071], [-121.22511, 38.72086], [-121.22548, 38.72116], [-121.22558, 38.7212]]]} Open Access 1 29448 Wetlands 27445 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.178 Wetlands 0 Local Conservation Area 4 2
3635 3634 {"type": "Polygon", "coordinates": [[[-121.34706, 38.80492], [-121.34706, 38.80537], [-121.34699, 38.80571], [-121.34697, 38.80589], [-121.34696, 38.80708], [-121.34535, 38.8071], [-121.34535, 38.80676], [-121.34526, 38.80672], [-121.34528, 38.80667], [-121.34526, 38.8066], [-121.34535, 38.80656], [-121.34536, 38.80589], [-121.34527, 38.80585], [-121.34529, 38.8058], [-121.34527, 38.80573], [-121.34536, 38.80569], [-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 29449 Mel Hamel Park 22106 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.032 Mel Hamel Park 0 Local Park 2 4
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
3637 3636 {"type": "Polygon", "coordinates": [[[-121.29798, 38.79045], [-121.29787, 38.79056], [-121.29647, 38.78955], [-121.29697, 38.78912], [-121.2972, 38.78923], [-121.29802, 38.78946], [-121.29805, 38.78949], [-121.29803, 38.78966], [-121.29802, 38.79021], [-121.298, 38.79026], [-121.29795, 38.79031], [-121.29793, 38.79036], [-121.29795, 38.79041], [-121.29798, 38.79045]]]} Open Access 1 29462 Summerhill Park 25959 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.889 Summerhill Park 0 Local Park 2 4
3638 3637 {"type": "Polygon", "coordinates": [[[-121.26288, 38.75472], [-121.26165, 38.75576], [-121.26024, 38.75636], [-121.2599, 38.75658], [-121.25957, 38.75693], [-121.25942, 38.7572], [-121.25928, 38.75719], [-121.25913, 38.75715], [-121.25811, 38.75675], [-121.2583, 38.75636], [-121.25846, 38.75613], [-121.25865, 38.75607], [-121.25897, 38.75611], [-121.25927, 38.75602], [-121.25879, 38.75582], [-121.25853, 38.75577], [-121.25864, 38.75568], [-121.25905, 38.75576], [-121.2594, 38.75588], [-121.25963, 38.7556], [-121.2597, 38.75563], [-121.25996, 38.75532], [-121.26004, 38.75535], [-121.2604, 38.75492], [-121.26036, 38.75477], [-121.26023, 38.7547], [-121.26041, 38.75449], [-121.26063, 38.75445], [-121.26067, 38.75462], [-121.26083, 38.75481], [-121.2612, 38.75475], [-121.26116, 38.75458], [-121.26112, 38.75458], [-121.26108, 38.75438], [-121.26112, 38.75435], [-121.26136, 38.75427], [-121.26158, 38.75423], [-121.26148, 38.75381], [-121.26193, 38.75408], [-121.2621, 38.75415], [-121.26238, 38.75435], [-121.2627, 38.75464], [-121.26288, 38.75472]], [[-121.26236, 38.75516], [-121.26236, 38.75514], [-121.26206, 38.75493], [-121.26189, 38.75488], [-121.26133, 38.75524], [-121.26147, 38.75549], [-121.26154, 38.75545], [-121.26208, 38.75534], [-121.26236, 38.75516]]]} Open Access 1 29478 Miner's Ravine Trail 22260 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 12.44 Miner's Ravine Trail 0 Local Recreation Area 3 4

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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