I am trying to create a new vector from a MySQL database table that
has x-y coordinates, using the following command:
GRASS 6.1.cvs (florida):~ > v.in.db driver=mysql database=florida
table=mortality x=longitude y=latitude key=recid output=mortality
However, I get the following error, which is confusing. Why is it
trying to overwrite the table? I thought it just uses the information
in the table to create the layer:
WARNING: The vector 'mortality' already exists and will be overwritten.
5699 points written to vector
DBMI-MySQL driver error:
Cannot create table:
CREATE TABLE mortality ( RECID INT, DATE VARCHAR(6), FILEDBY
VARCHAR(20), FIELDID VARCHAR(10), FMPCASE VARCHAR(5), FMPDIST
VARCHAR(2), SEX VARCHAR(1), LENGTH DOUBLE, LENEST VARCHAR(1), WEIGHT
VARCHAR(20), REPYEAR DOUBLE, REPMONTH DOUBLE, REPDAY DOUBLE, REPBY
VARCHAR(55), RECYEAR DOUBLE, RECMONTH DOUBLE, RECDAY DOUBLE, RECOVBY
VARCHAR(28), NECYEAR DOUBLE, NECMONTH DOUBLE, NECDAY DOUBLE, NECBY
VARCHAR(55), STATE VARCHAR(2), REGION VARCHAR(25), COUNTY VARCHAR(15),
WATERWAY VARCHAR(40), LOCALITY VARCHAR(130), CONDCODE VARCHAR(1),
DTHCODE VARCHAR(1), CAUSE VARCHAR(155), PHDORSAL VARCHAR(1), PHVENTRL
VARCHAR(1), PHLATERL VARCHAR(1), PHSCARS VARCHAR(1), PHFLUKE
VARCHAR(1), PHINTRNL VARCHAR(1), PHSITE VARCHAR(1), PHOTHER
VARCHAR(1), SKULL VARCHAR(1), PARTSKEL VARCHAR(1), COMPSKEL
VARCHAR(1), BLUBBER VARCHAR(1), MUSCLE VARCHAR(1), LIVER VARCHAR(1),
KIDNEY VARCHAR(1), HEART VARCHAR(1), BRAIN VARCHAR(1), EYES
VARCHAR(1), BLOOD VARCHAR(1), URINE VARCHAR(1), ENDOPARA VARCHAR(1),
ECTOPARA VARCHAR(1), REPRO VARCHAR(1), FETUS VARCHAR(1), STOMACH
VARCHAR(1), DUODENUM VARCHAR(1), CAECUM VARCHAR(1), SMINTEST
VARCHAR(1), LGINTEST VARCHAR(1), OTHERMAT VARCHAR(150), DISPOSIT
VARCHAR(69), COMPMEAS VARCHAR(1), SCARMEAS VARCHAR(1), HISTOREP
VARCHAR(1), TOXICREP VARCHAR(1), VETREP VARCHAR(1), HEMREP VARCHAR(1),
ORGANWTS VARCHAR(1), OTHERDAT VARCHAR(90), REMARKS VARCHAR(200),
SNTANUS VARCHAR(20), SNTGENIT VARCHAR(20), SNTUMBIL VARCHAR(20),
PEDGIRTH VARCHAR(20), ANUSGRTH VARCHAR(20), UMBGIRTH VARCHAR(20),
AXILGRTH VARCHAR(20), LATSKIN VARCHAR(20), VENTSKIN VARCHAR(20),
LBLUBOUT VARCHAR(20), VBLUBOUT VARCHAR(20), LBLUBIN VARCHAR(20),
VBLUBIN VARCHAR(20), RTTEAT VARCHAR(20), LTTEAT VARCHAR(20), SNTFLIP
VARCHAR(20), AXILLA VARCHAR(20), FLIPWID VARCHAR(20), FLUKELEN
VARCHAR(20), FLUKEWID VARCHAR(20), TEETHUR VARCHAR(20), TEETHUL
VARCHAR(20), TEETHLR VARCHAR(20), TEETHLL VARCHAR(20), NAILSRT
VARCHAR(20), NAILSLFT VARCHAR(20), ACCID VARCHAR(10), ID VARCHAR(20),
AGE VARCHAR(20), AGE_EST VARCHAR(1), CORRECT VARCHAR(100), CECUM
VARCHAR(1), STRUCTUR VARCHAR(10), LONGITUDE DOUBLE, LATITUDE DOUBLE )
Table 'mortality' already exists
WARNING: Cannot create new table
Bus error
--
Chris Fonnesbeck + Atlanta, GA + http://trichech.us