Vjylku

Is this Paypal Github SDK reference really a dangerous site?

Help! My Character is too much for her story!

Is there a logarithm base for which the logarithm becomes an identity function?

What would be the most expensive material to an intergalactic society?

The preposition for the verb (avenge) - avenge sb/sth (on OR from) sb

Is there stress on two letters on the word стоят

What is this tube in a jet engine's air intake?

Locked Away- What am I?

How to make sure I'm assertive enough in contact with subordinates?

Computation logic of Partway in TikZ

(Codewars) Linked Lists-Sorted Insert

Do black holes violate the conservation of mass?

What does *dead* mean in *What do you mean, dead?*?

What can I do if someone tampers with my SSH public key?

Optimal Proportions for Flying Humans

How do I raise a figure (placed with wrapfig) to be flush with the top of a paragraph?

What does the Digital Threat scope actually do?

Idiom for feeling after taking risk and someone else being rewarded

Professor forcing me to attend a conference, I can't afford even with 50% funding

Did Amazon pay $0 in taxes last year?

I am the person who abides by rules, but breaks the rules. Who am I?

Movie: boy escapes the real world and goes to a fantasy world with big furry trolls

Insult for someone who "doesn't know anything"

Is it possible to clone a polymorphic object without manually adding overridden clone method into each derived class in C++?

Show towns per province using QGIS value relation widget?

QGIS Value Map Edit Widget with properties dependent on another fieldHow to use buffer() in QGIS Value Relation field*Value relation* widget in QGISSelect intersecting features within Value Relation WidgetImporting Data Dictionary (DDF) into QGIS (Fields)Creating an Action using the Value column in Value Relation widgetJoining two datasets based on matching values in multiple fieldsDisplay value relation QGISSpatial join of feature class on layer class with PyQGISSum a Value Relation field in field calculator

0

I have basic (maybe a little more) knowledge of databases and GIS.

I study Archaeology and for my thesis I am designing a local database in QGIS (consist of shapefiles with their relationships). I have to prototype the design and test it in a GIS. Since the database is for managing Dutch archaeological projectdata (not to confuse with excavation data), each shapefile contain the fieldnames "province" and "town" so we can locate the project. We can conclude that one province has many towns. I want the field "town" depend on field "province".

There are some issues... I made a .csv file with 2 fields "Value" and "Description" as like in QGIS Value Map widget. Value contains all the provinces and description the towns. In Value Relation widget in QGIS I get the province multiple times in the field. Both 'key column' and 'value column' is the value (province) of the .csv file. I would like to see each province name once.

Second, if I choose province A in field "province", I would like to see the towns of province A in field "town" and not all towns of province A,B,C...

Did I made my .csv file on a wrong way?

Or do I have to write an expression?

Which I tried, but I could not manage it to work... As I said I am an Archaeology student, not an ICT student. The first picture shows a part of my .csv in excel. The second shows what I did in the Value Relation widget. The third shows that I get all the provinces multiple times and the last shows that I get all towns (of all provinces).

qgis table

share|improve this question

edited 5 mins ago

PolyGeo♦

53.6k1781243

asked 8 hours ago

FeliceFelice

1

New contributor

Felice is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Are you looking for "drill-down (cascading) forms"? This feature was introduced in QGIS 3.2, check out the changelog and tutorial video here: changelog.qgis.org/en/qgis/version/3.2.0/…
  
  – csk
  7 hours ago
  
  
  

  
  
  
  

add a comment | 

0

I have basic (maybe a little more) knowledge of databases and GIS.

I study Archaeology and for my thesis I am designing a local database in QGIS (consist of shapefiles with their relationships). I have to prototype the design and test it in a GIS. Since the database is for managing Dutch archaeological projectdata (not to confuse with excavation data), each shapefile contain the fieldnames "province" and "town" so we can locate the project. We can conclude that one province has many towns. I want the field "town" depend on field "province".

There are some issues... I made a .csv file with 2 fields "Value" and "Description" as like in QGIS Value Map widget. Value contains all the provinces and description the towns. In Value Relation widget in QGIS I get the province multiple times in the field. Both 'key column' and 'value column' is the value (province) of the .csv file. I would like to see each province name once.

Second, if I choose province A in field "province", I would like to see the towns of province A in field "town" and not all towns of province A,B,C...

Did I made my .csv file on a wrong way?

Or do I have to write an expression?

Which I tried, but I could not manage it to work... As I said I am an Archaeology student, not an ICT student. The first picture shows a part of my .csv in excel. The second shows what I did in the Value Relation widget. The third shows that I get all the provinces multiple times and the last shows that I get all towns (of all provinces).

qgis table

share|improve this question

edited 5 mins ago

PolyGeo♦

53.6k1781243

asked 8 hours ago

FeliceFelice

1

New contributor

Felice is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Are you looking for "drill-down (cascading) forms"? This feature was introduced in QGIS 3.2, check out the changelog and tutorial video here: changelog.qgis.org/en/qgis/version/3.2.0/…
  
  – csk
  7 hours ago
  
  
  

  
  
  
  

add a comment | 

I have basic (maybe a little more) knowledge of databases and GIS.

I study Archaeology and for my thesis I am designing a local database in QGIS (consist of shapefiles with their relationships). I have to prototype the design and test it in a GIS. Since the database is for managing Dutch archaeological projectdata (not to confuse with excavation data), each shapefile contain the fieldnames "province" and "town" so we can locate the project. We can conclude that one province has many towns. I want the field "town" depend on field "province".

There are some issues... I made a .csv file with 2 fields "Value" and "Description" as like in QGIS Value Map widget. Value contains all the provinces and description the towns. In Value Relation widget in QGIS I get the province multiple times in the field. Both 'key column' and 'value column' is the value (province) of the .csv file. I would like to see each province name once.

Second, if I choose province A in field "province", I would like to see the towns of province A in field "town" and not all towns of province A,B,C...

Did I made my .csv file on a wrong way?

Or do I have to write an expression?

Which I tried, but I could not manage it to work... As I said I am an Archaeology student, not an ICT student. The first picture shows a part of my .csv in excel. The second shows what I did in the Value Relation widget. The third shows that I get all the provinces multiple times and the last shows that I get all towns (of all provinces).

qgis table

share|improve this question

edited 5 mins ago

PolyGeo♦

53.6k1781243

asked 8 hours ago

FeliceFelice

1

New contributor

Felice is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share|improve this question

edited 5 mins ago

PolyGeo♦

53.6k1781243

asked 8 hours ago

FeliceFelice

1

New contributor

Felice is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share|improve this question

edited 5 mins ago

PolyGeo♦

53.6k1781243

asked 8 hours ago

FeliceFelice

1

New contributor

Felice is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

edited 5 mins ago

PolyGeo♦

53.6k1781243

edited 5 mins ago

PolyGeo♦

53.6k1781243

asked 8 hours ago

FeliceFelice

1

New contributor

Felice is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 8 hours ago

FeliceFelice

1