units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 1421, MNG_AGENCY = 28 and MNG_AG_LEV = 3 sorted by YR_EST
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- San Mateo County Parks and Recreation Dept., County of · 1 ✖
DES_TP 1
- - · 1 ✖
ACCESS_TYP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16964 | 16964 | 16963 | {"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.44263, 37.70126], [-122.4419, 37.7008], [-122.44065, 37.70092], [-122.44064, 37.70094], [-122.44125, 37.70273], [-122.44096, 37.7037], [-122.4397, 37.7037], [-122.43851, 37.70406], [-122.438, 37.70399], [-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.43303, 37.70432], [-122.43276, 37.70429], [-122.43247, 37.7043], [-122.43192, 37.70404], [-122.43161, 37.70431], [-122.43171, 37.70461], [-122.43152, 37.70478], [-122.43141, 37.70481], [-122.43141, 37.70483], [-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.70461], [-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.70004], [-122.42375, 37.70022], [-122.42353, 37.70032], [-122.42283, 37.70025], [-122.42269, 37.70022], [-122.42217, 37.69846], [-122.42341, 37.69681], [-122.42365, 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.43096, 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.44817, 37.70169], [-122.44855, 37.70167], [-122.44893, 37.70159], [-122.44907, 37.70164]]]} | Open Access 1 | 16001 | San Bruno Mountain State Park | 30691 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | http://www.parks.ca.gov/?page_id=518 | San Mateo 15 | 297.853 | San Bruno Mtn. SP | 1980 | None 1421 |
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]);