- Create a view to compose the data (locations) in a flat table, as follows:
SELECT
d.fid, trim(a.value) district, b.nom commune, c.numero, d.geom
FROM
district_tbd a, commune b, immeuble c, bf_tsur d, bf_tcen e, bien_fonds f
WHERE
a.id = b.no_district AND
substr(c.identdn,4,3) =
decode(length(b.numcom),1,'00'||b.numcom,2,'0'||b.numcom,b.numcom) AND
f.fid_bien_fonds_de = c.fid AND
e.fid_centroid = f.fid AND
e.fid_tsur = d.fid
ORDER BY
a.value, b.nom, length(c.numero), c.numero
This view can be very complex. Be careful about performance. The order of the input attributes does not matter, but you should have at least one input attribute.
- In the Infrastructure Administrator, do one of the following:
- Click Enterprise and connect to the enterprise industry model. Open a project.
- Click File and open an industry model drawing or template.
- Expand the industry model node and click Feature Search Administrator.
- Click Create.
- Enter a name.
- For Type, select Flat Search.
- In the Settings tab, enter the following values: (Define the different attributes so Feature Search knows which attributes contain which data.)
Input
Value
Table Name
V_Immeuble
Attribute Description 1
District
Attribute 1
DISTRCIT
Attribute Description 2
Commune
Attribute 2
COMMUNE
Attribute Description 3
Number
Attribute 3
NUMERO
Key Attribute
FID
Geometry Attribute
GEOM
- Using the previous definitions, when you start the search, the program will execute the following select statement: (The example is filled with some sample input data).
SELECT FID,DISTRICT,COMMUNE,NUMERO
FROM V_IMMEUBLE
WHERE UPPER(DISTRICT) LIKE UPPER('Lau%') ANDUPPER(NUMERO) LIKE UPPER('1002') - Executed geometry statement for the result row:
SELECT GEOM FROM V_IMMEUBLE WHERE FID=20407749