La Ciénega

Intermittent Stream, Aguascalientes

Mexico

Where is La Ciénega?

La Ciénega is a intermittent stream in Aguascalientes, Mexico. It has an elevation of 2436 meters above sea level. It is also known as La Cienega, La Ciénega. Information correct as at Tuesday 10th May 2016.

Field trip to understand grazing rotation and grassland restoration, Aguascalientes Mexico Photo by Sergio Avila, Sky Island Alliance

Presa San Blas, Pabellón de Higalgo, Aguascalientes

Pedrete corona negra Nycticorax nycticorax

Pato de collar mexicano Anas platyrhynchos ssp. diazi

What 3 Words

///serve.unit.freeborn. Near San Antonio de los Ríos, Aguascalientes

Nearby Locations

Natillas Tanque los Angelenos Arroyo el Chiquihuite Monte las Tapias

Ciénega de Alcorcha Aguascalientes

Juan Caporal Aguascalientes

Have you been to La Ciénega?

Leave your comments, questions and feedback on this listing below. You can also correct any listing errors or omissions.

(default) 4 queries took 9 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `Record`.`id`, `Record`.`name`, `Record`.`asciiname`, `Record`.`alternatenames`, `Record`.`latitude`, `Record`.`longitude`, `feature class`, `Record`.`feature_id`, `Record`.`country_id`, `Record`.`cc2`, `admin1 code`, `admin2 code`, `Record`.`area_id`, `Record`.`district_id`, `admin3 code`, `admin4 code`, `Record`.`population`, `Record`.`elevation`, `Record`.`dem`, `Record`.`timezone_id`, `modification date`, `Record`.`description`, `Record`.`what3words`, `Record`.`what3words_place`, `Country`.`id`, `Country`.`name`, `Country`.`alpha-3`, `Country`.`country-code`, `Country`.`iso_3166-2`, `Country`.`region`, `Country`.`sub-region`, `Country`.`intermediate-region`, `Country`.`region-code`, `Country`.`sub-region-code`, `Country`.`intermediate-region-code`, `Feature`.`id`, `Feature`.`summary`, `Feature`.`description`, `Area`.`id`, `Area`.`name`, `Area`.`asciiname`, `Area`.`code`, `District`.`id`, `District`.`name`, `District`.`asciiname`, `District`.`code`, `Timezone`.`id`, `Timezone`.`CountryCode`, `Timezone`.`GMToffset`, `Timezone`.`DSToffset`, `Timezone`.`rawOffset` FROM `places`.`records` AS `Record` LEFT JOIN `places`.`countries` AS `Country` ON (`Record`.`country_id` = `Country`.`id`) LEFT JOIN `places`.`features` AS `Feature` ON (`Record`.`feature_id` = `Feature`.`id`) LEFT JOIN `places`.`areas` AS `Area` ON (`Record`.`area_id` = `Area`.`id`) LEFT JOIN `places`.`districts` AS `District` ON (`Record`.`district_id` = `District`.`id`) LEFT JOIN `places`.`timezones` AS `Timezone` ON (`Record`.`timezone_id` = `Timezone`.`id`) WHERE `Record`.`id` = 11134156 LIMIT 1	1	1	1
2	SELECT `Record`.`id`, `Record`.`asciiname` FROM `places`.`records` AS `Record` LEFT JOIN `places`.`countries` AS `Country` ON (`Record`.`country_id` = `Country`.`id`) LEFT JOIN `places`.`features` AS `Feature` ON (`Record`.`feature_id` = `Feature`.`id`) LEFT JOIN `places`.`areas` AS `Area` ON (`Record`.`area_id` = `Area`.`id`) LEFT JOIN `places`.`districts` AS `District` ON (`Record`.`district_id` = `District`.`id`) LEFT JOIN `places`.`timezones` AS `Timezone` ON (`Record`.`timezone_id` = `Timezone`.`id`) WHERE district_id ='MX.01.' ORDER BY RAND() ASC LIMIT 4	4	4	6
3	SELECT `Record`.`id`, `Record`.`name`, `Record`.`asciiname`, `Record`.`alternatenames`, `Record`.`latitude`, `Record`.`longitude`, `feature class`, `Record`.`feature_id`, `Record`.`country_id`, `Record`.`cc2`, `admin1 code`, `admin2 code`, `Record`.`area_id`, `Record`.`district_id`, `admin3 code`, `admin4 code`, `Record`.`population`, `Record`.`elevation`, `Record`.`dem`, `Record`.`timezone_id`, `modification date`, `Record`.`description`, `Record`.`what3words`, `Record`.`what3words_place`, `Country`.`id`, `Country`.`name`, `Country`.`alpha-3`, `Country`.`country-code`, `Country`.`iso_3166-2`, `Country`.`region`, `Country`.`sub-region`, `Country`.`intermediate-region`, `Country`.`region-code`, `Country`.`sub-region-code`, `Country`.`intermediate-region-code`, `Feature`.`id`, `Feature`.`summary`, `Feature`.`description`, `Area`.`id`, `Area`.`name`, `Area`.`asciiname`, `Area`.`code`, `District`.`id`, `District`.`name`, `District`.`asciiname`, `District`.`code`, `Timezone`.`id`, `Timezone`.`CountryCode`, `Timezone`.`GMToffset`, `Timezone`.`DSToffset`, `Timezone`.`rawOffset` FROM `places`.`records` AS `Record` LEFT JOIN `places`.`countries` AS `Country` ON (`Record`.`country_id` = `Country`.`id`) LEFT JOIN `places`.`features` AS `Feature` ON (`Record`.`feature_id` = `Feature`.`id`) LEFT JOIN `places`.`areas` AS `Area` ON (`Record`.`area_id` = `Area`.`id`) LEFT JOIN `places`.`districts` AS `District` ON (`Record`.`district_id` = `District`.`id`) LEFT JOIN `places`.`timezones` AS `Timezone` ON (`Record`.`timezone_id` = `Timezone`.`id`) WHERE `Record`.`id` < 11134156 ORDER BY `Record`.`id` DESC LIMIT 1	1	1	1
4	SELECT `Record`.`id`, `Record`.`name`, `Record`.`asciiname`, `Record`.`alternatenames`, `Record`.`latitude`, `Record`.`longitude`, `feature class`, `Record`.`feature_id`, `Record`.`country_id`, `Record`.`cc2`, `admin1 code`, `admin2 code`, `Record`.`area_id`, `Record`.`district_id`, `admin3 code`, `admin4 code`, `Record`.`population`, `Record`.`elevation`, `Record`.`dem`, `Record`.`timezone_id`, `modification date`, `Record`.`description`, `Record`.`what3words`, `Record`.`what3words_place`, `Country`.`id`, `Country`.`name`, `Country`.`alpha-3`, `Country`.`country-code`, `Country`.`iso_3166-2`, `Country`.`region`, `Country`.`sub-region`, `Country`.`intermediate-region`, `Country`.`region-code`, `Country`.`sub-region-code`, `Country`.`intermediate-region-code`, `Feature`.`id`, `Feature`.`summary`, `Feature`.`description`, `Area`.`id`, `Area`.`name`, `Area`.`asciiname`, `Area`.`code`, `District`.`id`, `District`.`name`, `District`.`asciiname`, `District`.`code`, `Timezone`.`id`, `Timezone`.`CountryCode`, `Timezone`.`GMToffset`, `Timezone`.`DSToffset`, `Timezone`.`rawOffset` FROM `places`.`records` AS `Record` LEFT JOIN `places`.`countries` AS `Country` ON (`Record`.`country_id` = `Country`.`id`) LEFT JOIN `places`.`features` AS `Feature` ON (`Record`.`feature_id` = `Feature`.`id`) LEFT JOIN `places`.`areas` AS `Area` ON (`Record`.`area_id` = `Area`.`id`) LEFT JOIN `places`.`districts` AS `District` ON (`Record`.`district_id` = `District`.`id`) LEFT JOIN `places`.`timezones` AS `Timezone` ON (`Record`.`timezone_id` = `Timezone`.`id`) WHERE `Record`.`id` >= 11134155 AND `Record`.`id` != 11134156 ORDER BY `Record`.`id` ASC LIMIT 2	2	2	1

