units_with_maps

Table actions

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

1 row where ACCESS_TYP = 1, COUNTY = 5 and DES_TP = 39

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AG_TYP

DES_TP 1

  • State Recreation Area · 1 ✖

ACCESS_TYP 1

  • Open Access · 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
9817 9817 9816 {"type": "Polygon", "coordinates": [[[-122.27189, 37.08629], [-122.27082, 37.08655], [-122.26904, 37.08506], [-122.2671, 37.08305], [-122.2636, 37.07903], [-122.2613, 37.07462], [-122.25781, 37.0704], [-122.2592, 37.0701], [-122.25927, 37.07039], [-122.25953, 37.07063], [-122.25925, 37.07061], [-122.25921, 37.07079], [-122.25898, 37.07083], [-122.25897, 37.07084], [-122.25928, 37.07133], [-122.25954, 37.07104], [-122.25993, 37.07115], [-122.25989, 37.07215], [-122.26018, 37.07244], [-122.2602, 37.07267], [-122.26029, 37.07277], [-122.26057, 37.07276], [-122.26087, 37.07295], [-122.26099, 37.07276], [-122.26135, 37.07274], [-122.26128, 37.07243], [-122.26164, 37.07233], [-122.26169, 37.07276], [-122.26166, 37.07326], [-122.262, 37.07327], [-122.26193, 37.0733], [-122.2623, 37.07348], [-122.26261, 37.07354], [-122.26268, 37.07375], [-122.26226, 37.07488], [-122.26225, 37.075], [-122.26231, 37.07498], [-122.26231, 37.075], [-122.26265, 37.07494], [-122.26263, 37.07499], [-122.26334, 37.07595], [-122.26366, 37.07647], [-122.26405, 37.0774], [-122.2655, 37.07818], [-122.26634, 37.07843], [-122.26636, 37.07848], [-122.26655, 37.07849], [-122.26726, 37.07833], [-122.26739, 37.07814], [-122.26752, 37.07747], [-122.26771, 37.07736], [-122.26794, 37.07741], [-122.26791, 37.07792], [-122.26778, 37.07828], [-122.26697, 37.07885], [-122.26698, 37.07897], [-122.26728, 37.07915], [-122.26764, 37.08005], [-122.26758, 37.08033], [-122.26758, 37.08056], [-122.26829, 37.0822], [-122.26862, 37.08277], [-122.26868, 37.0833], [-122.26903, 37.08387], [-122.26968, 37.08488], [-122.27002, 37.08526], [-122.27084, 37.08552], [-122.27146, 37.0858], [-122.27189, 37.08629]]]} Open Access 1 25173 Greyhound Rock Fishing Access 32179 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   Santa Cruz 5 68.635 Greyhound Rock FA 0 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]);