Hey!

I have a problem
with my PostGIS database. Trying to get it much more efficient. It contains
information from several counties, which means I read a lot of unnecessary
information that I do not need and the computer is giving up.

Something similar
"Fastkart.ak = '2085' and all information within 2085 from
Fastkart.by" is what I need to do. But can’t figure out how. I’ve tried
many hours to write clause under feature type and also by using sqlexecutor.

Figure 1 shows all
tables in the database. Often when I am going to read information from my
municipality, it must read all the municipalities' buildings eg which makes it
very big amounts. Of course, you can drive a clipper directly after the base
but would be better if I could get the data base to read no information other
than it by 2085.

Anyone know if it’s
possible to write "Where clause" directly in the database when you do
not have matching information I attribute table?

(That would be the
best option)

Option 2 belongs to
the pictures 2,3,4

The pictures
3.1.3.2 show the attribute tables that I am interested in. They have no
attribute matching each other and therefore I need to do intersect, within,
spatial join or similar.

Stored fixed map.ak
contains the polygon that shows the surface of my municipality. That has
reached 2085. Fastkart.by contains all buildings.

Would you like to
write a "Where clause" where I get all the information from
fastkart.by that is located within fastkart.ak2085.

In Figure 4 you
will see my last attempt to do this with the sql executor.

Can’t load
workbench with database for privacy reasons.