(default) 4 queries took 9 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `Record`.`id`, `Record`.`name`, `Record`.`asciiname`, `Record`.`alternatenames`, `Record`.`latitude`, `Record`.`longitude`, `feature class`, `Record`.`feature_id`, `Record`.`country_id`, `Record`.`cc2`, `admin1 code`, `admin2 code`, `Record`.`area_id`, `Record`.`district_id`, `admin3 code`, `admin4 code`, `Record`.`population`, `Record`.`elevation`, `Record`.`dem`, `Record`.`timezone_id`, `modification date`, `Record`.`description`, `Record`.`what3words`, `Record`.`what3words_place`, `Country`.`id`, `Country`.`name`, `Country`.`alpha-3`, `Country`.`country-code`, `Country`.`iso_3166-2`, `Country`.`region`, `Country`.`sub-region`, `Country`.`intermediate-region`, `Country`.`region-code`, `Country`.`sub-region-code`, `Country`.`intermediate-region-code`, `Feature`.`id`, `Feature`.`summary`, `Feature`.`description`, `Area`.`id`, `Area`.`name`, `Area`.`asciiname`, `Area`.`code`, `District`.`id`, `District`.`name`, `District`.`asciiname`, `District`.`code`, `Timezone`.`id`, `Timezone`.`CountryCode`, `Timezone`.`GMToffset`, `Timezone`.`DSToffset`, `Timezone`.`rawOffset` FROM `places`.`records` AS `Record` LEFT JOIN `places`.`countries` AS `Country` ON (`Record`.`country_id` = `Country`.`id`) LEFT JOIN `places`.`features` AS `Feature` ON (`Record`.`feature_id` = `Feature`.`id`) LEFT JOIN `places`.`areas` AS `Area` ON (`Record`.`area_id` = `Area`.`id`) LEFT JOIN `places`.`districts` AS `District` ON (`Record`.`district_id` = `District`.`id`) LEFT JOIN `places`.`timezones` AS `Timezone` ON (`Record`.`timezone_id` = `Timezone`.`id`) WHERE `Record`.`id` = 11134156 LIMIT 1

SELECT `Record`.`id`, `Record`.`asciiname` FROM `places`.`records` AS `Record` LEFT JOIN `places`.`countries` AS `Country` ON (`Record`.`country_id` = `Country`.`id`) LEFT JOIN `places`.`features` AS `Feature` ON (`Record`.`feature_id` = `Feature`.`id`) LEFT JOIN `places`.`areas` AS `Area` ON (`Record`.`area_id` = `Area`.`id`) LEFT JOIN `places`.`districts` AS `District` ON (`Record`.`district_id` = `District`.`id`) LEFT JOIN `places`.`timezones` AS `Timezone` ON (`Record`.`timezone_id` = `Timezone`.`id`) WHERE district_id ='MX.01.' ORDER BY RAND() ASC LIMIT 4