[Home] [Help] [Dependency Information]
Object Name: | SDO_GEO_ADDR |
---|---|
Object Type: | TYPE |
Owner: | MDSYS |
Subobject Name: | $VSN_1 |
Status: | VALID |
Object Name: | SDO_GEO_ADDR |
---|---|
Object Type: | TYPE |
Owner: | MDSYS |
Subobject Name: | $VSN_2 |
Status: | VALID |
Object Name: | SDO_GEO_ADDR |
---|---|
Object Type: | TYPE |
Owner: | MDSYS |
Subobject Name: | |
Status: | VALID |
Type Code: | OBJECT |
---|---|
Predefined: | NO |
Incomplete: | NO |
Name | Datatype | Length | Prcn |
---|---|---|---|
ID | NUMBER |
|
|
ADDRESSLINES | SDO_KEYWORDARRAY |
|
|
PLACENAME | VARCHAR2 | (200) | |
STREETNAME | VARCHAR2 | (200) | |
INTERSECTSTREET | VARCHAR2 | (200) | |
SECUNIT | VARCHAR2 | (200) | |
SETTLEMENT | VARCHAR2 | (200) | |
MUNICIPALITY | VARCHAR2 | (200) | |
REGION | VARCHAR2 | (200) | |
COUNTRY | VARCHAR2 | (100) | |
POSTALCODE | VARCHAR2 | (20) | |
POSTALADDONCODE | VARCHAR2 | (20) | |
FULLPOSTALCODE | VARCHAR2 | (40) | |
POBOX | VARCHAR2 | (100) | |
HOUSENUMBER | VARCHAR2 | (100) | |
BASENAME | VARCHAR2 | (200) | |
STREETTYPE | VARCHAR2 | (20) | |
STREETTYPEBEFORE | VARCHAR2 | (1) | |
STREETTYPEATTACHED | VARCHAR2 | (1) | |
STREETPREFIX | VARCHAR2 | (20) | |
STREETSUFFIX | VARCHAR2 | (20) | |
SIDE | VARCHAR2 | (1) | |
PERCENT | NUMBER |
|
|
EDGEID | NUMBER |
|
|
ERRORMESSAGE | VARCHAR2 | (20) | |
MATCHCODE | NUMBER |
|
|
MATCHMODE | VARCHAR2 | (30) | |
LONGITUDE | NUMBER |
|
|
LATITUDE | NUMBER |
|
|
MATCHVECTOR | VARCHAR2 | (20) | |
SRID | NUMBER |
|
Name | Parameters | Result |
---|---|---|
SDO_GEO_ADDR |
SELF(SDO_GEO_ADDR) |
SDO_GEO_ADDR |
SDO_GEO_ADDR |
SELF(SDO_GEO_ADDR) COUNTRY(VARCHAR2) LINES(SDO_KEYWORDARRAY) MATCHMODE(VARCHAR2) |
SDO_GEO_ADDR |
SDO_GEO_ADDR |
SELF(SDO_GEO_ADDR) COUNTRY(VARCHAR2) MATCHMODE(VARCHAR2) STREET(VARCHAR2) SETTLEMENT(VARCHAR2) MUNICIPALITY(VARCHAR2) REGION(VARCHAR2) POSTALCODE(VARCHAR2) |
SDO_GEO_ADDR |
SDO_GEO_ADDR |
SELF(SDO_GEO_ADDR) ID(NUMBER) ADDRESSLINES(SDO_KEYWORDARRAY) PLACENAME(VARCHAR2) STREETNAME(VARCHAR2) INTERSECTSTREET(VARCHAR2) SECUNIT(VARCHAR2) SETTLEMENT(VARCHAR2) MUNICIPALITY(VARCHAR2) REGION(VARCHAR2) COUNTRY(VARCHAR2) POSTALCODE(VARCHAR2) POSTALADDONCODE(VARCHAR2) FULLPOSTALCODE(VARCHAR2) POBOX(VARCHAR2) HOUSENUMBER(VARCHAR2) BASENAME(VARCHAR2) STREETTYPE(VARCHAR2) STREETTYPEBEFORE(VARCHAR2) STREETTYPEATTACHED(VARCHAR2) STREETPREFIX(VARCHAR2) STREETSUFFIX(VARCHAR2) SIDE(VARCHAR2) PERCENT(NUMBER) EDGEID(NUMBER) ERRORMESSAGE(VARCHAR2) MATCHCODE(NUMBER) MATCHMODE(VARCHAR2) LONGITUDE(NUMBER) LATITUDE(NUMBER) |
SDO_GEO_ADDR |
SDO_GEO_ADDR |
SELF(SDO_GEO_ADDR) ID(NUMBER) ADDRESSLINES(SDO_KEYWORDARRAY) PLACENAME(VARCHAR2) STREETNAME(VARCHAR2) INTERSECTSTREET(VARCHAR2) SECUNIT(VARCHAR2) SETTLEMENT(VARCHAR2) MUNICIPALITY(VARCHAR2) REGION(VARCHAR2) COUNTRY(VARCHAR2) POSTALCODE(VARCHAR2) POSTALADDONCODE(VARCHAR2) FULLPOSTALCODE(VARCHAR2) POBOX(VARCHAR2) HOUSENUMBER(VARCHAR2) BASENAME(VARCHAR2) STREETTYPE(VARCHAR2) STREETTYPEBEFORE(VARCHAR2) STREETTYPEATTACHED(VARCHAR2) STREETPREFIX(VARCHAR2) STREETSUFFIX(VARCHAR2) SIDE(VARCHAR2) PERCENT(NUMBER) EDGEID(NUMBER) ERRORMESSAGE(VARCHAR2) MATCHCODE(NUMBER) MATCHMODE(VARCHAR2) LONGITUDE(NUMBER) LATITUDE(NUMBER) MATCHVECTOR(VARCHAR2) |
SDO_GEO_ADDR |
|
|
|