20171205
17024600
1.0
XTools Pro Metadata
FALSE
Find_By_Address_Point
Address
Locate Physical Addresses
$Revision: 10$
$Date: 7/12/2006 11:51:44 AM$
{04FCADCF-ED3B-11D2-9F48-00C04F8ED1C4}
{43BA3ECC-0120-11d4-AB58-00C04FA379E3}
LocationQueryEngine
True
TRUE
Street
Fulladd
Address
Addr
Street
Street
60
TRUE
us_snum2.mat
us_addr.stn
FALSE
{D9052385-AB46-11d2-AADA-00C04FA379E3}
{68F5E953-06FF-11d3-AAFD-00C04FA379E3}
mtchloc
mtchloc
ProgID = esriDataSourcesGDB.SdeWorkspaceFactory.1; Conn = (SERVER=sql2k8-1;INSTANCE=sde:sqlserver:sql2k8-1;DATABASE=gis;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA)
True
10
15
HouseNum
PreDir
PreType
SufDir
StreetName
SufType
XX
{1845B140-FC3B-11d2-AAFA-00C04FA379E3}
mtchloc
SDEX,mtchloc,SX,""
SpellSens,mtchloc,SpellSens,""
RoundHN,mtchloc,RoundHN,""
IdxTable1,"IndexTable for Primary table"
XID,"Soundex foreign key column",Y,$Table1.ID
Sx,"Soundex code column",Y,@SDEX($Table1.StreetName)
RoundHN,"Rounded House number column",Y,@RoundHN($Table1.HouseNum)
GC_SS
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
$IdxTable1.RoundHN
0
$Table1.HouseNum,$Table1.ID,$Table1.Shape
Query1,"Main query"
SN, $IdxTable1.Sx = '@SDEX(%SN%)'
@SpellSens(%SN%, $Table1.StreetName)
: AND $Table1.ID = $IdxTable1.XID:
Lox1
HouseNum,Table1.HouseNum
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%)' AND $IdxTable1.RoundHN = '@RoundHN(%HN%)'
Table1,"Primary table"
HouseNum,"House Number",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
gis.HAMPTON.GC_SSx25
RHN
SX
XID
GIS.DBO.Addresses
ADDRESS
OBJECTID
DIRECTION
::
Shape
NAME
TYPE
::
dbo.DEFAULT
ProgID = esriDataSourcesGDB.SdeWorkspaceFactory.1; Conn = (ENCRYPTED_PASSWORD=00028220b43ee1751cb75bfb8843e588364a00;SERVER=sql2k8-1;INSTANCE=sde:sqlserver:sql2k8-1;DATABASE=gis;USER=city\alambert;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS)
131493513773950000
1:36:17 PM
DBO.Find_By_Address_Point
15
TRUE
FALSE
{AE5A3A0E-F756-11D2-9F4F-00C04F8ED1C4}
True
True
9.2
False
False
False
::
::
ARC_Street
::
::
Shape
Status
Score
Match_addr
Septic_Tanks
002
Projected
GCS_NAD_1983_2011
Linear Unit: Foot_US (0.304801)
NAD_1983_2011_StatePlane_Virginia_South_FIPS_4502_Ft_US
<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_2011_StatePlane_Virginia_South_FIPS_4502_Ft_US",GEOGCS["GCS_NAD_1983_2011",DATUM["D_NAD_1983_2011",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",11482916.66666666],PARAMETER["False_Northing",3280833.333333333],PARAMETER["Central_Meridian",-78.5],PARAMETER["Standard_Parallel_1",36.76666666666667],PARAMETER["Standard_Parallel_2",37.96666666666667],PARAMETER["Latitude_Of_Origin",36.33333333333334],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",6595]]</WKT><XOrigin>-111140600</XOrigin><YOrigin>-91532100</YOrigin><XYScale>3048.0060960121928</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.0032808333333333331</XYTolerance><ZTolerance>2</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>103177</WKID><LatestWKID>6595</LatestWKID></ProjectedCoordinateSystem>
20251112
10075200
20251112
10075200
Esri ArcGIS 13.5.3.57366
Septic_Tanks
Enterprise Geodatabase Feature Class
dataset
EPSG
8.2.10(10.3.1)
0
Simple
FALSE
0
TRUE
FALSE
Septic_Tanks
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
Match_addr
Match_addr
String
63
0
0
ARC_Street
Street
String
60
0
0
STREETNAME
STREETNAME
String
255
0
0
STREETNAME_1
STREETNAME_1
String
255
0
0
ZIPCODE
ZIPCODE
Integer
4
10
0
OWNER
OWNER
String
255
0
0
ADDRESS
ADDRESS
String
255
0
0
CITY
CITY
String
255
0
0
STATE
STATE
String
255
0
0
OZIPCODE
OZIPCODE
Integer
4
10
0
LASTPUMP
LASTPUMP
Date
8
0
0
CHES_BAY
CHES_BAY
String
255
0
0
Comments
Comments
String
255
0
0
Shape
Shape
Geometry
8
0
0
Feature geometry.
ESRI
Coordinates defining the features.
20251112