ArcGIS REST Services Directory
Login
Home
>
services
>
PublicWorks
>
StormWater_NPDES_Permit (MapServer)
>
All Layers and Tables
API Reference
JSON
All Layers and Tables (PublicWorks/StormWater_NPDES_Permit)
Layers:
Layer:
SW_Education_Outreach
(0)
Name:
SW_Education_Outreach
Display Field:
ED_PO
Type:
Feature Layer
Geometry Type:
esriGeometryPoint
Description:
GDB for City NPDES permit requirement-public outreach & education. Locations for public outreach & education events to raise stormwater awareness.
Service Item Id:
fa8a01e4acf447838e0ee1dab2757577
Copyright Text:
StormWaterDept
Default Visibility: false
MaxRecordCount:
2000
Supported Query Formats:
JSON, geoJSON, PBF
Min Scale:
0
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: 745105.2921596318
YMin: 273257.4013813138
XMax: 849809.8042068928
YMax: 364113.3974904716
Spatial Reference: 102736 (2274)
Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style:
esriSMSCircle
Color:
[150, 0, 176, 255]
Size:
4.0
Angle:
0.0
XOffset:
0
YOffset:
0
Outline:
[0, 0, 0, 255]
Width:
1
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 )
ED_PO_ID
( type: esriFieldTypeDouble, alias: ED_PO ID )
ED_PO
( type: esriFieldTypeString, alias: ED or PO, length: 50 ,
Coded Values:
[ED: Education (School)] , [PO: Public Outreach (Non-school)] )
Address
( type: esriFieldTypeString, alias: Address, length: 100 )
Date_forFY
( type: esriFieldTypeDate, alias: Date _for FY map, length: 8 )
X
( type: esriFieldTypeDouble, alias: X )
Y
( type: esriFieldTypeDouble, alias: Y )
City
( type: esriFieldTypeString, alias: City, length: 50 )
State
( type: esriFieldTypeString, alias: State, length: 15 )
BASIN
( type: esriFieldTypeString, alias: BASIN, length: 50 )
WATERSHED
( type: esriFieldTypeString, alias: WATERSHED, length: 50 )
GlobalID
( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
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 )
Zip
( type: esriFieldTypeString, alias: Zip, length: 255 )
Shape
( type: esriFieldTypeGeometry, alias: SHAPE )
Relationships:
PW_GDB.PWGISEDITOR.PW_SW_ED_PO_ACTIVITIES (0) --
Related To
:
Education_PublicOutreach_Activities
(2)
Layer:
SW_Advertisements
(1)
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:
fa8a01e4acf447838e0ee1dab2757577
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
Has Labels:
false
Can Modify Layer:
true
Can Scale Symbols:
false
Use Standardized Queries:
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: 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 )
A_ID
( type: esriFieldTypeString, alias: A_ID, length: 25 )
SumCode
( type: esriFieldTypeString, alias: SumCode, length: 25 ,
Coded Values:
[NEW: New] , [DG: Digital Ad] , [TR: Traditional Ad]
, ...4 more...
)
A_Type
( type: esriFieldTypeString, alias: A_Type, length: 25 ,
Coded Values:
[NEW: New] , [BB: BillBoard] , [DG_S: Digital-Social]
, ...12 more...
)
Publisher
( type: esriFieldTypeString, alias: Publisher, length: 50 ,
Coded Values:
[NEW: New] , [CM: Contemporary Media] , [CLM: Clean Memphis]
, ...9 more...
)
Campaign_Ad_Description
( type: esriFieldTypeString, alias: Campaign_Ad_Description, length: 50 ,
Coded Values:
[NEW: New] , [SP: Scoop the Poop] , [DBI: Don't Blow It]
, ...31 more...
)
REF_Address
( type: esriFieldTypeString, alias: REF_Address, length: 75 )
Mailing_Qty
( type: esriFieldTypeSmallInteger, alias: Mailing_Qty )
Sign_Qty
( type: esriFieldTypeSmallInteger, alias: Sign_Qty )
Start_Date
( type: esriFieldTypeDate, alias: Start_Date, length: 8 )
End_Date
( type: esriFieldTypeDate, alias: End_Date, length: 8 )
BASIN
( type: esriFieldTypeString, alias: BASIN, length: 50 )
WATERSHED
( type: esriFieldTypeString, alias: WATERSHED, length: 50 ,
Coded Values:
[L: Loosahatchie] , [W: Wolf River] , [N: Nonconnah]
, ...1 more...
)
GlobalID
( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
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 )
Shape
( type: esriFieldTypeGeometry, alias: SHAPE )
Shape.STArea()
( type: esriFieldTypeDouble, alias: Shape.STArea() )
Shape.STLength()
( type: esriFieldTypeDouble, alias: Shape.STLength() )
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)
Tables:
Table:
Education_PublicOutreach_Activities
(2)
Name:
Education_PublicOutreach_Activities
Display Field:
EventName
Type:
Table
Geometry Type:
N/A
Description:
null
Service Item Id:
fa8a01e4acf447838e0ee1dab2757577
Copyright Text:
N/A
Default Visibility: false
MaxRecordCount:
2000
Supported Query Formats:
JSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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:
esriServerHTMLPopupTypeNone
Type ID Field:
null
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID )
ED_PO_ID
( type: esriFieldTypeDouble, alias: ED_PO_ID )
Address
( type: esriFieldTypeString, alias: Address, length: 100 )
EventLocation
( type: esriFieldTypeString, alias: Education Location, length: 100 )
EventName
( type: esriFieldTypeString, alias: Event Name, length: 100 )
EventType
( type: esriFieldTypeString, alias: Event Type, length: 255 ,
Coded Values:
[ED: Education (School)] , [PO: Public Outreach (Non-school)] )
EventSpecifics
( type: esriFieldTypeString, alias: Event Specifics, length: 255 ,
Coded Values:
[Classroom: Classroom Activity] , [Clean-Up: Clean-Up] , [Festival_Booth: Festival_Booth]
, ...11 more...
)
ActivitySpecifics
( type: esriFieldTypeString, alias: Activity Specifics, length: 255 )
StartDate
( type: esriFieldTypeDate, alias: Start Date, length: 8 )
EndDate
( type: esriFieldTypeDate, alias: End Date, length: 8 )
NumberReached
( type: esriFieldTypeInteger, alias: NumberReached )
Representatives
( type: esriFieldTypeString, alias: Representatives, length: 100 )
Giveaways
( type: esriFieldTypeString, alias: Giveaways, length: 255 ,
Coded Values:
[Yes: Yes] , [No: No] , [NA: NA] )
Giveaway1
( type: esriFieldTypeString, alias: Giveaway1, length: 255 ,
Coded Values:
[A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain]
, ...57 more...
)
Qty1
( type: esriFieldTypeInteger, alias: Qty1 )
Giveaway2
( type: esriFieldTypeString, alias: Giveaway2, length: 255 ,
Coded Values:
[A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain]
, ...57 more...
)
Qty2
( type: esriFieldTypeInteger, alias: Qty2 )
Giveaway3
( type: esriFieldTypeString, alias: Giveaway3, length: 255 ,
Coded Values:
[A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain]
, ...57 more...
)
Qty3
( type: esriFieldTypeInteger, alias: Qty3 )
Giveaway4
( type: esriFieldTypeString, alias: Giveaway4, length: 255 ,
Coded Values:
[A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain]
, ...57 more...
)
Qty4
( type: esriFieldTypeInteger, alias: Qty4 )
Giveaway5
( type: esriFieldTypeString, alias: Giveaway5, length: 255 ,
Coded Values:
[A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain]
, ...57 more...
)
Qty5
( type: esriFieldTypeInteger, alias: Qty5 )
Giveaway6
( type: esriFieldTypeString, alias: Giveaway6, length: 255 ,
Coded Values:
[A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain]
, ...57 more...
)
Qty6
( type: esriFieldTypeInteger, alias: Qty6 )
Giveaway7
( type: esriFieldTypeString, alias: Giveaway7, length: 255 ,
Coded Values:
[A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain]
, ...57 more...
)
Qty7
( type: esriFieldTypeInteger, alias: Qty7 )
Giveaway8
( type: esriFieldTypeString, alias: Giveaway8, length: 255 ,
Coded Values:
[A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain]
, ...57 more...
)
Qty8
( type: esriFieldTypeInteger, alias: Qty8 )
Giveaway9
( type: esriFieldTypeString, alias: Giveaway9, length: 255 ,
Coded Values:
[A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain]
, ...57 more...
)
Qty9
( type: esriFieldTypeInteger, alias: Qty9 )
Giveaway10
( type: esriFieldTypeString, alias: Giveaway10, length: 255 ,
Coded Values:
[A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain]
, ...57 more...
)
Qty10
( type: esriFieldTypeInteger, alias: Qty10 )
Giveaway11
( type: esriFieldTypeString, alias: Giveaway11, length: 255 ,
Coded Values:
[A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain]
, ...57 more...
)
Qty11
( type: esriFieldTypeInteger, alias: Qty11 )
Giveaway12
( type: esriFieldTypeString, alias: Giveaway12, length: 255 ,
Coded Values:
[A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain]
, ...57 more...
)
Qty12
( type: esriFieldTypeInteger, alias: Qty12 )
Giveaway13
( type: esriFieldTypeString, alias: Giveaway13, length: 255 ,
Coded Values:
[A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain]
, ...57 more...
)
Qty13
( type: esriFieldTypeInteger, alias: Qty13 )
Giveaway14
( type: esriFieldTypeString, alias: Giveaway14, length: 255 ,
Coded Values:
[A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain]
, ...57 more...
)
Qty14
( type: esriFieldTypeInteger, alias: Qty14 )
Giveaway15
( type: esriFieldTypeString, alias: Giveaway15, length: 255 ,
Coded Values:
[A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain]
, ...57 more...
)
Qty15
( type: esriFieldTypeInteger, alias: Qty15 )
Giveaway16
( type: esriFieldTypeString, alias: Giveaway16, length: 255 ,
Coded Values:
[A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain]
, ...57 more...
)
Qty16
( type: esriFieldTypeInteger, alias: Qty16 )
Giveaway17
( type: esriFieldTypeString, alias: Giveaway17, length: 255 ,
Coded Values:
[A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain]
, ...57 more...
)
Qty17
( type: esriFieldTypeInteger, alias: Qty17 )
Giveaway18
( type: esriFieldTypeString, alias: Giveaway18, length: 255 ,
Coded Values:
[A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain]
, ...57 more...
)
Qty18
( type: esriFieldTypeInteger, alias: Qty18 )
Giveaway19
( type: esriFieldTypeString, alias: Giveaway19, length: 255 ,
Coded Values:
[A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain]
, ...57 more...
)
Qty19
( type: esriFieldTypeInteger, alias: Qty19 )
Giveaway20
( type: esriFieldTypeString, alias: Giveaway20, length: 255 ,
Coded Values:
[A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain]
, ...57 more...
)
Qty20
( type: esriFieldTypeInteger, alias: Qty20 )
GlobalID
( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
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 )
Giveaway21
( type: esriFieldTypeString, alias: Giveaway21, length: 255 ,
Coded Values:
[A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain]
, ...57 more...
)
Qty21
( type: esriFieldTypeInteger, alias: Qty21 )
Giveaway22
( type: esriFieldTypeString, alias: Giveaway22, length: 255 ,
Coded Values:
[A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain]
, ...57 more...
)
Qty22
( type: esriFieldTypeInteger, alias: Qty22 )
Giveaway23
( type: esriFieldTypeString, alias: Giveaway23, length: 255 ,
Coded Values:
[A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain]
, ...57 more...
)
Qty23
( type: esriFieldTypeInteger, alias: Qty23 )
Giveaway24
( type: esriFieldTypeString, alias: Giveaway24, length: 255 ,
Coded Values:
[A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain]
, ...57 more...
)
Qty24
( type: esriFieldTypeInteger, alias: Qty24 )
Giveaway25
( type: esriFieldTypeString, alias: Giveaway25, length: 255 ,
Coded Values:
[A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain]
, ...57 more...
)
Qty25
( type: esriFieldTypeInteger, alias: Qty25 )
Giveaway26
( type: esriFieldTypeString, alias: Giveaway26, length: 255 ,
Coded Values:
[A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain]
, ...57 more...
)
Qty26
( type: esriFieldTypeInteger, alias: Qty26 )
Giveaway27
( type: esriFieldTypeString, alias: Giveaway27, length: 255 ,
Coded Values:
[A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain]
, ...57 more...
)
Qty27
( type: esriFieldTypeInteger, alias: Qty27 )
Giveaway28
( type: esriFieldTypeString, alias: Giveaway28, length: 255 ,
Coded Values:
[A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain]
, ...57 more...
)
Qty28
( type: esriFieldTypeInteger, alias: Qty28 )
Giveaway29
( type: esriFieldTypeString, alias: Giveaway29, length: 255 ,
Coded Values:
[A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain]
, ...57 more...
)
Qty29
( type: esriFieldTypeInteger, alias: Qty29 )
Giveaway30
( type: esriFieldTypeString, alias: Giveaway30, length: 255 ,
Coded Values:
[A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain]
, ...57 more...
)
Qty30
( type: esriFieldTypeInteger, alias: Qty30 )
Relationships:
PW_GDB.PWGISEDITOR.PW_GDB_SW_Education_PublicOutreach (0) --
Related To
:
SW_Education_Outreach
(0)
Table:
SW_VoiceMail_ActivityTable
(3)
Name:
SW_VoiceMail_ActivityTable
Display Field:
A_ID
Type:
Table
Geometry Type:
N/A
Description:
null
Service Item Id:
fa8a01e4acf447838e0ee1dab2757577
Copyright Text:
N/A
Default Visibility: false
MaxRecordCount:
2000
Supported Query Formats:
JSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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:
esriServerHTMLPopupTypeNone
Type ID Field:
null
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID )
A_ID
( type: esriFieldTypeString, alias: A_ID, length: 25 )
VM_Num
( type: esriFieldTypeString, alias: VM_Num, length: 25 ,
Coded Values:
[NEW: New] , [4349: 636-4349] , [6721: 636-6721] )
Caller_Num
( type: esriFieldTypeString, alias: Caller_Num, length: 25 )
Call_Date
( type: esriFieldTypeDate, alias: Call_Date, length: 8 )
Recd_Date
( type: esriFieldTypeDate, alias: Recd_Date, length: 8 )
Call_Concern
( type: esriFieldTypeString, alias: Call_Concern, length: 50 ,
Coded Values:
[OTHER: Other] , [SW_Fee: SW Fee Concern] , [SW_CL: SW Courtesy Letter]
, ...10 more...
)
Call_Notes
( type: esriFieldTypeString, alias: Call_Notes, length: 200 )
MATERIAL
( type: esriFieldTypeInteger, alias: MATERIAL ,
Coded Values:
[0: UNKNOWN] , [1: TRASH] , [2: CONSTRUCTION MATERIALS]
, ...10 more...
)
Action_Sum
( type: esriFieldTypeString, alias: Action_Sum, length: 75 ,
Coded Values:
[OTHER: Other] , [CB: Called Back] , [CB-Refer: Called Back- Ref2CorrectDept]
, ...5 more...
)
Promo_Item1_Qty
( type: esriFieldTypeInteger, alias: Promo_Item1_Qty )
Promo_Item2_Qty
( type: esriFieldTypeInteger, alias: Promo_Item2_Qty )
Promo_Item3_Qty
( type: esriFieldTypeInteger, alias: Promo_Item3_Qty )
GlobalID
( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
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 )
Promo_Item1
( type: esriFieldTypeString, alias: Promo_Item1, length: 255 ,
Coded Values:
[A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain]
, ...57 more...
)
Promo_Item2
( type: esriFieldTypeString, alias: Promo_Item2, length: 255 ,
Coded Values:
[A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain]
, ...57 more...
)
Promo_Item3
( type: esriFieldTypeString, alias: Promo_Item3, length: 255 ,
Coded Values:
[A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain]
, ...57 more...
)
Relationships:
PW_GDB.PWGISEDITOR.PW_SW_Awareness_Ad_Map (3) --
Related To
:
SW_Advertisements
(1)
Table:
SW_Digital_and_Traditional_Ad_Activity_Table
(4)
Name:
SW_Digital_and_Traditional_Ad_Activity_Table
Display Field:
A_ID
Type:
Table
Geometry Type:
N/A
Description:
null
Service Item Id:
fa8a01e4acf447838e0ee1dab2757577
Copyright Text:
N/A
Default Visibility: false
MaxRecordCount:
2000
Supported Query Formats:
JSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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:
esriServerHTMLPopupTypeNone
Type ID Field:
null
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID )
A_ID
( type: esriFieldTypeString, alias: A_ID, length: 25 )
SumCode
( type: esriFieldTypeString, alias: SumCode, length: 25 ,
Coded Values:
[NEW: New] , [DG: Digital Ad] , [TR: Traditional Ad]
, ...4 more...
)
A_Type
( type: esriFieldTypeString, alias: A_Type, length: 25 ,
Coded Values:
[NEW: New] , [BB: BillBoard] , [DG_S: Digital-Social]
, ...12 more...
)
Publisher
( type: esriFieldTypeString, alias: Publisher, length: 50 ,
Coded Values:
[NEW: New] , [CM: Contemporary Media] , [CLM: Clean Memphis]
, ...9 more...
)
Campaign_AdDescription
( type: esriFieldTypeString, alias: Campaign_AdDescription, length: 50 ,
Coded Values:
[NEW: New] , [SP: Scoop the Poop] , [DBI: Don't Blow It]
, ...31 more...
)
Description
( type: esriFieldTypeString, alias: Description, length: 200 )
Metric
( type: esriFieldTypeString, alias: Metric, length: 100 )
Dg_Link
( type: esriFieldTypeString, alias: Dg_Link, length: 200 )
Tr_QR
( type: esriFieldTypeString, alias: Tr_QR, length: 200 )
Start_Date
( type: esriFieldTypeDate, alias: Start Date, length: 8 )
End_Date
( type: esriFieldTypeDate, alias: End_Date, length: 8 )
Total_TV_Ads
( type: esriFieldTypeDouble, alias: Total_TV_Ads )
DMA_RTG_less1
( type: esriFieldTypeDouble, alias: DMA_RTG_less1 )
DMA_RTG_1to2
( type: esriFieldTypeDouble, alias: DMA.RTG_1-1.9 )
DMA_RTG_2to3
( type: esriFieldTypeDouble, alias: DMA_RTG_2-2.9 )
DMA_RTG_3to4
( type: esriFieldTypeDouble, alias: DMA_RTG_3-3.9 )
DMA_RTG_4to5
( type: esriFieldTypeDouble, alias: DMA_RTG_4-4.9 )
DMA_RTG_5andUp
( type: esriFieldTypeDouble, alias: DMA_RTG_5andUp )
Dg_Impressions
( type: esriFieldTypeDouble, alias: Dg_Impressions )
Dg_Clicks
( type: esriFieldTypeDouble, alias: Dg_Clicks )
Dg_CTR
( type: esriFieldTypeDouble, alias: Dg_CTR )
Dg_Engagement
( type: esriFieldTypeDouble, alias: Dg_Engagement )
Dg_Likes
( type: esriFieldTypeDouble, alias: Dg_Likes )
GlobalID
( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
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 )
Relationships:
PW_GDB.PWGISEDITOR.PW_SW_Awareness_Ad_Map (2) --
Related To
:
SW_Advertisements
(1)
Table:
SW_WWW_Ad_ActivityTable
(5)
Name:
SW_WWW_Ad_ActivityTable
Display Field:
A_ID
Type:
Table
Geometry Type:
N/A
Description:
null
Service Item Id:
fa8a01e4acf447838e0ee1dab2757577
Copyright Text:
N/A
Default Visibility: false
MaxRecordCount:
2000
Supported Query Formats:
JSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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:
esriServerHTMLPopupTypeNone
Type ID Field:
null
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID )
A_ID
( type: esriFieldTypeString, alias: A_ID, length: 25 )
Start_Date
( type: esriFieldTypeDate, alias: Start_Date, length: 8 )
End_Date
( type: esriFieldTypeDate, alias: End_Date, length: 8 )
TS_Direct
( type: esriFieldTypeInteger, alias: TS_Direct )
T_Search
( type: esriFieldTypeInteger, alias: T_Search )
TS_Referral
( type: esriFieldTypeInteger, alias: TS_Referral )
TS_RefQR
( type: esriFieldTypeInteger, alias: TS_RefQR )
TS_RefNotes
( type: esriFieldTypeString, alias: TS_RefNotes, length: 200 )
TS_Social
( type: esriFieldTypeInteger, alias: TS_Social )
TS_SocNotes
( type: esriFieldTypeString, alias: TS_SocNotes, length: 200 )
TS_DisplayAds
( type: esriFieldTypeInteger, alias: TS_DisplayAds )
TS_Email
( type: esriFieldTypeInteger, alias: TS_Email )
TS_GoogleAnalyt
( type: esriFieldTypeDouble, alias: TS_GoogleAnalyt )
TS_Notes
( type: esriFieldTypeString, alias: TS_Notes, length: 200 )
TS_QR_Promo_DBI
( type: esriFieldTypeInteger, alias: TS_QR_Promo_DBI )
TS_QR_Promo_DFI
( type: esriFieldTypeInteger, alias: TS_QR_Promo_DFI )
TS_QR_Promo_RRR
( type: esriFieldTypeInteger, alias: TS_QR_Promo_RRR )
TS_QR_Promo_ASD
( type: esriFieldTypeInteger, alias: TS_QR_Promo_ASD )
TS_QR_Promo_ASDA
( type: esriFieldTypeInteger, alias: TS_QR_Promo_ASDA )
TS_QR_Promo_SP
( type: esriFieldTypeInteger, alias: TS_QR_Promo_SP )
TS_QR_Promo_MSWcom
( type: esriFieldTypeInteger, alias: TS_QR_Promo_MSWcom )
TS_QR_Promo_LPP
( type: esriFieldTypeInteger, alias: TS_QR_Promo_LPP )
TS_QR_Promo_JWW
( type: esriFieldTypeInteger, alias: TS_QR_Promo_JWW )
TS_QR_Promo_GC
( type: esriFieldTypeInteger, alias: TS_QR_Promo_GC )
TS_QR_Promo_WS
( type: esriFieldTypeInteger, alias: TS_QR_Promo_WS )
TS_QR_Promo_GI
( type: esriFieldTypeInteger, alias: TS_QR_Promo_GI )
TS_QR_Promo_FOG
( type: esriFieldTypeInteger, alias: TS_QR_Promo_FOG )
TS_QR_Promo_FOGwipes
( type: esriFieldTypeInteger, alias: TS_QR_Promo_FOGwipes )
TS_QR_Promo_B
( type: esriFieldTypeInteger, alias: TS_QR_Promo_B )
TS_QR_AwFlyer
( type: esriFieldTypeInteger, alias: TS_QR_AwFlyer )
TS_QR_FOGAwFlyer
( type: esriFieldTypeInteger, alias: TS_QR_FOGAwFlyer )
TS_QR_PressR
( type: esriFieldTypeInteger, alias: TS_QR_PressR )
TS_QR_Mailing
( type: esriFieldTypeInteger, alias: TS_QR_Mailing )
TS_QR_Ad_LPL
( type: esriFieldTypeInteger, alias: TS_QR_Ad_LPL )
TS_QR_Ad_MF
( type: esriFieldTypeInteger, alias: TS_QR_Ad_MF )
TS_QR_Ad_MP
( type: esriFieldTypeInteger, alias: TS_QR_Ad_MP )
TS_QR_Ad_JB
( type: esriFieldTypeInteger, alias: TS_QR_Ad_JB )
TS_QR_Ad_FOG
( type: esriFieldTypeInteger, alias: TS_QR_Ad_FOG )
TS_QR_Ad_Notes
( type: esriFieldTypeString, alias: TS_QR_Ad_Notes, length: 200 )
TD_Desktop
( type: esriFieldTypeInteger, alias: TD_Desktop )
TD_Mobile
( type: esriFieldTypeInteger, alias: TD_Mobile )
TD_Tablet
( type: esriFieldTypeInteger, alias: TD_Tablet )
TD_Other
( type: esriFieldTypeString, alias: TD_Other, length: 200 )
T_PageViews
( type: esriFieldTypeInteger, alias: T_PageViews )
T_Visits
( type: esriFieldTypeInteger, alias: T_Visits )
T_UniqueV
( type: esriFieldTypeInteger, alias: T_UniqueV )
T_Page_Views
( type: esriFieldTypeInteger, alias: T_Page_Views )
PC_1
( type: esriFieldTypeString, alias: PC_1, length: 200 ,
Coded Values:
[NEW: New] , [HM: Homepage] , [AB: About]
, ...10 more...
)
PC_2
( type: esriFieldTypeString, alias: PC_2, length: 200 ,
Coded Values:
[NEW: New] , [HM: Homepage] , [AB: About]
, ...10 more...
)
PC_3
( type: esriFieldTypeString, alias: PC_3, length: 200 ,
Coded Values:
[NEW: New] , [HM: Homepage] , [AB: About]
, ...10 more...
)
PC_Pg_View_Percent
( type: esriFieldTypeString, alias: PC_Pg_View_Percent, length: 100 )
PC_Seconds_on_Pg
( type: esriFieldTypeDouble, alias: PC_Seconds_on_Pg )
PC_Bounce_Rate
( type: esriFieldTypeDouble, alias: PC_Bounce_Rate )
PC_Exit_Rate
( type: esriFieldTypeDouble, alias: PC_Exit_Rate )
F_ID
( type: esriFieldTypeInteger, alias: F_ID )
F_Appeal
( type: esriFieldTypeInteger, alias: F_Appeal )
F_ItemEv
( type: esriFieldTypeInteger, alias: F_ItemEv )
F_Fee
( type: esriFieldTypeInteger, alias: F_Fee )
GlobalID
( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
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 )
Relationships:
PW_GDB.PWGISEDITOR.PW_SW_Awareness_Ad_Map (1) --
Related To
:
SW_Advertisements
(1)