View In:   ArcGIS Online Map Viewer

Name: SW_Advertisements

Display Field: A_ID

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description: To track and enter awareness and advertising campaigns and promo items for required reporting with City's NPDES permit

Service Item Id: f06fa64d351d436e9aa37a4bb92c5e9b

Copyright Text: StormWater Dept

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

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: 677179.9470881087
YMin: 242198.2605054242
XMax: 920407.7918313504
YMax: 438932.8933601688
Spatial Reference: 102736  (2274)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSFSSolid
Color: [227, 252, 207, 255]
Outline:
Style: esriSLSSolid
Color: [110, 110, 110, 255]
Width: 0
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: true
Supports Returning Geometry Centroid: true
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: false
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:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• A_ID ( type: esriFieldTypeString, alias: A_ID, editable: true, nullable: false, length: 25, defaultValue: null, modelName: A_ID )
• SumCode ( type: esriFieldTypeString, alias: SumCode, editable: true, nullable: true, length: 25, defaultValue: null, modelName: SumCode , Coded Values: [NEW: New] , [DG: Digital Ad] , [TR: Traditional Ad] , ...4 more... )
• A_Type ( type: esriFieldTypeString, alias: A_Type, editable: true, nullable: true, length: 25, defaultValue: null, modelName: A_Type , Coded Values: [NEW: New] , [BB: BillBoard] , [DG_S: Digital-Social] , ...12 more... )
• Publisher ( type: esriFieldTypeString, alias: Publisher, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Publisher , Coded Values: [NEW: New] , [CM: Contemporary Media] , [CLM: Clean Memphis] , ...9 more... )
• Campaign_Ad_Description ( type: esriFieldTypeString, alias: Campaign_Ad_Description, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Campaign_Ad_Description , Coded Values: [NEW: New] , [SP: Scoop the Poop] , [DBI: Don't Blow It] , ...31 more... )
• REF_Address ( type: esriFieldTypeString, alias: REF_Address, editable: true, nullable: true, length: 75, defaultValue: null, modelName: REF_Address )
• Mailing_Qty ( type: esriFieldTypeSmallInteger, alias: Mailing_Qty, editable: true, nullable: true, defaultValue: null, modelName: Mailing_Qty )
• Sign_Qty ( type: esriFieldTypeSmallInteger, alias: Sign_Qty, editable: true, nullable: true, defaultValue: null, modelName: Sign_Qty )
• Start_Date ( type: esriFieldTypeDate, alias: Start_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Start_Date )
• End_Date ( type: esriFieldTypeDate, alias: End_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: End_Date )
• BASIN ( type: esriFieldTypeString, alias: BASIN, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BASIN )
• WATERSHED ( type: esriFieldTypeString, alias: WATERSHED, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WATERSHED , Coded Values: [L: Loosahatchie] , [W: Wolf River] , [N: Nonconnah] , ...1 more... )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, 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 )
• Shape__Area ( type: esriFieldTypeDouble, alias: Shape.STArea(), editable: false, nullable: true, defaultValue: null, modelName: Shape.STArea(), required: true )
• Shape__Length ( type: esriFieldTypeDouble, alias: Shape.STLength(), editable: false, nullable: true, defaultValue: null, modelName: Shape.STLength(), required: true )

Templates:

• Name: SW_Advertisements
  Description:
  Prototype:
  WATERSHED: null
  BASIN: null
  A_ID:
  SumCode: null
  A_Type: null
  Publisher: null
  Campaign_Ad_Description: null
  REF_Address: null
  Mailing_Qty: null
  Sign_Qty: null
  Start_Date: null
  End_Date: null
  
  Drawing Tool: esriFeatureEditToolPolygon

Relationships:

• PW_GDB.PWGISEDITOR.PW_SW_Ads_WWW_ActivityTable (1) -- Related To: SW_WWW_Ad_ActivityTable (5)
• PW_GDB.PWGISEDITOR.PW_SW_Ads_DG_TR_ActivityTable (2) -- Related To: SW_Digital_and_Traditional_Ad_Activity_Table (4)
• PW_GDB.PWGISEDITOR.PW_SW_Ads_VM_ActivityTable (3) -- Related To: SW_VoiceMail_ActivityTable (3)

Capabilities: Query,Create,Update,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: 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

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata