units_with_maps

Table actions

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

1 row where AGNCY_NAME = 215, DES_TP = 80 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 1 ✖

MNG_AGENCY 1

DES_TP 1

  • National Monument or Landmark · 1 ✖

ACCESS_TYP 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
16973 16973 16972 {"type": "MultiPolygon", "coordinates": [[[[-116.40815, 33.67042], [-116.40786, 33.67036], [-116.40782, 33.67052], [-116.40799, 33.67062], [-116.39102, 33.67062], [-116.391, 33.66342], [-116.39893, 33.66343], [-116.39911, 33.66404], [-116.40094, 33.66486], [-116.40196, 33.66555], [-116.40233, 33.66566], [-116.40387, 33.6657], [-116.4042, 33.66582], [-116.40453, 33.66609], [-116.40497, 33.66685], [-116.4053, 33.66712], [-116.40552, 33.66717], [-116.40528, 33.66757], [-116.40635, 33.66818], [-116.40697, 33.6684], [-116.40765, 33.66936], [-116.40814, 33.66949], [-116.40815, 33.67042]]], [[[-116.40827, 33.72153], [-116.40815, 33.72862], [-116.40669, 33.72863], [-116.40669, 33.72848], [-116.40684, 33.7284], [-116.40655, 33.72811], [-116.40623, 33.7282], [-116.40596, 33.72815], [-116.40582, 33.72814], [-116.40548, 33.72787], [-116.40502, 33.72771], [-116.40502, 33.72751], [-116.40505, 33.72734], [-116.40537, 33.72647], [-116.40619, 33.72641], [-116.4064, 33.7255], [-116.40497, 33.72403], [-116.40463, 33.72346], [-116.40453, 33.72287], [-116.40411, 33.72255], [-116.40389, 33.72245], [-116.40392, 33.72232], [-116.40349, 33.72228], [-116.4033, 33.72239], [-116.40281, 33.72177], [-116.4027, 33.7215], [-116.4029, 33.7215], [-116.40291, 33.72149], [-116.40175, 33.7185], [-116.40156, 33.71853], [-116.40039, 33.71553], [-116.40161, 33.71553], [-116.402, 33.71581], [-116.40276, 33.71609], [-116.40281, 33.71616], [-116.40284, 33.71642], [-116.40297, 33.71668], [-116.40302, 33.71674], [-116.40306, 33.71693], [-116.40319, 33.71696], [-116.40319, 33.717], [-116.40326, 33.71705], [-116.40359, 33.7171], [-116.40379, 33.71717], [-116.4039, 33.71725], [-116.40409, 33.71744], [-116.4044, 33.71793], [-116.40416, 33.71802], [-116.40406, 33.71789], [-116.40398, 33.71792], [-116.40391, 33.71801], [-116.40387, 33.71809], [-116.40386, 33.71821], [-116.40388, 33.71829], [-116.40363, 33.71859], [-116.40435, 33.71968], [-116.40505, 33.72005], [-116.40443, 33.72029], [-116.40465, 33.72151], [-116.40827, 33.72153]]], [[[-116.42543, 33.68504], [-116.4238, 33.68504], [-116.42375, 33.68413], [-116.42366, 33.68321], [-116.42348, 33.68225], [-116.42102, 33.67791], [-116.42092, 33.67739], [-116.41891, 33.67625], [-116.41686, 33.6757], [-116.4163, 33.67524], [-116.41641, 33.67467], [-116.41631, 33.67457], [-116.41632, 33.67446], [-116.41628, 33.67436], [-116.41599, 33.67408], [-116.41578, 33.67406], [-116.41563, 33.67392], [-116.41474, 33.67379], [-116.41409, 33.67414], [-116.41322, 33.67388], [-116.41171, 33.67319], [-116.41164, 33.67302], [-116.41166, 33.6721], [-116.4118, 33.6721], [-116.4119, 33.67207], [-116.41196, 33.672], [-116.41201, 33.67187], [-116.412, 33.67179], [-116.41196, 33.67172], [-116.41186, 33.67163], [-116.41177, 33.67159], [-116.41442, 33.67067], [-116.41673, 33.67067], [-116.41674, 33.67069], [-116.4254, 33.67068], [-116.42543, 33.68504]], [[-116.41672, 33.67293], [-116.41648, 33.6729], [-116.41612, 33.67323], [-116.41612, 33.6734], [-116.41694, 33.67337], [-116.41696, 33.67309], [-116.41677, 33.67294], [-116.41672, 33.67293]]]]} Open Access 1 5785 Santa Rosa and San Jacinto Mountains National Monument 8325 1240 Palm Desert, City of 215 City 2 City Agency 2 http://www.cityofpalmdesert.org/Index.aspx?page=174 City 2 1240 Palm Desert, City of 211 City 2 City Agency 2   Riverside 10 562.433 Santa Rosa and San Jacinto Mtns. NM 2000 National Monument or Landmark 80 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]);