calands: units_with_maps: 1 row where ACCESS_TYP = 1, DES

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

1 row where ACCESS_TYP = 1, DES_TP = 1410 and LAYER = 2

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
16511	16511	16510	{"type": "MultiPolygon", "coordinates": [[[[-117.42036, 33.89827], [-117.41851, 33.89932], [-117.4162, 33.8965], [-117.41663, 33.89624], [-117.41665, 33.89616], [-117.41647, 33.89589], [-117.41644, 33.89575], [-117.41647, 33.89559], [-117.41663, 33.89533], [-117.41535, 33.89528], [-117.4153, 33.89523], [-117.41665, 33.89524], [-117.41632, 33.89488], [-117.41609, 33.89488], [-117.41566, 33.89478], [-117.41492, 33.89449], [-117.41484, 33.89459], [-117.41385, 33.89471], [-117.41322, 33.89429], [-117.41256, 33.89429], [-117.41204, 33.89435], [-117.412, 33.89406], [-117.41183, 33.89388], [-117.41166, 33.89379], [-117.41111, 33.89291], [-117.41054, 33.89225], [-117.4102, 33.89208], [-117.41, 33.89204], [-117.40959, 33.89169], [-117.4093, 33.89168], [-117.40904, 33.89161], [-117.40943, 33.89155], [-117.40951, 33.8914], [-117.40941, 33.89114], [-117.4096, 33.89087], [-117.40925, 33.89053], [-117.40871, 33.89016], [-117.40837, 33.88975], [-117.40834, 33.8893], [-117.40809, 33.88889], [-117.40735, 33.88827], [-117.40711, 33.88799], [-117.40725, 33.88721], [-117.40755, 33.88702], [-117.4097, 33.88701], [-117.40989, 33.88734], [-117.40977, 33.88754], [-117.4093, 33.88773], [-117.40926, 33.88786], [-117.40949, 33.88808], [-117.40985, 33.88821], [-117.40998, 33.88863], [-117.41021, 33.88855], [-117.41045, 33.88821], [-117.41049, 33.88849], [-117.4106, 33.88852], [-117.41085, 33.88845], [-117.41084, 33.88867], [-117.41128, 33.88888], [-117.41121, 33.88913], [-117.41144, 33.88925], [-117.41134, 33.88943], [-117.41159, 33.88938], [-117.4116, 33.88955], [-117.41174, 33.88952], [-117.41175, 33.88963], [-117.41186, 33.88968], [-117.41184, 33.88987], [-117.41195, 33.88993], [-117.41194, 33.89031], [-117.41236, 33.89029], [-117.41254, 33.89021], [-117.41272, 33.89], [-117.41285, 33.88995], [-117.41287, 33.89013], [-117.413, 33.89022], [-117.41309, 33.89036], [-117.41332, 33.89056], [-117.4133, 33.8907], [-117.41341, 33.89088], [-117.41333, 33.891], [-117.41336, 33.89147], [-117.4133, 33.89158], [-117.4134, 33.89163], [-117.41354, 33.89164], [-117.4135, 33.89185], [-117.41376, 33.89199], [-117.41404, 33.89198], [-117.4144, 33.89203], [-117.41451, 33.89196], [-117.41431, 33.89159], [-117.41442, 33.89158], [-117.41441, 33.89148], [-117.41446, 33.89129], [-117.41441, 33.89119], [-117.41443, 33.89103], [-117.41431, 33.89089], [-117.41431, 33.89082], [-117.41447, 33.89082], [-117.41453, 33.8907], [-117.41438, 33.89054], [-117.41427, 33.89011], [-117.41449, 33.89053], [-117.41464, 33.89057], [-117.41472, 33.89067], [-117.41473, 33.89083], [-117.41482, 33.89098], [-117.41493, 33.89086], [-117.415, 33.89084], [-117.4151, 33.89065], [-117.41511, 33.8908], [-117.41518, 33.89084], [-117.41508, 33.89094], [-117.41511, 33.89106], [-117.41541, 33.89094], [-117.41584, 33.89039], [-117.41797, 33.89199], [-117.418, 33.89201], [-117.41759, 33.89239], [-117.41755, 33.89263], [-117.41808, 33.8932], [-117.41845, 33.89311], [-117.41869, 33.89345], [-117.41907, 33.89345], [-117.4193, 33.89373], [-117.41976, 33.89373], [-117.42014, 33.8941], [-117.42015, 33.89415], [-117.42003, 33.89418], [-117.41986, 33.89428], [-117.41995, 33.89439], [-117.42012, 33.89439], [-117.42021, 33.89448], [-117.42029, 33.89534], [-117.42006, 33.89559], [-117.41899, 33.89581], [-117.4186, 33.89529], [-117.41837, 33.89535], [-117.41812, 33.89552], [-117.42036, 33.89827]]], [[[-117.42232, 33.90418], [-117.41881, 33.90616], [-117.41756, 33.90463], [-117.42107, 33.90265], [-117.42232, 33.90418]]], [[[-117.42967, 33.90001], [-117.42254, 33.90406], [-117.42128, 33.90253], [-117.42311, 33.90146], [-117.42331, 33.90095], [-117.42404, 33.89999], [-117.42415, 33.8999], [-117.42428, 33.89985], [-117.42441, 33.89984], [-117.42454, 33.89986], [-117.42466, 33.89992], [-117.42483, 33.89998], [-117.42567, 33.90001], [-117.4284, 33.89846], [-117.42967, 33.90001]]]]}	Open Access 1	30006	California Citrus State Historic Park	16687	1279	Riverside, City of 189	City 2	City Agency 2	http://www.riversideca.gov/park_rec/	City 2	1279	Riverside, City of 185	City 2	City Agency 2		Riverside 10	193.189	California Citrus SHP	1984	None 1410

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