calands: units_with_maps: 14 rows where ACCESS_TYP = 3, AGNCY

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

14 rows where ACCESS_TYP = 3, AGNCY_TYP = 12 and COUNTY = 4

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	COUNTY	ACRES	LABEL_NAME	DES_TP	GAP_STS
196	196	195	{"type": "Polygon", "coordinates": [[[-116.80824, 32.84466], [-116.80813, 32.84546], [-116.80736, 32.84567], [-116.80702, 32.84516], [-116.80704, 32.84466], [-116.80824, 32.84466]]]}	No Public Access 3	46830	Palmer Property	30298	3208	Endangered Habitats Conservancy 79	Non Profit 6	Non Profit - Conservation 12	http://www.ehleague.org/EndangeredHabitatsConservancy.html	Non Governmental Organization 10	3208	Endangered Habitats Conservancy 77	Non Profit 6	Non Profit - Conservation 12	San Diego 4	2.548	Palmer Property	Private Conservation 16	2
3308	3308	3307	{"type": "Polygon", "coordinates": [[[-116.87605, 32.81198], [-116.87602, 32.81296], [-116.87303, 32.81508], [-116.87286, 32.81473], [-116.87304, 32.8145], [-116.87303, 32.81413], [-116.87289, 32.81331], [-116.87318, 32.8132], [-116.87335, 32.81308], [-116.87345, 32.81299], [-116.87353, 32.81288], [-116.87364, 32.81257], [-116.87401, 32.81237], [-116.87427, 32.81228], [-116.87453, 32.81222], [-116.87555, 32.8121], [-116.8758, 32.81205], [-116.87605, 32.81198]]]}	No Public Access 3	46828	La Cresta Hills Property	30296	3208	Endangered Habitats Conservancy 79	Non Profit 6	Non Profit - Conservation 12	http://www.ehleague.org/EndangeredHabitatsConservancy.html	Non Governmental Organization 10	3208	Endangered Habitats Conservancy 77	Non Profit 6	Non Profit - Conservation 12	San Diego 4	12.874	La Cresta Hills Property	Private Conservation 16	2
3309	3309	3308	{"type": "Polygon", "coordinates": [[[-116.86574, 32.79365], [-116.86293, 32.79371], [-116.86299, 32.79622], [-116.86104, 32.79623], [-116.861, 32.79604], [-116.85956, 32.79629], [-116.85947, 32.79387], [-116.85842, 32.79388], [-116.85828, 32.78993], [-116.86564, 32.79012], [-116.86574, 32.79365]]]}	No Public Access 3	46829	Michelson Property	30297	3208	Endangered Habitats Conservancy 79	Non Profit 6	Non Profit - Conservation 12	http://www.ehleague.org/EndangeredHabitatsConservancy.html	Non Governmental Organization 10	3208	Endangered Habitats Conservancy 77	Non Profit 6	Non Profit - Conservation 12	San Diego 4	91.593	Michelson Property	Private Conservation 16	2
3313	3313	3312	{"type": "Polygon", "coordinates": [[[-116.86309, 32.80074], [-116.86305, 32.80446], [-116.86307, 32.8054], [-116.85868, 32.80542], [-116.85866, 32.80438], [-116.85442, 32.80443], [-116.85445, 32.80069], [-116.85863, 32.80069], [-116.86309, 32.80074]]]}	No Public Access 3	46834	Ulrich Property	30302	3208	Endangered Habitats Conservancy 79	Non Profit 6	Non Profit - Conservation 12	http://www.ehleague.org/EndangeredHabitatsConservancy.html	Non Governmental Organization 10	3208	Endangered Habitats Conservancy 77	Non Profit 6	Non Profit - Conservation 12	San Diego 4	93.312	Ulrich Property	Private Conservation 16	2
11527	11527	11526	{"type": "Polygon", "coordinates": [[[-116.89504, 32.80952], [-116.89448, 32.80974], [-116.89425, 32.80982], [-116.89392, 32.80989], [-116.89358, 32.80992], [-116.89315, 32.80992], [-116.89296, 32.80991], [-116.89182, 32.80963], [-116.89176, 32.80812], [-116.89229, 32.80568], [-116.89368, 32.8059], [-116.89443, 32.80579], [-116.894, 32.80809], [-116.89504, 32.80952]]]}	No Public Access 3	46835	Walker Priest/La Cresta Property	30303	3208	Endangered Habitats Conservancy 79	Non Profit 6	Non Profit - Conservation 12	http://www.ehleague.org/EndangeredHabitatsConservancy.html	Non Governmental Organization 10	3208	Endangered Habitats Conservancy 77	Non Profit 6	Non Profit - Conservation 12	San Diego 4	25.204	Walker Priest/La Cresta Property	Private Conservation 16	2
11530	11530	11529	{"type": "MultiPolygon", "coordinates": [[[[-116.84201, 32.81202], [-116.84191, 32.8121], [-116.84131, 32.81251], [-116.8413, 32.81202], [-116.84201, 32.81202]]], [[[-116.84567, 32.81198], [-116.84566, 32.81571], [-116.84136, 32.8157], [-116.84133, 32.81349], [-116.84145, 32.81348], [-116.84145, 32.81308], [-116.84132, 32.81295], [-116.84132, 32.81279], [-116.84209, 32.81225], [-116.84236, 32.81201], [-116.84567, 32.81198]]]]}	No Public Access 3	46826	Harbison Canyon Property	30294	3208	Endangered Habitats Conservancy 79	Non Profit 6	Non Profit - Conservation 12	http://www.ehleague.org/EndangeredHabitatsConservancy.html	Non Governmental Organization 10	3208	Endangered Habitats Conservancy 77	Non Profit 6	Non Profit - Conservation 12	San Diego 4	40.355	Harbison Canyon Property	Private Conservation 16	2
11539	11539	11538	{"type": "Polygon", "coordinates": [[[-116.89741, 32.80669], [-116.89677, 32.80745], [-116.89737, 32.80782], [-116.89656, 32.80874], [-116.8966, 32.80905], [-116.89615, 32.80913], [-116.89571, 32.80924], [-116.89504, 32.80952], [-116.894, 32.80809], [-116.89443, 32.80579], [-116.89458, 32.80576], [-116.89741, 32.80669]]]}	No Public Access 3	46831	Sarjay/La Cresta Property	30299	3208	Endangered Habitats Conservancy 79	Non Profit 6	Non Profit - Conservation 12	http://www.ehleague.org/EndangeredHabitatsConservancy.html	Non Governmental Organization 10	3208	Endangered Habitats Conservancy 77	Non Profit 6	Non Profit - Conservation 12	San Diego 4	21.548	Sarjay/La Cresta Property	Private Conservation 16	2
11540	11540	11539	{"type": "Polygon", "coordinates": [[[-116.88944, 32.80854], [-116.88892, 32.80921], [-116.88842, 32.809], [-116.8881, 32.80881], [-116.88819, 32.80758], [-116.88937, 32.8079], [-116.88944, 32.80854]]]}	No Public Access 3	46832	Saxena/La Cresta Property	30300	3208	Endangered Habitats Conservancy 79	Non Profit 6	Non Profit - Conservation 12	http://www.ehleague.org/EndangeredHabitatsConservancy.html	Non Governmental Organization 10	3208	Endangered Habitats Conservancy 77	Non Profit 6	Non Profit - Conservation 12	San Diego 4	4.044	Saxena/La Cresta Property	Private Conservation 16	2
11541	11541	11540	{"type": "Polygon", "coordinates": [[[-116.88975, 32.80209], [-116.88488, 32.80571], [-116.88212, 32.80795], [-116.88059, 32.80794], [-116.88059, 32.80435], [-116.88489, 32.80431], [-116.88492, 32.80091], [-116.87626, 32.80088], [-116.87625, 32.79348], [-116.8719, 32.79355], [-116.87185, 32.7905], [-116.86734, 32.79039], [-116.86564, 32.79011], [-116.86281, 32.79004], [-116.86273, 32.78651], [-116.85814, 32.78609], [-116.8582, 32.78275], [-116.86725, 32.78347], [-116.86725, 32.78691], [-116.87625, 32.78778], [-116.8847, 32.78775], [-116.88471, 32.78835], [-116.88466, 32.80066], [-116.88467, 32.80066], [-116.88552, 32.79991], [-116.88576, 32.79977], [-116.88578, 32.79976], [-116.88582, 32.79981], [-116.88587, 32.79984], [-116.88598, 32.79984], [-116.88607, 32.79978], [-116.88609, 32.79973], [-116.88609, 32.79967], [-116.88613, 32.79963], [-116.88632, 32.79956], [-116.88653, 32.79952], [-116.88688, 32.79951], [-116.88723, 32.79957], [-116.88744, 32.79964], [-116.88765, 32.79975], [-116.88855, 32.80046], [-116.88872, 32.80056], [-116.8889, 32.80061], [-116.88896, 32.80068], [-116.88895, 32.80074], [-116.88882, 32.80092], [-116.88881, 32.801], [-116.88883, 32.80115], [-116.88889, 32.80129], [-116.88902, 32.80148], [-116.88925, 32.80165], [-116.88975, 32.80209]]]}	No Public Access 3	46833	South Crest Properties	30301	3208	Endangered Habitats Conservancy 79	Non Profit 6	Non Profit - Conservation 12	http://www.ehleague.org/EndangeredHabitatsConservancy.html	Non Governmental Organization 10	3208	Endangered Habitats Conservancy 77	Non Profit 6	Non Profit - Conservation 12	San Diego 4	586.423	South Crest Properties	Private Conservation 16	2
11544	11544	11543	{"type": "Polygon", "coordinates": [[[-117.19588, 33.05838], [-117.19584, 33.06309], [-117.19526, 33.06178], [-117.19482, 33.0613], [-117.19421, 33.06309], [-117.1936, 33.06368], [-117.19386, 33.06453], [-117.19343, 33.06485], [-117.19359, 33.06456], [-117.19334, 33.06393], [-117.19279, 33.06361], [-117.19236, 33.06362], [-117.19211, 33.06312], [-117.19045, 33.06383], [-117.18724, 33.06429], [-117.18724, 33.06097], [-117.19095, 33.0591], [-117.19135, 33.05875], [-117.19134, 33.05841], [-117.19588, 33.05838]]]}	No Public Access 3	46822	Bridges Property	30290	3208	Endangered Habitats Conservancy 79	Non Profit 6	Non Profit - Conservation 12	http://www.ehleague.org/EndangeredHabitatsConservancy.html	Non Governmental Organization 10	3208	Endangered Habitats Conservancy 77	Non Profit 6	Non Profit - Conservation 12	San Diego 4	96.326	Bridges Property	Private Conservation 16	2
11545	11545	11544	{"type": "Polygon", "coordinates": [[[-116.83922, 32.83545], [-116.83782, 32.83791], [-116.83786, 32.83795], [-116.83772, 32.83808], [-116.83739, 32.83845], [-116.83729, 32.83853], [-116.83713, 32.8386], [-116.83711, 32.83786], [-116.83671, 32.83746], [-116.82396, 32.83749], [-116.82414, 32.83012], [-116.83656, 32.83029], [-116.83668, 32.83206], [-116.83671, 32.83431], [-116.83922, 32.83545]]]}	No Public Access 3	46823	Gibson Property	30291	3208	Endangered Habitats Conservancy 79	Non Profit 6	Non Profit - Conservation 12	http://www.ehleague.org/EndangeredHabitatsConservancy.html	Non Governmental Organization 10	3208	Endangered Habitats Conservancy 77	Non Profit 6	Non Profit - Conservation 12	San Diego 4	251.399	Gibson Property	Private Conservation 16	2
11546	11546	11545	{"type": "Polygon", "coordinates": [[[-116.89021, 32.80935], [-116.89021, 32.80935], [-116.88892, 32.80921], [-116.88944, 32.80854], [-116.89012, 32.80849], [-116.89021, 32.80935]]]}	No Public Access 3	46824	Guyot/La Cresta Property	30292	3208	Endangered Habitats Conservancy 79	Non Profit 6	Non Profit - Conservation 12	http://www.ehleague.org/EndangeredHabitatsConservancy.html	Non Governmental Organization 10	3208	Endangered Habitats Conservancy 77	Non Profit 6	Non Profit - Conservation 12	San Diego 4	1.954	Guyot/La Cresta Property	Private Conservation 16	2
11547	11547	11546	{"type": "Polygon", "coordinates": [[[-116.90449, 32.86918], [-116.90258, 32.86929], [-116.90321, 32.8702], [-116.90357, 32.87149], [-116.90313, 32.87153], [-116.90277, 32.87162], [-116.90228, 32.87168], [-116.89941, 32.871], [-116.89778, 32.87065], [-116.89597, 32.87065], [-116.89596, 32.86588], [-116.89775, 32.86452], [-116.89789, 32.8644], [-116.89813, 32.86414], [-116.89845, 32.86372], [-116.89896, 32.86285], [-116.90128, 32.86311], [-116.90141, 32.86392], [-116.90299, 32.86415], [-116.90314, 32.86538], [-116.90379, 32.8653], [-116.90449, 32.86918]]]}	No Public Access 3	46825	Hanson Property	30293	3208	Endangered Habitats Conservancy 79	Non Profit 6	Non Profit - Conservation 12	http://www.ehleague.org/EndangeredHabitatsConservancy.html	Non Governmental Organization 10	3208	Endangered Habitats Conservancy 77	Non Profit 6	Non Profit - Conservation 12	San Diego 4	141.528	Hanson Property	Private Conservation 16	2
14177	14177	14176	{"type": "MultiPolygon", "coordinates": [[[[-116.83661, 32.82754], [-116.83656, 32.83029], [-116.82414, 32.83012], [-116.82764, 32.82602], [-116.82778, 32.82508], [-116.82831, 32.82471], [-116.83026, 32.82475], [-116.83027, 32.82503], [-116.83055, 32.82502], [-116.83059, 32.82476], [-116.83239, 32.8248], [-116.8324, 32.82659], [-116.8347, 32.82661], [-116.8361, 32.82754], [-116.83622, 32.82758], [-116.83634, 32.8276], [-116.83647, 32.82759], [-116.83661, 32.82754]]], [[[-116.83662, 32.82663], [-116.83661, 32.82732], [-116.83649, 32.82741], [-116.83635, 32.82744], [-116.83626, 32.82742], [-116.83617, 32.82739], [-116.83504, 32.82663], [-116.83662, 32.82663]]]]}	No Public Access 3	46827	Kemerko Property	30295	3208	Endangered Habitats Conservancy 79	Non Profit 6	Non Profit - Conservation 12	http://www.ehleague.org/EndangeredHabitatsConservancy.html	Non Governmental Organization 10	3208	Endangered Habitats Conservancy 77	Non Profit 6	Non Profit - Conservation 12	San Diego 4	122.681	Kemerko Property	Private Conservation 16	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]);