com.mizar.addressing.navteq
Class NavteqPoiBean

java.lang.Object
  extended by com.mizar.persistence.jpa.beans.GenericBean
      extended by com.mizar.persistence.jpa.beans.GeometryBean
          extended by com.mizar.persistence.jpa.beans.LocationBean
              extended by com.mizar.addressing.navteq.NavteqPoiBean
All Implemented Interfaces:
JPAGeometryInterface, JPAInterface, java.io.Serializable, java.lang.Comparable
Direct Known Subclasses:
NavteqPoiRow

@Entity
public class NavteqPoiBean
extends LocationBean

This is a method to access the POI view, which is a union of various NAVTEQ tables. create view POI as follows:

 SELECT LINK_ID, POI_ID, FACILITY_TYPE, POI_NAME, POINM_LANGCODE, POI_NAMETYPE, POI_ST_NUMBER,
 STREET_NAME, ST_LANGCODE, POI_ST_SIDE, ACCESS_TYPE, PHONE_NUMBER, CHAIN_ID,
 VANITY_CITY, ACTUAL_ADDRESS, PARTITION_ID, GEOMETRY from MAP_PARKING_US
 UNION ALL
 SELECT LINK_ID, POI_ID, FACILITY_TYPE, POI_NAME, POINM_LANGCODE, POI_NAMETYPE, POI_ST_NUMBER,
 STREET_NAME, ST_LANGCODE, POI_ST_SIDE, ACCESS_TYPE, PHONE_NUMBER, CHAIN_ID,
 VANITY_CITY, ACTUAL_ADDRESS, PARTITION_ID, GEOMETRY from MAP_RESTRNTS_US
 UNION ALL
 SELECT LINK_ID, POI_ID, FACILITY_TYPE, POI_NAME, POINM_LANGCODE, POI_NAMETYPE, POI_ST_NUMBER,
 STREET_NAME, ST_LANGCODE, POI_ST_SIDE, ACCESS_TYPE, PHONE_NUMBER, CHAIN_ID,
 VANITY_CITY, ACTUAL_ADDRESS, PARTITION_ID, GEOMETRY from MAP_TRANSHUBS_US
 UNION ALL
 SELECT LINK_ID, POI_ID, FACILITY_TYPE, POI_NAME, POINM_LANGCODE, POI_NAMETYPE, POI_ST_NUMBER,
 STREET_NAME, ST_LANGCODE, POI_ST_SIDE, ACCESS_TYPE, PHONE_NUMBER, CHAIN_ID,
 VANITY_CITY, ACTUAL_ADDRESS, PARTITION_ID, GEOMETRY from MAP_TRAVDEST_US
 UNION ALL
 SELECT LINK_ID, POI_ID, FACILITY_TYPE, POI_NAME, POINM_LANGCODE, POI_NAMETYPE, POI_ST_NUMBER,
 STREET_NAME, ST_LANGCODE, POI_ST_SIDE, ACCESS_TYPE, PHONE_NUMBER, CHAIN_ID,
 VANITY_CITY, ACTUAL_ADDRESS, PARTITION_ID, GEOMETRY from MAP_AUTOSVC_US
 UNION ALL
 SELECT LINK_ID, POI_ID, FACILITY_TYPE, POI_NAME, POINM_LANGCODE, POI_NAMETYPE, POI_ST_NUMBER,
 STREET_NAME, ST_LANGCODE, POI_ST_SIDE, ACCESS_TYPE, PHONE_NUMBER, CHAIN_ID,
 VANITY_CITY, ACTUAL_ADDRESS, PARTITION_ID, GEOMETRY from MAP_BORDCROSS_US
 UNION ALL
 SELECT LINK_ID, POI_ID, FACILITY_TYPE, POI_NAME, POINM_LANGCODE, POI_NAMETYPE, POI_ST_NUMBER,
 STREET_NAME, ST_LANGCODE, POI_ST_SIDE, ACCESS_TYPE, PHONE_NUMBER, CHAIN_ID,
 VANITY_CITY, ACTUAL_ADDRESS, PARTITION_ID, GEOMETRY from MAP_BUSINESS_US
 UNION ALL
 SELECT LINK_ID, POI_ID, FACILITY_TYPE, POI_NAME, POINM_LANGCODE, POI_NAMETYPE, POI_ST_NUMBER,
 STREET_NAME, ST_LANGCODE, POI_ST_SIDE, ACCESS_TYPE, PHONE_NUMBER, CHAIN_ID,
 VANITY_CITY, ACTUAL_ADDRESS, PARTITION_ID, GEOMETRY from MAP_AIRPORTS_PNTS_US
 UNION ALL
 SELECT LINK_ID, POI_ID, FACILITY_TYPE, POI_NAME, POINM_LANGCODE, POI_NAMETYPE, POI_ST_NUMBER,
 STREET_NAME, ST_LANGCODE, POI_ST_SIDE, ACCESS_TYPE, PHONE_NUMBER, CHAIN_ID,
 VANITY_CITY, ACTUAL_ADDRESS, PARTITION_ID, GEOMETRY from MAP_SHOPPING_US
 UNION ALL
 SELECT LINK_ID, POI_ID, FACILITY_TYPE, POI_NAME, POINM_LANGCODE, POI_NAMETYPE, POI_ST_NUMBER,
 STREET_NAME, ST_LANGCODE, POI_ST_SIDE, ACCESS_TYPE, PHONE_NUMBER, CHAIN_ID,
 VANITY_CITY, ACTUAL_ADDRESS, PARTITION_ID, GEOMETRY from MAP_NAMEDPLC_US
 UNION ALL
 SELECT LINK_ID, POI_ID, FACILITY_TYPE, POI_NAME, POINM_LANGCODE, POI_NAMETYPE, POI_ST_NUMBER,
 STREET_NAME, ST_LANGCODE, POI_ST_SIDE, ACCESS_TYPE, PHONE_NUMBER, CHAIN_ID,
 VANITY_CITY, ACTUAL_ADDRESS, PARTITION_ID, GEOMETRY from MAP_PARKFACIL_PNTS_US
 UNION ALL
 SELECT LINK_ID, POI_ID, FACILITY_TYPE, POI_NAME, POINM_LANGCODE, POI_NAMETYPE, POI_ST_NUMBER,
 STREET_NAME, ST_LANGCODE, POI_ST_SIDE, ACCESS_TYPE, PHONE_NUMBER, CHAIN_ID,
 VANITY_CITY, ACTUAL_ADDRESS, PARTITION_ID, GEOMETRY from MAP_FININSTS_US
 UNION ALL
 SELECT LINK_ID, POI_ID, FACILITY_TYPE, POI_NAME, POINM_LANGCODE, POI_NAMETYPE, POI_ST_NUMBER,
 STREET_NAME, ST_LANGCODE, POI_ST_SIDE, ACCESS_TYPE, PHONE_NUMBER, CHAIN_ID,
 VANITY_CITY, ACTUAL_ADDRESS, PARTITION_ID, GEOMETRY from MAP_HAMLET_US
 UNION ALL
 SELECT LINK_ID, POI_ID, FACILITY_TYPE, POI_NAME, POINM_LANGCODE, POI_NAMETYPE, POI_ST_NUMBER,
 STREET_NAME, ST_LANGCODE, POI_ST_SIDE, ACCESS_TYPE, PHONE_NUMBER, CHAIN_ID,
 VANITY_CITY, ACTUAL_ADDRESS, PARTITION_ID, GEOMETRY from MAP_ENTERTN_US;

