superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where MNG_AG_TYP = 5 and PARK_NAME = "Oceano Dunes State Vehicular Recreation Area"
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
189 | 189 | 188 | {"type": "Polygon", "coordinates": [[[-120.63643, 35.01784], [-120.63637, 35.01818], [-120.63622, 35.01883], [-120.63615, 35.01987], [-120.63579, 35.02097], [-120.63573, 35.02206], [-120.63521, 35.02377], [-120.63517, 35.02516], [-120.63512, 35.02605], [-120.63452, 35.02722], [-120.63466, 35.02858], [-120.63436, 35.02989], [-120.63414, 35.03142], [-120.63362, 35.0328], [-120.6336, 35.03357], [-120.63374, 35.03397], [-120.63334, 35.03491], [-120.63337, 35.03553], [-120.63356, 35.03581], [-120.63357, 35.03613], [-120.63344, 35.03684], [-120.63311, 35.03781], [-120.63306, 35.03854], [-120.63297, 35.03946], [-120.6327, 35.03996], [-120.6327, 35.04021], [-120.63264, 35.04056], [-120.63275, 35.04134], [-120.63018, 35.04129], [-120.62861, 35.05129], [-120.62808, 35.05592], [-120.6279, 35.05684], [-120.62793, 35.06078], [-120.62807, 35.06267], [-120.62825, 35.06616], [-120.62837, 35.07497], [-120.62864, 35.08087], [-120.61932, 35.08098], [-120.61917, 35.06809], [-120.61911, 35.06083], [-120.61572, 35.06084], [-120.61567, 35.05693], [-120.61165, 35.05696], [-120.60696, 35.04631], [-120.60821, 35.03689], [-120.60821, 35.03622], [-120.61133, 35.03435], [-120.61193, 35.03342], [-120.61364, 35.03325], [-120.61532, 35.03311], [-120.6176, 35.03273], [-120.62013, 35.03081], [-120.62069, 35.03088], [-120.62069, 35.03086], [-120.62007, 35.03036], [-120.62045, 35.03008], [-120.62078, 35.02939], [-120.62099, 35.02884], [-120.62148, 35.02831], [-120.62243, 35.02747], [-120.623, 35.0272], [-120.62464, 35.02677], [-120.62527, 35.02699], [-120.62589, 35.02701], [-120.62615, 35.0266], [-120.63127, 35.02843], [-120.63219, 35.02365], [-120.62112, 35.02369], [-120.61199, 35.01744], [-120.61221, 35.01709], [-120.60732, 35.01378], [-120.6001, 35.0088], [-120.63643, 35.01784]], [[-120.61375, 35.04511], [-120.61376, 35.0451], [-120.61353, 35.04414], [-120.61232, 35.04432], [-120.61254, 35.04528], [-120.61375, 35.04511]], [[-120.61406, 35.03687], [-120.61407, 35.03685], [-120.61405, 35.03588], [-120.61281, 35.03587], [-120.61283, 35.03685], [-120.61406, 35.03687]], [[-120.61452, 35.04049], [-120.61577, 35.04051], [-120.61576, 35.03953], [-120.61452, 35.03952], [-120.61452, 35.04049]], [[-120.61766, 35.03701], [-120.6189, 35.03703], [-120.6189, 35.03605], [-120.61766, 35.03604], [-120.61766, 35.03701]], [[-120.61914, 35.0565], [-120.61914, 35.05568], [-120.61819, 35.05569], [-120.6182, 35.05651], [-120.61914, 35.0565]], [[-120.62004, 35.04314], [-120.62003, 35.04316], [-120.62028, 35.04411], [-120.6215, 35.04391], [-120.62125, 35.04295], [-120.62004, 35.04314]], [[-120.62573, 35.0357], [-120.62601, 35.03474], [-120.62481, 35.03449], [-120.62455, 35.03545], [-120.62573, 35.0357]], [[-120.62597, 35.04015], [-120.62473, 35.04013], [-120.62473, 35.04111], [-120.62597, 35.04112], [-120.62597, 35.04015]], [[-120.6258, 35.0556], [-120.6258, 35.05642], [-120.62676, 35.05641], [-120.62674, 35.0556], [-120.6258, 35.0556]], [[-120.62922, 35.03568], [-120.62894, 35.03664], [-120.63014, 35.03689], [-120.6304, 35.03593], [-120.62922, 35.03568]], [[-120.62971, 35.04009], [-120.6297, 35.0401], [-120.62972, 35.04108], [-120.63096, 35.04108], [-120.63094, 35.0401], [-120.62971, 35.04009]]]} | Open Access 1 | Oceano Dunes State Vehicular Recreation Area | http://www.parks.ca.gov/?page_id=406 | 1659 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 2613.091 | Oceano Dunes SVRA | 1974 |
12242 | 12242 | 12241 | {"type": "Polygon", "coordinates": [[[-120.62013, 35.03081], [-120.61761, 35.03273], [-120.61532, 35.03311], [-120.61364, 35.03325], [-120.61193, 35.03342], [-120.61133, 35.03435], [-120.60821, 35.03622], [-120.60821, 35.03689], [-120.60696, 35.04631], [-120.61165, 35.05697], [-120.60801, 35.057], [-120.60052, 35.05401], [-120.59852, 35.05279], [-120.59685, 35.05291], [-120.59637, 35.04947], [-120.59602, 35.04949], [-120.59405, 35.0355], [-120.59325, 35.03276], [-120.59844, 35.03437], [-120.60263, 35.0349], [-120.6082, 35.03621], [-120.60821, 35.02925], [-120.61044, 35.02376], [-120.61978, 35.03058], [-120.62013, 35.03081]]]} | Restricted Access 2 | Oceano Dunes State Vehicular Recreation Area | 30668 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 846.047 | Oceano Dunes SVRA | 1974 |
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]);