Layer: Major Roads (ID:12)

View In: Map Viewer

Name: Major Roads

Display Field: FULLNAME

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Description of attributes are as follows:

CENTERLINEID - a unique ID to each segment

FROMLEFT, TOLEFT, FROMRIGHT, TORIGHT - hi low left and right side of the street situs addresses

FULLNAME - the full name of the street spelled out except for the street type which as abbreviated to USPS standards, foreign key into the MasterSreetName table

FEDROUTE - the unique numeric ID assigned to the road by the Federal Govt - Department of Transportation

FEDRTETYPE - type of road assigned by Federal Govt

AFEDRTE- alternate federal route ID

AFEDRTETYPE - alternate federal route type

STROUTE - state route ID assigned by GDOT

STRTETYPE - state route type assigned by GDOT

ASTROUTE - alternate state route ID assigned by GDOT

ASTRTETYPE - alternate state route type assigned by GDOT

CTYROUTE - city route ID

ONEWAYDIR - code to signify a one way road

ROADLEVEL- (currently not used)

INWATER - (currently not used)

ROADCLASS - the type of road from the 2014 DeKalb Transportation Plan (Freeway, Major Arterial, Minor Arterial, Collector, Local, 4WD, Other), Those roads classified as 'Other' signify roads that no longer exist and do not show on County maps.

CFCCCODE- type of road according to the Census Bureau ( 1100=Primary road,1200=Secondary road,1400=Local neighborhood road,1500=Vehicular trail (4WD),1630=Ramp,1640=Service road,1740=Walkway)

OWNEDBY - who own that road segment (1=Our Agency, -1=Private, -2=Other, -3=State, -4=Municipality)

MAINTBY- who maintains the road (1=Our Agency, -1=Private, -2=Other, -3=State, -4=Municipality)

MUNILEFT & MUNIRIGHT - the municipalities on either side of the segment (AE=Avondale Estates,AT=Atlanta,ATL=Atlanta in Fulton County,BH=Brookhaven,CH=Chamblee,CK=Clarkston,DC=unincorporated DeKalb,DE=Decatur,DO=Doraville,DWY=Dunwoody,FCO=Fulton County,GCO=Gwinnett County,LT=Lithonia,PL=Pine Lake,RCO=Rockdale County,SM=Stone Mountain,SP=Stone Mountain Park,TC=Tucker

ZIPLEFT & ZIPRIGHT - the zip codes on either side of the segment

MSAGLEFT & MSAGRIGHT - the MSAG on either side of the segment used by 911, populated with the place name associated with the zip code, aka "community"

ESNLEFT & ESNRIGHT - the emergency service zones on either side of the segment used by 911

LASTEDITOR & LASTUPDATE - who last edited the segment and when

AltName - another name for that road segment, also used for alternative spellings

STREET_NAME_ID - foreign key into the GIS.STREETNAME table

Copyright Text: DeKalb County GIS Department, Atlas GIS (2011)

Min. Scale: 0

Max. Scale: 0

Default Visibility: false

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,255,255,255],"width":1}},"scaleSymbols":true,"transparency":0,"labelingInfo":[{"labelExpressionInfo":{"expression":"$feature.FULLNAME"},"labelPlacement":"esriServerLinePlacementAboveAlong","textLayout":"straight","deconflictionStrategy":"dynamic","allowOverrun":true,"repeatLabel":false,"lineConnection":"minimizeLabels","stackLabel":true,"stackRowLength":24,"stackAlignment":"dynamic","removeDuplicates":"none","useCodedValues":true,"maxScale":0,"minScale":0,"name":"Class 1","priority":-1,"symbol":{"type":"esriTS","color":[0,0,0,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"bottom","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":null,"haloSize":null,"font":{"family":"Tahoma","size":10,"style":"normal","weight":"normal","decoration":"none"}}}]}
HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: FID

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

