Project Tracking-Suvey
This feature class tracks the documentation “lifecycle” from construction to record drawing. Gathering data along the lifecycle and most importantly raises red flags when the record drawing is “missing”. The end result brings transparency, data management, data stewardship and socialization to the buried Infrastructure GIS workflow process.Project Name - Name of the Project.Project Number - Assigned project number.Salesforce Development Permit Number - Salesforce assigned Development number.Construction Plan Delivery Date - The date the construction document was approved (Development Plans), or when the project was awarded (CIP Plans). This serves as the trigger to GIS staff a construction needs to be entered into GIS. (Note: This is inclusive for Stormwater, Water, Sewer, Reclaimed)W/S/R Construction Plan Editor - Initials of the responsible editor entering the Water, Sewer, or Reclaimed construction assets in GIS.W/S/R Construction Plan Digitized - Date the Water, Sewer, or Reclaimed construction assets were entered into GIS. Stormwater Construction Plan Editor - Initials of the responsible editor entering the Stormwater construction assets in GIS.Stormwater Construction Plan Digitized - Date the Stormwater construction assets were entered into GIS. Warranty Start Date - The date the warranty letter was written and serves as the trigger the record drawing should have been approved and accepted.Record Plan Delivery - The date the record plan document was approved and accepted. This serves as the trigger to GIS staff a record drawing needs to be entered into GIS. (Note: This is inclusive for Stormwater, Water, Sewer, Reclaimed, but not SCM)W/S/R Record Plan Editor - Initials of the responsible editor entering the Water, Sewer, or Reclaimed record plan assets in GIS.W/S/R Record Plan Digitized - Date the Water, Sewer, or Reclaimed record plan assets were entered into GIS. Stormwater Record Plan Editor - Initials of the responsible editor entering the Stormwater record plan assets in GIS.Stormwater Record Plan Digitized - Date the Stormwater record plan assets were entered into GIS. Record Plan Delivery Stormwater SCM - Date the stormwater SCM record plan document was approved and accepted.Stormwater SCM Record Plan Editor - Initials of the responsible editor entering the SCM record plan asset in GIS.Stormwater SCM Record Plan Digitized - Date the SCM record plan asset was entered into GIS. Record Plan Archival - Date of archiving the record drawing.Water - A T/F field to represent if the project has water assets.Sewer- A T/F field to represent if the project has sewer assets.Stormwater - A T/F field to represent if the project has stormwater assets.Reclaimed - A T/F field to represent if the project has Reclaimed assets.Project Type - Indicates if this project is development, Capital Improvement, PWUT In house, or NCDOT project.Construction Plan Link - Link to the construction plan document.Record Plan Link - Link to the record plan document.Salesforce Record Link - Link to the Salesforce record.Notes- A field to record additional notes.created_user, created_date, last_edited_user, last_edited_date - Standard ESRI automatic editor tracking fields.
[]
[{'name': 'OBJECTID', 'type': 'esriFieldTypeOID', 'alias': 'OBJECTID', 'domain': None}, {'name': 'PROJNAME', 'type': 'esriFieldTypeString', 'alias': 'Project Name', 'length': 75, 'domain': None}, {'name': 'PROJNUM', 'type': 'esriFieldTypeString', 'alias': 'Project Number', 'length': 75, 'domain': None}, {'name': 'SALESFORDEVPERM', 'type': 'esriFieldTypeString', 'alias': 'Salesforce Development Permit Number', 'length': 100, 'domain': None}, {'name': 'CONSPLANDEL', 'type': 'esriFieldTypeDate', 'alias': 'Construction Plan Delivery', 'length': 8, 'domain': None}, {'name': 'UTILCONSPLANEDITOR', 'type': 'esriFieldTypeString', 'alias': 'W/S/R Construction Plan Editor', 'length': 20, 'domain': None}, {'name': 'UTILCONSPLANDIGIT', 'type': 'esriFieldTypeDate', 'alias': 'W/S/R Construction Plan Digitized', 'length': 8, 'domain': None}, {'name': 'SWCONSPLANEDITOR', 'type': 'esriFieldTypeString', 'alias': 'Stormwater Construction Plan Editor', 'length': 20, 'domain': None}, {'name': 'SWCONSPLANDIGIT', 'type': 'esriFieldTypeDate', 'alias': 'Stormwater Construction Plan Digitized', 'length': 8, 'domain': None}, {'name': 'WARRSTART', 'type': 'esriFieldTypeDate', 'alias': 'Warranty Start Date', 'length': 8, 'domain': None}, {'name': 'RECPLANDELIVERY', 'type': 'esriFieldTypeDate', 'alias': 'Record Plan Delivery', 'length': 8, 'domain': None}, {'name': 'UTILRECPLANEDITOR', 'type': 'esriFieldTypeString', 'alias': 'W/S/R Record Plan Editor', 'length': 20, 'domain': None}, {'name': 'UTILRECPLANDIGIT', 'type': 'esriFieldTypeDate', 'alias': 'W/S/R Record Plan Digitized', 'length': 8, 'domain': None}, {'name': 'SWRECPLANEDITOR', 'type': 'esriFieldTypeString', 'alias': 'Stormwater Record Plan Editor', 'length': 20, 'domain': None}, {'name': 'SWRECPLANDIGIT', 'type': 'esriFieldTypeDate', 'alias': 'Stormwater Record Plan Digitized', 'length': 8, 'domain': None}, {'name': 'SWSCMRECPLANDEL', 'type': 'esriFieldTypeDate', 'alias': 'Record Plan Delivery Stormwater SCM', 'length': 8, 'domain': None}, {'name': 'SWSCMRECPLANEDITOR', 'type': 'esriFieldTypeString', 'alias': 'Stormwater SCM Record Plan Editor', 'length': 30, 'domain': None}, {'name': 'SWSCMRECPLANDIGIT', 'type': 'esriFieldTypeDate', 'alias': 'Stormwater SCM Record Plan Digitized', 'length': 8, 'domain': None}, {'name': 'RECPLANARCHIV', 'type': 'esriFieldTypeDate', 'alias': 'Record Plan Archival', 'length': 8, 'domain': None}, {'name': 'WATER', 'type': 'esriFieldTypeSmallInteger', 'alias': 'Water', 'domain': {'type': 'codedValue', 'name': 'BooleanDomain', 'description': 'A 0/1 boolean domain', 'codedValues': [{'name': 'False', 'code': 0}, {'name': 'True', 'code': 1}], 'mergePolicy': 'esriMPTDefaultValue', 'splitPolicy': 'esriSPTDuplicate'}}, {'name': 'SEWER', 'type': 'esriFieldTypeSmallInteger', 'alias': 'Sewer', 'domain': {'type': 'codedValue', 'name': 'BooleanDomain', 'description': 'A 0/1 boolean domain', 'codedValues': [{'name': 'False', 'code': 0}, {'name': 'True', 'code': 1}], 'mergePolicy': 'esriMPTDefaultValue', 'splitPolicy': 'esriSPTDuplicate'}}, {'name': 'STORMWATER', 'type': 'esriFieldTypeSmallInteger', 'alias': 'Stormwater', 'domain': {'type': 'codedValue', 'name': 'BooleanDomain', 'description': 'A 0/1 boolean domain', 'codedValues': [{'name': 'False', 'code': 0}, {'name': 'True', 'code': 1}], 'mergePolicy': 'esriMPTDefaultValue', 'splitPolicy': 'esriSPTDuplicate'}}, {'name': 'RECLAIMED', 'type': 'esriFieldTypeSmallInteger', 'alias': 'Reclaimed', 'domain': {'type': 'codedValue', 'name': 'BooleanDomain', 'description': 'A 0/1 boolean domain', 'codedValues': [{'name': 'False', 'code': 0}, {'name': 'True', 'code': 1}], 'mergePolicy': 'esriMPTDefaultValue', 'splitPolicy': 'esriSPTDuplicate'}}, {'name': 'PROJTYPE', 'type': 'esriFieldTypeString', 'alias': 'Project Type', 'length': 50, 'domain': {'type': 'codedValue', 'name': 'ProjectType', 'description': 'Project Type', 'codedValues': [{'name': 'Capital Improvement Project', 'code': 'CIP'}, {'name': 'Development Project', 'code': 'DP'}, {'name': 'Public Works/Utility In house Project', 'code': 'PWUT'}, {'name': 'NC Department of Transportation', 'code': 'NCDOT'}, {'name': 'Survey Project', 'code': 'SVY'}], 'mergePolicy': 'esriMPTDefaultValue', 'splitPolicy': 'esriSPTDuplicate'}}, {'name': 'CONSTLINK', 'type': 'esriFieldTypeString', 'alias': 'Construction Plan Link', 'length': 255, 'domain': None}, {'name': 'RECLINK', 'type': 'esriFieldTypeString', 'alias': 'Record Plan Link', 'length': 255, 'domain': None}, {'name': 'SALESFORLINK', 'type': 'esriFieldTypeString', 'alias': 'Salesforce Record Link', 'length': 255, 'domain': None}, {'name': 'NOTES', 'type': 'esriFieldTypeString', 'alias': 'Notes', 'length': 255, 'domain': None}, {'name': 'created_date', 'type': 'esriFieldTypeDate', 'alias': 'created_date', 'length': 8, 'domain': None}, {'name': 'created_user', 'type': 'esriFieldTypeString', 'alias': 'created_user', 'length': 255, 'domain': None}, {'name': 'last_edited_date', 'type': 'esriFieldTypeDate', 'alias': 'last_edited_date', 'length': 8, 'domain': None}, {'name': 'last_edited_user', 'type': 'esriFieldTypeString', 'alias': 'last_edited_user', 'length': 255, 'domain': None}, {'name': 'Shape', 'type': 'esriFieldTypeGeometry', 'alias': 'Shape', 'domain': None}, {'name': 'SCM', 'type': 'esriFieldTypeSmallInteger', 'alias': 'Stormwater SCM', 'domain': {'type': 'codedValue', 'name': 'BooleanDomain', 'description': 'A 0/1 boolean domain', 'codedValues': [{'name': 'False', 'code': 0}, {'name': 'True', 'code': 1}], 'mergePolicy': 'esriMPTDefaultValue', 'splitPolicy': 'esriSPTDuplicate'}}, {'name': 'SURVEYDEL', 'type': 'esriFieldTypeDate', 'alias': 'Survey Delivery Date', 'length': 8, 'domain': None}, {'name': 'SURVEYEDITOR', 'type': 'esriFieldTypeString', 'alias': 'Survey Editor', 'length': 20, 'domain': None}, {'name': 'SURVEYDIGITIZED', 'type': 'esriFieldTypeDate', 'alias': 'Survey Digitized Date', 'length': 8, 'domain': None}, {'name': 'Shape.STArea()', 'type': 'esriFieldTypeDouble', 'alias': 'Shape.STArea()', 'domain': None}, {'name': 'Shape.STLength()', 'type': 'esriFieldTypeDouble', 'alias': 'Shape.STLength()', 'domain': None}]
[{'name': 'R142_pk', 'fields': 'OBJECTID', 'isAscending': True, 'isUnique': True, 'description': ''}, {'name': 'S61_idx', 'fields': 'Shape', 'isAscending': True, 'isUnique': True, 'description': ''}]
[]
{'renderer': {'type': 'uniqueValue', 'field1': 'PROJTYPE', 'defaultSymbol': {'type': 'esriSFS', 'style': 'esriSFSSolid', 'color': [122, 245, 202, 255], 'outline': {'type': 'esriSLS', 'style': 'esriSLSNull', 'color': [110, 110, 110, 255], 'width': 0}}, 'defaultLabel': '<all other values>', 'uniqueValueInfos': [{'symbol': {'type': 'esriSFS', 'style': 'esriSFSSolid', 'color': [245, 245, 122, 255], 'outline': {'type': 'esriSLS', 'style': 'esriSLSSolid', 'color': [110, 110, 110, 255], 'width': 0.4}}, 'value': 'SVY', 'label': 'Survey Project'}], 'fieldDelimiter': ',', 'authoringInfo': {'colorRamp': {'type': 'multipart', 'colorRamps': [{'type': 'algorithmic', 'algorithm': 'esriCIELabAlgorithm', 'fromColor': [193, 201, 163, 255], 'toColor': [193, 201, 163, 255]}, {'type': 'algorithmic', 'algorithm': 'esriCIELabAlgorithm', 'fromColor': [214, 154, 213, 255], 'toColor': [214, 154, 213, 255]}, {'type': 'algorithmic', 'algorithm': 'esriCIELabAlgorithm', 'fromColor': [147, 174, 204, 255], 'toColor': [147, 174, 204, 255]}, {'type': 'algorithmic', 'algorithm': 'esriCIELabAlgorithm', 'fromColor': [194, 138, 139, 255], 'toColor': [194, 138, 139, 255]}, {'type': 'algorithmic', 'algorithm': 'esriCIELabAlgorithm', 'fromColor': [150, 212, 208, 255], 'toColor': [150, 212, 208, 255]}, {'type': 'algorithmic', 'algorithm': 'esriCIELabAlgorithm', 'fromColor': [151, 207, 154, 255], 'toColor': [151, 207, 154, 255]}, {'type': 'algorithmic', 'algorithm': 'esriCIELabAlgorithm', 'fromColor': [156, 142, 191, 255], 'toColor': [156, 142, 191, 255]}, {'type': 'algorithmic', 'algorithm': 'esriCIELabAlgorithm', 'fromColor': [209, 178, 204, 255], 'toColor': [209, 178, 204, 255]}, {'type': 'algorithmic', 'algorithm': 'esriCIELabAlgorithm', 'fromColor': [207, 179, 169, 255], 'toColor': [207, 179, 169, 255]}, {'type': 'algorithmic', 'algorithm': 'esriCIELabAlgorithm', 'fromColor': [159, 191, 172, 255], 'toColor': [159, 191, 172, 255]}, {'type': 'algorithmic', 'algorithm': 'esriCIELabAlgorithm', 'fromColor': [199, 143, 172, 255], 'toColor': [199, 143, 172, 255]}, {'type': 'algorithmic', 'algorithm': 'esriCIELabAlgorithm', 'fromColor': [155, 191, 199, 255], 'toColor': [155, 191, 199, 255]}, {'type': 'algorithmic', 'algorithm': 'esriCIELabAlgorithm', 'fromColor': [210, 212, 150, 255], 'toColor': [210, 212, 150, 255]}]}}}, 'scaleSymbols': True, 'transparency': 50, 'labelingInfo': None}
nan
nan