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 = 55 and YR_EST = 0

This data as json, copyable, CSV (advanced)

ACCESS_TYP 2

MNG_AG_TYP 1

DES_TP 1

  • State Resource Management 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
14333 14333 14332 {"type": "MultiPolygon", "coordinates": [[[[-119.95169, 35.34039], [-119.95158, 35.34385], [-119.94704, 35.34383], [-119.947, 35.3511], [-119.93381, 35.35103], [-119.93382, 35.34373], [-119.94283, 35.34379], [-119.94285, 35.34034], [-119.95169, 35.34039]]], [[[-119.96505, 35.33683], [-119.96502, 35.344], [-119.96043, 35.34409], [-119.96043, 35.3477], [-119.9559, 35.34767], [-119.95603, 35.34409], [-119.96042, 35.34409], [-119.96057, 35.33683], [-119.96505, 35.33683]]], [[[-119.98747, 35.33683], [-119.98735, 35.34411], [-119.96942, 35.34398], [-119.96961, 35.33682], [-119.98747, 35.33683]]], [[[-120.11221, 35.42515], [-120.11212, 35.43976], [-120.07625, 35.43965], [-120.07684, 35.425], [-120.05856, 35.4248], [-120.05869, 35.41023], [-120.04079, 35.41018], [-120.04076, 35.39937], [-120.03647, 35.39935], [-120.03645, 35.40289], [-120.03174, 35.40286], [-120.03178, 35.39558], [-120.02291, 35.39551], [-120.02283, 35.39752], [-120.01828, 35.39748], [-120.0183, 35.39549], [-120.01409, 35.39544], [-120.0141, 35.39176], [-120.01834, 35.39181], [-120.0183, 35.39548], [-120.01842, 35.39548], [-120.01843, 35.38431], [-120.01407, 35.3843], [-120.01398, 35.40633], [-120.02291, 35.40637], [-120.02291, 35.41006], [-120.01397, 35.4101], [-120.01396, 35.40745], [-119.98714, 35.40745], [-119.98723, 35.39547], [-119.98728, 35.38073], [-119.98721, 35.36616], [-120.00498, 35.36619], [-120.00533, 35.3516], [-120.03916, 35.35179], [-120.03919, 35.35942], [-120.03263, 35.35936], [-120.03223, 35.35888], [-120.03236, 35.35539], [-120.03276, 35.35491], [-120.03265, 35.35331], [-120.02691, 35.35331], [-120.02685, 35.35475], [-120.02724, 35.35502], [-120.02737, 35.38091], [-120.02717, 35.38092], [-120.02729, 35.3881], [-120.03183, 35.38814], [-120.03182, 35.38883], [-120.03183, 35.38884], [-120.03414, 35.38879], [-120.03698, 35.38817], [-120.04584, 35.38823], [-120.04587, 35.39171], [-120.04986, 35.39171], [-120.0499, 35.39568], [-120.0588, 35.39569], [-120.05897, 35.38872], [-120.06823, 35.38878], [-120.06818, 35.3957], [-120.08401, 35.39576], [-120.084, 35.40312], [-120.09426, 35.40318], [-120.09436, 35.42495], [-120.11221, 35.42515]], [[-120.00951, 35.36991], [-120.00952, 35.3699], [-120.00951, 35.36985], [-120.00509, 35.36985], [-120.00507, 35.36913], [-120.00505, 35.36913], [-120.00507, 35.3699], [-120.00951, 35.36991]], [[-120.01411, 35.38086], [-120.01412, 35.38085], [-120.0141, 35.38006], [-120.01409, 35.38085], [-120.01411, 35.38086]]], [[[-120.04067, 35.38442], [-120.03626, 35.3844], [-120.03623, 35.38094], [-120.04065, 35.38097], [-120.04067, 35.38442]]], [[[-120.09453, 35.35203], [-120.09446, 35.35604], [-120.09433, 35.35941], [-120.0943, 35.36646], [-120.08626, 35.36648], [-120.07741, 35.36647], [-120.07697, 35.36631], [-120.07702, 35.35933], [-120.07701, 35.35682], [-120.07617, 35.35678], [-120.07177, 35.35231], [-120.07016, 35.35227], [-120.07016, 35.35184], [-120.06997, 35.34965], [-120.06845, 35.34954], [-120.06851, 35.34831], [-120.0667, 35.34825], [-120.06668, 35.34663], [-120.06482, 35.34664], [-120.06478, 35.34488], [-120.0647, 35.3448], [-120.05734, 35.3449], [-120.05727, 35.34647], [-120.0543, 35.34645], [-120.05427, 35.34491], [-120.05033, 35.34496], [-120.0502, 35.34824], [-120.04715, 35.3482], [-120.04698, 35.3597], [-120.04063, 35.3597], [-120.04082, 35.33879], [-120.04089, 35.33879], [-120.05021, 35.34175], [-120.05287, 35.34161], [-120.0528, 35.33703], [-120.07704, 35.33706], [-120.07698, 35.35187], [-120.09453, 35.35203]]], [[[-120.09423, 35.37925], [-120.09423, 35.38101], [-120.09421, 35.38124], [-120.08206, 35.38118], [-120.08205, 35.38115], [-120.07786, 35.38119], [-120.0779, 35.37486], [-120.07979, 35.37486], [-120.08205, 35.37552], [-120.08204, 35.36856], [-120.08214, 35.3686], [-120.08215, 35.37614], [-120.09141, 35.37927], [-120.09423, 35.37925]]]]} No Public Access 3 44336 California Valley 32084 201 California Department of Fish and Wildlife 25 State 5 State Agency 5 https://www.wildlife.ca.gov/ California Department of Fish and Wildlife 6 201 California Department of Fish and Wildlife 25 State 5 State Agency 5   San Luis Obispo 1 12379.201 California Valley 0 State Resource Management Area 55 3
16582 16582 16581 {"type": "MultiPolygon", "coordinates": [[[[-119.71974, 35.2303], [-119.71972, 35.23372], [-119.71531, 35.23371], [-119.71533, 35.23026], [-119.70652, 35.23018], [-119.70654, 35.22655], [-119.70214, 35.2265], [-119.70217, 35.22287], [-119.70658, 35.22291], [-119.70661, 35.21927], [-119.71102, 35.21932], [-119.71099, 35.22295], [-119.70658, 35.22291], [-119.70655, 35.22654], [-119.71537, 35.22663], [-119.71534, 35.23026], [-119.71974, 35.2303]]], [[[-119.77399, 35.04841], [-119.76497, 35.04846], [-119.7649, 35.04519], [-119.76936, 35.04515], [-119.76928, 35.04158], [-119.75627, 35.04163], [-119.75623, 35.03425], [-119.77383, 35.03421], [-119.77399, 35.04841]]]]} Open Access 1 44756 California State Lands Commission 16724 209 California State Lands Commission 75 State 5 State Agency 5 http://www.slc.ca.gov/ Other State 5 209 California State Lands Commission 73 State 5 State Agency 5   San Luis Obispo 1 638.28 SLC 0 State Resource Management Area 55 3

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