units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
83 rows where MNG_AGENCY = 29 sorted by map
This data as json, copyable, CSV (advanced)
DES_TP 11
- Local Park 52
- Local Recreation Area 2
- Local Conservation Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency 63
MNG_AGENCY 1
- Santa Rosa, City of · 63 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 | |
9438 | 9438 | 9437 | {"type": "Polygon", "coordinates": [[[-122.69985, 38.43896], [-122.69973, 38.43922], [-122.69957, 38.43929], [-122.69935, 38.43966], [-122.69914, 38.43967], [-122.69902, 38.43988], [-122.69885, 38.43999], [-122.69873, 38.43998], [-122.69789, 38.44012], [-122.69763, 38.44002], [-122.69723, 38.44004], [-122.69707, 38.44015], [-122.69663, 38.44035], [-122.69639, 38.44033], [-122.69625, 38.44048], [-122.69587, 38.44045], [-122.69574, 38.44049], [-122.69535, 38.44019], [-122.69525, 38.44048], [-122.69476, 38.44073], [-122.69456, 38.44078], [-122.6943, 38.44094], [-122.69388, 38.44108], [-122.69413, 38.44091], [-122.69326, 38.44], [-122.69282, 38.43949], [-122.69287, 38.43943], [-122.69297, 38.43927], [-122.69313, 38.43917], [-122.69334, 38.43912], [-122.69332, 38.43909], [-122.69351, 38.43888], [-122.69374, 38.43866], [-122.69372, 38.43861], [-122.6941, 38.43834], [-122.69447, 38.43846], [-122.69494, 38.43873], [-122.69546, 38.43892], [-122.69586, 38.43913], [-122.69611, 38.43929], [-122.6965, 38.43937], [-122.69668, 38.43929], [-122.69683, 38.4391], [-122.6971, 38.43881], [-122.69764, 38.43904], [-122.69809, 38.43902], [-122.69859, 38.43876], [-122.69924, 38.43896], [-122.69985, 38.43896]]]} | Open Access 1 | 15780 | Doyle Park | 18260 | 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 | 21.595 | Doyle 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 | |
1325 | 1325 | 1324 | {"type": "Polygon", "coordinates": [[[-122.70256, 38.47544], [-122.70255, 38.47547], [-122.70224, 38.47541], [-122.70162, 38.47624], [-122.70157, 38.47671], [-122.7013, 38.47657], [-122.70121, 38.4765], [-122.70093, 38.47617], [-122.70076, 38.47599], [-122.70056, 38.47583], [-122.69975, 38.47539], [-122.6998, 38.47531], [-122.69915, 38.47498], [-122.69895, 38.47484], [-122.69885, 38.47467], [-122.70244, 38.47464], [-122.7023, 38.47517], [-122.70221, 38.47536], [-122.70256, 38.47544]]]} | Open Access 1 | 10821 | Hidden Valley Park | 19920 | 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 | 8.794 | Hidden Valley Park | 0 | Local Park 2 | 4 | |
1502 | 1502 | 1501 | {"type": "Polygon", "coordinates": [[[-122.70489, 38.42844], [-122.70386, 38.4288], [-122.7029, 38.42713], [-122.70284, 38.42692], [-122.70304, 38.4268], [-122.70316, 38.42678], [-122.7032, 38.42675], [-122.70329, 38.42672], [-122.70344, 38.42671], [-122.70354, 38.42665], [-122.70377, 38.42657], [-122.70384, 38.42664], [-122.70384, 38.42669], [-122.70397, 38.42686], [-122.70489, 38.42844]]]} | Open Access 1 | 10533 | Martin Luther King Park | 21919 | 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.524 | Martin Luther King 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 | |
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 | |
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 | |
7935 | 7935 | 7934 | {"type": "Polygon", "coordinates": [[[-122.70955, 38.4434], [-122.70874, 38.44377], [-122.70831, 38.44322], [-122.70831, 38.44319], [-122.70912, 38.4428], [-122.70955, 38.4434]]]} | Open Access 1 | 10757 | Fremont Park | 19102 | 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.548 | Fremont Park | 2000 | 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 | |
5235 | 5235 | 5234 | {"type": "Polygon", "coordinates": [[[-122.70989, 38.41101], [-122.70989, 38.41114], [-122.70987, 38.41123], [-122.70984, 38.41123], [-122.70975, 38.41126], [-122.70879, 38.41127], [-122.70869, 38.41121], [-122.7087, 38.41106], [-122.70867, 38.41101], [-122.70861, 38.41098], [-122.70854, 38.41096], [-122.70844, 38.41098], [-122.70797, 38.41098], [-122.70789, 38.41091], [-122.70789, 38.41085], [-122.70785, 38.41077], [-122.70765, 38.41056], [-122.70764, 38.41052], [-122.70767, 38.41046], [-122.70773, 38.41044], [-122.70774, 38.41046], [-122.70896, 38.41046], [-122.70917, 38.41045], [-122.70938, 38.41041], [-122.70948, 38.41044], [-122.70962, 38.41064], [-122.70979, 38.4108], [-122.70986, 38.41091], [-122.70989, 38.41101]]]} | Open Access 1 | 48077 | Harvest Park | 32579 | 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/Harvest-Park-72 | Sonoma 16 | 3.195 | Harvest 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 | |
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 | |
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 | |
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 | |||
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 | |
6787 | 6787 | 6786 | {"type": "Polygon", "coordinates": [[[-122.71291, 38.46188], [-122.71241, 38.46199], [-122.71217, 38.46155], [-122.7115, 38.46172], [-122.70972, 38.46007], [-122.70965, 38.45995], [-122.71273, 38.45904], [-122.71291, 38.46188]]]} | Open Access 1 | 5286 | Franklin Park | 19066 | 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 | 13.313 | Franklin 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 | |
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 |
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]);