superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
24 rows where MNG_AGENCY = 313 and MNG_AG_TYP = 2 sorted by YR_EST
This data as json, copyable, CSV (advanced)
Link | rowid | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2372 | 2372 | 2371 | {"type": "Polygon", "coordinates": [[[-122.70081, 38.32988], [-122.70061, 38.32996], [-122.70041, 38.32967], [-122.7006, 38.32959], [-122.70081, 38.32988]]]} | Open Access 1 | Burton Avenue Tot Lot | 16528 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 0.169 | Burton Avenue Tot Lot | ||
2629 | 2629 | 2628 | {"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 | Carlita Circle Tot Lot | 16858 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 0.163 | Carlita Circle Tot Lot | ||
2940 | 2940 | 2939 | {"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 | Cielo Mini-park | 17254 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 0.428 | Cielo Mini-park | ||
3226 | 3226 | 3225 | {"type": "Polygon", "coordinates": [[[-122.69604, 38.36128], [-122.69554, 38.36139], [-122.69524, 38.3615], [-122.69474, 38.36174], [-122.69466, 38.36174], [-122.69451, 38.36158], [-122.69443, 38.36147], [-122.69432, 38.36123], [-122.6943, 38.36111], [-122.69427, 38.36053], [-122.69432, 38.36047], [-122.6945, 38.36046], [-122.69447, 38.36059], [-122.69447, 38.36068], [-122.69453, 38.36085], [-122.6946, 38.36095], [-122.69471, 38.36104], [-122.69484, 38.36112], [-122.69497, 38.36116], [-122.69517, 38.36118], [-122.69528, 38.36118], [-122.69547, 38.36114], [-122.69564, 38.36105], [-122.69572, 38.36099], [-122.69583, 38.36084], [-122.69587, 38.36067], [-122.69587, 38.36059], [-122.69604, 38.36128]]]} | Open Access 1 | Country Club Mini Park | 17694 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 2.114 | Country Club MP | ||
4157 | 4157 | 4156 | {"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 | Hinebaugh Creek Park | 20001 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 0.195 | Hinebaugh Creek Park | ||
4284 | 4284 | 4283 | {"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 | Foot Hills Mini Park / Jasmine Tot Lot | 18974 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 0.17 | Foot Hills MP / Jasmine Tot Lot | ||
6168 | 6168 | 6167 | {"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 | Lilac Way Tot Lot | 21233 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 0.156 | Lilac Way Tot Lot | ||
6468 | 6468 | 6467 | {"type": "Polygon", "coordinates": [[[-122.68917, 38.31984], [-122.68871, 38.32012], [-122.68862, 38.31989], [-122.6885, 38.31969], [-122.68833, 38.31976], [-122.68822, 38.31988], [-122.68821, 38.31994], [-122.68813, 38.31992], [-122.68814, 38.31986], [-122.68808, 38.31967], [-122.68771, 38.31971], [-122.68776, 38.31955], [-122.68787, 38.31945], [-122.68798, 38.31932], [-122.68799, 38.31915], [-122.68789, 38.31873], [-122.68799, 38.31873], [-122.68873, 38.31982], [-122.68917, 38.31984]]]} | Open Access 1 | Lydia Court Mini-park | 21602 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1.303 | Lydia Court Mini-park | ||
8830 | 8830 | 8829 | {"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.70997, 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 | Roberts Lake Park | 24494 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 2.24 | Roberts Lake Park | ||
14606 | 14606 | 14605 | {"type": "MultiPolygon", "coordinates": [[[[-122.6975, 38.36612], [-122.69734, 38.36619], [-122.69709, 38.36634], [-122.69536, 38.36726], [-122.69449, 38.36933], [-122.69517, 38.37036], [-122.69584, 38.37134], [-122.69411, 38.37136], [-122.69245, 38.37031], [-122.6907, 38.36986], [-122.69038, 38.36872], [-122.69177, 38.36859], [-122.69286, 38.36873], [-122.69358, 38.36666], [-122.69634, 38.36528], [-122.69642, 38.36534], [-122.69653, 38.36539], [-122.69676, 38.36547], [-122.69697, 38.36557], [-122.69712, 38.3657], [-122.6975, 38.36612]]], [[[-122.70898, 38.36012], [-122.70778, 38.36135], [-122.70767, 38.36152], [-122.7071, 38.36209], [-122.70702, 38.36205], [-122.70748, 38.36157], [-122.70686, 38.36117], [-122.70628, 38.36175], [-122.70462, 38.36108], [-122.70419, 38.36097], [-122.70374, 38.36092], [-122.70328, 38.36091], [-122.6964, 38.36125], [-122.69604, 38.36128], [-122.69564, 38.35972], [-122.69545, 38.35657], [-122.69691, 38.35647], [-122.69729, 38.35804], [-122.69749, 38.36003], [-122.69883, 38.3598], [-122.69954, 38.35961], [-122.6992, 38.35623], [-122.70064, 38.35614], [-122.70132, 38.35946], [-122.70166, 38.35957], [-122.70361, 38.35947], [-122.70569, 38.358], [-122.70517, 38.35712], [-122.70522, 38.35674], [-122.70433, 38.35571], [-122.70408, 38.35529], [-122.70251, 38.35278], [-122.70262, 38.35201], [-122.70138, 38.35104], [-122.70123, 38.3508], [-122.70313, 38.35077], [-122.70898, 38.36012]]], [[[-122.70001, 38.36778], [-122.69854, 38.36776], [-122.69753, 38.36894], [-122.69828, 38.37051], [-122.69833, 38.37064], [-122.69784, 38.37126], [-122.69777, 38.3713], [-122.69774, 38.37131], [-122.69684, 38.37131], [-122.69615, 38.37029], [-122.6968, 38.37004], [-122.69645, 38.36954], [-122.69607, 38.36922], [-122.69604, 38.36805], [-122.69607, 38.36797], [-122.69626, 38.36772], [-122.69639, 38.36758], [-122.6976, 38.36693], [-122.69759, 38.36669], [-122.69761, 38.36658], [-122.69764, 38.36655], [-122.69857, 38.36607], [-122.70001, 38.36778]]], [[[-122.70675, 38.36236], [-122.70468, 38.36506], [-122.70424, 38.36526], [-122.70084, 38.36524], [-122.70082, 38.36531], [-122.69994, 38.36531], [-122.69971, 38.36554], [-122.69938, 38.36555], [-122.6991, 38.36561], [-122.69892, 38.36568], [-122.69853, 38.36588], [-122.69755, 38.36467], [-122.7001, 38.36388], [-122.70223, 38.36407], [-122.70278, 38.36381], [-122.70414, 38.363], [-122.70537, 38.36235], [-122.70572, 38.36194], [-122.70675, 38.36236]]], [[[-122.705, 38.36688], [-122.70205, 38.36782], [-122.70047, 38.36783], [-122.69937, 38.36659], [-122.70192, 38.36629], [-122.7025, 38.36599], [-122.70447, 38.366], [-122.705, 38.36688]]], [[[-122.70295, 38.35048], [-122.70097, 38.35045], [-122.6998, 38.34855], [-122.70177, 38.34858], [-122.70295, 38.35048]]], [[[-122.71201, 38.36935], [-122.71009, 38.36937], [-122.70842, 38.36762], [-122.70643, 38.36764], [-122.70528, 38.36571], [-122.70759, 38.3627], [-122.70855, 38.36309], [-122.70858, 38.36313], [-122.70859, 38.36317], [-122.70813, 38.36387], [-122.70798, 38.36383], [-122.70739, 38.3645], [-122.70635, 38.36559], [-122.70696, 38.36676], [-122.70714, 38.36692], [-122.70862, 38.36683], [-122.70863, 38.36672], [-122.70856, 38.36671], [-122.70864, 38.36569], [-122.70869, 38.36568], [-122.7087, 38.36543], [-122.70875, 38.36542], [-122.70875, 38.3653], [-122.70871, 38.36529], [-122.70872, 38.36513], [-122.70868, 38.36512], [-122.70873, 38.36441], [-122.70877, 38.36415], [-122.70945, 38.3639], [-122.70951, 38.36446], [-122.70955, 38.36528], [-122.71015, 38.36529], [-122.71024, 38.36524], [-122.71043, 38.3652], [-122.71044, 38.36511], [-122.71048, 38.36504], [-122.71064, 38.36488], [-122.71069, 38.36478], [-122.71067, 38.36468], [-122.71071, 38.36464], [-122.71056, 38.36444], [-122.71052, 38.36438], [-122.7105, 38.3643], [-122.71047, 38.36415], [-122.7105, 38.36411], [-122.71044, 38.36393], [-122.71041, 38.36364], [-122.71078, 38.36365], [-122.71095, 38.36393], [-122.71102, 38.36391], [-122.71146, 38.36462], [-122.71163, 38.36782], [-122.71174, 38.36845], [-122.71201, 38.36935]]]]} | Restricted Access 2 | Rohnert Park Municipal Golf Course | 33089 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 282.899 | Rohnert Park Municipal GC | ||
15549 | 15549 | 15548 | {"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 | Civic Center Tot Lot | 17370 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 0.273 | Civic Ctr. Tot Lot | ||
1140 | 1140 | 1139 | {"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 | Alicia Park | 15365 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 5.132 | Alicia Park | 1962 | |
1952 | 1952 | 1951 | {"type": "Polygon", "coordinates": [[[-122.70189, 38.33494], [-122.70176, 38.3354], [-122.70189, 38.33561], [-122.70049, 38.33618], [-122.7005, 38.33624], [-122.69917, 38.33674], [-122.69927, 38.33692], [-122.69936, 38.3369], [-122.69964, 38.33736], [-122.69877, 38.33769], [-122.69843, 38.33712], [-122.69844, 38.33707], [-122.69859, 38.337], [-122.69875, 38.33689], [-122.69884, 38.33679], [-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 | Benicia Park | 16012 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 8.441 | Benicia Park | 1962 | |
2706 | 2706 | 2705 | {"type": "Polygon", "coordinates": [[[-122.69481, 38.34006], [-122.6948, 38.3401], [-122.69443, 38.34012], [-122.69437, 38.34025], [-122.69369, 38.33982], [-122.69283, 38.33935], [-122.6926, 38.33958], [-122.6919, 38.33919], [-122.69186, 38.33914], [-122.69191, 38.33899], [-122.69192, 38.3389], [-122.69229, 38.33889], [-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.69346, 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.34005], [-122.69434, 38.34], [-122.69441, 38.34003], [-122.69481, 38.34006]]]} | Open Access 1 | Caterpillar Park | 16973 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 3.25 | Caterpillar Park | 1962 | |
3079 | 3079 | 3078 | {"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.69161, 38.34154], [-122.6924, 38.34064], [-122.69295, 38.34094], [-122.69322, 38.34106], [-122.69368, 38.34124]]]} | Open Access 1 | Colegio Vista Park | 17489 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 5.985 | Colegio Vista Park | 1962 | |
3664 | 3664 | 3663 | {"type": "Polygon", "coordinates": [[[-122.70016, 38.35527], [-122.69946, 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.69823, 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.69996, 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 | Dorotea Park | 18221 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 6.848 | Dorotea Park | 1962 | |
3770 | 3770 | 3769 | {"type": "Polygon", "coordinates": [[[-122.69201, 38.3549], [-122.69201, 38.35508], [-122.69198, 38.35537], [-122.69193, 38.35554], [-122.69183, 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.69001, 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 | Eagle Park | 18342 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 8.741 | Eagle Park | 1962 | |
4651 | 4651 | 4650 | {"type": "Polygon", "coordinates": [[[-122.68199, 38.36948], [-122.68193, 38.36952], [-122.68194, 38.36972], [-122.68117, 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.36929], [-122.68194, 38.36937], [-122.68199, 38.36948]]]} | Open Access 1 | Golis Park | 19386 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 12.693 | Golis Park | 1962 | |
5241 | 5241 | 5240 | {"type": "Polygon", "coordinates": [[[-122.69418, 38.3653], [-122.6939, 38.36545], [-122.69386, 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 | Honeybee Park | 20068 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 9.112 | Honeybee Park | 1962 | |
5865 | 5865 | 5864 | {"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 | Ladybug Park | 20827 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 5.032 | Ladybug Park | 1962 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);