calands: units_with_maps: 1 row where AGNCY_LEV = 2, DES_TP = 80 and MNG

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

1 row where AGNCY_LEV = 2, DES_TP = 80 and MNG_AGENCY = 546

Search:

descending

This data as json, copyable, CSV (advanced)

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
16987	16987	16986	{"type": "MultiPolygon", "coordinates": [[[[-116.45598, 33.64882], [-116.44832, 33.64885], [-116.44301, 33.64885], [-116.44283, 33.64527], [-116.44727, 33.64526], [-116.44728, 33.6416], [-116.45169, 33.6416], [-116.45169, 33.64524], [-116.45597, 33.64524], [-116.45598, 33.64882]]], [[[-116.58839, 33.78979], [-116.58817, 33.7898], [-116.58804, 33.78983], [-116.58789, 33.7899], [-116.58779, 33.79002], [-116.58763, 33.79028], [-116.58752, 33.79034], [-116.58742, 33.7903], [-116.58707, 33.78996], [-116.58697, 33.78967], [-116.58692, 33.78958], [-116.58674, 33.78955], [-116.58663, 33.7896], [-116.58654, 33.78969], [-116.58651, 33.78978], [-116.58644, 33.78988], [-116.58625, 33.78999], [-116.58619, 33.79], [-116.58573, 33.78994], [-116.58553, 33.78985], [-116.58535, 33.78981], [-116.5853, 33.78978], [-116.58524, 33.78972], [-116.58516, 33.78956], [-116.58501, 33.78941], [-116.58483, 33.78928], [-116.58457, 33.78907], [-116.5845, 33.78884], [-116.58445, 33.78879], [-116.58416, 33.7887], [-116.58414, 33.78669], [-116.58837, 33.78667], [-116.58839, 33.78979]]], [[[-116.59685, 33.79389], [-116.59266, 33.79392], [-116.59262, 33.79028], [-116.59684, 33.79025], [-116.59685, 33.79389]]], [[[-116.56323, 33.80153], [-116.55962, 33.80147], [-116.55074, 33.80137], [-116.55057, 33.80085], [-116.55113, 33.80049], [-116.55137, 33.80031], [-116.55159, 33.79937], [-116.55164, 33.79875], [-116.55161, 33.79843], [-116.55161, 33.79837], [-116.55155, 33.79832], [-116.55155, 33.79819], [-116.5516, 33.79775], [-116.55157, 33.79771], [-116.55148, 33.79765], [-116.55125, 33.79764], [-116.55184, 33.79764], [-116.55198, 33.79718], [-116.55157, 33.79687], [-116.55132, 33.79629], [-116.55046, 33.79594], [-116.55005, 33.79555], [-116.54939, 33.79511], [-116.54909, 33.79478], [-116.55181, 33.79478], [-116.55184, 33.79264], [-116.54945, 33.79262], [-116.54897, 33.79248], [-116.5486, 33.79157], [-116.5486, 33.79105], [-116.54789, 33.79103], [-116.54778, 33.79158], [-116.54768, 33.79158], [-116.54769, 33.79061], [-116.54751, 33.7906], [-116.5475, 33.78922], [-116.54744, 33.78921], [-116.54775, 33.78855], [-116.54807, 33.78802], [-116.54815, 33.78745], [-116.54809, 33.78704], [-116.54819, 33.78685], [-116.56316, 33.78691], [-116.56323, 33.80153]]], [[[-116.5631, 33.81604], [-116.56304, 33.82941], [-116.56085, 33.83032], [-116.55565, 33.83032], [-116.55429, 33.83027], [-116.55428, 33.8304], [-116.55352, 33.8304], [-116.55373, 33.83006], [-116.55404, 33.82972], [-116.55405, 33.82962], [-116.55405, 33.82957], [-116.554, 33.8295], [-116.55367, 33.82924], [-116.55362, 33.82908], [-116.5536, 33.82891], [-116.55357, 33.82887], [-116.55353, 33.82882], [-116.55321, 33.82864], [-116.55298, 33.82848], [-116.55284, 33.82824], [-116.55275, 33.82802], [-116.55268, 33.82795], [-116.55261, 33.82792], [-116.55248, 33.82789], [-116.55167, 33.8279], [-116.55101, 33.82809], [-116.5506, 33.82814], [-116.55042, 33.82822], [-116.55079, 33.82852], [-116.55129, 33.82881], [-116.55146, 33.82935], [-116.55175, 33.82934], [-116.55216, 33.82942], [-116.55266, 33.82935], [-116.55285, 33.82943], [-116.55302, 33.8296], [-116.55363, 33.82957], [-116.55366, 33.82993], [-116.55346, 33.8304], [-116.5481, 33.83015], [-116.54807, 33.82561], [-116.54829, 33.82541], [-116.55427, 33.82541], [-116.55424, 33.81778], [-116.55466, 33.81777], [-116.55465, 33.81673], [-116.55501, 33.81672], [-116.55501, 33.81627], [-116.55491, 33.81626], [-116.55491, 33.81593], [-116.5631, 33.81604]]], [[[-116.5806, 33.84508], [-116.56296, 33.84488], [-116.56305, 33.84079], [-116.56314, 33.84063], [-116.56318, 33.84051], [-116.56327, 33.84038], [-116.56332, 33.84017], [-116.56342, 33.83998], [-116.56347, 33.8399], [-116.56353, 33.83987], [-116.56355, 33.83979], [-116.56353, 33.83969], [-116.56354, 33.83957], [-116.56361, 33.83945], [-116.56354, 33.83933], [-116.56351, 33.83923], [-116.56349, 33.83906], [-116.56355, 33.83881], [-116.56362, 33.83863], [-116.56357, 33.83849], [-116.56349, 33.83818], [-116.56351, 33.83804], [-116.56335, 33.83774], [-116.56331, 33.83758], [-116.5633, 33.83714], [-116.56335, 33.83681], [-116.56325, 33.83669], [-116.56461, 33.83668], [-116.56462, 33.83609], [-116.56444, 33.83583], [-116.56442, 33.83572], [-116.56451, 33.83549], [-116.56461, 33.8354], [-116.56478, 33.83534], [-116.56524, 33.8351], [-116.56549, 33.83501], [-116.56584, 33.83492], [-116.56626, 33.83484], [-116.56641, 33.83478], [-116.56658, 33.83466], [-116.56671, 33.83453], [-116.56696, 33.83461], [-116.56705, 33.8346], [-116.56708, 33.83455], [-116.5671, 33.83444], [-116.56715, 33.83437], [-116.56726, 33.83434], [-116.56729, 33.83428], [-116.56731, 33.83419], [-116.56735, 33.83417], [-116.56741, 33.83408], [-116.56738, 33.83393], [-116.56738, 33.83374], [-116.56732, 33.83366], [-116.56661, 33.83309], [-116.56634, 33.83294], [-116.56619, 33.83279], [-116.56616, 33.83268], [-116.56626, 33.83246], [-116.5663, 33.83208], [-116.56648, 33.83162], [-116.56666, 33.83103], [-116.5668, 33.83076], [-116.56675, 33.83045], [-116.57471, 33.83041], [-116.58024, 33.83042], [-116.58025, 33.83067], [-116.58059, 33.83067], [-116.5806, 33.84508]]], [[[-116.59707, 33.85934], [-116.58047, 33.85949], [-116.58043, 33.85485], [-116.58245, 33.85483], [-116.5868, 33.85048], [-116.58694, 33.85047], [-116.58874, 33.85195], [-116.59006, 33.85195], [-116.59174, 33.85027], [-116.59259, 33.84761], [-116.59258, 33.84609], [-116.59307, 33.8461], [-116.59621, 33.84759], [-116.59703, 33.84877], [-116.59707, 33.85934]]], [[[-116.60571, 33.87064], [-116.60136, 33.87069], [-116.60135, 33.86804], [-116.6019, 33.86804], [-116.6019, 33.86712], [-116.60569, 33.86709], [-116.60571, 33.87064]]]]}	Open Access 1	5788	Santa Rosa and San Jacinto Mountains National Monument	8337	1241	Palm Springs, City of 553	City 2	City Agency 2	http://www.ci.palm-springs.ca.us/index.aspx?page=80	City 2	1241	Palm Springs, City of 546	City 2	City Agency 2		Riverside 10	2097.744	Santa Rosa and San Jacinto Mtns. NM	2000	National Monument or Landmark 80	3

Advanced export

JSON shape: default, array, newline-delimited

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