Querying Oracle from Client Applications Outline (1) Linking ArcView to external database engines o SQL Connect and Database connectivity extensions o Solving the MA population density problem (from the first lecture) o Mapping zoning variances (preview of Lab #5) (2) Creating 'pin maps' from tabular X/Y data (preview of Lab #5) o Event themes in ArcView o Converting lat/lon data - zoning and EPA envirofacts examples o Projecting zoning data to Mass State Plane coordinates MA Density Example <<Use SQL in Oracle to handle one-to-many problemsthat arise because the population total for each town isassociated with each of the polygons (such as Boston islands)that comprise a Massachusetts Town.>> sqlplusconnect zoning/xxxx <<examine selected columns from matowns2000, broughtinto Oracle by exporting from ArcView into INFO tableand using ArcInfo connection to Oracle>> describe matowns2000Name Null? Type ----------- -------- ---------------------------- AREA NUMBER(63) TOWN_ID NUMBER(38) TOWN VARCHAR2(21) POP80 NUMBER(38) POP90 NUMBER(38) POP_CH NUMBER(38) create view matown2000tot as select town_id, town, max(pop90) pop90, sum(area) area, 10000*max(pop90)/sum(area) pop_hectfrom matowns2000 where town_id > 0 group by town_id, town; <<pull this View into ArcView using SQL
View Full Document