Skip to content

Instantly share code, notes, and snippets.

View diegomozqueda's full-sized avatar
:octocat:
onGit

Diego Mozqueda diegomozqueda

:octocat:
onGit
View GitHub Profile
@diegomozqueda
diegomozqueda / App.js
Created April 30, 2017 17:30
Water Guardians Code
var layer1 = new ol.layer.Vector({
title: "Patzcuaro's hidrolycal basin",
source: new ol.source.Vector({
url: '../../data/patzcuaro_a.json',
format: new ol.format.GeoJSON()
}),
style:new ol.style.Style({
stroke: new ol.style.Stroke({
color: 'green',
width: 3
@diegomozqueda
diegomozqueda / Mexico, Catalog of Federal Districts
Created December 2, 2016 16:24
Mexico, Catalog of Federal Districts | Mexico, Catálogo de Distritos Federales
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for pd_cat_distritosfederales
-- ----------------------------
DROP TABLE IF EXISTS `pd_cat_distritosfederales`;
CREATE TABLE `pd_cat_distritosfederales` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`id_entidad` int(10) DEFAULT NULL,
`cve_geo` varchar(50) DEFAULT NULL,
@diegomozqueda
diegomozqueda / MySQL, Query to generate GeoJson
Last active December 2, 2016 16:26
MySQL, Query to generate GeoJson | MySQL, Consulta para generar GeoJson
SELECT
1 as id,
JSON_OBJECT(
'type', 'FeatureCollection',
'features',
JSON_OBJECT(
'type', 'Feature',
'properties',
JSON_OBJECT(
'clave', '1293',