private String createPropertyTable(String sourcefeatureTable, PropertyTable propTable) {
String tableName = propTable.getTable().toLowerCase();
String s = "";
s += "CREATE TABLE " + tableName + " (\n";
s += " feature_id integer NOT NULL REFERENCES " + sourcefeatureTable + ",\n";
s +=
" "
+ propTable.getColumn().toLowerCase()
+ " "
+ propTable.getSqlType()
+ " NOT NULL,\n";
s += " prop_idx smallint NOT NULL\n";
s += ");\n";
return s;
}
private String createMeasurePropertyTable(String sourcefeatureTable, PropertyTable propTable) {
String tableName = propTable.getTable().toLowerCase();
String s = "";
s += "CREATE TABLE " + tableName + " (\n";
s += " feature_id integer NOT NULL REFERENCES " + sourcefeatureTable + ",\n";
s += " measure double precision NOT NULL,\n";
s += " uom text NOT NULL,\n";
s += " prop_idx smallint NOT NULL\n";
s += ");\n";
return s;
}