20231025
11431200
FALSE
SI_SF_ALT
Address
Single Field with Altername Name
$Revision: 8$
$Date: 3/20/2008 11:44:30 AM$
{B5D3AB87-EED1-11D3-9F76-00C04F8ED1C4}
DEFAULTS
{43BA3ECC-0120-11d4-AB58-00C04FA379E3}
LocationQueryEngine
True
KeyField
Name
KeyField
30
TRUE
key_1.mat
key_1.stn
FALSE
{D9052385-AB46-11d2-AADA-00C04FA379E3}
{68F5E953-06FF-11d3-AAFD-00C04FA379E3}
mtchloc
mtchloc
ProgID = esriDataSourcesGDB.FileGDBWorkspaceFactory.1; Conn = (DATABASE=
True
35
60
KeyField
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.KeyField)
GC_KS
XID,"Soundex foreign key column for the Alternate Name table",Y,$Table2.ID
Sx,"Soundex code column",Y,@SDEX($Table2.KeyField)
GC_ALKS
Lox1
Lox2
$Table1.KeyField <> '' AND $Table1.KeyField <> ' '
$IdxTable1.Sx
$Table1.KeyField
0
$Table1.ID,$Table1.Shape
$Table2.KeyField <> '' AND $Table2.KeyField <> ' '
$IdxTable2.Sx
$Table2.KeyField
0
$Table1.ID,$Table1.Shape
Query1,"Main query"
Query2,"Alternate Name query"
@SpellSens(%K1%, $Table1.KeyField)
: AND $Table1.ID = $IdxTable1.XID:
Lox1
KeyField,Table1.KeyField
Shape,Table1.Shape
ID,Table1.ID
$IdxTable1.Sx = '@SDEX(%K1%)'
@SpellSens(%K1%, $Table2.KeyField)
: AND $Table2.ID = $IdxTable2.XID AND $Table1.JOINID = $Table2.JOINID:
Lox2
KeyField,Table2.KeyField
Shape,Table1.Shape
ID,Table1.ID
$IdxTable2.Sx = '@SDEX(%K1%)'
Table1,"Primary table"
Table2,"Alternate Name table"
KeyField,"Key Field",N,TRUE
ID,"Record ID for the Primary table",N,TRUE
JOINID,"Join ID",Y,TRUE
Shape,"Shape column",N,TRUE
esriCatalog.GxFilterPGDBFeatureClasses
esriCatalog.GxFilterSDEFeatureClasses
KeyField,"Key Field",N,TRUE
ID,"Record ID for the Alternate Name table",N,TRUE
JOINID,"Join ID",Y,TRUE
esriCatalog.GxFilterPGDBTables
esriCatalog.GxFilterSDETables
GC_KSx6
SX
XID
GC_ALKSx13
SX
XID
Street_Int
OBJECTID
JOINID
NAME
SHAPE
Street_IntAltName
OBJECTID
JOINID
NAME
ProgID = esriDataSourcesGDB.FileGDBWorkspaceFactory.1; Conn = (DATABASE=.)
129586592922640000
11:34:52 AM
SI_SF_ALT
25
False
FALSE
{AE5A3A0E-F756-11D2-9F4F-00C04F8ED1C4}
True
9.2
False
False
False
Street_IntAltName
ProgID = esriDataSourcesGDB.FileGDBWorkspaceFactory.1; Conn = (DATABASE=.)
JOINID
NAME
::
::
ARC_KeyField
::
::
Shape
Status
Score
Match_addr
TMC_Intersections
002
0.000
Projected
GCS_North_American_1983_HARN
Linear Unit: Foot_US (0.304801)
NAD_1983_HARN_StatePlane_Washington_North_FIPS_4601_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/2.9.0'><WKT>PROJCS["NAD_1983_HARN_StatePlane_Washington_North_FIPS_4601_Feet",GEOGCS["GCS_North_American_1983_HARN",DATUM["D_North_American_1983_HARN",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",0.0],PARAMETER["Central_Meridian",-120.8333333333333],PARAMETER["Standard_Parallel_1",47.5],PARAMETER["Standard_Parallel_2",48.73333333333333],PARAMETER["Latitude_Of_Origin",47.0],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",2926]]</WKT><XOrigin>-117104300</XOrigin><YOrigin>-99539600</YOrigin><XYScale>3048.0060960121918</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>0.0032808333333333331</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>2926</WKID><LatestWKID>2926</LatestWKID></ProjectedCoordinateSystem>
20231019
14533300
20231019
14533300
1.0
withheld
withheld
Local Area Network
File Geodatabase Feature Class
0.000
Dataset copied.
withheld
20120913
08513000
Esri ArcGIS 12.9.4.32739
TMC_Intersections
dataset
EPSG
6.3(9.0.0)
0
Simple
FALSE
0
TRUE
FALSE
TMC_Intersections
Feature Class
0
OBJECTID
OBJECTID
OID
4
0
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
Shape
Shape
Geometry
0
0
0
Feature geometry.
Esri
Coordinates defining the features.
ID
ID
Double
8
0
0
N_S_Street
N_S_Street
String
254
0
0
E_W_Street
E_W_Street
String
254
0
0
Intersecti
Intersecti
String
254
0
0
20231019