Name: Sidewalk Panel Points

Display Field: ReportName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 4ed26713a32e4fd09e0a3c78819f9c52

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 5000.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: true

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 1855670.0624261722
YMin: 725507.837402679
XMax: 1881575.3055630885
YMax: 749190.3202213421
Spatial Reference: 102723  (3735)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: RemedStatus
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 0
  Label: No Violation
  Description: No Violation
  Symbol:
  
• Value: 1
  Label: To Be Remediated
  Description: To Be Remediated
  Symbol:
  
• Value: 20
  Label: Planned
  Description: Planned
  Symbol:
  
• Value: 30
  Label: Designed
  Description: Designed
  Symbol:
  
• Value: 31
  Label: Inspection - Pass
  Description: Inspection - Pass
  Symbol:
  
• Value: 40
  Label: Inspection - Fail
  Description: Inspection - Fail
  Symbol:
  
• Value: 70
  Label: Reported
  Description: Reported
  Symbol:
  
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: N/A
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 10
Font Family: Tahoma
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 300.0
Max. Scale: 0.0

Feature Draw Order:

N/A

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:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• cFacilityID ( type: esriFieldTypeString, alias: Facility ID, length: 50 )
• cLegacyID ( type: esriFieldTypeString, alias: Legacy ID, length: 50 )
• Address ( type: esriFieldTypeString, alias: Location, length: 130 )
• Location ( type: esriFieldTypeString, alias: Location Details, length: 256 )
• installdate ( type: esriFieldTypeDate, alias: Install Date, length: 8 )
• WarrantyDate ( type: esriFieldTypeDate, alias: Warranty Date, length: 8 )
• cWarranty ( type: esriFieldTypeString, alias: Warranty Information, length: 256 )
• cWarrantyResponsible ( type: esriFieldTypeString, alias: Warranty Responsible, length: 20 )
• cAssetCost ( type: esriFieldTypeDouble, alias: Asset Cost )
• cStatus ( type: esriFieldTypeString, alias: Lifecycle Status, length: 10 , Coded Values: [OOSERV: Out of Service] , [DISPOSE: Disposed/Removed] , [PLANNED: Planned/On Order] , ...3 more... )
• cCondition ( type: esriFieldTypeSmallInteger, alias: Condition , Coded Values: [1: Excellent] , [2: Good] , [3: Fair] , ...1 more... )
• cConditionDate ( type: esriFieldTypeDate, alias: Condition Date, length: 8 )
• cLifeExpectancy ( type: esriFieldTypeSmallInteger, alias: Life Expectancy in Yrs. )
• cCOF ( type: esriFieldTypeSmallInteger, alias: Consequence of Failure )
• cPOF ( type: esriFieldTypeSmallInteger, alias: Probability of Failure )
• cBRE ( type: esriFieldTypeSmallInteger, alias: Business Risk of Failure )
• cHazard ( type: esriFieldTypeString, alias: Hazard?, length: 3 )
• cComments ( type: esriFieldTypeString, alias: Comments, length: 255 )
• ReportLink ( type: esriFieldTypeString, alias: ReportLink, length: 250 )
• PARCELID ( type: esriFieldTypeString, alias: Parcel Id, length: 10 )
• SITEADDRESS ( type: esriFieldTypeString, alias: Site Address, length: 70 )
• ReportName ( type: esriFieldTypeString, alias: ReportName, length: 100 )
• ParcelPanelNumber ( type: esriFieldTypeInteger, alias: ParcelPanelNumber )
• PanelID ( type: esriFieldTypeString, alias: PanelID, length: 255 )
• PanelLen ( type: esriFieldTypeDouble, alias: PanelLength (LF) )
• PanelWid ( type: esriFieldTypeDouble, alias: PanelWidth (LF) )
• PanelArea ( type: esriFieldTypeDouble, alias: PanelArea (SF) )
• PanelType ( type: esriFieldTypeString, alias: Panel Type, length: 10 , Coded Values: [SW: Sidewalk] , [CDW: Commercial Driveway] , [RDW: Residential Driveway] )
• Responsibility ( type: esriFieldTypeString, alias: Responsibility, length: 50 , Coded Values: [N/A: N/A] , [City: City] , [Owner: Owner] )
• Defect ( type: esriFieldTypeString, alias: Defect, length: 20 )
• ConcreteReplace4in ( type: esriFieldTypeDouble, alias: 4in Concrete Replacement (SF) )
• ConcreteReplace6in ( type: esriFieldTypeDouble, alias: 6in Concrete Replacement (SF) )
• ConcreteReplace8in ( type: esriFieldTypeDouble, alias: 8in Concrete Replacement (SF) )
• Grinding ( type: esriFieldTypeDouble, alias: Grinding(LF) )
• PatchAsphalt ( type: esriFieldTypeDouble, alias: Patch Asphalt (SF) )
• PatchConcrete ( type: esriFieldTypeDouble, alias: Patch Concrete (SF) )
• Vegetation ( type: esriFieldTypeDouble, alias: Vegetation (LF) )
• ADARampCount ( type: esriFieldTypeDouble, alias: ADA Ramp (ea) )
• ADARampCost ( type: esriFieldTypeDouble, alias: ADA Ramp Cost )
• RootPruning ( type: esriFieldTypeDouble, alias: Root Pruning (Panel) )
• ObstructionCount ( type: esriFieldTypeDouble, alias: Obstructions (ea) )
• ObstructionCost ( type: esriFieldTypeDouble, alias: Obstruction Cost )
• RemedID ( type: esriFieldTypeString, alias: Remediation ID, length: 100 )
• RemedStatus ( type: esriFieldTypeInteger, alias: Remediation Status , Coded Values: [0: No Violation] , [1: To Be Remediated] , [20: Planned] , ...5 more... )
• Inspector ( type: esriFieldTypeInteger, alias: Inspector , Coded Values: [0: Tom Komlac] , [1: Brian Kennedy] , [2: Paige Wright] , ...5 more... )
• InspectionDate ( type: esriFieldTypeDate, alias: Inspection Date, length: 8 )
• Editor ( type: esriFieldTypeInteger, alias: Editor )
• EditDate ( type: esriFieldTypeDate, alias: Edit Date, length: 8 )
• Status ( type: esriFieldTypeString, alias: Status, length: 255 , Coded Values: [DEL: Delete] , [COL: Collected] , [GAH Rev: Gahanna Reviewed] , ...6 more... )
• 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 )
• Defect1 ( type: esriFieldTypeString, alias: Defect 1, length: 255 , Coded Values: [A: Excessive Cracking] , [B: Concrete Spalling] , [C: Gaps] , ...4 more... )
• Defect2 ( type: esriFieldTypeString, alias: Defect 2, length: 255 , Coded Values: [A: Excessive Cracking] , [B: Concrete Spalling] , [C: Gaps] , ...4 more... )
• Defect3 ( type: esriFieldTypeString, alias: Defect 3, length: 255 , Coded Values: [A: Excessive Cracking] , [B: Concrete Spalling] , [C: Gaps] , ...4 more... )
• ProYR ( type: esriFieldTypeString, alias: ProYR, length: 25 , Coded Values: [2021 Sidewalk: 2021 Sidewalk] , [2022 Sidewalk: 2022 Sidewalk] , [2023 PD: 2023 PD] , ...21 more... )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• Landuse ( type: esriFieldTypeString, alias: Landuse, length: 255 , Coded Values: [RES: Residential] , [COM: Commercial] )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• ApplyCityResponsibility ( type: esriFieldTypeString, alias: Apply City Resposibility, length: 255 , Coded Values: [Yes: Yes] , [No: No] )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata