The Faulted Earth tool needs new tables (sorry about the strange naming of some of the table columns, there is a 10 character limit on column names to be use for shapefiles) to be generated by Django models: traces, fault_summary, fault, and fault_source
* traces:
the traces table need to have the following columns:
id PK integer
the_geom geometry (multistring polyline)
section_name character varying(30)
loc_meth character varying(30)
scale integer
accuracy integer
geom_exp character varying(30)
notes text
* fault_summary
The fault summary table is already completed, but many need to be altered (primary key, foreign key, we will have to remove the_geom column etc.)
* fault
The fault table will be just like the fault_summary table but with out the_geom column
* fault_source
id PK integer
fault_name character varying(30)
fault_polygon double
length double precision
u_sm_d_min double precision
u_sm_d_max double precision
u_sm_d_pre double precision
low_d_min double precision
low_d_max double precision
low_d_pref double precision
low_d_com integer
width DECIMAL
area DECIMAL
dip_min integer
dip_max integer
dip_pref integer
dip_com integer
dip_dir integer
rake SMALLINT
slip_typ character(30)
slip_r_min numeric
slip_r_max numeric
slip_r_pre numeric
slip_r_com numeric
magnitude smallint
re_int_min integer
re_int_max integer
re_int_pre integer
aseis_slip double precision
last_eq date
data_complet integer
compiler character varying(50)
contrib character varying(50)
created timestamp without time zone