20241106
20522100
1.0
FALSE
PermitLocator
Address
US One Address
::
$Revision: 10$
$Date: 7/12/2006 11:51:44 AM$
{B5D3AB87-EED1-11D3-9F76-00C04F8ED1C4}
{43BA3ECC-0120-11d4-AB58-00C04FA379E3}
LocationQueryEngine
TRUE
0
Percent
TRUE
Street
SiteAdd
Street
60
TRUE
us_snum2.mat
us_addr.stn
FALSE
L
R
::
{D9052385-AB46-11d2-AADA-00C04FA379E3}
{68F5E953-06FF-11d3-AAFD-00C04FA379E3}
mtchloc
mtchloc
ProgID = esriDataSourcesFile.ShapefileWorkspaceFactory.1; Path = .
True
true
200
200
10
100
HouseNum
PreDir
PreType
SufDir
StreetName
SufType
XX
Shape
Status
Score
Match_addr
{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_data.MARCUSB.GC_SSx1382
RHN
SX
XID
GIS_Data.A1.AddressPoints
HOUSENUM
OBJECTID
::
::
Shape
STREETNAME
STREETTYPE
STREETDIR
sde.DEFAULT
ProgID = esriDataSourcesGDB.SdeWorkspaceFactory.1; Conn = (ENCRYPTED_PASSWORD=00022e68424376426f496834464e53566f53574e7476444f72706f3249394f47762b62722f494b747857484a492b6b3d2a00;SERVER=durham-gis;INSTANCE=sde:sqlserver:durham-gis;DBCLIENT=sqlserver;DB_C
ONNECTION_PROPERTIES=durham-gis;DATABASE=GIS_Data;USER=marcusb;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS)
131619225094110000
1:35:09 AM
false
0
PermitLocator
1
false
0
ReferenceDataUnits
80
TRUE
FALSE
false
false
{AE5A3A0E-F756-11D2-9F4F-00C04F8ED1C4}
True
True
9.2
false
false
false
false
false
False
false
1
::
::
ARC_Street
::
::
50000
Active_PlumbPmts
002
0.000
Projected
GCS_North_American_1983
Linear Unit: Foot_US (0.304801)
NAD_1983_StatePlane_North_Carolina_FIPS_3200_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.1'><WKT>PROJCS["NAD_1983_StatePlane_North_Carolina_FIPS_3200_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",2000000.002616666],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-79.0],PARAMETER["Standard_Parallel_1",34.33333333333334],PARAMETER["Standard_Parallel_2",36.16666666666666],PARAMETER["Latitude_Of_Origin",33.75],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",2264]]</WKT><XOrigin>-121841899.99987197</XOrigin><YOrigin>-93658999.999860793</YOrigin><XYScale>15624.999985448077</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.0005120000004768374</XYTolerance><ZTolerance>2</ZTolerance><MTolerance>2</MTolerance><HighPrecision>true</HighPrecision><WKID>102719</WKID><LatestWKID>2264</LatestWKID></ProjectedCoordinateSystem>
20180201
01372000
20180201
01372000
Esri ArcGIS 10.2.2.3552
Active_PlumbPmts
Feature Class
0.000
dataset
EPSG
8.2.6
0
Simple
FALSE
0
TRUE
FALSE
Active_PlumbPmts
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.
Permit_ID
Permit_ID
String
30
0
0
P_Type
P_Type
String
10
0
0
P_Status
P_Status
String
10
0
0
In_CIty
In_CIty
String
1
0
0
In_County
In_County
String
1
0
0
P_Activity
P_Activity
String
10
0
0
Unit_Type
Unit_Type
String
10
0
0
Unit_Num
Unit_Num
String
10
0
0
P_Descript
P_Descript
String
254
0
0
PIN
PIN
String
20
0
0
PID
PID
String
20
0
0
PIN15
PIN15
String
15
0
0
PIN4
PIN4
String
4
0
0
SiteAdd
SiteAdd
String
254
0
0
PLUMB_DIST
PLUMB_DIST
String
12
0
0
INSPECTOR
INSPECTOR
String
50
0
0
PLUMB_PH
PLUMB_PH
String
20
0
0
FNAME
FNAME
String
16
0
0
LNAME
LNAME
String
16
0
0
INSPCODE
INSPCODE
String
16
0
0
MAPTITLE
MAPTITLE
String
50
0
0
PLUMB_INSP
PLUMB_INSP
String
50
0
0
PLUM_FNAME
PLUM_FNAME
String
16
0
0
PLUM_LNAME
PLUM_LNAME
String
16
0
0
PBMAPTITLE
PBMAPTITLE
String
50
0
0
20180201