Parent Layer: Sewer Abandoned Assets

Name: Abandoned Points

Display Field: NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This dataset contains a collection of features that represent the separated and combined sewer features in a community.

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 5000

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: 2021973.3741199672
YMin: 706159.6000119746
XMax: 2078865.5999022275
YMax: 780600.2683875561
Spatial Reference: 102719  (2264)

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: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, length: 8 )
• DIAMETER ( type: esriFieldTypeDouble, alias: Diameter , Coded Values: [0: Unknown] , [0.75: 3/4"] , [1: 1"] , ...27 more... )
• FACILITYID ( type: esriFieldTypeString, alias: Facility Identifier, length: 20 )
• Shape ( type: esriFieldTypeGeometry, alias: SHAPE )
• NOTES ( type: esriFieldTypeString, alias: NOTES, length: 255 )
• CREATED_USER ( type: esriFieldTypeString, alias: created_user, length: 75 )
• CREATED_DATE ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: last_edited_user, length: 75 )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• ABANDPTTYPE ( type: esriFieldTypeString, alias: Abandoned Point Type, length: 50 , Coded Values: [CLEANOUT: Sewer Cleanout] , [CTRLVAL: Sewer Control Valve] , [FIT: Sewer Fitting] , ...6 more... )
• ABANDDATE ( type: esriFieldTypeDate, alias: Abandoned Date, length: 8 )
• ABANDMETHOD ( type: esriFieldTypeString, alias: Abandoned Method, length: 50 , Coded Values: [CAP: Capped] , [FILL: Filled] , [REMOVE: Removed] , ...1 more... )
• ABANDPROJNAME ( type: esriFieldTypeString, alias: Abandoned Project Name, length: 50 )
• ABANDPROJNUM ( type: esriFieldTypeString, alias: Abandoned Project Number, length: 100 )
• ESTINSTALLYEAR ( type: esriFieldTypeSmallInteger, alias: Estimated Install Year )
• NUMPIPES ( type: esriFieldTypeSmallInteger, alias: Number of Pipes )
• RIMELEV ( type: esriFieldTypeDouble, alias: Rim Elevation )
• INVIN1 ( type: esriFieldTypeDouble, alias: Primary Invert In )
• INVIN2 ( type: esriFieldTypeDouble, alias: Invert In 2 )
• INVIN3 ( type: esriFieldTypeDouble, alias: Invert In 3 )
• INVIN4 ( type: esriFieldTypeDouble, alias: Invert In 4 )
• PRIMARYINVOUT ( type: esriFieldTypeDouble, alias: Primary Invert Out )
• INVOUT2 ( type: esriFieldTypeDouble, alias: Invert Out 2 )
• INVOUT3 ( type: esriFieldTypeDouble, alias: Invert Out 3 )
• DEPTH ( type: esriFieldTypeDouble, alias: Depth )
• MHCONFIG ( type: esriFieldTypeString, alias: Manhole Configuration, length: 50 , Coded Values: [CONE: Cone] , [FLATATTACHED: Flat top with ring attached to slab] , [FLATEMBEDDED: Flat top with ring embedded in top slab] , ...2 more... )
• CVTYPE ( type: esriFieldTypeString, alias: Cover Type, length: 20 , Coded Values: [TIGHT: Water Tight] , [VENT: Vented] , [UNK: Unknown] )
• CVSECURITY ( type: esriFieldTypeString, alias: Cover Security, length: 15 , Coded Values: [BOLT: Bolted] , [LCKBAR: Locking Bar] , [NONE: None] )
• VENTED ( type: esriFieldTypeString, alias: Vented, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• VENTELEV ( type: esriFieldTypeDouble, alias: Vent Elevation )
• ODORCNTLTYPE ( type: esriFieldTypeString, alias: Odor Control Type, length: 50 , Coded Values: [BAR: Barrel] , [CAN: Cannister] , [POT: Pot] , ...1 more... )
• WALLMAT ( type: esriFieldTypeString, alias: Manhole Material, length: 25 , Coded Values: [BL: Block] , [BR: Brick] , [CM: Composite] , ...2 more... )
• MHTYPE ( type: esriFieldTypeString, alias: Manhole Type, length: 15 , Coded Values: [STD: Standard] , [INDROP: Inside Drop] , [OUTDROP: Outside Drop] , ...4 more... )
• MHINTCOATING ( type: esriFieldTypeString, alias: Manhole Interior Coating, length: 25 , Coded Values: [CT: Coal Tar] , [EP: Epoxy] , [NONE: None] , ...1 more... )
• FLOWDIR ( type: esriFieldTypeString, alias: Flow Direction, length: 25 , Coded Values: [E: East] , [N: North] , [S: South] , ...9 more... )
• RECLAIMBLOWOFF ( type: esriFieldTypeSmallInteger, alias: Reclaimed Blowoff , Coded Values: [0: False] , [1: True] )
• SYSVALVETYPE ( type: esriFieldTypeString, alias: System Valve Type, length: 50 , Coded Values: [BALL: Ball] , [BFLY: Butterfly] , [GATE: Gate] , ...2 more... )
• SYSMANUFACTURER ( type: esriFieldTypeString, alias: System Valve Manufacturer System Valve Manufacturer System Valve Manufacturer System Valve Manufacturer System Valve Manufacturer, length: 50 , Coded Values: [DEZ: DeZurik] , [MILL: Millikin] , [PRATT: Pratt] , ...1 more... )
• ENCLOSURETYPE ( type: esriFieldTypeString, alias: Enclosure Type, length: 15 , Coded Values: [BOX: Valve Box] , [MANHOLE: Manhole] , [VAULT: Vault] , ...2 more... )
• BYPASSVALVE ( type: esriFieldTypeSmallInteger, alias: Bypass Valve , Coded Values: [0: False] , [1: True] )
• CLOCKTOCLOSE ( type: esriFieldTypeSmallInteger, alias: Clockwise to Close , Coded Values: [0: False] , [1: True] )
• TURNSTOCLOSE ( type: esriFieldTypeInteger, alias: Turns To Close )
• OPERABLE ( type: esriFieldTypeSmallInteger, alias: Operable , Coded Values: [0: False] , [1: True] )
• NORMALLYOPEN ( type: esriFieldTypeSmallInteger, alias: Normally Open , Coded Values: [0: False] , [1: True] )
• CURROPEN ( type: esriFieldTypeSmallInteger, alias: Currently Open , Coded Values: [0: False] , [1: True] )
• CNTRLVALVETYPE ( type: esriFieldTypeString, alias: Valve Type, length: 20 , Coded Values: [ARV: Air Release] , [BACK: Backflow] , [COMBO: Combination Air Release] , ...1 more... )
• CNTRLMANUFACTURER ( type: esriFieldTypeString, alias: Control Valve Manufacturer Control Valve Manufacturer Control Valve Manufacturer Control Valve Manufacturer, length: 10 , Coded Values: [ABCO: ABCO] , [CLOW: CLOW] , [DEZ: DeZurik] )
• NAME ( type: esriFieldTypeString, alias: Name, length: 50 )
• STATIONID ( type: esriFieldTypeString, alias: Station ID, length: 10 )
• ADDRESS ( type: esriFieldTypeString, alias: Address, length: 50 )
• PUMPTYPE ( type: esriFieldTypeString, alias: Pump Type, length: 20 , Coded Values: [DRYPIT: Dry Pit] , [SUBMERS: Submersible] )
• NUMOFPUMP ( type: esriFieldTypeDouble, alias: Number of Pumps )
• FIRMCAP ( type: esriFieldTypeDouble, alias: Firm Capacity )
• TDH ( type: esriFieldTypeDouble, alias: Total Dynamic Head )
• WWTELEV ( type: esriFieldTypeDouble, alias: Wet Well Top Elevation )
• WWFELEV ( type: esriFieldTypeDouble, alias: Wet Well Floor Elevation )
• TIER ( type: esriFieldTypeDouble, alias: Tier , Coded Values: [1: 1] , [2: 2] , [3: 3] )
• GRINDER ( type: esriFieldTypeString, alias: Grinder, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• BACKUPPWR ( type: esriFieldTypeString, alias: Backup Power, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• ODORCNTRLDEV ( type: esriFieldTypeString, alias: Odor Control Device, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• BARSCREEN ( type: esriFieldTypeString, alias: Bar Screen, length: 4 , Coded Values: [Yes: Yes] , [No: No] )
• FLOODPLAIN ( type: esriFieldTypeString, alias: Floodplain, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• FLOODPROOF ( type: esriFieldTypeString, alias: Floodproofed, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• FUELTANK ( type: esriFieldTypeString, alias: Fuel Tank, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• FUELTANKSIZE ( type: esriFieldTypeDouble, alias: Fuel Tank Size )
• NUMGEN ( type: esriFieldTypeDouble, alias: Number of Generators )
• GENSIZE ( type: esriFieldTypeDouble, alias: Genrator Size )
• CHEMFEED ( type: esriFieldTypeString, alias: Chemical Feed, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• CHEMTYPE ( type: esriFieldTypeString, alias: Chemical Type, length: 20 , Coded Values: [CN: Calcium Nitrate] , [FC: Ferric Chloride] , [FS: Ferrous Sulfate] )
• SCADA ( type: esriFieldTypeString, alias: SCADA, length: 15 , Coded Values: [SCADA: SCADA] , [DIALER: DIALER] , [BOTH: SCADA/Dialer] )
• FITTINGTYPE ( type: esriFieldTypeString, alias: Fitting Type, length: 50 , Coded Values: [11.25 BEND: 11.25 Bend] , [22.5 BEND: 22.5 Bend] , [45 BEND: 45 Bend] , ...10 more... )
• SITENUM ( type: esriFieldTypeDouble, alias: Flow Monitor Site Number )
• INSTALLMETHOD ( type: esriFieldTypeString, alias: Install Method, length: 20 , Coded Values: [DOWN: Downstream Pipe] , [UP: Upstream Pipe] )
• INTERCEPTOR ( type: esriFieldTypeString, alias: Interceptor, length: 40 , Coded Values: [BAB: Bachelor Branch] , [BLC: Black Creek] , [BOL: Bond Lake] , ...76 more... )
• MODEL ( type: esriFieldTypeString, alias: Flow Monitor Model, length: 40 , Coded Values: [TRI: Triton +] )
• FLOWMONMANUFACTURER ( type: esriFieldTypeString, alias: Flow Monitor Manufacturer, length: 40 , Coded Values: [ADS: ADS] )
• MANHOLEID ( type: esriFieldTypeString, alias: Manhole Facility ID, length: 20 )
• TREATMENTFAC ( type: esriFieldTypeString, alias: Treatment Facility, length: 50 , Coded Values: [NCWRF: North Cary Water Reclamation Facility] , [SCWRF: South Cary Water Reclamation Facility] , [WWRWRF: Western Wake Regional Water Reclamation Facility] )
• CONTRACTNUM ( type: esriFieldTypeString, alias: Contract Number, length: 50 )
• CONTRACTOR ( type: esriFieldTypeString, alias: Contractor, length: 75 , Coded Values: [FRAZIER: Frazier] )
• STRUCTTYPE ( type: esriFieldTypeString, alias: Structure Type, length: 30 , Coded Values: [CASCADE: Cascade Aerator] , [DISCHARGE: Discharge Structure] , [JUNCTION: Junction Chamber] , ...3 more... )
• CAPACITY ( type: esriFieldTypeDouble, alias: Treatment Plant Capacity )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By , Coded Values: [4: Aqua] , [7: Apex] , [13: Chatham County] , ...5 more... )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Maintained By , Coded Values: [7: Apex] , [4: Aqua] , [1: Cary] , ...5 more... )
• MATFLDSOURCE ( type: esriFieldTypeString, alias: Material Field Source, length: 50 , Coded Values: [CCTV: CCTV Inspection] , [CONSULTANT: Consultant Resources] , [TOWN: Town Resources] )
• DIAMFLDSOURCE ( type: esriFieldTypeString, alias: Diameter Field Source, length: 50 , Coded Values: [CCTV: CCTV Inspection] , [CONSULTANT: Consultant Resources] , [TOWN: Town Resources] )
• FLDVRFDDATE ( type: esriFieldTypeDate, alias: Field Verified Date, length: 8 )
• UTILEXTPERMNUM ( type: esriFieldTypeString, alias: Utility Extension Permit Number, length: 25 )
• RECORDNAME ( type: esriFieldTypeString, alias: Record Name, length: 150 )
• RECORDNUM ( type: esriFieldTypeString, alias: Record Number, length: 100 )
• RECORDSOURCE ( type: esriFieldTypeString, alias: Record Source, length: 25 , Coded Values: [Auto: Auto Generated] , [Construction: Construction] , [Construction (Permitted): Construction (Permitted)] , ...6 more... )
• RECORDNOTES ( type: esriFieldTypeString, alias: Record Notes, length: 255 )
• SURVEYDATE ( type: esriFieldTypeDate, alias: Survey Date, length: 8 )
• SURVEYNAME ( type: esriFieldTypeString, alias: Survey Name, length: 150 )
• SURVEYPROJNUM ( type: esriFieldTypeString, alias: Survey Project Number, length: 100 )
• SURVEYSOURCE ( type: esriFieldTypeString, alias: Survey Source, length: 40 , Coded Values: [Consultant: Consultant Resources] , [Town: Town Resources] , [Record Drawing: Survey Submitted with Record Drawing] , ...1 more... )
• SURVEYQUALHORZ ( type: esriFieldTypeString, alias: Survey Quality, Horizontal, length: 40 , Coded Values: [AA: AA (PLS certified survey per NCBELS)] , [A: A (PLS certified survey per NCBELS)] , [B: B (PLS certified survey per NCBELS)] , ...6 more... )
• SURVEYQUALVERT ( type: esriFieldTypeString, alias: Survey Quality, Vertical, length: 50 , Coded Values: [A: A (PLS certified survey per NCBELS)] , [B: B (PLS certified survey per NCBELS)] , [C: C (PLS certified survey per NCBELS)] , ...3 more... )
• SURVEYDATUMHORZ ( type: esriFieldTypeString, alias: Survey Datum, Horizontal, length: 8 , Coded Values: [NAD27: NAD27] , [NAD8386: NAD83 (1986)] , [NAD8396: NAD83 (CORS96)] , ...4 more... )
• SURVEYDATUMVERT ( type: esriFieldTypeString, alias: Survey Datum, Vertical, length: 8 , Coded Values: [NGVD29: NGVD29] , [NAVD88: NAVD88] )
• SURVEYPOSTPROCESSERROR ( type: esriFieldTypeDouble, alias: Survey Post Process Error )
• SURVEYX ( type: esriFieldTypeDouble, alias: Survey X )
• SURVEYY ( type: esriFieldTypeDouble, alias: Survey Y )
• DEEDREF ( type: esriFieldTypeString, alias: Deed Reference, length: 100 )
• REHABTYPE ( type: esriFieldTypeString, alias: Rehab Lining Type, length: 25 , Coded Values: [CM: Cement Mortar] , [EP: Epoxy] , [UNK: Unknown] )
• REHABDATE ( type: esriFieldTypeDate, alias: Rehab Date, length: 8 )
• REHABPROJNUM ( type: esriFieldTypeString, alias: Rehab Project Number, length: 100 )
• REHABPROJNAME ( type: esriFieldTypeString, alias: Rehab Project Name, length: 150 )
• REHABCONTRACTOR ( type: esriFieldTypeString, alias: Rehab Contractor, length: 75 )
• LOCDESC ( type: esriFieldTypeString, alias: Location Description, length: 200 )
• PHOTOID ( type: esriFieldTypeString, alias: Photo ID, length: 75 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )

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

  Iteminfo   Thumbnail   Metadata