SUPERSLR - Stanford University's Project on Engineering Responses to Sea Level Rise

You are here: start » tutorials:start » tutorials:sebastian:start » tutorials:sebastian:research_database


|

Meta

Research Database

A public user for accessing the data stored in SUPERSLR's research database is available (SELECT privileges only). SUPERSLR members may access the username and password here

Database Structure

Table: current_features

Fields Data Type Comments
ID mediumint(9) auto_increment, PRIMARY
portID mediumint(9) INDEX
timestamp timestamp CURRENT_TIMESTAMP, INDEX
attribution tinytext FULLTEXT
feature_type mediumtext INDEX(5)
feature_geometry geometry SPATIAL INDEX
feature_details longtext

Table: edit_history

Fields Data Type Comments
ID mediumint(9) auto_increment, PRIMARY
itemID mediumint(9) INDEX
type tinytext INDEX(8)
field tinytext INDEX(5)
attribution tinytext
timestamp timestamp CURRENT_TIMESTAMP, INDEX
oldValue mediumtext
newValue mediumtext

Table: historical_features

Fields Data Type Comments
ID mediumint(9) auto_increment, PRIMARY
portID mediumint(9) INDEX
created timestamp INDEX
updated timestamp CURRENT_TIMESTAMP, INDEX
attribution tinytext FULLTEXT
feature_type mediumtext INDEX(5)
feature_geometry geometry SPATIAL INDEX
feature_details longtext

Table: landcover

Fields Data Type Comments
longitude float INDEX
latitude float INDEX
type smallint(11) INDEX
point geometry SPATIAL INDEX

Table: modelparameters

Fields Data Type Comments
ID smallint(6) auto_increment, PRIMARY
eqn tinytext INDEX(6)
sea_level_rise float
freeboard float
design_wave_height float
storm_surge float
mean_high_high_tide float
mean_low_low_tide float
dike_flat_top float
foundation_height float
toe_height float
outer_toe_slope float
outer_dike_slope float
inner_dike_slope float
max_elevation float
min_elevation float

Table: notes

Fields Data Type Comments
ID bigint(20) auto_increment, PRIMARY
timestamp timestamp CURRENT_TIMESTAMP
attribution tinytext INDEX(10)
details longtext
status tinytext
visible tinyint(1) INDEX
feature_geometry geometry SPATIAL INDEX

Table: portdata

Fields Data Type Comments
ID smallint(6) auto_increment, PRIMARY
name mediumtext INDEX(10)
alt_name mediumtext
longitude float
latitude float
country mediumtext
region tinytext
sub-region tinytext
water_body tinytext
classification tinytext
existing_structure mediumtext
maintained_channel_depth float
maintained_channel_width float
avg_channel_dredging float
infrastructure_area double
basin_area double
measured_avg_defense_elevation float
calculated_avg_defense_elevation float
measured_max_defense_elevation float
calculated_max_defense_elevation float
measured_defense_length float
calculated_defense_length float
population_density mediumint(9)
population bigint(20)
population_data_source tinytext
river_present tinyint(1)
river_names text
reef-protected_area_present tinyint(1)
biologically_significant_environment_present tinyint(1)
subaquatic_geology mediumtext
sediment_load float
watershed_area float
avg_river_discharge float
peak_river_discharge float
mean_low_low_tide float
mean_high_high_tide float
storm_surge float
design_wave_height float
design_wave_period float
sea_storm_return_period mediumint(9)
sea_storm_surge_wave_height float
river_storm_return_period mediumint(9)
river_storm_design_flow float
metric_tonnage mediumint(9)
freight_tonnage mediumint(9)
revenue_tonnage mediumint(9)
TEUs mediumint(9)
shipping_export_value mediumint(9)
shipping_import_value mediumint(9)
shipping_total_value mediumint(9)

Table: portprotector

Fields Data Type Comments
ID mediumint(9) auto_increment, PRIMARY
timestamp timestamp CURRENT_TIMESTAMP
portID mediumint(9) INDEX
attribution tinytext
avg_elev double
path_length double
path_volume double
feature_geometry geometry SPATIAL INDEX
3Dfile mediumtext

Table: portprotector_history

Fields Data Type Comments
ID mediumint(9) auto_increment, PRIMARY
updated timestamp CURRENT_TIMESTAMP
created timestamp
portID mediumint(9) INDEX
attribution tinytext
avg_elev double
path_length double
path_volume double
feature_geometry geometry SPATIAL INDEX
3Dfile mediumtext

Table: topobathy

Fields Data Type Comments
longitude float INDEX
latitude float INDEX
elevation float
point geometry SPATIAL INDEX




Back to Documentation Contents
Back to Sebastian Overview