To find a parcel in a survey industry model

1. 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.

2. 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.
3. Expand the industry model node and click Feature Search Administrator.
4. Click Create.
5. Enter a name.
6. For Type, select Flat Search.
7. 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

8. 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%') AND
   

   UPPER(NUMERO) LIKE UPPER('1002')
   

9. Executed geometry statement for the result row:

   SELECT GEOM FROM V_IMMEUBLE WHERE FID=20407749