20190213
15314200
1.0
FALSE
br_streets_venueAddress
US Streets with Zone
Shape
Status
Score
Side
Match_addr
::
$Revision: 12$
$Date: 7/12/2006 11:42:44 AM$
{B5D3AB87-EED1-11D3-9F76-00C04F8ED1C4}
{43BA3ECC-0120-11d4-AB58-00C04FA379E3}
LocationQueryEngine
TRUE
3
Percent
FALSE
Street or Intersection
Zone
Address
Addr
Street
Zip
Zipcode
City
Zone
Street
Zone
60
20
TRUE
FALSE
us_addr1.mat
us_addr.stn
TRUE
L
R
& | @
us_intsc1.mat
us_intsc.stn
{D9052385-AB46-11d2-AADA-00C04FA379E3}
{68F5E953-06FF-11d3-AAFD-00C04FA379E3}
mtchloc
mtchloc
ProgID = esriDataSourcesFile.ShapefileWorkspaceFactory.1; Path = ..\..\..\..\LYRs\Locators
True
true
200
200
10
60
SufDir1
SufDir2
PreType1
PreType2
HouseNum
PreDir1
PreDir2
PreDir
PreType
StreetName1
StreetName2
SufDir
StreetName
SufType
SufType1
SufType2
Zone
XX
ZN
{1845B140-FC3B-11d2-AAFA-00C04FA379E3}
mtchloc
SDEX,mtchloc,SX,""
ZNSX,mtchloc,ZoneSX,""
SpellSens,mtchloc,SpellSens,""
IdxTable1,"IndexTable for Primary table"
XID,"Soundex foreign key column",Y,$Table1.ID
Sx,"Soundex code column",Y,@SDEX($Table1.StreetName)
ZoneL,"Left zone column",Y,@ZNSX($Table1.LeftZone)
ZoneR,"Right zone column",Y,@ZNSX($Table1.RightZone)
GC_SZS
ZN, " AND ($IdxTable1.ZoneL = '@ZNSX(%ZN%)' OR $IdxTable1.ZoneR = '@ZNSX(%ZN%)')"
@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
LeftZone1,Table1.LeftZone
RightZone1,Table1.RightZone
Shape,Table1.Shape
ID,Table1.ID
$IdxTable1.Sx = '@SDEX(%S1%)'
ZN, " AND ($IdxTable1.ZoneL = '@ZNSX(%ZN%)' OR $IdxTable1.ZoneR = '@ZNSX(%ZN%)')"
@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
LeftZone2,Table1.LeftZone
RightZone2,Table1.RightZone
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.ZoneL,$IdxTable1.ZoneR
$Table1.LeftZone,$Table1.RightZone
$IdxTable1.Sx
$Table1.StreetName
$Table1.PreType,$Table1.PreDir,$Table1.SufDir,$Table1.StreetType
1
$Table1.LeftFrom,$Table1.LeftTo,$Table1.RightFrom,$Table1.RightTo,$Table1.ID,$Table1.Shape
Query1,"Main query"
ZN, " AND ($IdxTable1.ZoneL = '@ZNSX(%ZN%)' OR $IdxTable1.ZoneR = '@ZNSX(%ZN%)')"
SN, $IdxTable1.Sx = '@SDEX(%SN%)'
@SpellSens(%SN%, $Table1.StreetName)
: AND $Table1.ID = $IdxTable1.XID:
Lox1
LeftFrom,Table1.LeftFrom
LeftTo,Table1.LeftTo
RightFrom,Table1.RightFrom
RightTo,Table1.RightTo
PreDir,Table1.PreDir
PreType,Table1.PreType
StreetName,Table1.StreetName
StreetType,Table1.StreetType
SufDir,Table1.SufDir
LeftZone,Table1.LeftZone
RightZone,Table1.RightZone
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
LeftZone,"Left Zone",N,TRUE
RightZone,"Right Zone",N,TRUE
ID,"Record ID for the Primary table",N,TRUE
Shape,"Shape column",N,TRUE
esriCatalog.GxFilterFeatureClasses
GC_SZSbr_streets
SX
XID
LZONE
RZONE
br_streets
FID
LLO
LHI
LVENUE
PRD
PRT
RLO
RHI
RVENUE
Shape
STN
STS
POD
ProgID = esriDataSourcesFile.ShapefileWorkspaceFactory.1; Path = ..\..\Layers\Broome\trans_infra
131279063291160000
8:38:49 AM
false
0
br_streets_venue
1
false
25
ReferenceDataUnits
80
TRUE
TRUE
false
false
{AE5A3A0E-F756-11D2-9F4F-00C04F8ED1C4}
True
True
9.2
false
false
false
false
false
False
false
1
::
::
ARC_Street
ARC_Zone
::
::
50000
Disturbance_Merge
002
Projected
GCS_North_American_1983
Linear Unit: Foot_US (0.304801)
NAD_1983_StatePlane_New_York_Central_FIPS_3102_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/2.3.0'><WKT>PROJCS["NAD_1983_StatePlane_New_York_Central_FIPS_3102_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["Transverse_Mercator"],PARAMETER["False_Easting",820208.3333333333],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-76.58333333333333],PARAMETER["Scale_Factor",0.9999375],PARAMETER["Latitude_Of_Origin",40.0],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",2261]]</WKT><XOrigin>-17627200</XOrigin><YOrigin>-47344700</YOrigin><XYScale>3048.0060960121918</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>0.0032808333333333331</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102716</WKID><LatestWKID>2261</LatestWKID></ProjectedCoordinateSystem>
20190508
10363800
20190508
10363800
Esri ArcGIS 12.3.2.15850
Disturbance_Merge
crim
crime
File Geodatabase Feature Class
dataset
EPSG
5.3(9.0.0)
0
Simple
FALSE
0
TRUE
FALSE
Disturbance_Merge
Feature Class
0
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.
Status
Status
String
1
0
0
Score
Score
Integer
4
0
0
Match_type
Match_type
String
2
0
0
Side
Side
String
1
0
0
Match_addr
Match_addr
String
83
0
0
ARC_Street
ARC_Street
String
60
0
0
ADDRESS
ADDRESS
String
254
0
0
OCCURRED_I
OCCURRED_I
String
254
0
0
Type
Type
String
50
0
0
Nature
Nature
String
50
0
0
DATE_REPOR
DATE_REPOR
String
254
0
0
OCCURRED_1
OCCURRED_1
String
254
0
0
SOURCE_ID
Source ID
Integer
4
0
0
CLUSTER_ID
Cluster ID
Integer
4
0
0
PROB
Probability
Double
8
0
0
OUTLIER
Outlier
Double
8
0
0
EXEMPLAR
Exemplar
Integer
4
0
0
STABILITY
Stability
Double
8
0
0
COLOR_ID
Color ID
Integer
4
0
0
20190508