calands: units_with_maps: 1 row where ACCESS_TYP = 1, MNG_AGENCY = 89, MNG_AG_TYP = 10 and UNIT

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

1 row where ACCESS_TYP = 1, MNG_AGENCY = 89, MNG_AG_TYP = 10 and UNIT_NAME = "Carlsbad Oaks North Preserve"

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
14636	14636	14635	{"type": "MultiPolygon", "coordinates": [[[[-117.25819, 33.13745], [-117.25858, 33.13781], [-117.25859, 33.13785], [-117.25859, 33.13788], [-117.25856, 33.13792], [-117.25826, 33.13803], [-117.25778, 33.13817], [-117.25578, 33.13853], [-117.2555, 33.13856], [-117.25509, 33.13854], [-117.25435, 33.1384], [-117.25396, 33.13837], [-117.25147, 33.13844], [-117.25109, 33.13848], [-117.25085, 33.13853], [-117.25058, 33.13862], [-117.25, 33.1389], [-117.24976, 33.13899], [-117.24955, 33.13905], [-117.24879, 33.13919], [-117.24842, 33.1393], [-117.24805, 33.13948], [-117.24745, 33.13987], [-117.24712, 33.14001], [-117.24677, 33.14011], [-117.24635, 33.14015], [-117.24589, 33.13338], [-117.24693, 33.13467], [-117.24867, 33.1356], [-117.24982, 33.13599], [-117.25209, 33.13589], [-117.25234, 33.13565], [-117.25248, 33.13269], [-117.25261, 33.13298], [-117.25278, 33.13326], [-117.253, 33.13351], [-117.25348, 33.134], [-117.25456, 33.13548], [-117.2547, 33.13565], [-117.25487, 33.13581], [-117.2552, 33.13604], [-117.25559, 33.13623], [-117.25591, 33.13632], [-117.25674, 33.13648], [-117.25695, 33.13654], [-117.2572, 33.13664], [-117.2574, 33.13676], [-117.25736, 33.13684], [-117.25745, 33.13712], [-117.25754, 33.13725], [-117.25765, 33.13735], [-117.25782, 33.13745], [-117.25811, 33.13751], [-117.25819, 33.13745]]], [[[-117.26726, 33.13981], [-117.26721, 33.14096], [-117.26718, 33.14217], [-117.26266, 33.14528], [-117.26179, 33.1458], [-117.24672, 33.1458], [-117.24663, 33.1439], [-117.24743, 33.14452], [-117.24845, 33.14495], [-117.249, 33.14504], [-117.25026, 33.14502], [-117.2506, 33.14498], [-117.25517, 33.14497], [-117.25613, 33.14421], [-117.25627, 33.1439], [-117.25644, 33.14391], [-117.25674, 33.14366], [-117.2572, 33.14348], [-117.25734, 33.14345], [-117.2575, 33.14347], [-117.25804, 33.14364], [-117.25818, 33.14365], [-117.25842, 33.14362], [-117.25862, 33.14365], [-117.25877, 33.14371], [-117.25919, 33.14399], [-117.25975, 33.14407], [-117.25995, 33.14397], [-117.26031, 33.14352], [-117.26033, 33.14337], [-117.26018, 33.14303], [-117.25985, 33.14274], [-117.25983, 33.14199], [-117.25976, 33.1418], [-117.25964, 33.14163], [-117.25948, 33.1415], [-117.25927, 33.14139], [-117.25904, 33.14132], [-117.25883, 33.14129], [-117.25815, 33.14129], [-117.25746, 33.14138], [-117.25664, 33.14144], [-117.25649, 33.14025], [-117.25649, 33.13984], [-117.25644, 33.1397], [-117.25635, 33.13959], [-117.25622, 33.13951], [-117.2561, 33.13948], [-117.25594, 33.13947], [-117.25549, 33.13959], [-117.25529, 33.13978], [-117.25514, 33.13918], [-117.25515, 33.13884], [-117.25517, 33.13881], [-117.25521, 33.13879], [-117.25546, 33.13879], [-117.25579, 33.13877], [-117.25778, 33.13841], [-117.25809, 33.13833], [-117.25839, 33.13824], [-117.25885, 33.13805], [-117.25893, 33.13806], [-117.25907, 33.13819], [-117.25911, 33.1383], [-117.25967, 33.13853], [-117.25983, 33.13864], [-117.25993, 33.13867], [-117.26004, 33.13867], [-117.26035, 33.13858], [-117.26092, 33.13836], [-117.26121, 33.13835], [-117.26111, 33.13681], [-117.26114, 33.13681], [-117.26177, 33.13645], [-117.26199, 33.13641], [-117.26207, 33.13625], [-117.2623, 33.1361], [-117.26246, 33.13602], [-117.26265, 33.13601], [-117.26283, 33.13581], [-117.26331, 33.13562], [-117.26352, 33.1356], [-117.26378, 33.13575], [-117.26491, 33.13572], [-117.26567, 33.13603], [-117.26438, 33.138], [-117.26571, 33.13987], [-117.26726, 33.13981]]], [[[-117.26107, 33.13612], [-117.26089, 33.1361], [-117.26047, 33.1362], [-117.25916, 33.13639], [-117.25858, 33.1364], [-117.25739, 33.1363], [-117.25727, 33.1363], [-117.25721, 33.13639], [-117.25681, 33.13625], [-117.25598, 33.1361], [-117.2556, 33.13597], [-117.2554, 33.13588], [-117.25518, 33.13574], [-117.25502, 33.1356], [-117.25484, 33.13542], [-117.25371, 33.13386], [-117.25321, 33.13336], [-117.25301, 33.13312], [-117.25287, 33.1329], [-117.25274, 33.13262], [-117.25327, 33.13291], [-117.25402, 33.13366], [-117.255, 33.13445], [-117.25599, 33.13519], [-117.25749, 33.13536], [-117.25908, 33.13548], [-117.25998, 33.13548], [-117.26099, 33.13502], [-117.26107, 33.13612]]], [[[-117.2677, 33.13206], [-117.26703, 33.13277], [-117.267, 33.13362], [-117.26742, 33.134], [-117.26607, 33.13473], [-117.26507, 33.13531], [-117.26491, 33.13536], [-117.2648, 33.13529], [-117.26466, 33.1351], [-117.26468, 33.13502], [-117.26494, 33.1348], [-117.26499, 33.13464], [-117.26511, 33.13451], [-117.26537, 33.13411], [-117.2657, 33.13382], [-117.26577, 33.13364], [-117.26602, 33.13248], [-117.26628, 33.13169], [-117.26646, 33.13148], [-117.2677, 33.13206]]]]}	Open Access 1	44868	Carlsbad Oaks North Preserve	28253	3014	Center for Natural Lands Management 91	Non Profit 6	Non Profit - Land Trust 10	http://cnlm.org/	Non Governmental Organization 10	3014	Center for Natural Lands Management 89	Non Profit 6	Non Profit - Land Trust 10	http://cnlm.org/portfolio_page/carlsbad-oaks/	San Diego 4	331.194	Carlsbad Oaks North Preserve	2007	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]);