close
Warning:
Can't synchronize with repository "(default)" ("(default)" is not readable or not a Git repository.). Look in the Trac log for more information.
- Timestamp:
-
Feb 21, 2012, 11:36:19 PM (12 years ago)
- Author:
-
sissiok
- Comment:
-
--
Legend:
- Unmodified
- Added
- Removed
- Modified
-
v6
|
v7
|
|
13 | 13 | 4. compute destination AS (prob: how to match AS to grid in probability matrix)[[BR]] |
14 | 14 | |
| 15 | ---- |
| 16 | table TAXIDATA has all data loaded, table TAXI1 loads only the first data file[[BR]] |
| 17 | |
| 18 | table contents are below[[BR]] |
| 19 | CREATE TABLE TAXIDATA[[BR]] |
| 20 | ([[BR]] |
| 21 | ID NUMBER(10) CONSTRAINT TAXIDATA_ID NOT NULL, [[BR]] |
| 22 | TAXIID NUMBER(7), [[BR]] |
| 23 | LONGITUDE NUMBER(9,6),[[BR]] |
| 24 | LATITUDE NUMBER(8,6), [[BR]] |
| 25 | SPEED NUMBER(3), [[BR]] |
| 26 | ANGLE NUMBER(3), [[BR]] |
| 27 | DATETIME TIMESTAMP(6),[[BR]] |
| 28 | STATUS NUMBER(1), [[BR]] |
| 29 | EXTENDSTATUS NUMBER(1),[[BR]] |
| 30 | REVISED NUMBER(1), [[BR]] |
| 31 | PRIMARY KEY(ID) )[[BR]] |
| 32 | TABLESPACE USERS;[[BR]] |
| 33 | ---- |
| 34 | |
| 35 | |
| 36 | |