units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where ACCESS_TYP = 1, MNG_AG_TYP = 4 and YR_EST = 1977
This data as json, copyable, CSV (advanced)
Suggested facets: LABEL_NAME
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1218 | 1218 | 1217 | {"type": "MultiPolygon", "coordinates": [[[[-122.1451, 37.64851], [-122.14511, 37.64897], [-122.14509, 37.64903], [-122.14501, 37.64917], [-122.14486, 37.64934], [-122.14456, 37.64957], [-122.14429, 37.64973], [-122.14412, 37.64979], [-122.14409, 37.64745], [-122.14507, 37.64744], [-122.1451, 37.64851]]], [[[-122.14586, 37.6471], [-122.14517, 37.64711], [-122.14517, 37.64682], [-122.14586, 37.64682], [-122.14586, 37.6471]]]]} | Open Access 1 | 8671 | Hayward Shoreline | 19762 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 5.421 | Hayward Shoreline | 1977 | Local Park 2 | 4 | |
9863 | 9863 | 9862 | {"type": "MultiPolygon", "coordinates": [[[[-122.15302, 37.6263], [-122.15283, 37.62659], [-122.1515, 37.6266], [-122.14838, 37.62665], [-122.14826, 37.62667], [-122.14763, 37.62687], [-122.14728, 37.62691], [-122.14546, 37.62688], [-122.14478, 37.62685], [-122.14441, 37.62681], [-122.144, 37.6268], [-122.14248, 37.62687], [-122.14139, 37.62687], [-122.14047, 37.62683], [-122.14027, 37.6268], [-122.13998, 37.62671], [-122.13982, 37.62673], [-122.13956, 37.62689], [-122.13937, 37.62323], [-122.13707, 37.62323], [-122.13704, 37.6234], [-122.13625, 37.62359], [-122.13581, 37.62359], [-122.13521, 37.62378], [-122.13519, 37.62365], [-122.13545, 37.623], [-122.13965, 37.6221], [-122.14706, 37.62481], [-122.14837, 37.62508], [-122.14973, 37.62515], [-122.1508, 37.62499], [-122.15138, 37.62484], [-122.15259, 37.62462], [-122.15302, 37.6263]]], [[[-122.14879, 37.65606], [-122.14479, 37.65609], [-122.14396, 37.65627], [-122.14392, 37.65609], [-122.14392, 37.65591], [-122.14433, 37.64981], [-122.14879, 37.65606]]], [[[-122.16185, 37.6312], [-122.16174, 37.64456], [-122.16171, 37.65587], [-122.16161, 37.65596], [-122.15072, 37.65604], [-122.15069, 37.65593], [-122.15098, 37.65355], [-122.14947, 37.65148], [-122.15252, 37.65117], [-122.15483, 37.65108], [-122.15483, 37.65097], [-122.15538, 37.65153], [-122.15604, 37.65308], [-122.15606, 37.65308], [-122.15555, 37.65077], [-122.15547, 37.65072], [-122.15521, 37.64933], [-122.15539, 37.64918], [-122.15538, 37.64917], [-122.15521, 37.64913], [-122.15538, 37.64891], [-122.15541, 37.64883], [-122.15518, 37.64882], [-122.15504, 37.64871], [-122.15489, 37.64814], [-122.15466, 37.64699], [-122.15488, 37.6468], [-122.15488, 37.64676], [-122.15469, 37.64672], [-122.1544, 37.64599], [-122.15437, 37.64555], [-122.15426, 37.64537], [-122.15389, 37.64384], [-122.1538, 37.64376], [-122.15348, 37.6423], [-122.15368, 37.64213], [-122.15367, 37.64208], [-122.15349, 37.64195], [-122.15351, 37.64192], [-122.15381, 37.64187], [-122.1539, 37.64184], [-122.15408, 37.64173], [-122.15408, 37.64167], [-122.15511, 37.64162], [-122.15521, 37.63118], [-122.16185, 37.6312]]]]} | Open Access 1 | 16897 | Hayward Shoreline | 4363 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 595.87 | Hayward Shoreline | 1977 | Local Park 2 | 4 | |
15924 | 15924 | 15923 | {"type": "Polygon", "coordinates": [[[-122.61533, 38.12598], [-122.61493, 38.1262], [-122.61439, 38.12871], [-122.61418, 38.12925], [-122.61368, 38.12995], [-122.61238, 38.13142], [-122.61171, 38.13244], [-122.6117, 38.13282], [-122.61072, 38.13467], [-122.60983, 38.13621], [-122.60916, 38.13774], [-122.60842, 38.13882], [-122.60855, 38.14775], [-122.60705, 38.1472], [-122.60106, 38.14798], [-122.59468, 38.14646], [-122.59238, 38.14593], [-122.58737, 38.14183], [-122.57955, 38.14374], [-122.57931, 38.14375], [-122.58049, 38.13628], [-122.57556, 38.13231], [-122.57611, 38.13144], [-122.57684, 38.13001], [-122.57656, 38.13005], [-122.57561, 38.12926], [-122.57403, 38.12993], [-122.57385, 38.12979], [-122.57362, 38.12964], [-122.57338, 38.12953], [-122.57316, 38.12946], [-122.57357, 38.12903], [-122.57352, 38.12893], [-122.57348, 38.12888], [-122.57332, 38.12879], [-122.57348, 38.1286], [-122.57358, 38.1284], [-122.57404, 38.12851], [-122.57426, 38.12793], [-122.57426, 38.1279], [-122.57429, 38.1278], [-122.57498, 38.12784], [-122.57519, 38.12789], [-122.5755, 38.12788], [-122.57568, 38.12791], [-122.57623, 38.12787], [-122.57654, 38.12777], [-122.57636, 38.12744], [-122.57649, 38.12739], [-122.57668, 38.12763], [-122.57701, 38.12789], [-122.57752, 38.12753], [-122.57737, 38.12714], [-122.57751, 38.12697], [-122.57771, 38.12677], [-122.57871, 38.12653], [-122.57873, 38.12635], [-122.57836, 38.12627], [-122.57826, 38.12622], [-122.57825, 38.12617], [-122.5782, 38.12613], [-122.57812, 38.12611], [-122.57806, 38.12612], [-122.57794, 38.12593], [-122.57749, 38.1259], [-122.5773, 38.12585], [-122.57682, 38.12569], [-122.57668, 38.1256], [-122.57654, 38.1254], [-122.57628, 38.12495], [-122.57584, 38.1251], [-122.57576, 38.12497], [-122.57616, 38.12483], [-122.57648, 38.12464], [-122.57646, 38.12415], [-122.57647, 38.12387], [-122.57594, 38.12389], [-122.57593, 38.12383], [-122.57589, 38.12378], [-122.5762, 38.12347], [-122.5762, 38.12345], [-122.57515, 38.12335], [-122.57558, 38.12123], [-122.57661, 38.12098], [-122.57704, 38.12091], [-122.57733, 38.12088], [-122.57762, 38.12087], [-122.57806, 38.12088], [-122.5792, 38.12099], [-122.57941, 38.12102], [-122.57993, 38.12115], [-122.58069, 38.12146], [-122.58091, 38.12151], [-122.58112, 38.12154], [-122.58135, 38.12155], [-122.58163, 38.12152], [-122.58244, 38.12132], [-122.58262, 38.12129], [-122.58294, 38.12129], [-122.58321, 38.12131], [-122.58322, 38.12202], [-122.5842, 38.1226], [-122.58378, 38.12349], [-122.58342, 38.12338], [-122.58373, 38.12276], [-122.58306, 38.12236], [-122.58224, 38.12253], [-122.58178, 38.12369], [-122.58224, 38.12377], [-122.58221, 38.12399], [-122.58223, 38.12422], [-122.58234, 38.12456], [-122.58247, 38.12474], [-122.58141, 38.12533], [-122.58118, 38.12565], [-122.58134, 38.12598], [-122.58162, 38.12574], [-122.58168, 38.12577], [-122.58175, 38.12576], [-122.58174, 38.12582], [-122.58191, 38.126], [-122.58227, 38.1263], [-122.58261, 38.12669], [-122.5828, 38.12686], [-122.58335, 38.1272], [-122.584, 38.12735], [-122.58487, 38.1252], [-122.58546, 38.12533], [-122.58577, 38.12537], [-122.58599, 38.12497], [-122.5867, 38.12544], [-122.58718, 38.1257], [-122.58794, 38.12582], [-122.58789, 38.12606], [-122.58778, 38.12647], [-122.5883, 38.12658], [-122.5891, 38.12662], [-122.59028, 38.1266], [-122.59041, 38.12642], [-122.59052, 38.12648], [-122.59059, 38.12645], [-122.59084, 38.12612], [-122.59114, 38.12626], [-122.59132, 38.12607], [-122.5916, 38.12624], [-122.59162, 38.12623], [-122.59179, 38.12632], [-122.59179, 38.12633], [-122.59209, 38.12652], [-122.59228, 38.12635], [-122.59261, 38.12609], [-122.59261, 38.12606], [-122.59276, 38.12598], [-122.59271, 38.1259], [-122.593, 38.12566], [-122.59295, 38.12562], [-122.5933, 38.12525], [-122.59327, 38.12522], [-122.59358, 38.12499], [-122.59353, 38.12465], [-122.59358, 38.12453], [-122.59368, 38.12453], [-122.59377, 38.12447], [-122.59378, 38.12442], [-122.59377, 38.12437], [-122.59398, 38.12409], [-122.59393, 38.12397], [-122.59399, 38.12395], [-122.59397, 38.12388], [-122.59417, 38.12383], [-122.59419, 38.12385], [-122.59439, 38.1238], [-122.59439, 38.12377], [-122.59482, 38.12366], [-122.59483, 38.12367], [-122.59524, 38.12355], [-122.59525, 38.12355], [-122.59543, 38.12351], [-122.59574, 38.12452], [-122.59649, 38.12448], [-122.59682, 38.12461], [-122.59684, 38.12457], [-122.59746, 38.12469], [-122.59863, 38.12416], [-122.59874, 38.1243], [-122.59886, 38.1242], [-122.59944, 38.12431], [-122.59933, 38.12472], [-122.5999, 38.12476], [-122.60042, 38.12439], [-122.60059, 38.12524], [-122.60092, 38.1267], [-122.60101, 38.12705], [-122.60118, 38.12743], [-122.60139, 38.12782], [-122.60157, 38.12808], [-122.60185, 38.12846], [-122.60221, 38.12884], [-122.60339, 38.12859], [-122.60371, 38.12907], [-122.60383, 38.12928], [-122.60424, 38.13042], [-122.60567, 38.13069], [-122.60584, 38.13022], [-122.60649, 38.13033], [-122.60674, 38.12935], [-122.60505, 38.12705], [-122.60639, 38.12616], [-122.60541, 38.12565], [-122.6049, 38.12499], [-122.60505, 38.1246], [-122.60515, 38.12445], [-122.60601, 38.12394], [-122.60619, 38.12397], [-122.60642, 38.12414], [-122.60644, 38.12414], [-122.60642, 38.12313], [-122.60643, 38.12308], [-122.60644, 38.12308], [-122.60649, 38.12459], [-122.60717, 38.12456], [-122.60757, 38.12402], [-122.60849, 38.12353], [-122.61185, 38.12361], [-122.61282, 38.12404], [-122.61282, 38.12352], [-122.61243, 38.12293], [-122.61234, 38.1226], [-122.61205, 38.1226], [-122.61203, 38.12256], [-122.61232, 38.12253], [-122.61226, 38.12225], [-122.61237, 38.12228], [-122.61249, 38.1226], [-122.61251, 38.1228], [-122.61292, 38.12315], [-122.61335, 38.12358], [-122.61373, 38.12407], [-122.61394, 38.12441], [-122.61413, 38.12476], [-122.61428, 38.12512], [-122.61448, 38.12575], [-122.61533, 38.12598]], [[-122.59435, 38.14496], [-122.59435, 38.14494], [-122.59403, 38.14463], [-122.59363, 38.14489], [-122.59395, 38.14521], [-122.59435, 38.14496]], [[-122.60009, 38.12798], [-122.5998, 38.12745], [-122.59897, 38.12769], [-122.59888, 38.12775], [-122.59883, 38.12781], [-122.59882, 38.12787], [-122.59882, 38.12824], [-122.59884, 38.12835], [-122.59887, 38.12842], [-122.59893, 38.1285], [-122.599, 38.12857], [-122.59912, 38.12864], [-122.59923, 38.12867], [-122.59935, 38.12869], [-122.59948, 38.12868], [-122.5996, 38.12866], [-122.60003, 38.1285], [-122.60009, 38.12798]], [[-122.60746, 38.13228], [-122.60747, 38.13227], [-122.60722, 38.13181], [-122.60644, 38.13206], [-122.60669, 38.13253], [-122.60746, 38.13228]]]} | Open Access 1 | 18091 | Mount Burdell Open Space Preserve | 31440 | 2070 | Marin County Open Space District 44 | Special District 4 | Recreation/Parks District 4 | http://www.marincountyparks.org/Depts/PK.aspx | Special District 4 | 2070 | Marin County Open Space District 43 | Special District 4 | Recreation/Parks District 4 | http://www.marincounty.org/depts/pk/divisions/open-space/mount-burdell | Marin 23 | 1626.378 | Mount Burdell OSP | 1977 | Local Conservation Area 4 | 2 |
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]);