20220210
15101100
FALSE
Sewer Geocoding Locator 2
Address
Single Field
$Revision: 11$
$Date: 12/17/2007 1:28:00 PM$
{B5D3AB87-EED1-11D3-9F76-00C04F8ED1C4}
{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 = esriDataSourcesFile.ShapefileWorkspaceFactory.1; Path =
True
10
60
KeyField
XX
{1845B140-FC3B-11d2-AAFA-00C04FA379E3}
mtchloc
SDEX,mtchloc,SX,""
RSDEX,mtchloc,RSX,""
SpellSens,mtchloc,SpellSens,""
IdxTable1,"IndexTable for Primary table"
XID,"Soundex foreign key column",Y,$Table1.ID
Sx,"Soundex code column",Y,@SDEX($Table1.KeyField)
RSx,"Reverse Soundex code column",Y,@RSDEX($Table1.KeyField)
GC_KS
Lox1
$Table1.KeyField <> '' AND $Table1.KeyField <> ' '
$IdxTable1.Sx
$IdxTable1.RSx
$Table1.KeyField
1
$Table1.ID,$Table1.Shape
Query1,"Main query"
@SpellSens(%K1%, $Table1.KeyField)
: AND $Table1.ID = $IdxTable1.XID:
Lox1
KeyField,Table1.KeyField
Shape,Table1.Shape
ID,Table1.ID
($IdxTable1.Sx = '@SDEX(%K1%)' OR $IdxTable1.RSx = '@RSDEX(%K1%)')
Table1,"Primary table"
KeyField,"Key Field",N,TRUE
ID,"Record ID for the Primary table",N,TRUE
Shape,"Shape column",N,TRUE
esriCatalog.GxFilterFeatureClasses
SDE.ERIK.GC_KSx12063
RSX
SX
XID
SDE.ERIK.Addresses_ft2
OBJECTID
LSN
Shape
sde.DEFAULT
ProgID = esriDataSourcesGDB.SdeWorkspaceFactory.1; Conn = (ENCRYPTED_PASSWORD=00027514ef78562608e3c072ef9a4d01ad5200;SERVER=gissde1;INSTANCE=esri_sde;USER=erik;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS)
129302434023510000
2:16:42 PM
Sewer Geocoding Locator 2
80
FALSE
FALSE
{AE5A3A0E-F756-11D2-9F4F-00C04F8ED1C4}
True
9.3
False
True
False
::
::
ARC_KeyField
::
::
Shape
Status
Score
Stan_addr
Match_addr
sewer_customers
002
0.000
Projected
GCS_North_American_1983
NAD_1983_StatePlane_Ohio_North_FIPS_3401_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.6'><WKT>PROJCS["NAD_1983_StatePlane_Ohio_North_FIPS_3401_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",1968500.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-82.5],PARAMETER["Standard_Parallel_1",40.43333333333333],PARAMETER["Standard_Parallel_2",41.7],PARAMETER["Latitude_Of_Origin",39.66666666666666],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",3734]]</WKT><XOrigin>-118963900</XOrigin><YOrigin>-96373800</YOrigin><XYScale>3048.0060960121928</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.0032808333333333331</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102722</WKID><LatestWKID>3734</LatestWKID></ProjectedCoordinateSystem>
Linear Unit: Foot_US (0.304801)
20220210
14475100
20220210
14475100
1.0
withheld
withheld
Feature Class
0.000
Dataset copied.
withheld
20100929
14505600
Version 6.2 (Build 9200) ; Esri ArcGIS 10.6.1.9270
sewer_customers
002
dataset
EPSG
6.13(9.3.0.0)
Simple
FALSE
0
TRUE
FALSE
0
sewer_customers
Feature Class
0
OBJECTID
OBJECTID
OID
4
10
0
Internal feature number.
ESRI
Sequential unique whole numbers that are automatically generated.
Shape
Shape
Geometry
4
0
0
Feature geometry.
ESRI
Coordinates defining the features.
Stan_addr
Stan_addr
String
79
0
0
BillID
BillID
Double
8
38
8
PLANT_ID
PLANT_ID
Double
8
38
8
WWTP
WWTP
String
25
0
0
TYPE
TYPE
String
25
0
0
ACCT_NO
ACCT_NO
String
5
0
0
20220210