superunits_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: MNG_AG_ID
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
1819 | 1819 | 1818 | {"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 | Bay Front Park | 15872 | 1205 | Millbrae, City of 398 | City 2 | City Agency 2 | http://www.ci.millbrae.ca.us/ | City 2 | 4.104 | Bay Front Park | 1962 | |
1820 | 1820 | 1819 | {"type": "Polygon", "coordinates": [[[-122.29236, 37.54722], [-122.29185, 37.54752], [-122.29115, 37.5467], [-122.29144, 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.54663], [-122.29164, 37.54668], [-122.29171, 37.54671], [-122.29185, 37.54671], [-122.29236, 37.54722]]]} | Open Access 1 | Bay Meadows East | 15873 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1.372 | Bay Meadows East | 1962 | |
1823 | 1823 | 1822 | {"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 | Bay Meadows West | 15876 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 2.441 | Bay Meadows West | 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 | |
2702 | 2702 | 2701 | {"type": "Polygon", "coordinates": [[[-122.44233, 37.6272], [-122.4423, 37.62756], [-122.44226, 37.62762], [-122.4421, 37.62755], [-122.44212, 37.62752], [-122.44216, 37.62718], [-122.44233, 37.6272]]]} | Open Access 1 | Catalpa Tot Lot | 16969 | 1294 | San Bruno, City of 434 | City 2 | City Agency 2 | http://www.sanbruno.ca.gov/parks_main.html | City 2 | 0.174 | Catalpa Tot Lot | 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 | |
4309 | 4309 | 4308 | {"type": "Polygon", "coordinates": [[[-122.41852, 37.63269], [-122.4172, 37.63337], [-122.4159, 37.63383], [-122.41435, 37.63404], [-122.41411, 37.63403], [-122.41415, 37.63398], [-122.41495, 37.63392], [-122.41593, 37.63353], [-122.41759, 37.63292], [-122.4185, 37.6325], [-122.41852, 37.63269]]]} | Open Access 1 | Forest Lane Park | 18996 | 1294 | San Bruno, City of 434 | City 2 | City Agency 2 | http://www.sanbruno.ca.gov/parks_main.html | City 2 | 2.178 | Forest Lane 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 | |
5685 | 5685 | 5684 | {"type": "Polygon", "coordinates": [[[-121.86436, 37.32449], [-121.86277, 37.32544], [-121.86265, 37.32553], [-121.86248, 37.32557], [-121.86223, 37.32554], [-121.86213, 37.32557], [-121.86205, 37.32555], [-121.86197, 37.32556], [-121.86167, 37.32565], [-121.86133, 37.32587], [-121.86139, 37.32606], [-121.86102, 37.32624], [-121.861, 37.32635], [-121.86093, 37.32652], [-121.861, 37.32662], [-121.86058, 37.3271], [-121.8609, 37.32761], [-121.86112, 37.32772], [-121.85953, 37.32881], [-121.85297, 37.32221], [-121.85255, 37.32176], [-121.85209, 37.32147], [-121.85155, 37.32086], [-121.85073, 37.32013], [-121.8527, 37.31876], [-121.85442, 37.31764], [-121.85452, 37.31752], [-121.85459, 37.31753], [-121.85456, 37.31756], [-121.85453, 37.31781], [-121.85598, 37.31917], [-121.85403, 37.31875], [-121.85358, 37.31878], [-121.85293, 37.31909], [-121.85295, 37.3193], [-121.85337, 37.31946], [-121.85374, 37.31951], [-121.85506, 37.31936], [-121.85577, 37.31971], [-121.85625, 37.31956], [-121.85664, 37.31937], [-121.85688, 37.31921], [-121.85731, 37.31911], [-121.85852, 37.3184], [-121.86171, 37.32174], [-121.86436, 37.32449]]]} | Open Access 1 | Kelley Park | 20576 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 164.335 | Kelley 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 | |
5948 | 5948 | 5947 | {"type": "Polygon", "coordinates": [[[-122.00293, 37.39667], [-122.00246, 37.3967], [-122.00231, 37.3969], [-122.00237, 37.39776], [-122.00214, 37.39785], [-122.00216, 37.39818], [-122.0012, 37.39819], [-122.00119, 37.39838], [-121.99922, 37.39844], [-121.99917, 37.3984], [-121.9992, 37.39835], [-121.99922, 37.39676], [-121.9993, 37.3965], [-122.00293, 37.39646], [-122.00293, 37.39667]]]} | Open Access 1 | Lakewood Park | 20990 | 1345 | Sunnyvale, City of 413 | City 2 | City Agency 2 | http://sunnyvale.ca.gov/Departments/CommunityServices/Parks.aspx | City 2 | 14.138 | Lakewood Park | 1962 | |
6055 | 6055 | 6054 | {"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 | Laureola Park | 21109 | 1295 | San Carlos, City of 432 | City 2 | City Agency 2 | http://www.cityofsancarlos.org/depts/pr/default.asp | City 2 | 2.246 | Laureola Park | 1962 | |
6529 | 6529 | 6528 | {"type": "Polygon", "coordinates": [[[-122.6821, 38.33061], [-122.6821, 38.33102], [-122.68208, 38.33113], [-122.68194, 38.33135], [-122.68175, 38.33153], [-122.68168, 38.33162], [-122.68157, 38.33183], [-122.68154, 38.33206], [-122.68144, 38.33214], [-122.67701, 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.68122, 38.33054], [-122.68152, 38.33054], [-122.68154, 38.33061], [-122.6821, 38.33061]]]} | Open Access 1 | Magnolia Park | 21681 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 18.046 | Magnolia Park | 1962 | |
6648 | 6648 | 6647 | {"type": "Polygon", "coordinates": [[[-122.2914, 37.568], [-122.29143, 37.56813], [-122.29141, 37.56827], [-122.29139, 37.56829], [-122.29135, 37.56831], [-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.29126, 37.56788], [-122.2914, 37.568]]]} | Open Access 1 | Marina Lagoon Wildlife Island | 21829 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 0.386 | Marina Lagoon Wildlife Island | 1962 | |
7833 | 7833 | 7832 | {"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 | P.A.L. Sportscenter | 23287 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 13.751 | P.A.L. Sportscenter | 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]);