| Author |
 Topic |
|
|
Yochanan
1 Posts |
 Posted - 03/28/2005 : 9:44:09 PM
|
Hi:
I have the following cadastral database:
land_parcel(id: number, boundary: POLYGON);
land_ownership(id: number, owner_name: string,
driver_licence_num: number, land_value: number);
suburb(name: string, boundary: POLYGON);
where land_ownership.id is a foreign key to land_parcel.id, and land_value is city council's valuation of the land.
PROBLEM: I would like to obtain the SQL for the following queries where the ORDBMS supports the data type POLOYGON.
 1) The area affected by road noise from a proposed highway can be represented as a polygon. Write a query in an SQL-like query language to find the land parcels affected by a given flight path.
2) Write a query in an SQL-like language to find which suburbs are affected by the proposed highway, and for each affected suburb the total land value for the land parcels affected in that suburb.
Your assistance is appreciated.
Regards,
Yochanan
|
|
|
GIS Department
54 Posts |
Posted - 03/30/2005 : 2:31:44 PM
|
Yochanan,
Thank you for your post. A bit of clarification, this forum is specific to Boone County GIS datasets and users. If you are using a specific GIS program, such as ArcGIS, I would suggest posting your questions at http://support.esri.com/index.cfm?fa=forums.gateway
Thank you for your time and good luck,
Jason Warzinik
Boone County GIS Program Manager |
 |
|
| |
Topic |
|
|
|
cadastral database - queries
