calands: units_with_maps: 2 rows where AGNCY_LEV = 5, MNG_AGENCY = 47 and YR

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

2 rows where AGNCY_LEV = 5, MNG_AGENCY = 47 and YR_EST = 1984

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
1169	1169	1168	{"type": "MultiPolygon", "coordinates": [[[[-118.27708, 34.23336], [-118.2746, 34.23281], [-118.27449, 34.23274], [-118.27367, 34.23255], [-118.26859, 34.23141], [-118.268, 34.23107], [-118.26755, 34.23097], [-118.26718, 34.23078], [-118.26693, 34.23072], [-118.2668, 34.23061], [-118.26718, 34.23041], [-118.26682, 34.22994], [-118.26683, 34.22784], [-118.26967, 34.22964], [-118.27167, 34.23046], [-118.27708, 34.23336]]], [[[-118.27981, 34.23393], [-118.27925, 34.23386], [-118.27867, 34.23373], [-118.27191, 34.2301], [-118.26993, 34.22928], [-118.26683, 34.22733], [-118.26687, 34.22185], [-118.27531, 34.22179], [-118.27539, 34.2291], [-118.27975, 34.22907], [-118.27981, 34.23393]]]]}	Open Access 1	6828	Verdugo Mountains Park Property	1781	204	California Department of Parks and Recreation 48	State 5	State Agency 5	http://www.parks.ca.gov/	California Department of Parks and Recreation 9	204	California Department of Parks and Recreation 47	State 5	State Agency 5	http://www.parks.ca.gov/?page_id=635	Los Angeles 6	252.47	Verdugo Mtns. Park Property	1984	State Other or Unknown 104	4
16504	16504	16503	{"type": "MultiPolygon", "coordinates": [[[[-117.41584, 33.89039], [-117.41541, 33.89094], [-117.41511, 33.89107], [-117.41508, 33.89095], [-117.41518, 33.89085], [-117.41511, 33.8908], [-117.4151, 33.89068], [-117.41509, 33.89068], [-117.415, 33.89084], [-117.41493, 33.89086], [-117.41483, 33.89098], [-117.41473, 33.89083], [-117.41472, 33.89067], [-117.41463, 33.89057], [-117.41449, 33.89053], [-117.41431, 33.89018], [-117.41429, 33.89018], [-117.41437, 33.89054], [-117.41453, 33.89069], [-117.41447, 33.89082], [-117.41431, 33.89083], [-117.41431, 33.89089], [-117.41443, 33.89103], [-117.41441, 33.89119], [-117.41446, 33.89129], [-117.41441, 33.89148], [-117.41442, 33.89158], [-117.41432, 33.8916], [-117.41451, 33.89196], [-117.4144, 33.89203], [-117.41404, 33.89198], [-117.41377, 33.89199], [-117.4135, 33.89186], [-117.41354, 33.89164], [-117.4134, 33.89163], [-117.4133, 33.89157], [-117.41336, 33.89147], [-117.41333, 33.89099], [-117.41341, 33.89088], [-117.4133, 33.8907], [-117.41332, 33.89056], [-117.41309, 33.89036], [-117.413, 33.89022], [-117.41287, 33.89013], [-117.41285, 33.88996], [-117.41272, 33.89], [-117.41254, 33.89021], [-117.41235, 33.89029], [-117.41194, 33.89031], [-117.41195, 33.88993], [-117.41184, 33.88988], [-117.41186, 33.88968], [-117.41174, 33.88961], [-117.41173, 33.88952], [-117.41159, 33.88956], [-117.41158, 33.88938], [-117.41133, 33.88943], [-117.41144, 33.88925], [-117.4112, 33.88913], [-117.41128, 33.88888], [-117.41085, 33.88867], [-117.41085, 33.88845], [-117.4106, 33.88852], [-117.41048, 33.88846], [-117.41045, 33.88823], [-117.41044, 33.88823], [-117.41021, 33.88855], [-117.40998, 33.88863], [-117.40985, 33.88821], [-117.40949, 33.88808], [-117.40925, 33.88786], [-117.4093, 33.88773], [-117.40977, 33.88755], [-117.40989, 33.88734], [-117.4097, 33.88701], [-117.40964, 33.88694], [-117.41085, 33.88738], [-117.41231, 33.88798], [-117.41291, 33.88834], [-117.41352, 33.88872], [-117.41408, 33.88914], [-117.41462, 33.88949], [-117.41584, 33.89039]]], [[[-117.42825, 33.89828], [-117.42551, 33.89984], [-117.42507, 33.89982], [-117.42447, 33.89968], [-117.42413, 33.89972], [-117.42387, 33.89991], [-117.42313, 33.90089], [-117.42295, 33.9013], [-117.42102, 33.9024], [-117.41746, 33.90445], [-117.41221, 33.89813], [-117.41103, 33.89667], [-117.41409, 33.89496], [-117.41445, 33.89493], [-117.41478, 33.89496], [-117.41517, 33.89544], [-117.41526, 33.89538], [-117.41851, 33.89932], [-117.42036, 33.89826], [-117.41811, 33.89551], [-117.41837, 33.89535], [-117.4186, 33.89529], [-117.41899, 33.89581], [-117.42006, 33.89559], [-117.42029, 33.89534], [-117.42021, 33.89448], [-117.42012, 33.89439], [-117.41995, 33.89439], [-117.42013, 33.89428], [-117.42019, 33.89428], [-117.42026, 33.89429], [-117.4205, 33.8944], [-117.42072, 33.89443], [-117.42092, 33.89442], [-117.42108, 33.89436], [-117.42117, 33.8943], [-117.42124, 33.89421], [-117.42129, 33.89411], [-117.42141, 33.89401], [-117.42153, 33.89405], [-117.42195, 33.89414], [-117.42262, 33.89437], [-117.42282, 33.89463], [-117.42312, 33.89445], [-117.42341, 33.8946], [-117.42361, 33.89468], [-117.42387, 33.89474], [-117.4243, 33.89469], [-117.42455, 33.89476], [-117.42507, 33.89494], [-117.42563, 33.89526], [-117.426, 33.89556], [-117.4265, 33.89614], [-117.42825, 33.89828]]], [[[-117.4211, 33.89413], [-117.42104, 33.89421], [-117.42094, 33.89427], [-117.42079, 33.8943], [-117.42061, 33.89428], [-117.4203, 33.89417], [-117.42015, 33.89415], [-117.42014, 33.8941], [-117.41976, 33.89373], [-117.4193, 33.89373], [-117.41907, 33.89345], [-117.41869, 33.89345], [-117.41845, 33.89311], [-117.41809, 33.8932], [-117.41755, 33.89264], [-117.41759, 33.89239], [-117.418, 33.89201], [-117.41868, 33.89265], [-117.41885, 33.89297], [-117.4192, 33.8931], [-117.41938, 33.89329], [-117.41972, 33.89351], [-117.41991, 33.89358], [-117.42044, 33.89369], [-117.42069, 33.89379], [-117.42107, 33.89392], [-117.4211, 33.89413]]]]}	Open Access 1	13493	California Citrus State Historic Park	1455	204	California Department of Parks and Recreation 48	State 5	State Agency 5	http://www.parks.ca.gov/	California Department of Parks and Recreation 9	204	California Department of Parks and Recreation 47	State 5	State Agency 5	http://www.parks.ca.gov/?page_id=649	Riverside 10	252.338	California Citrus SHP	1984	State Historic or Cultural Area 132	4

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