OSGeo Planet

gvSIG Team: New support services on gvSIG Desktop

OSGeo Planet - Mon, 2017-02-13 18:54

Use of Geographic Information System for any organization that manages geographic information is a fundamental tool. Adopting open source solutions in any entity, an upward trend, usually requires training and support services.

gvSIG Desktop is an open source GIS used in more than 160 countries and with a high level of implementation in a corporative level. The need to count with a support professional service by users to guarantee the resolution of events or doubts related to its use, as well as having technology updated with the improvements that are published continuously have been added to the interest to use gvSIG Desktop to analyse and manage geographic information.

More over gvSIG Desktop software, it’s important to emphasise that the gvSIG Association is the responsible for its maintenance and evolution, providing support, development, training and consulting services on that solution, as well as on gvSIG Suite, the free geomatics solutions catalogue maintained by the gvSIG Association.

Now, in 2017 we launch new packaged support services, in a user level, as well as in a developer one. With this service, gvSIG Desktop users can keep the value of the product, counting with the most advanced version always and with the support of the gvSIG Association, the organization that is the responsible for the maintenance and evolution of the application.


What does the gvSIG Desktop annual support include?

Level I, for users:

  • Resolution of user doubts: We offer a support team to solve all the doubts and problems found in gvSIG Desktop use. With this technical support, a customized monitoring of reported events is got, communicating with users to solve them. Distance communication or support portal will be established, and there will be on-site visits in case it’s needed. 
  • Service management by a Technical Manager. A technical responsible with detailed knowledge about installations and clients needs will participate. This specific knowledge about the installation, business and needs of the final user will allow to identify in a precise and optimized way the support needs and the corrective, preventive and/or evolutionary actions that can be necessary in a concrete moment currently as well as in a planned future.
  • Information about new versions, updates and improvements of the software that the gvSIG Association releases periodically. Support to launch updates and installation of new plugins.
  • Training for users.
  • Discounts in other services offered by the gvSIG Association.

Level II, with development service support includes:

    • Development packages by hours oriented to promote improvements on gvSIG Desktop and bug correction required by the client. Any request will be evaluated and the gvSIG Association will communicate to the client how any hours it would take. Once it’s confirmed by the client it would be carried out. Hour packages are the next: 160, 320, 480 or 1.000 hours.

Contact us: info@gvsig.com

Filed under: Business, development, english, gvSIG Association, gvSIG Desktop, training Tagged: Support
Categories: OSGeo Planet

GIScussions: FAKE MAPS, very dishonest!!!

OSGeo Planet - Mon, 2017-02-13 16:38

An open letter to President Trump

Dear Mr President
I read in this morning’s (failing) New York Times that you were pretty keen on maps in your briefing papers.

And while Mr. Obama liked policy option papers that were three to six single-spaced pages, council staff members are now being told to keep papers to a single page, with lots of graphics and maps.

“The president likes maps,” one official said.

Now I recognise that this may be a deliberate attempt by the dishonest press to mislead people and that you may not like maps. But, in case you do like maps, I wanted to give you a bit of insight into some of the sneaky things that those very dishonest cartographers (they even have a long foreign name to confuse people) do to make FAKE MAPS.

So the first thing FAKE MAP makers can do is to change projection from a wholesome projection like this Web Mercator projection which emphasises the size of your hands the US compared to the southern hemisphere

Web Mercator – A few major misconceptions based on this map: Alaska is nearly as large as the continental U.S. Greenland is roughly the same size as Africa. Europe (excluding Russia) is only a bit larger than South America. Antarctica dwarfs all the continents. In reality: Alaska can fit inside the continental U.S. about three times. Greenland can fit inside Africa about 14 times. South America nearly doubles Europe’s land mass. Antarctica looks like the second-smallest continent. (sourceBusiness Insider UK)

Compare that with this sneaky Gall-Peters projection which is an “equal-area cylindric or cylindrical equal-area projection. It achieved considerable notoriety in the late 20th century as the centerpiece of a controversy about the political implications of map design.” (Source Wikipedia)

The Peters Projection (via Wikipedia)

You might prefer a nice US centric projection like this US Centric Map

Thx to Jason Davies

Or you could suggest that your map makers read Michael Corey’s guide to map projections for the US

FAKE MAPS? Which projection ‘accurately’ portrays the United States? Thx to Michael Corey

So enough about projections, they are pretty technical and can be confusing even for experts.

Once you have chosen your projection (I wonder how long it will be before a loyal map maker comes up with a Trump projection?) then maps are a good way of presenting a lot of information and enabling you to get a clear view of the subject matter on which you are being briefed. Except that sometimes they aren’t! Before you make any major decisions (think immigration bans, voter registration changes, healthcare, starting a war etc) you might want to read How to Lie with Maps by Mark Monmomier – yes someone has written a whole book about FAKE MAPS, very very dishonest cartographers.

How to Lie with Maps by Mark Monmomier

If you are feeling bored on one of those lonely nights in the White House you could also try playing the Redistricting Game which will give you a clue to how someone could win an election without winning the majority of the votes (the answer is more to do with Governor Elbridge Gerry than illegal immigrants). I loved this quote on the home page (even if it did come from a failed, loser, Democrat)

“The polarization and poisonous atmosphere that have infected the House of Representatives for the past two decades or more can be traced — in large part — to the manner in which district lines are drawn in most states.”

I would also be remiss not to advise you to normalise your choropleths, no that is not some obscene abuse it’s advice from my friend Ken Field that you can read here, here, here and here.

So by now you may be wondering whether getting your daily briefings in the form of a map is such a great idea? Well on the plus side lots of people have been making maps that you might not have seen so I thought I would share a few of the best with you.

The World According to Donald Trump Thx to Huffington Post and Aaron Nemo

Thx to Hispanic Market Works

Thx to Andrea Mann, David Schneider and David Beresford at Huffington Post UK

Thx to Yanko Tsvetkov via The Independent

There are a lot of FAKE MAPS out there from those failing very very dishonest cartographers, keep them coming.

Categories: OSGeo Planet

From GIS to Remote Sensing: Webinar by NASA ARSET on Land Cover Classification with Satellite Imagery: Materials Available

OSGeo Planet - Mon, 2017-02-13 11:49
The NASA ARSET (Applied Remote Sensing Training) held a webinar on Land Cover Classification with Satellite Imagery using the Semi-Automatic Classification Plugin for QGIS.

First, I want to thank very much NASA ARSET for organizing this webinar, and especially the instructor Cindy Schmidt who had very kind words for my plugin and the plugin manual.
It gives me great satisfaction that such an important institution considered using the Semi-Automatic Classification Plugin in a webinar about remote sensing. This inspires me to do even more for the plugin development.

The demand for the webinar was high. For those who couldn't attend the webinar, the materials and recordings are now freely available.

Image Credit: NASA/USGS, NASA Earth Observatory
Categories: OSGeo Planet

gvSIG Team: Aprendiendo SIG con Juego de Tronos (VII): Añadir las coordenadas a una Tabla

OSGeo Planet - Mon, 2017-02-13 09:43

