| 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),
|
fix: lib/PostgreSQL-MySQL.csv: need to replace "double precision" with "double" to work with MySQL Workbench 5.2.47