calands: units_with_maps: 11 rows where ACCESS_TYP = 2, COUNTY = 4 and DES

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

11 rows where ACCESS_TYP = 2, COUNTY = 4 and DES_TP = 16

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	DES_TP	GAP_STS
1578	1578	1577	{"type": "Polygon", "coordinates": [[[-117.18285, 33.40983], [-117.18281, 33.41292], [-117.17805, 33.4133], [-117.17813, 33.40996], [-117.18285, 33.40983]]]}	Restricted Access 2	47760	Rainbow Preserve	31565	7024	Land to Sea Conservancy 388	Non Profit 6	Non Profit - Conservation 12	http://www.landtosea.org/index.html	Non Governmental Organization 10	3022	Fallbrook Land Conservancy 336	Non Profit 6	Non Profit - Land Trust 10		San Diego 4	38.788	Rainbow Preserve	Private Conservation 16	2
4216	4216	4215	{"type": "Polygon", "coordinates": [[[-117.39755, 33.44539], [-117.38308, 33.44537], [-117.36359, 33.44529], [-117.36342, 33.43052], [-117.38823, 33.43027], [-117.389, 33.43025], [-117.38944, 33.43083], [-117.39484, 33.43788], [-117.39755, 33.44539]]]}	Restricted Access 2	47758	Margarita Peak Preserve	31564	3022	Fallbrook Land Conservancy 339	Non Profit 6	Non Profit - Land Trust 10	http://www.fallbrooklandconservancy.org/	Non Governmental Organization 10	3022	Fallbrook Land Conservancy 336	Non Profit 6	Non Profit - Land Trust 10		San Diego 4	1165.479	Margarita Peak Preserve	Private Conservation 16	2
5393	5393	5392	{"type": "Polygon", "coordinates": [[[-116.80676, 32.87373], [-116.80265, 32.87367], [-116.8023, 32.85874], [-116.80627, 32.85879], [-116.80663, 32.86644], [-116.80676, 32.87373]]]}	Restricted Access 2	47898	Peutz Creek Preserve	31861	3206	San Diego River Park Foundation 804	Non Profit 6	Non Profit - Conservation 12	http://sandiegoriver.org/	Non Governmental Organization 10	3206	San Diego River Park Foundation 784	Non Profit 6	Non Profit - Conservation 12		San Diego 4	156.957	Peutz Creek Preserve	Private Conservation 16	2
5394	5394	5393	{"type": "Polygon", "coordinates": [[[-116.66647, 32.96362], [-116.66615, 32.96362], [-116.66613, 32.96401], [-116.66421, 32.96406], [-116.66329, 32.96512], [-116.66112, 32.96511], [-116.6611, 32.96361], [-116.66364, 32.96362], [-116.66451, 32.96339], [-116.66476, 32.96328], [-116.66507, 32.96309], [-116.66533, 32.96298], [-116.66555, 32.963], [-116.66584, 32.96322], [-116.66599, 32.96323], [-116.66612, 32.96329], [-116.66623, 32.96337], [-116.6663, 32.96347], [-116.66644, 32.96353], [-116.66647, 32.96362]]]}	Restricted Access 2	47899	Boulder Creek Preserve	31862	3206	San Diego River Park Foundation 804	Non Profit 6	Non Profit - Conservation 12	http://sandiegoriver.org/	Non Governmental Organization 10	3206	San Diego River Park Foundation 784	Non Profit 6	Non Profit - Conservation 12		San Diego 4	15.037	Boulder Creek Preserve	Private Conservation 16	2
5395	5395	5394	{"type": "Polygon", "coordinates": [[[-116.66092, 33.0459], [-116.66084, 33.04923], [-116.6651, 33.04926], [-116.66506, 33.05292], [-116.65653, 33.05293], [-116.65227, 33.05291], [-116.65232, 33.04918], [-116.65233, 33.04202], [-116.64727, 33.04204], [-116.64767, 33.04131], [-116.64771, 33.04121], [-116.64771, 33.0411], [-116.64766, 33.04089], [-116.64766, 33.04078], [-116.6477, 33.04058], [-116.64766, 33.04037], [-116.64769, 33.04027], [-116.64776, 33.04019], [-116.64805, 33.03994], [-116.64812, 33.03986], [-116.64816, 33.03976], [-116.64815, 33.03965], [-116.64798, 33.03931], [-116.64799, 33.03924], [-116.64802, 33.03918], [-116.64825, 33.03902], [-116.6483, 33.03894], [-116.65227, 33.03896], [-116.65257, 33.03929], [-116.65264, 33.03932], [-116.65433, 33.03932], [-116.65434, 33.04021], [-116.65646, 33.04022], [-116.65648, 33.04229], [-116.66092, 33.04229], [-116.66092, 33.0459]]]}	Restricted Access 2	47900	Eagle Peak Ranch	31863	3206	San Diego River Park Foundation 804	Non Profit 6	Non Profit - Conservation 12	http://sandiegoriver.org/	Non Governmental Organization 10	3206	San Diego River Park Foundation 784	Non Profit 6	Non Profit - Conservation 12		San Diego 4	335.398	Eagle Peak Ranch	Private Conservation 16	2
5890	5890	5889	{"type": "Polygon", "coordinates": [[[-116.83991, 32.9052], [-116.83982, 32.91649], [-116.8236, 32.91642], [-116.82363, 32.90747], [-116.82362, 32.90223], [-116.83778, 32.90156], [-116.83777, 32.90524], [-116.83991, 32.9052]]]}	Restricted Access 2	46780	El Cajon Mountain Preserve	31859	3206	San Diego River Park Foundation 804	Non Profit 6	Non Profit - Conservation 12	http://sandiegoriver.org/	Non Governmental Organization 10	3206	San Diego River Park Foundation 784	Non Profit 6	Non Profit - Conservation 12		San Diego 4	588.392	El Cajon Mtn. Preserve	Private Conservation 16	2
6251	6251	6250	{"type": "MultiPolygon", "coordinates": [[[[-116.68093, 32.60085], [-116.68055, 32.60089], [-116.68054, 32.60089], [-116.68054, 32.60089], [-116.68093, 32.60085]]], [[[-116.68153, 32.60102], [-116.68153, 32.60106], [-116.68151, 32.60109], [-116.68151, 32.60109], [-116.68151, 32.6011], [-116.6815, 32.60111], [-116.68153, 32.60102], [-116.68152, 32.60097], [-116.68149, 32.60092], [-116.68139, 32.60088], [-116.68144, 32.60089], [-116.68147, 32.6009], [-116.68149, 32.60092], [-116.68152, 32.60097], [-116.68153, 32.60102]]], [[[-116.68378, 32.60165], [-116.68372, 32.60158], [-116.68369, 32.60157], [-116.68364, 32.60157], [-116.68358, 32.60161], [-116.68362, 32.60158], [-116.68364, 32.60157], [-116.68366, 32.60157], [-116.68369, 32.60157], [-116.68372, 32.60158], [-116.68375, 32.60159], [-116.68378, 32.60165]]], [[[-116.68386, 32.60207], [-116.68385, 32.60192], [-116.68383, 32.60185], [-116.68384, 32.60189], [-116.68386, 32.60194], [-116.68386, 32.60207]]], [[[-116.68386, 32.60209], [-116.68386, 32.60209], [-116.68386, 32.60211], [-116.68386, 32.60209]]], [[[-116.68202, 32.6024], [-116.68181, 32.60235], [-116.68154, 32.60236], [-116.68179, 32.60235], [-116.68182, 32.60236], [-116.68187, 32.60236], [-116.68202, 32.6024]]], [[[-116.68384, 32.60247], [-116.68384, 32.60249], [-116.68383, 32.60251], [-116.68383, 32.60251], [-116.68384, 32.60247]]], [[[-116.68435, 32.60337], [-116.68425, 32.60331], [-116.68408, 32.60322], [-116.68422, 32.60329], [-116.68432, 32.60334], [-116.68435, 32.60337]]], [[[-116.68439, 32.6034], [-116.68438, 32.60339], [-116.68438, 32.60339], [-116.68439, 32.6034]]], [[[-116.68669, 32.60192], [-116.68659, 32.60417], [-116.68563, 32.60407], [-116.68538, 32.604], [-116.68518, 32.60389], [-116.68441, 32.60326], [-116.68397, 32.60303], [-116.68394, 32.60299], [-116.68386, 32.60281], [-116.68385, 32.60276], [-116.68397, 32.60248], [-116.68399, 32.60197], [-116.6839, 32.6016], [-116.68386, 32.60154], [-116.68378, 32.60148], [-116.68364, 32.60146], [-116.68352, 32.6015], [-116.68325, 32.60182], [-116.68272, 32.60218], [-116.68265, 32.6022], [-116.6821, 32.6023], [-116.6818, 32.60224], [-116.68147, 32.60225], [-116.6814, 32.60224], [-116.68107, 32.60191], [-116.68104, 32.60186], [-116.68103, 32.60179], [-116.68104, 32.60174], [-116.68116, 32.60151], [-116.6816, 32.60118], [-116.68166, 32.60108], [-116.68166, 32.60098], [-116.68249, 32.60098], [-116.6825, 32.60053], [-116.68293, 32.60077], [-116.68338, 32.60096], [-116.68669, 32.60192]]]]}	Restricted Access 2	1326	Conservation Fund	17596	3087	The Conservation Fund - California 675	Non Profit 6	Non Profit - Land Trust 10	http://www.conservationfund.org/	Non Governmental Organization 10	3087	The Conservation Fund - California 665	Non Profit 6	Non Profit - Land Trust 10		San Diego 4	23.197	Conservation Fund	Private Conservation 16	2
6275	6275	6274	{"type": "Polygon", "coordinates": [[[-116.88449, 32.9177], [-116.88442, 32.91819], [-116.88434, 32.91843], [-116.88422, 32.91866], [-116.88382, 32.91883], [-116.88374, 32.91886], [-116.88364, 32.91887], [-116.88353, 32.91892], [-116.88342, 32.919], [-116.88329, 32.91915], [-116.88323, 32.91919], [-116.88322, 32.91923], [-116.88261, 32.91942], [-116.88176, 32.91965], [-116.88175, 32.91967], [-116.88048, 32.92002], [-116.87996, 32.92023], [-116.87923, 32.92062], [-116.87894, 32.92081], [-116.87862, 32.92107], [-116.8761, 32.92338], [-116.87568, 32.92378], [-116.87552, 32.92398], [-116.87355, 32.92403], [-116.87354, 32.92387], [-116.87288, 32.92386], [-116.8671, 32.92734], [-116.86707, 32.92253], [-116.86293, 32.92261], [-116.8629, 32.91899], [-116.85859, 32.91904], [-116.84121, 32.91914], [-116.84119, 32.9155], [-116.85857, 32.91537], [-116.85906, 32.91535], [-116.86072, 32.91536], [-116.86073, 32.91535], [-116.86072, 32.91264], [-116.86927, 32.9126], [-116.87363, 32.91259], [-116.87362, 32.91458], [-116.88181, 32.91446], [-116.88184, 32.91632], [-116.88279, 32.91634], [-116.88275, 32.91768], [-116.88449, 32.9177]]]}	Restricted Access 2	1366	Silverwood Wildlife Sanctuary	25502	3064	San Diego Audubon Society 831	Non Profit 6	Non Profit - Conservation 12	http://www.sandiegoaudubon.org/	Non Governmental Organization 10	3064	San Diego Audubon Society 811	Non Profit 6	Non Profit - Conservation 12	http://www.sandiegoaudubon.org/our-work/sanctuaries/silverwood-wildlife-sanctuary	San Diego 4	709.224	Silverwood Wildlife Sanctuary	Private Conservation 16	2
6769	6769	6768	{"type": "MultiPolygon", "coordinates": [[[[-116.87056, 32.73716], [-116.86583, 32.73711], [-116.86553, 32.73354], [-116.87, 32.73358], [-116.87056, 32.73716]]], [[[-116.86613, 32.74077], [-116.86448, 32.74076], [-116.86425, 32.74118], [-116.86327, 32.74076], [-116.86447, 32.74076], [-116.86509, 32.73962], [-116.86605, 32.74], [-116.86613, 32.74077]]], [[[-116.86623, 32.74204], [-116.86596, 32.74191], [-116.86619, 32.74151], [-116.86623, 32.74204], [-116.86623, 32.74204]]], [[[-116.86641, 32.74443], [-116.86663, 32.75147], [-116.85716, 32.75147], [-116.85758, 32.7585], [-116.8533, 32.7585], [-116.85303, 32.75147], [-116.85255, 32.75145], [-116.84475, 32.75143], [-116.84406, 32.74438], [-116.84852, 32.74441], [-116.84849, 32.74083], [-116.85084, 32.74079], [-116.85271, 32.74079], [-116.85277, 32.74444], [-116.85672, 32.74447], [-116.86175, 32.74445], [-116.86166, 32.74238], [-116.86163, 32.74219], [-116.86156, 32.74075], [-116.8624, 32.74076], [-116.86172, 32.74196], [-116.86343, 32.7427], [-116.86309, 32.74335], [-116.86309, 32.74337], [-116.86397, 32.74372], [-116.86497, 32.74376], [-116.86514, 32.74342], [-116.86572, 32.74366], [-116.86628, 32.74265], [-116.86641, 32.74443]]]]}	Restricted Access 2	5224	McGinty Mountain Preserve	30607	3091	The Nature Conservancy 63	Non Profit 6	Non Profit - Land Trust 10	http://www.nature.org/	Non Governmental Organization 10	3091	The Nature Conservancy 61	Non Profit 6	Non Profit - Land Trust 10		San Diego 4	577.956	McGinty Mtn. Preserve	Private Conservation 16	2
14781	14781	14780	{"type": "Polygon", "coordinates": [[[-116.94846, 32.64539], [-116.94839, 32.64551], [-116.94804, 32.64538], [-116.94761, 32.64525], [-116.94727, 32.64516], [-116.94683, 32.64507], [-116.94696, 32.64451], [-116.9465, 32.64443], [-116.94654, 32.64432], [-116.94654, 32.64418], [-116.94627, 32.64341], [-116.94628, 32.6433], [-116.94633, 32.64314], [-116.94659, 32.64328], [-116.94692, 32.6434], [-116.94793, 32.64356], [-116.9478, 32.64414], [-116.9478, 32.64431], [-116.94783, 32.64446], [-116.94788, 32.64461], [-116.94795, 32.64473], [-116.94839, 32.64535], [-116.94846, 32.64539]]]}	Restricted Access 2	45168	Little League Ballfields	33364	6074	Home Owners Association - Unknown Name 640	Private 7	Home Owners Association 16		Private 14	6074	Home Owners Association - Unknown Name 629	Private 7	Home Owners Association 15		San Diego 4	6.308	Little League Ballfields	Private Conservation 16	2
14783	14783	14782	{"type": "Polygon", "coordinates": [[[-116.98285, 32.63543], [-116.98278, 32.63553], [-116.98274, 32.63564], [-116.98277, 32.63571], [-116.98272, 32.63579], [-116.98265, 32.63578], [-116.98257, 32.63579], [-116.9824, 32.63586], [-116.98222, 32.63538], [-116.98267, 32.63521], [-116.98278, 32.63525], [-116.98285, 32.63543]]]}	Restricted Access 2	45170	The Breezeway	33355	6074	Home Owners Association - Unknown Name 640	Private 7	Home Owners Association 16		Private 14	6074	Home Owners Association - Unknown Name 629	Private 7	Home Owners Association 15		San Diego 4	0.674	The Breezeway	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]);