units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
46 rows where DES_TP = 14 and MNG_AGENCY = 533 sorted by map
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 46
MNG_AGENCY 1
- Roseville, City of · 46 ✖
DES_TP 1
- Local Other or Unknown · 46 ✖
ACCESS_TYP 1
- Open Access 46
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3050 | 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.24387, 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 | |
13833 | 13833 | 13832 | {"type": "MultiPolygon", "coordinates": [[[[-121.26563, 38.75907], [-121.26557, 38.7593], [-121.2655, 38.75933], [-121.26527, 38.75949], [-121.26532, 38.75954], [-121.26548, 38.75949], [-121.26554, 38.75951], [-121.2656, 38.75956], [-121.2656, 38.76219], [-121.26264, 38.76212], [-121.26238, 38.76232], [-121.26236, 38.76614], [-121.26277, 38.76663], [-121.26083, 38.76664], [-121.2601, 38.76776], [-121.26007, 38.76784], [-121.26007, 38.76802], [-121.26014, 38.76828], [-121.26048, 38.76883], [-121.26044, 38.76961], [-121.26028, 38.77043], [-121.25966, 38.77028], [-121.25947, 38.77022], [-121.25929, 38.77014], [-121.25866, 38.76979], [-121.25872, 38.76979], [-121.25913, 38.76859], [-121.25831, 38.76752], [-121.25745, 38.76894], [-121.25746, 38.76946], [-121.25729, 38.76949], [-121.25656, 38.76967], [-121.2566, 38.76976], [-121.25733, 38.76959], [-121.25746, 38.76957], [-121.25746, 38.76959], [-121.25646, 38.76981], [-121.25603, 38.76986], [-121.25586, 38.76991], [-121.25581, 38.76991], [-121.25573, 38.76989], [-121.25566, 38.76979], [-121.25497, 38.76977], [-121.25568, 38.76893], [-121.25606, 38.76844], [-121.2565, 38.76781], [-121.25726, 38.76665], [-121.2574, 38.76664], [-121.25789, 38.76595], [-121.25836, 38.76526], [-121.25906, 38.76417], [-121.26115, 38.76082], [-121.26133, 38.76058], [-121.26153, 38.76035], [-121.26192, 38.76001], [-121.2623, 38.75976], [-121.26277, 38.75952], [-121.26323, 38.75935], [-121.2637, 38.75922], [-121.26419, 38.75914], [-121.26563, 38.75907]]], [[[-121.25747, 38.7696], [-121.25759, 38.76957], [-121.25774, 38.76958], [-121.2579, 38.7696], [-121.25807, 38.76965], [-121.25822, 38.76972], [-121.25931, 38.77031], [-121.25957, 38.77041], [-121.26025, 38.77057], [-121.26018, 38.77076], [-121.2601, 38.77085], [-121.26003, 38.77089], [-121.25963, 38.77103], [-121.25942, 38.77113], [-121.25923, 38.77128], [-121.25908, 38.77147], [-121.25878, 38.77197], [-121.25851, 38.77251], [-121.25829, 38.77354], [-121.25636, 38.7731], [-121.25634, 38.77292], [-121.25603, 38.77257], [-121.25652, 38.77212], [-121.25656, 38.77206], [-121.2558, 38.77165], [-121.25603, 38.77139], [-121.25627, 38.77142], [-121.25663, 38.77083], [-121.2564, 38.77022], [-121.25673, 38.77014], [-121.25661, 38.7698], [-121.25747, 38.7696]]]]} | Open Access 1 | 36423 | Roseville holding 34 | 24654 | 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 | 116.361 | Roseville holding 34 | 0 | Local Other or Unknown 14 | 4 | |
13869 | 13869 | 13868 | {"type": "MultiPolygon", "coordinates": [[[[-121.26734, 38.7323], [-121.26626, 38.7326], [-121.26625, 38.73285], [-121.26643, 38.73321], [-121.26695, 38.7334], [-121.26695, 38.73389], [-121.26687, 38.73422], [-121.26683, 38.73463], [-121.26662, 38.73479], [-121.26642, 38.73489], [-121.2661, 38.73498], [-121.26588, 38.735], [-121.2656, 38.73506], [-121.26536, 38.73519], [-121.26518, 38.73538], [-121.26504, 38.7356], [-121.26456, 38.73555], [-121.26417, 38.73571], [-121.2637, 38.73577], [-121.26275, 38.73606], [-121.26275, 38.7363], [-121.26205, 38.73631], [-121.26201, 38.73654], [-121.26195, 38.73667], [-121.26189, 38.73678], [-121.26155, 38.73663], [-121.26131, 38.73684], [-121.26071, 38.73684], [-121.26006, 38.7365], [-121.26008, 38.73647], [-121.26008, 38.73646], [-121.25969, 38.73628], [-121.25954, 38.73614], [-121.25938, 38.73601], [-121.25921, 38.73594], [-121.25879, 38.73604], [-121.2587, 38.73599], [-121.25866, 38.736], [-121.2586, 38.73321], [-121.25835, 38.73203], [-121.25829, 38.73203], [-121.25828, 38.73172], [-121.25832, 38.73171], [-121.2584, 38.73192], [-121.25855, 38.73214], [-121.25874, 38.73236], [-121.25952, 38.73293], [-121.25993, 38.73321], [-121.26032, 38.73321], [-121.26032, 38.73389], [-121.26149, 38.73473], [-121.2641, 38.73471], [-121.26476, 38.73468], [-121.26522, 38.73462], [-121.26573, 38.73442], [-121.26609, 38.73404], [-121.26621, 38.73359], [-121.26577, 38.73271], [-121.26574, 38.7325], [-121.26587, 38.73238], [-121.26653, 38.73211], [-121.26708, 38.73196], [-121.26734, 38.73194], [-121.26734, 38.7323]]], [[[-121.2719, 38.73376], [-121.2719, 38.73406], [-121.27145, 38.73404], [-121.27076, 38.73392], [-121.27048, 38.73382], [-121.27028, 38.7338], [-121.27019, 38.73376], [-121.27008, 38.73362], [-121.27001, 38.73356], [-121.26982, 38.73349], [-121.2697, 38.7334], [-121.2697, 38.73335], [-121.26936, 38.73299], [-121.2688, 38.73266], [-121.26767, 38.73227], [-121.26751, 38.73229], [-121.2675, 38.73197], [-121.26792, 38.73205], [-121.26829, 38.73216], [-121.26864, 38.73226], [-121.26942, 38.73267], [-121.26975, 38.73293], [-121.26994, 38.73315], [-121.27049, 38.73359], [-121.27092, 38.73362], [-121.27126, 38.7335], [-121.27152, 38.73374], [-121.2719, 38.73376]]]]} | Open Access 1 | 36460 | Roseville holding 19 | 24637 | 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.189 | Roseville holding 19 | 0 | Local Other or Unknown 14 | 4 | |
13838 | 13838 | 13837 | {"type": "MultiPolygon", "coordinates": [[[[-121.27583, 38.78542], [-121.27565, 38.78562], [-121.2749, 38.78586], [-121.27441, 38.78594], [-121.274, 38.78597], [-121.27348, 38.78594], [-121.27242, 38.78581], [-121.27207, 38.78582], [-121.27134, 38.78606], [-121.2708, 38.78601], [-121.26981, 38.78552], [-121.26945, 38.78548], [-121.26862, 38.78553], [-121.26736, 38.78575], [-121.26707, 38.78593], [-121.26684, 38.78648], [-121.26655, 38.78608], [-121.26631, 38.78568], [-121.26638, 38.78534], [-121.26704, 38.78475], [-121.2674, 38.78457], [-121.26797, 38.78444], [-121.26872, 38.78451], [-121.26908, 38.78459], [-121.26944, 38.78464], [-121.26998, 38.78476], [-121.27049, 38.78517], [-121.2711, 38.78518], [-121.27171, 38.78493], [-121.2718, 38.78493], [-121.27233, 38.78501], [-121.27266, 38.78494], [-121.27324, 38.78495], [-121.27415, 38.7852], [-121.27468, 38.78523], [-121.27491, 38.78496], [-121.27583, 38.78542]]], [[[-121.27822, 38.78417], [-121.27622, 38.78508], [-121.27604, 38.78528], [-121.27485, 38.78468], [-121.27501, 38.78464], [-121.27639, 38.78326], [-121.27822, 38.78417]]]]} | Open Access 1 | 36429 | Roseville holding 27 | 24646 | 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.609 | Roseville holding 27 | 0 | Local Other or Unknown 14 | 4 | |
5354 | 5354 | 5353 | {"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.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], [-121.27822, 38.76677], [-121.27819, 38.76686]]]]} | Open Access 1 | 36420 | Roseville holding 29 | 24648 | 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.864 | Roseville holding 29 | 0 | Local Other or Unknown 14 | 4 | |
13989 | 13989 | 13988 | {"type": "Polygon", "coordinates": [[[-121.21782, 38.72076], [-121.21758, 38.7208], [-121.21734, 38.72088], [-121.21712, 38.72103], [-121.21687, 38.72108], [-121.21656, 38.72104], [-121.21655, 38.72139], [-121.21573, 38.72099], [-121.21577, 38.72075], [-121.2158, 38.72071], [-121.21586, 38.72069], [-121.21588, 38.72054], [-121.21585, 38.72053], [-121.21597, 38.72036], [-121.21628, 38.72067], [-121.21632, 38.72069], [-121.21635, 38.72067], [-121.21637, 38.71985], [-121.21634, 38.71977], [-121.21634, 38.71962], [-121.21636, 38.71954], [-121.21648, 38.71935], [-121.21642, 38.71931], [-121.21613, 38.71931], [-121.21612, 38.71922], [-121.21653, 38.71922], [-121.21654, 38.71941], [-121.21696, 38.71986], [-121.2172, 38.71964], [-121.21725, 38.71967], [-121.21702, 38.71992], [-121.21782, 38.72076]]]} | Open Access 1 | 36673 | Roseville holding 42 | 24663 | 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.488 | Roseville holding 42 | 0 | Local Other or Unknown 14 | 4 | |
4814 | 4814 | 4813 | {"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 | 48764 | Unknown Park - Roseville, City of | 33491 | 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.092 | 0 | Local Other or Unknown 14 | 4 | ||
13836 | 13836 | 13835 | {"type": "Polygon", "coordinates": [[[-121.22836, 38.73076], [-121.22836, 38.73086], [-121.22831, 38.73091], [-121.22796, 38.73092], [-121.22796, 38.73079], [-121.22828, 38.73079], [-121.22832, 38.73076], [-121.22836, 38.73076]]]} | Open Access 1 | 36427 | Roseville holding 35 | 24655 | 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.124 | Roseville holding 35 | 0 | Local Other or Unknown 14 | 4 | |
13837 | 13837 | 13836 | {"type": "Polygon", "coordinates": [[[-121.23075, 38.73105], [-121.23072, 38.73117], [-121.23009, 38.73105], [-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.22856, 38.73079], [-121.22916, 38.73081], [-121.22976, 38.73086], [-121.23029, 38.73095], [-121.23075, 38.73105]]]} | Open Access 1 | 36428 | Roseville holding 26 | 24645 | 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.734 | Roseville holding 26 | 0 | Local Other or Unknown 14 | 4 | |
13835 | 13835 | 13834 | {"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 | 36426 | Roseville holding 25 | 24644 | 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.497 | Roseville holding 25 | 0 | Local Other or Unknown 14 | 4 | |
13839 | 13839 | 13838 | {"type": "Polygon", "coordinates": [[[-121.24156, 38.73934], [-121.24125, 38.73946], [-121.24051, 38.73948], [-121.23986, 38.73945], [-121.2389, 38.7392], [-121.23841, 38.73917], [-121.23818, 38.73912], [-121.23784, 38.73924], [-121.23757, 38.73919], [-121.23748, 38.73911], [-121.23722, 38.73929], [-121.23715, 38.73925], [-121.23711, 38.73918], [-121.23683, 38.73919], [-121.23671, 38.73931], [-121.2367, 38.73946], [-121.23634, 38.7397], [-121.23614, 38.74011], [-121.23586, 38.74029], [-121.2358, 38.74004], [-121.23578, 38.73942], [-121.23583, 38.73941], [-121.23581, 38.73859], [-121.23594, 38.73848], [-121.23736, 38.73854], [-121.23819, 38.73859], [-121.23827, 38.73864], [-121.23838, 38.73864], [-121.23862, 38.73869], [-121.2387, 38.73882], [-121.23882, 38.73891], [-121.23891, 38.73892], [-121.23896, 38.73896], [-121.23928, 38.73901], [-121.23969, 38.73912], [-121.23979, 38.73911], [-121.2399, 38.73916], [-121.24007, 38.73913], [-121.24012, 38.7391], [-121.24017, 38.73912], [-121.24022, 38.73912], [-121.24029, 38.73908], [-121.24043, 38.73913], [-121.24063, 38.73914], [-121.24065, 38.73915], [-121.24122, 38.73912], [-121.24156, 38.73934]]]} | Open Access 1 | 36430 | Roseville holding 36 | 24656 | 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 | 7.922 | Roseville holding 36 | 0 | Local Other or Unknown 14 | 4 | |
13846 | 13846 | 13845 | {"type": "Polygon", "coordinates": [[[-121.24296, 38.71911], [-121.24239, 38.71886], [-121.2423, 38.71857], [-121.2423, 38.71852], [-121.24233, 38.71848], [-121.24273, 38.71815], [-121.24269, 38.71824], [-121.24268, 38.71838], [-121.24271, 38.71863], [-121.24281, 38.71889], [-121.24296, 38.71911]]]} | Open Access 1 | 36435 | Roseville holding 37 | 24657 | 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.609 | Roseville holding 37 | 0 | Local Other or Unknown 14 | 4 | |
13870 | 13870 | 13869 | {"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 | 36461 | Roseville holding 18 | 24636 | 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.478 | Roseville holding 18 | 0 | Local Other or Unknown 14 | 4 | |
13868 | 13868 | 13867 | {"type": "Polygon", "coordinates": [[[-121.25119, 38.76227], [-121.25118, 38.76283], [-121.2511, 38.76282], [-121.25103, 38.76312], [-121.25079, 38.7631], [-121.25076, 38.76321], [-121.25066, 38.76323], [-121.25051, 38.76323], [-121.25048, 38.7634], [-121.25038, 38.76345], [-121.25014, 38.76348], [-121.25016, 38.76361], [-121.25006, 38.76369], [-121.24974, 38.76379], [-121.24939, 38.76382], [-121.24918, 38.76394], [-121.24886, 38.76392], [-121.24872, 38.76407], [-121.24858, 38.76412], [-121.24851, 38.76423], [-121.24826, 38.76432], [-121.24834, 38.76444], [-121.2483, 38.76454], [-121.24817, 38.76459], [-121.2481, 38.76466], [-121.24802, 38.76467], [-121.24783, 38.76464], [-121.24778, 38.76447], [-121.2475, 38.76446], [-121.2474, 38.76452], [-121.24729, 38.76448], [-121.24719, 38.76453], [-121.24699, 38.76451], [-121.24686, 38.76442], [-121.24659, 38.76445], [-121.24649, 38.76427], [-121.24634, 38.76433], [-121.246, 38.76432], [-121.24588, 38.76427], [-121.24584, 38.76423], [-121.24585, 38.76419], [-121.24589, 38.76416], [-121.24618, 38.7642], [-121.24654, 38.76409], [-121.24674, 38.76424], [-121.24693, 38.76415], [-121.2472, 38.76415], [-121.24724, 38.76406], [-121.24738, 38.76404], [-121.24771, 38.76423], [-121.24794, 38.7639], [-121.24792, 38.76371], [-121.24802, 38.76359], [-121.24826, 38.76352], [-121.24827, 38.76329], [-121.24881, 38.76292], [-121.24897, 38.7627], [-121.24922, 38.76266], [-121.24933, 38.76223], [-121.24988, 38.76224], [-121.24989, 38.76222], [-121.25095, 38.76223], [-121.25096, 38.76227], [-121.25119, 38.76227]]]} | Open Access 1 | 36459 | Roseville holding 16 | 24634 | 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.651 | Roseville holding 16 | 0 | Local Other or Unknown 14 | 4 | |
13873 | 13873 | 13872 | {"type": "Polygon", "coordinates": [[[-121.25551, 38.73951], [-121.25547, 38.73971], [-121.25543, 38.7397], [-121.25492, 38.73969], [-121.25405, 38.74009], [-121.25408, 38.74219], [-121.25395, 38.74206], [-121.25384, 38.74188], [-121.25376, 38.74169], [-121.25372, 38.74148], [-121.25371, 38.74006], [-121.25374, 38.73979], [-121.25384, 38.73938], [-121.25404, 38.73937], [-121.25406, 38.73985], [-121.25418, 38.73976], [-121.25483, 38.73952], [-121.25511, 38.73949], [-121.25551, 38.73951]]]} | Open Access 1 | 36464 | Roseville holding 21 | 24640 | 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.809 | Roseville holding 21 | 0 | Local Other or Unknown 14 | 4 | |
13841 | 13841 | 13840 | {"type": "Polygon", "coordinates": [[[-121.25572, 38.72971], [-121.25572, 38.73032], [-121.2557, 38.73046], [-121.25562, 38.73062], [-121.25555, 38.73072], [-121.25548, 38.7307], [-121.25502, 38.73118], [-121.25487, 38.73128], [-121.25469, 38.73134], [-121.25452, 38.73102], [-121.25441, 38.73102], [-121.25442, 38.731], [-121.25449, 38.73098], [-121.25448, 38.7306], [-121.25445, 38.73046], [-121.25435, 38.73028], [-121.25413, 38.73021], [-121.25399, 38.73019], [-121.25392, 38.73021], [-121.25391, 38.73008], [-121.25343, 38.73003], [-121.25286, 38.73006], [-121.25286, 38.72987], [-121.25391, 38.72987], [-121.25391, 38.72967], [-121.25567, 38.72967], [-121.25572, 38.72971]]]} | Open Access 1 | 36432 | Roseville holding 38 | 24658 | 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.217 | Roseville holding 38 | 0 | Local Other or Unknown 14 | 4 | |
13860 | 13860 | 13859 | {"type": "Polygon", "coordinates": [[[-121.25834, 38.73133], [-121.25794, 38.73149], [-121.25793, 38.73087], [-121.25833, 38.73087], [-121.25834, 38.73133]]]} | Open Access 1 | 36451 | Roseville holding 10 | 24628 | 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.514 | Roseville holding 10 | 0 | Local Other or Unknown 14 | 4 | |
13871 | 13871 | 13870 | {"type": "Polygon", "coordinates": [[[-121.25991, 38.74062], [-121.2595, 38.74063], [-121.25902, 38.74044], [-121.25851, 38.74038], [-121.25832, 38.74062], [-121.25739, 38.74034], [-121.25647, 38.74023], [-121.25623, 38.74023], [-121.25597, 38.73979], [-121.25569, 38.73979], [-121.25569, 38.73955], [-121.25612, 38.73958], [-121.25648, 38.74002], [-121.25746, 38.74014], [-121.25863, 38.74022], [-121.25935, 38.74032], [-121.25958, 38.74046], [-121.25988, 38.74041], [-121.25991, 38.74062]]]} | Open Access 1 | 36462 | Roseville holding 43 | 24664 | 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.535 | Roseville holding 43 | 0 | Local Other or Unknown 14 | 4 | |
13872 | 13872 | 13871 | {"type": "Polygon", "coordinates": [[[-121.26094, 38.73866], [-121.26079, 38.73896], [-121.26056, 38.73889], [-121.26071, 38.73859], [-121.26094, 38.73866]]]} | Open Access 1 | 36463 | Roseville holding 20 | 24639 | 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.188 | Roseville holding 20 | 0 | Local Other or Unknown 14 | 4 | |
13874 | 13874 | 13873 | {"type": "Polygon", "coordinates": [[[-121.26187, 38.74161], [-121.26125, 38.74206], [-121.26126, 38.74403], [-121.26106, 38.74403], [-121.26106, 38.74328], [-121.26099, 38.74322], [-121.26038, 38.74322], [-121.26038, 38.74317], [-121.26099, 38.74317], [-121.26106, 38.74311], [-121.26106, 38.74198], [-121.26165, 38.74155], [-121.26163, 38.74138], [-121.2616, 38.74118], [-121.26036, 38.74062], [-121.26014, 38.74062], [-121.2601, 38.74037], [-121.26044, 38.74031], [-121.2604, 38.74015], [-121.26031, 38.73951], [-121.26036, 38.73928], [-121.26049, 38.73903], [-121.26071, 38.7391], [-121.26059, 38.73935], [-121.26056, 38.73955], [-121.26064, 38.74012], [-121.26076, 38.74054], [-121.2609, 38.74068], [-121.26181, 38.74109], [-121.26187, 38.74161]]]} | Open Access 1 | 36465 | Roseville holding 22 | 24641 | 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.28 | Roseville holding 22 | 0 | Local Other or Unknown 14 | 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]);