calands: units_with_maps: 2 rows where ACCESS_TYP = 1, DES_TP = 4 and MNG

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

2 rows where ACCESS_TYP = 1, DES_TP = 4 and MNG_AGENCY = 165

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
6298	6298	6297	{"type": "MultiPolygon", "coordinates": [[[[-117.35822, 33.80178], [-117.35821, 33.80646], [-117.35818, 33.8076], [-117.35807, 33.80825], [-117.35787, 33.80896], [-117.35779, 33.8093], [-117.35773, 33.80975], [-117.35771, 33.81021], [-117.35791, 33.81283], [-117.3581, 33.81404], [-117.35812, 33.81452], [-117.34499, 33.8145], [-117.34509, 33.80721], [-117.34514, 33.79991], [-117.35388, 33.79993], [-117.35386, 33.80178], [-117.35822, 33.80178]]], [[[-117.36258, 33.8088], [-117.36255, 33.81453], [-117.35849, 33.81452], [-117.35846, 33.81401], [-117.35827, 33.8128], [-117.35807, 33.81031], [-117.35807, 33.80999], [-117.35811, 33.80956], [-117.35817, 33.80924], [-117.35828, 33.80883], [-117.36258, 33.8088]]]]}	Open Access 1	1420	Harford Springs Reserve	9495	315	Riverside, County of 169	County 3	County Agency 3	http://www.rivcoparks.org/	County 3	315	Riverside, County of 165	County 3	County Agency 3	http://www.rivcoparks.org/?s=Harford+Springs+Reserve	Riverside 10	523.302	Harford Springs Reserve	0	Local Conservation Area 4	2
15587	15587	15586	{"type": "Polygon", "coordinates": [[[-117.25406, 33.55451], [-117.25253, 33.56096], [-117.24683, 33.5616], [-117.24552, 33.56023], [-117.24566, 33.55849], [-117.24724, 33.55612], [-117.24602, 33.55264], [-117.24327, 33.55101], [-117.24324, 33.54786], [-117.24168, 33.54458], [-117.24149, 33.54456], [-117.24152, 33.54438], [-117.24157, 33.54416], [-117.24171, 33.54383], [-117.24191, 33.54353], [-117.24204, 33.54337], [-117.24225, 33.54317], [-117.2408, 33.54033], [-117.23339, 33.54632], [-117.22864, 33.54271], [-117.22887, 33.54253], [-117.22887, 33.54252], [-117.22643, 33.54067], [-117.22561, 33.54005], [-117.22537, 33.54023], [-117.2253, 33.54017], [-117.226, 33.53963], [-117.22419, 33.53825], [-117.22281, 33.53721], [-117.22209, 33.53775], [-117.21106, 33.52939], [-117.21102, 33.52829], [-117.21103, 33.52817], [-117.21106, 33.528], [-117.21112, 33.52783], [-117.2112, 33.52767], [-117.21131, 33.5275], [-117.21143, 33.52738], [-117.21158, 33.52724], [-117.21173, 33.52713], [-117.21191, 33.52704], [-117.21221, 33.52692], [-117.21278, 33.52679], [-117.213, 33.5267], [-117.21319, 33.52659], [-117.21335, 33.52648], [-117.2135, 33.52634], [-117.21363, 33.52619], [-117.21374, 33.52601], [-117.21385, 33.52572], [-117.21409, 33.52468], [-117.21437, 33.52406], [-117.21445, 33.52382], [-117.21448, 33.52363], [-117.21448, 33.52344], [-117.21445, 33.52325], [-117.21439, 33.52308], [-117.21866, 33.52143], [-117.22166, 33.51869], [-117.21882, 33.51411], [-117.21989, 33.51229], [-117.22153, 33.51238], [-117.22236, 33.50986], [-117.22285, 33.5099], [-117.22321, 33.50995], [-117.22368, 33.51004], [-117.22428, 33.51022], [-117.22491, 33.51048], [-117.22532, 33.5107], [-117.22566, 33.51092], [-117.22599, 33.51116], [-117.22692, 33.51191], [-117.22726, 33.51215], [-117.22766, 33.51238], [-117.22809, 33.5126], [-117.22861, 33.51281], [-117.22889, 33.51291], [-117.23077, 33.51346], [-117.23127, 33.51364], [-117.2316, 33.51379], [-117.23215, 33.51409], [-117.23256, 33.51437], [-117.23298, 33.51471], [-117.23341, 33.51513], [-117.2337, 33.51489], [-117.23662, 33.51215], [-117.23969, 33.51163], [-117.24188, 33.50703], [-117.24828, 33.50454], [-117.25383, 33.51734], [-117.25377, 33.5195], [-117.24323, 33.52422], [-117.24132, 33.52305], [-117.24029, 33.52069], [-117.23797, 33.5209], [-117.23768, 33.51976], [-117.23719, 33.51948], [-117.23606, 33.52001], [-117.23536, 33.51836], [-117.23254, 33.52021], [-117.2309, 33.51924], [-117.23011, 33.51651], [-117.22905, 33.51536], [-117.22688, 33.51494], [-117.22433, 33.51347], [-117.22264, 33.51402], [-117.2206, 33.51356], [-117.22059, 33.51357], [-117.22518, 33.51826], [-117.22448, 33.51937], [-117.22218, 33.51968], [-117.2206, 33.52139], [-117.22061, 33.5214], [-117.22413, 33.52116], [-117.224, 33.52437], [-117.22322, 33.52492], [-117.2242, 33.52581], [-117.22559, 33.5261], [-117.22588, 33.52645], [-117.22633, 33.52759], [-117.22621, 33.52965], [-117.22676, 33.53007], [-117.2286, 33.52873], [-117.23179, 33.5306], [-117.2308, 33.53201], [-117.23041, 33.53267], [-117.23223, 33.53295], [-117.23305, 33.53376], [-117.23405, 33.53327], [-117.23607, 33.53089], [-117.2367, 33.53318], [-117.23592, 33.53433], [-117.23733, 33.53479], [-117.23864, 33.53444], [-117.23992, 33.53463], [-117.23958, 33.53654], [-117.24223, 33.53693], [-117.25139, 33.55059], [-117.25406, 33.55451]]]}	Open Access 1	12823	Santa Rosa Plateau Ecological Reserve	9507	315	Riverside, County of 169	County 3	County Agency 3	http://www.rivcoparks.org/	County 3	315	Riverside, County of 165	County 3	County Agency 3	http://www.rivcoparks.org/education/santa-rosa-plateau/santa-rosa-plateau/	Riverside 10	1994.248	Santa Rosa Plateau ER	1994	Local Conservation Area 4	2

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