units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
83 rows where MNG_AGENCY = 29 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, 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_TYP 2 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14486 | 14486 | 14485 | {"type": "Polygon", "coordinates": [[[-122.71198, 38.44182], [-122.71187, 38.44186], [-122.7117, 38.44163], [-122.71179, 38.44159], [-122.71198, 38.44182]]]} | Open Access 1 | 48270 | Jeju Way | 32823 | 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.075 | Jeju Way | None 1233 | |||
7926 | 7926 | 7925 | {"type": "Polygon", "coordinates": [[[-122.73678, 38.44783], [-122.73649, 38.44785], [-122.73648, 38.44771], [-122.73672, 38.44771], [-122.73677, 38.44775], [-122.73678, 38.44783]]]} | Open Access 1 | 10664 | Haydn Village Park | 19753 | 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.09 | Haydn Village Park | 0 | Local Park 2 | 4 | |
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 | |
4118 | 4118 | 4117 | {"type": "Polygon", "coordinates": [[[-122.70017, 38.45107], [-122.69985, 38.45112], [-122.69976, 38.45111], [-122.6999, 38.45099], [-122.69998, 38.45089], [-122.70003, 38.45087], [-122.70008, 38.4509], [-122.70012, 38.45099], [-122.70017, 38.45107]]]} | Open Access 1 | 48268 | Triangle Park | 32821 | 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.122 | Triangle Park | 0 | Local Park 2 | 4 | |
12756 | 12756 | 12755 | {"type": "Polygon", "coordinates": [[[-122.71297, 38.43721], [-122.7128, 38.43723], [-122.71289, 38.43736], [-122.71246, 38.4374], [-122.71245, 38.43726], [-122.71248, 38.43725], [-122.71247, 38.43715], [-122.71295, 38.43713], [-122.71297, 38.43721]]]} | Open Access 1 | 29787 | Prince Memorial Greenway | 24005 | 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.243 | Prince Memorial Greenway | 0 | Local Recreation Area 3 | 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 | ||
1492 | 1492 | 1491 | {"type": "Polygon", "coordinates": [[[-122.72142, 38.43789], [-122.72122, 38.43798], [-122.72083, 38.43747], [-122.72102, 38.43739], [-122.72142, 38.43789]]]} | Open Access 1 | 10590 | Railroad Depot Park | 32921 | 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/Railroad-Depot-Park-97 | Sonoma 16 | 0.326 | Railroad Depot Park | 0 | Local Park 2 | 4 |
1499 | 1499 | 1498 | {"type": "Polygon", "coordinates": [[[-122.71082, 38.40228], [-122.71082, 38.40279], [-122.7105, 38.40279], [-122.7105, 38.40224], [-122.71077, 38.40224], [-122.71082, 38.40228]]]} | Open Access 1 | 10510 | Red Hawk Park | 24222 | 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.419 | Red Hawk Park | 0 | Local Park 2 | 4 | |
7938 | 7938 | 7937 | {"type": "Polygon", "coordinates": [[[-122.69702, 38.44707], [-122.69666, 38.44712], [-122.69664, 38.44728], [-122.69643, 38.44733], [-122.69631, 38.4472], [-122.69599, 38.44727], [-122.69594, 38.44715], [-122.69636, 38.44706], [-122.69699, 38.44694], [-122.69702, 38.44707]]]} | Open Access 1 | 10769 | Eastside Park | 18400 | 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.419 | Eastside Park | 0 | Local Park 2 | 4 | |
7933 | 7933 | 7932 | {"type": "Polygon", "coordinates": [[[-122.7143, 38.4539], [-122.71426, 38.45392], [-122.71394, 38.45391], [-122.71397, 38.45335], [-122.7143, 38.45336], [-122.71433, 38.45338], [-122.7143, 38.4539]]]} | Open Access 1 | 10750 | Humboldt Park | 20146 | 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.482 | Humboldt Park | 0 | Local Park 2 | 4 | |
12738 | 12738 | 12737 | {"type": "Polygon", "coordinates": [[[-122.71295, 38.43713], [-122.71249, 38.43715], [-122.71244, 38.43683], [-122.71245, 38.43674], [-122.71249, 38.43672], [-122.71284, 38.43664], [-122.71295, 38.43713]]]} | Open Access 1 | 29788 | Prince Gateway Park | 24004 | 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.483 | Prince Gateway Park | 0 | Local Park 2 | 4 | |
11555 | 11555 | 11554 | {"type": "Polygon", "coordinates": [[[-122.66792, 38.46122], [-122.66782, 38.46129], [-122.66773, 38.46132], [-122.66731, 38.46157], [-122.66726, 38.46163], [-122.66714, 38.4613], [-122.66776, 38.46098], [-122.66792, 38.46122]]]} | Open Access 1 | 23641 | Trailhead Park | 26509 | 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.533 | Trailhead 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 | |
1491 | 1491 | 1490 | {"type": "Polygon", "coordinates": [[[-122.7096, 38.43788], [-122.70954, 38.43791], [-122.70929, 38.4381], [-122.70925, 38.43795], [-122.70895, 38.43799], [-122.70876, 38.43769], [-122.70873, 38.43762], [-122.70874, 38.4376], [-122.7088, 38.43759], [-122.70951, 38.4375], [-122.7096, 38.43788]]]} | Open Access 1 | 10579 | Rae Park | 24071 | 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.782 | Rae Park | 0 | Local Park 2 | 4 | |
3830 | 3830 | 3829 | {"type": "Polygon", "coordinates": [[[-122.71934, 38.43449], [-122.71922, 38.4345], [-122.71889, 38.43457], [-122.71873, 38.43463], [-122.71837, 38.43469], [-122.71826, 38.43438], [-122.7183, 38.43434], [-122.71915, 38.43414], [-122.7192, 38.43418], [-122.71929, 38.43442], [-122.71934, 38.43449]]]} | Open Access 1 | 10556 | Olive Park | 23127 | 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.851 | Olive Park | 0 | Local Park 2 | 4 | |
7934 | 7934 | 7933 | {"type": "Polygon", "coordinates": [[[-122.70898, 38.449], [-122.70895, 38.44953], [-122.70824, 38.44951], [-122.70826, 38.44898], [-122.70898, 38.449]]]} | Open Access 1 | 10752 | North Park | 22842 | 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.916 | North Park | 0 | Local Park 2 | 4 | |
1495 | 1495 | 1494 | {"type": "Polygon", "coordinates": [[[-122.72547, 38.44105], [-122.72507, 38.44108], [-122.72464, 38.44045], [-122.72539, 38.44038], [-122.72547, 38.44105]]]} | Open Access 1 | 10616 | DeTurk Park | 18123 | 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.923 | DeTurk Park | 0 | Local Park 2 | 4 | |
7222 | 7222 | 7221 | {"type": "Polygon", "coordinates": [[[-122.71034, 38.49485], [-122.71017, 38.49538], [-122.70934, 38.49527], [-122.70927, 38.49498], [-122.70966, 38.49491], [-122.71034, 38.49485]]]} | Open Access 1 | 10713 | Fir Ridge Park | 18907 | 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.975 | Fir Ridge Park | 0 | Local Park 2 | 4 | |
4895 | 4895 | 4894 | {"type": "Polygon", "coordinates": [[[-122.71147, 38.43682], [-122.71061, 38.43738], [-122.70939, 38.43825], [-122.7091, 38.43839], [-122.70903, 38.43829], [-122.70954, 38.43791], [-122.70968, 38.43784], [-122.70976, 38.43784], [-122.70988, 38.43779], [-122.71003, 38.43765], [-122.70999, 38.43739], [-122.71051, 38.43731], [-122.71145, 38.43674], [-122.71147, 38.43682]]]} | Open Access 1 | 10567 | Sonoma Avenue Park | 25606 | 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.008 | Sonoma Avenue Park | 0 | Local Park 2 | 4 | |
7941 | 7941 | 7940 | {"type": "Polygon", "coordinates": [[[-122.67197, 38.43672], [-122.67163, 38.43671], [-122.67165, 38.43646], [-122.67173, 38.43598], [-122.67152, 38.43563], [-122.67188, 38.43551], [-122.67205, 38.4358], [-122.67208, 38.43593], [-122.67208, 38.43604], [-122.67204, 38.43622], [-122.67197, 38.43672]]]} | Open Access 1 | 10783 | Matanzas Park | 21948 | 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.031 | Matanzas 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]);