units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
23 rows where ACCESS_TYP = 1, COUNTY = 16 and MNG_AGENCY = 313
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP
DES_TP 4
- Local Park 16
- Local Recreation Area 5
- None 1
- None 1
MNG_AGENCY 1
- Rohnert Park, City of · 23 ✖
ACCESS_TYP 1
- Open Access · 23 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1104 | 1104 | 1103 | {"type": "Polygon", "coordinates": [[[-122.69418, 38.3653], [-122.69389, 38.36545], [-122.69385, 38.3655], [-122.69408, 38.36577], [-122.69408, 38.36583], [-122.69319, 38.36637], [-122.69305, 38.36658], [-122.6928, 38.36729], [-122.69185, 38.36717], [-122.69074, 38.36727], [-122.6906, 38.36705], [-122.69092, 38.36689], [-122.69111, 38.36677], [-122.6913, 38.36662], [-122.69146, 38.36645], [-122.69158, 38.36631], [-122.69174, 38.36602], [-122.69184, 38.3657], [-122.69233, 38.36574], [-122.69238, 38.36572], [-122.69351, 38.36483], [-122.69418, 38.3653]]]} | Open Access 1 | 7057 | Honeybee Park | 20068 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 9.109 | Honeybee Park | 1962 | Local Park 2 | 4 | |
1206 | 1206 | 1205 | {"type": "Polygon", "coordinates": [[[-122.69481, 38.34006], [-122.6948, 38.3401], [-122.69443, 38.34011], [-122.69437, 38.34025], [-122.69369, 38.33982], [-122.69282, 38.33935], [-122.6926, 38.33958], [-122.6919, 38.33919], [-122.69186, 38.33914], [-122.69191, 38.33898], [-122.69192, 38.3389], [-122.69229, 38.3389], [-122.69228, 38.33872], [-122.69224, 38.33849], [-122.69215, 38.33812], [-122.69255, 38.3382], [-122.69262, 38.33827], [-122.69308, 38.33902], [-122.6931, 38.3391], [-122.6932, 38.33916], [-122.69347, 38.33943], [-122.69359, 38.33934], [-122.69379, 38.33956], [-122.69374, 38.33961], [-122.69373, 38.33968], [-122.69374, 38.33971], [-122.69379, 38.33976], [-122.6939, 38.3398], [-122.69422, 38.34006], [-122.69434, 38.34], [-122.69441, 38.34003], [-122.69481, 38.34006]]]} | Open Access 1 | 8435 | Caterpillar Park | 16973 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 3.241 | Caterpillar Park | 1962 | Local Park 2 | 4 | |
1207 | 1207 | 1206 | {"type": "Polygon", "coordinates": [[[-122.70189, 38.33494], [-122.70176, 38.3354], [-122.70189, 38.33561], [-122.70048, 38.33619], [-122.7005, 38.33624], [-122.69917, 38.33674], [-122.69927, 38.33693], [-122.69936, 38.3369], [-122.69964, 38.33736], [-122.69877, 38.33769], [-122.69843, 38.33712], [-122.69844, 38.33707], [-122.69859, 38.33701], [-122.69875, 38.33689], [-122.69884, 38.3368], [-122.69893, 38.33661], [-122.69894, 38.33646], [-122.69891, 38.33637], [-122.69885, 38.33625], [-122.69866, 38.33595], [-122.70127, 38.33495], [-122.70152, 38.33476], [-122.70176, 38.3349], [-122.70189, 38.33494]]]} | Open Access 1 | 8446 | Benicia Park | 16012 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 8.436 | Benicia Park | 1962 | Local Park 2 | 4 | |
1377 | 1377 | 1376 | {"type": "Polygon", "coordinates": [[[-122.68811, 38.34604], [-122.6881, 38.34708], [-122.68795, 38.34709], [-122.68794, 38.34737], [-122.68766, 38.34739], [-122.68746, 38.34744], [-122.68726, 38.34753], [-122.68714, 38.34759], [-122.6865, 38.34808], [-122.68621, 38.34821], [-122.68598, 38.34827], [-122.68572, 38.34827], [-122.68566, 38.34823], [-122.68565, 38.3482], [-122.68565, 38.34599], [-122.68568, 38.34595], [-122.68572, 38.34593], [-122.68686, 38.34592], [-122.68775, 38.34599], [-122.68811, 38.34604]]]} | Open Access 1 | 8394 | Sunrise Park | 26026 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 10.821 | Sunrise Park | 1962 | Local Park 2 | 4 | |
1379 | 1379 | 1378 | {"type": "Polygon", "coordinates": [[[-122.69158, 38.34574], [-122.69136, 38.34566], [-122.69118, 38.34562], [-122.69114, 38.34559], [-122.69112, 38.34555], [-122.69118, 38.34527], [-122.69157, 38.34527], [-122.69161, 38.34561], [-122.69161, 38.34569], [-122.69158, 38.34574]]]} | Open Access 1 | 8405 | San Simeon Park | 24993 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 0.422 | San Simeon Park | 1962 | Local Park 2 | 4 | |
1381 | 1381 | 1380 | {"type": "Polygon", "coordinates": [[[-122.69368, 38.34124], [-122.69329, 38.3419], [-122.69329, 38.3423], [-122.69148, 38.34232], [-122.69146, 38.34161], [-122.69155, 38.34158], [-122.6916, 38.34155], [-122.6924, 38.34064], [-122.69295, 38.34094], [-122.69322, 38.34106], [-122.69368, 38.34124]]]} | Open Access 1 | 8416 | Colegio Vista Park | 17489 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 5.985 | Colegio Vista Park | 1962 | Local Park 2 | 4 | |
1382 | 1382 | 1381 | {"type": "Polygon", "coordinates": [[[-122.70788, 38.34198], [-122.70682, 38.34199], [-122.70676, 38.34111], [-122.70675, 38.34001], [-122.70784, 38.34001], [-122.70788, 38.34198]]]} | Open Access 1 | 8424 | Alicia Park | 15365 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 5.133 | Alicia Park | 1962 | Local Park 2 | 4 | |
3215 | 3215 | 3214 | {"type": "Polygon", "coordinates": [[[-122.68779, 38.33818], [-122.68742, 38.3387], [-122.68736, 38.33868], [-122.6872, 38.33842], [-122.68741, 38.33811], [-122.68779, 38.33818]]]} | Open Access 1 | 28194 | Cielo Mini-park | 17254 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 0.428 | Cielo Mini-park | None 264 | |||
3216 | 3216 | 3215 | {"type": "Polygon", "coordinates": [[[-122.69706, 38.34239], [-122.69676, 38.3424], [-122.69675, 38.34203], [-122.69679, 38.34203], [-122.69684, 38.34205], [-122.69706, 38.34239]]]} | Open Access 1 | 28195 | Carlita Circle Tot Lot | 16858 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 0.163 | Carlita Circle Tot Lot | 0 | Local Recreation Area 3 | 4 | |
3217 | 3217 | 3216 | {"type": "Polygon", "coordinates": [[[-122.69549, 38.34679], [-122.69543, 38.34722], [-122.69517, 38.34718], [-122.69523, 38.34676], [-122.69549, 38.34679]]]} | Open Access 1 | 28197 | Civic Center Tot Lot | 17370 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 0.273 | Civic Ctr. Tot Lot | 0 | Local Recreation Area 3 | 4 | |
5365 | 5365 | 5364 | {"type": "Polygon", "coordinates": [[[-122.69201, 38.3549], [-122.69201, 38.35508], [-122.69198, 38.35537], [-122.69193, 38.35554], [-122.69184, 38.35575], [-122.69143, 38.35644], [-122.69128, 38.35641], [-122.68961, 38.35644], [-122.68958, 38.35602], [-122.68958, 38.35507], [-122.68968, 38.35482], [-122.68984, 38.35459], [-122.69002, 38.35468], [-122.69015, 38.35472], [-122.69017, 38.35481], [-122.69025, 38.35488], [-122.69031, 38.35489], [-122.69037, 38.35487], [-122.69049, 38.35482], [-122.69193, 38.35482], [-122.69201, 38.3549]]]} | Open Access 1 | 8373 | Eagle Park | 18342 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 8.741 | Eagle Park | 1962 | Local Park 2 | 4 | |
5388 | 5388 | 5387 | {"type": "Polygon", "coordinates": [[[-122.70016, 38.35527], [-122.69945, 38.35534], [-122.69945, 38.35567], [-122.69925, 38.35569], [-122.69905, 38.35569], [-122.69895, 38.35569], [-122.69871, 38.35562], [-122.69837, 38.35545], [-122.69791, 38.35528], [-122.69806, 38.35499], [-122.69824, 38.35472], [-122.69825, 38.35464], [-122.69832, 38.35452], [-122.69839, 38.35444], [-122.69863, 38.35376], [-122.69871, 38.35378], [-122.69901, 38.35369], [-122.69912, 38.35376], [-122.69927, 38.35378], [-122.69966, 38.35387], [-122.69978, 38.35417], [-122.69996, 38.35448], [-122.69994, 38.35463], [-122.70002, 38.35476], [-122.69995, 38.35482], [-122.69994, 38.3549], [-122.70001, 38.35498], [-122.70009, 38.35502], [-122.70008, 38.35511], [-122.70016, 38.35527]]]} | Open Access 1 | 8383 | Dorotea Park | 18221 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 6.845 | Dorotea Park | 1962 | Local Park 2 | 4 | |
5389 | 5389 | 5388 | {"type": "Polygon", "coordinates": [[[-122.69406, 38.32394], [-122.69184, 38.32478], [-122.69137, 38.32401], [-122.69294, 38.32344], [-122.69304, 38.32338], [-122.69314, 38.32329], [-122.6933, 38.32325], [-122.69365, 38.32326], [-122.69406, 38.32394]]]} | Open Access 1 | 8496 | Ladybug Park | 20827 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 5.032 | Ladybug Park | 1962 | Local Park 2 | 4 | |
7511 | 7511 | 7510 | {"type": "Polygon", "coordinates": [[[-122.68194, 38.36972], [-122.68116, 38.36973], [-122.68117, 38.37063], [-122.68002, 38.37064], [-122.67995, 38.37062], [-122.67993, 38.37059], [-122.67994, 38.36792], [-122.67996, 38.36787], [-122.68001, 38.36785], [-122.68031, 38.36782], [-122.68053, 38.36776], [-122.68102, 38.36756], [-122.68128, 38.36748], [-122.68157, 38.36743], [-122.6819, 38.36741], [-122.68193, 38.3693], [-122.68194, 38.36937], [-122.68199, 38.36948], [-122.68198, 38.3695], [-122.68193, 38.36952], [-122.68194, 38.36972]]]} | Open Access 1 | 7045 | Golis Park | 19386 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 12.688 | Golis Park | 1962 | Local Park 2 | 4 | |
7762 | 7762 | 7761 | {"type": "Polygon", "coordinates": [[[-122.68283, 38.33783], [-122.68273, 38.33791], [-122.68222, 38.33795], [-122.68211, 38.33788], [-122.68206, 38.33754], [-122.68184, 38.33688], [-122.68179, 38.33666], [-122.68178, 38.33633], [-122.68183, 38.33628], [-122.68196, 38.33624], [-122.68244, 38.33624], [-122.68244, 38.33656], [-122.68249, 38.33661], [-122.68244, 38.33667], [-122.68243, 38.33673], [-122.68247, 38.3368], [-122.6826, 38.33689], [-122.6827, 38.33715], [-122.68279, 38.33749], [-122.68283, 38.33783]]]} | Open Access 1 | 8455 | Rainbow Park | 24090 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 2.874 | Rainbow Park | 1962 | Local Park 2 | 4 | |
7765 | 7765 | 7764 | {"type": "Polygon", "coordinates": [[[-122.6821, 38.33061], [-122.6821, 38.33102], [-122.68208, 38.33113], [-122.68194, 38.33135], [-122.68174, 38.33153], [-122.68168, 38.33162], [-122.68157, 38.33183], [-122.68154, 38.33206], [-122.68144, 38.33214], [-122.677, 38.33216], [-122.67668, 38.33221], [-122.67656, 38.33217], [-122.67654, 38.33211], [-122.67642, 38.3318], [-122.67635, 38.33147], [-122.67634, 38.33107], [-122.67642, 38.331], [-122.67968, 38.33097], [-122.6798, 38.33099], [-122.67989, 38.331], [-122.67996, 38.33096], [-122.67998, 38.33091], [-122.67995, 38.33077], [-122.67994, 38.33029], [-122.6812, 38.33029], [-122.68121, 38.33054], [-122.68152, 38.33054], [-122.68153, 38.33061], [-122.6821, 38.33061]]]} | Open Access 1 | 8478 | Magnolia Park | 21681 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 18.043 | Magnolia Park | 1962 | Local Park 2 | 4 | |
11108 | 11108 | 11107 | {"type": "Polygon", "coordinates": [[[-122.6879, 38.32193], [-122.6879, 38.32224], [-122.6877, 38.32225], [-122.6877, 38.32193], [-122.6879, 38.32193]]]} | Open Access 1 | 28203 | Lilac Way Tot Lot | 21233 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 0.156 | Lilac Way Tot Lot | 0 | Local Recreation Area 3 | 4 | |
11556 | 11556 | 11555 | {"type": "Polygon", "coordinates": [[[-122.71072, 38.36465], [-122.71067, 38.36468], [-122.71069, 38.36478], [-122.71065, 38.36488], [-122.71048, 38.36503], [-122.71044, 38.36511], [-122.71043, 38.3652], [-122.71024, 38.36524], [-122.71015, 38.36529], [-122.70954, 38.36529], [-122.70951, 38.36446], [-122.70998, 38.36444], [-122.70998, 38.36434], [-122.7105, 38.3643], [-122.71052, 38.36438], [-122.71056, 38.36444], [-122.71072, 38.36465]]]} | Open Access 1 | 23643 | Roberts Lake Park | 24494 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 2.239 | Roberts Lake Park | 0 | Local Park 2 | 4 | |
12468 | 12468 | 12467 | {"type": "Polygon", "coordinates": [[[-122.68291, 38.34386], [-122.68267, 38.34386], [-122.68266, 38.34356], [-122.6829, 38.34357], [-122.68291, 38.34386]]]} | Open Access 1 | 28196 | Foot Hills Mini Park / Jasmine Tot Lot | 18974 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 0.171 | Foot Hills MP / Jasmine Tot Lot | 0 | Local Recreation Area 3 | 4 | |
12477 | 12477 | 12476 | {"type": "Polygon", "coordinates": [[[-122.6955, 38.35083], [-122.6955, 38.35097], [-122.69511, 38.35097], [-122.69472, 38.35084], [-122.6955, 38.35083]]]} | Open Access 1 | 28198 | Hinebaugh Creek Park | 20001 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 0.195 | Hinebaugh Creek 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]);