Hoy vamos a ver una herramienta muy sencilla a la par que útil. Permite añadir de forma automática las coordenadas X e Y (o Latitud/Longitud) de una capa de puntos. En nuestro caso, con cartografía ficticia sobre el sistema de proyección EPSG 4326 (el que utilizan los GPS), nos dará unas coordenadas que representan la latitud y longitud.

La capa de puntos que tenemos es “Locations”, sobre la que vamos a probar la herramienta denominada “Añadir X e Y”.

En primer lugar ponemos activa la capa “Locations” y abrimos su Tabla de atributos (como vimos en el post “Tablas”).

A continuación ejecutamos la herramienta, bien en el menú “Tabla/Añadir medición/Añadir X e Y”, bien en el botón correspondiente:046_got

Veremos como de forma automática añade dos nuevas columnas a la tabla de atributos y que contienen los datos de las coordenadas.047_got

Ahora ya podemos enviar a nuestros dragones a las coordenadas exactas

El siguiente post is coming…

Filed under: gvSIG Desktop Tagged: Añadir coordenadas, Juego de tronos
Categories: OSGeo Planet

Paul Ramsey: On "Transformation" and Government IT

OSGeo Planet - Sat, 2017-02-11 16:00

“You may find yourself,
In a beautiful house,
With a beautiful wife.
You may ask yourself,
well, how did I get here?”
– David Byrne, Once In a Lifetime

I’ve spilled a lot of electrons over the last 5 years talking about IT failures in the BC government (ICM, BCeSIS, NRPP, CloudBC), and a recurring theme in the comments is “how did this happen?” and “are we special or does everybody do this?”

The answer is nothing more sophisticated than “big projects tend to fail”, usually because more people on an IT project just adds to organizational churn: more reporting, more planning, more reviewing of same, all undertaken by the most expensive managerial resources.

That being so, why do we keep approving and attempting big IT projects? BC isn’t unique in doing so, though we have our own organizational tale to tell.


Both the social services Integrated Case Management (2009) and the Natural Resources Permitting Project (2013) projects were born out of “transformation” intiatives, attempts to restructure the business of a Ministry around new principles of authority and information flow.

Even for businesses as structured and regimented as a Department of Motor Vehicles, these projects can be risky. For a Ministry like Children & Families, where the stakes are children’s lives, and the evaluations of the facts of cases are necessarily subjective, the risk levels are even higher.

On "Transformation" and Government IT

Nonetheless, in the mid 2000’s, the Province gave the Ministry of Management Services a new mission, to “champion the transformation of government service delivery to respond to the everyday needs of citizens, businesses and the public sector.” In particular, the IT folks in the Chief Information Officer’s department took this mission in hand. This may be a clue as to why IT projects became the central pivot for “transformation” initiatives.

Around the same time, the term “citizen centred service delivery” began to show up in Ministry Service Plans. Ministries were encouraged to pursue this new goal, with the assistance of Management Services (later renamed Citizens’ Services). This activity reached a climax in 2010, with the release of Citizens @ The Centre: B.C. Government 2.0 by then Deputy to the Premier Alan Seckel.

The “government 2.0” bit is a direct echo of hype from south of the border, where in 2009 meme-machine Tim O’Reilly kicked off a series of conferences and articles on “Government 2.0” as a counterpart to his “web 2.0” meme.

Enthusiasm for technology-driven “government as a platform” resulted in some positive side effects, such as the “open data” movement, and the creation of alternative in-sourced delivery organizations, like the UK Government Digital Service and the American 18F organization in the General Service Administration. In BC the technology mania also wafted over the top levels of civil service, resulting in the Citizens @ The Centre plan.

As a result, the IT inmates took over the asylum. Otherwise sane Ministries were directed to produce “Transformation and Technology Plans” to demonstrate their alignment with the goals of “Citizens @ the Centre”. Education, Transportation, Natural Resources and presumbly all the rest produced these plans during what turned out to be the final years of Premier Gordon Campbell’s rule.

The 2011 change in leadership from Gordon Campbell’s technocratic approach to the “politics über alles” style of Christie Clark has not substantially reduced the momentum of IT-driven transformation projects.

Part of this may be a matter of senior leadership personalities: the current Deputy to the Premier, Kim Henderson was leading Citizen’s Services when it produced Citizens @ The Centre; the former CIO Dave Nikolejsin, an architect of the catastrophic ICM project, remains involved in the ongoing NRPP transformation project, despite his new perch in the Ministry of Natural Gas Developent.


The IT-led do-goodism of “transformation” explains to some extent how systems became the organizing principle for these disruptive projects, but it doesn’t fully explain their awesome size. Within my own professional memory, only 15 years ago, $10M was an surprisingly large IT opportunity in BC. Now I can name half a dozen projects that have exceeded $100M.

The social services Integrated Case Management project provides an interesting study in how a budget can blow up.

“Integrated Case Management” as a desirable concept was suggested by the 1996 Gove Report, (yes, 1996) leading to an “Integrated Case Management Policy” in 1998, and by 1999 a Ministry working group examining “off-the-shelf” (COTS) technology solutions. The COTS review did not turn up a suitable solution, and the Ministry buried itself in a long “requirements gathering” process, culminating in a working prototype by 2002. In 2003, an RFP was issued to expand the prototype into a pilot for a few hundred users.

The 2003 contract to build out the pilot was awarded to GDS & Associates Systems in the amount of $142,800. No, I didn’t drop any zeroes. Six years before a $180,000,000 ICM contract was awarded to Deloitte, the Ministry thought a working pilot could be developed for 1/1000 of the cost.

What happened after that is a bit of a mystery. Presumably the pilot process failed in some way (would love to know! leave a comment! send an email!) because in 2007 the government was back with a Request to procure a “commercial off-the-shelf” integrated case management solution.

This was the big kahuna. Instead of piloting a small solution and incrementally rolling out, the government already had plans to roll the solution out to over 5000 government workers and potentially 12000 contractors. And the process was going to be incredibly easy:

  • Phase 1: Procure Software
  • Phase 2: Planning and Systems Integration
  • Phase 3: Blueprint and Configure
  • Phase 4: Implementation
  • Phase 5: Future Implementation

Here’s where things get confusing. Despite using “off-the-shelf” software to avoid software development risks, and having a simple plan to just “configure” the software and roll it out, the new project was tied to a capital plan for $180M dollars, 1000 times the budget of the custom pilot software from a few years earlier.


Whereas the original pilot aimed to provide a new case management solution, full stop, the new project seems to have been designed to “boil the ocean”, touching and replacing hundreds of systems throughout the Ministry.


At this point the psychology of capital financing and government approvals starts to come into play. Capital financing can be hard to get. Large plans must be written and costed, and business cases built to show “return on investment” to Treasury Board.

One way to gain easy “return” is to take all the legacy systems in the organization, fluff up their annual operating costs as much as possible, bundle them together and say “we’re going to replace all this, for an annual savings of $X, which in conjunction with efficiencies $Y from our new technology and centralized maintenance gives us a positive ROI!”

I’m pretty sure this psychology applies, since almost exactly the same arguments backstop the “business case” for the ongoing Natural Resource Permitting Project.

A natural effect of bundling multiple system integrations is to blow up the budget size. This is actually a Good Thing (tm) from the point of view of technology managers, since it provides some excellent resumé points: “procured and managed 9-digit public IT project.”

A manager who successfully delivers a superb $4M IT project gets a celebratory dinner at the pub; a manager who brings even a terrible $140M IT project to “completion” can write her ticket in IT consulting.

The only downside of huge IT projects is that they fail to provide value to end-users a majority of the time, and of course they soak the taxpayers (or shareholders in the case of private sector IT failures, which happen all the time) for far more money than they should.

Can We Stop? Should We?

We really should stop. The source of the problems are pretty clear: overly large projects, and heavily outsourced IT.

Even the folks at the very top can see the problem and describe it, if they have the guts.

David Freud, former Conservative minister at the UK Department for Work and Pensions, was in charge of “Universal Credit” a large social services transformation project, which included a large poorly-built IT component – a project similar in scope to our ICM. He had this to say in a debrief about what he learned in the process:

The implementation was harder than I had expected. Maybe that was my own naivety. What I didn’t know, and I don’t think anyone knew, was how bad a mistake it had been for all of government to have sent out their IT.

It happened in the 1990s and early 2000s. You went to these big firms to build your IT. I think that was a most fundamental mistake, right across government and probably across government in the western world…

We talk about IT as something separate but it isn’t. It is part of your operating system. It’s a tool within a much better system. If you get rid of it, and lose control of it, you don’t know how to build these systems.

So we had an IT department but it was actually an IT commissioning department. It didn’t know how to do the IT.

What we actually discovered through the (UC) process was that you had to bring the IT back on board. The department has been rebuilding itself in order to do that. That is a massive job.

The solution will be difficult, because it will involve re-building internal IT skills in the public service, a work environment that is drastically less flexible and rewarding than the one on offer from the private sector. However, what the public service has going for it is a mission. Public service is about, well, “public service”. And IT workers are the same as anyone else in wanting their work to have value, to help people, and to do good.

The best minds of my generation are thinking about how to make people click ads.
– Jeffrey Hammerbacher

When the Obamacare healthcare.gov site, built by Canadian enterprise IT consultant CGI, cratered shortly after launch, it was customer-focused IT experts from Silicon Valley and elsewhere who sprang into action to rescue it. And when they were done, many of them stayed on, founding the US Digital Service to bring modern technology practices into the government. They’re paid less, and their offices aren’t as swank, but they have a mission, beyond driving profit to shareholders, and that’s a motivating thing.

Government can build up a new IT workforce, and start building smaller projects, faster, and stop boiling the ocean, but they have to want to do it first. That’ll take some leadership, at the political level as well as in the civil service. IT revitalization is not a partisan thing, but neither is it an easy thing, or a sexy thing, so it’ll take a politician with some guts to make it a priority.

Categories: OSGeo Planet

gvSIG Team: Día internacional de la mujer y la niña en la ciencia, ¿un día como otro cualquiera?

OSGeo Planet - Sat, 2017-02-11 10:57

Hoy es el Día Internacional de la Mujer y la Niña en la Ciencia, un día que nos recuerda algo que ocurre de forma silenciosa el resto de días del año.

Si miramos atrás, es fácil comprobar que las mujeres han contribuido a la ciencia desde sus inicios, aunque en multitud de casos no hayan sido reconocidas por ello. Si volvemos al presente, a día de hoy las mujeres todavía siguen enfrentándose a barreras que les impiden participar plenamente en el mundo científico y tecnológico, lo que sin duda es un factor más que impide avanzar hacia una plena igualdad de género y al emponderamiento de las mujeres.

En la parte que nos toca, asistiendo a cualquier congreso de geomática libre, también podemos comprobar que la situación de nuestro “gremio” no es diferente. De hecho incluso pienso que no sé es consciente de esta realidad; recuerdo que en alguna ocasión hemos planteado realizar algún debate sobre ello en jornadas gvSIG y siempre se ha percibido como algo “no necesario”.

Sin embargo, sobre esto se habló por primera vez en las pasadas Jornadas Internacionales de gvSIG, en el marco de una ponencia que anunciaba los premios de la Cátedra gvSIG. Aquí os dejo la grabación a partir del momento en que se trata este tema, vale la pena que le deis un vistazo:

Y aprovecho para dar las gracias a todas las que participáis en la Comunidad gvSIG y formáis parte necesaria de la construcción de este proyecto común.

Filed under: opinion, software libre Tagged: ciencia, desigualdad, emponderamiento, igualdad de género, mujer, tecnología
Categories: OSGeo Planet

Tim Waters: Mapwarper Tutorial & Spatial Humanities Workshop by Lincoln Mullen

OSGeo Planet - Fri, 2017-02-10 19:09

Lincoln Mullen has written a great series of workshops on the Spatial / Digital Humanities over five days. Day 3 is focused around Georectification with Mapwarper.net and is a very good tutorial.
The full workshop contents are here, and I recommend you to check them out:
Day 1: Introduction and Setup | Map Literacy | Narrative Maps
Day 2: Data Maps | QGIS
Day 3: Georectification | Working with Spatial Data
Day 4: Deep Maps | From Manuscripts to Maps
Day 5: Programmatic Maps

Lincoln is an assistant professor in the Department of History and Art History at George Mason University, working on the history of American religions as a digital historian.

The link to the Georectificaiton Workshop is here: http://lincolnmullen.com/projects/spatial-workshop/georectification.html

The screenshot of the tutorial is below the fold.



Categories: OSGeo Planet

gvSIG Team: Nuevos servicios de soporte sobre gvSIG Desktop

OSGeo Planet - Fri, 2017-02-10 11:51

Para cualquier organización que gestione información geográfica el uso de Sistemas de Información Geográfica (SIG, en adelante) se convierte en una herramienta fundamental. La adopción de soluciones libres en cualquier entidad, una tendencia al alza, suele requerir de servicios de soporte y formación.

gvSIG Desktop es un SIG en software libre utilizado en más de 160 países y con un alto grado de implantación a nivel corporativo. Al interés creciente en utilizar gvSIG Desktop para analizar y gestionar información de carácter geográfico, se une la necesidad de muchos usuarios de contar con un servicio profesional de soporte para garantizar la resolución de incidencias o dudas relacionadas con su utilización, así como tener actualizada la tecnología con las mejoras que continuamente se van publicando.

Más allá del software gvSIG Desktop, es importante reseñar que la Asociación gvSIG es la responsable de su mantenimiento y evolución, proporcionando servicios de soporte, desarrollo, formación y consultoría alrededor de dicha solución, así como de gvSIG Suite, el catálogo de soluciones de geomática libre mantenido por la Asociación gvSIG.

Este 2017 ponemos en marcha unos nuevos servicios de soporte paquetizados, tanto a nivel de usuario como de desarrollo. Con este servicio, los usuarios de gvSIG Desktop, pueden mantener el valor del producto, contando siempre con la versión más avanzada y con el soporte de la Asociación gvSIG, la propia organización responsable del mantenimiento y evolución de la aplicación.


