units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
25 rows where MNG_AG_TYP = 2 and YR_EST = 1962
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_NAME, MNG_AG_ID
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 | |
1834 | 1834 | 1833 | {"type": "Polygon", "coordinates": [[[-122.29139, 37.56829], [-122.29135, 37.56831], [-122.2913, 37.56829], [-122.29123, 37.56825], [-122.29109, 37.56813], [-122.29095, 37.56795], [-122.29089, 37.56778], [-122.29092, 37.56774], [-122.29111, 37.5678], [-122.29127, 37.56788], [-122.2914, 37.568], [-122.29143, 37.56813], [-122.29141, 37.56827], [-122.29139, 37.56829]]]} | Open Access 1 | 14019 | Marina Lagoon Wildlife Island | 21829 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 0.388 | Marina Lagoon Wildlife Island | 1962 | Local Conservation Area 4 | 2 | |
1841 | 1841 | 1840 | {"type": "Polygon", "coordinates": [[[-122.29381, 37.54598], [-122.29325, 37.54661], [-122.29319, 37.54657], [-122.29232, 37.54575], [-122.29336, 37.54507], [-122.2935, 37.54518], [-122.29315, 37.5456], [-122.29381, 37.54598]]]} | Open Access 1 | 14077 | Bay Meadows West | 15876 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 2.436 | Bay Meadows West | 1962 | None 146 | ||
1842 | 1842 | 1841 | {"type": "Polygon", "coordinates": [[[-122.29185, 37.54671], [-122.29236, 37.54722], [-122.29185, 37.54752], [-122.29115, 37.5467], [-122.29145, 37.5465], [-122.2914, 37.54642], [-122.29154, 37.54633], [-122.29159, 37.54639], [-122.29155, 37.54645], [-122.29153, 37.54651], [-122.29155, 37.54658], [-122.29158, 37.54664], [-122.29164, 37.54668], [-122.29171, 37.54671], [-122.29185, 37.54671]]]} | Open Access 1 | 14079 | Bay Meadows East | 15873 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 1.371 | Bay Meadows East | 1962 | None 147 | ||
2742 | 2742 | 2741 | {"type": "Polygon", "coordinates": [[[-121.85257, 37.34148], [-121.84776, 37.34453], [-121.84758, 37.34434], [-121.8473, 37.34393], [-121.84727, 37.34384], [-121.84727, 37.34377], [-121.84728, 37.34371], [-121.84732, 37.34362], [-121.84737, 37.34356], [-121.84804, 37.34292], [-121.8502, 37.34167], [-121.8504, 37.34158], [-121.85073, 37.34146], [-121.85108, 37.34137], [-121.85137, 37.34133], [-121.85163, 37.34134], [-121.85257, 37.34148]]]} | Open Access 1 | 18411 | P.A.L. Sportscenter | 23287 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 13.753 | P.A.L. Sportscenter | 1962 | None 227 | ||
5104 | 5104 | 5103 | {"type": "Polygon", "coordinates": [[[-122.22471, 37.47312], [-122.2232, 37.47432], [-122.22235, 37.475], [-122.22294, 37.47252], [-122.22471, 37.47312]]]} | Open Access 1 | 13961 | Union Cemetery | 26655 | 1271 | Redwood City, City of 397 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | San Mateo 15 | 5.763 | Union Cemetery | 1962 | Local Historic or Cultural Area 19 | 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 | |
6152 | 6152 | 6151 | {"type": "Polygon", "coordinates": [[[-122.26027, 37.50956], [-122.25945, 37.51013], [-122.25916, 37.51001], [-122.25916, 37.50997], [-122.25875, 37.50957], [-122.25955, 37.50895], [-122.26027, 37.50956]]]} | Open Access 1 | 14351 | Laureola Park | 21109 | 1295 | San Carlos, City of 438 | City 2 | City Agency 2 | http://www.cityofsancarlos.org/depts/pr/default.asp | City 2 | 1295 | San Carlos, City of 432 | City 2 | City Agency 2 | San Mateo 15 | 2.247 | Laureola 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 | |
8796 | 8796 | 8795 | {"type": "Polygon", "coordinates": [[[-122.3781, 37.60526], [-122.37758, 37.60546], [-122.37701, 37.60546], [-122.37638, 37.60529], [-122.3761, 37.60514], [-122.37588, 37.60499], [-122.37578, 37.60487], [-122.37554, 37.60465], [-122.37534, 37.60452], [-122.37481, 37.60411], [-122.37457, 37.60399], [-122.37435, 37.60378], [-122.37438, 37.6037], [-122.37667, 37.60469], [-122.37747, 37.60502], [-122.37771, 37.60507], [-122.3781, 37.60526]]]} | Open Access 1 | 14308 | Bay Front Park | 15872 | 1205 | Millbrae, City of 404 | City 2 | City Agency 2 | http://www.ci.millbrae.ca.us/ | City 2 | 1205 | Millbrae, City of 398 | City 2 | City Agency 2 | San Mateo 15 | 4.105 | Bay Front Park | 1962 | 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]);