superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, MNG_AGENCY = 28, MNG_AG_LEV = 3 and YR_EST = 1980
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- San Mateo County Parks and Recreation Dept., County of · 1 ✖
ACCESS_TYP 1
- Open Access · 1 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15572 | 15572 | 15571 | {"type": "Polygon", "coordinates": [[[-122.44907, 37.70164], [-122.44695, 37.70279], [-122.44598, 37.70227], [-122.44575, 37.70217], [-122.44551, 37.70208], [-122.44361, 37.70161], [-122.44327, 37.70156], [-122.44284, 37.70156], [-122.44274, 37.70138], [-122.44262, 37.70126], [-122.4419, 37.7008], [-122.44066, 37.70092], [-122.44064, 37.70094], [-122.44124, 37.70273], [-122.44096, 37.7037], [-122.4397, 37.7037], [-122.43851, 37.70406], [-122.438, 37.704], [-122.43697, 37.70439], [-122.4362, 37.7043], [-122.43532, 37.7044], [-122.43459, 37.70436], [-122.43413, 37.70446], [-122.43398, 37.70467], [-122.43383, 37.70462], [-122.4336, 37.70461], [-122.43349, 37.70458], [-122.43338, 37.70453], [-122.4332, 37.70439], [-122.43302, 37.70432], [-122.43276, 37.70429], [-122.43247, 37.7043], [-122.43192, 37.70404], [-122.43162, 37.70431], [-122.43171, 37.70461], [-122.43152, 37.70478], [-122.43141, 37.70481], [-122.43142, 37.70482], [-122.43148, 37.70482], [-122.43136, 37.70488], [-122.43118, 37.7049], [-122.43072, 37.70478], [-122.43052, 37.70476], [-122.43031, 37.70475], [-122.42995, 37.7048], [-122.42937, 37.70497], [-122.42917, 37.70497], [-122.429, 37.70494], [-122.42897, 37.70491], [-122.42902, 37.70474], [-122.42902, 37.70462], [-122.42888, 37.70403], [-122.42876, 37.70374], [-122.4285, 37.70331], [-122.42839, 37.70321], [-122.42792, 37.70287], [-122.4272, 37.70349], [-122.42551, 37.70158], [-122.42569, 37.70113], [-122.42477, 37.70005], [-122.42376, 37.70022], [-122.42353, 37.70032], [-122.42283, 37.70025], [-122.42269, 37.70022], [-122.42217, 37.69846], [-122.42341, 37.69681], [-122.42366, 37.69657], [-122.42396, 37.69637], [-122.42431, 37.69623], [-122.42468, 37.69614], [-122.42508, 37.69612], [-122.42534, 37.69614], [-122.42565, 37.69621], [-122.42589, 37.69629], [-122.42612, 37.6964], [-122.42887, 37.69833], [-122.42919, 37.69852], [-122.42949, 37.69862], [-122.42987, 37.6987], [-122.43026, 37.69871], [-122.43065, 37.69866], [-122.43095, 37.69857], [-122.43124, 37.69843], [-122.43149, 37.69826], [-122.4317, 37.69806], [-122.4318, 37.69793], [-122.43191, 37.69774], [-122.43243, 37.69655], [-122.43257, 37.69637], [-122.43274, 37.6962], [-122.43299, 37.69604], [-122.43333, 37.69591], [-122.4337, 37.69584], [-122.43408, 37.69585], [-122.43429, 37.69589], [-122.4345, 37.69595], [-122.43627, 37.69661], [-122.43688, 37.69687], [-122.43746, 37.69717], [-122.43981, 37.69866], [-122.44012, 37.69883], [-122.44045, 37.69896], [-122.44753, 37.70159], [-122.44784, 37.70167], [-122.44816, 37.70169], [-122.44855, 37.70167], [-122.44893, 37.70159], [-122.44907, 37.70164]]]} | Open Access 1 | San Bruno Mountain State Park | http://www.parks.ca.gov/?page_id=518 | 30691 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | http://www.co.sanmateo.ca.us/portal/site/parks/ | County 3 | 297.871 | San Bruno Mtn. SP | 1980 |
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]);