Name: Pershing Roads
Display Field: MAINNAME
Type: Feature Layer
Geometry Type: esriGeometryPolyline
Has Views: true
Source Schema Changes Allowed: true
Views
Description:
Copyright Text:
Min. Scale: 0
Max. Scale: 0
Default Visibility: true
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: -13285762.1025959
YMin: 4859853.80328158
XMax: -13060937.136692
YMax: 4991793.37402004
Spatial Reference: 102100 (3857)
Drawing Info:
{"renderer":{"type":"uniqueValue","field1":"FUNCTIONCODE","uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[250,52,17,255],"width":1.7},"value":"INTERSTATE","label":"Interstate"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,0,0,255],"width":1.5},"value":"STATE","label":"State Route"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,0,0,255],"width":1.5},"value":"STATE / LOCAL","label":"State Route"},{"symbol":{"type":"esriSLS","style":"esriSLSDashDot","color":[0,0,0,255],"width":0.4},"value":"","label":"Local Route"},{"symbol":{"type":"esriSLS","style":"esriSLSDashDot","color":[0,0,0,255],"width":0.4},"value":"CITY LOCAL","label":"Local Route"},{"symbol":{"type":"esriSLS","style":"esriSLSDashDot","color":[0,0,0,255],"width":0.4},"value":"COUNTY LOCAL","label":"Local Route"},{"symbol":{"type":"esriSLS","style":"esriSLSDashDot","color":[0,0,0,255],"width":0.4},"value":"LOCAL","label":"Local Route"},{"symbol":{"type":"esriSLS","style":"esriSLSDashDot","color":[0,0,0,255],"width":0.4},"value":"STATE FRONTAGE","label":"Local Route"},{"symbol":{"type":"esriSLS","style":"esriSLSDashDot","color":[0,0,0,255],"width":0.4},"value":"STATE FRONTAGE / LOCAL","label":"Local Route"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[104,104,104,255],"width":0.2},"value":"INTERSTATE RAMP","label":"On / Off Ramp"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[62,161,207,255],"toColor":[241,250,122,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[241,250,122,255],"toColor":[240,36,29,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":[{"labelExpressionInfo":{"expression":"var name = $feature.MAINNAME\n// create dictionary for label contents\nvar label = []\n\n// iterate through name to find numbers\nfor (var i in name){\n var namei = Text(Number(name[i])) // Number converts value to a number. Text coverts it back to text. Sets this to a variable\n if(namei != \"NaN\") {\n Push(label, namei) // Push adds an element to an array (name of array, value to add)\n }\n}\nreturn Number(Concatenate(label,\"\"))","title":"Interstate - Arcade"},"labelPlacement":"esriServerLinePlacementCenterAlong","textLayout":"horizontal","deconflictionStrategy":"dynamic","allowOverrun":true,"repeatLabel":false,"lineConnection":"none","multiPart":"labelPerFeature","stackLabel":true,"stackAlignment":"dynamic","removeDuplicates":"all","removeDuplicatesDistance":100,"stackRowLength":24,"where":"FUNCTIONCODE = 'INTERSTATE'","useCodedValues":false,"maxScale":0,"minScale":0,"name":"Interstate - Arcade","priority":-1,"symbol":{"type":"esriTS","color":[255,255,255,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":"Arial","size":10,"style":"normal","weight":"bold","decoration":"none"}}},{"labelExpressionInfo":{"expression":"var mainfulname = $feature.MAINFULNAME\n// create dictionary for label contents\nvar label = []\n\n// convert mainname to uppercase\nvar mainUpper = Upper(mainfulname)\n\nfor (var i in mainfulname){\n // check if \"STATE RTE\" is present in the main name\n if (Find('STATE RTE', mainUpper) > -1 ){ // Find('searchText','targetText') returns number position of first character of string \n // Extract numbers from mainname using regex\n var routeNum = Text(Number(mainfulname[i])) // Number converts value to a number. Text coverts it back to text. Sets this to a variable\n if(routeNum != \"NaN\" && routeNum != \"0\") {\n Push(label, routeNum) // Push adds an element to an array (name of array, value to add)\n } \n } else {\n // check if \"STATE RTE\" is present in als1fulname\n var als1name = $feature.ALS1FULNAME\n var als1Upper = Upper(als1name)\n if (Find(\"STATE RTE\", als1Upper) > -1) {\n // Extract numbers from als1name \n var altRouteNum = Text(Number(als1name)) // Number converts value to a number. Text coverts it back to text. Sets this to a variable\n if(altRouteNum != \"NaN\" && altRouteNum != \"0\"){\n // add als1name to label array\n Push(label, altRouteNum)\n }\n }\n }\n}\nreturn Concatenate(label,\"\")","title":"State Routes"},"labelPlacement":"esriServerLinePlacementCenterAlong","textLayout":"horizontal","deconflictionStrategy":"dynamic","allowOverrun":true,"repeatLabel":false,"lineConnection":"none","multiPart":"labelPerFeature","stackLabel":true,"stackAlignment":"dynamic","removeDuplicates":"all","removeDuplicatesDistance":0,"stackRowLength":24,"useCodedValues":true,"maxScale":0,"minScale":50000,"name":"State Route - Arcade","priority":-1,"symbol":{"type":"esriTS","color":[0,0,0,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"bottom","horizontalAlignment":"center","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":null,"haloSize":null,"font":{"family":"Arial","size":8,"style":"normal","weight":"bold","decoration":"none"}}},{"labelExpressionInfo":{"expression":"var mainfulname = $feature.MAINFULNAME\nvar mainUpper = Upper(mainfulname)\n\nvar als1name = $feature.ALS1FULNAME\nvar altUpper = Upper(als1name)\n\nif ((Find('STATE FRONTAGE',mainUpper) == -1) && (Find('STATE RTE',mainUpper) == -1)){\n return mainUpper\n}\nif (!IsEmpty(als1name)){\n if ((Find('STATE RTE',altUpper) == -1) && (Find('STATE FRONTAGE',altUpper) == -1)){\n return altUpper\n}}","title":"Street Names - Arcade"},"labelPlacement":"esriServerLinePlacementCenterAlong","textLayout":"followFeature","deconflictionStrategy":"dynamic","allowOverrun":true,"repeatLabel":false,"lineConnection":"minimizeLabels","allowOverlapOfFeatureInterior":"avoid","stackLabel":true,"stackAlignment":"dynamic","removeDuplicates":"all","removeDuplicatesDistance":0,"stackRowLength":24,"stackSeparators":[{"separator":" "}],"useCodedValues":true,"maxScale":0,"minScale":24000,"name":"Street Name - Arcade","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":[255,255,255,255],"haloSize":1,"font":{"family":"Arial Narrow","size":9,"style":"normal","weight":"normal","decoration":"none"}}}]}
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: true
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field: GlobalID
Type ID Field: FUNCTIONCODE
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- MAINPREDIR (type: esriFieldTypeString, alias: Name (Main) Pre-Dir, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- MAINPRETYPE (type: esriFieldTypeString, alias: Name (Main) Pre-Type, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- MAINNAME (type: esriFieldTypeString, alias: Name (Main) Name, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
- MAINSUFDIR (type: esriFieldTypeString, alias: Name (Main) Suff-Dir, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- MAINSUFTYPE (type: esriFieldTypeString, alias: Name (Main) Suff-Type, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- MAINFULNAME (type: esriFieldTypeString, alias: Name (Main) Full Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- ALS1PREDIR (type: esriFieldTypeString, alias: Name (Alias #1) Pre-Dir, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- ALS1PRETYPE (type: esriFieldTypeString, alias: Name (Alias #1) Pre-Type, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- ALS1NAME (type: esriFieldTypeString, alias: Name (Alias #1) Name, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
- ALS1SUFDIR (type: esriFieldTypeString, alias: Name (Alias #1) Suff-Dir, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- ALS1SUFTYPE (type: esriFieldTypeString, alias: Name (Alias #1) Suff-Type, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- ALS1FULNAME (type: esriFieldTypeString, alias: Name (Alias #1) Full Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- ALS2PREDIR (type: esriFieldTypeString, alias: Name (Alias #2) Pre-Dir, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- ALS2PRETYPE (type: esriFieldTypeString, alias: Name (Alias #2) Pre-Type, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- ALS2NAME (type: esriFieldTypeString, alias: Name (Alias #2) Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- ALS2SUFDIR (type: esriFieldTypeString, alias: Name (Alias #2) Suff-Dir, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- ALS2SUFTYPE (type: esriFieldTypeString, alias: Name (Alias #2) Suff-Type, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- ALS2FULNAME (type: esriFieldTypeString, alias: Name (Alias #2) Full Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- ALS3PREDIR (type: esriFieldTypeString, alias: Name (Alias #3) Pre-Dir, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- ALS3PRETYPE (type: esriFieldTypeString, alias: Name (Alias #3) Pre-Type, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- ALS3NAME (type: esriFieldTypeString, alias: Name (Alias #3) Name, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
- ALS3SUFDIR (type: esriFieldTypeString, alias: Name (Alias #3) Suff-Dir, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- ALS3SUFTYPE (type: esriFieldTypeString, alias: Name (Alias #3) Suff-Type, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- ALS3FULNAME (type: esriFieldTypeString, alias: Name (Alias #3) Full Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- OWNERSHIP (type: esriFieldTypeString, alias: Ownership, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
- MAINTAINEDBY (type: esriFieldTypeString, alias: Maintained By, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
- FIPSCODE (type: esriFieldTypeString, alias: FIPS Code, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- NUMBLANES (type: esriFieldTypeSmallInteger, alias: Number of Lanes, SQL Type: sqlTypeOther, nullable: true, editable: true)
- FUNCTIONCODE (type: esriFieldTypeString, alias: Street Function, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- SURFACE (type: esriFieldTypeString, alias: Surface, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- SURFACETYPE (type: esriFieldTypeString, alias: Surface Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- ONEWAY (type: esriFieldTypeSmallInteger, alias: One Way, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ONEWAYDIR (type: esriFieldTypeString, alias: One Way Direction, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- PAVSEGID (type: esriFieldTypeString, alias: Pavement Segment ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- STATUS (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- COMMENTS (type: esriFieldTypeString, alias: GIS Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- NOTES (type: esriFieldTypeString, alias: Road Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- ADDRNG_L_F (type: esriFieldTypeInteger, alias: Address Range: Left From, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ADDRNG_L_T (type: esriFieldTypeInteger, alias: Address Range: Left To, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ADDRNG_R_F (type: esriFieldTypeInteger, alias: Address Range: Right From, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ADDRNG_R_T (type: esriFieldTypeInteger, alias: Address Range: Right To, SQL Type: sqlTypeOther, nullable: true, editable: true)
- CITY_L (type: esriFieldTypeString, alias: City: Left, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- CITY_R (type: esriFieldTypeString, alias: City: Right, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- COUNTY_L (type: esriFieldTypeString, alias: County: Left, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- COUNTY_R (type: esriFieldTypeString, alias: County: Right, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- STATE_L (type: esriFieldTypeString, alias: State: Left, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- STATE_R (type: esriFieldTypeString, alias: State: Right, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- ZIP_L (type: esriFieldTypeString, alias: ZIP Code: Left, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- ZIP_R (type: esriFieldTypeString, alias: ZIP Code: Right, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- COUNTRYCODE (type: esriFieldTypeString, alias: Country Code, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- BLOCKID_L (type: esriFieldTypeString, alias: Block ID: Left, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- BLOCKID_R (type: esriFieldTypeString, alias: Block ID: Right, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- CREATED_DATE (type: esriFieldTypeDate, alias: Creation Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- LAST_UPDATED (type: esriFieldTypeDate, alias: Last Update Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- LAST_EDITOR (type: esriFieldTypeString, alias: Last Editor, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
- GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
- Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)
Types:
ID: INTERSTATE
Name: Interstate
Domains:
Templates:
Name: INTERSTATE
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- FUNCTIONCODE: INTERSTATE
- ONEWAY: 0
ID: STATE
Name: State Route
Domains:
Templates:
Name: STATE
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- FUNCTIONCODE: STATE
- ONEWAY: 0
ID: STATE / LOCAL
Name: State Route
Domains:
Templates:
Name: STATE / LOCAL
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- FUNCTIONCODE: STATE / LOCAL
- ONEWAY: 0
ID:
Name: Local Route
Domains:
Templates:
Name: <Null>
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
ID: CITY LOCAL
Name: Local Route
Domains:
Templates:
Name: CITY LOCAL
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- FUNCTIONCODE: CITY LOCAL
- ONEWAY: 0
ID: COUNTY LOCAL
Name: Local Route
Domains:
Templates:
Name: COUNTY LOCAL
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- FUNCTIONCODE: COUNTY LOCAL
- ONEWAY: 0
ID: LOCAL
Name: Local Route
Domains:
Templates:
Name: LOCAL
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- FUNCTIONCODE: LOCAL
- ONEWAY: 0
ID: STATE FRONTAGE
Name: Local Route
Domains:
Templates:
Name: STATE FRONTAGE
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- FUNCTIONCODE: STATE FRONTAGE
- ONEWAY: 0
ID: STATE FRONTAGE / LOCAL
Name: Local Route
Domains:
Templates:
Name: STATE FRONTAGE / LOCAL
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- FUNCTIONCODE: STATE FRONTAGE / LOCAL
- ONEWAY: 0
ID: INTERSTATE RAMP
Name: On / Off Ramp
Domains:
Templates:
Name: INTERSTATE RAMP
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- FUNCTIONCODE: INTERSTATE RAMP
- ONEWAY: 0
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 9/6/2023 10:17:43 PM
Schema Last Edit Date: 9/6/2023 10:17:43 PM
Data Last Edit Date: 9/6/2023 10:17:43 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat