units_with_maps

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

2 rows where COUNTY = 1, DES_TP = 39 and YR_EST = 1974

This data as json, copyable, CSV (advanced)

ACCESS_TYP 2

MNG_AG_TYP 1

DES_TP 1

  • State Recreation Area · 2 ✖
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
4052 4052 4051 {"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.05278], [-120.59685, 35.05291], [-120.59637, 35.04946], [-120.59602, 35.04949], [-120.59405, 35.0355], [-120.59325, 35.03276], [-120.59845, 35.03437], [-120.60263, 35.0349], [-120.6082, 35.03622], [-120.60821, 35.02925], [-120.61044, 35.02376], [-120.61978, 35.03058], [-120.62013, 35.03081]]]} Restricted Access 2 47022 Oceano Dunes State Vehicular Recreation Area 30668 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 204 California Department of Parks and Recreation 47 State 5 State Agency 5   San Luis Obispo 1 845.96 Oceano Dunes SVRA 1974 State Recreation Area 39 4
16668 16668 16667 {"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.02988], [-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.0378], [-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.04128], [-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.61568, 35.05693], [-120.61165, 35.05697], [-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.6207, 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.6322, 35.02364], [-120.62112, 35.02369], [-120.61199, 35.01744], [-120.61221, 35.0171], [-120.60732, 35.01378], [-120.6001, 35.0088], [-120.63643, 35.01784]], [[-120.61375, 35.04511], [-120.61376, 35.0451], [-120.61354, 35.04414], [-120.61231, 35.04431], [-120.61254, 35.04528], [-120.61375, 35.04511]], [[-120.61406, 35.03687], [-120.61407, 35.03686], [-120.61406, 35.03588], [-120.61281, 35.03587], [-120.61282, 35.03686], [-120.61406, 35.03687]], [[-120.61452, 35.0405], [-120.61577, 35.04051], [-120.61576, 35.03953], [-120.61452, 35.03952], [-120.61452, 35.0405]], [[-120.61766, 35.03702], [-120.61891, 35.03704], [-120.6189, 35.03605], [-120.61766, 35.03604], [-120.61766, 35.03702]], [[-120.61915, 35.0565], [-120.61915, 35.05568], [-120.61818, 35.05569], [-120.6182, 35.05651], [-120.61915, 35.0565]], [[-120.62004, 35.04314], [-120.62003, 35.04315], [-120.62028, 35.04411], [-120.6215, 35.04391], [-120.62125, 35.04295], [-120.62004, 35.04314]], [[-120.62574, 35.0357], [-120.62602, 35.03474], [-120.62481, 35.03449], [-120.62454, 35.03545], [-120.62574, 35.0357]], [[-120.62597, 35.04014], [-120.62472, 35.04013], [-120.62473, 35.04111], [-120.62597, 35.04112], [-120.62597, 35.04014]], [[-120.62579, 35.0556], [-120.6258, 35.05643], [-120.62676, 35.05642], [-120.62675, 35.0556], [-120.62579, 35.0556]], [[-120.62921, 35.03568], [-120.62893, 35.03664], [-120.63014, 35.03689], [-120.63041, 35.03593], [-120.62921, 35.03568]], [[-120.62971, 35.04009], [-120.6297, 35.0401], [-120.62971, 35.04108], [-120.63096, 35.04109], [-120.63095, 35.0401], [-120.62971, 35.04009]]]} Open Access 1 18256 Oceano Dunes State Vehicular Recreation Area 1659 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 204 California Department of Parks and Recreation 47 State 5 State Agency 5 http://www.parks.ca.gov/?page_id=406 San Luis Obispo 1 2612.474 Oceano Dunes SVRA 1974 State Recreation Area 39 4

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);