20230627
14314700
1.0
FALSE
ServerLocator
Address
US Streets
1
::
$Revision: 15$
$Date: 12/14/2007 5:41:23 PM$
{B5D3AB87-EED1-11D3-9F76-00C04F8ED1C4}
{43BA3ECC-0120-11d4-AB58-00C04FA379E3}
LocationQueryEngine
TRUE
3
Percent
Street or Intersection
Address
Addr
Street
Street
60
TRUE
us_addr2.mat
us_addr.stn
false
ARC_Street
::
::
TRUE
L
R
/
us_intsc2.mat
us_intsc.stn
{D9052385-AB46-11d2-AADA-00C04FA379E3}
{68F5E953-06FF-11d3-AAFD-00C04FA379E3}
mtchloc
mtchloc
ProgID = esriDataSourcesFile.ShapefileWorkspaceFactory.1; Path =
True
True
200
200
30
60
SufDir1
SufDir2
PreType1
PreType2
HouseNum
PreDir1
PreDir2
PreDir
PreType
StreetName1
StreetName2
SufDir
StreetName
SufType
SufType1
SufType2
XX
Shape
Status
Score
Side
Match_addr
::
::
B
E
O
{1845B140-FC3B-11d2-AAFA-00C04FA379E3}
mtchloc
SDEX,mtchloc,SX,""
SpellSens,mtchloc,SpellSens,""
IdxTable1,"IndexTable for Primary table"
XID,"Soundex foreign key column",Y,$Table1.ID
Sx,"Soundex code column",Y,@SDEX($Table1.StreetName)
GC_SS
@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,$Table1.ID,$Table1.Shape
Query1,"Main query"
@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
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
GC_SSStreets
SX
XID
Streets
FID
LF
LT
::
::
RF
RT
Shape
NAME
TYPE
SUFFIXDIR
ProgID = esriDataSourcesFile.ShapefileWorkspaceFactory.1; Path = .
131018423773870000
4:39:37 PM
false
0
ServerLocator
1
false
20
Feet
80
TRUE
TRUE
false
false
{AE5A3A0E-F756-11D2-9F4F-00C04F8ED1C4}
True
True
9.3
false
false
false
false
False
False
False
False
50000
CrimeReport2018
002
Projected
GCS_North_American_1983
Linear Unit: Foot_US (0.304801)
NAD_1983_StatePlane_Texas_North_Central_FIPS_4202_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/3.0.0'><WKT>PROJCS["NAD_1983_StatePlane_Texas_North_Central_FIPS_4202_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",1968500.0],PARAMETER["False_Northing",6561666.666666666],PARAMETER["Central_Meridian",-98.5],PARAMETER["Standard_Parallel_1",32.13333333333333],PARAMETER["Standard_Parallel_2",33.96666666666667],PARAMETER["Latitude_Of_Origin",31.66666666666667],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",2276]]</WKT><XOrigin>-123407700</XOrigin><YOrigin>-86123500</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>102738</WKID><LatestWKID>2276</LatestWKID></ProjectedCoordinateSystem>
20230627
14194900
20230627
14194900
Esri ArcGIS 13.0.3.36057
CrimeReport2018
File Geodatabase Feature Class
dataset
EPSG
5.3(9.0.0)
0
Simple
FALSE
0
TRUE
FALSE
CrimeReport2018
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.
Match_type
Match_type
String
2
0
0
DATE
DATE
Date
8
0
0
CALL_TYPE
CALL_TYPE
String
254
0
0
ADDRESS
ADDRESS
String
254
0
0
Grid2018
Grid2018
String
50
0
0
District18
District18
String
50
0
0
20230627