units_with_maps

Table actions

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

1 row where ACCESS_TYP = 1, AGNCY_TYP = 12 and DES_TP = 3

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

DES_TP 1

  • Local 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
16196 16196 16195 {"type": "Polygon", "coordinates": [[[-117.0865, 34.04475], [-117.08624, 34.04842], [-117.0692, 34.04833], [-117.06049, 34.04845], [-117.06053, 34.04117], [-117.06028, 34.04116], [-117.06136, 34.04016], [-117.06174, 34.03987], [-117.06213, 34.03963], [-117.06229, 34.03983], [-117.06217, 34.03991], [-117.06204, 34.04003], [-117.06193, 34.04016], [-117.06185, 34.04031], [-117.0618, 34.04047], [-117.06173, 34.04129], [-117.06164, 34.04169], [-117.06154, 34.04194], [-117.06143, 34.04217], [-117.06097, 34.04289], [-117.06091, 34.04319], [-117.06129, 34.04371], [-117.06201, 34.04408], [-117.06344, 34.04421], [-117.06355, 34.04469], [-117.06401, 34.0452], [-117.06526, 34.04508], [-117.06733, 34.04373], [-117.06926, 34.04307], [-117.06929, 34.04107], [-117.06949, 34.04146], [-117.0696, 34.0416], [-117.0697, 34.04169], [-117.06984, 34.04178], [-117.07002, 34.04185], [-117.07023, 34.0419], [-117.07042, 34.04191], [-117.07059, 34.04189], [-117.07124, 34.04177], [-117.07142, 34.04172], [-117.07162, 34.04162], [-117.0722, 34.04122], [-117.07364, 34.041], [-117.07357, 34.04112], [-117.07356, 34.04255], [-117.074, 34.0428], [-117.07417, 34.04316], [-117.07504, 34.04377], [-117.07525, 34.04398], [-117.07626, 34.04404], [-117.07656, 34.04384], [-117.07839, 34.04318], [-117.07967, 34.04238], [-117.08011, 34.04194], [-117.07995, 34.0413], [-117.08064, 34.04121], [-117.08074, 34.04181], [-117.08067, 34.04184], [-117.08088, 34.04306], [-117.08058, 34.04376], [-117.08109, 34.0441], [-117.08156, 34.0439], [-117.08182, 34.04338], [-117.08177, 34.04301], [-117.08168, 34.04272], [-117.08098, 34.0427], [-117.08072, 34.0412], [-117.08344, 34.04075], [-117.08406, 34.04061], [-117.08457, 34.04045], [-117.08458, 34.04109], [-117.08231, 34.0411], [-117.08215, 34.04474], [-117.0865, 34.04475]]]} Open Access 1 29521 Chapman Heights Open Space 10132 3237 Crafton Hills Open Space Conservancy 1166 Non Profit 6 Non Profit - Conservation 12 http://craftonhillsconservancy.org/ Non Governmental Organization 10 318 San Bernardino, County of 363 County 3 County Agency 3 http://craftonhillsconservancy.org/maps/trail-maps-all-trails San Bernardino 22 336.232 Chapman Heights OS 0 Local Recreation Area 3 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]);