topic Re: Query builder in Geoprocessing Questions

Query builder

MassimoSpirlandelli — Tue, 14 Oct 2014 07:42:31 GMT

In my "level curves" (1 meter definition) shp file I want to query:

- the pair numbers (for instance: 102, 104, 106, 108, 110 , ect. ect.)

- every five meters (for instance: 100, 105, 110, 115, 120, 125, ect. ect.)

How can I do quickly instead of select every single record?

Is there any query?

thank you

Re: Query builder

JohannesBierer — Tue, 14 Oct 2014 07:54:49 GMT

With python:

for i in range(102, "End", 2): print i

Re: Query builder

MassimoSpirlandelli — Tue, 14 Oct 2014 08:00:02 GMT

could you explain me clearly with details (I have never used directly python) ?

Re: Query builder

JohannesBierer — Tue, 14 Oct 2014 08:23:24 GMT

The best is to create a model with select by attribute - then export the model to python and modificate the python code with the for i in range command?

Re: Query builder

MassimoSpirlandelli — Tue, 14 Oct 2014 08:46:11 GMT

ok but with query builder it isn't possible ?

Re: Query builder

DanPatterson_Retired — Tue, 14 Oct 2014 09:03:31 GMT

if you have to do this with a lot of records, consider building a temporary field then you can query that field for the appropriate ranges see the example of using the mod (%) function in python. Unfortunately the query builder doesn't support native python at present.

Re: Query builder

MassimoSpirlandelli — Tue, 14 Oct 2014 09:13:31 GMT

THANK YOU !

easy and fast !!