20230412
08550500
FALSE
MemphisStreets
Address
US Streets with Zone
$Revision: 16$
$Date: 12/14/2007 5:41:23 PM$
{B5D3AB87-EED1-11D3-9F76-00C04F8ED1C4}
{43BA3ECC-0120-11d4-AB58-00C04FA379E3}
LocationQueryEngine
TRUE
3
FALSE
Street or Intersection
Zone
Address
Addr
Street
Zip
Zipcode
City
Zone
Street
Zone
60
40
TRUE
FALSE
us_addr1.mat
us_addr.stn
TRUE
& | @
us_intsc1.mat
us_intsc.stn
{D9052385-AB46-11d2-AADA-00C04FA379E3}
{68F5E953-06FF-11d3-AAFD-00C04FA379E3}
mtchloc
mtchloc
ProgID = esriDataSourcesFile.ShapefileWorkspaceFactory.1; Path = ..\..
True
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_SZStl_2012_47157_edges
SX
XID
LZONE
RZONE
tl_2012_47157_edges
FID
LFROMADD
LTOADD
ZIPL
::
::
RFROMADD
RTOADD
ZIPR
Shape
FULLNAME
::
::
ProgID = esriDataSourcesFile.ShapefileWorkspaceFactory.1; Path =
130114464809600000
10:41:20 AM
MemphisStreets
0
Feet
80
TRUE
TRUE
{AE5A3A0E-F756-11D2-9F4F-00C04F8ED1C4}
True
9.3
False
False
False
False
::
::
ARC_Street
ARC_Zone
::
::
Shape
Status
Score
Side
Match_addr
20160801
12013100
20160801
12013100
CommunityCenters
002
0.000
Geographic
GCS_North_American_1983
<GeographicCoordinateSystem xsi:type='typens:GeographicCoordinateSystem' 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>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],AUTHORITY["EPSG",4269]]</WKT><XOrigin>-400</XOrigin><YOrigin>-400</YOrigin><XYScale>11258999068426.238</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>8.9831528411952133e-009</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><LeftLongitude>-180</LeftLongitude><WKID>4269</WKID></GeographicCoordinateSystem>
1.0
ESRI ArcCatalog 9.3.1.3000
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.
Community_Centers_130508
Community_Centers_130508
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.
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.
Shapefile
ESRI ArcGIS 10.0.0.2414
CommunityCenters
002
REQUIRED: A brief narrative summary of the data set.REQUIRED: A summary of the intentions with which the data set was developed.002
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.
20130508
ISO 19115 Geographic Information - Metadata
DIS_ESRI1.0
dataset
Downloadable Data
0.000
0.000
002
withheld
Local Area Network
0.000
Shapefile
Shapefile
0.000
Vector
Simple
1
FALSE
0
FALSE
FALSE
GCS_North_American_1983
Decimal degrees
0.000000
0.000000
North American Datum of 1983
Geodetic Reference System 80
6378137.000000
298.257222
GCS_North_American_1983
EPSG
7.4.1
0
0
CommunityCenters
Feature Class
0
FID
FID
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
SmallInteger
4
4
0
Match_type
Match_type
String
2
0
0
Side
Side
String
1
0
0
Match_addr
Match_addr
String
103
0
0
ARC_Street
ARC_Street
String
60
0
0
ARC_Zone
ARC_Zone
String
40
0
0
Name
Name
String
254
0
0
Community
Community
String
254
0
0
City
City
String
254
0
0
State
State
String
254
0
0
County
County
String
254
0
0
Zip
Zip
Double
19
0
0
20160801