For pictures with "o" beginning, will be found in other dir. Use comments to give credit. Page generation should suppress copyright. Column name Type Nulls pict_id serial no filename char(30) yes book_area char(30) yes |8.0| burbank|8.0| claremont|22.0| commerce|4.0| downtown|118.0| duarte|7.0| east la|253.0| hermosa beach|16.0| highland park|39.0| hollywood|136.0| la airport|14.0| long beach|100.0| mid-city|123.0| near|4.0| pasadena|16.0| san fernando|114.0| san gabriel|2.0| santa monica|49.0| silver lake|108.0| south la|77.0| venice|66.0| vernon|38.0| west la|55.0| whittier|10.0| book_num char(8) yes picture_1 char(8) yes picture_2 char(8) yes picture_3 char(8) yes picture_4 char(8) yes picture_5 char(8) yes picture_6 char(8) yes picture_7 char(8) yes picture_8 char(8) yes thumbnail char(9) yes title varchar(120,0) yes artist varchar(250,0) yes artist_1 char(70) yes artist_2 char(70) yes artist_3 char(70) yes artist_4 char(70) yes artist_5 char(70) yes artist_6 char(70) yes sponsor varchar(120,0) yes key_interior char(1) yes key_exterior char(1) yes key_commercial char(1) yes key_cultural char(1) yes key_political char(1) yes key_community char(1) yes key_landscape char(1) yes key_union char(1) yes key_church char(1) yes key_school char(1) yes key_religious char(1) yes key_kids char(1) yes key_gang char(1) yes key_spraypaint char(1) yes key_sparc char(1) yes key_mta char(1) yes key_virgin char(1) yes key_cornucopia char(1) yes key_coke char(1) yes key_corporate char(1) yes key_memorial char(1) yes destroyed char(1) yes rating char(1) yes |5.0| |8.0| 0|77.0| 1|14.0| 2|228.0| 3|856.0| 4|195.0| 5|4.0| permis char(1) yes |4.0| |5.0| a|78.0| d|36.0| n|67.0| o|89.0| p|1102.0| s|6.0| location varchar(80,0) yes address varchar(80,0) yes comment char(2000) yes modified_by char(8) yes modify_date date yes done_yn char(1) yes archive_yn char(1) yes entered_by char(8) yes enter_date date yes Column name Type Nulls area char(30) yes area_tr char(60) yes max_num integer yes found_num integer yes tot_num integer yes Column name Type Nulls artist char(70) yes num_murals integer yes first_name char(70) yes last_name char(70) yes stat_code char(1) yes filename char(70) yes last_caps char(70) yes Column name Type Nulls roll char(7) yes proc_date date yes Column name Type Nulls key_code char(20) yes key_name char(20) yes key_desc char(70) yes