{1C0C0C57-994E-4948-9954-FD68F2AFB6F3}
20100505
15055300
FALSE
$Revision: 15$
$Date: 12/14/2007 5:41:23 PM$
{B5D3AB87-EED1-11D3-9F76-00C04F8ED1C4}
{43BA3ECC-0120-11d4-AB58-00C04FA379E3}
LocationQueryEngine
TRUE
3
Street or Intersection
<_0>Address
<_0>Addr
<_0>Street
Street
60
TRUE
us_addr2.mat
us_addr.stn
TRUE
& | @
us_intsc2.mat
us_intsc.stn
{D9052385-AB46-11d2-AADA-00C04FA379E3}
{68F5E953-06FF-11d3-AAFD-00C04FA379E3}
mtchloc
mtchloc
ProgID = esriDataSourcesFile.ShapefileWorkspaceFactory; Path =
TRUE
10
60
SufDir1
SufDir2
PreType1
PreType2
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,""
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"
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_SSx12SX
XID
cntr_lnsOBJECTID
L_F_ADD
L_T_ADD
PREFIX
R_F_ADD
R_T_ADD
Shape
NAME
SUFFIX
ProgID = esriDataSourcesGDB.FileGDBWorkspaceFactory.1; Conn = (DATABASE=
129804225153050000
8:55:15 AM
Northglenn
20
Feet
80
TRUE
TRUE
{AE5A3A0E-F756-11D2-9F4F-00C04F8ED1C4}
TRUE
9.3
FALSE
FALSE
FALSE
FALSE
withheld
{6A5F1CD0-96B0-41A1-B23A-293BB32F2CDE}
20080111
14345000
FALSE
20100616
15242000
20100616
15242000
ESRI ArcCatalog 9.3.1.1850
en
REQUIRED: A brief narrative summary of the data set.
REQUIRED: A summary of the intentions with which the data set was developed.
REQUIRED: The name of an organization or individual that developed the data set.
REQUIRED: The date when the data set is published or otherwise made available for release.
cntr_lns
cntr_lns
vector digital data
withheld
REQUIRED: The basis on which the time period of content information is determined.
REQUIRED: The year (and optionally month, or month and day) for which the data set corresponds to the ground.
REQUIRED: The frequency with which changes and additions are made to the data set after the initial data set is completed.
-105.015649
-104.944743
39.921408
39.868037
3135953.824560
3155736.353892
1195263.725593
1214589.537335
REQUIRED: Reference to a formally registered thesaurus or a similar authoritative source of theme keywords.
REQUIRED: Common-use word or phrase used to describe the subject of the data set.
REQUIRED: Restrictions and legal prerequisites for accessing the data set.
REQUIRED: Restrictions and legal prerequisites for using the data set after access is granted.
File Geodatabase Feature Class
ESRI ArcCatalog 9.3.1.1850
cntr_lns
3135953.82456
3155736.353892
1214589.537335
1195263.725593
1
-105.015649
-104.944743
39.921408
39.868037
1
en
FGDC Content Standards for Digital Geospatial Metadata
FGDC-STD-001-1998
local time
REQUIRED: The person responsible for the metadata information.
REQUIRED: The organization responsible for the metadata information.
REQUIRED: The mailing and/or physical address for the organization or individual.
REQUIRED: The city of the address.
REQUIRED: The state or province of the address.
REQUIRED: The ZIP or other postal code of the address.
REQUIRED: The telephone number by which individuals can speak to the organization or individual.
20100616
http://www.esri.com/metadata/esriprof80.html
ESRI Metadata Profile
ISO 19115 Geographic Information - Metadata
DIS_ESRI1.0
dataset
Downloadable Data
002
withheld
Local Area Network
File Geodatabase Feature Class
Vector
Simple
Polyline
FALSE
1292
TRUE
FALSE
String
1292
GCS_North_American_1983
NAD_1983_StatePlane_Colorado_North_FIPS_0501_Feet
coordinate pair
survey feet
0.000328
0.000328
Lambert Conformal Conic
39.716667
40.783333
-105.500000
39.333333
3000000.000316
999999.999996
North American Datum of 1983
Geodetic Reference System 80
6378137.000000
298.257222
Explicit elevation coordinate included with horizontal coordinates
0.000100
NAD_1983_StatePlane_Colorado_North_FIPS_0501_Feet
1292
cntr_lns
Feature Class
1292
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.
FNODE_
FNODE_
Integer
4
0
0
TNODE_
TNODE_
Integer
4
0
0
LPOLY_
LPOLY_
Integer
4
0
0
RPOLY_
RPOLY_
Integer
4
0
0
LENGTH
LENGTH
Double
8
0
0
CNTR_LNS_
CNTR_LNS_
Integer
4
0
0
CNTR_LNS_I
CNTR_LNS_I
Integer
4
0
0
FULLNAME
FULLNAME
String
30
0
0
FULLTYPE
FULLTYPE
Double
8
0
0
DXF_LAYER
DXF_LAYER
String
16
0
0
L_F_ADD
L_F_ADD
Double
8
0
0
L_T_ADD
L_T_ADD
Double
8
0
0
R_F_ADD
R_F_ADD
Double
8
0
0
R_T_ADD
R_T_ADD
Double
8
0
0
PREFIX
PREFIX
String
2
0
0
NAME
NAME
String
20
0
0
TYPE
TYPE
String
4
0
0
SUFFIX
SUFFIX
String
3
0
0
Shape_Length
Shape_Length
Double
8
0
0
Length of feature in internal units.
ESRI
Positive real numbers that are automatically generated.
20100616
20120502
08551600
20120502
08551600
Projected
GCS_North_American_1983
Linear Unit: Foot_US (0.304801)
NAD_1983_StatePlane_Colorado_North_FIPS_0501_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.0'><WKT>PROJCS["NAD_1983_StatePlane_Colorado_North_FIPS_0501_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",3000000.000316083],PARAMETER["False_Northing",999999.999996],PARAMETER["Central_Meridian",-105.5],PARAMETER["Standard_Parallel_1",39.71666666666667],PARAMETER["Standard_Parallel_2",40.78333333333333],PARAMETER["Latitude_Of_Origin",39.33333333333334],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",2231]]</WKT><XOrigin>-118265500</XOrigin><YOrigin>-95180100</YOrigin><XYScale>3048.0060960121918</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.0032808333333333335</XYTolerance><ZTolerance>0</ZTolerance><MTolerance>0</MTolerance><HighPrecision>true</HighPrecision><WKID>2231</WKID></ProjectedCoordinateSystem>
ESRI ArcCatalog 9.3.1.1850
en
REQUIRED: A brief narrative summary of the data set.
REQUIRED: A summary of the intentions with which the data set was developed.
REQUIRED: The name of an organization or individual that developed the data set.
REQUIRED: The date when the data set is published or otherwise made available for release.
REQUIRED: The name by which the data set is known.
REQUIRED: The basis on which the time period of content information is determined.
REQUIRED: The year (and optionally month, or month and day) for which the data set corresponds to the ground.
REQUIRED: The frequency with which changes and additions are made to the data set after the initial data set is completed.
REQUIRED: Western-most coordinate of the limit of coverage expressed in longitude.
REQUIRED: Eastern-most coordinate of the limit of coverage expressed in longitude.
REQUIRED: Northern-most coordinate of the limit of coverage expressed in latitude.
REQUIRED: Southern-most coordinate of the limit of coverage expressed in latitude.
REQUIRED: Reference to a formally registered thesaurus or a similar authoritative source of theme keywords.
REQUIRED: Common-use word or phrase used to describe the subject of the data set.
REQUIRED: Restrictions and legal prerequisites for accessing the data set.
REQUIRED: Restrictions and legal prerequisites for using the data set after access is granted.
ESRI ArcGIS 10.0.3.3600
Northglenn
en
FGDC Content Standards for Digital Geospatial Metadata
FGDC-STD-001-1998
local time
REQUIRED: The person responsible for the metadata information.
REQUIRED: The organization responsible for the metadata information.
REQUIRED: The mailing and/or physical address for the organization or individual.
REQUIRED: The city of the address.
REQUIRED: The state or province of the address.
REQUIRED: The ZIP or other postal code of the address.
REQUIRED: The telephone number by which individuals can speak to the organization or individual.
20100505
ISO 19115 Geographic Information - Metadata
DIS_ESRI1.0
dataset
Northglenn
Address Locator
Vector
GCS_North_American_1983
NAD_1983_StatePlane_Colorado_North_FIPS_0501_Feet
coordinate pair
survey feet
0.000328
0.000328
North American Datum of 1983
Geodetic Reference System 80
6378137.000000
298.257222
Explicit elevation coordinate included with horizontal coordinates
1.000000
NAD_1983_StatePlane_Colorado_North_FIPS_0501_Feet
EPSG
7.4.1
20120502