calands: units_with_maps: 3 rows where DES_TP = 4, LAYER = 2 and MNG

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

3 rows where DES_TP = 4, LAYER = 2 and MNG_AGENCY = 101

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
7371	7371	7370	{"type": "MultiPolygon", "coordinates": [[[[-116.86639, 32.64508], [-116.85755, 32.65151], [-116.84988, 32.64452], [-116.83978, 32.6535], [-116.84011, 32.64195], [-116.84001, 32.63453], [-116.85687, 32.6339], [-116.86632, 32.63397], [-116.8663, 32.63756], [-116.86637, 32.64162], [-116.86639, 32.64508]]], [[[-116.86655, 32.61902], [-116.86648, 32.62263], [-116.85735, 32.62253], [-116.8575, 32.61887], [-116.85328, 32.61895], [-116.85341, 32.6153], [-116.85765, 32.61523], [-116.85766, 32.61522], [-116.86235, 32.61529], [-116.86229, 32.61895], [-116.86655, 32.61902]]], [[[-116.89127, 32.62103], [-116.88695, 32.62103], [-116.88698, 32.62282], [-116.88243, 32.62281], [-116.88238, 32.62103], [-116.88012, 32.62103], [-116.88014, 32.61181], [-116.88905, 32.61191], [-116.88897, 32.61919], [-116.89126, 32.61923], [-116.89127, 32.62103]]], [[[-116.89403, 32.68807], [-116.88945, 32.68809], [-116.88943, 32.68986], [-116.88507, 32.6899], [-116.88499, 32.6881], [-116.88498, 32.68628], [-116.8872, 32.68625], [-116.88718, 32.68453], [-116.894, 32.68446], [-116.89403, 32.68807]]], [[[-116.9108, 32.60449], [-116.91078, 32.61199], [-116.89349, 32.61196], [-116.8934, 32.60454], [-116.9108, 32.60449]]], [[[-116.9023, 32.67355], [-116.89805, 32.67354], [-116.89802, 32.67032], [-116.90228, 32.6703], [-116.9023, 32.67355]]], [[[-116.92781, 32.66319], [-116.91926, 32.66312], [-116.91924, 32.66405], [-116.91912, 32.66399], [-116.91867, 32.66361], [-116.91849, 32.66338], [-116.91783, 32.66291], [-116.91751, 32.66259], [-116.91698, 32.66218], [-116.91629, 32.66151], [-116.91562, 32.661], [-116.91537, 32.66092], [-116.91511, 32.66091], [-116.91485, 32.66092], [-116.91489, 32.65935], [-116.91629, 32.65938], [-116.91632, 32.65562], [-116.9278, 32.65584], [-116.92781, 32.66319]]], [[[-116.9485, 32.60875], [-116.94821, 32.60883], [-116.94815, 32.60864], [-116.94799, 32.60841], [-116.94773, 32.60837], [-116.9475, 32.6084], [-116.94739, 32.60869], [-116.94739, 32.60906], [-116.94742, 32.60929], [-116.94734, 32.60969], [-116.94734, 32.60992], [-116.94738, 32.61022], [-116.94743, 32.61044], [-116.94749, 32.61058], [-116.9478, 32.61102], [-116.94786, 32.61125], [-116.94789, 32.61154], [-116.94788, 32.61175], [-116.94781, 32.61196], [-116.9477, 32.61218], [-116.94757, 32.61233], [-116.94741, 32.61249], [-116.94719, 32.61264], [-116.94704, 32.61273], [-116.94666, 32.61303], [-116.94652, 32.61342], [-116.94644, 32.61381], [-116.94655, 32.61422], [-116.94661, 32.6148], [-116.94671, 32.61502], [-116.94664, 32.61532], [-116.94647, 32.61551], [-116.94636, 32.61556], [-116.9461, 32.61561], [-116.94598, 32.6156], [-116.94581, 32.61554], [-116.94563, 32.61541], [-116.94524, 32.61528], [-116.94507, 32.61536], [-116.9451, 32.61559], [-116.94526, 32.61583], [-116.94535, 32.61608], [-116.94537, 32.61635], [-116.94531, 32.61658], [-116.94524, 32.61655], [-116.94451, 32.61703], [-116.94436, 32.61718], [-116.94427, 32.61735], [-116.94424, 32.61754], [-116.94426, 32.61802], [-116.94422, 32.61873], [-116.94416, 32.61915], [-116.94408, 32.61957], [-116.94392, 32.62017], [-116.94323, 32.62228], [-116.94298, 32.62294], [-116.94274, 32.62345], [-116.94252, 32.62383], [-116.9422, 32.62431], [-116.94185, 32.62477], [-116.94155, 32.6251], [-116.94113, 32.62552], [-116.94067, 32.62592], [-116.94033, 32.62618], [-116.93446, 32.61192], [-116.93444, 32.61181], [-116.93431, 32.61145], [-116.9337, 32.61008], [-116.93333, 32.60918], [-116.93421, 32.60895], [-116.93327, 32.60677], [-116.93401, 32.60657], [-116.93324, 32.60469], [-116.93298, 32.60475], [-116.93164, 32.60515], [-116.92891, 32.59854], [-116.93933, 32.5955], [-116.93933, 32.59113], [-116.93937, 32.58207], [-116.94513, 32.5821], [-116.94524, 32.59383], [-116.94269, 32.59453], [-116.94534, 32.60102], [-116.94534, 32.60104], [-116.94536, 32.60105], [-116.9485, 32.60875]]], [[[-116.96532, 32.58705], [-116.96529, 32.58711], [-116.96524, 32.58746], [-116.96526, 32.5878], [-116.96532, 32.58792], [-116.96231, 32.5888], [-116.96222, 32.58619], [-116.96221, 32.58429], [-116.96433, 32.58431], [-116.96437, 32.58459], [-116.96435, 32.58468], [-116.96443, 32.58532], [-116.9643, 32.58561], [-116.96436, 32.58577], [-116.96456, 32.58587], [-116.96514, 32.58598], [-116.96514, 32.58611], [-116.96525, 32.58636], [-116.96522, 32.58656], [-116.96532, 32.58705]]], [[[-116.97937, 32.58382], [-116.96896, 32.58686], [-116.9689, 32.5868], [-116.96865, 32.58659], [-116.96838, 32.58631], [-116.96819, 32.58627], [-116.968, 32.58606], [-116.96781, 32.58604], [-116.96723, 32.58604], [-116.96664, 32.5844], [-116.96574, 32.58455], [-116.9656, 32.58432], [-116.96664, 32.58432], [-116.96664, 32.58242], [-116.97107, 32.58246], [-116.97936, 32.58251], [-116.97937, 32.58382]]], [[[-116.98618, 32.61112], [-116.98584, 32.61131], [-116.98592, 32.61153], [-116.98568, 32.61161], [-116.98543, 32.61174], [-116.98533, 32.61174], [-116.98504, 32.61199], [-116.98461, 32.61232], [-116.98453, 32.61251], [-116.98451, 32.61261], [-116.98452, 32.61225], [-116.98456, 32.61219], [-116.9847, 32.61208], [-116.9847, 32.61206], [-116.98466, 32.612], [-116.98446, 32.61187], [-116.98445, 32.61182], [-116.98446, 32.61162], [-116.98449, 32.61153], [-116.98454, 32.61144], [-116.98461, 32.61139], [-116.98463, 32.61135], [-116.98462, 32.61119], [-116.98457, 32.61095], [-116.98458, 32.61089], [-116.98461, 32.61083], [-116.98467, 32.61062], [-116.98478, 32.61049], [-116.98486, 32.61033], [-116.98489, 32.61021], [-116.98496, 32.6101], [-116.98489, 32.60999], [-116.98489, 32.60976], [-116.98502, 32.60993], [-116.98504, 32.60993], [-116.98557, 32.61058], [-116.98618, 32.61112]]], [[[-116.99061, 32.60452], [-116.99046, 32.60532], [-116.99044, 32.60553], [-116.99036, 32.60581], [-116.99001, 32.60644], [-116.98993, 32.60662], [-116.98981, 32.60704], [-116.98935, 32.60734], [-116.98925, 32.60749], [-116.98912, 32.60783], [-116.98913, 32.60813], [-116.98795, 32.60955], [-116.98722, 32.61006], [-116.98659, 32.61084], [-116.98646, 32.61097], [-116.98582, 32.61041], [-116.98531, 32.60978], [-116.98516, 32.60986], [-116.98501, 32.60967], [-116.9852, 32.60968], [-116.98536, 32.60976], [-116.98547, 32.60976], [-116.98566, 32.60973], [-116.98594, 32.60962], [-116.98608, 32.6095], [-116.98621, 32.60935], [-116.98628, 32.60932], [-116.98638, 32.60904], [-116.98655, 32.60894], [-116.98689, 32.60884], [-116.98714, 32.60871], [-116.98726, 32.60852], [-116.98723, 32.6084], [-116.98728, 32.6081], [-116.98732, 32.60803], [-116.98783, 32.60768], [-116.98802, 32.60737], [-116.98804, 32.60681], [-116.98811, 32.60674], [-116.98869, 32.60645], [-116.98882, 32.60631], [-116.98903, 32.60523], [-116.98907, 32.60495], [-116.99061, 32.60452]]]]}	No Public Access 3	47589	Otay Ranch Preserve	31316	1056	Chula Vista, City of 120	City 2	City Agency 2	http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp	City 2	319	San Diego, County of 101	County 3	County Agency 3	http://www.sandiegocounty.gov/parks/openspace/Otay_Ranch.html	San Diego 4	3245.845	Otay Ranch Preserve	Local Conservation Area 4	2
7963	7963	7962	{"type": "MultiPolygon", "coordinates": [[[[-116.96231, 32.5888], [-116.95891, 32.58979], [-116.96013, 32.59278], [-116.95959, 32.59293], [-116.95911, 32.5929], [-116.95864, 32.593], [-116.95789, 32.59309], [-116.95733, 32.59319], [-116.95703, 32.59325], [-116.95686, 32.59339], [-116.95657, 32.59347], [-116.95598, 32.59351], [-116.95514, 32.59365], [-116.95421, 32.59393], [-116.95377, 32.59419], [-116.95265, 32.59474], [-116.95221, 32.59489], [-116.95194, 32.59494], [-116.9508, 32.59216], [-116.95833, 32.58995], [-116.95639, 32.58888], [-116.95595, 32.58857], [-116.9523, 32.58586], [-116.95369, 32.58588], [-116.96222, 32.58619], [-116.96231, 32.5888]]], [[[-116.96197, 32.5973], [-116.96128, 32.5975], [-116.96123, 32.59737], [-116.96109, 32.59724], [-116.96094, 32.5972], [-116.96072, 32.59721], [-116.96053, 32.59726], [-116.96038, 32.59735], [-116.96029, 32.59743], [-116.96024, 32.59751], [-116.9602, 32.59766], [-116.96014, 32.59775], [-116.96003, 32.59785], [-116.95988, 32.59786], [-116.95969, 32.5978], [-116.95952, 32.59771], [-116.95914, 32.59765], [-116.95898, 32.59758], [-116.95875, 32.59759], [-116.95844, 32.59767], [-116.95811, 32.59787], [-116.95753, 32.5982], [-116.95669, 32.59855], [-116.95642, 32.59876], [-116.95623, 32.59892], [-116.95384, 32.59959], [-116.95285, 32.59719], [-116.95353, 32.59743], [-116.95424, 32.59722], [-116.95498, 32.59694], [-116.95604, 32.59641], [-116.95638, 32.5962], [-116.95675, 32.59608], [-116.95783, 32.59581], [-116.9586, 32.59566], [-116.95917, 32.59523], [-116.95938, 32.59502], [-116.96077, 32.59435], [-116.96197, 32.5973]]]]}	Restricted Access 2	47729	Otay Ranch Preserve	31529	1056	Chula Vista, City of 120	City 2	City Agency 2	http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp	City 2	319	San Diego, County of 101	County 3	County Agency 3	http://www.sandiegocounty.gov/parks/openspace/Otay_Ranch.html	San Diego 4	179.037	Otay Ranch Preserve	Local Conservation Area 4	2
13205	13205	13204	{"type": "MultiPolygon", "coordinates": [[[[-116.92352, 32.60821], [-116.9235, 32.61195], [-116.91216, 32.61202], [-116.91078, 32.61199], [-116.91094, 32.61568], [-116.90658, 32.61567], [-116.90666, 32.61927], [-116.90219, 32.61927], [-116.90214, 32.61198], [-116.91078, 32.61199], [-116.9108, 32.60449], [-116.91928, 32.60446], [-116.91928, 32.6082], [-116.92352, 32.60821]]], [[[-116.91632, 32.65562], [-116.91629, 32.65938], [-116.91356, 32.65931], [-116.91311, 32.65864], [-116.91287, 32.65836], [-116.91254, 32.65791], [-116.91207, 32.65716], [-116.91169, 32.65659], [-116.91154, 32.65645], [-116.91128, 32.65626], [-116.91056, 32.65556], [-116.91239, 32.65554], [-116.91632, 32.65562]]]]}	Open Access 1	45236	Otay Ranch Preserve	10734	1056	Chula Vista, City of 120	City 2	City Agency 2	http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp	City 2	319	San Diego, County of 101	County 3	County Agency 3	http://www.sandiegocounty.gov/pds/mscp/or.html	San Diego 4	368.875	Otay Ranch Preserve	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]);