20210910
10202700
1.0
FALSE
ENG_TrafficSignals_ServiceRequests
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>
20201111
09540600
20201111
09540600
Esri ArcGIS 10.5.1.7333
ENG_TrafficSignals_ServiceRequests
Feature Class
dataset
EPSG
5.3(9.0.0)
0
Simple
FALSE
0
TRUE
FALSE
ENG_TrafficSignals_ServiceRequests
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
DISPATCH
Dispatcher
String
55
0
0
ISSUED_BY
Issued By
String
55
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
TROUBLE_CODE
Trouble Code
String
50
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
String
50
0
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
JURSIDICTION
Jurisdiction
String
50
0
0
QUARTER
Quarter
SmallInteger
2
5
0
PAY_APPLICATION
Pay Application
Integer
4
10
0
SS4
SS4
String
254
0
0
START_TIME
Start Time
Date
8
0
0
FINISH_TIME
Finish Time
Date
8
0
0
FIELDTECH1
Technician 1
String
50
0
0
FIELDTECH2
Technician 2
String
50
0
0
DM_MAINT
DM Maintenance
Integer
4
10
0
UNIT_NUMB
Unit Number
String
100
0
0
EQUIP_NUMB
Equipment Number
Integer
4
10
0
DM_NUMB
DM Number
Integer
4
10
0
EQUIP_NUMB2
Equipment Number 2
String
100
0
0
DM_NUMB2
DM Number 2
String
100
0
0
LOOP_TYPE
Loop Type
String
50
0
0
LOOP_NAME
Loop Name
String
50
0
0
LOOP_ID
Loop ID
String
50
0
0
REPAIRED
Repaired
Integer
4
10
0
REPAIR_DATE
Repair_Dat
Date
8
0
0
LOOP_SIZE
Loop_Size
String
50
0
0
SHAPE
SHAPE
Geometry
4
0
0
Feature geometry.
Esri
Coordinates defining the features.
20201111