Trasladar un punto a la geometria mas cercana postgis

https://signatura21.wordpress.com/2014/09/24/trasladar-un-punto-a-la-geometria-mas-cercana-con-postgis/

Anuncios

POSTGIS

http://postgis.net/install/

 

-- Enable PostGIS (includes raster)
CREATE EXTENSION postgis;
-- Enable Topology
CREATE EXTENSION postgis_topology;
-- Enable PostGIS Advanced 3D 
-- and other geoprocessing algorithms
-- sfcgal not available with all distributions
CREATE EXTENSION postgis_sfcgal;
-- fuzzy matching needed for Tiger
CREATE EXTENSION fuzzystrmatch;
-- rule based standardizer
CREATE EXTENSION address_standardizer;
-- example rule data set
CREATE EXTENSION address_standardizer_data_us;
-- Enable US Tiger Geocoder
CREATE EXTENSION postgis_tiger_geocoder

-- Upgrade PostGIS (includes raster) to latest version
ALTER EXTENSION postgis UPDATE;
ALTER EXTENSION postgis_topology UPDATE;

or to a specific version

-- Upgrade PostGIS (includes raster)
ALTER EXTENSION postgis 
 UPDATE TO "2.4.2";
-- Upgrade Topology
ALTER EXTENSION postgis_topology 
 UPDATE TO "2.4.2";
 
-- Upgrade US Tiger Geocoder
ALTER EXTENSION postgis_tiger_geocoder 
 UPDATE TO "2.4.2";

Crear servicios en android.

https://geekytheory.com/desarrollo-de-android-apps-servicios

http://www.w3ii.com/es/android/android_services.html

https://stackoverflow.com/questions/28535703/best-way-to-get-user-gps-location-in-background-in-android

http://www.sgoliver.net/blog/tareas-en-segundo-plano-en-android-ii-intentservice/

https://sekthdroid.wordpress.com/2013/02/12/asynctask-en-service-en-android/

http://www.jtech.ua.es/dadm/2011-2012/restringido
/android-av/sesion02-apuntes.html

Desarrollo Android: Hacer que una tarea se ejecute periodicamente

https://www.albertcoronado.com/2014/09/23/desarrollo-android-hacer-que-una-tarea-se-ejecute-repetidamente/

Herramientoas GIS

Fuente http://suite.opengeo.org

  • GeoServer 2.11
  • GeoWebCache 1.11
  • GeoTools 17
  • PostgreSQL 9.6
  • PostGIS 2.3
  • GDAL 1.11.5

Codificacion charset oracle python. insert caracteres especiales en oracle python

os.environ[‘NLS_LANG’] = ‘AMERICAN_AMERICA.UTF8’

http://www.oracle.com/technetwork/articles/dsl/tuininga-cx-oracle-084866.html

https://sourceforge.net/p/cx-oracle/mailman/message/27473780/

Ejemplo tomado

import os
import cx_Oracle

os.environ[‘NLS_LANG’] = ‘AMERICAN_AMERICA.UTF8’
utf8_conn = cx_Oracle.connect(‘dana’, ‘pw’, ‘utf8db’)
print utf8_conn.encoding
s = utf8_conn.cursor().execute(‘SELECT :s AS str FROM dual’,
s=u’d\u00e4t\u00e4′).fetchone()[0]
print s, type(s), len(s), len(s.encode(‘utf8’))

utf8_conn.close()

os.environ[‘NLS_LANG’] =’AMERICAN_AMERICA.WE8ISO8859P1′
latin1_conn = cx_Oracle.connect(‘dana’, ‘pw’, ‘latin1db’)
print latin1_conn.encoding
s = latin1_conn.cursor().execute(‘SELECT :s AS str FROM dual’,
s=’d\xe4t\xe4′).fetchone()[0].decode(‘latin1’)
print s, type(s), len(s), len(s.encode(‘latin1’))

Sincronizar directorio ftp con rsync en linux

http://askubuntu.com/questions/34868/how-do-i-back-up-via-ftp-and-rsync

 

yum install glib2-devel  yum install fuse-devel  yum install libcurl-devel  wget http://sourceforge.net/projects/curlftpfs/files/latest/download  tar xvzf curlftpfs-0.9.2.tar.gz  cd curlftpfs-0.9.2  ./configure  make  make install