¿Qué incluye el soporte anual de gvSIG Desktop?

El Nivel I, para usuarios:

  • Resolución de dudas de usuario: ponemos a disposición un equipo de soporte para solventar todas las dudas y problemas encontrados en el uso de gvSIG Desktop. Con este soporte técnico se obtiene un seguimiento personalizado de las incidencias reportadas, llevándose a cabo las comunicaciones pertinentes para su resolución. Se establecerán mecanismos de comunicación a distancia, portal de soporte y, en su caso, se realizarán visitas in-situ.
  • Gestión del servicio por un Coordinador Técnico. Se trata de un responsable técnico que dispondrá de un conocimiento detallado de las instalaciones y necesidades del cliente. Este conocimiento específico de la instalación, negocio y necesidades del usuario final permitirá identificar de forma mucho más precisa y optimizada las necesidades de soporte y las acciones correctivas, preventivas y/o evolutivas que pueden necesitarse en un momento determinado, tanto en la actualidad como en un futuro planificado.
  • Información de nuevas versiones, actualizaciones y mejoras en el software que la Asociación gvSIG libera periódicamente. Soporte para llevar a cabo las actualizaciones e instalación de nuevos complementos (plugins).
  • Formación para usuarios.
  • Descuentos en otros servicios ofrecidos por la Asociación gvSIG.

En Nivel II, de soporte con servicio de desarrollo incluye:

    • Paquetes de horas de desarrollo orientados a proporcionar mejoras sobre gvSIG Desktop y corrección de bugs requeridos por el cliente. Cada petición se valorará y se comunicará al cliente el consumo de horas requeridos, una vez confirmado por el cliente se procederá a su ejecución. Los paquetes de horas pueden ser de: 160, 320, 480 o 1.000 horas.

Contáctanos en info@gvsig.com

Filed under: Business, gvSIG Association, gvSIG Desktop, spanish Tagged: Soporte
Categories: OSGeo Planet

SourcePole: AutoForm Plugin for QGIS

OSGeo Planet - Fri, 2017-02-10 07:01

The AutoForm plugin for QGIS automatically sets the edit widget type for the fields of a selected layer based on their data types and foreign keys. This is in order to save the user time they may need to spend on manually editing these widgets. In order for this to work correctly, the layer information must be stored in a PostgreSQL database. Furthermore, foreign keys must have a constraint rule for this to work. The plugin does NOT allow you to set relations. It merely checks for any and takes advantage of them accordingly.


When you have a database with a lot of tables, there should be a way for quickly entering data whithout having to configure the input form for each table first. In Switzerland this a common use case when you import Interlis data with ili2pg based on an official data model. ili2pg automatically adds reference constraints based on the Interlis model, which is a prerequisite to detect relations in a generic way.

There is already a plugin with a very similar goal: DataDrivenInputMask written by Bernhard Ströbl. Maybe it was bad luck, but we had always troubles when using it. Once we eventually found out the PostgreSQL driver for the QtSql library was missing and another time we failed to use the plugin because we had a socket based connection to PostgreSQL. In both cases we were stuck in the login dialog without a hint why the connection had failed. Another problem is in some cases that the DataDrivenInputMask plugin writes additional metadata into the original database.

So we decided to make our own proof of concept, hopefully avoiding these problems and having the Swiss “ili2pg” use case in mind. A major conceptual difference is, that AutoForm uses the built-in input form functionality of QGIS instead of creating custom dialogs like DataDrivenInputMask does.

Running the plugin

After you have installed the AutoForm plugin (flagged “experimental”) via the QGIS Plugin repository you should see a new option in the Plugins menu called AutoForm. Clicking on it will give you the option Generate Form. Running this with the layer selected will generate your form. If everything is correctly configured, this next step should be easy.

  • Select a PostGIS layer from the Layers Panel
  • Click on Generate Form

And thats it! Now if you toggle editing you should see the changes which were made. In my case, this was the result:



If your layer had a foreign key reference to one or multiple other tables, then they too were added automatically to the Layers Panel and their values should be selectable in their according fields.

Behind the Scenes

In order to perhaps help a bit with understanding how this Plugin works, I am adding this section for anyone who is curious. The Plugin follows this process:

  • Check if a layer is selected
  • If a layer is selected search for any key relationships to other tables
  • If a foreign key relationship to another table was found the load that table into the project and set the corresponding fields to a Value Relation WidgetType
  • Proceed normally and set the remaining Widgets where applicable

The script checks first if the field has already been changed, so as to prevent user made edits or the previously set Value Relations from being overwritten. Then it takes a look at the typeName() of the field in order to determine which widgettype to assign. For example if the field has the Date Type, it would use the calender widget. It does this for each field in the layer. Should the user wish to make additional changes (or correct any mistakes which might have been made), they can do so in the ‘Fields’ tab of the layer properties.


This plugin is in an early stage and serves as a proof of concept. There is much left to be done, especially in supporting embedded forms for related tables. We also don’t analyze additional metadata written by ili2pg, which would allow to recognize whether related tables are only lookup tables without the need to embed them as entry forms.

The source code is available on Github. If you are interested in collaborating or maybe sponsoring improvements to this plugin, please contact us!

Categories: OSGeo Planet

Fernando Quadro: Smart Cities – Uma visão geográfica

OSGeo Planet - Thu, 2017-02-09 11:54

Isto é simplesmente o equivalente ao mundo tecnológico com um nova roupagem? Estamos vestindo conceitos antigos com uma nova terminologia? Ou podemos realmente começar a entender como nossas cidades estão evoluindo e apoiar os planejadores e desenvolvedores de novas cidades? A percepção de que 75% das pessoas globalmente estarão vivendo nas cidades em 2050 (IBM) requer soluções inteligentes, mas a chave para isso é que os dados que os alimentam sejam precisos e acionáveis. Nossa responsabilidade, portanto, é garantir que o valor da localização seja representado e envolvido o mais cedo possível neste processo.

Ser inteligente, de ‘meu ponto de vista’, é estar levando as fantásticas fontes de dados geoespaciais de vários repositórios diferentes, integradas em um sistema, permitindo que os dados fluam e soluções sejam desenvolvidas à medida que conexões naturais são feitas entre os conjuntos de dados. Isso pode ser simplesmente acompanhamento dinâmico do volume crescente de dados de imagens de satélite, tanto Open (Sentinel e Landsat) como comercialmente disponíveis, ou uma visão mais detalhada dos dados geoespaciais para construir uma compreensão abrangente de um crescimento e desenvolvimento das cidades. Entender a visão de cima já está ajudando as cidades a considerar suas necessidades passadas, presentes e futuras.

Em um recente trabalho de apoio ao Banco Mundial na Tanzânia mostrou exatamente isso: levando os dados Landsat e Sentinel para apresentar não apenas onde a expansão urbana havia ocorrido, mas também quais áreas estão crescendo mais rápido; Igualando uma visão dinâmica em um ambiente urbano – neste exemplo ajudando a direcionar topógrafos para gerar mapas novos e precisos de uma cidade em crescimento.

Figura 1: Crescimento Urbano em Dar es Salaam 2014 – 2015

Somos capazes de interpretar a mudança geográfica dentro do município. O interesse chave é onde a mudança ocorre, na Figura 1 mostra que o setor urbano central não está mudando significativamente, o rápido crescimento está no desenvolvimento não planejado para o norte e sul, demonstrado pelos setores mais escuros de laranja.

O valor está levando esta etapa ainda mais, para mostrar o ambiente dinamicamente em mudança à medida que novas imagens de satélite se tornam disponíveis. A Figura 2 ilustra como a paisagem urbana continua a mudar rapidamente entre 2015 e 2016.

Figura 2: Crescimento Urbano em Dar es Salaam 2015 – 2016

No entanto, quando se olha para o mesmo tipo de dados, neste caso dados de imagens de satélite no Reino Unido, o nosso interesse específico é na mudança do ambiente ocidental, e gira em torno da mudança no espaço verde, desta vez em Milton Keynes.

Figura 3: Mudança do Espaço Verde em Milton Keynes

Smart sugere inteligência, e nesses exemplos simples é a inteligência dos dados convertida em análise para apresentar os resultados relevantes para as perguntas, “onde está crescendo minha cidade?”, Em oposição a”onde os espaços verdes estão perdidos em minha cidade?”; Prioridade e foco dita o que é de maior preocupação, mas intrigantemente a fonte de dados é a mesmo.

Para os geógrafos, a cartografia é o aliado confiável na realização de tornar-se um gênio. Seu poder de combinar múltiplos conjuntos de dados, extrair informações complexas e reunir em forma de uma apresentação elegante faz do mapa a ferramenta de visualização purista do geógrafo. Desta forma, podemos e devemos continuar a abraçar os dados que a cada dia crescem e estão em constante mutação, pois nunca foi tão importante criar mapas claros e facilmente reconhecíveis.

As aplicações inteligentes nos permitem, como empresa, dar esses passos adiante, permitindo-nos entregar não apenas um mapa, mas também os dados de inteligência de negócios associados. No ambiente urbano, podemos dar contexto a um planejador de cidade e desenvolvedor para que eles possam ver e avaliar potenciais atividades de escala macro que podem rapidamente informar e envolver um público mais amplo através de uma representação clara das cidades vivas do século XXI.

Quanto mais rápido transformarmos o complexo em simples, mais rápido apoiamos as decisões necessárias no planejamento e desenvolvimento de cidades inteligentes novas ou existentes.

Esta é uma tradução livre do artigo “Smart Cities – A Geographers view” escrito por Phil Cooper, CIO e Diretor da Sterling GEO.

Fonte: LinkedIn Pulse

Posts RelacionadosSovrn
Categories: OSGeo Planet

gvSIG Team: Aprendiendo SIG con Juego de Tronos (VI): Hiperenlace y otras herramientas de información

OSGeo Planet - Wed, 2017-02-08 06:07

Hoy veremos las herramientas de información, centrándonos en aprender a manejar la herramienta de “Hiperenlace”.

Son 4 las principales herramientas de información: información por punto, consultar área, consultar distancia e hiperenlace. A esas podríamos añadir otras como “Google Street View” que nos permite consultar las imágenes de este servicio de Google…aunque en este caso todavía no hay coches de Google paseando por los paisajes de Juego de Tronos.

Esas 4 herramientas están accesibles en la barra de botones:


Las 3 primeras son muy intuitivas y basta comentar su funcionamiento para que comencéis a probarlo.

Información por punto: nos da información del elemento en el que hagamos clic, estando su capa activa. Nos mostrará una ventana con los valores de ese elemento en su tabla de atributos. Por ejemplo, si teniendo activada la capa “Locations” pulsamos sobre el punto que representa “King’s Landing” (Desembarco del Rey) se nos abrirá la siguiente ventana:


Las herramientas de consultar área y distancia tienen un funcionamiento similar. Una vez seleccionada la herramienta vamos haciendo clics en la Vista y nos va mostrando en un caso información de perímetro y área, y en otro distancia parcial y total. Esta información aparece en la parte inferior de la pantalla, en la denominada barra de estado (también aparece otra información como escala, unidades o coordenadas).


La herramienta de hiperenlace es más compleja, ya que requiere previamente definir en las “Propiedades” de la capa la configuración de los hiperenlaces. Vamos a ver su funcionamiento con un ejemplo práctico.

Repasando el post anterior de “Edición de Tablas” vamos a añadir al campo “Web” de la tabla de atributos de la capa “Political”una serie de enlaces a páginas web con información de las Casas de Juego de Tronos:

El resultado será similar al siguiente:


Ahora vamos a indicarle a la Capa que tiene un campo (“Web”) que es un hiperenlace a una página web.

Para abrir la ventana de Propiedades de una capa pulsamos con el botón secundario sobre el nombre de la capa en la Tabla de Contenidos o bien activamos la capa y vamos al menú “Capa/Propiedades”.


De la ventana que nos abre vamos a la pestaña “Hiperenlace”, que es la que nos interesa en esta ocasión.

Pulsamos “Activar hiperenlace”, seleccionamos el campo “Web” y la acción “Enlazar con ficheros de texto y HTML”.


Ahora ya podemos cerrar esta ventana, pulsando el botón de “Aceptar” y comenzar a utilizar el botón de hiperenlace sobre la capa “Political”.

¿Qué ocurre cada vez que pulsamos sobre un elemento?…pues se abre un navegador (que por cierto se mejorará en la siguiente versión de gvSIG) con información de la página web indicada en la Tabla de atributos. Y que, en este caso, nos da toda la información sobre cada una de la Casas. Por ejemplo al pulsar en el reino del Norte ( “The North”) nos enlaza con la información de la casa Stark:


Ahora vamos a crear otro tipo de hiperenlace. Uno que abra una imagen que tengamos en nuestro ordenador. En nuestro caso los escudos de cada una de las casas, que podéis descargar en un fichero comprimido de aquí.

Para ello primero ponemos la Tabla de atributos de la capa “Political” en edición y añadimos la información de la ruta donde tengáis las imágenes al campo “Shield”. En mi caso:

  • /home/alvaro/Escritorio/Shields/Arryn.PNG
  • /home/alvaro/Escritorio/Shields/Baratheon.PNG
  • /home/alvaro/Escritorio/Shields/Greyjoy.PNG
  • /home/alvaro/Escritorio/Shields/Martell.PNG
  • /home/alvaro/Escritorio/Shields/NightsWatch.PNG
  • /home/alvaro/Escritorio/Shields/Stark.PNG
  • /home/alvaro/Escritorio/Shields/Tully.PNG
  • /home/alvaro/Escritorio/Shields/Lannister.PNG
  • /home/alvaro/Escritorio/Shields/Targaryen.PNG
  • /home/alvaro/Escritorio/Shields/Tyrell.PNG

La Tabla quedará del siguiente modo:


Tal y como hemos hecho anteriormente, redefinimos el hiperenlace indicando que el campo es “Shield” y la acción “Enlazar con ficheros de imagen”:


Si probamos la herramienta “Hiperenlace”, cada vez que pulsemos sobre un elemento de la capa “Political” nos abrirá una imagen con el escudo de la Casa correspondiente. Así si pulsamos en “The Westerlands” (Tierras del Oeste) nos aparecerá el escudo de los Lannister:


Y como nosotros también pagamos nuestras deudas, os emplazamos a un siguiente post de este curso de SIG tan peculiar.

Filed under: gvSIG Desktop, spanish, training Tagged: hiperenlace, informacion, Juego de tronos, medir área, medir distancia
Categories: OSGeo Planet

Equipo Geotux: ¡GeoTux cumple 10 años! Aquí un recuento...

OSGeo Planet - Mon, 2017-02-06 15:33

El 6 de febrero de 2017 el sitio web GeoTux cumple 10 años de creado. En este post hacemos un recuento de lo que han sido esos 10 años.



¿Cómo empezó GeoTux?

GeoTux es hijo de GeoLinUD (Geoinformática en Linux de la Universidad Distrital), un sitio web creado por Samuel Mesa durante sus últimos semestres de Ingeniería Catastral y Geodesia en Bogotá. GeoLinUD tuvo por objeto servir de fuente de información y ayuda en el área de la Geoinformática con software libre.

Al culminar el paso por la universidad e ingresar al ambiente laboral, Samuel quiso fortalecer GeoLinUD y darle un respaldo más profesional. Extendió una invitación a varios compañeros para hacer parte del proyecto. A Germán Carrillo le gustó la idea y decidió hacer parte directa de lo que luego llamarían juntos: GeoTux. Terminaba el año 2006 y comenzaba el 2007 y tras varias reuniones, GeoTux estaba listo para ser publicado (gracias al hosting gratuito francés TuxFamily, que gestionó Samuel) y promovido entre los contactos académicos y laborales de los dos administradores.

GeoTux nació el martes 6 de Febrero de 2007, con el objetivo principal de promover la Geoinformática en software libre. El sitio web colaborativo estuvo listo semanas antes, pero por la proximidad a una fecha especial para Samuel, se decidió aplazar el lanzamiento para el día 6. Se generó material de difusión y muy pronto se publicaron los dos primeros posts relativos a la Geoinformática en Python y a la Construcción de un visor de Shapefiles con MapWinGIS, los cuales sirvieron para empezar a difundir GeoTux a lectores hispanohablantes.

En estos 10 años...

El año 2007 fue muy activo para GeoTux. En julio, Samuel y Germán viajaron a Mocoa, Putumayo, para implementar el SIG de un cabildo indígena NASA del Putumayo, una experiencia inolvidable.

Un poco más tarde, entre septiembre y octubre de…

Categories: OSGeo Planet

gvSIG Team: Learning GIS with Game of Thrones (IV): Selecting tools

OSGeo Planet - Mon, 2017-02-06 13:54

Selecting tools are very important in all the GIS because, among other things, there are a lot of tools that are executed on selected elements. Besides they can be useful to locate elements with specified characteristics easily.

Before starting we remember that, as we saw in the post about Tables, where we select elements of a layer they are selected on its attribute table too (and vice versa).

Selecting tools can be found at the “Selection” menu or in the corresponding button:


Most of the selecting tools are graphical and their working is similar (and very easy). We are going to explain this working and we encourage you to test the different graphical selection tools.

To apply most of the graphical selection tools we have to press the main button of the mouse on the origin point of the selection, then drag and drop to finish selecting. In the selection by polygon case, for example, we have to click on each vertex of it and double click to finish it. And in simple selection option, we only have to click on the element to be selected. 

To add entities to an existing selection, we have to keep “Control” key pressed while we select the elements. If we want to add or remove an element of a group of selected geometries, we have to press “Control” key and click on them. The selected elements are shown in yellow colour.

Have you tested it already?

Well, we’re going to see the non graphical selection tools in detail. Before starting open your “Game of Thrones”project…

Selection by attributes

This tool is in the “Selection/Select by attributes” menu or from the corrresponding button:

It allows to select elements through an enquiry of attributes.

The interface is this one:


  1. Fields. List of attribute fields of the layer. When double clicking on a field it’s added to the enquiry of the selection.
  2. Logical operators. It allows to add a logical expression to the enquiry pressing on them.
  3. Known values. It shows a list with the different values of the selected field. When double clicking on it, it’s added to the enquiry.
  4. Enquiry. Space where the enquiry is being represented. It allows to be written directly.
  5. Selection options.
    • New set. It creates a new selection.
    • Add to set. The results of the new enquiry is added to the existing selection.
    • Select from set. It creates a selection from the existing one. The enquiry is done on the elements selected previously and not on the whole layer.

Now we are going to apply “Select by attribute” tool to select all the castles of our geography. For that we are going to put “Locations” layer active (clicking on its name the name will change to bold). We run “Select by attribute” tool and make this enquiry: “type” = ‘Castle’


When we press “New set” all the castles of the layer will be selected. Now we can consult the attribute table of the layer to check it (as we saw at the “Tables” post) or navigate on the Wiew to see the castles location (as we saw at the “Navigation tools” post).

Select by layer

This tool is available from the “Selection/Select by layer” menu and from its corresponding button:


It allows to select elements from a layer according to its spatial relationship with elements from another layer. 

The interface is this one:


  1. Select items from active layer that are… Pull-down menu that allows us to indicate the selection method. e020_got
  2. Selected items of a layer. It allows us to select the layer for the spatial relationship through a pull-down menu. The elements that we want to take into account have to be selected at that layer. If we want a relationship of the whole layer we would have to select all the elements of that layer.
  3. Selection options. Similar to the “Select by attribute” ones.

Now we are going to do an exercise where we will select all the elements of the “Locations” layer that are located in “The Westerlands”. For that we are going to activate “Political” layer, that includes the different kingdoms of Game of Thrones, and using “Select by attribute” tool we are going to do this query: name = ‘The Westerlands’

We also would be able to select the polygon graphically, but at this way we review the tool that we have just known. Results will be:

021_gotWe have the element selected in our reference layer already. Now we activate the “Locations” layer and we press “Select by layer” tool. In the new window we indicate these options:e021_got

We press “New set” and we will get all the locations contained in “The Westerlands”:


See you in the next post…

Filed under: english, gvSIG Desktop, training Tagged: Selection by attribute, Selection by layer
Categories: OSGeo Planet

Jackie Ng: Announcing: MapGuide Maestro 6.0m6

OSGeo Planet - Mon, 2017-02-06 10:25
Here's another long overdue new milestone release for MapGuide Maestro 6.0.

Here's a summary of what's new.

Friendlier connection error dialog

Rather than say MgConnectionFailedException, perhaps this dialog can explain things better?

Theme support

The latest version of DockPanelSuite supports theming. Maestro now includes a bunch of VisualStudio-style skins that you can choose from the options UI. For example, here's Maestro with the Visual Studio "blue" theme.

Non-modal map previews

Resource previews that use the local map viewer (ie. It doesn't launch an external web browser), now display as additional document-resident view content instead of a modal dialog.


Rather than punching in coordinates for override extents manually, you can now set the extents interactively with Maestro's map viewer component.

Also on that subject, when generating tiles with overridden extents, the total tiles calculation should be more accurate now, having verified the overridden extents against the contents of the physical tile cache, the visual verification made much easier with this new feature.

Other Changes
  • Maestro now has new validation rules for ODBC configuration documents
  • You can now enter a Google Maps API key in the Flexible Layout editor (if you require it)
  • The mapguide-rest addin now generates configuration documents with valid representation nodes
  • Fix NullReferenceExceptions when editing Fusion Flexible Layouts with multiple map groups. A nice timely fix to have to make way in preparation for when this is ready.
  • Upgrading a WebLayout to a 2.4 or newer schema version will now include the MapTip command if it doesn't exist
  • Upgrading a Layer Definition to a 2.4 or newer schema version no longer discards any URL settings.
  • XML editor now automatically trims off null '\0' characters (the source of many bogus content validation errors)
  • FDO stylization functions are no longer falsely reported as unsupported functions by the FDO expression validator.
  • Fusion and Symbol Definition editors should now trigger dirty state more often.
  • IronPython updated to 2.7.7

Categories: OSGeo Planet

gvSIG Team: Geopaparazzi 5.2.0 está aquí y ya es compatible con gvSIG Online

OSGeo Planet - Mon, 2017-02-06 10:19

Para todos los usuarios de SIG móvil y amantes del software libre: Ya está disponible Geopaparazzi 5.2.0 en Google Play. gvSIG Suite continua creciendo.

Está nueva versión, además de arreglar distintos bugs, trae un buen número de interesantes mejoras. Vamos a echar un vistazo a las más importantes.

Geopaparazzi + gvSIG Online

Probablemente la mejora más destacable sea la compatibilidad de la nueva versión de Geopaparazzi con gvSIG Online. Esta integración se enmarca en el trabajo que estamos realizando desde la Asociación gvSIG para disponer de una completa suite de productos de geomática libre, en este caso de la mano de nuestras empresas HydroloGIS y Software Colaborativo.

Gracias a esta integración podemos importar y exportar proyectos de Geopaparazzi y bases de datos SpatialLite desde y hacia gvSIG Online. En definitiva, lo importante es que tendremos sincronizada nuestra IDE con las aplicaciones móviles para trabajo de campo. ¡Y desde nuestro gvSIG Online podremos crearnos en minutos nuestras aplicaciones de campo!

Además esta versión permite agregar imágenes (fotografías) a las geometrías de una determinada capa. Cuando se selecciona un elemento y se están editando sus atributos veremos un nuevo icono con una cámara que nos permitirá asociar fotografías a ese elemento:

geopaparazzi_01Pulsando sobre él veremos las imágenes ya asociadas, pudiendo añadir otras nuevas:

geopaparazzi_02Herramientas de zoom

Varios usuarios nos habían preguntado por la posibilidad de disponer de un “zoom-sobre-el-zoom”, facilitado por la alta resolución de los nuevos dispositivos. La idea es tener un zoom secundario (al que llamaremos escalado) que trabaje en paralelo al zoom geográfico. Cuando hacemos un zoom geográfico muchas veces cambia la representación de los elementos cartográficos, con un zoom escalado no.

Ahora, para cada nivel de zoom geográfico, el usuario podrá escalar la imagen para hacerla más legible. En cierto modo funciona como una lupa que agranda la visualización del zoom geográfico utilizado en ese momento.
La mejor forma de entender esta nueva funcionalidad es con esta imagen comparativa:

zoom_geopaparazziDos consecuencias menores de esta nueva funcionalidad son:

  • Hemos cambiado el icono de posición con una imagen vectorial para evitar el pixelado.
  • Al realizar un centrado con GPS hay que tener en cuenta que los límites de la pantalla se ven afectados por la escala.
Cargar directorios de datos

Con la nueva versión podemos cargar directorios de tileados o de bases de datos Spatialite.

Podéis comprobar como aparece un nuevo icono en la equina inferior izquierda, desde la vista de añadir fuentes (add-sources):


GPS Status

GPS Status, usado anteriormente y que no es software libre, ya no será utilizada para conocer el estado del GPS. En su lugar se utilizará la app GPS Test, que sí es software libre y, por tanto, encaja perfectamente con nuestra filosofía.


Más mejoras…

La nueva versión de Geopaparazzi trae soporte para WMS 1.3, actualización de idiomas, y mejoras de optimización y rendimiento en relación a las últimas versiones de Android.

Esperemos que os gusten estas mejoras. ¡Disfrutadlas!

Filed under: english, Geopaparazzi, gvSIG Mobile, gvSIG Online, press office Tagged: gvSIG Suite, Mobile GIS
Categories: OSGeo Planet

GeoSolutions: GeoSolutions al FOSS4G-IT 2017 a Genova

OSGeo Planet - Mon, 2017-02-06 09:51


Cari lettori,

GeoSolutions sarà presente alla conferenza italiana sul software geografico e sui dati geografici liberi (FOSS4G-IT 2017) nei giorni dall'8 all'11 Febbraio 2017 a Genova (maggiori dettagli qui)

Durante l'evento verranno presentati i migliori lavori sull’utilizzo, lo sviluppo e la diffusione delle applicazioni libere e a codice aperto (Free and Open Source Software) in ambito GIS.

La giornata dell' 8 Febbraio sarà dedicata a workshop introduttivi su GeoServer  e su GeoNode,

nelle giornate successive (9 e 10 Febbraio) si terranno le conferenze su MapStore 2, GeoServer e GeoNode con interventi degli sviluppatori sul software libero sui principali progetti Desktop GIS e WebGIS.

Di seguito il programma dei nostri workshop e delle nostre presentazioni:

  • GeoServer, il server Open Source per la gestione interoperabile dei dati geospaziali, Giovedi 9/2, ore 12:40
  • MapStore 2: Modern WebMapping con OpenLayer 3, Leaflet e React, Giovedi 9/2, ore 12:50
  • GeoNode, il CMS geospaziale Open Source,  Venerdi 10/2, ore 15:20
Ricordiamo che i workshop sono accreditati presso l'ordine degli architetti e presso l'ordine degli ingegneri. La conferenza sarà anche l'occasione per parlare di come poter soddisfare i vostri bisogni attraverso i nostri prodotti e i nostri piani di supporto. Vi aspettiamo numerosi! Il team di GeoSolutions, 320x100_eng
Categories: OSGeo Planet

gvSIG Team: Aprendiendo SIG con Juego de Tronos (V): Edición de tablas

OSGeo Planet - Mon, 2017-02-06 06:18

Seguimos con el mini-curso de introducción a SIG con Juego de Tronos. Con el post de hoy comenzamos a revisar las herramientas de edición alfanumérica. Partiendo de la capa “Political” que contiene los reinos del continente denominado “Westeros” o “Los Siete Reinos” vamos a completar la información alfanumérica original con la frase de la casa reinante y dos campos que nos servirán para ver (en un siguiente post) como funciona la herramienta de “Hiperenlace”.


Una vez abierto nuestro proyecto, activamos la capa “Political”y abrimos su tabla de atributos, tal y como vimos en el post “Tablas”. Esta tabla de atributos tiene 3 campos: id, name (nombre del reino) y ClaimedBy (Casa dominante). Es el momento de comenzar la edición y añadir 3 campos adicionales.

Para comenzar la edición vamos al menú “Tabla/Comenzar edición” o pulsamos el botón correspondiente:

024_gotSi tenéis la Vista visible veréis que el nombre de la capa (“Political”) se ha puesto de color rojo, lo que nos indica que está en edición.

025_gotVamos a añadir las 3 columnas, una a una. Hay varias formas de hacer esto, vamos a ver la más sencilla, utilizando la herramienta del menú “Tabla/Añadir columna” o su botón correspondiente:

026_gotAl pulsar el botón nos aparecerá una nueva ventana que nos pide definir: el nombre del campo, el tipo, el tamaño (número de caracteres permitidos), precisión (sólo para campos de tipo numérico) y valor por defecto (este es opcional, si no ponemos nada las celdas aparecen vacías).

028_gotLos valores de los 3 campos nuevos a crear serán:

  • Nombre: Words, Tipo: String, Tamaño: 50
  • Nombre: Shield, Tipo: String, Tamaño: 100
  • Nombre: Web, Tipo: String, Tamaño: 100

Una vez añadidos los 3 campos nuestra tabla quedará así:

029_gotAhora ya podemos pasar a rellenar con valores las celdas de cada uno de ellos. Para ello basta con hacer doble clic en la celda en la que queremos añadir datos y comenzar a escribir. Con este procedimiento vamos rellenando cada una de las celdas.

Para el campo “Words” añadiremos las siguientes frases para cada una de las Casas Reinantes:

  • Tully: “Family, Duty, Honor”

  • Stark: “Winter is Coming”

  • Greyhoy: “What Is Dead May Never Die”

  • Martell: “Unbowed, Unbent, Unbroken”

  • Baratheon: “Ours is the Fury”

  • Arryn: “As High as Honor”

  • Lannister: “A Lannister Always Pays His Debts”

  • Targaryen: “Fire and Blood”

  • Tyrell: “Growing Strong”

El resultado debe ser similar a este:

030_gotComo hemos comentado los otros dos campos los trabajaremos en un siguiente post relacionado con los hiperenlaces. Por tanto finalizamos la edición de la tabla en el menú “Tabla/Terminar edición” o en su botón correspondiente:

031_gotAntes de finalizar es importante comentar que hay una herramienta que nos permite editar los valores alfanuméricos de los elementos de una capa desde la misma Vista. En ocasiones esto nos puede ahorrar tiempo en nuestras tareas de actualización de datos.

Para probarla, desde nuestra Vista y con la capa “Political” activada, pulsamos el botón “Editor de atributos”:

032_gotPara usarla vamos con que vayamos pulsando en el elemento a editar, nos abrirá una ventana con sus atributos alfanuméricos y podremos modificarlos.

033_gotProbadla y comprobad su funcionamiento. Para terminar pulsar el botón de esa misma ventana de “Terminar edición”.

Seguiremos aprendiendo en siguientes post…

Filed under: gvSIG Desktop, spanish, training Tagged: Añadir columna, Edición alfanumérica, Tablas
Categories: OSGeo Planet

QGIS Blog: Minutes of the Inaugural QGIS General Meeting (2016)

OSGeo Planet - Sun, 2017-02-05 22:03

Dear QGIS community members

At the end of December 2016, we held our inaugural Annual General Meeting (AGM). It should be noted that QGIS AGM’s will be ‘virtual’ meetings conducted as a questionnaire (for voting / raising motions) and then a report such as the one below, with optional follow up email discussion if deemed necessary. The reason for this is that our community is spread far and wide and any attempt at an in-person (physical or virtual) meeting will prove very difficult given the number of different time zones the participants live in. Thus this, and future, AGM reports will be a reflection / summary of the various online activities that constitute the ‘AGM’ and the reports should be read with this understanding in mind.  It should also be kept in mind that because we are bootstrapping the QGIS Board, the 2016/ 2017 meetings follow a reduced agenda – the 2018 meeting will commence with the full AGM agenda since we will have a year of financial reporting / board activity etc. behind us. Here follow the minutes:


Minutes of the Inaugural General Assembly (AGM) 2016 – Concluded 22 December 2016

Dear QGIS.ORG voting members,

In December 2016 we held a special Inaugural AGM event in order to bootstrap the new governance structures for QGIS.ORG. The following items were tabled during our special AGM to cater for the needed transition from the old organisation to the new:

Election of incoming board and PSC member replacements

Under our statutes, existing board / PSC members are automatically put forward for re-election during our PSC elections. A call for nominations was held and closed on 15 December 2016. All voting members were elegible to put forward their nominations. The following valid nominations were received (i.e. for candidates who were not already PSC members):

  1. Régis Haubourg

Subsequent to the call for nominations, an election was held via online vote. Response rate was 20 out of 27 eligible voters. Under our statutes this is considered a quorum. Election results were as follows:

Position Name Votes Received Max Votes Chair: QGIS Board Tim Sutton 19 20 Vice-Chair: QGIS Board Paolo Cavallini 12 20 Treasurer: QGIS Board Andreas Neumann 20 20 PSC Member Richard Duivenvoorde 17 20 PSC Member Anita Graser 16 20 PSC Member Jϋrgen Fischer 14 20 Honorary PSC Member Gary Sherman – –

Note that each voting member was allowed 6 votes, but was not allowed to vote for the same person more than once. For the Board Member positions, which were specifically named, the candidate with the greatest number of votes for each role assigned that role. The PSC member positions were calculated based on the total number of votes each candidate received (including those allocated to named board roles). In accordance with our statutes, Gary Sherman remains on the PSC on a permanent basis as Honorary PSC member.

Election of the board chair

Election of the board chair was carried out as part of the general voting process. The successful candidate was Tim Sutton.

Matters brought forward by voting members

There were no matters brought forward by voting members.

Annual AGM for 2017

Now that the special AGM has been held and the Board and PSC constituted, we will hold our first AGM in the first quarter of 2017 (and then each year thereafter will be held in the first quarter). The 2017 AGM will be a reduced format since we will have just elected the PSC and Board,

Agenda for 2017 AGM:

  1. Approval of the annual report (2016) by the chair
  2. Approval of the annual financial report (2016)
  3. Approval of the 2017 budget
  4. Election of two financial auditors for the upcoming year
  5. Deal with matters brought forward by voting members


Given the outcomes of the end-2016 AGM, the QGIS Governance now looks like this (click for larger version):


If you have any queries about the QGIS Governance processes, please do not hesitate to ask!



Tim Sutton (QGIS Project Chair)


Categories: OSGeo Planet
Syndicate content