See Also:
Serialized Form

Field Summary
 
Fields inherited from class com.mizar.persistence.jpa.beans.GeometryBean
searchTolerance, sridPrecision, wktLocation, wktMBR, wktShape
 
Fields inherited from class com.mizar.persistence.jpa.beans.GenericBean
_logger, DELETE, EDIT, NEW, READ, serialVersionUID
 
Constructor Summary
NavteqPoiBean()
           
 
Method Summary
 int compareTo(java.lang.Object otherPoi)
          Untested
 boolean equals(java.lang.Object other)
           
 java.lang.String getAccessType()
           
 java.lang.String getActualAddress()
           
 java.lang.String getAddressNumber()
           
 java.lang.Long getChainId()
           
 java.lang.String getFacilityTypeMC()
           
 oracle.spatial.geometry.JGeometry getGeom()
          Entity classes implementing GeometryBean should have at least one SDO_GEOMETRY column in their associated table.
 java.lang.Long getLinkId()
           
 java.lang.Long getLocationId()
          In the implementing @Entity class this getter must be associated with the @Id annotation representing the primary key.
 java.lang.String getName()
           
 java.lang.String getNameLangCode()
           
 java.lang.String getNameMC()
           
 java.lang.String getNameType()
           
 java.lang.String getPhoneNumber()
           
 java.lang.Long getPrimaryKeyValue()
          NOTE: If an implementing bean expects to be extended by a RowInterface in a often-used Table, you should override this method in order to avoid the overheads associated with the reflective code in JPAUtils.getPrimaryKeyValue(this)
 java.lang.String getStreetLangcode()
           
 java.lang.String getStreetName()
           
 java.lang.String getStreetSide()
           
 java.lang.Long getType()
           
 java.lang.String getVanityCity()
           
 void setAccessType(java.lang.String newaccessType)
           
 void setActualAddress(java.lang.String newactualAddress)
           
 void setAddressNumber(java.lang.String newpoiStNumber)
           
 void setChainId(java.lang.Long newchainId)
           
 void setGeom(oracle.spatial.geometry.JGeometry geom)
           
 void setLocationId(java.lang.Long newpoiId)
           
 void setName(java.lang.String newpoiName)
           
 void setNameLangCode(java.lang.String newpoinmLangcode)
           
 void setNameType(java.lang.String newpoiNametype)
           
 void setPhoneNumber(java.lang.String newphoneNumber)
           
 void setStreetLangcode(java.lang.String newstLangcode)
           
 void setStreetName(java.lang.String newstreetName)
           
 void setStreetSide(java.lang.String newpoiStSide)
           
 void setType(java.lang.Long newfacilityType)
           
 void setVanityCity(java.lang.String newvanicyCity)
           
 
Methods inherited from class com.mizar.persistence.jpa.beans.GeometryBean
getArea, getBasicGeometryType, getGeomDimensions, getGeomNumPoints, getGeomType, getGType, getHeight, getLength, getRange, getSearchTolerance, getSrid, getSridPrecision, getWidth, getWktLocation, getWktMBR, getWktShape, isGeometryExtant, setArea, setSearchTolerance, setSridPrecision, setWktLocation, setWktShape
 
Methods inherited from class com.mizar.persistence.jpa.beans.GenericBean
getDELETE, getEDIT, getEntityState, getEntityStateLabel, getLogger, getNEW, getREAD, hashCode, isEditable, isNew, setEditable, setEntityState, toString
 
Methods inherited from class java.lang.Object
clone, finalize, getClass, notify, notifyAll, wait, wait, wait
 

Constructor Detail

NavteqPoiBean

public NavteqPoiBean()
Method Detail

setLocationId

public void setLocationId(java.lang.Long newpoiId)
Specified by:
setLocationId in class LocationBean

getLocationId

public java.lang.Long getLocationId()
Description copied from class: LocationBean
In the implementing @Entity class this getter must be associated with the @Id annotation representing the primary key. In other words, any JPA implementing class must use the property Long locationId; as the primary key property. This protocol enables the generic query capability based on primary key, name, and name.

Specified by:
getLocationId in class LocationBean
Returns:
the primary key of the implementing bean

