units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
130 rows where MNG_AGENCY = 533 sorted by DES_TP descending
This data as json, copyable, CSV (advanced)
Suggested facets: GAP_STS
DES_TP 9
- Local Park 67
- Local Other or Unknown 46
- Local Recreation Area 9
- Local Conservation Area 3
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency 130
MNG_AGENCY 1
- 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12643 | 12643 | 12642 | {"type": "Polygon", "coordinates": [[[-121.22468, 38.76733], [-121.22222, 38.76843], [-121.22123, 38.7689], [-121.22088, 38.7691], [-121.22075, 38.76896], [-121.22106, 38.76875], [-121.2214, 38.76847], [-121.22171, 38.76816], [-121.22193, 38.76789], [-121.22212, 38.7676], [-121.22231, 38.76724], [-121.22242, 38.76693], [-121.22251, 38.76659], [-121.2246, 38.76659], [-121.22461, 38.7671], [-121.22468, 38.76733]]]} | Open Access 1 | 29471 | Welands | 27335 | 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 | 8.755 | Welands | None 1096 | |||
10917 | 10917 | 10916 | {"type": "Polygon", "coordinates": [[[-121.28958, 38.73527], [-121.2895, 38.73568], [-121.28937, 38.73609], [-121.28927, 38.73609], [-121.28931, 38.73527], [-121.28958, 38.73527]]]} | Open Access 1 | 20922 | SAUGSTAD PARK | 25170 | 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.397 | SAUGSTAD PARK | None 952 | |||
10904 | 10904 | 10903 | {"type": "MultiPolygon", "coordinates": [[[[-121.29959, 38.76962], [-121.2993, 38.7698], [-121.29923, 38.76987], [-121.29918, 38.76996], [-121.29916, 38.77015], [-121.29909, 38.77023], [-121.29902, 38.77026], [-121.29895, 38.77027], [-121.29852, 38.77021], [-121.29834, 38.77026], [-121.29781, 38.77063], [-121.29753, 38.77099], [-121.29743, 38.77103], [-121.2973, 38.77105], [-121.29728, 38.77091], [-121.29738, 38.77088], [-121.29763, 38.77055], [-121.2982, 38.77014], [-121.29832, 38.77009], [-121.29848, 38.77006], [-121.29861, 38.77006], [-121.29888, 38.7701], [-121.29892, 38.7701], [-121.29896, 38.77006], [-121.29897, 38.76993], [-121.29901, 38.76983], [-121.29912, 38.76971], [-121.29946, 38.76949], [-121.29959, 38.76962]]], [[[-121.30131, 38.76977], [-121.30109, 38.7698], [-121.30087, 38.76974], [-121.30077, 38.77001], [-121.30059, 38.76995], [-121.30061, 38.7699], [-121.30055, 38.76978], [-121.30029, 38.76952], [-121.30004, 38.76946], [-121.29992, 38.76945], [-121.29981, 38.76947], [-121.29971, 38.76953], [-121.29926, 38.76909], [-121.29925, 38.76904], [-121.29938, 38.76892], [-121.2995, 38.76884], [-121.29964, 38.76879], [-121.2998, 38.76875], [-121.29992, 38.76929], [-121.30018, 38.76932], [-121.30025, 38.76925], [-121.30036, 38.76927], [-121.30039, 38.76931], [-121.30056, 38.76939], [-121.30083, 38.76944], [-121.30096, 38.76948], [-121.30126, 38.76949], [-121.30131, 38.76977]]], [[[-121.30185, 38.76993], [-121.3015, 38.76993], [-121.30142, 38.76957], [-121.30177, 38.76954], [-121.30185, 38.76993]]], [[[-121.30413, 38.77028], [-121.30379, 38.77055], [-121.30374, 38.77063], [-121.30374, 38.77072], [-121.30321, 38.77073], [-121.30284, 38.77079], [-121.30276, 38.77077], [-121.30273, 38.77074], [-121.30268, 38.77062], [-121.30253, 38.77014], [-121.3024, 38.76965], [-121.30229, 38.7691], [-121.30254, 38.76925], [-121.30251, 38.76928], [-121.30251, 38.7693], [-121.30256, 38.76932], [-121.3026, 38.76928], [-121.30314, 38.76959], [-121.30365, 38.76993], [-121.30413, 38.77028]]], [[[-121.31662, 38.77171], [-121.31619, 38.77188], [-121.31577, 38.77201], [-121.31578, 38.77177], [-121.31574, 38.77155], [-121.31561, 38.77139], [-121.31544, 38.77098], [-121.31523, 38.77076], [-121.31513, 38.77063], [-121.31501, 38.77051], [-121.31481, 38.77039], [-121.31453, 38.77035], [-121.31411, 38.77017], [-121.31393, 38.77022], [-121.31359, 38.77046], [-121.3134, 38.7704], [-121.31309, 38.76999], [-121.31309, 38.76967], [-121.31335, 38.76963], [-121.31368, 38.76973], [-121.31377, 38.76979], [-121.3139, 38.76983], [-121.3141, 38.76979], [-121.31416, 38.76971], [-121.31426, 38.76966], [-121.31466, 38.76978], [-121.31496, 38.76993], [-121.31529, 38.77021], [-121.31581, 38.77084], [-121.31587, 38.77099], [-121.3163, 38.77142], [-121.31639, 38.77154], [-121.31662, 38.77171]]], [[[-121.33001, 38.76511], [-121.32991, 38.76563], [-121.32982, 38.76636], [-121.32569, 38.76637], [-121.32568, 38.76502], [-121.32375, 38.76509], [-121.32375, 38.76473], [-121.32414, 38.76503], [-121.32558, 38.76498], [-121.32561, 38.76492], [-121.3256, 38.76477], [-121.32609, 38.76474], [-121.3261, 38.7649], [-121.32612, 38.76496], [-121.32932, 38.76485], [-121.32934, 38.76513], [-121.33001, 38.76511]]]]} | Open Access 1 | 20881 | Welands | 27335 | 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 | 26.924 | Welands | None 951 | |||
10901 | 10901 | 10900 | {"type": "Polygon", "coordinates": [[[-121.31804, 38.75775], [-121.31713, 38.75822], [-121.31682, 38.75837], [-121.31629, 38.75858], [-121.31573, 38.75875], [-121.31504, 38.75891], [-121.31443, 38.759], [-121.31396, 38.75904], [-121.31348, 38.75905], [-121.31343, 38.75904], [-121.31339, 38.759], [-121.31341, 38.75865], [-121.31345, 38.7585], [-121.3135, 38.75837], [-121.31358, 38.75823], [-121.31369, 38.75809], [-121.31397, 38.75784], [-121.31458, 38.75829], [-121.31596, 38.7574], [-121.31702, 38.75682], [-121.31804, 38.75775]]]} | Open Access 1 | 20892 | JAMES W. WANISH PARK | 20354 | 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.213 | JAMES W. WANISH PARK | None 950 | |||
2641 | 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 | |||
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 | |
3539 | 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 | 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 | |
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 | ||
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 | |
5385 | 5385 | 5384 | {"type": "Polygon", "coordinates": [[[-121.28307, 38.78], [-121.28264, 38.78022], [-121.28219, 38.78039], [-121.28199, 38.78005], [-121.28182, 38.77989], [-121.28146, 38.77964], [-121.28221, 38.77939], [-121.28307, 38.78]]]} | Open Access 1 | 36418 | Roseville holding 31 | 24651 | 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.841 | Roseville holding 31 | 0 | Local Other or Unknown 14 | 4 | |
5386 | 5386 | 5385 | {"type": "Polygon", "coordinates": [[[-121.31243, 38.80095], [-121.3121, 38.80123], [-121.31177, 38.801], [-121.31176, 38.80095], [-121.31148, 38.80074], [-121.31191, 38.80058], [-121.31243, 38.80095]]]} | Open Access 1 | 36419 | Roseville holding 30 | 24650 | 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.7 | Roseville holding 30 | 0 | Local Other or Unknown 14 | 4 | |
10918 | 10918 | 10917 | {"type": "Polygon", "coordinates": [[[-121.28931, 38.73527], [-121.28926, 38.73535], [-121.28919, 38.73532], [-121.28927, 38.73501], [-121.28923, 38.73477], [-121.28889, 38.73486], [-121.28886, 38.73484], [-121.2892, 38.73473], [-121.28893, 38.73434], [-121.28848, 38.73416], [-121.28827, 38.73404], [-121.28811, 38.73391], [-121.28768, 38.73376], [-121.28769, 38.73373], [-121.28697, 38.73301], [-121.28696, 38.73287], [-121.28596, 38.73286], [-121.28595, 38.73305], [-121.28563, 38.73306], [-121.28482, 38.73357], [-121.2845, 38.73363], [-121.28378, 38.73346], [-121.28357, 38.73328], [-121.28339, 38.73323], [-121.28305, 38.73259], [-121.2832, 38.73219], [-121.2832, 38.73179], [-121.28349, 38.73159], [-121.28366, 38.73137], [-121.28382, 38.73123], [-121.28412, 38.73154], [-121.28378, 38.73159], [-121.28366, 38.73184], [-121.28366, 38.73285], [-121.28421, 38.7332], [-121.28441, 38.73322], [-121.28474, 38.73313], [-121.28474, 38.73306], [-121.28486, 38.73306], [-121.28508, 38.73292], [-121.28537, 38.73268], [-121.28574, 38.73246], [-121.28582, 38.73234], [-121.28596, 38.73234], [-121.28597, 38.73238], [-121.2864, 38.73239], [-121.28691, 38.73245], [-121.28733, 38.73266], [-121.28753, 38.73284], [-121.2878, 38.73301], [-121.28786, 38.73307], [-121.28825, 38.7333], [-121.28826, 38.73334], [-121.28844, 38.73337], [-121.28862, 38.73345], [-121.28884, 38.73347], [-121.28928, 38.73373], [-121.28931, 38.73527]]]} | Open Access 1 | 20924 | 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 | 10.315 | Flood Control | 0 | Local Other or Unknown 14 | 4 | |
13820 | 13820 | 13819 | {"type": "Polygon", "coordinates": [[[-121.31816, 38.77053], [-121.31806, 38.77076], [-121.31784, 38.77063], [-121.31776, 38.77046], [-121.31816, 38.77053]]]} | Open Access 1 | 36404 | Roseville holding 14 | 24632 | 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.147 | Roseville holding 14 | 0 | Local Other or Unknown 14 | 4 | |
13824 | 13824 | 13823 | {"type": "Polygon", "coordinates": [[[-121.31748, 38.76975], [-121.31732, 38.76971], [-121.31722, 38.76963], [-121.31737, 38.76942], [-121.31747, 38.76953], [-121.31748, 38.76975]]]} | Open Access 1 | 36410 | Roseville holding 12 | 24630 | 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.121 | Roseville holding 12 | 0 | Local Other or Unknown 14 | 4 | |
13826 | 13826 | 13825 | {"type": "Polygon", "coordinates": [[[-121.27189, 38.72221], [-121.2719, 38.72246], [-121.27189, 38.72249], [-121.27183, 38.72252], [-121.27163, 38.72252], [-121.27162, 38.72235], [-121.27153, 38.72222], [-121.27189, 38.72221]]]} | Open Access 1 | 36425 | Roseville holding 24 | 24643 | 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.216 | Roseville holding 24 | 0 | Local Other or Unknown 14 | 4 | |
13830 | 13830 | 13829 | {"type": "Polygon", "coordinates": [[[-121.2774, 38.75226], [-121.27672, 38.7523], [-121.276, 38.7525], [-121.27515, 38.75246], [-121.27515, 38.75257], [-121.27232, 38.75259], [-121.27232, 38.75203], [-121.27306, 38.75202], [-121.27274, 38.7509], [-121.27349, 38.75084], [-121.2741, 38.75115], [-121.27423, 38.75136], [-121.27424, 38.75153], [-121.2746, 38.75152], [-121.27459, 38.75166], [-121.27461, 38.75202], [-121.27739, 38.75201], [-121.2774, 38.75226]]]} | Open Access 1 | 36417 | Roseville holding 32 | 24652 | 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.585 | Roseville holding 32 | 0 | Local Other or Unknown 14 | 4 | |
13831 | 13831 | 13830 | {"type": "Polygon", "coordinates": [[[-121.27192, 38.72489], [-121.27154, 38.72489], [-121.27165, 38.72472], [-121.27165, 38.72427], [-121.27117, 38.72371], [-121.2713, 38.72364], [-121.27155, 38.72304], [-121.2716, 38.72267], [-121.27184, 38.72267], [-121.27188, 38.72269], [-121.27191, 38.72273], [-121.27192, 38.72489]]]} | Open Access 1 | 36421 | Roseville holding 23 | 24642 | 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.207 | Roseville holding 23 | 0 | Local Other or Unknown 14 | 4 | |
13832 | 13832 | 13831 | {"type": "Polygon", "coordinates": [[[-121.27303, 38.72705], [-121.27266, 38.72708], [-121.27227, 38.72708], [-121.27222, 38.72706], [-121.27221, 38.72704], [-121.27219, 38.72273], [-121.27221, 38.72269], [-121.27227, 38.72267], [-121.27246, 38.72266], [-121.27249, 38.72298], [-121.27246, 38.72335], [-121.27246, 38.72361], [-121.27252, 38.72382], [-121.27248, 38.72408], [-121.27248, 38.72432], [-121.27248, 38.72481], [-121.27251, 38.72514], [-121.27251, 38.72644], [-121.27263, 38.72662], [-121.2728, 38.72666], [-121.27303, 38.72705]]]} | Open Access 1 | 36422 | Roseville holding 28 | 24647 | 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.549 | Roseville holding 28 | 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 |
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]);