Schools20130501

20250515 16083000 FALSE StreetMapUSA LocatorAddress US Streets with City, State, and ZIP for StreetMap $Revision: 13$ $Date: 7/12/2006 11:42:04 AM$ {B5D3AB87-EED1-11D3-9F76-00C04F8ED1C4} {43BA3ECC-0120-11d4-AB58-00C04FA379E3} LocationQueryEngine TRUE 3 TRUE Street or Intersection City State Abbreviation ZIP Address Addr Street City State State_abbr State_name ZIP Zipcode Street City State ZIP 60 40 20 12 TRUE FALSE FALSE FALSE sm9usa.mat sm9usa.stn TRUE & | @ sm9usai.mat sm9usai.stn {D9052385-AB46-11d2-AADA-00C04FA379E3} {68F5E953-06FF-11d3-AAFD-00C04FA379E3} mtchloc mtchloc True 10 70 City SufDir1 SufDir2 PreType1 PreType2 HouseNum PreDir1 PreDir2 PreDir PreType StreetName1 StreetName2 State SufDir StreetName SufType SufType1 SufType2 ZIP XX CT SA ZP {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)' OR $IdxTable1.ZIPR1 = '@Substr(%ZP%, 0, 1)') 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)' OR $IdxTable1.ZIPR1 = '@Substr(%ZP%, 0, 1)') 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)' OR $IdxTable1.ZIPR1 = '@Substr(%ZP%, 0, 1)') 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 GC_CSZXSDE.SDE.TIGER_STREETS CTSXL CTSXR STABBR SX XID ZIPLSX ZIPL1 ZIPRSX ZIPR1 SDE.SDE.TIGER_STREETS OBJECTID POSTNAME_L ADDR_LF ADDR_LT ZIPL PREFIX :: POSTNAME_R ADDR_RF ADDR_RT ZIPR SHAPE STATE NAME TYPE SUFFIX sde.DEFAULT ProgID = esriDataSourcesGDB.SdeWorkspaceFactory.1; Conn = (ENCRYPTED_PASSWORD=0002bd6841dfb88232d77d1b99454600;SERVER=mapdata;INSTANCE=5151;DATABASE=sde;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS) 128021111488120000 1:59:08 PM 0.0001 ReferenceDataUnits 80 TRUE TRUE {AE5A3A0E-F756-11D2-9F4F-00C04F8ED1C4} False 9.2 False False False False ProgID = esriDataSourcesFile.ShapefileWorkspaceFactory; Path = _GIS Data Library\_ESRI Data & Maps and StreetMap USA - DVD 9.2 20061212\usa\streetmap_usa\streets\ StreetMapUSA Locator :: :: ARC_Street ARC_City ARC_State ARC_ZIP :: :: Shape Status Score Side Match_addr 20230825 09454600 20230825 09454600 Schools 002 206863.434100 399677.989900 3868136.672200 4134877.786200 1 0.017 Projected GCS_North_American_1983 Linear Unit: Meter (1.000000) NAD_1983_UTM_Zone_15N <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.6'><WKT>PROJCS["NAD_1983_UTM_Zone_15N",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",500000.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-93.0],PARAMETER["Scale_Factor",0.9996],PARAMETER["Latitude_Of_Origin",0.0],UNIT["Meter",1.0],AUTHORITY["EPSG",26915]]</WKT><XOrigin>-5120900</XOrigin><YOrigin>-9998100</YOrigin><XYScale>10000</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.001</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>26915</WKID><LatestWKID>26915</LatestWKID></ProjectedCoordinateSystem> 1.0 XTools Pro Metadata ItemDescription 150000000 5000 ESRI ArcCatalog 9.2.6.1500 en Schools dataset developed from OK State Education Dept list of public schools. Schools where first geocoded. If the school was not matched during the geocoding then further research was done to located exact location from 2008 aerials. Updated 5/2/2013. 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. Schools20130501 14_County_Schools vector digital data withheld publication date 2009 Complete Annually -96.292762 -94.539098 37.012622 35.339267 206891.039752 360188.601705 3915441.719034 4097426.962731 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 David Justice Cherokee Nation GeoData Center GIS Administrator 918-453-5000 Version 6.2 (Build 9200) ; Esri ArcGIS 10.6.1.9270 Schools 206891.039752 360188.601705 4097426.962731 3915441.719034 1 -96.292762 -94.539098 37.012622 35.339267 1 1 -96.307733 -94.098719 37.355191 34.913371 <DIV STYLE="text-align:Left;"><DIV><DIV>Dataset developed from....SCHOOLS-Oklahoma State Department of Education (www.ok.gov/sde/)-Oklahoma Private School Accrediting Commission(www.opsac.org/)and internet searches.HIGHER EDUCATION-Oklahoma State Regents for Higher Education (www.okhighered.org/)-Arkansas Department of Higher Education (www.adhe.edu)-Kansas Board of Regents (www.kansasregents.org/)-Missouri Department of Higher Education (www.dhe.mo.gov)-North Central Association of Colleges and Schools (www.northcentralassociation.org/)and internet searches.TECHNICAL-Oklahoma Department of Career and Technology Education (www.okcareertech.org/)-Oklahoma Board of Private Vocational Schools (405.528.3370)-Oklahoma State Board of Cosmetology and Barbering (www.ok.gov/cosmo/)-Accrediting Commission of Career Schools and Colleges (www.accsc.org)-Association for Biblical Higher Education (www.abhe.org)-Council on Occupational Education (www.council.org)-National Accrediting Commission of Career Arts & Sciences (www.naccas.org)and internet searches.JOM-Reba Bruner (ex 5397)HEAD START CENTERS-Cherokee Nation Head Start - Sheryl McMahan, Manager, Administrative Operations (ex 5717)-Office of Head Start (www.acf.hhs.gov/programs/ohs)Updated 10/17/2014.</DIV></DIV></DIV> Updated 10/17/2014 Schools within Cherokee Nation, schools recieving Cherokee Nation funds; head start centers ran by Cherokee Nation and head start centers within/ or near Cherokee Nation; higher education and career/trade schools within and around Cherokee Nation. Schools en FGDC Content Standards for Digital Geospatial Metadata FGDC-STD-001-1998 local time David Justice Cherokee Nation GeoData Center 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. 918-453-5000 GIS Administrator 20090318 ISO 19115 Geographic Information - Metadata DIS_ESRI1.0 dataset Downloadable Data 0.905 0.905 002 withheld Local Area Network 0.019 Shapefile Feature Class 0.017 Vector Simple FALSE 690 TRUE FALSE GCS_North_American_1983 NAD_1983_UTM_Zone_15N North American Datum of 1983 Geodetic Reference System 80 6378137.000000 298.257222 coordinate pair meters 0.000000 0.000000 NAD_1983_UTM_Zone_15N EPSG 6.13(3.0.1) 690 Schools Feature Class 690 OBJECTID OBJECTID OID 4 10 0 Internal feature number. Esri Sequential unique whole numbers that are automatically generated. Shape Shape Geometry 4 0 0 Feature geometry. ESRI Coordinates defining the features. Match_addr Match_addr String 135 0 0 ARC_Street ARC_Street String 60 0 0 ARC_City ARC_City String 40 0 0 ARC_ZIP ARC_ZIP String 12 0 0 DISTRICT_C DISTRICT_C String 254 0 0 COUNTY_NAM COUNTY_NAM String 254 0 0 SITE_NAME SITE_NAME String 254 0 0 SITE_NAM_1 SITE_NAM_1 String 254 0 0 SITE_LEVEL SITE_LEVEL String 254 0 0 LOW_GRADE LOW_GRADE String 254 0 0 District District String 50 0 0 En_Oct2010 En_Oct2010 Integer 4 10 0 JOM JOM String 3 0 0 Phone Phone String 25 0 0 En_Oct2011 En_Oct2011 Integer 4 10 0 High_Grad High_Grad String 10 0 0 En_May2014 En_May2014 Integer 4 10 0 En_Aug2014 En_Aug2014 Integer 4 10 0 AIAN_Popul AIAN_Popul String 10 0 0 En_May2015 En_May2015 Integer 4 10 0 En_Nov2015 En_Nov2015 Integer 4 10 0 En_Aug2016 En_Aug2016 Integer 4 10 0 En_Aug2015 En_Aug2015 Integer 4 10 0 RuleID RuleID Integer 4 10 0 Override Override Blob 0 0 0 En_Aug2019 En_Aug2019 Integer 4 10 0 En_Mar2020 En_Mar2020 Double 8 38 8 En_June2021 En_June2021 Double 8 38 8 Reservation Reservation String 3 0 0 En_Feb2023 En_Feb2023 Double 8 38 8 20230825 Dataset copied. 20090318 16144900 Dataset copied. withheld 20090728 14293800 Dataset moved. withheld 20090728 15315300 Dataset copied. withheld 20091118 10540400 Dataset copied. withheld 20100208 13352800 0 Data CNMAIN\eric-dean 11/22/2010 4:19:26 PM 1 Data CNMAIN\eric-dean 12/2/2010 1:42:08 PM