Revision 13559
Added by Aaron Marcuse-Kubitza over 10 years ago
| vegbien.my.sql | ||
|---|---|---|
| 1150 | 1150 |
USE default_schema; |
| 1151 | 1151 |
|
| 1152 | 1152 |
-- |
| 1153 |
-- Name: _cm_to_m(double precision); Type: FUNCTION; Schema: public; Owner: -
|
|
| 1153 |
-- Name: _cm_to_m(double); Type: FUNCTION; Schema: public; Owner: - |
|
| 1154 | 1154 |
-- |
| 1155 | 1155 |
|
| 1156 | 1156 |
|
| ... | ... | |
| 1164 | 1164 |
|
| 1165 | 1165 |
|
| 1166 | 1166 |
-- |
| 1167 |
-- Name: _fraction_to_percent(double precision); Type: FUNCTION; Schema: public; Owner: -
|
|
| 1167 |
-- Name: _fraction_to_percent(double); Type: FUNCTION; Schema: public; Owner: - |
|
| 1168 | 1168 |
-- |
| 1169 | 1169 |
|
| 1170 | 1170 |
|
| 1171 | 1171 |
|
| 1172 | 1172 |
|
| 1173 | 1173 |
-- |
| 1174 |
-- Name: _ft_to_m(double precision); Type: FUNCTION; Schema: public; Owner: -
|
|
| 1174 |
-- Name: _ft_to_m(double); Type: FUNCTION; Schema: public; Owner: - |
|
| 1175 | 1175 |
-- |
| 1176 | 1176 |
|
| 1177 | 1177 |
|
| 1178 | 1178 |
|
| 1179 | 1179 |
|
| 1180 | 1180 |
-- |
| 1181 |
-- Name: _ha_to_m2(double precision); Type: FUNCTION; Schema: public; Owner: -
|
|
| 1181 |
-- Name: _ha_to_m2(double); Type: FUNCTION; Schema: public; Owner: - |
|
| 1182 | 1182 |
-- |
| 1183 | 1183 |
|
| 1184 | 1184 |
|
| ... | ... | |
| 1192 | 1192 |
|
| 1193 | 1193 |
|
| 1194 | 1194 |
-- |
| 1195 |
-- Name: _in_to_m(double precision); Type: FUNCTION; Schema: public; Owner: -
|
|
| 1195 |
-- Name: _in_to_m(double); Type: FUNCTION; Schema: public; Owner: - |
|
| 1196 | 1196 |
-- |
| 1197 | 1197 |
|
| 1198 | 1198 |
|
| 1199 | 1199 |
|
| 1200 | 1200 |
|
| 1201 | 1201 |
-- |
| 1202 |
-- Name: _km_to_m(double precision); Type: FUNCTION; Schema: public; Owner: -
|
|
| 1202 |
-- Name: _km_to_m(double); Type: FUNCTION; Schema: public; Owner: - |
|
| 1203 | 1203 |
-- |
| 1204 | 1204 |
|
| 1205 | 1205 |
|
| ... | ... | |
| 1213 | 1213 |
|
| 1214 | 1214 |
|
| 1215 | 1215 |
-- |
| 1216 |
-- Name: _m2_to_ha(double precision); Type: FUNCTION; Schema: public; Owner: -
|
|
| 1216 |
-- Name: _m2_to_ha(double); Type: FUNCTION; Schema: public; Owner: - |
|
| 1217 | 1217 |
-- |
| 1218 | 1218 |
|
| 1219 | 1219 |
|
| 1220 | 1220 |
|
| 1221 | 1221 |
|
| 1222 | 1222 |
-- |
| 1223 |
-- Name: _m_to_cm(double precision); Type: FUNCTION; Schema: public; Owner: -
|
|
| 1223 |
-- Name: _m_to_cm(double); Type: FUNCTION; Schema: public; Owner: - |
|
| 1224 | 1224 |
-- |
| 1225 | 1225 |
|
| 1226 | 1226 |
|
| 1227 | 1227 |
|
| 1228 | 1228 |
|
| 1229 | 1229 |
-- |
| 1230 |
-- Name: _m_to_km(double precision); Type: FUNCTION; Schema: public; Owner: -
|
|
| 1230 |
-- Name: _m_to_km(double); Type: FUNCTION; Schema: public; Owner: - |
|
| 1231 | 1231 |
-- |
| 1232 | 1232 |
|
| 1233 | 1233 |
|
| 1234 | 1234 |
|
| 1235 | 1235 |
|
| 1236 | 1236 |
-- |
| 1237 |
-- Name: _mm_to_m(double precision); Type: FUNCTION; Schema: public; Owner: -
|
|
| 1237 |
-- Name: _mm_to_m(double); Type: FUNCTION; Schema: public; Owner: - |
|
| 1238 | 1238 |
-- |
| 1239 | 1239 |
|
| 1240 | 1240 |
|
| ... | ... | |
| 1255 | 1255 |
|
| 1256 | 1256 |
|
| 1257 | 1257 |
-- |
| 1258 |
-- Name: _percent_to_fraction(double precision); Type: FUNCTION; Schema: public; Owner: -
|
|
| 1258 |
-- Name: _percent_to_fraction(double); Type: FUNCTION; Schema: public; Owner: - |
|
| 1259 | 1259 |
-- |
| 1260 | 1260 |
|
| 1261 | 1261 |
|
| ... | ... | |
| 1485 | 1485 |
county varchar(255), |
| 1486 | 1486 |
description varchar(255), |
| 1487 | 1487 |
geovalid int(1) DEFAULT false NOT NULL, |
| 1488 |
distance_to_country_m double precision,
|
|
| 1489 |
distance_to_state_m double precision,
|
|
| 1490 |
distance_to_county_m double precision
|
|
| 1488 |
distance_to_country_m double, |
|
| 1489 |
distance_to_state_m double, |
|
| 1490 |
distance_to_county_m double |
|
| 1491 | 1491 |
); |
| 1492 | 1492 |
|
| 1493 | 1493 |
|
| ... | ... | |
| 2091 | 2091 |
project_name varchar(255), |
| 2092 | 2092 |
plot_code varchar(255), |
| 2093 | 2093 |
taxon varchar(255), |
| 2094 |
totalpercentcover double precision
|
|
| 2094 |
totalpercentcover double |
|
| 2095 | 2095 |
); |
| 2096 | 2096 |
|
| 2097 | 2097 |
|
| ... | ... | |
| 2110 | 2110 |
project_name varchar(255), |
| 2111 | 2111 |
plot_code varchar(255), |
| 2112 | 2112 |
taxon varchar(255), |
| 2113 |
intercept_cm double precision
|
|
| 2113 |
intercept_cm double |
|
| 2114 | 2114 |
); |
| 2115 | 2115 |
|
| 2116 | 2116 |
|
| ... | ... | |
| 2412 | 2412 |
-- |
| 2413 | 2413 |
|
| 2414 | 2414 |
CREATE TABLE `~type._specimens_13b_list_of_all_decimal_lat_long` ( |
| 2415 |
`decimalLatitude` double precision,
|
|
| 2416 |
`decimalLongitude` double precision
|
|
| 2415 |
`decimalLatitude` double, |
|
| 2416 |
`decimalLongitude` double |
|
| 2417 | 2417 |
); |
| 2418 | 2418 |
|
| 2419 | 2419 |
|
| ... | ... | |
| 3152 | 3152 |
`stateProvince` varchar(255), |
| 3153 | 3153 |
county varchar(255), |
| 3154 | 3154 |
locality varchar(255), |
| 3155 |
`decimalLatitude` double precision,
|
|
| 3156 |
`decimalLongitude` double precision,
|
|
| 3157 |
`coordinateUncertaintyInMeters` double precision,
|
|
| 3155 |
`decimalLatitude` double, |
|
| 3156 |
`decimalLongitude` double, |
|
| 3157 |
`coordinateUncertaintyInMeters` double, |
|
| 3158 | 3158 |
`coordinateSource_bien` varchar(255), |
| 3159 | 3159 |
`georeferenceProtocol_bien` varchar(255), |
| 3160 | 3160 |
geovalid_bien int(11), |
| ... | ... | |
| 3167 | 3167 |
location__cultivated__bien int(1), |
| 3168 | 3168 |
locationevent__pkey int(11), |
| 3169 | 3169 |
`eventDate` date, |
| 3170 |
`elevationInMeters` double precision,
|
|
| 3171 |
`slopeAspect` double precision,
|
|
| 3172 |
`slopeGradient` double precision,
|
|
| 3173 |
`plotArea_ha` double precision,
|
|
| 3170 |
`elevationInMeters` double, |
|
| 3171 |
`slopeAspect` double, |
|
| 3172 |
`slopeGradient` double, |
|
| 3173 |
`plotArea_ha` double, |
|
| 3174 | 3174 |
`samplingProtocol` varchar(255), |
| 3175 |
`temperature_C` double precision,
|
|
| 3176 |
precipitation_m double precision,
|
|
| 3175 |
`temperature_C` double, |
|
| 3176 |
precipitation_m double, |
|
| 3177 | 3177 |
stratum__name varchar(255), |
| 3178 | 3178 |
communities varchar(255), |
| 3179 | 3179 |
plot__collectors varchar(255), |
| ... | ... | |
| 3208 | 3208 |
cultivated_bien int(11), |
| 3209 | 3209 |
`cultivatedBasis_bien` varchar(255), |
| 3210 | 3210 |
`occurrenceRemarks` varchar(255), |
| 3211 |
`coverPercent` double precision,
|
|
| 3212 |
`diameterBreastHeight_cm` double precision,
|
|
| 3213 |
height_m double precision,
|
|
| 3211 |
`coverPercent` double, |
|
| 3212 |
`diameterBreastHeight_cm` double, |
|
| 3213 |
height_m double, |
|
| 3214 | 3214 |
tag varchar(255), |
| 3215 |
`organismX_m` double precision,
|
|
| 3216 |
`organismY_m` double precision,
|
|
| 3215 |
`organismX_m` double, |
|
| 3216 |
`organismY_m` double, |
|
| 3217 | 3217 |
`taxonOccurrenceID` varchar(255), |
| 3218 | 3218 |
`authorTaxonCode` varchar(255), |
| 3219 | 3219 |
`aggregateOrganismObservationID` varchar(255), |
| ... | ... | |
| 3291 | 3291 |
sourceaccessioncode varchar(255), |
| 3292 | 3292 |
taxonoccurrence_id int(11), |
| 3293 | 3293 |
collectiondate date, |
| 3294 |
cover_fraction double precision,
|
|
| 3295 |
linecover_m double precision,
|
|
| 3296 |
basalarea_m2 double precision,
|
|
| 3297 |
biomass_kg_m2 double precision,
|
|
| 3298 |
inferencearea_m2 double precision,
|
|
| 3294 |
cover_fraction double, |
|
| 3295 |
linecover_m double, |
|
| 3296 |
basalarea_m2 double, |
|
| 3297 |
biomass_kg_m2 double, |
|
| 3298 |
inferencearea_m2 double, |
|
| 3299 | 3299 |
count int(11), |
| 3300 | 3300 |
stratum_id int(11), |
| 3301 | 3301 |
coverindex_id int(11), |
| ... | ... | |
| 3375 | 3375 |
CREATE TABLE coordinates ( |
| 3376 | 3376 |
coordinates_id int(11) NOT NULL, |
| 3377 | 3377 |
source_id int(11) NOT NULL, |
| 3378 |
latitude_deg double precision NOT NULL,
|
|
| 3379 |
longitude_deg double precision NOT NULL,
|
|
| 3378 |
latitude_deg double NOT NULL, |
|
| 3379 |
longitude_deg double NOT NULL, |
|
| 3380 | 3380 |
verbatimlatitude varchar(255), |
| 3381 | 3381 |
verbatimlongitude varchar(255), |
| 3382 | 3382 |
verbatimcoordinates varchar(255), |
| 3383 | 3383 |
footprintgeometry_dwc varchar(255), |
| 3384 |
coordsaccuracy_m double precision
|
|
| 3384 |
coordsaccuracy_m double |
|
| 3385 | 3385 |
); |
| 3386 | 3386 |
|
| 3387 | 3387 |
|
| ... | ... | |
| 3440 | 3440 |
place_id int(11), |
| 3441 | 3441 |
accesslevel varchar(255), |
| 3442 | 3442 |
accessconditions varchar(255), |
| 3443 |
sublocationxposition_m double precision,
|
|
| 3444 |
sublocationyposition_m double precision,
|
|
| 3443 |
sublocationxposition_m double, |
|
| 3444 |
sublocationyposition_m double, |
|
| 3445 | 3445 |
iscultivated int(1), |
| 3446 | 3446 |
authorzone varchar(255), |
| 3447 | 3447 |
authordatum varchar(255), |
| 3448 | 3448 |
authorlocation varchar(255), |
| 3449 | 3449 |
locationnarrative varchar(255), |
| 3450 |
azimuth double precision,
|
|
| 3450 |
azimuth double, |
|
| 3451 | 3451 |
shape varchar(255), |
| 3452 |
area_m2 double precision,
|
|
| 3452 |
area_m2 double, |
|
| 3453 | 3453 |
standsize varchar(255), |
| 3454 | 3454 |
placementmethod varchar(255), |
| 3455 | 3455 |
permanence int(1), |
| 3456 | 3456 |
layoutnarrative varchar(255), |
| 3457 |
elevation_m double precision,
|
|
| 3458 |
elevationaccuracy_m double precision,
|
|
| 3459 |
elevationrange_m double precision,
|
|
| 3457 |
elevation_m double, |
|
| 3458 |
elevationaccuracy_m double, |
|
| 3459 |
elevationrange_m double, |
|
| 3460 | 3460 |
verbatimelevation varchar(255), |
| 3461 |
slopeaspect_deg double precision,
|
|
| 3462 |
minslopeaspect_deg double precision,
|
|
| 3463 |
maxslopeaspect_deg double precision,
|
|
| 3464 |
slopegradient_fraction double precision,
|
|
| 3465 |
minslopegradient_fraction double precision,
|
|
| 3466 |
maxslopegradient_fraction double precision,
|
|
| 3461 |
slopeaspect_deg double, |
|
| 3462 |
minslopeaspect_deg double, |
|
| 3463 |
maxslopeaspect_deg double, |
|
| 3464 |
slopegradient_fraction double, |
|
| 3465 |
minslopegradient_fraction double, |
|
| 3466 |
maxslopegradient_fraction double, |
|
| 3467 | 3467 |
topoposition varchar(255), |
| 3468 | 3468 |
landform varchar(255), |
| 3469 | 3469 |
surficialdeposits varchar(255), |
| ... | ... | |
| 3514 | 3514 |
obsenddate date, |
| 3515 | 3515 |
dateaccuracy varchar(255), |
| 3516 | 3516 |
method_id int(11), |
| 3517 |
temperature_c double precision,
|
|
| 3518 |
precipitation_m double precision,
|
|
| 3517 |
temperature_c double, |
|
| 3518 |
precipitation_m double, |
|
| 3519 | 3519 |
autotaxoncover int(1), |
| 3520 | 3520 |
originaldata varchar(255), |
| 3521 | 3521 |
effortlevel varchar(255), |
| ... | ... | |
| 3529 | 3529 |
representativeness varchar(255), |
| 3530 | 3530 |
standmaturity varchar(255), |
| 3531 | 3531 |
successionalstatus varchar(255), |
| 3532 |
basalarea double precision,
|
|
| 3532 |
basalarea double, |
|
| 3533 | 3533 |
hydrologicregime varchar(255), |
| 3534 | 3534 |
soilmoistureregime varchar(255), |
| 3535 | 3535 |
soildrainage varchar(255), |
| 3536 | 3536 |
watersalinity varchar(255), |
| 3537 |
waterdepth_m double precision,
|
|
| 3538 |
shoredistance double precision,
|
|
| 3539 |
soildepth double precision,
|
|
| 3540 |
organicdepth double precision,
|
|
| 3537 |
waterdepth_m double, |
|
| 3538 |
shoredistance double, |
|
| 3539 |
soildepth double, |
|
| 3540 |
organicdepth double, |
|
| 3541 | 3541 |
soiltaxon_id int(11), |
| 3542 | 3542 |
soiltaxonsrc varchar(255), |
| 3543 |
percentbedrock double precision,
|
|
| 3544 |
percentrockgravel double precision,
|
|
| 3545 |
percentwood double precision,
|
|
| 3546 |
percentlitter double precision,
|
|
| 3547 |
percentbaresoil double precision,
|
|
| 3548 |
percentwater double precision,
|
|
| 3549 |
percentother double precision,
|
|
| 3543 |
percentbedrock double, |
|
| 3544 |
percentrockgravel double, |
|
| 3545 |
percentwood double, |
|
| 3546 |
percentlitter double, |
|
| 3547 |
percentbaresoil double, |
|
| 3548 |
percentwater double, |
|
| 3549 |
percentother double, |
|
| 3550 | 3550 |
nameother varchar(255), |
| 3551 |
treeht double precision,
|
|
| 3552 |
shrubht double precision,
|
|
| 3553 |
fieldht double precision,
|
|
| 3554 |
nonvascularht double precision,
|
|
| 3555 |
submergedht double precision,
|
|
| 3556 |
treecover double precision,
|
|
| 3557 |
shrubcover double precision,
|
|
| 3558 |
fieldcover double precision,
|
|
| 3559 |
nonvascularcover double precision,
|
|
| 3560 |
floatingcover double precision,
|
|
| 3561 |
submergedcover double precision,
|
|
| 3551 |
treeht double, |
|
| 3552 |
shrubht double, |
|
| 3553 |
fieldht double, |
|
| 3554 |
nonvascularht double, |
|
| 3555 |
submergedht double, |
|
| 3556 |
treecover double, |
|
| 3557 |
shrubcover double, |
|
| 3558 |
fieldcover double, |
|
| 3559 |
nonvascularcover double, |
|
| 3560 |
floatingcover double, |
|
| 3561 |
submergedcover double, |
|
| 3562 | 3562 |
dominantstratum varchar(255), |
| 3563 | 3563 |
growthform1type varchar(255), |
| 3564 | 3564 |
growthform2type varchar(255), |
| 3565 | 3565 |
growthform3type varchar(255), |
| 3566 |
growthform1cover double precision,
|
|
| 3567 |
growthform2cover double precision,
|
|
| 3568 |
growthform3cover double precision,
|
|
| 3569 |
totalcover double precision,
|
|
| 3566 |
growthform1cover double, |
|
| 3567 |
growthform2cover double, |
|
| 3568 |
growthform3cover double, |
|
| 3569 |
totalcover double, |
|
| 3570 | 3570 |
notespublic int(1), |
| 3571 | 3571 |
notesmgt int(1), |
| 3572 | 3572 |
revisions int(1), |
| ... | ... | |
| 3610 | 3610 |
source_id int(11) NOT NULL, |
| 3611 | 3611 |
name varchar(255), |
| 3612 | 3612 |
description varchar(255), |
| 3613 |
diameterheight_m double precision,
|
|
| 3614 |
mindiameter_m double precision,
|
|
| 3615 |
maxdiameter_m double precision,
|
|
| 3616 |
minheight_m double precision,
|
|
| 3617 |
maxheight_m double precision,
|
|
| 3613 |
diameterheight_m double, |
|
| 3614 |
mindiameter_m double, |
|
| 3615 |
maxdiameter_m double, |
|
| 3616 |
minheight_m double, |
|
| 3617 |
maxheight_m double, |
|
| 3618 | 3618 |
observationtype varchar(255), |
| 3619 | 3619 |
observationmeasure varchar(255), |
| 3620 | 3620 |
covermethod_id int(11), |
| 3621 |
samplingfactor double precision DEFAULT 1 NOT NULL,
|
|
| 3621 |
samplingfactor double DEFAULT 1 NOT NULL, |
|
| 3622 | 3622 |
coverbasis varchar(255), |
| 3623 | 3623 |
stemsamplemethod varchar(255), |
| 3624 | 3624 |
shape varchar(255), |
| 3625 |
length_m double precision,
|
|
| 3626 |
width_m double precision,
|
|
| 3627 |
radius_m double precision,
|
|
| 3628 |
area_m2 double precision,
|
|
| 3629 |
samplearea_m2 double precision,
|
|
| 3630 |
subplotspacing_m double precision,
|
|
| 3625 |
length_m double, |
|
| 3626 |
width_m double, |
|
| 3627 |
radius_m double, |
|
| 3628 |
area_m2 double, |
|
| 3629 |
samplearea_m2 double, |
|
| 3630 |
subplotspacing_m double, |
|
| 3631 | 3631 |
subplotmethod_id int(11), |
| 3632 | 3632 |
pointsperline int(11) |
| 3633 | 3633 |
); |
| ... | ... | |
| 3799 | 3799 |
source_id int(11) NOT NULL, |
| 3800 | 3800 |
sourceaccessioncode varchar(255), |
| 3801 | 3801 |
aggregateoccurrence_id int(11), |
| 3802 |
overallheight_m double precision,
|
|
| 3803 |
overallheightaccuracy_m double precision,
|
|
| 3802 |
overallheight_m double, |
|
| 3803 |
overallheightaccuracy_m double, |
|
| 3804 | 3804 |
authorplantcode varchar(255), |
| 3805 | 3805 |
stemcount int(11), |
| 3806 | 3806 |
reproductivecondition varchar(255), |
| ... | ... | |
| 3888 | 3888 |
stratum_id int(11) NOT NULL, |
| 3889 | 3889 |
source_id int(11) NOT NULL, |
| 3890 | 3890 |
stratumname varchar(255) NOT NULL, |
| 3891 |
stratumheight double precision,
|
|
| 3892 |
stratumbase double precision,
|
|
| 3893 |
stratumcover double precision,
|
|
| 3894 |
area double precision,
|
|
| 3891 |
stratumheight double, |
|
| 3892 |
stratumbase double, |
|
| 3893 |
stratumcover double, |
|
| 3894 |
area double, |
|
| 3895 | 3895 |
method_id int(11) |
| 3896 | 3896 |
); |
| 3897 | 3897 |
|
| ... | ... | |
| 3965 | 3965 |
authorstemcode varchar(255), |
| 3966 | 3966 |
tag varchar(255), |
| 3967 | 3967 |
tags varchar(255), |
| 3968 |
xposition_m double precision,
|
|
| 3969 |
yposition_m double precision,
|
|
| 3970 |
diameterbreastheight_m double precision,
|
|
| 3971 |
basaldiameter_m double precision,
|
|
| 3972 |
diameteraccuracy_m double precision,
|
|
| 3973 |
height_m double precision,
|
|
| 3974 |
heightfirstbranch_m double precision,
|
|
| 3975 |
heightaccuracy_m double precision,
|
|
| 3968 |
xposition_m double, |
|
| 3969 |
yposition_m double, |
|
| 3970 |
diameterbreastheight_m double, |
|
| 3971 |
basaldiameter_m double, |
|
| 3972 |
diameteraccuracy_m double, |
|
| 3973 |
height_m double, |
|
| 3974 |
heightfirstbranch_m double, |
|
| 3975 |
heightaccuracy_m double, |
|
| 3976 | 3976 |
health varchar(255), |
| 3977 |
age double precision
|
|
| 3977 |
age double |
|
| 3978 | 3978 |
); |
| 3979 | 3979 |
|
| 3980 | 3980 |
|
| ... | ... | |
| 4473 | 4473 |
coverindex_id int(11) NOT NULL, |
| 4474 | 4474 |
covermethod_id int(11) NOT NULL, |
| 4475 | 4475 |
covercode varchar(255) NOT NULL, |
| 4476 |
upperlimit double precision,
|
|
| 4477 |
lowerlimit double precision,
|
|
| 4478 |
coverpercent double precision NOT NULL,
|
|
| 4476 |
upperlimit double, |
|
| 4477 |
lowerlimit double, |
|
| 4478 |
coverpercent double NOT NULL, |
|
| 4479 | 4479 |
indexdescription varchar(255) |
| 4480 | 4480 |
); |
| 4481 | 4481 |
|
| ... | ... | |
| 4562 | 4562 |
locationevent_id int(11) NOT NULL, |
| 4563 | 4563 |
disturbancetype varchar(255) NOT NULL, |
| 4564 | 4564 |
disturbanceintensity varchar(255), |
| 4565 |
disturbanceage double precision,
|
|
| 4566 |
disturbanceextent double precision,
|
|
| 4565 |
disturbanceage double, |
|
| 4566 |
disturbanceextent double, |
|
| 4567 | 4567 |
disturbancecomment varchar(255) |
| 4568 | 4568 |
); |
| 4569 | 4569 |
|
| ... | ... | |
| 4590 | 4590 |
country varchar(255), |
| 4591 | 4591 |
`stateProvince` varchar(255), |
| 4592 | 4592 |
county varchar(255), |
| 4593 |
`decimalLatitude` double precision,
|
|
| 4594 |
`decimalLongitude` double precision
|
|
| 4593 |
`decimalLatitude` double, |
|
| 4594 |
`decimalLongitude` double |
|
| 4595 | 4595 |
); |
| 4596 | 4596 |
|
| 4597 | 4597 |
|
| ... | ... | |
| 5199 | 5199 |
locationevent_id int(11) NOT NULL, |
| 5200 | 5200 |
horizon varchar(255) DEFAULT 'unknown' NOT NULL, |
| 5201 | 5201 |
description varchar(255), |
| 5202 |
depthtop_m double precision,
|
|
| 5203 |
depthbottom_m double precision,
|
|
| 5202 |
depthtop_m double, |
|
| 5203 |
depthbottom_m double, |
|
| 5204 | 5204 |
color varchar(255), |
| 5205 | 5205 |
texture varchar(255), |
| 5206 |
organic_fraction double precision,
|
|
| 5207 |
sand_fraction double precision,
|
|
| 5208 |
silt_fraction double precision,
|
|
| 5209 |
clay_fraction double precision,
|
|
| 5210 |
coarse_fraction double precision,
|
|
| 5211 |
ph double precision,
|
|
| 5212 |
acidity_fraction double precision,
|
|
| 5213 |
basesaturation_fraction double precision,
|
|
| 5214 |
cationexchangecapacity_cmol_kg double precision,
|
|
| 5215 |
conductivity double precision,
|
|
| 5216 |
carbon_fraction double precision,
|
|
| 5217 |
phosphorus_fraction double precision,
|
|
| 5218 |
potassium_fraction double precision,
|
|
| 5219 |
magnesium_fraction double precision,
|
|
| 5220 |
nitrogen_fraction double precision,
|
|
| 5221 |
calcium_fraction double precision,
|
|
| 5222 |
sodium_fraction double precision
|
|
| 5206 |
organic_fraction double, |
|
| 5207 |
sand_fraction double, |
|
| 5208 |
silt_fraction double, |
|
| 5209 |
clay_fraction double, |
|
| 5210 |
coarse_fraction double, |
|
| 5211 |
ph double, |
|
| 5212 |
acidity_fraction double, |
|
| 5213 |
basesaturation_fraction double, |
|
| 5214 |
cationexchangecapacity_cmol_kg double, |
|
| 5215 |
conductivity double, |
|
| 5216 |
carbon_fraction double, |
|
| 5217 |
phosphorus_fraction double, |
|
| 5218 |
potassium_fraction double, |
|
| 5219 |
magnesium_fraction double, |
|
| 5220 |
nitrogen_fraction double, |
|
| 5221 |
calcium_fraction double, |
|
| 5222 |
sodium_fraction double |
|
| 5223 | 5223 |
); |
| 5224 | 5224 |
|
| 5225 | 5225 |
|
| ... | ... | |
| 13270 | 13270 |
batch varchar(255) NOT NULL, |
| 13271 | 13271 |
`Name_number` int(11) NOT NULL, |
| 13272 | 13272 |
`Name_submitted` varchar(255) NOT NULL, |
| 13273 |
`Overall_score` double precision,
|
|
| 13273 |
`Overall_score` double, |
|
| 13274 | 13274 |
`Name_matched` varchar(255), |
| 13275 | 13275 |
`Name_matched_rank` varchar(255), |
| 13276 |
`Name_score` double precision,
|
|
| 13276 |
`Name_score` double, |
|
| 13277 | 13277 |
`Name_matched_author` varchar(255), |
| 13278 | 13278 |
`Name_matched_url` varchar(255), |
| 13279 | 13279 |
`Author_matched` varchar(255), |
| 13280 |
`Author_score` double precision,
|
|
| 13280 |
`Author_score` double, |
|
| 13281 | 13281 |
`Family_matched` varchar(255), |
| 13282 |
`Family_score` double precision,
|
|
| 13282 |
`Family_score` double, |
|
| 13283 | 13283 |
`Name_matched_accepted_family` varchar(255), |
| 13284 | 13284 |
`Genus_matched` varchar(255), |
| 13285 |
`Genus_score` double precision,
|
|
| 13285 |
`Genus_score` double, |
|
| 13286 | 13286 |
`Specific_epithet_matched` varchar(255), |
| 13287 |
`Specific_epithet_score` double precision,
|
|
| 13287 |
`Specific_epithet_score` double, |
|
| 13288 | 13288 |
`Infraspecific_rank` varchar(255), |
| 13289 | 13289 |
`Infraspecific_epithet_matched` varchar(255), |
| 13290 |
`Infraspecific_epithet_score` double precision,
|
|
| 13290 |
`Infraspecific_epithet_score` double, |
|
| 13291 | 13291 |
`Infraspecific_rank_2` varchar(255), |
| 13292 | 13292 |
`Infraspecific_epithet_2_matched` varchar(255), |
| 13293 |
`Infraspecific_epithet_2_score` double precision,
|
|
| 13293 |
`Infraspecific_epithet_2_score` double, |
|
| 13294 | 13294 |
`Annotations` varchar(255), |
| 13295 | 13295 |
`Unmatched_terms` varchar(255), |
| 13296 | 13296 |
`Taxonomic_status` varchar(255), |
| ... | ... | |
| 13370 | 13370 |
`Finish time` varchar(255), |
| 13371 | 13371 |
`TNRS version` varchar(255), |
| 13372 | 13372 |
`Sources selected` varchar(255), |
| 13373 |
`Match threshold` double precision,
|
|
| 13373 |
`Match threshold` double, |
|
| 13374 | 13374 |
`Classification` varchar(255), |
| 13375 | 13375 |
`Allow partial matches?` int(1), |
| 13376 | 13376 |
`Sort by source` int(1), |
| ... | ... | |
| 13463 | 13463 |
`*row_num` int(11) NOT NULL, |
| 13464 | 13464 |
`stateProvince` varchar(255), |
| 13465 | 13465 |
county varchar(255), |
| 13466 |
`decimalLatitude` double precision,
|
|
| 13467 |
`decimalLongitude` double precision,
|
|
| 13468 |
`*error_km` double precision
|
|
| 13466 |
`decimalLatitude` double, |
|
| 13467 |
`decimalLongitude` double, |
|
| 13468 |
`*error_km` double |
|
| 13469 | 13469 |
); |
| 13470 | 13470 |
|
| 13471 | 13471 |
|
| ... | ... | |
| 13475 | 13475 |
|
| 13476 | 13476 |
CREATE TABLE geoscrub_output ( |
| 13477 | 13477 |
`*row_num` int(11) NOT NULL, |
| 13478 |
`decimalLatitude` double precision NOT NULL,
|
|
| 13479 |
`decimalLongitude` double precision NOT NULL,
|
|
| 13478 |
`decimalLatitude` double NOT NULL, |
|
| 13479 |
`decimalLongitude` double NOT NULL, |
|
| 13480 | 13480 |
country varchar(255), |
| 13481 | 13481 |
`stateProvince` varchar(255), |
| 13482 | 13482 |
county varchar(255), |
Also available in: Unified diff
fix: lib/PostgreSQL-MySQL.csv: need to replace "double precision" with "double" to work with MySQL Workbench 5.2.47