Database Schema of IOT GIS Data

For the iTaxi project, we need the points of landmarks, the polylines of roads, and the polygons of geopolitical areas.

Landmark:

landmark {
landmarkid: (13-digit code) AAAAABBBBBBBB (A - county code, B - serial number),
landmarkcode: (3-digit code) (classification code),
landmarkname: String,
landmarkaddr: String,
landmarkgeom: (geom)
}

Road:

road {
roadid: (13-digit code) AAAAABBBBBBBB (A - county code, B - serial number),
roadcode: (4-digit code),
roadaddr: String,
roadgeom: (geom)
}

Administrative Division:

admdiv {
admdivid: (9-digit code) AAAAABBBB (A - county code, B - serial number),
admdivcode: (10-digit code) AAAAABBCCC (A - county code, B - town code, C - village code),
admdivname: String,
admdivgeom: (geom)
}

Advertisement

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.