20120215
14313400
FALSE
COSDC Address Locator 2011
Address
US Alphanumeric Ranges
$Revision: 15$
$Date: 12/14/2007 5:41:21 PM$
{04FCADCF-ED3B-11D2-9F48-00C04F8ED1C4}
DEFAULTS
{78E9FDDC-001A-11d4-AB58-00C04FA379E3}
mtchloc
TRUE
1
Street or Intersection
Address
Addr
Street
Street
60
TRUE
us_addc4.mat
us_addrc.stn
TRUE
& | @
us_intsc2.mat
us_intsc.stn
{D9052385-AB46-11d2-AADA-00C04FA379E3}
{68F5E953-06FF-11d3-AAFD-00C04FA379E3}
mtchloc
mtchloc
ProgID = esriDataSourcesGDB.SdeWorkspaceFactory.1; Conn = (ENCRYPTED_PASSWORD=00027523ec7b5f3919f2c9aa2ae68b40fcb14700;SERVER=Gisserver;INSTANCE=sde:sqlserver:Gisserver;DATABASE=SDE;USER=jonesr;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS)
True
10
60
SufDir1
SufDir2
PreType1
PreType2
GridZone
HouseNum
PreDir1
PreDir2
PreDir
PreType
StreetName1
StreetName2
SufDir
StreetName
SufType
SufType1
SufType2
XX
{1845B140-FC3B-11d2-AAFA-00C04FA379E3}
mtchloc
SDEX,mtchloc,SX,""
SpellSens,mtchloc,SpellSens,""
GridRange,mtchloc,GridRange,""
IdxTable1,"IndexTable for Primary table"
XID,"Soundex foreign key column",Y,$Table1.ID
Sx,"Soundex code column",Y,@SDEX($Table1.StreetName)
LeftGridZone,"",Y,@GridRange($Table1.LeftFrom, $Table1.LeftTo, 0)
LeftFrom,"",Y,@GridRange($Table1.LeftFrom, $Table1.LeftTo, 2)
LeftTo,"",Y,@GridRange($Table1.LeftFrom, $Table1.LeftTo, 3)
RightGridZone,"",Y,@GridRange($Table1.RightFrom, $Table1.RightTo, 1)
RightFrom,"",Y,@GridRange($Table1.RightFrom, $Table1.RightTo, 2)
RightTo,"",Y,@GridRange($Table1.RightFrom, $Table1.RightTo, 3)
GC_GR
@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,$IdxTable1.LeftFrom,$IdxTable1.LeftTo,$IdxTable1.LeftGridZone,$IdxTable1.RightFrom,$IdxTable1.RightTo,$IdxTable1.RightGridZone,$Table1.ID,$Table1.Shape
Query1,"Main query"
@SpellSens(%SN%, $Table1.StreetName)
: AND $Table1.ID = $IdxTable1.XID:
Lox1
GridZoneL,IdxTable1.LeftGridZone
LeftFrom,IdxTable1.LeftFrom
LeftTo,IdxTable1.LeftTo
GridZoneR,IdxTable1.RightGridZone
RightFrom,IdxTable1.RightFrom
RightTo,IdxTable1.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
SDE.DBO.GC_GRx5599
LF
LGZ
LT
RF
RGZ
RT
SX
XID
SDE.DBO.TRANS_COSDC_ROADS_Merge
OBJECTID
L_F_ADD
L_T_ADD
::
PREFIX
R_F_ADD
R_T_ADD
Shape
NAME
TYPE
::
sde.DEFAULT
129500217070160000
12:15:07 PM
DBO.COSDC_Address_Locator_2011
30
Feet
80
GD
TRUE
TRUE
{AE5A3A0E-F756-11D2-9F4F-00C04F8ED1C4}
True
9.3
True
True
True
True
ProgID = esriDataSourcesGDB.SdeWorkspaceFactory.1; Conn = (ENCRYPTED_PASSWORD=00027523ec7b5f3919f2c9aa2ae68b40fcb14700;SERVER=Gisserver;INSTANCE=sde:sqlserver:Gisserver;DATABASE=SDE;USER=jonesr;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS)
::
::
ARC_Street
::
::
Shape
Status
Score
Side
X
Y
Stan_addr
Ref_ID
Pct_along
Match_addr
COSDC.DBO.ADMIN_COSDC_POLLING_PLACES_2011
002
123738.318622
279810.089483
105862.987066
307802.626924
1
0.001
Server=GISSERVER2011; Service=sde:sqlserver:gisserver2011; Database=COSDC; User=fisknessj; Version=sde.DEFAULT
ArcSDE Connection
Projected
douglas cnty geographic coord system
dc-4
<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["dc-4",GEOGCS["douglas cnty geographic coord system",DATUM["<custom>",SPHEROID["douglas county",6378414.93,298.27021878]],PRIMEM["greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",194000.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-91.91666667],PARAMETER["Scale_Factor",0.999994968],PARAMETER["Latitude_Of_Origin",45.88333333],UNIT["Foot_US",0.3048006096012192]]</WKT><XOrigin>-18255300</XOrigin><YOrigin>-49493900</YOrigin><XYScale>137236248.56384292</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></ProjectedCoordinateSystem>
Linear Unit: Foot_US (0.304801)
CopyFeatures "Database Connections\GIS2011-SDE.sde\COSDC.DBO.ADMIN_COSDC_POLLING_PLACES_2011" "Database Connections\Gis2011-Beta (Editing).sde\Beta.DBO.ADMIN_COSDC_POLLING_PLACES_2011" # 0 0 0
CopyFeatures "Database Connections\Gis2011-Beta (Editing).sde\Beta.DBO.ADMIN_COSDC_POLLING_PLACES_2011" "Database Connections\GIS2011-SDE.sde\COSDC.DBO.ADMIN_COSDC_POLLING_PLACES_2011" # 0 0 0
20141008
11570800
20141008
11570800
1.0
FGDC CSDGM Metadata
Microsoft Windows 7 Version 6.1 (Build 7601) Service Pack 1; Esri ArcGIS 10.2.0.3348
Superior Polling Places
002
-92.196811
-91.574529
46.727316
46.173118
1
Superior Polling Places
Superior Polling Places
SDE Feature Class
0.001
dataset
Simple
FALSE
26
TRUE
FALSE
26
COSDC.DBO.ADMIN_COSDC_POLLING_PLACES_2011
Feature Class
26
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.
Score
Score
SmallInteger
2
5
0
Side
Side
String
1
0
0
X
X
Double
8
24
6
Y
Y
Double
8
24
6
Ref_ID
Ref_ID
Integer
4
10
0
Municipali
Municipali
String
254
0
0
Bldg
Bldg
String
254
0
0
District
District
String
25
0
0
GlobalID
GlobalID
GlobalID
38
0
0
address
address
String
254
0
0
20141008
/9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a
HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy
MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCACFAMgDASIA
AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA
AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3
ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm
p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA
AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx
BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK
U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3
uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3+iii
gAooooAKKKKACo554baIyzyxxRggF5GCgEnA5PqSB+NSVBeWVrqFsbe8toriBiCY5kDqSDkcHjgg
GgCNtQRdWTTzBc7mhM3n+UfJGGC7S/TdznHpVuqGoWmm6jLbWt8sMssci3UETthg0ZGHAzk4JHtz
z1qSO0mTVZ7tr6d4ZIkjW1IXy4ypYlgcZycjqe35AFuiiigAooooAKKKKACiiigAooooAKKKKACi
iigAooooAKKKKACiiigAooooAqXd3NbXNnFFYz3CTymOSSMqBANpO5skHGQBxnr+duiigDNEfneI
nkl0hB9ntwINRYoWbeTvjA+8oG1Sexz7VpUUUAFFQT3tray28VxcwxSXD+XCjuFMjYJwoPU4BPHp
U9ABRRRQBWsNRs9Vs1u7C6iubZiyrLEwZSVJU4I9CCKs01ESNdqKqrknCjA55NOoAKqQ6ba2+pXW
oRo4ubpUWVjIxBCZ24UnA6noBVuigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKDwOmfaii
gCpptzc3enQT3li1jcOuXtmkVzGfTcvBq3RRQBHJBDM8TyxRu8Tb42ZQSjYIyPQ4JH0JqSjIzjPN
FABVSOwWPVZ9QFxcs00SRGFpSYl2ljuVOgY7uT3wKt0UAVNOubq6tmku7F7KQSugjeRXJUMQrZXj
5gAcds4oB1D+1nBS2/s3yAVYM3m+buOQRjG3bjvnNW6KACiiigAoqpbHUDfXguktltAy/ZDGzFyN
vzbwRgHdnGO1W6ACiiigAooooAKKKKACiiigAooooAKKKKACiiqltc3U19eQzWLwQQsohnMisJwV
ySAOVweOetAFuiiigCodNs21ZdUNupvlhNus3ORGWDFfzANW6KKAILy7t9Psp7y6lEVvBG0srnoq
qMk/kKfBPFdW8VxA4eKVA6OOjKRkH8qkIBGCMg0UAFRztKlvK8EYllVCUjLbQzY4GecZPepKKAIL
KS4msbeS7gW3uXjVpYVfeI2I5Xd3weM1PRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFF
FFABRRRQAUUUUAFVL+O/kSAafcQQsJ0aUzRF90QPzKMEYYjoecelW6KACiiigCB721S9jsnuYVup
UaSOEuA7KuMkDqQMj86nqMwQtcJcNFGZkUoshUblU4JAPUA4H5CpKACiiigAooooAKKKKACiiigA
ooooAKKKKACiiigAooooAKKKKACiiigAqNLiCSWWJJo2kiIEiBgShIyAR2yCDUlZtzoGk3cxmn0+
3aU3Edy0gTDNLH9xiRySO2aANKiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACii
igAooooAKKKKACiiigAoqtY6jZ6nA09jdRXESyNEXiYMAykhh9QRVmgAooooAKKKKACiiigAoooo
AKKKKACiiigAooooAKKKKACqkd60mqz2Js7lFiiSQXLKPKfcWG1TnJYbeRjuPWrdFABRRRQAUUUU
AFFFBIAyTgCgBqIka7UVVBJbCjHJOSfxJJp1VdN1Kz1fT4b+wnWe1mG6ORc4YZx3+lWqACiiigAo
oooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKAAAAYAwBRRRQAUUUUAFF
FFABRRRQAUUUUAFFFFAH/9k=