units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
83 rows where MNG_AGENCY = 29 sorted by LABEL_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_TYP, AGNCY_WEB, LAYER, YR_EST, GAP_STS
DES_TP 14
- Local Park 68
- Local Recreation Area 3
- Local Conservation Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 3
AGNCY_LEV 2 ✖
- City 82
- Special District 1
MNG_AG_TYP 1
- City Agency 83
MNG_AGENCY 1
- Santa Rosa, City of · 83 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3681 | 3681 | 3680 | {"type": "Polygon", "coordinates": [[[-122.76777, 38.44155], [-122.76294, 38.44149], [-122.76245, 38.44143], [-122.75839, 38.44082], [-122.75793, 38.44072], [-122.75784, 38.43796], [-122.75939, 38.43796], [-122.75991, 38.4382], [-122.76024, 38.43812], [-122.76023, 38.43774], [-122.7607, 38.43792], [-122.76121, 38.43805], [-122.76187, 38.43812], [-122.76776, 38.43816], [-122.76777, 38.44155]]]} | Open Access 1 | 10425 | A Place to Play Park | 15224 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 76.453 | A Place to Play Park | 0 | Local Park 2 | 4 | |
5234 | 5234 | 5233 | {"type": "Polygon", "coordinates": [[[-122.75784, 38.4152], [-122.75778, 38.41523], [-122.75712, 38.41527], [-122.75706, 38.41524], [-122.75708, 38.41511], [-122.75706, 38.41495], [-122.757, 38.41477], [-122.75689, 38.41379], [-122.75695, 38.41376], [-122.75707, 38.41376], [-122.75772, 38.41379], [-122.75771, 38.41399], [-122.75778, 38.41411], [-122.75783, 38.41454], [-122.7578, 38.41467], [-122.75782, 38.4148], [-122.75781, 38.41494], [-122.75784, 38.4152]]]} | Open Access 1 | 48076 | Airfield Park | 32578 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | https://srcity.org/facilities/facility/details/airfieldpark-48 | Sonoma 16 | 2.865 | Airfield Park | 0 | Local Park 2 | 4 |
6615 | 6615 | 6614 | {"type": "MultiPolygon", "coordinates": [[[[-122.77242, 38.38856], [-122.77237, 38.38856], [-122.77228, 38.38852], [-122.77236, 38.38852], [-122.77242, 38.38856]]], [[[-122.78653, 38.39443], [-122.78225, 38.39597], [-122.77744, 38.39197], [-122.77726, 38.39206], [-122.77695, 38.39211], [-122.77686, 38.39216], [-122.77651, 38.39193], [-122.77658, 38.39187], [-122.77677, 38.39178], [-122.77708, 38.3917], [-122.77709, 38.39169], [-122.77328, 38.38856], [-122.77867, 38.38851], [-122.77897, 38.38833], [-122.77912, 38.38832], [-122.77993, 38.38786], [-122.78653, 38.39443]]], [[[-122.79813, 38.3852], [-122.79796, 38.38596], [-122.7971, 38.38672], [-122.79711, 38.38673], [-122.79756, 38.38673], [-122.79756, 38.38825], [-122.79762, 38.38827], [-122.79761, 38.38881], [-122.7974, 38.38973], [-122.79746, 38.39027], [-122.79521, 38.39118], [-122.79444, 38.39148], [-122.78668, 38.39437], [-122.78491, 38.39263], [-122.78087, 38.38859], [-122.78007, 38.38777], [-122.7815, 38.38698], [-122.78783, 38.38684], [-122.78778, 38.38578], [-122.78764, 38.38578], [-122.78757, 38.38314], [-122.79463, 38.38229], [-122.79484, 38.38244], [-122.79564, 38.38276], [-122.79618, 38.38313], [-122.79632, 38.38369], [-122.79703, 38.38415], [-122.79707, 38.38419], [-122.79708, 38.38423], [-122.79813, 38.3852]]]]} | No Public Access 3 | 4205 | Alpha Farm | 15405 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 410.901 | Alpha Farm | None 534 | |||
3671 | 3671 | 3670 | {"type": "Polygon", "coordinates": [[[-122.72799, 38.42185], [-122.72623, 38.4222], [-122.72621, 38.422], [-122.72615, 38.42201], [-122.72601, 38.42086], [-122.7278, 38.42042], [-122.72799, 38.42185]]]} | Open Access 1 | 29698 | Bayer Neighborhood Park and Gardens | 32509 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 6.16 | Bayer Neighborhood Park and Gardens | 2017 | Local Park 2 | 4 | |
3550 | 3550 | 3549 | {"type": "Polygon", "coordinates": [[[-122.79598, 38.68638], [-122.79593, 38.68645], [-122.79587, 38.68663], [-122.79584, 38.68702], [-122.79582, 38.68712], [-122.79577, 38.68724], [-122.79549, 38.68779], [-122.79545, 38.68786], [-122.79501, 38.68816], [-122.79483, 38.68832], [-122.79478, 38.68849], [-122.79478, 38.68903], [-122.79483, 38.68923], [-122.79486, 38.68944], [-122.79482, 38.68962], [-122.79478, 38.68969], [-122.79471, 38.68978], [-122.79457, 38.68984], [-122.79425, 38.68987], [-122.79372, 38.68983], [-122.79362, 38.68984], [-122.79311, 38.68994], [-122.79276, 38.69005], [-122.79265, 38.69012], [-122.79244, 38.6902], [-122.79194, 38.69034], [-122.79182, 38.69038], [-122.79175, 38.69043], [-122.79171, 38.6905], [-122.79168, 38.69063], [-122.79137, 38.69088], [-122.79073, 38.69135], [-122.79069, 38.69141], [-122.79067, 38.69148], [-122.7907, 38.6916], [-122.79102, 38.69195], [-122.79109, 38.69208], [-122.79115, 38.69228], [-122.79115, 38.69241], [-122.79113, 38.69252], [-122.79101, 38.69282], [-122.79094, 38.6929], [-122.79085, 38.69297], [-122.79052, 38.69312], [-122.79023, 38.69322], [-122.79012, 38.69328], [-122.78934, 38.69224], [-122.78925, 38.6893], [-122.78809, 38.68905], [-122.7847, 38.68871], [-122.78467, 38.68598], [-122.79598, 38.68638]]]} | No Public Access 3 | 28288 | Bear Canyon | 15921 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 98.229 | Bear Canyon | 0 | Local Recreation Area 3 | 4 | |
1497 | 1497 | 1496 | {"type": "Polygon", "coordinates": [[[-122.73927, 38.40898], [-122.73867, 38.40899], [-122.738, 38.40906], [-122.73765, 38.40913], [-122.73678, 38.40934], [-122.73673, 38.40907], [-122.73673, 38.40862], [-122.73676, 38.40856], [-122.73679, 38.40856], [-122.73922, 38.40855], [-122.73926, 38.40859], [-122.73927, 38.40898]]]} | Open Access 1 | 10498 | Bellevue Ranch | 15988 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 3.292 | Bellevue Ranch | 0 | Local Park 2 | 4 | |
10343 | 10343 | 10342 | {"type": "Polygon", "coordinates": [[[-122.66467, 38.42516], [-122.66241, 38.42639], [-122.66227, 38.4263], [-122.66226, 38.42719], [-122.65949, 38.42718], [-122.65908, 38.42721], [-122.65845, 38.42668], [-122.65832, 38.42654], [-122.65644, 38.4244], [-122.65601, 38.42344], [-122.65578, 38.42204], [-122.65565, 38.42202], [-122.65546, 38.42204], [-122.65549, 38.4217], [-122.65548, 38.42103], [-122.65551, 38.41987], [-122.65565, 38.41987], [-122.65588, 38.4191], [-122.65722, 38.41788], [-122.65756, 38.41741], [-122.6573, 38.4169], [-122.65799, 38.41691], [-122.6584, 38.41785], [-122.65968, 38.41786], [-122.65969, 38.41989], [-122.66115, 38.4199], [-122.66231, 38.41954], [-122.66239, 38.41954], [-122.66292, 38.41936], [-122.66368, 38.41889], [-122.66412, 38.4193], [-122.6643, 38.41953], [-122.66441, 38.4197], [-122.66452, 38.41991], [-122.66463, 38.42017], [-122.66468, 38.42039], [-122.66472, 38.42062], [-122.66473, 38.42089], [-122.66471, 38.42112], [-122.6646, 38.42152], [-122.66438, 38.42201], [-122.66428, 38.42228], [-122.66368, 38.42219], [-122.66363, 38.42242], [-122.6636, 38.42265], [-122.66358, 38.42288], [-122.6636, 38.42317], [-122.66364, 38.42345], [-122.66372, 38.42373], [-122.66392, 38.42421], [-122.66406, 38.42445], [-122.66427, 38.42473], [-122.66467, 38.42516]]]} | Restricted Access 2 | 29799 | Bennett Valley Municipal Golf Course | 33093 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 150.922 | Bennett Valley Municipal GC | 0 | Local Recreation Area 3 | 4 | |
1509 | 1509 | 1508 | {"type": "Polygon", "coordinates": [[[-122.73461, 38.46734], [-122.7346, 38.46746], [-122.73412, 38.46747], [-122.73412, 38.46903], [-122.73393, 38.46903], [-122.73392, 38.46856], [-122.73274, 38.46856], [-122.73272, 38.46715], [-122.73363, 38.46714], [-122.73415, 38.46715], [-122.73416, 38.46733], [-122.73461, 38.46734]]]} | Open Access 1 | 10704 | Bicentennial Park | 16066 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 5.086 | Bicentennial Park | 0 | Local Park 2 | 4 | |
1506 | 1506 | 1505 | {"type": "Polygon", "coordinates": [[[-122.7493, 38.45103], [-122.74879, 38.45105], [-122.74793, 38.45105], [-122.74799, 38.45086], [-122.74798, 38.45076], [-122.74856, 38.45078], [-122.74855, 38.45051], [-122.74885, 38.45051], [-122.74889, 38.45078], [-122.74929, 38.45078], [-122.7493, 38.45103]]]} | Open Access 1 | 10676 | Brendon Park | 16349 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 1.071 | Brendon Park | 0 | Local Park 2 | 4 | |
6597 | 6597 | 6596 | {"type": "MultiPolygon", "coordinates": [[[[-122.81587, 38.40123], [-122.81272, 38.40264], [-122.81266, 38.4026], [-122.81259, 38.40252], [-122.81251, 38.40232], [-122.8125, 38.40212], [-122.81253, 38.40196], [-122.81251, 38.40187], [-122.81245, 38.40185], [-122.81236, 38.40191], [-122.81224, 38.40206], [-122.81216, 38.4022], [-122.81215, 38.40227], [-122.8122, 38.40247], [-122.81207, 38.40279], [-122.81206, 38.40286], [-122.8121, 38.40292], [-122.80774, 38.40488], [-122.80551, 38.40586], [-122.80424, 38.40644], [-122.80102, 38.40784], [-122.8008, 38.40792], [-122.80001, 38.40832], [-122.79906, 38.40885], [-122.79838, 38.40919], [-122.79601, 38.41007], [-122.79446, 38.41071], [-122.79431, 38.4105], [-122.7948, 38.41031], [-122.79481, 38.4103], [-122.79469, 38.41013], [-122.79451, 38.41029], [-122.79424, 38.4104], [-122.79317, 38.40885], [-122.79019, 38.40445], [-122.79012, 38.40432], [-122.78868, 38.40221], [-122.7934, 38.40115], [-122.81277, 38.39668], [-122.81331, 38.39672], [-122.81342, 38.39753], [-122.81363, 38.39754], [-122.81382, 38.39773], [-122.81484, 38.39865], [-122.81524, 38.39907], [-122.8155, 38.39927], [-122.8156, 38.39953], [-122.81568, 38.40008], [-122.81565, 38.40089], [-122.81569, 38.40107], [-122.81573, 38.40118], [-122.81584, 38.40118], [-122.81587, 38.40123]], [[-122.79167, 38.40561], [-122.7905, 38.40387], [-122.79017, 38.40335], [-122.79015, 38.40335], [-122.79016, 38.40341], [-122.79022, 38.40352], [-122.79161, 38.40558], [-122.79166, 38.40564], [-122.79167, 38.40561]], [[-122.79449, 38.40986], [-122.7939, 38.40892], [-122.79355, 38.40842], [-122.7932, 38.40791], [-122.79289, 38.40741], [-122.79257, 38.40696], [-122.79309, 38.40795], [-122.79429, 38.41005], [-122.7943, 38.41005], [-122.79449, 38.40986]]], [[[-122.81641, 38.40121], [-122.81554, 38.4016], [-122.81554, 38.40315], [-122.81577, 38.40353], [-122.8131, 38.40439], [-122.80605, 38.40685], [-122.79987, 38.40907], [-122.79972, 38.40883], [-122.80116, 38.40807], [-122.80147, 38.40794], [-122.80163, 38.40819], [-122.80555, 38.4068], [-122.80919, 38.40545], [-122.81179, 38.40453], [-122.81179, 38.40451], [-122.81153, 38.40448], [-122.81074, 38.40427], [-122.81033, 38.40411], [-122.81012, 38.40399], [-122.81108, 38.40358], [-122.81322, 38.40262], [-122.81613, 38.40122], [-122.81641, 38.40121]]]]} | No Public Access 3 | 4034 | Brown Farm | 16443 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 468.322 | Brown Farm | None 532 | |||
1514 | 1514 | 1513 | {"type": "Polygon", "coordinates": [[[-122.68198, 38.46239], [-122.68133, 38.4633], [-122.68079, 38.46269], [-122.68076, 38.46258], [-122.68051, 38.46228], [-122.68082, 38.46212], [-122.68198, 38.46239]]]} | Open Access 1 | 10806 | Brush Creek Park | 16453 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 2.058 | Brush Creek Park | 0 | Local Park 2 | 4 | |
12755 | 12755 | 12754 | {"type": "Polygon", "coordinates": [[[-122.71212, 38.43656], [-122.7117, 38.43671], [-122.71147, 38.43682], [-122.71142, 38.43649], [-122.71151, 38.43656], [-122.71162, 38.43657], [-122.71167, 38.43655], [-122.71171, 38.43652], [-122.71173, 38.43645], [-122.71168, 38.43638], [-122.71161, 38.43636], [-122.71132, 38.43638], [-122.71122, 38.43594], [-122.71127, 38.43592], [-122.7112, 38.43553], [-122.71192, 38.43544], [-122.7121, 38.43627], [-122.71212, 38.43656]]]} | Open Access 1 | 29786 | Burbank Home & Gardens | 16508 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 2.036 | Burbank Home & Gardens | 0 | Local Park 2 | 4 | |
14487 | 14487 | 14486 | {"type": "Polygon", "coordinates": [[[-122.71421, 38.43614], [-122.71396, 38.4362], [-122.71382, 38.43581], [-122.71408, 38.43575], [-122.71421, 38.43614]]]} | Open Access 1 | 48271 | Church of One Tree | 32825 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | https://srcity.org/633/Church-of-One-Tree | Sonoma 16 | 0.253 | Church of One Tree | None 1234 | ||
7922 | 7922 | 7921 | {"type": "Polygon", "coordinates": [[[-122.74875, 38.47854], [-122.74847, 38.4785], [-122.74774, 38.47848], [-122.74764, 38.47838], [-122.74756, 38.47836], [-122.74744, 38.47839], [-122.74717, 38.47833], [-122.74716, 38.47697], [-122.74722, 38.47692], [-122.7478, 38.47691], [-122.74855, 38.47695], [-122.74864, 38.47728], [-122.74879, 38.47755], [-122.74887, 38.47785], [-122.74887, 38.47811], [-122.74883, 38.47835], [-122.74875, 38.47854]]]} | Open Access 1 | 10695 | Coffey Park | 17476 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 5.869 | Coffey Park | 0 | Local Park 2 | 4 | |
4937 | 4937 | 4936 | {"type": "Polygon", "coordinates": [[[-122.70759, 38.41914], [-122.70759, 38.41914], [-122.70755, 38.42031], [-122.70739, 38.42027], [-122.70713, 38.42014], [-122.70689, 38.41994], [-122.70666, 38.41953], [-122.70667, 38.41945], [-122.7068, 38.41934], [-122.70705, 38.41921], [-122.70739, 38.41913], [-122.70759, 38.41914]]]} | Open Access 1 | 10522 | Colgan Creek Park | 17495 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 1.808 | Colgan Creek Park | 0 | Local Park 2 | 4 | |
3337 | 3337 | 3336 | {"type": "Polygon", "coordinates": [[[-122.727, 38.40276], [-122.72699, 38.40298], [-122.72678, 38.40342], [-122.72676, 38.40361], [-122.7267, 38.40366], [-122.72629, 38.40366], [-122.72613, 38.40368], [-122.72613, 38.40277], [-122.727, 38.40276]]]} | Open Access 1 | 29791 | Colgan Creek Park and Preserve | 17496 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 1.602 | Colgan Creek Park and Preserve | 0 | Local Conservation Area 4 | 2 | |
5634 | 5634 | 5633 | {"type": "Polygon", "coordinates": [[[-122.70518, 38.4452], [-122.70488, 38.44513], [-122.70485, 38.44509], [-122.70485, 38.44504], [-122.70498, 38.44494], [-122.70518, 38.4452]]]} | Open Access 1 | 29789 | College Triangle Park | 17513 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 0.094 | College Triangle Park | 0 | Local Park 2 | 4 | |
11383 | 11383 | 11382 | {"type": "Polygon", "coordinates": [[[-122.74784, 38.42357], [-122.74779, 38.42358], [-122.74773, 38.42348], [-122.74765, 38.42339], [-122.74745, 38.42324], [-122.74732, 38.42319], [-122.7472, 38.42314], [-122.74692, 38.42311], [-122.74678, 38.42311], [-122.74658, 38.42315], [-122.74658, 38.42303], [-122.74772, 38.42294], [-122.74777, 38.42298], [-122.74784, 38.42357]]]} | Open Access 1 | 28192 | Cook Park | 17617 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 0.672 | Cook Park | 0 | Local Park 2 | 4 | |
5635 | 5635 | 5634 | {"type": "Polygon", "coordinates": [[[-122.66692, 38.43193], [-122.66671, 38.43182], [-122.66654, 38.43177], [-122.66633, 38.43194], [-122.66629, 38.43208], [-122.66588, 38.43202], [-122.66588, 38.432], [-122.66552, 38.43187], [-122.66457, 38.43138], [-122.66443, 38.43128], [-122.66431, 38.43116], [-122.66448, 38.43109], [-122.66447, 38.43084], [-122.66505, 38.43084], [-122.66505, 38.43086], [-122.66692, 38.43176], [-122.66692, 38.43193]]]} | Open Access 1 | 29790 | Creekside Park | 17780 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 3.518 | Creekside Park | 0 | Local Park 2 | 4 | |
14485 | 14485 | 14484 | {"type": "Polygon", "coordinates": [[[-122.69406, 38.42745], [-122.69385, 38.42747], [-122.69367, 38.42746], [-122.69322, 38.42733], [-122.69295, 38.42728], [-122.69276, 38.42728], [-122.69252, 38.42729], [-122.6925, 38.42728], [-122.69245, 38.42715], [-122.69226, 38.4268], [-122.6925, 38.4267], [-122.69262, 38.42662], [-122.69274, 38.42651], [-122.6928, 38.42637], [-122.69306, 38.42644], [-122.69312, 38.42649], [-122.69314, 38.42658], [-122.69322, 38.42669], [-122.69329, 38.42675], [-122.69343, 38.42681], [-122.69351, 38.42687], [-122.69368, 38.42704], [-122.69378, 38.42716], [-122.69384, 38.42728], [-122.694, 38.42736], [-122.69406, 38.42745]]]} | Open Access 1 | 48269 | Dauenhauer Park | 32822 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | https://srcity.org/Facilities/Facility/Details/Dauenhauer-Park-59 | Sonoma 16 | 2.291 | Dauenhauer 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]);