{330976CC-133B-4320-81F8-96EBE5D3A065}
20081027
10250800
FALSE
$Revision: 12$
$Date: 7/12/2006 11:42:44 AM$
{B5D3AB87-EED1-11D3-9F76-00C04F8ED1C4}
{43BA3ECC-0120-11d4-AB58-00C04FA379E3}
LocationQueryEngine
True
3
FALSE
Street or Intersection
Zone
<_0>Address
<_0>Addr
<_0>Street
<_1>Zip
<_1>Zipcode
<_1>City
<_1>Zone
Street
Zone
60
20
TRUE
FALSE
us_addr1.mat
us_addr.stn
TRUE
& | @
us_intsc1.mat
us_intsc.stn
{D9052385-AB46-11d2-AADA-00C04FA379E3}
{68F5E953-06FF-11d3-AAFD-00C04FA379E3}
mtchloc
mtchloc
ProgID = esriDataSourcesFile.ShapefileWorkspaceFactory; Path = addressÂ
locator\
True
40
60
SufDir1
SufDir2
PreType1
PreType2
HouseNum
PreDir1
PreDir2
PreDir
PreType
StreetName1
StreetName2
SufDir
StreetName
SufType
SufType1
SufType2
Zone
XX
ZN
{1845B140-FC3B-11d2-AAFA-00C04FA379E3}
mtchloc
SDEX,mtchloc,SX,""
ZNSX,mtchloc,ZoneSX,""
SpellSens,mtchloc,SpellSens,""
IdxTable1,"IndexTable for Primary table"
XID,"Soundex foreign key column",Y,$Table1.ID
Sx,"Soundex code column",Y,@SDEX($Table1.StreetName)
ZoneL,"Left zone column",Y,@ZNSX($Table1.LeftZone)
ZoneR,"Right zone column",Y,@ZNSX($Table1.RightZone)
GC_SZS
ZN, " AND ($IdxTable1.ZoneL = '@ZNSX(%ZN%)' OR $IdxTable1.ZoneR = '@ZNSX(%ZN%)')"
@SpellSens(%S1%, $Table1.StreetName)
AND $Table1.ID = $IdxTable1.XID
Lox1
PreDir1,Table1.PreDir
PreType1,Table1.PreType
StreetName1,Table1.StreetName
Type1,Table1.StreetType
SufDir1,Table1.SufDir
LeftZone1,Table1.LeftZone
RightZone1,Table1.RightZone
Shape,Table1.Shape
ID,Table1.ID
$IdxTable1.Sx = '@SDEX(%S1%)'
ZN, " AND ($IdxTable1.ZoneL = '@ZNSX(%ZN%)' OR $IdxTable1.ZoneR = '@ZNSX(%ZN%)')"
@SpellSens(%S2%, $Table1.StreetName)
AND $Table1.ID = $IdxTable1.XID
Lox1
PreDir2,Table1.PreDir
PreType2,Table1.PreType
StreetName2,Table1.StreetName
Type2,Table1.StreetType
SufDir2,Table1.SufDir
LeftZone2,Table1.LeftZone
RightZone2,Table1.RightZone
Shape,Table1.Shape
ID,Table1.ID
$IdxTable1.Sx = '@SDEX(%S2%)'
ILQuery,"Left Intersection Query"
Lox1
$Table1.StreetName <> 'UNNAMED STREET' AND $Table1.StreetName <> 'UNNAMED' AND $Table1.StreetName IS NOT NULL AND $Table1.StreetName <> ' '
$IdxTable1.ZoneL,$IdxTable1.ZoneR
$Table1.LeftZone,$Table1.RightZone
$IdxTable1.Sx
$Table1.StreetName
$Table1.PreType,$Table1.PreDir,$Table1.SufDir,$Table1.StreetType
1
$Table1.LeftFrom,$Table1.LeftTo,$Table1.RightFrom,$Table1.RightTo,$Table1.ID,$Table1.Shape
Query1,"Main query"
ZN, " AND ($IdxTable1.ZoneL = '@ZNSX(%ZN%)' OR $IdxTable1.ZoneR = '@ZNSX(%ZN%)')"
SN, $IdxTable1.Sx = '@SDEX(%SN%)'
@SpellSens(%SN%, $Table1.StreetName)
AND $Table1.ID = $IdxTable1.XID
Lox1
LeftFrom,Table1.LeftFrom
LeftTo,Table1.LeftTo
RightFrom,Table1.RightFrom
RightTo,Table1.RightTo
PreDir,Table1.PreDir
PreType,Table1.PreType
StreetName,Table1.StreetName
StreetType,Table1.StreetType
SufDir,Table1.SufDir
LeftZone,Table1.LeftZone
RightZone,Table1.RightZone
Shape,Table1.Shape
ID,Table1.ID
$IdxTable1.Sx = '@SDEX(%SN%)'
IRQuery,"Right Intersection Query"
LeftFrom,"House From Left",N,TRUE
LeftTo,"House To Left",N,TRUE
RightFrom,"House From Right",N,TRUE
RightTo,"House To Right",N,TRUE
PreDir,"Prefix Direction",N,FALSE
PreType,"Prefix Type",N,FALSE
StreetName,"Street Name",N,TRUE
StreetType,"Street Type",N,FALSE
SufDir,"Suffix Direction",N,FALSE
LeftZone,"Left Zone",N,TRUE
RightZone,"Right Zone",N,TRUE
ID,"Record ID for the Primary table",N,TRUE
Shape,"Shape column",N,TRUE
esriCatalog.GxFilterFeatureClasses
TRANSPORTATION.GC_SZS1168
SX
XID
LZONE
RZONE
TRANSPORTATION.StreetCenterlines
OBJECTID
LEFT_START_ADDRESS
LEFT_END_ADDRESS
LEFT_ZIP_CODE
PREFIX_DIRECTION
RIGHT_START_ADDRESS
RIGHT_END_ADDRESS
RIGHT_ZIP_CODE
SHAPE
STREET_NAME
STREET_SUFFIX
SUFFIX_DIRECTION
SDE.DEFAULT
ProgID = esriDataSourcesGDB.SdeWorkspaceFactory.1; Conn = (ENCRYPTED_PASSWORD=0002a14bf592731cf9d6c073ffac4ef7a44c00;SERVER=publisher;INSTANCE=5151;USER=transportation;VERSION=SDE.DEFAULT;AUTHENTICATION_MODE=DBMS)
129882949594600000
11:42:39 AM
Street Address with Zone Geocoder
60
Feet
80
True
TRUE
{AE5A3A0E-F756-11D2-9F4F-00C04F8ED1C4}
False
9.2
False
False
False
False
withheld
20110620
10221100
TRUE
{4A54B4D5-9EF6-4B0E-A164-F615448C8A36}
withheld
withheld
Dataset copied.
withheld
20110620
10221100
20120801
11425200
20120801
11425200
ESRI ArcCatalog 9.3.1.3000
en
REQUIRED: A brief narrative summary of the data set.
REQUIRED: A summary of the intentions with which the data set was developed.
REQUIRED: The name of an organization or individual that developed the data set.
REQUIRED: The date when the data set is published or otherwise made available for release.
REQUIRED: The name by which the data set is known.
REQUIRED: The basis on which the time period of content information is determined.
REQUIRED: The year (and optionally month, or month and day) for which the data set corresponds to the ground.
REQUIRED: The frequency with which changes and additions are made to the data set after the initial data set is completed.
REQUIRED: Western-most coordinate of the limit of coverage expressed in longitude.
REQUIRED: Eastern-most coordinate of the limit of coverage expressed in longitude.
REQUIRED: Northern-most coordinate of the limit of coverage expressed in latitude.
REQUIRED: Southern-most coordinate of the limit of coverage expressed in latitude.
REQUIRED: Reference to a formally registered thesaurus or a similar authoritative source of theme keywords.
REQUIRED: Common-use word or phrase used to describe the subject of the data set.
REQUIRED: Restrictions and legal prerequisites for accessing the data set.
REQUIRED: Restrictions and legal prerequisites for using the data set after access is granted.
ESRI ArcCatalog 9.3.1.3000
Street_Address_with_Zone_Geocoder
en
FGDC Content Standards for Digital Geospatial Metadata
FGDC-STD-001-1998
local time
REQUIRED: The person responsible for the metadata information.
REQUIRED: The organization responsible for the metadata information.
REQUIRED: The mailing and/or physical address for the organization or individual.
REQUIRED: The city of the address.
REQUIRED: The state or province of the address.
REQUIRED: The ZIP or other postal code of the address.
REQUIRED: The telephone number by which individuals can speak to the organization or individual.
20120801
http://www.esri.com/metadata/esriprof80.html
ESRI Metadata Profile
ISO 19115 Geographic Information - Metadata
DIS_ESRI1.0
dataset
Street Address with Zone Geocoder
Address Locator
Vector
GCS_North_American_1983
NAD_1983_StatePlane_Michigan_South_FIPS_2113_IntlFeet
coordinate pair
international feet
0.000625
0.000625
Lambert Conformal Conic
42.100000
43.666667
-84.366667
41.500000
13123359.580052
0.000000
North American Datum of 1983
Geodetic Reference System 80
6378137.000000
298.257222
Explicit elevation coordinate included with horizontal coordinates
1.000000
NAD_1983_StatePlane_Michigan_South_FIPS_2113_IntlFeet
20120801