Name: EGISPUB.GIS.SignRequest

Display Field: FirstName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 2220765.23304842
YMin: 1345299.24867799
XMax: 3253397.27213233
YMax: 1501770.2800483
Spatial Reference: 102667 (2240)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"c986616258cbaecc6e8cf9c723109189","imageData":"iVBORw0KGgoAAAANSUhEUgAAABQAAAAUCAYAAACNiR0NAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAhRJREFUOI2t1F9I01EUwPHv1tyvsaT46YhIqPVHWSuaZY6kNBizlkTQS+QQsqShCEqIEf17kojAXkpYrJfqIaKgPfQkJOWD9OdBSElDIqMotO6inD/vaquH3NivtuVW5/Eezueec+EeE/85TDlyBkVRvHsd0rPRTqmlCPMXjdlHz3g/JtV7QojhBYOqqrrb68Tpxjq5tnwFDkNaLu4n9uSl8N0c5EVfP2eBNznBBheHO3yi0+tic6bLFhkwb6+gurqcKmcZ9jNhtVsI8Tgj6FqneLr2y65dG3Bmf4kUbGzbQ63JGO0NXONQstN00Ny8Q55bCJYeR72y5vVHLp4Pc1AH+mto9e9kSz7YfKcccLMtOKi6hBDDKdC9nvqSJVjzBQEq12Bv3BptvtxPRwpcvpSyQrBkl46V0g5pIy82U1woCGCdr0+BiQSJfwHjENeBUalEQBaE/QAiUSI6cOqzHNFiVFnM+YOT0yQiM9zRgW9nOPFglH0NlZTkCw6MKhM9YXlbB/aGmaqwKdcnp2XnKhuG7OX6GBpnTn6T3fyaXP/1AiF5PNSC0+OifrXt79jTCWJj75RLrSEZTp79sRxaQuy+0UZwfBlNtQ4smd5URGHgOUKT6skjQXE1PZdxfTX1Ebh/igt3h7hSbGWTtYhSoxHz9zizX+f4oMV4qH2i/dgtof1em3XBNvTwCvDlnDlD5NrYBcVPsbmlZv6GxOcAAAAASUVORK5CYII=","contentType":"image/png","width":15,"height":15,"angle":0,"xoffset":0,"yoffset":0},"label":"","description":""},"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• TYPEREQ (type: esriFieldTypeString, alias: Type of Sign Request, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true, Coded Values: [Regulatory Sign: Regulatory Sign (i.e. Stop, Speed Limit,etc)], [Warning Sign: Warning Sign (i.e. Yield Ahead, Right Turn,etc)], [School Zone Sign: School Zone Sign (i.e. School Speed Limit, etc)], ... 2 more ...)
• REGsign (type: esriFieldTypeString, alias: REGsign, SQL Type: sqlTypeOther, length: 300, nullable: true, editable: true, Coded Values: [Stop: Stop], [All Way: All Way], [Yield: Yield], ... 22 more ...)
• WARNsign (type: esriFieldTypeString, alias: WARNsign, SQL Type: sqlTypeOther, length: 300, nullable: true, editable: true, Coded Values: [Stop Ahead: Stop Ahead], [Yield Ahead: Yield Ahead], [Signal Ahead: Signal Ahead], ... 44 more ...)
• SCHLsign (type: esriFieldTypeString, alias: SCHLsign, SQL Type: sqlTypeOther, length: 300, nullable: true, editable: true, Coded Values: [Adv School: Adv School], [School Crossing: School Crossing], [School Speed Limit: School Speed Limit], ... 3 more ...)
• SIGNpost (type: esriFieldTypeString, alias: SIGNpost, SQL Type: sqlTypeOther, length: 300, nullable: true, editable: true, Coded Values: [Sign Post 12 FT: Sign Post 12 FT], [Sign Post 11 FT: Sign Post 11 FT], [Sign Post 10 FT: Sign Post 10 FT], ... 1 more ...)
• SPECsign (type: esriFieldTypeString, alias: SPECsign, SQL Type: sqlTypeOther, length: 300, nullable: true, editable: true)
• Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ReqStatus (type: esriFieldTypeString, alias: Sign Request Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [A: Approved], [D: Denied], [P: Pending])
• Verified (type: esriFieldTypeString, alias: Verified, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [A: Approved], [D: Denied], [P: Pending])
• RequDate (type: esriFieldTypeDate, alias: Requested Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• FirstName (type: esriFieldTypeString, alias: First Name, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• LastName (type: esriFieldTypeString, alias: LastName, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• CustComments (type: esriFieldTypeString, alias: CustComments, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• StNumber (type: esriFieldTypeString, alias: Street Number, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• StName (type: esriFieldTypeString, alias: Street Name, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• PreDir (type: esriFieldTypeString, alias: Pre Directional, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [N: N], [S: S], [E: E], ... 5 more ...)
• StType (type: esriFieldTypeString, alias: Street Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [INTERSTATE: INTERSTATE], [STATE HIGHWAY: STATE HIGHWAY], [COUNTY ROAD: COUNTY ROAD], ... 6 more ...)
• PostDir (type: esriFieldTypeString, alias: Post Directional, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [N: N], [S: S], [E: E], ... 5 more ...)
• UnitType (type: esriFieldTypeString, alias: Unit Type, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true, Coded Values: [APT: APARTMENT], [BSMT: BASEMENT], [BLDG: BUILDING], ... 23 more ...)
• PostCity (type: esriFieldTypeString, alias: Postal City, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true, Coded Values: [PINE LAKE: PINE LAKE], [STONE MOUNTAIN: STONE MOUNTAIN], [DORAVILLE: DORAVILLE], ... 21 more ...)
• State (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• ZipCode (type: esriFieldTypeString, alias: Zip Code, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [30002: 30002], [30012: 30012], [30021: 30021], ... 34 more ...)
• DateReceived (type: esriFieldTypeDate, alias: Date Received, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• IssueBy (type: esriFieldTypeString, alias: IssueBy, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• LandDist (type: esriFieldTypeString, alias: Land District, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [6: 6], [11: 11], [12: 12], ... 3 more ...)
• LandLot (type: esriFieldTypeString, alias: Land Lot, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• Location (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• InqNum (type: esriFieldTypeString, alias: INQ Number, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• WorkPerformed (type: esriFieldTypeString, alias: Type Work Performed, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Installation: Installation], [Repaired: Repaired], [Replaced: Replaced], ... 4 more ...)
• CompBy (type: esriFieldTypeString, alias: Completed By, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [DFCHAMBLISS: Demetria Chambliss-Allen], [MALLEN: Monica Allen], [DLOWENS: Doronda Owens], ... 2 more ...)
• DateComp (type: esriFieldTypeDate, alias: DateComp, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• TimeArrived (type: esriFieldTypeString, alias: Time Arrived, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• TimeDeparted (type: esriFieldTypeString, alias: Time Departed, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Dispatched (type: esriFieldTypeString, alias: Dispatched, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• CustPhoneNum (type: esriFieldTypeString, alias: Customer Phone Number, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• CustEmail (type: esriFieldTypeString, alias: CustEmail, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• CustSignCondition (type: esriFieldTypeString, alias: CustSignCondition, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [M: Missing], [R: Needs Repair], [D: Destoyed])
• TEVerifiedSignCondition (type: esriFieldTypeString, alias: TEVerifiedSignCondition, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [M: Missing], [R: Needs Repair], [D: Destoyed])
• CountyService (type: esriFieldTypeString, alias: CountyService, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Y: YES], [N: NO])
• Municipality (type: esriFieldTypeString, alias: Municipality, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Atlanta: Atlanta], [Avondale Estates: Avondale Estates], [Brookhaven: Brookhaven], ... 11 more ...)
• BOCDistrict (type: esriFieldTypeString, alias: BOCDist, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [3: 3], ... 2 more ...)
• BOCSuperDistrict (type: esriFieldTypeString, alias: BOCSuperDistrict, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [6: 6], [7: 7])

Templates:

Name: EGISPUB.GIS.SignRequest
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• Verified: P
• State: GA
• Dispatched: No
• CustSignCondition: R
• TEVerifiedSignCondition: R

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/8/2019 9:33:40 PM

Schema Last Edit Date: 2/8/2019 9:33:40 PM

Data Last Edit Date: 2/8/2019 9:33:40 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Attachments   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat