superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
8 rows where ACCESS_TYP = 1, MNG_AG_TYP = 2 and YR_EST = 1975
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_WEB
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8 | 8 | 7 | {"type": "Polygon", "coordinates": [[[-122.31858, 37.50826], [-122.3184, 37.50828], [-122.31742, 37.50808], [-122.31706, 37.50821], [-122.31668, 37.50859], [-122.31616, 37.50867], [-122.31595, 37.509], [-122.31615, 37.50957], [-122.31609, 37.50994], [-122.31592, 37.50987], [-122.31551, 37.50927], [-122.31494, 37.509], [-122.31446, 37.50912], [-122.31425, 37.50958], [-122.31363, 37.50959], [-122.31324, 37.50998], [-122.313, 37.50955], [-122.30871, 37.51013], [-122.30522, 37.51002], [-122.30536, 37.50954], [-122.30537, 37.50947], [-122.30488, 37.50944], [-122.30458, 37.50929], [-122.30423, 37.50924], [-122.30341, 37.50887], [-122.30307, 37.50882], [-122.3029, 37.50882], [-122.30159, 37.50568], [-122.30093, 37.50585], [-122.30104, 37.5053], [-122.30095, 37.50489], [-122.30035, 37.50437], [-122.30004, 37.50406], [-122.29996, 37.50371], [-122.29918, 37.50395], [-122.29869, 37.50284], [-122.29859, 37.50188], [-122.2975, 37.50219], [-122.29989, 37.50765], [-122.29968, 37.50768], [-122.29967, 37.50738], [-122.29956, 37.50724], [-122.2992, 37.50739], [-122.29918, 37.50736], [-122.29951, 37.5072], [-122.29931, 37.50706], [-122.29926, 37.50688], [-122.29885, 37.50661], [-122.29855, 37.50652], [-122.29842, 37.5064], [-122.29826, 37.50634], [-122.29812, 37.50633], [-122.29772, 37.50634], [-122.2976, 37.50626], [-122.29743, 37.50638], [-122.29719, 37.50585], [-122.29725, 37.50583], [-122.29741, 37.50608], [-122.29763, 37.506], [-122.29784, 37.50588], [-122.2976, 37.50542], [-122.29742, 37.50541], [-122.29731, 37.50544], [-122.29719, 37.50545], [-122.29708, 37.50549], [-122.29721, 37.50578], [-122.29716, 37.5058], [-122.29707, 37.50568], [-122.29697, 37.50559], [-122.29705, 37.50546], [-122.29705, 37.50541], [-122.29703, 37.50537], [-122.29697, 37.50534], [-122.29689, 37.50535], [-122.29678, 37.50541], [-122.29672, 37.50527], [-122.29669, 37.50487], [-122.29693, 37.50475], [-122.29697, 37.5046], [-122.2969, 37.50442], [-122.29682, 37.50431], [-122.2967, 37.50423], [-122.2963, 37.50418], [-122.29614, 37.50428], [-122.29555, 37.50357], [-122.29595, 37.50329], [-122.29577, 37.50306], [-122.29608, 37.50311], [-122.29616, 37.50282], [-122.2959, 37.50276], [-122.29587, 37.50281], [-122.29579, 37.50279], [-122.29577, 37.50281], [-122.29547, 37.50276], [-122.29543, 37.50285], [-122.29522, 37.50267], [-122.29503, 37.50262], [-122.29488, 37.50248], [-122.29436, 37.50217], [-122.29412, 37.50241], [-122.29399, 37.50234], [-122.29435, 37.50194], [-122.29431, 37.5019], [-122.29429, 37.50157], [-122.29413, 37.50141], [-122.29399, 37.50143], [-122.29391, 37.50152], [-122.29405, 37.50178], [-122.29379, 37.50162], [-122.29336, 37.50194], [-122.2933, 37.5019], [-122.29329, 37.50189], [-122.2935, 37.50173], [-122.29341, 37.50141], [-122.2929, 37.50104], [-122.29266, 37.50118], [-122.29264, 37.50107], [-122.29265, 37.50074], [-122.29263, 37.5006], [-122.29258, 37.50049], [-122.29241, 37.5002], [-122.29229, 37.50009], [-122.2921, 37.49997], [-122.29217, 37.49971], [-122.29216, 37.49963], [-122.29212, 37.49954], [-122.29376, 37.49871], [-122.29418, 37.49827], [-122.29456, 37.49849], [-122.29479, 37.49857], [-122.29496, 37.49858], [-122.29512, 37.49857], [-122.29528, 37.49853], [-122.29544, 37.49847], [-122.29564, 37.49831], [-122.29571, 37.49822], [-122.29575, 37.49813], [-122.29531, 37.49793], [-122.29565, 37.49742], [-122.29569, 37.49739], [-122.29623, 37.49732], [-122.29632, 37.49728], [-122.2964, 37.49723], [-122.30054, 37.49991], [-122.30112, 37.4995], [-122.30192, 37.49956], [-122.30232, 37.49954], [-122.30292, 37.49923], [-122.30308, 37.49935], [-122.30323, 37.49949], [-122.30305, 37.49961], [-122.30314, 37.49982], [-122.3033, 37.5], [-122.30377, 37.5004], [-122.3043, 37.50052], [-122.30463, 37.50021], [-122.30487, 37.50027], [-122.3051, 37.50039], [-122.30441, 37.50104], [-122.30378, 37.5016], [-122.30343, 37.50136], [-122.30212, 37.50251], [-122.30247, 37.50276], [-122.30272, 37.50255], [-122.30362, 37.50252], [-122.30381, 37.50265], [-122.30343, 37.50336], [-122.30347, 37.50365], [-122.30375, 37.5037], [-122.30515, 37.5036], [-122.30543, 37.5038], [-122.30517, 37.50455], [-122.30541, 37.50467], [-122.30613, 37.5043], [-122.30659, 37.50462], [-122.30505, 37.5071], [-122.30592, 37.50792], [-122.30768, 37.50799], [-122.30923, 37.5068], [-122.30881, 37.5059], [-122.30777, 37.50541], [-122.30842, 37.5038], [-122.30856, 37.50373], [-122.30917, 37.5046], [-122.30938, 37.50456], [-122.30975, 37.50396], [-122.31054, 37.50373], [-122.3109, 37.50454], [-122.31117, 37.5047], [-122.31265, 37.50443], [-122.31302, 37.50461], [-122.31246, 37.50543], [-122.31237, 37.5075], [-122.31388, 37.50723], [-122.31738, 37.50714], [-122.31775, 37.50703], [-122.31826, 37.50792], [-122.31858, 37.50826]]]} | Open Access 1 | Water Dog Lake Canyon | http://www.belmont.gov/Home/Components/FacilityDirectory/FacilityDirectory/10/702 | 534 | 1025 | Belmont, City of 194 | City 2 | City Agency 2 | http://www.belmont.gov/city-hall/park-and-recreation | City 2 | 276.47 | Water Dog Lake Canyon | 1975 |
5745 | 5745 | 5744 | {"type": "Polygon", "coordinates": [[[-122.28792, 38.28849], [-122.28768, 38.28918], [-122.28666, 38.28895], [-122.2869, 38.28829], [-122.28792, 38.28849]]]} | Open Access 1 | Kiwanis Park | 20683 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1.783 | Kiwanis Park | 1975 | |
6367 | 6367 | 6366 | {"type": "Polygon", "coordinates": [[[-122.49163, 37.66643], [-122.49162, 37.66709], [-122.49046, 37.66708], [-122.48986, 37.66709], [-122.48952, 37.66716], [-122.48943, 37.66703], [-122.48945, 37.66693], [-122.48946, 37.66658], [-122.48976, 37.66658], [-122.48983, 37.66646], [-122.48982, 37.66623], [-122.49153, 37.66626], [-122.49153, 37.66642], [-122.49163, 37.66643]]]} | Open Access 1 | Longview Park | 21457 | 1078 | Daly City, City of 421 | City 2 | City Agency 2 | http://www.dalycity.org/ | City 2 | 4.098 | Longview Park | 1975 | |
9880 | 9880 | 9879 | {"type": "MultiPolygon", "coordinates": [[[[-122.39528, 37.59394], [-122.3894, 37.59734], [-122.38915, 37.59707], [-122.39089, 37.59607], [-122.3911, 37.59626], [-122.39164, 37.59597], [-122.39165, 37.59595], [-122.39145, 37.59575], [-122.39305, 37.59482], [-122.39471, 37.59366], [-122.39481, 37.59358], [-122.39494, 37.59351], [-122.39528, 37.59394]]], [[[-122.40184, 37.59691], [-122.40145, 37.59714], [-122.40141, 37.59713], [-122.40108, 37.59693], [-122.40089, 37.59671], [-122.40092, 37.59664], [-122.40068, 37.59652], [-122.40054, 37.59642], [-122.4005, 37.59644], [-122.40022, 37.5962], [-122.39966, 37.59584], [-122.39922, 37.59541], [-122.39908, 37.59509], [-122.39951, 37.59487], [-122.40018, 37.59558], [-122.40069, 37.59603], [-122.40076, 37.59601], [-122.40079, 37.59603], [-122.40093, 37.59596], [-122.40184, 37.59691]]], [[[-122.40762, 37.59812], [-122.40671, 37.59864], [-122.40508, 37.59828], [-122.40481, 37.59844], [-122.40388, 37.59818], [-122.4032, 37.59794], [-122.4025, 37.59763], [-122.40167, 37.59719], [-122.40196, 37.59703], [-122.40249, 37.59715], [-122.40298, 37.59737], [-122.40346, 37.59757], [-122.40377, 37.59739], [-122.4038, 37.59741], [-122.40347, 37.5976], [-122.40347, 37.59762], [-122.40434, 37.59789], [-122.40487, 37.59743], [-122.40752, 37.598], [-122.40762, 37.59812]]]]} | Open Access 1 | Spur Trail Park | 25755 | 1205 | Millbrae, City of 398 | City 2 | City Agency 2 | http://www.ci.millbrae.ca.us/ | City 2 | 18.139 | Spur Trail Park | 1975 | |
10028 | 10028 | 10027 | {"type": "Polygon", "coordinates": [[[-121.90296, 37.44503], [-121.90289, 37.44506], [-121.90284, 37.44514], [-121.90286, 37.44521], [-121.90294, 37.44527], [-121.9028, 37.44554], [-121.90282, 37.44581], [-121.90289, 37.44587], [-121.90282, 37.446], [-121.90281, 37.44623], [-121.90275, 37.44626], [-121.90226, 37.44629], [-121.90223, 37.44597], [-121.90228, 37.44594], [-121.90231, 37.44587], [-121.90226, 37.44527], [-121.9022, 37.4452], [-121.9021, 37.44518], [-121.90207, 37.4449], [-121.90157, 37.44492], [-121.90155, 37.44464], [-121.90147, 37.4446], [-121.90149, 37.44452], [-121.90145, 37.44409], [-121.90291, 37.44401], [-121.90287, 37.44427], [-121.90293, 37.44432], [-121.90289, 37.4444], [-121.90292, 37.44447], [-121.90287, 37.44451], [-121.90287, 37.44477], [-121.90296, 37.44503]]]} | Open Access 1 | Strickroth Park | 25925 | 1206 | Milpitas, City of 411 | City 2 | City Agency 2 | http://www.ci.milpitas.ca.gov/ | City 2 | 4.948 | Strickroth Park | 1975 | |
11964 | 11964 | 11963 | {"type": "Polygon", "coordinates": [[[-122.49422, 37.67986], [-122.49409, 37.68022], [-122.49374, 37.68015], [-122.49378, 37.68003], [-122.49381, 37.67984], [-122.49369, 37.67956], [-122.49403, 37.67946], [-122.49422, 37.67986]]]} | Open Access 1 | Northridge Park | 28792 | 1078 | Daly City, City of 421 | City 2 | City Agency 2 | http://www.dalycity.org/ | City 2 | 0.642 | Northridge Park | 1975 | |
12243 | 12243 | 12242 | {"type": "Polygon", "coordinates": [[[-117.24522, 32.80169], [-117.24443, 32.80186], [-117.24419, 32.8011], [-117.24499, 32.80093], [-117.24522, 32.80169]]]} | Open Access 1 | Pacific Beach Recreation Center | https://www.sandiego.gov/park-and-recreation/centers/recctr/pacificb | 33225 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1.663 | Pacific Beach Rec. Ctr. | 1975 |
13957 | 13957 | 13956 | {"type": "Polygon", "coordinates": [[[-122.17854, 37.34566], [-122.17621, 37.35241], [-122.17292, 37.35272], [-122.17289, 37.35278], [-122.17225, 37.35279], [-122.17206, 37.34613], [-122.17207, 37.34577], [-122.17854, 37.34566]]]} | Open Access 1 | Foothills Open Space Preserve | 31434 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 86.852 | Foothills OSP | 1975 |
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]);