20260112
10332000
1.0
FALSE
PW_HeavyEquip_ServiceRequest
002
Projected
GCS_North_American_1983
Linear Unit: Foot_US (0.304801)
NAD_1983_StatePlane_Tennessee_FIPS_4100_Feet
<ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/10.5'><WKT>PROJCS["NAD_1983_StatePlane_Tennessee_FIPS_4100_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",1968500.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-86.0],PARAMETER["Standard_Parallel_1",35.25],PARAMETER["Standard_Parallel_2",36.41666666666666],PARAMETER["Latitude_Of_Origin",34.33333333333334],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",2274]]</WKT><XOrigin>-121521300</XOrigin><YOrigin>-93934000</YOrigin><XYScale>3048.0060960121928</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.0032808333333333331</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102736</WKID><LatestWKID>2274</LatestWKID></ProjectedCoordinateSystem>
20210218
16302900
20210218
16302900
Version 6.2 (Build 9200) ; Esri ArcGIS 10.5.1.7333
PW_HeavyEquip_ServiceRequest
Feature Class
dataset
EPSG
5.3(9.0.0)
0
Simple
FALSE
0
TRUE
FALSE
PW_HeavyEquip_ServiceRequest
Feature Class
0
OBJECTID
OBJECTID
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
REC_EDIT_MODE
Live Link: Change to MANUAL
String
50
0
0
REC_EDIT_MODE_COMMENTS
REC_EDIT_MODE_COMMENTS
String
255
0
0
X
X
Double
8
38
8
Y
Y
Double
8
38
8
DIVISION
Division
String
150
0
0
DEPARTMENT
Department
String
150
0
0
CATEGORY
Category
String
50
0
0
INCIDENT_ID
Oracle ID
Integer
4
10
0
INCIDENT_NUMBER
Service Request Number
String
15
0
0
INCIDENT_TYPE_ID
Service Request Type ID
Integer
4
10
0
REQUEST_TYPE
Service Request Type
String
50
0
0
REQUEST_STATUS
Service Request Status
String
20
0
0
REQUEST_PRIORITY
Service Request Priority
String
15
0
0
REPORTED_DATE
Reported Date
Date
8
0
0
REQUEST_SUMMARY
Service Request Summary
String
2000
0
0
SR_CREATION_CHANNEL
SR_CREATION_CHANNEL
String
50
0
0
CREATED_BY_USER
Created By
String
255
0
0
DAYS_OLD
Days Old
SmallInteger
2
5
0
CREATION_DATE
Creation Date
Date
8
0
0
CREATED_BY
CREATED_BY
Integer
4
10
0
LAST_UPDATE_DATE
Last Updated Date
Date
8
0
0
UPDATED_BY_USER
Updated By
String
50
0
0
LAST_UPDATED_BY
LAST_UPDATED_BY
Integer
4
10
0
LAST_UPDATE_LOGIN
LAST_UPDATE_LOGIN
Integer
4
10
0
LAST_MODIFIED_DATE
LAST_MODIFIED_DATE
Date
8
0
0
FOLLOWUP_DATE
Follow Up Date
Date
8
0
0
NEXT_OPEN_TASK_DATE
NEXT_OPEN_TASK_DATE
Date
8
0
0
JOB_NOTES
Job Notes
String
255
0
0
REQUEST_NOTES
Consolidated Notes
String
2000
0
0
ASSIGNED_TO
Assigned To
String
50
0
0
ASSIGNED_DATE
Assigned Date
Date
8
0
0
SUPERVISOR
Supervisor
String
50
0
0
NOTIFICATION
Notification To
String
50
0
0
QAQC_YESNO
QA/QC
String
50
0
0
QAQC_RATING
QA/QC Rating
Integer
4
10
0
SUPERVISOR_APPROVAL
Supervisor Approval
String
5
0
0
SUPERVISOR_NOTES
Supervisor Notes
String
255
0
0
RESOLVED_DATE
Resolved Date
Date
8
0
0
CLOSE_DATE
Closed Date
Date
8
0
0
RESOLUTION_CODE
Resolution Code
String
100
0
0
RESOLUTION_CODE_MEANING
RESOLUTION_CODE_MEANING
String
255
0
0
RESOLUTION_SUMMARY
Resolution Summary
String
2000
0
0
GROUP_NAME
GROUP_NAME
String
50
0
0
OWNER_NAME
OWNER_NAME
String
50
0
0
STREET_NAME
STREET_NAME
String
100
0
0
ADDRESS1
Location
String
255
0
0
ADDRESS2
ADDRESS2
String
100
0
0
ADDRESS3
ADDRESS3
String
100
0
0
CITY
City
String
100
0
0
STATE
State
String
50
0
0
POSTAL_CODE
Postal Code
String
20
0
0
PARCEL_ID
Parcel ID
String
20
0
0
ASSET_ID
Asset ID
String
20
0
0
P_LOCATION_ID
P_LOCATION_ID
Integer
4
10
0
P_PARTY_ID
P_PARTY_ID
Integer
4
10
0
CONTACT_NAME_FIRST
Owner Name
String
255
0
0
CONTACT_NAME_LAST
Owner Name 2
String
255
0
0
PERSON_ADDRESS1
Owner Address1
String
255
0
0
PERSON_ADDRESS2
Owner Address2
String
255
0
0
PERSON_ADDRESS3
Owner Address3
String
255
0
0
PERSON_STATE
Owner State
String
50
0
0
PERSON_CITY
Owner City
String
100
0
0
PERSON_ZIP_CODE
Owner Zip Code
String
50
0
0
MAP_PG
Map Page
String
50
0
0
MAP_BLK
Map Block
String
50
0
0
GRID_NO
Grid Number
SmallInteger
2
5
0
CODE_DISTRICT
Code District
SmallInteger
2
5
0
CODE_SUBDISTRICT
Code Sub-District
String
50
0
0
TARGET_BLOCK
Target Block
String
50
0
0
DRAIN_ZONE
Drain Zone
String
50
0
0
DRAIN_GRID
Drain Grid
String
50
0
0
STREET_ZONE
Street Zone
String
50
0
0
STREET_GRID
Street Grid
String
50
0
0
TRAFFIC_ZONE
Traffic Zone
String
50
0
0
SWM_AREA
SWM Area
String
10
0
0
SWM_ZONE
SWM Zone
String
10
0
0
COLLECTION_DAY
Collection Day
String
20
0
0
SWM_ROUTE
SWM Route
String
10
0
0
PREM_CODE
Premise Code
Integer
4
10
0
CUST_CODE
Customer Code
Integer
4
10
0
MLGW_ON
MLGW Est Date
String
25
0
0
MLGW_STATUS
MLGW Acct. Status
String
25
0
0
SWF_RATE
SWM Fee Rate
String
10
0
0
SWF_STATUS
SWM Fee Status
String
10
0
0
MLGW_CUSTOMER
MLGW Customer
String
255
0
0
MLGW_CONTACT1
MLGW Contact 1
String
25
0
0
MLGW_CONTACT2
MLGW Contact 2
String
25
0
0
MLGW_EMAIL
MLGW Contact Email
String
100
0
0
NUMBER_OF_TASKS
NUMBER_OF_TASKS
Integer
4
10
0
LINKED_SR
Linked SR
String
50
0
0
RELATION
Relation with SR
String
50
0
0
cd_name
Council District No
Integer
4
10
0
cd_desc
Council District
String
100
0
0
sccd_name
Shelby Co. Council No
Integer
4
10
0
sccd_desc
Shelby Co. Council District
String
100
0
0
scd_name
Super District No
Integer
4
10
0
scd_desc
Super Council District
String
100
0
0
neigh_name
neigh_name
String
100
0
0
neigh_desc
Neighborhood Name
String
100
0
0
tract_name
Tract Number
Integer
4
10
0
tract_desc
Tract
String
100
0
0
voting_name
voting_name
String
100
0
0
voting_desc
Voting
String
100
0
0
zip_name
Zip Code No
Integer
4
10
0
zip_desc
Zip Code
String
100
0
0
ce_name
ce_name
String
100
0
0
ce_desc
ce_desc
String
100
0
0
cityzone
City Zone
String
100
0
0
CONTACT_NAME
SCF Name
String
100
0
0
CONTACT_EMAIL
SCF Email
String
100
0
0
CONTACT_PHONE
SCF Phone
String
50
0
0
SCF_URL
SeeClickFix URL
String
1000
0
0
SCF_Description
SeeClickFix Description
String
2000
0
0
EX_ATTRIBUTE12
EX_ATTRIBUTE12
String
100
0
0
X_COORD
X_COORD
Double
8
38
8
Y_COORD
Y_COORD
Double
8
38
8
Reported_By
Reported By
String
50
0
0
Dispatch_Date
Dispatch Date
Date
8
0
0
Action_Taken
Action Taken
String
50
0
0
Barricade
Barricade
String
50
0
0
Repair_Method
Repair Method
String
50
0
0
Repaired_Date
Repaired Date
Date
8
0
0
Time_Received
Time Received
Date
8
0
0
Length
Length
SmallInteger
2
5
0
Width
Width
SmallInteger
2
5
0
Depth
Depth
SmallInteger
2
5
0
Size
Size
String
50
0
0
No_Barricades
No Barricades
SmallInteger
2
5
0
Barricade_Date
Barricade Date
Date
8
0
0
State_Route
Barricade By
String
50
0
0
Barricade_By_Radio_No
Barricade By Radio No
SmallInteger
2
5
0
ReferredTo
Referred To
String
50
0
0
ReferredFromNotes
Referred From Notes
String
1000
0
0
ReferredContact
Referred Contact
String
100
0
0
LoadsHauled
LoadsHauled
Double
8
38
8
TotalFeetCleaned
TotalFeetCleaned
Double
8
38
8
DitchName
DitchName
String
50
0
0
WorkNotes
WorkNotes
String
50
0
0
ReferredFrom
ReferredFrom
String
50
0
0
ExpectedCompletionDate
ExpectedCompletionDate
Date
8
0
0
DumpLocation
DumpLocation
String
50
0
0
BackHoeHours
BackHoeHours
Double
8
38
8
FrontEndLoaderHours
FrontEndLoaderHours
Double
8
38
8
DozerHours
DozerHours
Double
8
38
8
Start_Mile
Start_Mile
Double
8
38
8
End_Mile
End_Mile
Double
8
38
8
Total_Mile
Total_Mile
Double
8
38
8
SmallDozerHrs
SmallDozerHrs
Double
8
38
8
GreaseTrkHrs
GreaseTrkHrs
Double
8
38
8
TandemTrkHrs
TandemTrkHrs
Double
8
38
8
LowBoyHrs
LowBoyHrs
Double
8
38
8
MiniExcHrs
MiniExcHrs
Double
8
38
8
SkidSteerHrs
SkidSteerHrs
Double
8
38
8
GraderHrs
GraderHrs
Double
8
38
8
TrailerDumperHrs
TrailerDumperHrs
Double
8
38
8
WaterTrkHrs
WaterTrkHrs
Double
8
38
8
WheeledExcHrs
WheeledExcHrs
Double
8
38
8
TrkSteerHrs
TrkSteerHrs
Double
8
38
8
GroveCraneHrs
GroveCraneHrs
Double
8
38
8
BoatHrs
BoatHrs
Double
8
38
8
HydSeedHrs
HydSeedHrs
Double
8
38
8
HeavyOpHrs
HeavyOpHrs
Double
8
38
8
EquipOpHrs
EquipOpHrs
Double
8
38
8
TempHours
TempHours
Double
8
38
8
Cat349Hrs
Cat349Hrs
Double
8
38
8
CatCompactHrs
CatCompactHrs
Double
8
38
8
a3830TrctrHrs
a3830TrctrHrs
Double
8
38
8
BoomMowerHrs
BoomMowerHrs
Double
8
38
8
HEMechHrs
HEMechHrs
Double
8
38
8
BrbRoadRakeHrs
BrbRoadRakeHrs
Double
8
38
8
BobcatMiniHrs
BobcatMiniHrs
Double
8
38
8
GreaserHrs
GreaserHrs
Double
8
38
8
LeafVacHrs
LeafVacHrs
Double
8
38
8
SHAPE
SHAPE
Geometry
4
0
0
Feature geometry.
Esri
Coordinates defining the features.
20210218