Desarrollo _ geomaticblog

Phew, it’s been almost two years since my last techie blog post. Database er diagram I know I know, blame on me, I should’ve been writing more here but at least I did some nice posts at CARTO blog. Data recovery tools linux Anyway, It’s Christmas today and because Internet is my playground and any piece of data I can put on a map can be a toy I spent a few hours having some geeky fun. A few days ago a friend asked I knew any service to create a map of pictures in a collaborative environment. Data recovery wizard for mac I thought maybe a trendy photo service like Instagram would be a good fit but it happens it’s super restrictive for developers so I headed to the good old Flickr.

Database etl Flickr is one of those services that are really developer friendly, has a ton of super cool features and a decent mobile application and still, for some reason, it’s loosing its traction. Database lock Sad. Anyway, Flickr has groups so a number of individuals can share geolocated pictures and they can display it on a map but sincerely, it has a very bad interface so probably we can do something better with CARTO. Data recovery reviews The issue then is how can we maintain an updated map in CARTO from a Flickr Group? I’m a big fan of unmanaged services. Database d b I know there are people that love to maintain their servers but I’m not one of them. Ads b database If I have to publish a website I try to use something static like uploading the site to Amazon S3 (i.e. Database denormalization my own website) or even better, use Github Pages like the Geoinquietos website. Pokemon y database In this case not so long ago the only option to build an application to solve this issue was going to a PaaS service like Heroku, Amazon Beanstalk or Google App Engine, but they are meant for big applications typically involving a database and in general an architecture prepared for bigger things than this simple requirement. Data recovery icon Over the last two years a new approach has emerged, a type of service that provides an automatically managed infrastructure to define small functions where each one is aimed to do a single functionality. Fda 510 k database They only live while they are being executed and afterwards the server is shut down. Google hacking database Amazon Lambda was the first of it’s class but recently also appeared Google Cloud Functions. Database concepts 6th edition pdf On both services you can write your function in different languages (Python, Java, NodeJS, even PHP) and they can be triggered from a HTTP call or schedule its execution periodically. As everything with Amazon, configuration from their website can be difficult and using it from the command line can be heroic. Data recovery utility But it was a matter of time that something like Zappa would appear. Data recovery from hard drive Zappa is an application that makes deploying Python functions to Lambda dead easy. Database objects You basically configure a few settings and code your function and it takes care of the full cycle of deploying, versioning and even you can tail the logs from the cloud into your console in real time. So to make this as short as possible, I coded a Lambda function that is exposed as a url acting as a proxy to Flickr API. Data recovery raid 5 This proxy will take URL arguments (or use some defaults) to retrieve photos information and will output them as a valid GeoJSON file. Database architect This allows me to create a CARTO Synchronized Table that updates every hour for example and retrieves the last pictures sent to a group (up to 500, as a Flickr API limitation). Data recovery options This dataset can then be used to create a BUILDER dashboard to present the pictures as nicely as possible. But there are other methods on Flickr that returns photos, you can create a map of an account public uploads, or a map of the most interesting photos of the day, by photoset, etc. Database jobs etc. H2 database file All using the same proxy!! I’ve created a github repo with the source code of this proxy (just around 130 lines of code) and more detailed instructions on how to set up your environment to deploy your own version of it on your account and use it in your own integrations. R studio data recovery serial key I have more ideas that I want to explore and I’ll try to share it here when I do them. What do you think of this approach? Have you used Lambda for any other interesting use cases? Do you want me to continue posting on this topic about the other ideas I have? Feel free to comment here or reach me on twitter. After that experience, and thanks to Pedro’s friendship with Carlos Galcerán, a Cuban GIS consultant working in New Zealand, we had the opportunity to put our brains working again for another pet project. Database query languages The idea is easy, have you ever wondered who is on your antipodes? Yes, three quarters of our planet are oceans so the chance to have an inhabited antipodes is not high but here in Spain, it happens that half of the Iberian Peninsula is antipodal to New Zealand. P d database Join that with the possibility to have data about schools on both countries and well, that’s reason enough for us to start playing. Database 101 Imagine a geography class on primary school, say in the north coast of Galicia, where kids can contact their antipodal school in Christchurch and practice their English, or kiwis practicing their Spanish, both learning about our cultures, favorite sports, our differences. We started with a dataset only for Galician schools and end up digging a national registry of schools to create a full dataset of schools for the country. M power database That and the help of Carlos and some help from the Spanish Embassy in New Zealand, gave us all the data needed to set up two tables on CartoDB, so the last piece was just a web interface to develop. Data recovery from external hard drive With the recent release of OpenLayers 3, and having played with it a bit before, I wanted to do something more complex. Database join types We’ll leave the technical details about data and software for another post or two. The application is available at Probably some of you do a real engineering process to build your GIS projects, I mean, the classical analyse-design-implement cycle. Section 8 database As a GIS is in fact an Information System with the (complex of course) spatial component, one should expect that the common tools and methodologies of « normal Information Systems» are available for GIS engineers but on the case of database modelling that’s not so common. So, what happens when you want to design a GIS data model? Well, one usually had to use a “fake” geometry type on your CASE tool of choice and afterwards create the geometry columns by hand or using custom post-processes. Until now, because my smart colleagues at Prodevelop have developed an extension to the MOSKitt software called MOSKitt Geo that adds the spatial data type to the UML and Entity-Relationship models so you can perform the regular design process on MOSKitt: you do your UML model, then you convert it to the Entity-Relationship model and then you select your target database and MOSKitt creates the DDL scripts automatically. Even more, you can also do reverse engineering of your spatial database and redesign or improve you data models using excellent MOSKitt graphical tools! Take a look on these videos from the new Prodevelop YouTube channel to see how it works and go ( and comment!) to the Carlos post about MOSKitt Geo at Prodevelop blog. Como ya os conté en su momento, tengo instalado un mapserver y un tilecache en el ordenador, lo que no os conté es que está encima de un XAMPP. Icd 9 database Recientemente se me ha ocurrido probar ka-Map, a raíz del taller de las IIas Jornadas de SIG Libre,y cuando lo instalé, siguiendo rigurosamente las instrucciones, me encontré con un problemilla que me ha llevado un poco resolver, sobretodo porque pese a que hay bastante gente que le ha pasado, no he sido capaz de enc
ontrar la solución en San Google. Database xampp Se trata de un problema para instalar MapScript sobre un Apache ya existente (o sobre un XAMPP). Todo empieza con este error cuando pedimos la siguiente dirección: http://localhost/ka-map/init.php Warning: dl() [function.dl]: Not supported in multithreaded Web servers – use extension=php_mapscript.dll in your php.ini in C:xampphtdocska-mapinit.php on line 118 Fatal error: Call to undefined function ms_newmapobj() in C:xampphtdocska-mapinit.php on line 124 Para empezar la distribución estándar de xampp no tiene la dll php_mapscript así que vamos a la página de PHP MapScript decididísimo a descargarme lo que haga falta… te llegas a la página de PHP MapScript y descubres que, para MSW$, ahora solo se distribuye junto con ms4w,pero claro, yo ya tenía un Apache y un MapServer funcionando así que no quería instalar otro servicio Apache… cojo, la versión en zip de ms4w y rapiño la dll… Ojo, acordaros de modificar convenientemente el config.php de ka-Map … retoco el php.ini del xampp (usad el phpinfo() para saber dónde está) para que cargue php_mapscript como extensión, reinicio Apache y … Warning: dl() [function.dl]: Not supported in multithreaded Web servers – use extension=php_mapscript.dll in your php.ini in C:xampphtdocska-mapinit.php on line 118 Fatal error: Call to undefined function ms_newmapobj() in C:xampphtdocska-mapinit.php on line 124 vale, al parecer estoy haciendo algo mal… tras unas búsquedas en Google veo que es un mal bastante común y que no parece que nadie sepa cómo solucionarlo, así que me pongo a investigar y descubro que ms4w tiene montado PHP como FastCGI en vez de como módulo (opción por defecto en XAMPP), bueno, pues probemos si es eso… Vamos a C:/xampp/apache/conf/extra/httpd-xampp.conf y modificamos las primeras líneas del archivo para que recen así: ScriptAlias /php/ “C:/xampp/php/” Action application/x-httpd-php “/php/php-cgi.exe” #LoadModule php5_module “C:/xampp/apache/bin/php5apache2.dll” AddType application/x-httpd-php-source .phps AddType application/x-httpd-php .php .php5 .php4 .php3 .phtml .phpt si lo reiniciáis y ejecutáis “as is” lo más fácil es que os de un error de Acceso prohibido cuando intentéis ejecutar cualquier archivo php ya que por defecto C:/xampp/php/ NO tiene permisos asignados en Apache (ojo con esto que puede producir fallos GORDOS de seguridad) AllowOverride AuthConfig Order allow,deny Allow from all reiniciamos Apache y “sorpresa” Warning: dl() [ function.dl]: Unable to load dynamic library ‘C:xamppphpextphp_mapscript.dll’ – No se puede encontrar el módulo C:xampphtdocska-mapinit.php on line 118 Fatal error: Call to undefined function ms_newmapobj() in C:xampphtdocska-mapinit.php on line 124 El hecho de que hayamos cambiado de error indica que estamos progresando 😀 aunque el error que indica es que no puede cargar php_mapscript.dll la realidad es un poco más compicada, lo que no puede cargar es alguna de sus dependencias pero ¿cuales? pues para contestar eso tendremos que ejecutar un programita que “escarba” las dependencias de las dll el Dependency Walker(esto lo averigüe leyendo la ayuda de Apache). Cuando falta una dll, la podemos obtener de la versión en zip de ms4w, descomprimiendo lo que necesitemos, las dlls están todas en ms4w_2.2.7.zipms4wApachecgi-bin. Database administrator jobs Conforme vamos añadiendo dlls a C:/xampp/php/nos irá señalando nuevas faltas (refrescando Dependency walker con F5). Data recovery joondalup Una forma de “acelerar” el proceso es descomprimir directamente todas las dlls que hay en el .zip en la carpeta (básicamente GDALes y PROJes)… Hay una dependencia que no es necesario resolver para que php_mapscript funcione “ MSJAVA.dll“. Fijaros que cómo PHP está montado como FastCGI no hace falta reiniciar Apache para que surtan efecto los cambios. Database of genomic variants Una vez hecho esto el mensaje de error de ka-Map es distinto, haciendo referencia a que no encuentra el mapa de ejemplo… señal de que funciona. Database viewer Warning: [MapServer Error]: msLoadMap(): (C:xampphtdocska-map/../../gmap/htdocs/ in C:xampphtdocska-mapinit.php on line 124 Warning: Failed to open map file ../../gmap/htdocs/ in C:xampphtdocska-mapinit.php on line 124 Fatal error: Call to a member function getMetaData() on a non-object in C:xampphtdocska-mapinit.php on line 130 Bueno, pues con esto en un periquete tenéis ka-Map montado sobre un XAMPP ya existente (ojito, again, con las configuraciones de seguridad, este es un ejemplo para un puesto de desarrollo, no de producción). H data recovery registration code free download Espero que os sirva la recetilla y si tenéis dudas… ya sabéis.