calands: superunits_with_maps: 1 row where ACCESS_TYP = 1 and LABEL

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

1 row where ACCESS_TYP = 1 and LABEL_NAME = "Rancho Jamul ER"

Search:

descending

This data as json, copyable, CSV (advanced)

Link	rowid ▼	id	map	ACCESS_TYP	PARK_NAME	PARK_URL	SUID_NMA	MNG_AG_ID	MNG_AGENCY	MNG_AG_LEV	MNG_AG_TYP	AGNCY_WEB	LAYER	ACRES	LABEL_NAME	YR_EST
14505	14505	14504	{"type": "MultiPolygon", "coordinates": [[[[-116.85259, 32.65128], [-116.85237, 32.65129], [-116.85211, 32.65136], [-116.85187, 32.65145], [-116.85171, 32.65155], [-116.85154, 32.65169], [-116.85091, 32.65234], [-116.85052, 32.65269], [-116.85018, 32.65294], [-116.84902, 32.65366], [-116.84879, 32.65385], [-116.84828, 32.65436], [-116.84808, 32.65463], [-116.84796, 32.65484], [-116.84791, 32.65498], [-116.84751, 32.65633], [-116.84746, 32.65646], [-116.84733, 32.65664], [-116.84713, 32.65681], [-116.84651, 32.6571], [-116.84382, 32.65809], [-116.83996, 32.65938], [-116.83967, 32.65952], [-116.83945, 32.65968], [-116.83922, 32.6599], [-116.83827, 32.66111], [-116.83783, 32.66199], [-116.83773, 32.66222], [-116.83766, 32.6625], [-116.83749, 32.66331], [-116.83743, 32.66348], [-116.83729, 32.66374], [-116.83712, 32.66398], [-116.83645, 32.6647], [-116.83528, 32.6659], [-116.83507, 32.66605], [-116.83482, 32.66613], [-116.83353, 32.66641], [-116.83255, 32.66678], [-116.83233, 32.66686], [-116.83171, 32.66704], [-116.8308, 32.66726], [-116.82816, 32.66806], [-116.82803, 32.66807], [-116.8278, 32.66804], [-116.82496, 32.66736], [-116.82468, 32.66732], [-116.82298, 32.66736], [-116.82265, 32.66731], [-116.82247, 32.66727], [-116.82223, 32.66718], [-116.82205, 32.6671], [-116.82205, 32.66298], [-116.83519, 32.66305], [-116.83514, 32.65762], [-116.84751, 32.64662], [-116.85186, 32.65059], [-116.85259, 32.65128]]], [[[-116.89411, 32.69899], [-116.89408, 32.70264], [-116.88948, 32.70272], [-116.88952, 32.7048], [-116.88738, 32.70635], [-116.88518, 32.7064], [-116.88526, 32.70315], [-116.88525, 32.70279], [-116.87636, 32.70295], [-116.87641, 32.69926], [-116.87326, 32.69924], [-116.8737, 32.70186], [-116.87358, 32.70358], [-116.87184, 32.70354], [-116.87183, 32.7029], [-116.86795, 32.7027], [-116.86794, 32.70272], [-116.86822, 32.70336], [-116.86725, 32.70335], [-116.86281, 32.69883], [-116.86281, 32.6988], [-116.86224, 32.69825], [-116.8607, 32.69668], [-116.8607, 32.69666], [-116.86042, 32.6964], [-116.85224, 32.68814], [-116.85102, 32.68699], [-116.85107, 32.68695], [-116.85107, 32.68693], [-116.85011, 32.68601], [-116.84956, 32.68558], [-116.84933, 32.68542], [-116.84934, 32.6854], [-116.84932, 32.68538], [-116.84914, 32.68526], [-116.84869, 32.68501], [-116.84818, 32.68476], [-116.84764, 32.68457], [-116.84726, 32.68445], [-116.84283, 32.68329], [-116.84249, 32.68316], [-116.8421, 32.68296], [-116.84179, 32.68275], [-116.84149, 32.68251], [-116.84132, 32.68233], [-116.84045, 32.68042], [-116.84027, 32.67885], [-116.8351, 32.67281], [-116.83475, 32.67245], [-116.83444, 32.67217], [-116.83412, 32.67192], [-116.83377, 32.67167], [-116.83338, 32.67143], [-116.83295, 32.67121], [-116.83242, 32.67097], [-116.83189, 32.67078], [-116.83111, 32.67057], [-116.83038, 32.67044], [-116.82962, 32.67038], [-116.82849, 32.67039], [-116.82847, 32.67048], [-116.82681, 32.67049], [-116.82642, 32.67044], [-116.82603, 32.67031], [-116.82586, 32.67023], [-116.82566, 32.6701], [-116.82563, 32.67009], [-116.82543, 32.66992], [-116.82525, 32.66974], [-116.82426, 32.66851], [-116.82409, 32.66835], [-116.82385, 32.66817], [-116.82354, 32.66801], [-116.82344, 32.66783], [-116.82335, 32.66772], [-116.82321, 32.66758], [-116.82302, 32.66747], [-116.82444, 32.66743], [-116.82475, 32.66744], [-116.82492, 32.66747], [-116.82779, 32.66815], [-116.82799, 32.66818], [-116.82819, 32.66817], [-116.82835, 32.66813], [-116.83085, 32.66736], [-116.8317, 32.66715], [-116.83234, 32.66697], [-116.8329, 32.66677], [-116.83356, 32.66651], [-116.83376, 32.66646], [-116.83485, 32.66624], [-116.83502, 32.66619], [-116.83517, 32.66612], [-116.83529, 32.66605], [-116.83542, 32.66594], [-116.83655, 32.66476], [-116.83731, 32.66393], [-116.83749, 32.66364], [-116.83761, 32.66335], [-116.83766, 32.66315], [-116.83777, 32.66252], [-116.83786, 32.66224], [-116.83799, 32.66194], [-116.83832, 32.66127], [-116.83844, 32.66107], [-116.83931, 32.65997], [-116.83955, 32.65975], [-116.83974, 32.65961], [-116.84005, 32.65947], [-116.8434, 32.65836], [-116.84656, 32.6572], [-116.84716, 32.65692], [-116.84738, 32.65675], [-116.84748, 32.65665], [-116.84757, 32.65651], [-116.84764, 32.65635], [-116.84803, 32.655], [-116.84818, 32.6547], [-116.84841, 32.65441], [-116.84881, 32.65399], [-116.84906, 32.65378], [-116.84921, 32.65367], [-116.84923, 32.65367], [-116.84979, 32.65332], [-116.85108, 32.65283], [-116.85296, 32.65286], [-116.85516, 32.65507], [-116.85605, 32.6556], [-116.85868, 32.65591], [-116.86005, 32.65531], [-116.86064, 32.65474], [-116.86231, 32.65417], [-116.86443, 32.65276], [-116.86613, 32.65202], [-116.86617, 32.6506], [-116.86765, 32.64995], [-116.86847, 32.64965], [-116.86873, 32.6495], [-116.86893, 32.64933], [-116.86904, 32.6492], [-116.86914, 32.64903], [-116.86921, 32.64889], [-116.86926, 32.6487], [-116.86936, 32.64777], [-116.86938, 32.64771], [-116.87011, 32.6441], [-116.87017, 32.64396], [-116.87028, 32.64375], [-116.87048, 32.64353], [-116.87061, 32.64342], [-116.87375, 32.64143], [-116.87379, 32.64143], [-116.87526, 32.6405], [-116.8754, 32.64043], [-116.87562, 32.64035], [-116.87591, 32.6403], [-116.87616, 32.64029], [-116.8775, 32.64048], [-116.87848, 32.64053], [-116.87892, 32.64052], [-116.87969, 32.64041], [-116.88049, 32.64022], [-116.88114, 32.64001], [-116.88198, 32.63963], [-116.88229, 32.63947], [-116.88253, 32.63932], [-116.88302, 32.63898], [-116.88315, 32.63886], [-116.88329, 32.63866], [-116.88335, 32.63848], [-116.88349, 32.63764], [-116.88368, 32.63703], [-116.8842, 32.6369], [-116.89104, 32.64091], [-116.8904, 32.64089], [-116.87474, 32.64696], [-116.87454, 32.64858], [-116.87393, 32.64859], [-116.87322, 32.65576], [-116.8747, 32.65574], [-116.87361, 32.66523], [-116.87636, 32.66563], [-116.87629, 32.67028], [-116.87645, 32.68462], [-116.87642, 32.69924], [-116.88056, 32.69916], [-116.8805, 32.69176], [-116.88048, 32.68814], [-116.88499, 32.6881], [-116.88507, 32.6899], [-116.88509, 32.6917], [-116.88949, 32.69167], [-116.89406, 32.69185], [-116.89408, 32.69533], [-116.88963, 32.69538], [-116.88962, 32.69539], [-116.88974, 32.69903], [-116.89411, 32.69899]], [[-116.87131, 32.64458], [-116.87262, 32.64333], [-116.87252, 32.64298], [-116.87093, 32.64366], [-116.8703, 32.64505], [-116.87062, 32.64522], [-116.87131, 32.64458]], [[-116.87272, 32.64368], [-116.8727, 32.64367], [-116.87211, 32.64426], [-116.87284, 32.64414], [-116.87272, 32.64368]]], [[[-116.87069, 32.64323], [-116.87051, 32.64335], [-116.87036, 32.64347], [-116.87022, 32.64362], [-116.8701, 32.64381], [-116.87, 32.64405], [-116.86923, 32.64773], [-116.86912, 32.64873], [-116.86907, 32.64889], [-116.869, 32.64905], [-116.86884, 32.64925], [-116.86873, 32.64935], [-116.86854, 32.64949], [-116.86831, 32.6496], [-116.8676, 32.64985], [-116.86585, 32.65062], [-116.86563, 32.65067], [-116.86544, 32.65066], [-116.86522, 32.65058], [-116.86508, 32.65047], [-116.86472, 32.65012], [-116.86456, 32.65002], [-116.8644, 32.64996], [-116.86356, 32.6498], [-116.86335, 32.6498], [-116.86313, 32.64984], [-116.86298, 32.64991], [-116.86247, 32.65021], [-116.86223, 32.65043], [-116.86154, 32.65121], [-116.85995, 32.65231], [-116.85974, 32.65238], [-116.85922, 32.65245], [-116.85905, 32.65249], [-116.8589, 32.65256], [-116.85845, 32.65282], [-116.85799, 32.6532], [-116.85784, 32.65331], [-116.85765, 32.65342], [-116.85744, 32.6535], [-116.85718, 32.65357], [-116.85716, 32.65352], [-116.85691, 32.65354], [-116.85693, 32.65095], [-116.85757, 32.65151], [-116.8701, 32.64237], [-116.87069, 32.64323]]], [[[-116.91539, 32.69911], [-116.90982, 32.69911], [-116.90263, 32.69904], [-116.90249, 32.69181], [-116.89804, 32.69182], [-116.89801, 32.68805], [-116.90684, 32.68801], [-116.90689, 32.69177], [-116.91097, 32.69172], [-116.91064, 32.6843], [-116.90654, 32.68433], [-116.90661, 32.67694], [-116.91025, 32.6769], [-116.91494, 32.67679], [-116.91487, 32.68427], [-116.91524, 32.68429], [-116.91527, 32.68821], [-116.91504, 32.6882], [-116.91503, 32.68822], [-116.91535, 32.69523], [-116.91539, 32.69911]]]]}	Open Access 1	Rancho Jamul Ecological Reserve		32273	201	California Department of Fish and Wildlife 25	State 5	State Agency 5	https://www.wildlife.ca.gov/	California Department of Fish and Wildlife 6	5722.976	Rancho Jamul ER	2000

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE superunits_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  PARK_NAME TEXT,
  PARK_URL TEXT,
  SUID_NMA INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
    ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
    ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
    ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
    ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
    ON [superunits_with_maps] ([ACCESS_TYP]);