FID (type: esriFieldTypeOID, alias: FID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
OBJECTID (type: esriFieldTypeInteger, alias: OBJECTID, SQL Type: sqlTypeOther, nullable: true, editable: true)
CENTERLINE (type: esriFieldTypeString, alias: CENTERLINE, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
FROMLEFT (type: esriFieldTypeInteger, alias: FROMLEFT, SQL Type: sqlTypeOther, nullable: true, editable: true)
TOLEFT (type: esriFieldTypeInteger, alias: TOLEFT, SQL Type: sqlTypeOther, nullable: true, editable: true)
FROMRIGHT (type: esriFieldTypeInteger, alias: FROMRIGHT, SQL Type: sqlTypeOther, nullable: true, editable: true)
TORIGHT (type: esriFieldTypeInteger, alias: TORIGHT, SQL Type: sqlTypeOther, nullable: true, editable: true)
FULLNAME (type: esriFieldTypeString, alias: FULLNAME, SQL Type: sqlTypeOther, length: 125, nullable: true, editable: true)
FEDROUTE (type: esriFieldTypeString, alias: FEDROUTE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
FEDRTETYPE (type: esriFieldTypeString, alias: FEDRTETYPE, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
AFEDRTE (type: esriFieldTypeString, alias: AFEDRTE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
AFEDRTETYP (type: esriFieldTypeString, alias: AFEDRTETYP, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
STROUTE (type: esriFieldTypeString, alias: STROUTE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
STRTETYPE (type: esriFieldTypeString, alias: STRTETYPE, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
ASTRTE (type: esriFieldTypeString, alias: ASTRTE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
ASTRTETYPE (type: esriFieldTypeString, alias: ASTRTETYPE, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
CTYROUTE (type: esriFieldTypeString, alias: CTYROUTE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
ONEWAYDIR (type: esriFieldTypeString, alias: ONEWAYDIR, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
ROADLEVEL (type: esriFieldTypeInteger, alias: ROADLEVEL, SQL Type: sqlTypeOther, nullable: true, editable: true)
INWATER (type: esriFieldTypeString, alias: INWATER, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
ROADCLASS (type: esriFieldTypeString, alias: ROADCLASS, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
CFCCCODE (type: esriFieldTypeString, alias: CFCCCODE, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
OWNEDBY (type: esriFieldTypeSmallInteger, alias: OWNEDBY, SQL Type: sqlTypeOther, nullable: true, editable: true)
MAINTBY (type: esriFieldTypeSmallInteger, alias: MAINTBY, SQL Type: sqlTypeOther, nullable: true, editable: true)
MUNILEFT (type: esriFieldTypeString, alias: MUNILEFT, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
MUNIRIGHT (type: esriFieldTypeString, alias: MUNIRIGHT, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
ZIPLEFT (type: esriFieldTypeString, alias: ZIPLEFT, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
ZIPRIGHT (type: esriFieldTypeString, alias: ZIPRIGHT, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
MSAGLEFT (type: esriFieldTypeString, alias: MSAGLEFT, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
MSAGRIGHT (type: esriFieldTypeString, alias: MSAGRIGHT, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
ESNLEFT (type: esriFieldTypeString, alias: ESNLEFT, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
ESNRIGHT (type: esriFieldTypeString, alias: ESNRIGHT, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
LASTUPDATE (type: esriFieldTypeDate, alias: LASTUPDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
LASTEDITOR (type: esriFieldTypeString, alias: LASTEDITOR, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
SHAPE_Leng (type: esriFieldTypeDouble, alias: SHAPE_Leng, SQL Type: sqlTypeOther, nullable: true, editable: true)
AltName (type: esriFieldTypeString, alias: AltName, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
JoinID (type: esriFieldTypeSmallInteger, alias: JoinID, SQL Type: sqlTypeOther, nullable: true, editable: true)
STREET_NAM (type: esriFieldTypeDouble, alias: STREET_NAM, SQL Type: sqlTypeOther, nullable: true, editable: true)
SpeedLimit (type: esriFieldTypeSmallInteger, alias: SpeedLimit, SQL Type: sqlTypeOther, nullable: true, editable: true)
FromElev (type: esriFieldTypeSmallInteger, alias: FromElev, SQL Type: sqlTypeOther, nullable: true, editable: true)
ToElev (type: esriFieldTypeSmallInteger, alias: ToElev, SQL Type: sqlTypeOther, nullable: true, editable: true)
Name (type: esriFieldTypeString, alias: Name, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/31/2022 2:57:07 PM

Schema Last Edit Date: 5/31/2022 2:57:07 PM

Data Last Edit Date: 5/31/2022 2:57:07 PM

Supported Operations: Query Query Pivot Query Top Features Query Analytic Query Bins Generate Renderer Validate SQL Get Estimates ConvertFormat