getPrimaryKeyValue

public java.lang.Long getPrimaryKeyValue()
Description copied from class: GenericBean

NOTE: If an implementing bean expects to be extended by a RowInterface in a often-used Table, you should override this method in order to avoid the overheads associated with the reflective code in JPAUtils.getPrimaryKeyValue(this)

 public Object getPrimaryKeyValue(){
   return getProperty();
 }
 

In the absence of an overriding method, this method provides a generic method to get the value of the primary key. This is especially useful for calls to em.find(object) from within abstract classes

Overrides:
getPrimaryKeyValue in class GenericBean
Returns:
JPAUtils#getPrimaryKeyValue(this)
See Also:
RowInterface.getPrimaryKeyValue()

getLinkId

public java.lang.Long getLinkId()

setChainId

public void setChainId(java.lang.Long newchainId)

getChainId

public java.lang.Long getChainId()

setType

public void setType(java.lang.Long newfacilityType)
Specified by:
setType in class LocationBean

getType

public java.lang.Long getType()
Specified by:
getType in class LocationBean

getFacilityTypeMC

public java.lang.String getFacilityTypeMC()

setName

public void setName(java.lang.String newpoiName)
Specified by:
setName in class LocationBean

getName

public java.lang.String getName()
Specified by:
getName in class LocationBean

getNameMC

public java.lang.String getNameMC()

setNameLangCode

public void setNameLangCode(java.lang.String newpoinmLangcode)

getNameLangCode

public java.lang.String getNameLangCode()

setNameType

public void setNameType(java.lang.String newpoiNametype)

getNameType

public java.lang.String getNameType()

setAddressNumber

public void setAddressNumber(java.lang.String newpoiStNumber)

getAddressNumber

public java.lang.String getAddressNumber()

setStreetName

public void setStreetName(java.lang.String newstreetName)

getStreetName

public java.lang.String getStreetName()

setStreetLangcode

public void setStreetLangcode(java.lang.String newstLangcode)

getStreetLangcode

public java.lang.String getStreetLangcode()

setStreetSide

public void setStreetSide(java.lang.String newpoiStSide)

getStreetSide

public java.lang.String getStreetSide()

setAccessType

public void setAccessType(java.lang.String newaccessType)

getAccessType

public java.lang.String getAccessType()

setPhoneNumber

public void setPhoneNumber(java.lang.String newphoneNumber)

getPhoneNumber

public java.lang.String getPhoneNumber()

setVanityCity

public void setVanityCity(java.lang.String newvanicyCity)

getVanityCity

public java.lang.String getVanityCity()

setActualAddress

public void setActualAddress(java.lang.String newactualAddress)

getActualAddress

public java.lang.String getActualAddress()

getGeom

public oracle.spatial.geometry.JGeometry getGeom()
Description copied from class: GeometryBean
Entity classes implementing GeometryBean should have at least one SDO_GEOMETRY column in their associated table. It is entirely possible for an Entity to support more than one SDO_GEOMETRY column but one must be designated and the default or nominal object and a getter method called getGeom() must be mapped to it.

Specified by:
getGeom in class GeometryBean
Returns:
the principal SDO_GEOMETRY column

setGeom

public void setGeom(oracle.spatial.geometry.JGeometry geom)
Specified by:
setGeom in class GeometryBean

compareTo

public int compareTo(java.lang.Object otherPoi)
              throws java.lang.ClassCastException
Untested

Specified by:
compareTo in interface java.lang.Comparable
Overrides:
compareTo in class GenericBean
Parameters:
otherPoi -
Returns:
a negative integer, zero, or a positive integer as this object is less than, equal to, or greater than the specified object.
Throws:
java.lang.ClassCastException

equals

public boolean equals(java.lang.Object other)
Overrides:
equals in class GenericBean
Parameters:
other -
Returns:
true or false if reference values are all equal
See Also:
#compareTo()