Name: Converted With Issue
Display Field: PERSONNAME
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description:
Copyright Text:
Default Visibility: true
MaxRecordCount: 5000
Supported Query Formats: JSON, geoJSON, PBF
Min Scale: 3177506.883573972
Max Scale: 0
Supports Advanced Queries: true
Supports Statistics: true
Has Labels: false
Can Modify Layer: true
Can Scale Symbols: false
Use Standardized Queries: true
Supports Datum Transformation: true
Extent:
XMin: -124.35314617306283
YMin: 32.74825333300004
XMax: -117.12857666699995
YMax: 41.36410899128224
Spatial Reference: 4326
(4326)
Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments: true
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Type ID Field: null
Fields:
-
OP_SCHED
(
type: esriFieldTypeDouble, alias: OP_SCHED
)
-
Latitude
(
type: esriFieldTypeDouble, alias: Latitude
)
-
Longitude
(
type: esriFieldTypeDouble, alias: Longitude
)
-
GlobalID
(
type: esriFieldTypeGlobalID, alias: GlobalID, length: 38
)
-
POINT_X
(
type: esriFieldTypeDouble, alias: POINT_X
)
-
POINT_Y
(
type: esriFieldTypeDouble, alias: POINT_Y
)
-
created_user
(
type: esriFieldTypeString, alias: created_user, length: 255
)
-
created_date
(
type: esriFieldTypeDate, alias: created_date, length: 8
)
-
last_edited_user
(
type: esriFieldTypeString, alias: last_edited_user, length: 255
)
-
last_edited_date
(
type: esriFieldTypeDate, alias: last_edited_date, length: 8
)
-
DecorativeFixType
(
type: esriFieldTypeString, alias: Decorative Fixture Type, length: 50
, Coded Values:
[GRAN: Gran]
, [CONT: Cont]
, [MEMP: Memp]
, ...4 more...
)
-
DecoFixWattage
(
type: esriFieldTypeInteger, alias: Deco Fixture Wattage
, Range: [0, 400]
)
-
Evari_Number_Audit
(
type: esriFieldTypeDouble, alias: Evari_Number_Audit
)
-
Evari_Number
(
type: esriFieldTypeDouble, alias: Evari_Number
)
-
OBJECTID
(
type: esriFieldTypeInteger, alias: OBJECTID
)
-
OFFICE
(
type: esriFieldTypeString, alias: OFFICE, length: 8
)
-
PERSONNAME
(
type: esriFieldTypeString, alias: PERSONNAME, length: 50
)
-
ACCTNUM
(
type: esriFieldTypeString, alias: ACCTNUM, length: 10
)
-
BADGENUM
(
type: esriFieldTypeString, alias: BADGENUM, length: 30
)
-
FX_CODE
(
type: esriFieldTypeString, alias: FX_CODE, length: 30
, Coded Values:
[0: Painted pole]
, [1: 1st light on multi-light pole]
, [2: 2nd light on multi-light pole]
, ...7 more...
)
-
STATUS
(
type: esriFieldTypeString, alias: STATUS, length: 2
, Coded Values:
[A: Active]
, [O: Ordered]
, [R: Retired]
)
-
STATUSFLAG
(
type: esriFieldTypeString, alias: STATUSFLAG, length: 6
)
-
REC_DATE
(
type: esriFieldTypeDate, alias: REC_DATE, length: 8
)
-
RET_DATE
(
type: esriFieldTypeDate, alias: RET_DATE, length: 8
)
-
INS_DATE
(
type: esriFieldTypeDate, alias: INS_DATE, length: 8
)
-
REM_DATE
(
type: esriFieldTypeDate, alias: REM_DATE, length: 8
)
-
COP_DATE
(
type: esriFieldTypeDate, alias: COP_DATE, length: 8
)
-
DESC_ADDR
(
type: esriFieldTypeString, alias: DESC_ADDR, length: 80
)
-
MAPNUMBER
(
type: esriFieldTypeString, alias: MAPNUMBER, length: 50
)
-
RATE_SCHED
(
type: esriFieldTypeString, alias: RATE_SCHED, length: 8
, Coded Values:
[LS1-A: LS1-A]
, [LS1-C: LS1-C]
, [LS1-E: LS1-E]
, ...8 more...
)
-
ITEM_CODE
(
type: esriFieldTypeString, alias: ITEM_CODE, length: 30
, Coded Values:
[S4H-50: 240V-High Pressure - 50W 3800L]
, [S4H-70: 240V-High Pressure - 70W 5800L]
, [S4H-100: 240V-High Pressure -100W 9500L]
, ...368 more...
)
-
SERVICE
(
type: esriFieldTypeString, alias: SERVICE, length: 16
, Coded Values:
[N: Overhead]
, [Y: Underground]
)
-
FX_MAN
(
type: esriFieldTypeString, alias: FX_MAN, length: 30
, Coded Values:
[UK: Unknown]
, [GE: General Electric]
, [HP: Holophane]
, ...7 more...
)
-
POLE_TYPE
(
type: esriFieldTypeString, alias: POLE_TYPE, length: 30
, Coded Values:
[CENTER BORE WOOD: Center Bore Wood Pole]
, [STANDARD WOOD: Standard Wood Pole]
, [STEEL: Steel Pole]
, ...8 more...
)
-
POLE_LGTH
(
type: esriFieldTypeString, alias: POLE_LGTH, length: 30
, Coded Values:
[16-19 FT: 16-19 FT]
, [25-29 FT: 25-29 FT]
, [40 FT: 40 FT]
, ...7 more...
)
-
SUSPENSION
(
type: esriFieldTypeString, alias: SUSPENSION, length: 30
, Coded Values:
[POST TOP: Post Top]
, [30 INCHES: 30 In Bracket or Arm]
, [6 FT: 6 Ft Bracket or Arm]
, ...7 more...
)
-
POLE_USE
(
type: esriFieldTypeString, alias: POLE_USE, length: 30
, Coded Values:
[CUST OWNED: Customer Owned]
, [DISTRIBUTION: Distribution]
, [NONE: None]
, ...2 more...
)
-
SP_ID
(
type: esriFieldTypeString, alias: SP_ID, length: 10
)
-
SA_ID
(
type: esriFieldTypeString, alias: SA_ID, length: 10
)
-
PREM_ID
(
type: esriFieldTypeString, alias: PREM_ID, length: 10
)
-
TOT_CODE
(
type: esriFieldTypeString, alias: TOT_CODE, length: 16
)
-
TOT_TERR
(
type: esriFieldTypeString, alias: TOT_TERR, length: 30
)
-
INV_DATE
(
type: esriFieldTypeDate, alias: INV_DATE, length: 8
)
-
INV_BY
(
type: esriFieldTypeString, alias: INV_BY, length: 30
)
-
SPITEMHIST
(
type: esriFieldTypeString, alias: SPITEMHIST, length: 10
)
-
UNIQUESPID
(
type: esriFieldTypeString, alias: UNIQUESPID, length: 50
)
-
GIS_ID
(
type: esriFieldTypeString, alias: GIS_ID, length: 12
)
-
BLCH_DATE
(
type: esriFieldTypeDate, alias: BLCH_DATE, length: 8
)
-
LMCH_DATE
(
type: esriFieldTypeDate, alias: LMCH_DATE, length: 8
)
-
LINESHARE
(
type: esriFieldTypeString, alias: LINESHARE, length: 16
)
-
LITE_SIZE
(
type: esriFieldTypeString, alias: LITE_SIZE, length: 16
)
-
LITE_TYPE
(
type: esriFieldTypeString, alias: LITE_TYPE, length: 16
)
-
LUCH_DATE
(
type: esriFieldTypeDate, alias: LUCH_DATE, length: 8
)
-
PCCH_DATE
(
type: esriFieldTypeDate, alias: PCCH_DATE, length: 8
)
-
PCELL
(
type: esriFieldTypeString, alias: PCELL, length: 16
)
-
POCH_DATE
(
type: esriFieldTypeDate, alias: POCH_DATE, length: 8
)
-
PTCH_DATE
(
type: esriFieldTypeDate, alias: PTCH_DATE, length: 8
)
-
STRT_CH_DT
(
type: esriFieldTypeDate, alias: STRT_CH_DT, length: 8
)
-
LITESIZE
(
type: esriFieldTypeString, alias: LITESIZE, length: 16
)
-
LITETYPE
(
type: esriFieldTypeString, alias: LITETYPE, length: 16
)
-
HALFHRADJ
(
type: esriFieldTypeString, alias: HALFHRADJ, length: 16
)
-
MAIL_ADDR1
(
type: esriFieldTypeString, alias: MAIL_ADDR1, length: 80
)
-
MAIL_ADDR2
(
type: esriFieldTypeString, alias: MAIL_ADDR2, length: 80
)
-
MAIL_CITY
(
type: esriFieldTypeString, alias: MAIL_CITY, length: 50
)
-
MAILSTATE
(
type: esriFieldTypeString, alias: MAILSTATE, length: 2
)
-
MAIL_ZIP
(
type: esriFieldTypeString, alias: MAIL_ZIP, length: 5
)
-
NEWBADGE
(
type: esriFieldTypeString, alias: NEWBADGE, length: 30
)
-
FMETRICOM
(
type: esriFieldTypeString, alias: FMETRICOM, length: 30
, Coded Values:
[G1: G1]
, [G1D: G1D]
, [G2: G2]
, ...1 more...
)
-
FREVENUE
(
type: esriFieldTypeString, alias: FREVENUE, length: 30
, Coded Values:
[SUSPECTED DIVERSION: SUSPECTED DIVERSION]
)
-
FAR1
(
type: esriFieldTypeString, alias: FAR1, length: 30
, Coded Values:
[Corrected Badge Number: Corrected Badge Number]
, [Loose arm: Loose arm]
, [Pole Loose: Pole Loose]
, ...24 more...
)
-
FAR2
(
type: esriFieldTypeString, alias: FAR2, length: 30
, Coded Values:
[DAY BURNER: DAY BURNER]
, [CYCLING LIGHT: CYCLING LIGHT]
, [FOUNDATION ONLY: FOUNDATION ONLY]
, ...17 more...
)
-
FAR3
(
type: esriFieldTypeString, alias: FAR3, length: 30
, Coded Values:
[DAY BURNER: DAY BURNER]
, [CYCLING LIGHT: CYCLING LIGHT]
, [FOUNDATION ONLY: FOUNDATION ONLY]
, ...17 more...
)
-
FAROTHER
(
type: esriFieldTypeString, alias: FAROTHER, length: 30
)
-
MAINTNOTE
(
type: esriFieldTypeString, alias: MAINTNOTE, length: 30
)
-
FAPPL1
(
type: esriFieldTypeString, alias: FAPPL1, length: 50
, Coded Values:
[BUS SHELTER: BUS SHELTER]
, [CAMERA: CAMERA]
, [IRRIGATION: IRRIGATION]
, ...8 more...
)
-
FAPPL2
(
type: esriFieldTypeString, alias: FAPPL2, length: 50
, Coded Values:
[BUS SHELTER: BUS SHELTER]
, [CAMERA: CAMERA]
, [IRRIGATION: IRRIGATION]
, ...8 more...
)
-
FAPPL3
(
type: esriFieldTypeString, alias: FAPPL3, length: 50
, Coded Values:
[BUS SHELTER: BUS SHELTER]
, [CAMERA: CAMERA]
, [IRRIGATION: IRRIGATION]
, ...8 more...
)
-
FAPPL4
(
type: esriFieldTypeString, alias: FAPPL4, length: 50
, Coded Values:
[BUS SHELTER: BUS SHELTER]
, [CAMERA: CAMERA]
, [IRRIGATION: IRRIGATION]
, ...8 more...
)
-
FAPPL5
(
type: esriFieldTypeString, alias: FAPPL5, length: 50
, Coded Values:
[BUS SHELTER: BUS SHELTER]
, [CAMERA: CAMERA]
, [IRRIGATION: IRRIGATION]
, ...8 more...
)
-
METERED
(
type: esriFieldTypeString, alias: METERED, length: 2
, Coded Values:
[Y: Y]
)
-
PAINTPOLE
(
type: esriFieldTypeString, alias: PAINTPOLE, length: 2
, Coded Values:
[Y: Y]
, [N: N]
)
-
TRNSACTION
(
type: esriFieldTypeString, alias: TRNSACTION, length: 50
, Coded Values:
[1: Add]
, [2: Delete]
, [3: Change]
, ...7 more...
)
-
FAR4
(
type: esriFieldTypeString, alias: FAR4, length: 30
, Coded Values:
[DAY BURNER: DAY BURNER]
, [CYCLING LIGHT: CYCLING LIGHT]
, [FOUNDATION ONLY: FOUNDATION ONLY]
, ...17 more...
)
-
FAR5
(
type: esriFieldTypeString, alias: FAR5, length: 30
, Coded Values:
[DAY BURNER: DAY BURNER]
, [CYCLING LIGHT: CYCLING LIGHT]
, [FOUNDATION ONLY: FOUNDATION ONLY]
, ...17 more...
)
-
InstallStatus
(
type: esriFieldTypeString, alias: InstallStatus, length: 50
, Coded Values:
[ToBeConverted: To Be Converted]
, [Converted: Converted]
, [ConvertedInstallerIssue: Converted Installer Issue]
, ...70 more...
)
-
NewItemCode
(
type: esriFieldTypeString, alias: NewItemCode, length: 50
, Coded Values:
[S-LC-29: 29 Watt LED]
, [S-LC-34: 34 Watt LED]
, [S-LC-56: 56 Watt LED]
, ...71 more...
)
-
InstalledCCT
(
type: esriFieldTypeString, alias: InstalledCCT, length: 10
, Coded Values:
[3000K: 3000K]
, [4000K: 4000K]
, [2700K: 2700K]
)
-
InstallerInitials
(
type: esriFieldTypeString, alias: InstallerInitials, length: 10
)
-
InstallDate
(
type: esriFieldTypeDate, alias: InstallDate, length: 8
)
-
CityOutReachNotes
(
type: esriFieldTypeString, alias: CityOutReachNotes, length: 250
)
-
BadAddress
(
type: esriFieldTypeString, alias: BadAddress, length: 2
, Coded Values:
[Y: Y]
)
-
InstallerNotes
(
type: esriFieldTypeString, alias: InstallerNotes, length: 250
)
-
StatusHistory
(
type: esriFieldTypeString, alias: StatusHistory, length: 250
)
-
StatusYesterday
(
type: esriFieldTypeString, alias: StatusYesterday, length: 50
)
-
LinkToGoogleMaps
(
type: esriFieldTypeString, alias: LinkToGoogleMaps, length: 250
)
-
OBJECTID_1
(
type: esriFieldTypeOID, alias: OBJECTID_1
)
-
InstallDatePacific
(
type: esriFieldTypeDate, alias: InstallDatePacific, length: 8
)
-
Shape
(
type: esriFieldTypeGeometry, alias: Shape
)
-
Lighting_DIstrict
(
type: esriFieldTypeSmallInteger, alias: Lighting_DIstrict
)
-
New_Badge_To_Install
(
type: esriFieldTypeString, alias: New_Badge_To_Install, length: 50
)
-
Phone_Call
(
type: esriFieldTypeString, alias: Phone_Call, length: 50
, Coded Values:
[Yes: Yes]
, [No: No]
, [Ok to proceed: Ok to proceed]
, ...2 more...
)
-
Fixture_Color
(
type: esriFieldTypeString, alias: Fixture_Color, length: 50
)
-
Light_Pattern
(
type: esriFieldTypeString, alias: Light_Pattern, length: 50
)
Supported Operations:
Query
Query Attachments
Query Analytic
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata