4

I don't think this question can actually be answered definitively as there are many, many ways of approaching this .. However, these thoughts may be relevant: The data storage is relatively unimportant. Whatever mechanism you use, Database, JSON, KML, etc, it is still "flat storage". What is important is the software you use and how you represent the ...


2

Change you script in: ##difference_between_pst/astenot=name ##output_alg0=output vector ##output_alg1=output vector ##output_layer_alg2=output vector ##output_layer_alg3=output vector vectorlayer_1 = "pst" vectorlayer_2 = "astenot" outputs_0=Processing.runalg("qgis:difference", vectorlayer_1, vectorlayer_2, output_alg0) outputs_1=Processing.runalg("qgis:...


2

Don't know if this helps you, because I think UTDF is not very "europe related". What I know, there are a lot of different combinations of spatial database model <-> Exchange Format <-> Traffic analysis software. It depends mostly on the exchange format which is supported by your traffic analysis software, but its very hard to get out of the box ...


2

The Infrastructure for Spatial Information in Europe (INSPIRE) has a land use data model. Here's an overview. Here's a comparison between the Plan4all and INSPIRE Land Use Data Model. Can't find a document about just the Plan4all data model though, will post it here if I do find it.


2

There isn't really a "best practice" for SSDM but using the data dictionary in conjunction with populating the data model is a huge help. The "best practice" is to reference the associated data dictionary (the OGP model has one) with what attribute should be used in each field. Additionally, look at the geometry of each feature class to determine if you ...


1

You are correct that there is no equivalent in PostgreSQL to the coded value domain available in ArcGIS. The simplest option may be to just create lookup tables, one for each domain, then map the code and description appropriately for each use. You can even apply constraints on the code and description columns to ensure input validation. Here is an example ...


1

Esri have several pages specific to electricity industry: Esri - Electric Energy Utilities (includes ArcGIS MultiSpeak) Data Model (PDF) ArcGIS for Electric and Gas Some of the downloads on those pages may also include a pre-built geodatabase using an electric data-model that can be used to create your own. We used their water-network model to create ours ...


1

As I understand it, a zombie entity is basically one that is either unknown or not properly defined. I found another report of this (I work for Safe Software) and the developer told us: "this seems to be a misunderstanding of proxy and zombie entities. Basically, zombie entities are a category of entity which is not fully defined, or not fully ...


1

This is rather old (1994) so predates RDF/OWL by a long way, but may be of theoretical interest. It was developed independently from, but around the same time as, Geographic Markup Language (GML), and is more of a conceptual discussion than a comprehensive catalog. Towards a geographic semantic database model, by M Feuchtwanger (me). Here's the abstract: ...


1

Just sort the data by increasing density and remove records until up to 2% of the population has been eliminated. Here are the details if you're unfamiliar with this kind of analysis in ArcGIS: Compute population density by dividing population by area. (If you don't have areas, compute them. It's best to use an equal-area projection, but for most cities ...


1

Here is what a definition query would look like that could do this: -- For 3 highest gas prices GASID IN ( SELECT TOP 3 GASID FROM gasprices GROUP BY GASID ORDER BY AVG(Price) DESC) -- For 3 lowest gas prices GASID IN ( SELECT TOP 3 GASID FROM gasprices GROUP BY GASID ORDER BY AVG(Price) ASC) You are trying to select features by GASID and not by average ...


Only top voted, non community-wiki answers of a minimum length are eligible