20260423
22260600
FALSE
BusStopLocator
Address
US Streets Parsed Address (DDP)
$Revision: 12$
$Date: 7/12/2006 11:43:16 AM$
{B5D3AB87-EED1-11D3-9F76-00C04F8ED1C4}
{43BA3ECC-0120-11d4-AB58-00C04FA379E3}
LocationQueryEngine
TRUE
10
House Number
Prefix Direction
Prefix Type
Street Name
Street Type
Suffix Direction
ADDR_HN
HouseNumber
HouseNum
HN
AHN
ADDR_PD
PrefixDirection
Prefix
PreDir
PD
APD
ADDR_PT
PrefixType
PreType
PT
APT
ADDR_SN
StreetName
Street
SN
ASN
ADDR_ST
StreetType
SuffixType
StrType
SufType
ST
AST
ADDR_SD
SuffixDirection
SufDir
SD
ASD
HouseNumber
PrefixDirection
PrefixType
StreetName
StreetType
SuffixDirection
10
2
6
30
6
2
TRUE
FALSE
FALSE
TRUE
FALSE
FALSE
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 = esriDataSourcesGDB.FileGDBWorkspaceFactory.1; Conn = (DATABASE=.)
FALSE
10
60
SufDir1
SufDir2
PreType1
PreType2
HouseNum
PreDir1
PreDir2
PreDir
PreType
StreetName1
StreetName2
SufDir
StreetName
SufType
SufType1
SufType2
HN
PD
PT
SN
ST
SD
{1845B140-FC3B-11d2-AAFA-00C04FA379E3}
mtchloc
SDEX,mtchloc,SX,""
SpellSens,mtchloc,SpellSens,""
IdxTable1,"IndexTable for Primary table"
XID,"Soundex foreign key column",Y,$Table1.ID
Sx,"Soundex code column",Y,@SDEX($Table1.StreetName)
GC_SS
@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%, $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"
Lox1
$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
Query1,"Main 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%)'
IRQuery,"Right Intersection Query"
Table1,"Primary 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
ID,"Record ID for the Primary table",N,TRUE
Shape,"Shape column",N,TRUE
esriCatalog.GxFilterFeatureClasses
GC_SSx10
SX
XID
Streets
OBJECTID
L_F_ADD
L_T_ADD
ADDR_PD
ADDR_PT
R_F_ADD
R_T_ADD
Shape
ADDR_SN
ADDR_ST
ADDR_SD
ProgID = esriDataSourcesGDB.FileGDBWorkspaceFactory.1; Conn = (DATABASE=.)
129180579883370000
1:26:28 PM
BusStopLocator
30
80
TRUE
TRUE
{AE5A3A0E-F756-11D2-9F4F-00C04F8ED1C4}
True
9.2
FALSE
FALSE
FALSE
FALSE
::
::
ARC_HouseNumber
ARC_PrefixDirection
ARC_PrefixType
ARC_StreetName
ARC_StreetType
ARC_SuffixDirection
::
::
Shape
Status
Score
Side
Match_addr
1.0
SDE.BusStops
002
Projected
GCS_North_American_1983
Linear Unit: Foot_US (0.304801)
NAD_1983_StatePlane_California_V_FIPS_0405_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/3.5.0'><WKT>PROJCS["NAD_1983_StatePlane_California_V_FIPS_0405_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",6561666.666666666],PARAMETER["False_Northing",1640416.666666667],PARAMETER["Central_Meridian",-118.0],PARAMETER["Standard_Parallel_1",34.03333333333333],PARAMETER["Standard_Parallel_2",35.46666666666667],PARAMETER["Latitude_Of_Origin",33.5],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",2229]]</WKT><XOrigin>-117608900</XOrigin><YOrigin>-91881400</YOrigin><XYScale>3048.0060960121914</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.0032808333333333335</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102645</WKID><LatestWKID>2229</LatestWKID></ProjectedCoordinateSystem>
20260321
02145600
20260321
02145600
Esri ArcGIS 13.5.3.57366
SDE.BusStops
Enterprise Geodatabase Feature Class
dataset
EPSG
5.3(9.0.0)
0
Simple
FALSE
0
TRUE
FALSE
SDE.BusStops
Feature Class
0
OBJECTID
ObjectID
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
Status
Status
String
1
0
0
Score
Score
SmallInteger
2
5
0
Match_type
Match_type
String
2
0
0
Side
Side
String
1
0
0
Match_addr
Match_addr
String
59
0
0
ARC_HouseNumber
House Number
String
10
0
0
ARC_PrefixDirection
Prefix Direction
String
2
0
0
ARC_PrefixType
Prefix Type
String
6
0
0
ARC_StreetName
Street Name
String
30
0
0
ARC_StreetType
Street Type
String
6
0
0
ARC_SuffixDirection
Suffix Direction
String
2
0
0
ADDR_HN
ADDR_HN
String
10
0
0
ADDR_PD
ADDR_PD
String
2
0
0
ADDR_PT
ADDR_PT
String
6
0
0
ADDR_SN
ADDR_SN
String
30
0
0
ADDR_ST
ADDR_ST
String
6
0
0
ADDR_SD
ADDR_SD
String
2
0
0
LOCATION
LOCATION
String
42
0
0
BUS_STOP
BUS_STOP
String
9
0
0
BusLine
BusLine
String
3
0
0
NAME
NAME
String
100
0
0
DESTINATION
DESTINATION
String
100
0
0
ROUTE
ROUTE
String
100
0
0
TIME
TIME
String
50
0
0
Shape
Shape
Geometry
8
0
0
Feature geometry.
Esri
Coordinates defining the features.
20260321