View In:   ArcGIS Online Map Viewer

Name: Outlet

Display Field: assetid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 6bd18d9e30914e5aae49c69cc1f2b5a8

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 10000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: -9285218.778643318
YMin: 4318764.007145761
XMax: -9261522.461638972
YMax: 4337034.911516664
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: additionaldetails
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 1
  Label: Yes
  Description: N/A
  Symbol:
  
• Value: 2
  Label: No
  Description: N/A
  Symbol:
  
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: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: true

HasM: true

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: additionaldetails

Fields:

• assetid ( type: esriFieldTypeString, alias: Asset ID, editable: true, nullable: true, length: 64, defaultValue: null, modelName: assetid )
• assettype_outlet ( type: esriFieldTypeString, alias: Outlet_Asset_Tpe, editable: true, nullable: true, length: 255, defaultValue: null, modelName: assettype_outlet , Coded Values: [PO: Pipe_Outlet] , [CB: Catch_Basin] , [HW: Headwall] , ...5 more... )
• additionaldetails ( type: esriFieldTypeSmallInteger, alias: Outfall, editable: true, nullable: true, defaultValue: null, modelName: additionaldetails , Coded Values: [1: Yes] , [2: No] )
• outfallid ( type: esriFieldTypeString, alias: Outfall ID, editable: true, nullable: true, length: 64, defaultValue: null, modelName: outfallid )
• hotspot ( type: esriFieldTypeString, alias: Hot_Spot, editable: true, nullable: true, length: 10, defaultValue: null, modelName: hotspot , Coded Values: [Yes: Yes] , [No: No] )
• surfacewater ( type: esriFieldTypeSmallInteger, alias: Receives Surface Water, editable: true, nullable: true, defaultValue: 0, modelName: surfacewater , Coded Values: [0: Unknown] , [1: Yes] , [2: No] )
• ditchtype ( type: esriFieldTypeString, alias: Ditch_Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ditchtype , Coded Values: [Riprap: Riprap] , [Concrete: Concrete] , [Earth: Earth] , ...1 more... )
• outletexit ( type: esriFieldTypeString, alias: Outlet_Exiting_System, editable: true, nullable: true, length: 255, defaultValue: null, modelName: outletexit , Coded Values: [1: City] , [2: Stream_Waterway] , [3: TDOT] , ...3 more... )
• outletview ( type: esriFieldTypeString, alias: Outlet_Location_View, editable: true, nullable: true, length: 255, defaultValue: null, modelName: outletview , Coded Values: [BL: Bank_Left] , [BR: Bank_Right] )
• ditchwidth ( type: esriFieldTypeInteger, alias: Ditch_Width_feet, editable: true, nullable: true, defaultValue: null, modelName: ditchwidth )
• ownedby ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: 1, modelName: ownedby , Coded Values: [-2: Other] , [1: Our Agency] , [-1: Private] )
• maintby ( type: esriFieldTypeSmallInteger, alias: Maintained By, editable: true, nullable: true, defaultValue: 1, modelName: maintby , Coded Values: [1: Our Agency] , [-1: Private] , [-2: Other] )
• notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: notes )
• spatialsource ( type: esriFieldTypeSmallInteger, alias: Spatial Source, editable: true, nullable: true, defaultValue: 0, modelName: spatialsource , Coded Values: [0: Unknown] , [1: As-Built] , [2: CAD] , ...3 more... )
• spatialconfidence ( type: esriFieldTypeSmallInteger, alias: Spatial Confidence, editable: true, nullable: true, defaultValue: 0, modelName: spatialconfidence , Coded Values: [0: Unknown] , [1: High] , [2: Medium] , ...1 more... )
• facilityid ( type: esriFieldTypeString, alias: Facility_ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: facilityid )
• invertelev ( type: esriFieldTypeDouble, alias: Invert Elevation, editable: true, nullable: true, defaultValue: null, modelName: invertelev )
• material ( type: esriFieldTypeSmallInteger, alias: Outlet Material, editable: true, nullable: true, defaultValue: 0, modelName: material , Coded Values: [0: Unknown] , [3: Asphalt - ASP] , [4: Brick - BR] , ...12 more... )
• diameter ( type: esriFieldTypeDouble, alias: Diameter, editable: true, nullable: true, defaultValue: 0, modelName: diameter , Coded Values: [0: Unknown] , [3: 3"] , [4: 4"] , ...21 more... )
• permitted ( type: esriFieldTypeSmallInteger, alias: Permitted, editable: true, nullable: true, defaultValue: 0, modelName: permitted , Coded Values: [0: Unknown] , [1: Yes] , [2: No] )
• permitid ( type: esriFieldTypeString, alias: Permit ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: permitid )
• installdate ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: installdate )
• lifecyclestatus ( type: esriFieldTypeSmallInteger, alias: Lifecycle Status, editable: true, nullable: false, defaultValue: 8, modelName: lifecyclestatus , Coded Values: [0: Unknown] , [1: Proposed] , [2: Proposed - Approved] , ...4 more... )
• ESRIGNSS_LATITUDE ( type: esriFieldTypeDouble, alias: Latitude, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_LATITUDE )
• ESRIGNSS_LONGITUDE ( type: esriFieldTypeDouble, alias: Longitude, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_LONGITUDE )
• ESRIGNSS_ALTITUDE ( type: esriFieldTypeDouble, alias: Altitude, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_ALTITUDE )
• GlobalID ( type: esriFieldTypeGUID, alias: GlobalID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• OBJECTID ( type: esriFieldTypeOID, alias: objectid, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: GlobalID_1, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID_1 )
• lastinspectdate ( type: esriFieldTypeDate, alias: Last Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: lastinspectdate )
• numinsp ( type: esriFieldTypeSmallInteger, alias: Number of Inspections, editable: true, nullable: true, defaultValue: null, modelName: numinsp )

Types:

ID: 1
Name: Yes
Domains:
• assettype_outlet:
  Inherited
• additionaldetails:
  Inherited
• hotspot:
  Inherited
• surfacewater:
  Inherited
• ditchtype:
  Inherited
• outletexit:
  Inherited
• outletview:
  Inherited
• ownedby:
  Inherited
• maintby:
  Inherited
• spatialsource:
  Inherited
• spatialconfidence:
  Inherited
• material:
  Inherited
• diameter:
  Inherited
• permitted:
  Inherited
• lifecyclestatus:
  Inherited
Templates:
• Name: Yes
  Description:
  Prototype:
  assettype_outlet: null
  lastinspectdate: null
  assetid: null
  additionaldetails: 1
  outfallid: null
  hotspot: null
  surfacewater: 0
  ditchtype: null
  outletexit: null
  outletview: null
  ditchwidth: null
  ownedby: 1
  maintby: 1
  notes: null
  spatialsource: 0
  spatialconfidence: 0
  facilityid: null
  invertelev: null
  material: 0
  diameter: 0
  permitted: 0
  permitid: null
  installdate: null
  lifecyclestatus: 8
  ESRIGNSS_LATITUDE: null
  ESRIGNSS_LONGITUDE: null
  ESRIGNSS_ALTITUDE: null
  GlobalID: null
  numinsp: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 2
Name: No
Domains:
• assettype_outlet:
  Inherited
• additionaldetails:
  Inherited
• hotspot:
  Inherited
• surfacewater:
  Inherited
• ditchtype:
  Inherited
• outletexit:
  Inherited
• outletview:
  Inherited
• ownedby:
  Inherited
• maintby:
  Inherited
• spatialsource:
  Inherited
• spatialconfidence:
  Inherited
• material:
  Inherited
• diameter:
  Inherited
• permitted:
  Inherited
• lifecyclestatus:
  Inherited
Templates:
• Name: No
  Description:
  Prototype:
  assettype_outlet: null
  lastinspectdate: null
  assetid: null
  additionaldetails: 2
  outfallid: null
  hotspot: null
  surfacewater: 0
  ditchtype: null
  outletexit: null
  outletview: null
  ditchwidth: null
  ownedby: 1
  maintby: 1
  notes: null
  spatialsource: 0
  spatialconfidence: 0
  facilityid: null
  invertelev: null
  material: 0
  diameter: 0
  permitted: 0
  permitid: null
  installdate: null
  lifecyclestatus: 8
  ESRIGNSS_LATITUDE: null
  ESRIGNSS_LONGITUDE: null
  ESRIGNSS_ALTITUDE: null
  GlobalID: null
  numinsp: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Relationships:

• LG_Base.DBO.Outlet_Inspections (0) -- Related To: Outlet_Inspections (8)

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata