Owner Table Name Attributes Web-Service Number of Tuples Comments
spatial video FILENAME NOT NULL VARCHAR2(100)
CAMERA_ID NUMBER(38)
CAMERA_DESC VARCHAR2(50)
VIDEO_TYPE VARCHAR2(10)
LOCATION_DESC VARCHAR2(100)
FPS NOT NULL NUMBER(38)
FRAME_HEIGHT NUMBER(38)
FRAME_WIDTH NUMBER(38)
START_TIME NOT NULL TIMESTAMP(6)
END_TIME NOT NULL TIMESTAMP(6)
DURATION NOT NULL FLOAT(126)
SERVER_NAME NOT NULL VARCHAR2(40)
SERVER_IP NOT NULL VARCHAR2(40)
SERVER_DESC VARCHAR2(50)
LOCATION SPATIAL.SDO_GEOMETRY
RIGHT_PROJECTION SPATIAL.SDO_GEOMETRY
LEFT_PROJECTION SPATIAL.SDO_GEOMETRY		 getVideoServlet 24  
spatial usc_models_xy ID NUMBER
MIN_X NUMBER
MAX_X NUMBER
MIN_Y NUMBER
MAX_Y NUMBER
COMP_HGT NUMBER
ROOF_HGT NUMBER
VRML_URL CHAR

getVRML

getXML

 247 USC 3D models
navtech streets LINK_ID NUMBER
ST_NAME VARCHAR2(80)
ST_LANGCD VARCHAR2(3)
NUM_STNMES NUMBER
ST_NM_PREF VARCHAR2(2)
ST_TYP_BEF VARCHAR2(30)
ST_NM_BASE VARCHAR2(35)
ST_NM_SUFF VARCHAR2(2)
ST_TYP_AFT VARCHAR2(30)
ST_TYP_ATT VARCHAR2(1)
ADDR_TYPE VARCHAR2(1)
L_REFADDR VARCHAR2(10)
L_NREFADDR VARCHAR2(10)
L_ADDRSCH VARCHAR2(1)
L_ADDRFORM VARCHAR2(1)
R_REFADDR VARCHAR2(10)
R_NREFADDR VARCHAR2(10)
R_ADDRSCH VARCHAR2(1)
R_ADDRFORM VARCHAR2(1)
REF_IN_ID NUMBER
NREF_IN_ID NUMBER
N_SHAPEPNT NUMBER
FUNC_CLASS VARCHAR2(1)
SPEED_CAT VARCHAR2(1)
LANE_CAT VARCHAR2(1)
DIVIDER VARCHAR2(1)
DIR_TRAVEL VARCHAR2(1)
L_AREA_ID NUMBER
R_AREA_ID NUMBER
L_POSTCODE VARCHAR2(11)
R_POSTCODE VARCHAR2(11)
L_NUMZONES NUMBER
R_NUMZONES NUMBER
NUM_AD_RNG NUMBER
AR_AUTO VARCHAR2(1)
AR_BUS VARCHAR2(1)
AR_TAXIS VARCHAR2(1)
AR_CARPOOL VARCHAR2(1)
AR_PEDEST VARCHAR2(1)
AR_TRUCKS VARCHAR2(1)

AR_TRAFF VARCHAR2(1)
AR_DELIV VARCHAR2(1)
AR_EMERVEH VARCHAR2(1)
PAVED VARCHAR2(1)
PRIVATE VARCHAR2(1)
FRONTAGE VARCHAR2(1)
BRIDGE VARCHAR2(1)
TUNNEL VARCHAR2(1)
RAMP VARCHAR2(1)
TOLLWAY VARCHAR2(1)
POIACCESS VARCHAR2(1)
CONTRACC VARCHAR2(1)
ROUNDABOUT VARCHAR2(1)
INTERINTER VARCHAR2(1)
UNDEFTRAFF VARCHAR2(1)
FERRY_TYPE VARCHAR2(1)
MULTIDIGIT VARCHAR2(1)
MAXATTR VARCHAR2(1)
SPECTRFIG VARCHAR2(1)
INDESCRIB VARCHAR2(1)
MANOEUVRE VARCHAR2(1)
DIVIDERLEG VARCHAR2(1)
INPROCDATA VARCHAR2(1)
FULL_GEOM VARCHAR2(1)
URBAN VARCHAR2(1)
ROUTE_TYPE VARCHAR2(1)
DIRONSIGN VARCHAR2(1)
EXPLICATBL VARCHAR2(1)
NAMEONRDSN VARCHAR2(1)
POSTALNAME VARCHAR2(1)
STALENAME VARCHAR2(1)
VANITYNAME VARCHAR2(1)
JUNCTIONNM VARCHAR2(1)
EXITNAME VARCHAR2(1)
GEOM MDSYS.SDO_GEOMETRY
DCA VARCHAR2(10)

vectorGeneratorServlet

 

 

generateResultServlet

 24,565,749 Navteq dataset
navtech streets_aggr1 ST_NAME VARCHAR2(80)
LINK_ID NUMBER
FUNC_CLASS VARCHAR2(1)
GEOM MDSYS.SDO_GEOMETRY		 generateResultServlet 156,539

aggregated materialized view. navteq dataset

Area:(-120.23931,32.927289,-114.945266,37.473046)

 
navtech streets_agg1_area ST_NAME VARCHAR2(80)
LINK_ID NUMBER
FUNC_CLASS VARCHAR2(1)
AREA_ID NUMBER
GEOM MDSYS.SDO_GEOMETRY		 generateResultServlet 58523

aggregated materialized view. navteq dataset

Area: (-118.23931,33.927289,-116.945266,35.473046)
spatial roads_cal_u2 ID NUMBER
LENGTH NUMBER
SRS VARCHAR2(20)
SEGMENTTYP VARCHAR2(50)
WIDTH NUMBER
BIDIRECTIO VARCHAR2(10)
SOURCE VARCHAR2(20)
PROCESSING VARCHAR2(100)
ACCURACY VARCHAR2(20)
PREDIRECTI VARCHAR2(10)
NAME VARCHAR2(100)
TYPE VARCHAR2(50)
POSTDIRECT VARCHAR2(10)
LEFTFROMAD VARCHAR2(20)
LEFTTOADDR VARCHAR2(20)
 RIGHTFROMA VARCHAR2(20)
RIGHTTOADD VARCHAR2(20)
ZIPLEFT VARCHAR2(20)
ZIPRIGHT VARCHAR2(20)
BLOCKLEFT VARCHAR2(20)
BLOCKRIGHT VARCHAR2(20)
TRACTLEFT VARCHAR2(20)
TRACTRIGHT VARCHAR2(20)
GEOM MDSYS.SDO_GEOMETRY
COUNTY_ID NUMBER(38)
COUNTY_NAME VARCHAR2(60)		   607641

Tiger Dataset (unified).

Area: southern California

spatial roads_cal_u2_aggr ID NUMBER
PREDIRECTI VARCHAR2(10)
NAME VARCHAR2(100)
TYPE VARCHAR2(50)
COUNTY_NAME VARCHAR2(60)
SEGMENTTYP VARCHAR2(50)
BIDIRECTIO VARCHAR2(10)
LENGTH NUMBER
WIDTH NUMBER

 ACCURACY NUMBER
ZIPLEFT NUMBER
ZIPRIGHT NUMBER
LEFTFROMADD NUMBER
LEFTTOADD NUMBER
RIGHTFROMADDR NUMBER
RIGHTTOADDR NUMBER
GEOM MDSYS.SDO_GEOMETRY		   98429

aggregated materialized view

Tiger Dataset (unified).

Area: southern California

navtech namedplc LINK_ID NUMBER
POI_ID NUMBER
FAC_TYPE NUMBER
POI_NAME VARCHAR2(35)
POI_LANGCD VARCHAR2(3)
POI_NMTYPE VARCHAR2(1)
POI_ST_NUM VARCHAR2(10)
ST_NAME VARCHAR2(80)
ST_LANGCD VARCHAR2(3)
POI_ST_SD VARCHAR2(1)
 ACC_TYPE VARCHAR2(1)
PH_NUMBER VARCHAR2(15)
CHAIN_ID NUMBER
POPULATION NUMBER
CAPITAL VARCHAR2(1)
VAN_CITY VARCHAR2(35)
ACT_ADDR VARCHAR2(110)
GEOM MDSYS.SDO_GEOMETRY
DCA VARCHAR2(10)

nplGeneratorServlet

 

POIGeneratorServlet

91653 Navteq dataset
navtech hospital LINK_ID NUMBER
POI_ID NUMBER
FAC_TYPE NUMBER
POI_NAME VARCHAR2(35)
POI_LANGCD VARCHAR2(3)
POI_NMTYPE VARCHAR2(1)
POI_ST_NUM VARCHAR2(10)
ST_NAME VARCHAR2(80)
ST_LANGCD VARCHAR2(3)
 POI_ST_SD VARCHAR2(1)
ACC_TYPE VARCHAR2(1)
PH_NUMBER VARCHAR2(15)
CHAIN_ID NUMBER
VAN_CITY VARCHAR2(35)
ACT_ADDR VARCHAR2(110)
GEOM MDSYS.SDO_GEOMETRY
DCA VARCHAR2(10)

hosGeneratorServlet

 

POIGeneratorServlet

2581 Navteq dataset
navtech parkrec LINK_ID NUMBER
POI_ID NUMBER
FAC_TYPE NUMBER
POI_NAME VARCHAR2(35)
POI_LANGCD VARCHAR2(3)
POI_NMTYPE VARCHAR2(1)
POI_ST_NUM VARCHAR2(10)
ST_NAME VARCHAR2(80)
ST_LANGCD VARCHAR2(3)
 POI_ST_SD VARCHAR2(1)
ACC_TYPE VARCHAR2(1)
PH_NUMBER VARCHAR2(15)
CHAIN_ID NUMBER
VAN_CITY VARCHAR2(35)
ACT_ADDR VARCHAR2(110)
GEOM MDSYS.SDO_GEOMETRY
DCA VARCHAR2(10)

prkGeneratorServlet

 

POIGeneratorServlet

49176 Navteq dataset
navtech transhubs LINK_ID NUMBER
POI_ID NUMBER
FAC_TYPE NUMBER
POI_NAME VARCHAR2(35)
POI_LANGCD VARCHAR2(3)
POI_NMTYPE VARCHAR2(1)
POI_ST_NUM VARCHAR2(10)
ST_NAME VARCHAR2(80)
 ST_LANGCD VARCHAR2(3)
POI_ST_SD VARCHAR2(1)
ACC_TYPE VARCHAR2(1)
PH_NUMBER VARCHAR2(15)
CHAIN_ID NUMBER
VAN_CITY VARCHAR2(35)
ACT_ADDR VARCHAR2(110)
GEOM MDSYS.SDO_GEOMETRY
DCA VARCHAR2(10)

trnGeneratorServlet

 

POIGeneratorServlet

4552 Navteq dataset
navtech travdest LINK_ID NUMBER
POI_ID NUMBER
FAC_TYPE NUMBER
POI_NAME VARCHAR2(35)
POI_LANGCD VARCHAR2(3)
POI_NMTYPE VARCHAR2(1)
POI_ST_NUM VARCHAR2(10)
ST_NAME VARCHAR2(80)
ST_LANGCD VARCHAR2(3)
 POI_ST_SD VARCHAR2(1)
ACC_TYPE VARCHAR2(1)
PH_NUMBER VARCHAR2(15)
CHAIN_ID NUMBER
VAN_CITY VARCHAR2(35)
ACT_ADDR VARCHAR2(110)
GEOM MDSYS.SDO_GEOMETRY
DCA VARCHAR2(10)

trvGeneratorServlet

POIGeneratorServlet

88697 Navteq dataset
navtech shopping LINK_ID NUMBER
POI_ID NUMBER
FAC_TYPE NUMBER
POI_NAME VARCHAR2(35)
POI_LANGCD VARCHAR2(3)
POI_NMTYPE VARCHAR2(1)
POI_ST_NUM VARCHAR2(10)
ST_NAME VARCHAR2(80)
 ST_LANGCD VARCHAR2(3)
POI_ST_SD VARCHAR2(1)
ACC_TYPE VARCHAR2(1)
PH_NUMBER VARCHAR2(15)
CHAIN_ID NUMBER
VAN_CITY VARCHAR2(35)
ACT_ADDR VARCHAR2(110)
GEOM MDSYS.SDO_GEOMETRY
DCA VARCHAR2(10)

shpGeneratorServlet

POIGeneratorServlet

15524 Navteq dataset
navtech restrnts LINK_ID NUMBER
POI_ID NUMBER
FAC_TYPE NUMBER
POI_NAME VARCHAR2(35)
POI_LANGCD VARCHAR2(3)
POI_NMTYPE VARCHAR2(1)
POI_ST_NUM VARCHAR2(10)
ST_NAME VARCHAR2(80)
ST_LANGCD VARCHAR2(3)
 POI_ST_SD VARCHAR2(1)
ACC_TYPE VARCHAR2(1)
PH_NUMBER VARCHAR2(15)
CHAIN_ID NUMBER
FOOD_TYPE VARCHAR2(35)
VAN_CITY VARCHAR2(35)
ACT_ADDR VARCHAR2(110)
GEOM MDSYS.SDO_GEOMETRY
DCA VARCHAR2(10)

resGeneratorServlet

POIGeneratorServlet

450,562 Navteq dataset
navtech entertn LINK_ID NUMBER
POI_ID NUMBER
FAC_TYPE NUMBER
POI_NAME VARCHAR2(35)
POI_LANGCD VARCHAR2(3)
POI_NMTYPE VARCHAR2(1)
POI_ST_NUM VARCHAR2(10)
ST_NAME VARCHAR2(80)
ST_LANGCD VARCHAR2(3)
 POI_ST_SD VARCHAR2(1)
ACC_TYPE VARCHAR2(1)
PH_NUMBER VARCHAR2(15)
CHAIN_ID NUMBER
VAN_CITY VARCHAR2(35)
ACT_ADDR VARCHAR2(110)
GEOM MDSYS.SDO_GEOMETRY
DCA VARCHAR2(10)

entGeneratorServlet

POIGeneratorServlet

2180 Navteq dataset
navtech autosvc LINK_ID NUMBER
POI_ID NUMBER
FAC_TYPE NUMBER
POI_NAME VARCHAR2(35)
POI_LANGCD VARCHAR2(3)
POI_NMTYPE VARCHAR2(1)
POI_ST_NUM VARCHAR2(10)
ST_NAME VARCHAR2(80)
 ST_LANGCD VARCHAR2(3)
POI_ST_SD VARCHAR2(1)
ACC_TYPE VARCHAR2(1)
PH_NUMBER VARCHAR2(15)
CHAIN_ID NUMBER
VAN_CITY VARCHAR2(35)
ACT_ADDR VARCHAR2(110)
GEOM MDSYS.SDO_GEOMETRY
DCA VARCHAR2(10)

autGeneratorServlet

POIGeneratorServlet

260,497 Navteq dataset
navtech fininsts LINK_ID NUMBER
POI_ID NUMBER
FAC_TYPE NUMBER
POI_NAME VARCHAR2(35)
POI_LANGCD VARCHAR2(3)
POI_NMTYPE VARCHAR2(1)
POI_ST_NUM VARCHAR2(10)
ST_NAME VARCHAR2(80)
ST_LANGCD VARCHAR2(3)
 POI_ST_SD VARCHAR2(1)
ACC_TYPE VARCHAR2(1)
PH_NUMBER VARCHAR2(15)
CHAIN_ID NUMBER
VAN_CITY VARCHAR2(35)
ACT_ADDR VARCHAR2(110)
GEOM MDSYS.SDO_GEOMETRY
DCA VARCHAR2(10)

finGeneratorServlet

POIGeneratorServlet

183,159 Navteq dataset
navtech business LINK_ID NUMBER
POI_ID NUMBER
FAC_TYPE NUMBER
POI_NAME VARCHAR2(35)
POI_LANGCD VARCHAR2(3)
POI_NMTYPE VARCHAR2(1)
POI_ST_NUM VARCHAR2(10)
ST_NAME VARCHAR2(80)
 ST_LANGCD VARCHAR2(3)
POI_ST_SD VARCHAR2(1)
ACC_TYPE VARCHAR2(1)
PH_NUMBER VARCHAR2(15)
CHAIN_ID NUMBER
VAN_CITY VARCHAR2(35)
ACT_ADDR VARCHAR2(110)
GEOM MDSYS.SDO_GEOMETRY
DCA VARCHAR2(10)

busGeneratorServlet

POIGeneratorServlet

6890 Navteq dataset
navtech commsvc LINK_ID NUMBER
POI_ID NUMBER
FAC_TYPE NUMBER
POI_NAME VARCHAR2(35)
POI_LANGCD VARCHAR2(3)
POI_NMTYPE VARCHAR2(1)
POI_ST_NUM VARCHAR2(10)
ST_NAME VARCHAR2(80)
 ST_LANGCD VARCHAR2(3)
POI_ST_SD VARCHAR2(1)
ACC_TYPE VARCHAR2(1)
PH_NUMBER VARCHAR2(15)
CHAIN_ID NUMBER
VAN_CITY VARCHAR2(35)
ACT_ADDR VARCHAR2(110)
GEOM MDSYS.SDO_GEOMETRY
DCA VARCHAR2(10)

comGeneratorServlet

POIGeneratorServlet

15831 Navteq dataset
navtech eduinsts LINK_ID NUMBER
POI_ID NUMBER
FAC_TYPE NUMBER
POI_NAME VARCHAR2(35)
POI_LANGCD VARCHAR2(3)
POI_NMTYPE VARCHAR2(1)
POI_ST_NUM VARCHAR2(10)
ST_NAME VARCHAR2(80)
 ST_LANGCD VARCHAR2(3)
POI_ST_SD VARCHAR2(1)
ACC_TYPE VARCHAR2(1)
PH_NUMBER VARCHAR2(15)
CHAIN_ID NUMBER
VAN_CITY VARCHAR2(35)
ACT_ADDR VARCHAR2(110)
GEOM MDSYS.SDO_GEOMETRY
DCA VARCHAR2(10)

eduGeneratorServlet

POIGeneratorServlet

63225 Navteq dataset
navtech parking LINK_ID NUMBER
POI_ID NUMBER
FAC_TYPE NUMBER
POI_NAME VARCHAR2(35)
POI_LANGCD VARCHAR2(3)
POI_NMTYPE VARCHAR2(1)
POI_ST_NUM VARCHAR2(10)
ST_NAME VARCHAR2(80)
 ST_LANGCD VARCHAR2(3)
POI_ST_SD VARCHAR2(1)
ACC_TYPE VARCHAR2(1)
PH_NUMBER VARCHAR2(15)
CHAIN_ID NUMBER
VAN_CITY VARCHAR2(35)
ACT_ADDR VARCHAR2(110)
GEOM MDSYS.SDO_GEOMETRY
DCA VARCHAR2(10)

parGeneratorServlet

POIGeneratorServlet

5337 Navteq dataset

*Information you need to connect to the database:

User Name = infolab / Password = infolab_stdbm (you can only read the data, if you need more privilegs contact me)

(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = infolab-db.usc.edu)(PORT = 1521))
)
(CONNECT_DATA =
(SID = starterD)
(SERVER = DEDICATED)
)
)

**For a complete listing and description of every layer in Navtech data, check Navtech user guide.