signs_11162010

20250306 11061800 FALSE Cranston Address US Streets with Alternate Names (GDB) $Revision: 13$ $Date: 7/12/2006 11:41:19 AM$ {B5D3AB87-EED1-11D3-9F76-00C04F8ED1C4} {43BA3ECC-0120-11d4-AB58-00C04FA379E3} LocationQueryEngine True 3 Street or Intersection Address Addr 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 = esriDataSourcesGDB.FileGDBWorkspaceFactory.1; Conn = (DATABASE= True 10 60 SufDir1 SufDir2 PreType1 PreType2 HouseNum PreDir1 PreDir2 PreDir PreType StreetName1 StreetName2 SufDir StreetName SufType SufType1 SufType2 XX Address PlaceName CranstonGIS.GISADMIN.PlaceNames ProgID = esriDataSourcesGDB.SdeWorkspaceFactory.1; Conn = (ENCRYPTED_PASSWORD=0002a240ec7e3cf3a04f11ca5711c77c2bdf4700;INSTANCE=sde:sqlserver:chgis01;DATABASE=CranstonGIS;USER=GISAdmin;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS) {1845B140-FC3B-11d2-AAFA-00C04FA379E3} mtchloc SDEX,mtchloc,SX,"" SpellSens,mtchloc,SpellSens,"" IdxTable1,"IndexTable for Primary table" IdxTable2,"IndexTable for Alternate Name table" XID,"Soundex foreign key column",Y,$Table1.ID Sx,"Soundex code column",Y,@SDEX($Table1.StreetName) GC_SS XID,"Soundex foreign key column for the Alternate Name table",Y,$Table2.ID Sx,"Soundex code column",Y,@SDEX($Table2.StreetName) GC_ALSS @SpellSens(%S1%, $Table2.StreetName) : AND $Table2.ID = $IdxTable2.XID AND $Table1.JOINID = $Table2.JOINID: Lox2 PreDir1,Table2.PreDir PreType1,Table2.PreType StreetName1,Table2.StreetName Type1,Table2.StreetType SufDir1,Table2.SufDir Shape,Table1.Shape ID,Table1.ID $IdxTable2.Sx = '@SDEX(%S1%)' @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%, $Table2.StreetName) : AND $Table2.ID = $IdxTable2.XID AND $Table1.JOINID = $Table2.JOINID: Lox2 PreDir2,Table2.PreDir PreType2,Table2.PreType StreetName2,Table2.StreetName Type2,Table2.StreetType SufDir2,Table2.SufDir Shape,Table1.Shape ID,Table1.ID $IdxTable2.Sx = '@SDEX(%S2%)' @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" ILAltQuery,"Left Intersection Query (Alternate Name)" Lox1 Lox2 $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 $Table2.StreetName <> 'UNNAMED STREET' AND $Table2.StreetName <> 'UNNAMED' AND $Table2.StreetName <> '' AND $Table2.StreetName <> ' ' $IdxTable2.Sx $Table2.StreetName $Table2.PreType,$Table2.PreDir,$Table2.SufDir,$Table2.StreetType 0 $Table1.LeftFrom,$Table1.LeftTo,$Table1.RightFrom,$Table1.RightTo,$Table1.ID,$Table1.Shape Query1,"Main query" Query2,"Alternate Address 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%)' @SpellSens(%SN%, $Table2.StreetName) : AND $Table2.ID = $IdxTable2.XID AND $Table1.JOINID = $Table2.JOINID: Lox2 LeftFrom,Table1.LeftFrom LeftTo,Table1.LeftTo RightFrom,Table1.RightFrom RightTo,Table1.RightTo PreDir,Table2.PreDir PreType,Table2.PreType StreetName,Table2.StreetName StreetType,Table2.StreetType SufDir,Table2.SufDir Shape,Table1.Shape ID,Table1.ID $IdxTable2.Sx = '@SDEX(%SN%)' IRQuery,"Right Intersection Query" IRAltQuery,"Right Intersection Query (Alternate Name)" Table1,"Primary table" Table2,"Alternate Name 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 JOINID,"Join ID",Y,TRUE ID,"Record ID for the Primary table",N,TRUE Shape,"Shape column",N,TRUE esriCatalog.GxFilterPGDBFeatureClasses esriCatalog.GxFilterSDEFeatureClasses PreDir,"Prefix Direction",N,FALSE PreType,"Prefix Type",N,FALSE StreetName,"Alternate Street Name",N,TRUE StreetType,"Street Type",N,FALSE SufDir,"Suffix Direction",N,FALSE ID,"Record ID for the Alternate Name table",N,TRUE JOINID,"Join ID",Y,TRUE esriCatalog.GxFilterPGDBTables esriCatalog.GxFilterSDETables CranstonGIS.GISADMIN.GC_SS251 SX XID CranstonGIS.GISADMIN.GC_ALSS417 SX XID CranstonGIS.GISADMIN.RoadCenterlines OBJECTID NAME X_LEFTFROM X_LEFTTO :: :: X_RIGHTFROM X_RIGHTTO SHAPE STREETNAME TYPE_ABREV :: CranstonGIS.GISADMIN.StreetNameScrubber OBJECTID GeocodeName :: :: BadName :: :: sde.DEFAULT ProgID = esriDataSourcesGDB.SdeWorkspaceFactory.1; Conn = (ENCRYPTED_PASSWORD=00027413bf500ec57221e29c1ac46c22d3885400;INSTANCE=sde:sqlserver:chgis01;DATABASE=CranstonGIS;USER=GISAdmin;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS) 129131278235840000 11:57:03 AM Cranston 0 ReferenceDataUnits 80 TRUE TRUE {AE5A3A0E-F756-11D2-9F4F-00C04F8ED1C4} True 9.2 False False False False :: :: ARC_Street :: :: Shape Status Score Side Match_addr 20160930 09011500 20160930 09011500 StopAndYieldSigns_09302016 002 Projected GCS_North_American_1983 Linear Unit: Foot_US (0.304801) NAD_1983_StatePlane_Rhode_Island_FIPS_3800_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.3'><WKT>PROJCS["NAD_1983_StatePlane_Rhode_Island_FIPS_3800_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",328083.3333333333],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-71.5],PARAMETER["Scale_Factor",0.99999375],PARAMETER["Latitude_Of_Origin",41.08333333333334],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",3438]]</WKT><XOrigin>-18120299.999979723</XOrigin><YOrigin>-47742099.999997847</YOrigin><XYScale>28633.1152666667</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>6.9849193193739003e-005</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>2.0000000000000002e-005</MTolerance><HighPrecision>true</HighPrecision><WKID>102730</WKID><LatestWKID>3438</LatestWKID></ProjectedCoordinateSystem> 1.0 withheld 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. signs_11162010 signs_11162010 vector digital data 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 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 state of the data set. 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. Feature Class withheld Local Area Network 002 Feature Class Feature Class Dataset copied. withheld 20100430 09515800 Dataset copied. withheld 20100430 09531000 Dataset copied. withheld 20101116 10072800 Esri ArcGIS 10.3.1.4959 StopAndYieldSigns_09302016 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. 20101116 ISO 19115 Geographic Information - Metadata DIS_ESRI1.0 dataset Downloadable Data Vector Simple FALSE 0 TRUE FALSE GCS_North_American_1983 NAD_1983_StatePlane_Rhode_Island_FIPS_3800_Feet coordinate pair survey feet 0.000035 0.000035 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_Rhode_Island_FIPS_3800_Feet EPSG 8.6.2 0 StopAndYieldSigns_09302016 Feature Class 0 OBJECTID OBJECTID OID 4 10 0 Internal feature number. ESRI Sequential unique whole numbers that are automatically generated. GrpType GrpType String 25 0 0 Item Item Double 8 38 8 Type Type String 25 0 0 Ordinance_Ref Ordinance_Ref String 255 0 0 OrdText OrdText String 255 0 0 Street Street String 255 0 0 CrossStreet CrossStreet String 255 0 0 AuthorizationDate AuthorizationDate Date 36 0 0 AuthorizationOrdinance AuthorizationOrdinance String 100 0 0 Location Location String 255 0 0 TurnFCRecord TurnFCRecord String 25 0 0 Notes Notes String 255 0 0 LocationClarificationNotes LocationClarificationNotes String 255 0 0 DrivingDirection DrivingDirection String 25 0 0 SignID SignID String 15 0 0 Undocumented Undocumented String 10 0 0 FinalDisposition FinalDisposition String 25 0 0 DateRemoved DateRemoved Date 36 0 0 Jurisdiction Jurisdiction String 25 0 0 GroupID GroupID SmallInteger 2 5 0 OrdRefType OrdRefType String 20 0 0 Shape Shape Geometry 4 0 0 Feature geometry. ESRI Coordinates defining the features. TemporaryID TemporaryID String 15 0 0 OrdinanceLink OrdinanceLink String 300 0 0 SignStatus SignStatus String 20 0 0 Duplicate Duplicate String 10 0 0 CorrectionNotes CorrectionNotes String 250 0 0 OrdHistory OrdHistory String 300 0 0 created_user created_user String 255 0 0 created_date created_date Date 36 0 0 last_edited_user last_edited_user String 255 0 0 last_edited_date last_edited_date Date 36 0 0 GlobalID GlobalID GlobalID 38 0 0 MUTCDComplianceDate MUTCDComplianceDate Date 36 0 0 20160930