TexasHeightModernizationProgramDatabaseProject
21 Nov 2009 12:35 UTC 2009325+1235 UTC

Texas Spatial Reference Center Database (TSRCDB)

8/25/09

Purpose: Database containing ALL the points of Texas. Non-housed points will be represented in a link towards different agencies containing the points. Output of one-page printable sheet of Benchmark's information.

Primary Users: Public use, Texas Surveyors, Field Crew Chiefs

Contents of Database:
GPS Data
Benchmark descriptions (Geographic Latitudes and longitudes)
Benchmark Photos (North, South, West, and East views along with Benchmark Close-Up)

Tasks for now:
Create Database Structure

Back end solutions (MySQL? , SQLite?, etc...)
For internal points - Normalize database entities, fields, records

Internal Database (Rough Draft)

For external points - Solution to query other agencies databases
Raw GPS data entry (data size usually around 300-400 k)

Reading and Storing electronic generated OPUS-Solutions

Note: Electronic Generated OPUS-Solutions can be generated either in XML or txt formats.
Note: More than one OPUS-Solution can be produced
Note: 3 types of reports (Rapid, UltraRapid?, Precise)

Future Tasks:
Meet TNRIS contractual obligations

Access controls

10/2/09

Updated Project Name: Texas Spatial Reference Center Database (TSRCDB)

Notes:
Contributer is a person who uploads an observation to the database

One mark will have multiple grid systems but one of each (Universal Transverse Mercator (UTM), State Plane Coordinate System (SPS or SPCS), and Grid System)

Convergence is the angle between true north while using UTM and SPC
Nothing, Easting numbers will not be longer then 10 million

Reference Frame ITRF in xml will be ignored. (Only NAD_83 Reference Frame data will be used with database)

Database will hold a primary observation for each mark, a mark can then have multiple observations

The primary observation will have an appending description that is updated without adding an observation
The primary observation will be the observation with the most accuracy of location
The primary observation will display a list of other observations pertaining to the mark being viewed

A table will be needed for users/contributers information
A table will be needed for description of a mark for appending without adding an observation

An observation can be uploaded without a pid, therefor coordinate checking will be needed to find marks within a range of observation coordinates to determine if a possible observation for that mark is already present.

Revised Internal Database (Rough Draft)

TSRCDBScript

Page last modified on October 08, 2009, at 02:16 PM