20191004
11151000
1.0
FALSE
ADPARCEL Address Matcher
Address
US One Address
$Revision: 12$
$Date: 10/9/2007 5:40:08 PM$
{B5D3AB87-EED1-11D3-9F76-00C04F8ED1C4}
{43BA3ECC-0120-11d4-AB58-00C04FA379E3}
LocationQueryEngine
True
TRUE
Street
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 = esriDataSourcesFile.ShapefileWorkspaceFactory.1; Path =
True
10
50
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
vectorsde.GISDATA.GC_SSx9
RHN
SX
XID
vectorsde.GISDATA.adparcel
STREET_NO
OBJECTID
STREET_DIR
::
Shape
AD_STREET
AD_SUFFIX
::
sde.DEFAULT
ProgID = esriDataSourcesGDB.SdeWorkspaceFactory.1; Conn = (ENCRYPTED_PASSWORD=00027415e273612a15f19d41c07012b67539cf5500;SERVER=pw-sql2005;INSTANCE=5151;USER=mlibert1;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS)
129331283693460000
11:39:29 PM
ADPARCEL Address Matcher
80
TRUE
FALSE
{AE5A3A0E-F756-11D2-9F4F-00C04F8ED1C4}
True
9.3
False
False
False
::
::
ARC_Street
::
::
Shape
Status
Score
Match_addr
TW_LOCIDs
002
875764.187664
1081497.576389
334522.687664
551099.812664
1
Projected
GCS_North_American_1983_HARN
NAD_1983_HARN_StatePlane_Arizona_Central_FIPS_0202_Feet_Intl
<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_HARN_StatePlane_Arizona_Central_FIPS_0202_Feet_Intl",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["Transverse_Mercator"],PARAMETER["False_Easting",700000.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-111.9166666666667],PARAMETER["Scale_Factor",0.9999],PARAMETER["Latitude_Of_Origin",31.0],UNIT["Foot",0.3048],AUTHORITY["EPSG",2868]]</WKT><XOrigin>-17746700</XOrigin><YOrigin>-44067300</YOrigin><XYScale>137254860.72514725</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.0032808398950131233</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>2868</WKID><LatestWKID>2868</LatestWKID></ProjectedCoordinateSystem>
Linear Unit: Foot (0.304800)
20191002
13165100
20191002
13165100
FGDC CSDGM Metadata
Esri ArcGIS 10.6.1.9270
TW_LOCIDs
002
1
-111.350165
-110.679129
32.513752
31.913740
Tucson audit programTAP
Personal GeoDatabase Feature Class
dataset
EPSG
6.13(9.0.0)
Simple
FALSE
252697
TRUE
FALSE
252697
TW_LOCIDs
Feature Class
252697
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.
LOCATIONID
LOCATIONID
Double
8
0
0
CUSTOMERID
CUSTOMERID
Double
8
0
0
NAME
NAME
String
30
0
0
CCF
CCF
Double
8
0
0
SRVC
SRVC
String
2
0
0
MTRADDRESS
MTRADDRESS
String
41
0
0
INSTALLYEAR
INSTALLYEAR
SmallInteger
2
0
0
COTFACILITY
COTFACILITY
String
100
0
0
UPDATED
UPDATED
SmallInteger
2
0
0
ISOLATED
ISOLATED
SmallInteger
2
0
0
TAMPERED
TAMPERED
SmallInteger
2
0
0
PULLED
PULLED
SmallInteger
2
0
0
PY_CODE
PY_CODE
String
20
0
0
SEWER
SEWER
SmallInteger
2
0
0
TRS
TRS
String
10
0
0
WSA
WSA
String
5
0
0
CONTRACT
CONTRACT
String
50
0
0
MASTERPLAN
MASTERPLAN
String
50
0
0
SUBDIVISION
SUBDIVISION
String
100
0
0
X
X
Double
8
0
0
SRVC_TYPE
SRVC_TYPE
String
5
0
0
JURIS
JURIS
String
5
0
0
ACTIVE
ACTIVE
String
5
0
0
PUEBLOCODE
PUEBLOCODE
String
10
0
0
PIO_MFHET
PIO_MFHET
SmallInteger
2
0
0
PIO_CHET
PIO_CHET
SmallInteger
2
0
0
PIO_CHEU
PIO_CHEU
SmallInteger
2
0
0
PIO_SFHET
PIO_SFHET
SmallInteger
2
0
0
PIO_LIHET
PIO_LIHET
SmallInteger
2
0
0
PIO_GW
PIO_GW
SmallInteger
2
0
0
PIO_WH
PIO_WH
SmallInteger
2
0
0
PIO_WM
PIO_WM
SmallInteger
2
0
0
PIO_WH_REBATE
PIO_WH_REBATE
Integer
4
0
0
PIO_WH_LEVEL
PIO_WH_LEVEL
String
10
0
0
RATECLASS
RATECLASS
String
10
0
0
PARCEL
PARCEL
String
15
0
0
DATASOURCE
DATASOURCE
String
50
0
0
20191002
/9j/4AAQSkZJRgABAgAAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0aHBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCACFAMgDASIAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3+iiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAOcHHWqelz31xYq+oWotrnOGjDBh9eCf51copW1uNPS1itHeeZfzWn2a4URKCZmTEbZxwp7n+WPpmzUc/nfZ5Ps4QzbTs8wkLntnHai3877PH9o8vz9o8zy87d3fGe1C7Ddmrokoqtfvdx2btYwpNccbUdtoPPPNUb691S20i9nWyDTo2IUiYuSuQN2ACTjJOAMnGKUppbjjTcrWt95r0VT0oXo0u3/ALRYG7K5lxj5SedvHBx0yAM4zgVcpp3VyZKzaCiiimIKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKqalp1vqthJZXSloZMbgDg8EEfqBVuq11Z/angb7RPF5MgkxE+0Pjs3HI/L+dKSurWuVB2kmnYs0UUUyRrSIjKrOoZvugnBP0qCa/tre9trOWTbPc7vKXaTu2jJ5xgcevXtRc6fa3c9vNPEHkt23Rkk8Hg/jyAee4B7VOY0Z1dkUsudrEcjPXFLUpcvX+uw6iiimSFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFVY7+CXUJrFS3nRKGYFeMHHf8f5+hxaopO/Qat1CiiimIKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoqrdXy2tzawGCeQ3DFQ8aZVCP7x7f/WNWqSaY2mkm+oUUUUxBRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAf/9k=