20201118
16422200
1.0
FALSE
LoganCenter08132014
Address
US Streets with Alternate Names (GDB)
$Revision: 16$
$Date: 12/14/2007 5:41:22 PM$
{B5D3AB87-EED1-11D3-9F76-00C04F8ED1C4}
{43BA3ECC-0120-11d4-AB58-00C04FA379E3}
LocationQueryEngine
TRUE
3
Street or Intersection
Address
Addr
Street
Street
60
TRUE
us_addr2.mat
us_addr.stn
TRUE
& | @
us_intsc2.mat
us_intsc.stn
{D9052385-AB46-11d2-AADA-00C04FA379E3}
{68F5E953-06FF-11d3-AAFD-00C04FA379E3}
mtchloc
mtchloc
ProgID = esriDataSourcesFile.ShapefileWorkspaceFactory.1; Path =
True
True
10
90
SufDir1
SufDir2
PreType1
PreType2
HouseNum
PreDir1
PreDir2
PreDir
PreType
StreetName1
StreetName2
SufDir
StreetName
SufType
SufType1
SufType2
XX
{1845B140-FC3B-11d2-AAFA-00C04FA379E3}
mtchloc
SDEX,mtchloc,SX,""
SpellSens,mtchloc,SpellSens,""
IdxTable1,"IndexTable for Primary table"
IdxTable2,"IndexTable for Alternate Name table"
XID,"Soundex foreign key column",Y,$Table1.ID
Sx,"Soundex code column",Y,@SDEX($Table1.StreetName)
GC_SS
XID,"Soundex foreign key column for the Alternate Name table",Y,$Table2.ID
Sx,"Soundex code column",Y,@SDEX($Table2.StreetName)
GC_ALSS
@SpellSens(%S1%, $Table2.StreetName)
: AND $Table2.ID = $IdxTable2.XID AND $Table1.JOINID = $Table2.JOINID:
Lox2
PreDir1,Table2.PreDir
PreType1,Table2.PreType
StreetName1,Table2.StreetName
Type1,Table2.StreetType
SufDir1,Table2.SufDir
Shape,Table1.Shape
ID,Table1.ID
$IdxTable2.Sx = '@SDEX(%S1%)'
@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
Shape,Table1.Shape
ID,Table1.ID
$IdxTable1.Sx = '@SDEX(%S1%)'
@SpellSens(%S2%, $Table2.StreetName)
: AND $Table2.ID = $IdxTable2.XID AND $Table1.JOINID = $Table2.JOINID:
Lox2
PreDir2,Table2.PreDir
PreType2,Table2.PreType
StreetName2,Table2.StreetName
Type2,Table2.StreetType
SufDir2,Table2.SufDir
Shape,Table1.Shape
ID,Table1.ID
$IdxTable2.Sx = '@SDEX(%S2%)'
@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
Shape,Table1.Shape
ID,Table1.ID
$IdxTable1.Sx = '@SDEX(%S2%)'
ILQuery,"Left Intersection Query"
ILAltQuery,"Left Intersection Query (Alternate Name)"
Lox1
Lox2
$Table1.StreetName <> 'UNNAMED STREET' AND $Table1.StreetName <> 'UNNAMED' AND $Table1.StreetName <> '' AND $Table1.StreetName <> ' '
$IdxTable1.Sx
$Table1.StreetName
$Table1.PreType,$Table1.PreDir,$Table1.SufDir,$Table1.StreetType
0
$Table1.LeftFrom,$Table1.LeftTo,$Table1.RightFrom,$Table1.RightTo,$Table1.ID,$Table1.Shape
$Table2.StreetName <> 'UNNAMED STREET' AND $Table2.StreetName <> 'UNNAMED' AND $Table2.StreetName <> '' AND $Table2.StreetName <> ' '
$IdxTable2.Sx
$Table2.StreetName
$Table2.PreType,$Table2.PreDir,$Table2.SufDir,$Table2.StreetType
0
$Table1.LeftFrom,$Table1.LeftTo,$Table1.RightFrom,$Table1.RightTo,$Table1.ID,$Table1.Shape
Query1,"Main query"
Query2,"Alternate Address query"
@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
Shape,Table1.Shape
ID,Table1.ID
$IdxTable1.Sx = '@SDEX(%SN%)'
@SpellSens(%SN%, $Table2.StreetName)
: AND $Table2.ID = $IdxTable2.XID AND $Table1.JOINID = $Table2.JOINID:
Lox2
LeftFrom,Table1.LeftFrom
LeftTo,Table1.LeftTo
RightFrom,Table1.RightFrom
RightTo,Table1.RightTo
PreDir,Table2.PreDir
PreType,Table2.PreType
StreetName,Table2.StreetName
StreetType,Table2.StreetType
SufDir,Table2.SufDir
Shape,Table1.Shape
ID,Table1.ID
$IdxTable2.Sx = '@SDEX(%SN%)'
IRQuery,"Right Intersection Query"
IRAltQuery,"Right Intersection Query (Alternate Name)"
Table1,"Primary table"
Table2,"Alternate Name table"
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
JOINID,"Join ID",Y,TRUE
ID,"Record ID for the Primary table",N,TRUE
Shape,"Shape column",N,TRUE
esriCatalog.GxFilterPGDBFeatureClasses
esriCatalog.GxFilterSDEFeatureClasses
PreDir,"Prefix Direction",N,FALSE
PreType,"Prefix Type",N,FALSE
StreetName,"Alternate Street Name",N,TRUE
StreetType,"Street Type",N,FALSE
SufDir,"Suffix Direction",N,FALSE
ID,"Record ID for the Alternate Name table",N,TRUE
JOINID,"Join ID",Y,TRUE
esriCatalog.GxFilterPGDBTables
esriCatalog.GxFilterSDETables
GC_SSx3
SX
XID
GC_ALSSx5
SX
XID
Center08132014
OBJECTID_12
JOINID
FAL
TAL
PRE_DIR
::
FAR
TAR
SHAPE
GEOCODEST
TYPE
SUFFDIR
AltTableAlias08132014
OBJECTID_12
JoinID
AliasPreDir
::
AliasStreet
AliasType
AliasSufDir
ProgID = esriDataSourcesGDB.FileGDBWorkspaceFactory.1; Conn = (DATABASE=2014_LoganCity_Geocode.gdb)
130524000262040000
10:40:26 AM
LoganCenter08132014
20
Feet
80
TRUE
TRUE
{AE5A3A0E-F756-11D2-9F4F-00C04F8ED1C4}
True
9.3
False
False
False
False
True
::
::
ARC_Street
::
::
Shape
Status
Score
Side
Match_addr
TrafficLights
002
Projected
GCS_North_American_1983
Linear Unit: Foot_US (0.304801)
NAD_1983_StatePlane_Utah_North_FIPS_4301_Feet
<ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/10.7'><WKT>PROJCS["NAD_1983_StatePlane_Utah_North_FIPS_4301_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",1640416.666666667],PARAMETER["False_Northing",3280833.333333333],PARAMETER["Central_Meridian",-111.5],PARAMETER["Standard_Parallel_1",40.71666666666667],PARAMETER["Standard_Parallel_2",41.78333333333333],PARAMETER["Latitude_Of_Origin",40.33333333333334],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",3560]]</WKT><XOrigin>-119221999.99676862</XOrigin><YOrigin>-93353199.997228891</YOrigin><XYScale>3906.2499963620207</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.008192000007629395</XYTolerance><ZTolerance>2.0000000000000002e-05</ZTolerance><MTolerance>2.0000000000000002e-05</MTolerance><HighPrecision>true</HighPrecision><WKID>102742</WKID><LatestWKID>3560</LatestWKID></ProjectedCoordinateSystem>
20201119
17352700
20201119
17352700
Version 6.2 (Build 9200) ; Esri ArcGIS 10.7.1.11595
TrafficLights
Feature Class
dataset
EPSG
8.9.3(9.3.0.0)
0
Simple
FALSE
0
TRUE
FALSE
TrafficLights
Feature Class
0
OBJECTID
OBJECTID
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
Type
Type
String
254
0
0
Ipaddress
Ipaddress
String
254
0
0
Address
Address
String
254
0
0
GridSmartV
GridSmartV
String
254
0
0
Antenna
Antenna
String
254
0
0
Camera
Camera
String
254
0
0
Cam_Height
Cam_Height
String
254
0
0
Connection
Connection
String
254
0
0
PedButton
PedButton
String
254
0
0
Other
Other
String
254
0
0
FacilityID
FacilityID
String
12
0
0
InspecDate
InspecDate
Date
8
0
0
InspResult
InspResult
String
50
0
0
Shape
Shape
Geometry
4
0
0
Feature geometry.
Esri
Coordinates defining the features.
20201119