CCFDFireHydrants

20100319 09113900 FALSE HydrantStreetLocator Address US Streets with City, State, and ZIP $Revision: 20$ $Date: 12/17/2007 2:36:03 PM$ {B5D3AB87-EED1-11D3-9F76-00C04F8ED1C4} {43BA3ECC-0120-11d4-AB58-00C04FA379E3} LocationQueryEngine TRUE 3 TRUE Street or Intersection City State Abbreviation ZIP Address Addr Street NewFullAddr City State State_abbr State_name ZIP Zipcode Street City State ZIP 60 40 20 12 TRUE FALSE FALSE FALSE us_addr5.mat us_addr.stn TRUE & | @ us_intsc5.mat us_intsc.stn {D9052385-AB46-11d2-AADA-00C04FA379E3} {68F5E953-06FF-11d3-AAFD-00C04FA379E3} mtchloc mtchloc ProgID = esriDataSourcesFile.ShapefileWorkspaceFactory.1; Path = . True 20 30 City SufDir1 SufDir2 PreType1 PreType2 HouseNum PreDir1 PreDir2 PreDir PreType StreetName1 StreetName2 State SufDir StreetName SufType SufType1 SufType2 ZIP XX CT SA ZP SA,@STABBR(%SA%) ZP,@Substr(%ZP%, 0, 5) {1845B140-FC3B-11d2-AAFA-00C04FA379E3} mtchloc SDEX,mtchloc,SX,"" ZNSX,mtchloc,ZoneSX,"" SpellSens,mtchloc,SpellSens,"" STABBR,mtchloc,StateAbbr,"" Substr,mtchloc,Substr,"" IdxTable1,"IndexTable for Primary table" XID,"Soundex foreign key column",Y,$Table1.ID SX,"Soundex code column",Y,@SDEX($Table1.StreetName) CTSXL,"Left city column",Y,@ZNSX($Table1.LeftCity) CTSXR,"Right city column",Y,@ZNSX($Table1.RightCity) ZIPL,"Left ZIP column",Y,@ZNSX($Table1.LeftZIP) ZIPR,"Right ZIP column",Y,@ZNSX($Table1.RightZIP) ZIPL1,"First Digit of Left ZIP column",Y,@Substr($Table1.LeftZIP, 0, 1) ZIPR1,"First Digit of Right ZIP column",Y,@Substr($Table1.RightZIP, 0, 1) STABBR,"State Abbreviation",Y,@STABBR($Table1.State) GC_CSZX SA, " AND ($IdxTable1.STABBR = '@STABBR(%SA%)')" S1, "($IdxTable1.Sx = '@SDEX(%S1%)') AND ($IdxTable1.CTSXL = '@ZNSX(%CT%)' OR $IdxTable1.CTSXR = '@ZNSX(%CT%)') AND ($IdxTable1.STABBR = '@STABBR(%SA%)')" @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 LeftCity1,Table1.LeftCity RightCity1,Table1.RightCity State1,IdxTable1.STABBR LeftZIP1,Table1.LeftZIP RightZIP1,Table1.RightZIP Shape,Table1.Shape ID,Table1.ID $IdxTable1.Sx = '@SDEX(%S1%)' AND ($IdxTable1.ZIPL = '@ZNSX(%ZP%)' OR $IdxTable1.ZIPR = '@ZNSX(%ZP%)') : AND (($IdxTable1.ZIPL1 = '@Substr(%ZP%, 0, 1)' AND $IdxTable1.ZIPL1 <> '') OR ($IdxTable1.ZIPR1 = '@Substr(%ZP%, 0, 1)' AND $IdxTable1.ZIPR1 <> '')): SA, " AND ($IdxTable1.STABBR = '@STABBR(%SA%)')" S2, "($IdxTable1.Sx = '@SDEX(%S2%)') AND ($IdxTable1.CTSXL = '@ZNSX(%CT%)' OR $IdxTable1.CTSXR = '@ZNSX(%CT%)') AND ($IdxTable1.STABBR = '@STABBR(%SA%)')" @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 LeftCity2,Table1.LeftCity RightCity2,Table1.RightCity State2,IdxTable1.STABBR LeftZIP2,Table1.LeftZIP RightZIP2,Table1.RightZIP Shape,Table1.Shape ID,Table1.ID $IdxTable1.Sx = '@SDEX(%S2%)' AND ($IdxTable1.ZIPL = '@ZNSX(%ZP%)' OR $IdxTable1.ZIPR = '@ZNSX(%ZP%)') : AND (($IdxTable1.ZIPL1 = '@Substr(%ZP%, 0, 1)' AND $IdxTable1.ZIPL1 <> '') OR ($IdxTable1.ZIPR1 = '@Substr(%ZP%, 0, 1)' AND $IdxTable1.ZIPR1 <> '')): ILQuery,"Left Intersection Query" Lox1 $Table1.StreetName <> 'UNNAMED STREET' AND $Table1.StreetName <> 'UNNAMED' AND $Table1.StreetName <> '' AND $Table1.StreetName <> ' ' $IdxTable1.STABBR $Table1.State $IdxTable1.ZIPL1,$IdxTable1.ZIPR1 $IdxTable1.ZIPL,$IdxTable1.ZIPR $Table1.LeftZIP,$Table1.RightZIP $IdxTable1.CTSXL,$IdxTable1.CTSXR $Table1.LeftCity,$Table1.RightCity $IdxTable1.Sx $Table1.StreetName $Table1.PreType,$Table1.PreDir,$Table1.SufDir,$Table1.StreetType 0,6 $Table1.LeftFrom,$Table1.LeftTo,$Table1.RightFrom,$Table1.RightTo,$Table1.ID,$Table1.Shape Query1,"Main query" SA, " AND ($IdxTable1.STABBR = '@STABBR(%SA%)')" SN, "($IdxTable1.Sx = '@SDEX(%SN%)') AND ($IdxTable1.CTSXL = '@ZNSX(%CT%)' OR $IdxTable1.CTSXR = '@ZNSX(%CT%)') AND ($IdxTable1.STABBR = '@STABBR(%SA%)')" @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 LeftCity,Table1.LeftCity RightCity,Table1.RightCity State,IdxTable1.STABBR LeftZIP,Table1.LeftZIP RightZIP,Table1.RightZIP Shape,Table1.Shape ID,Table1.ID $IdxTable1.Sx = '@SDEX(%SN%)' AND ($IdxTable1.ZIPL = '@ZNSX(%ZP%)' OR $IdxTable1.ZIPR = '@ZNSX(%ZP%)') : AND (($IdxTable1.ZIPL1 = '@Substr(%ZP%, 0, 1)' AND $IdxTable1.ZIPL1 <> '') OR ($IdxTable1.ZIPR1 = '@Substr(%ZP%, 0, 1)' AND $IdxTable1.ZIPR1 <> '')): 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 LeftCity,"Left City",N,TRUE RightCity,"Right City",N,TRUE State,"State Abreviation",N,TRUE LeftZIP,"Left ZIP Code",N,TRUE RightZIP,"Right ZIP Code",N,TRUE ID,"Record ID for the Primary table",N,TRUE Shape,"Shape column",N,TRUE esriCatalog.GxFilterFeatureClasses sde_Production.WPELOQUIN.GC_CSZXx1247 CTSXL CTSXR STABBR SX XID ZIPLSX ZIPL1 ZIPRSX ZIPR1 sde_Production.GISADMIN.RoadCenterline OBJECTID CITYL FRADDL TOADDL ZIPL FEDIRP PREFIX_TYPE CITYR FRADDR TOADDR ZIPR Shape STATE FENAME FETYPE FEDIRS GISADMIN.wpeloquin ProgID = esriDataSourcesGDB.SdeWorkspaceFactory.1; Conn = (ENCRYPTED_PASSWORD=0002b7613ecaa477543be08614bd741ed88d5600;SERVER=ZADOK;INSTANCE=5155;DATABASE=sde_Production;USER=wpeloquin;VERSION=GISADMIN.wpeloquin;AUTHENTICATION_MODE=DBMS) 129131168493900000 8:54:09 AM HydrantStreetLocator 20 Feet 40 TRUE TRUE {AE5A3A0E-F756-11D2-9F4F-00C04F8ED1C4} True 9.3 False False False False :: :: ARC_Street ARC_City ARC_State ARC_ZIP :: :: Shape Status Score Side Match_addr {9C699522-9100-4257-8ADE-6076AF2ABBB3} 20240410 09121300 20240410 09121300 CCFDFireHydrants 002 Projected GCS_North_American_1983 Linear Unit: Foot_US (0.304801) NAD_1983_StatePlane_Georgia_West_FIPS_1002_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.2.0'><WKT>PROJCS["NAD_1983_StatePlane_Georgia_West_FIPS_1002_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",2296583.333333333],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-84.16666666666667],PARAMETER["Scale_Factor",0.9999],PARAMETER["Latitude_Of_Origin",30.0],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",2240]]</WKT><XOrigin>-16150100</XOrigin><YOrigin>-43703500</YOrigin><XYScale>3048.0060960121928</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.0032808333333333331</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102667</WKID><LatestWKID>2240</LatestWKID></ProjectedCoordinateSystem> 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. CCFDFireHydrants CCFDFireHydrants 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 002 Feature Class Enterprise Geodatabase Feature Class Dataset copied. withheld 20100319 09113900 Esri ArcGIS 13.2.2.49743 CCFDFireHydrants 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. 20100325 ISO 19115 Geographic Information - Metadata DIS_ESRI1.0 dataset Downloadable Data Vector Simple FALSE 0 TRUE FALSE GCS_North_American_1983 NAD_1983_StatePlane_Georgia_West_FIPS_1002_Feet coordinate pair survey feet 0.000625 0.000625 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_Georgia_West_FIPS_1002_Feet EPSG 5.3(9.0.0) 0 CCFDFireHydrants Feature Class 0 OBJECTID OBJECTID OID 4 10 0 Internal feature number. ESRI Sequential unique whole numbers that are automatically generated. Hydr_id Hydr_id String 20 0 0 Main_id Main_id String 254 0 0 Station Station Double 8 38 8 FENAME FENAME String 254 0 0 FETYPE FETYPE String 254 0 0 FEDIRP FEDIRP String 254 0 0 FEDIRS FEDIRS String 254 0 0 NewFullAdd NewFullAdd String 254 0 0 CITYL CITYL String 254 0 0 ZIPL ZIPL String 254 0 0 Corrected Corrected String 5 0 0 Private Private String 5 0 0 created_user created_user String 255 0 0 created_date created_date Date 8 0 0 last_edited_user last_edited_user String 255 0 0 last_edited_date last_edited_date Date 8 0 0 Shape Shape Geometry 8 0 0 Feature geometry. ESRI Coordinates defining the features. Sub_Zone Sub_Zone String 5 0 0 20240410