[Cartoweb-users] Newbie help: Add search function with PostGIS-data

[R. Paul Warriner]

Hello Steven,

The attached is the searchTool plugin that was created for our Town by
camptocamp. It may be a place to start...

I don't have time to put together the entire code base for you, but for what
it is worth, I will be posting my progress in the future to:
http://www.orchardparkny.org/town/gis/gis.htm

It uses an external search lookup to the following composite table:
CREATE TABLE geninfo_perftable (
    gid integer,
    the_geom geometry,
    print_key character varying(50),
    roll_yr integer,
    parcel_id bigint,
    "owner" character varying(70),
    street character varying(30),
    full_parcel_adress text,
    type_of_property character varying,
    building_style character varying,
    sbl character varying(25),
    usd_land_assesed_value numeric(20,4),
    usd_total_assesed_value numeric(20,4),
    usd_county_taxable_value numeric(20,4),
    usd_town_taxable_value numeric(20,4),
    usd_school_taxable_value numeric(20,4),
    usd_village_taxable_value numeric(20,4),
    usd_star_town_taxable_value numeric(20,4),
    usd_star_school_taxable_value numeric(20,4),
    usd_total_assesed_value_sqft numeric,
    usd_full_market_value numeric(20,4),
    yr_built integer,
    usd_sales_price numeric,
    usd_sales_price_sqft numeric,
    sales_date character varying,
    usd_exeption_amount numeric,
    surface_building_square_footage bigint,
    surface_lot_size numeric,
    bathroom_nbr integer,
    bedroom_nbr integer,
    fireplace_nbr integer,
    basement_type character varying,
    nbhd_code text,
    admin_nbhd_code numeric,
    image_path character varying,
    unique_id integer DEFAULT nextval('batch_unique_id'::regclass) NOT NULL
);


Regards,
Paul

-----Original Message-----
From: cartoweb-users-bounces at lists.maptools.org
[mailto:cartoweb-users-bounces at lists.maptools.org] On Behalf Of Steven De
Vriendt
Sent: Tuesday, March 06, 2007 10:21 AM
To: CartoWeb Lista de Usuários
Subject: [Cartoweb-users] Newbie help: Add search function with PostGIS-data

Hi,

I'd like to add a search function based on parcel, address,...data in
CartoWeb. This
data is stored in PostGIS. I have no idea on where to begin adding
this search function.
Can someone point me out on how to achieve this ?

thanks
Steven
_______________________________________________
Cartoweb-users mailing list
Cartoweb-users at lists.maptools.org
http://lists.maptools.org/mailman/listinfo/cartoweb-users
-------------- next part --------------
A non-text attachment was scrubbed...
Name: searchTool.zip
Type: application/x-zip-compressed
Size: 60226 bytes
Desc: not available
Url : http://lists.maptools.org/pipermail/cartoweb-users/attachments/20070307/de4d8f82/searchTool-0001.bin