units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
67 rows where DES_TP = 2 and MNG_AGENCY = 533 sorted by map
This data as json, copyable, CSV (advanced)
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency 67
MNG_AGENCY 1
- Roseville, City of · 67 ✖
DES_TP 1
- Local Park · 67 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10926 | 10926 | 10925 | {"type": "MultiPolygon", "coordinates": [[[[-121.2536, 38.73338], [-121.25359, 38.73673], [-121.25357, 38.73677], [-121.25353, 38.73678], [-121.24938, 38.73679], [-121.24936, 38.73636], [-121.24627, 38.73635], [-121.24626, 38.73637], [-121.24688, 38.73754], [-121.24758, 38.73808], [-121.24734, 38.73832], [-121.24707, 38.73853], [-121.24673, 38.73873], [-121.24639, 38.73886], [-121.24604, 38.73896], [-121.24427, 38.7393], [-121.24407, 38.73931], [-121.24386, 38.7393], [-121.24371, 38.73928], [-121.24352, 38.73921], [-121.24325, 38.73907], [-121.24315, 38.73898], [-121.24306, 38.73887], [-121.24299, 38.73876], [-121.24294, 38.73864], [-121.2429, 38.73843], [-121.24289, 38.73642], [-121.24283, 38.73617], [-121.24273, 38.73593], [-121.24259, 38.73573], [-121.24244, 38.73557], [-121.2412, 38.73453], [-121.24105, 38.73433], [-121.24094, 38.73412], [-121.24088, 38.7339], [-121.24088, 38.73367], [-121.2409, 38.73349], [-121.24104, 38.73301], [-121.24106, 38.73273], [-121.24101, 38.73248], [-121.24082, 38.73196], [-121.24081, 38.73182], [-121.24085, 38.73167], [-121.24097, 38.73153], [-121.24112, 38.73144], [-121.24132, 38.73138], [-121.24364, 38.7314], [-121.24389, 38.73138], [-121.24477, 38.73126], [-121.24503, 38.73125], [-121.2452, 38.73126], [-121.24688, 38.73149], [-121.2471, 38.73155], [-121.24731, 38.73164], [-121.24746, 38.73174], [-121.2476, 38.73189], [-121.24767, 38.732], [-121.24804, 38.73269], [-121.2482, 38.7329], [-121.24842, 38.73308], [-121.24864, 38.73321], [-121.24896, 38.73332], [-121.24932, 38.73337], [-121.24933, 38.73334], [-121.25354, 38.73334], [-121.25358, 38.73335], [-121.2536, 38.73338]]], [[[-121.25391, 38.72987], [-121.25287, 38.72987], [-121.25286, 38.73006], [-121.25248, 38.73009], [-121.25234, 38.73036], [-121.25234, 38.73087], [-121.2522, 38.73103], [-121.25207, 38.73115], [-121.25145, 38.73135], [-121.25118, 38.73142], [-121.25096, 38.73157], [-121.25065, 38.73189], [-121.25044, 38.73201], [-121.25006, 38.73205], [-121.24963, 38.7322], [-121.24957, 38.7325], [-121.2496, 38.73289], [-121.2496, 38.73319], [-121.24921, 38.73319], [-121.24893, 38.73314], [-121.2491, 38.73306], [-121.24918, 38.73298], [-121.24898, 38.73243], [-121.24898, 38.73201], [-121.24914, 38.73184], [-121.24956, 38.73162], [-121.25001, 38.73172], [-121.25027, 38.73154], [-121.25032, 38.73137], [-121.2501, 38.73117], [-121.24961, 38.73116], [-121.24928, 38.73094], [-121.24831, 38.73035], [-121.24904, 38.7302], [-121.24895, 38.72992], [-121.24969, 38.72971], [-121.24977, 38.72992], [-121.25016, 38.72983], [-121.25022, 38.7299], [-121.25009, 38.73018], [-121.2501, 38.73019], [-121.25075, 38.73017], [-121.25075, 38.72948], [-121.25391, 38.72955], [-121.25391, 38.72987]]]]} | Open Access 1 | 20931 | Maidu Regional Park | 21687 | 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 | 165.433 | Maidu RP | 0 | Local Park 2 | 4 | |
12646 | 12646 | 12645 | {"type": "MultiPolygon", "coordinates": [[[[-121.28756, 38.7378], [-121.28714, 38.7382], [-121.28686, 38.73842], [-121.28655, 38.73872], [-121.28634, 38.7391], [-121.28621, 38.73939], [-121.2859, 38.73951], [-121.2857, 38.73966], [-121.28558, 38.73989], [-121.28541, 38.73989], [-121.2852, 38.74024], [-121.2851, 38.74025], [-121.2851, 38.74041], [-121.28509, 38.74041], [-121.28465, 38.74133], [-121.28396, 38.74288], [-121.28397, 38.74289], [-121.28403, 38.7429], [-121.28403, 38.74386], [-121.28266, 38.74384], [-121.2826, 38.74382], [-121.28258, 38.74378], [-121.28259, 38.74216], [-121.28252, 38.74214], [-121.28253, 38.7407], [-121.2834, 38.74074], [-121.28341, 38.74], [-121.28348, 38.7399], [-121.28406, 38.7399], [-121.28419, 38.7398], [-121.28419, 38.73974], [-121.28477, 38.73949], [-121.28494, 38.73905], [-121.28513, 38.73878], [-121.28578, 38.73851], [-121.28643, 38.73781], [-121.28756, 38.7378]]], [[[-121.28933, 38.73623], [-121.28922, 38.73665], [-121.28846, 38.73666], [-121.28846, 38.73686], [-121.28862, 38.73686], [-121.28856, 38.737], [-121.28856, 38.73713], [-121.28846, 38.73714], [-121.28829, 38.73733], [-121.28805, 38.73725], [-121.28753, 38.73769], [-121.28694, 38.7377], [-121.28738, 38.73735], [-121.28776, 38.73714], [-121.28804, 38.73687], [-121.2883, 38.73666], [-121.2884, 38.73666], [-121.28865, 38.73635], [-121.28875, 38.7362], [-121.28931, 38.73527], [-121.28927, 38.73609], [-121.28933, 38.73623]]]]} | Open Access 1 | 29481 | Saugstad Park | 25169 | 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 | 25.464 | Saugstad Park | 0 | Local Park 2 | 4 | |
3303 | 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 | |
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 | |
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 | |
10929 | 10929 | 10928 | {"type": "Polygon", "coordinates": [[[-121.22577, 38.73138], [-121.22577, 38.73238], [-121.2235, 38.73236], [-121.22286, 38.73217], [-121.2221, 38.73211], [-121.2221, 38.73192], [-121.22212, 38.73176], [-121.22224, 38.73147], [-121.22228, 38.73131], [-121.22238, 38.73114], [-121.22268, 38.73073], [-121.22275, 38.73069], [-121.22281, 38.7307], [-121.22317, 38.73083], [-121.22352, 38.73094], [-121.22415, 38.73109], [-121.22471, 38.73117], [-121.22489, 38.73121], [-121.22561, 38.73123], [-121.22572, 38.73129], [-121.22577, 38.73138]]]} | Open Access 1 | 20941 | Hillsborough Park | 19976 | 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 | 10.773 | Hillsborough Park | 0 | Local Park 2 | 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 | |
10928 | 10928 | 10927 | {"type": "Polygon", "coordinates": [[[-121.23265, 38.7393], [-121.23203, 38.73923], [-121.23024, 38.73974], [-121.22955, 38.73943], [-121.22965, 38.7393], [-121.23099, 38.73852], [-121.22984, 38.73731], [-121.23054, 38.7369], [-121.23032, 38.73666], [-121.23082, 38.73667], [-121.23118, 38.73669], [-121.2326, 38.73687], [-121.23265, 38.7393]]]} | Open Access 1 | 20940 | Ray E. Lockridge Park | 24203 | 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 | 15.048 | Ray E. Lockridge Park | 0 | Local Park 2 | 4 | |
10916 | 10916 | 10915 | {"type": "Polygon", "coordinates": [[[-121.23266, 38.74778], [-121.233, 38.74779], [-121.2333, 38.74783], [-121.23366, 38.74792], [-121.23379, 38.74796], [-121.23383, 38.748], [-121.23383, 38.74804], [-121.23346, 38.74887], [-121.23333, 38.74911], [-121.23319, 38.7493], [-121.233, 38.7495], [-121.23282, 38.74966], [-121.23254, 38.74984], [-121.23211, 38.74997], [-121.23183, 38.74985], [-121.23182, 38.74973], [-121.23141, 38.74972], [-121.23143, 38.74887], [-121.23092, 38.74887], [-121.23091, 38.74866], [-121.23115, 38.74854], [-121.2312, 38.74846], [-121.23117, 38.7484], [-121.231, 38.74823], [-121.23195, 38.74789], [-121.23228, 38.74782], [-121.23266, 38.74778]]]} | Open Access 1 | 20921 | Olympus Park | 23141 | 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.909 | Olympus Park | 0 | Local Park 2 | 4 | |
12464 | 12464 | 12463 | {"type": "Polygon", "coordinates": [[[-121.23271, 38.75219], [-121.23154, 38.75352], [-121.23154, 38.75353], [-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.75346], [-121.2304, 38.75322], [-121.23049, 38.75273], [-121.23058, 38.75271], [-121.23064, 38.75264], [-121.23064, 38.75259], [-121.23062, 38.75254], [-121.23053, 38.7525], [-121.2306, 38.75219], [-121.23271, 38.75219]]]} | Open Access 1 | 48763 | Waltrip Park | 33490 | 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 | https://www.roseville.ca.us/cms/One.aspx?portalId=7964922&pageId=10993299 | Placer 35 | 7.777 | Waltrip Park | 0 | Local Park 2 | 4 |
12642 | 12642 | 12641 | {"type": "Polygon", "coordinates": [[[-121.23375, 38.76677], [-121.23373, 38.76704], [-121.2333, 38.76698], [-121.23292, 38.76735], [-121.23232, 38.76763], [-121.2317, 38.76788], [-121.23105, 38.76811], [-121.22949, 38.76852], [-121.22919, 38.76864], [-121.22843, 38.7688], [-121.22828, 38.76894], [-121.22805, 38.76934], [-121.22789, 38.7695], [-121.2274, 38.76968], [-121.22692, 38.76968], [-121.22675, 38.76998], [-121.22677, 38.77033], [-121.22568, 38.77034], [-121.22612, 38.76974], [-121.2261, 38.76952], [-121.22446, 38.76905], [-121.22456, 38.76889], [-121.2247, 38.76876], [-121.22482, 38.76862], [-121.22494, 38.76845], [-121.22497, 38.76835], [-121.22497, 38.76821], [-121.22493, 38.76808], [-121.22472, 38.76779], [-121.22505, 38.76765], [-121.22532, 38.76804], [-121.22568, 38.76821], [-121.22575, 38.76826], [-121.22585, 38.76841], [-121.22598, 38.76882], [-121.22593, 38.76886], [-121.22621, 38.76924], [-121.22715, 38.76899], [-121.2277, 38.76851], [-121.22791, 38.76837], [-121.22838, 38.76813], [-121.22865, 38.76804], [-121.22891, 38.76798], [-121.23007, 38.7678], [-121.23105, 38.76724], [-121.23083, 38.76692], [-121.23118, 38.76679], [-121.23147, 38.76718], [-121.23193, 38.76712], [-121.23215, 38.76691], [-121.23228, 38.76661], [-121.23231, 38.7665], [-121.23236, 38.76643], [-121.23263, 38.76653], [-121.23299, 38.76663], [-121.23335, 38.76671], [-121.23375, 38.76677]]]} | Open Access 1 | 29469 | Secret Ravine Park | 25281 | 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.508 | Secret Ravine Park | 0 | Local Park 2 | 4 | |
3625 | 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 | |
12644 | 12644 | 12643 | {"type": "Polygon", "coordinates": [[[-121.23738, 38.7669], [-121.23737, 38.76733], [-121.23735, 38.76747], [-121.2373, 38.76762], [-121.23715, 38.76789], [-121.23692, 38.76813], [-121.23663, 38.76832], [-121.23412, 38.76962], [-121.23287, 38.76814], [-121.23345, 38.76783], [-121.23361, 38.76772], [-121.2337, 38.76762], [-121.2338, 38.76747], [-121.23387, 38.76731], [-121.23389, 38.76718], [-121.2339, 38.76685], [-121.23398, 38.76681], [-121.23398, 38.76679], [-121.23674, 38.7668], [-121.23727, 38.76682], [-121.23727, 38.76684], [-121.23733, 38.76686], [-121.23735, 38.7669], [-121.23738, 38.7669]]]} | Open Access 1 | 29479 | Harry Crabb Park | 19705 | 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.82 | Harry Crabb 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 | |
10924 | 10924 | 10923 | {"type": "Polygon", "coordinates": [[[-121.24017, 38.72845], [-121.24012, 38.72857], [-121.2401, 38.72873], [-121.24009, 38.7297], [-121.24007, 38.72973], [-121.24001, 38.72975], [-121.23919, 38.72965], [-121.23917, 38.72832], [-121.23896, 38.72831], [-121.23894, 38.72817], [-121.23808, 38.72816], [-121.23807, 38.72824], [-121.23775, 38.72824], [-121.23774, 38.72771], [-121.2397, 38.7277], [-121.24017, 38.72845]]]} | Open Access 1 | 20936 | Willard Dietrich Park | 27530 | 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.806 | Willard Dietrich Park | 0 | Local Park 2 | 4 | |
12641 | 12641 | 12640 | {"type": "Polygon", "coordinates": [[[-121.24502, 38.75872], [-121.24496, 38.75878], [-121.2447, 38.75881], [-121.24447, 38.75887], [-121.24429, 38.75896], [-121.24399, 38.75914], [-121.24374, 38.75926], [-121.24348, 38.75936], [-121.24299, 38.75949], [-121.24279, 38.75957], [-121.24235, 38.75977], [-121.24169, 38.76015], [-121.2414, 38.75979], [-121.23915, 38.76145], [-121.23854, 38.76172], [-121.23809, 38.76199], [-121.2378, 38.76218], [-121.23758, 38.76239], [-121.23708, 38.76296], [-121.23585, 38.76411], [-121.23562, 38.76444], [-121.23528, 38.76514], [-121.23459, 38.76562], [-121.23434, 38.76586], [-121.23412, 38.76621], [-121.23406, 38.76646], [-121.23405, 38.76658], [-121.23342, 38.76651], [-121.23314, 38.76645], [-121.23281, 38.76636], [-121.23285, 38.76629], [-121.23304, 38.76626], [-121.23321, 38.76619], [-121.23348, 38.76597], [-121.23359, 38.76581], [-121.2336, 38.76527], [-121.23419, 38.76527], [-121.23425, 38.7652], [-121.23426, 38.76478], [-121.2342, 38.76472], [-121.23425, 38.76469], [-121.23428, 38.76465], [-121.23427, 38.76455], [-121.23466, 38.76454], [-121.23499, 38.7643], [-121.23516, 38.76398], [-121.23519, 38.76378], [-121.23459, 38.76336], [-121.23428, 38.76336], [-121.23428, 38.76303], [-121.23423, 38.76289], [-121.23417, 38.76276], [-121.23504, 38.76264], [-121.23563, 38.76224], [-121.23612, 38.76226], [-121.23651, 38.76192], [-121.23653, 38.76148], [-121.2359, 38.76106], [-121.236, 38.76095], [-121.23612, 38.76087], [-121.23637, 38.76076], [-121.2367, 38.76068], [-121.23694, 38.76109], [-121.23753, 38.76086], [-121.23781, 38.76068], [-121.23951, 38.75949], [-121.24003, 38.75919], [-121.24031, 38.75908], [-121.24147, 38.75881], [-121.24147, 38.7588], [-121.24104, 38.75821], [-121.24112, 38.75808], [-121.24117, 38.75805], [-121.24161, 38.75813], [-121.24167, 38.75838], [-121.24187, 38.75871], [-121.24237, 38.7586], [-121.24282, 38.75826], [-121.24306, 38.75811], [-121.24391, 38.75776], [-121.24418, 38.75768], [-121.24484, 38.75755], [-121.24492, 38.75779], [-121.24499, 38.75811], [-121.24502, 38.75872]]]} | Open Access 1 | 29468 | False Ravine Park | 18840 | 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.406 | False Ravine Park | 0 | Local Park 2 | 4 | |
12625 | 12625 | 12624 | {"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 | 29475 | John Piches Park | 20462 | 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.981 | John Piches Park | 0 | Local Park 2 | 4 | |
12648 | 12648 | 12647 | {"type": "Polygon", "coordinates": [[[-121.25289, 38.7212], [-121.25269, 38.72121], [-121.25269, 38.72142], [-121.25255, 38.72143], [-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 | 29485 | Crestmont Park | 17809 | 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 | 6.387 | Crestmont Park | 0 | Local Park 2 | 4 | |
12647 | 12647 | 12646 | {"type": "Polygon", "coordinates": [[[-121.2594, 38.74656], [-121.2593, 38.74661], [-121.25925, 38.7467], [-121.25919, 38.74691], [-121.2591, 38.747], [-121.25877, 38.747], [-121.25821, 38.74694], [-121.258, 38.74697], [-121.258, 38.74604], [-121.2582, 38.74599], [-121.25828, 38.74594], [-121.25832, 38.74583], [-121.25832, 38.74568], [-121.25867, 38.74549], [-121.25883, 38.74544], [-121.25893, 38.74525], [-121.25912, 38.74525], [-121.25913, 38.7458], [-121.25914, 38.74601], [-121.25924, 38.7463], [-121.2594, 38.74656]]]} | Open Access 1 | 29482 | Marco Dog Park | 21796 | 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.975 | Marco Dog Park | 0 | Local Park 2 | 4 | |
12626 | 12626 | 12625 | {"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 | 29477 | Sculpture Park | 25220 | 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.815 | Sculpture 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]);