CIP_Projects
CIP_Projects
[{'name': 'OBJECTID', 'type': 'esriFieldTypeOID', 'alias': 'Object ID', 'sqlType': 'sqlTypeOther', 'nullable': False, 'editable': False, 'domain': None, 'defaultValue': None}, {'name': 'PROJ_NAME', 'type': 'esriFieldTypeString', 'alias': 'Project Name', 'sqlType': 'sqlTypeOther', 'length': 100, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'DEPT', 'type': 'esriFieldTypeString', 'alias': 'Owner Department', 'sqlType': 'sqlTypeOther', 'length': 50, 'nullable': True, 'editable': True, 'domain': {'type': 'codedValue', 'name': 'CIP_Projects_DEPT_418c543c-c9eb-4d5e-8540-1c9a2ed40a44', 'codedValues': [{'name': 'Planning and Development', 'code': 'plan'}, {'name': 'Fire', 'code': 'fire'}, {'name': 'General Government', 'code': 'gen'}, {'name': 'Housing & Neighborhoods', 'code': 'hous'}, {'name': 'Information Technology', 'code': 'it'}, {'name': 'Parks, Recreation & Cultural Resources', 'code': 'prcr'}, {'name': 'Police', 'code': 'police'}, {'name': 'Raleigh Water', 'code': 'pub'}, {'name': 'Raleigh Convention Center', 'code': 'rcc'}, {'name': 'Stormwater', 'code': 'str'}, {'name': 'Transportation', 'code': 'trans'}]}, 'defaultValue': None}, {'name': 'URL', 'type': 'esriFieldTypeString', 'alias': 'Project URL', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'GlobalID', 'type': 'esriFieldTypeGlobalID', 'alias': 'GlobalID', 'sqlType': 'sqlTypeOther', 'length': 38, 'nullable': False, 'editable': False, 'domain': None, 'defaultValue': 'NEWID() WITH VALUES'}]
[{'name': 'PK__CAPITAL___F4B70D85CE670BAD', 'fields': 'OBJECTID', 'isAscending': True, 'isUnique': True, 'description': '', 'indexType': 'Attribute'}, {'name': 'user_370.CAPITAL_IMPROVEMENT_PROJECTS_CIP_PROJECTS_Shape_sidx', 'fields': 'SHAPE', 'isAscending': True, 'isUnique': False, 'description': '', 'indexType': 'Spatial'}, {'name': 'GlobalID_Index', 'fields': 'GlobalID', 'isAscending': False, 'isUnique': True, 'description': '', 'indexType': 'Attribute'}, {'name': 'DEPT_Index', 'fields': 'DEPT', 'isAscending': True, 'isUnique': False, 'description': 'DEPT_Index', 'indexType': 'Attribute'}, {'name': 'PROJ_NAME_Index', 'fields': 'PROJ_NAME', 'isAscending': True, 'isUnique': False, 'description': 'PROJ_NAME_Index', 'indexType': 'Attribute'}]
nan
{'renderer': {'visualVariables': [{'type': 'sizeInfo', 'target': 'outline', 'expression': 'view.scale', 'valueExpression': '$view.scale', 'stops': [{'size': 1.5, 'value': 736}, {'size': 0.75, 'value': 2299}, {'size': 0.375, 'value': 9197}, {'size': 0, 'value': 18395}]}], 'type': 'uniqueValue', 'field1': 'DEPT', 'defaultSymbol': None, 'uniqueValueInfos': [{'value': 'plan', 'label': 'City Planning', 'symbol': {'color': [20, 158, 206, 255], 'outline': {'color': [153, 153, 153, 64], 'width': 0.75, 'type': 'esriSLS', 'style': 'esriSLSSolid'}, 'type': 'esriSFS', 'style': 'esriSFSSolid'}}, {'value': 'fire', 'label': 'Fire', 'symbol': {'color': [237, 81, 81, 255], 'outline': {'color': [153, 153, 153, 64], 'width': 0.75, 'type': 'esriSLS', 'style': 'esriSLSSolid'}, 'type': 'esriSFS', 'style': 'esriSFSSolid'}}, {'value': 'hous', 'label': 'Housing & Neighborhoods', 'symbol': {'color': [158, 85, 156, 255], 'outline': {'color': [153, 153, 153, 64], 'width': 0.75, 'type': 'esriSLS', 'style': 'esriSLSSolid'}, 'type': 'esriSFS', 'style': 'esriSFSSolid'}}, {'value': 'it', 'label': 'Information Technology', 'symbol': {'color': [252, 146, 31, 255], 'outline': {'color': [153, 153, 153, 64], 'width': 0.75, 'type': 'esriSLS', 'style': 'esriSLSSolid'}, 'type': 'esriSFS', 'style': 'esriSFSSolid'}}, {'value': 'prcr', 'label': 'Parks, Recreation and Cultural Resources', 'symbol': {'color': [167, 198, 54, 255], 'outline': {'color': [153, 153, 153, 64], 'width': 0.75, 'type': 'esriSLS', 'style': 'esriSLSSolid'}, 'type': 'esriSFS', 'style': 'esriSFSSolid'}}, {'value': 'police', 'label': 'Police', 'symbol': {'color': [255, 222, 62, 255], 'outline': {'color': [153, 153, 153, 64], 'width': 0.75, 'type': 'esriSLS', 'style': 'esriSLSSolid'}, 'type': 'esriSFS', 'style': 'esriSFSSolid'}}, {'value': 'pub', 'label': 'Public Utilities', 'symbol': {'color': [247, 137, 216, 255], 'outline': {'color': [153, 153, 153, 64], 'width': 0.75, 'type': 'esriSLS', 'style': 'esriSLSSolid'}, 'type': 'esriSFS', 'style': 'esriSFSSolid'}}, {'value': 'rcc', 'label': 'Raleigh Convention Center', 'symbol': {'color': [183, 129, 74, 255], 'outline': {'color': [153, 153, 153, 64], 'width': 0.75, 'type': 'esriSLS', 'style': 'esriSLSSolid'}, 'type': 'esriSFS', 'style': 'esriSFSSolid'}}, {'value': 'str', 'label': 'Stormwater', 'symbol': {'color': [60, 175, 153, 255], 'outline': {'color': [153, 153, 153, 64], 'width': 0.75, 'type': 'esriSLS', 'style': 'esriSLSSolid'}, 'type': 'esriSFS', 'style': 'esriSFSSolid'}}, {'value': 'trans', 'label': 'Transportation', 'symbol': {'color': [107, 107, 214, 255], 'outline': {'color': [153, 153, 153, 64], 'width': 0.75, 'type': 'esriSLS', 'style': 'esriSLSSolid'}, 'type': 'esriSFS', 'style': 'esriSFSSolid'}}]}, 'transparency': 0}
[{'id': 'plan', 'name': 'City Planning', 'domains': {}, 'templates': [{'name': 'City Planning', 'description': '', 'drawingTool': 'esriFeatureEditToolNone', 'prototype': {'attributes': {'PROJ_ID': None, 'PROJ_NAME': None, 'PROJ_DESC': None, 'PROJ_CAT': None, 'DEPT': 'plan', 'STATUS': None, 'STATUS_NOTES': None, 'DESIGN_PERC_COMPLETE': None, 'DESIGN_PLANSTART': None, 'DESIGN_PLANEND': None, 'DESIGN_ACTSTART': None, 'DESIGN_ACTEND': None, 'CONST_PERC_COMPLETE': None, 'CONST_PLANSTART': None, 'CONST_PLANEND': None, 'CONST_ACTSTART': None, 'CONST_ACTEND': None, 'ESTCOST': None, 'ACTCOST': None, 'FUNDING_SOURCE': None, 'FUNDING_SOURCE_2': None, 'FUNDING_SOURCE_NOTES': None, 'LOCATION': None, 'COUNCIL_DISTRICT': None, 'CAC_DISTRICT': None, 'PROJECT_MANAGER': None, 'PM_EMAIL': None, 'PM_PHONE': None, 'CONSULTANT': None, 'CONTRACTOR': None, 'MWBE_PARTICIPATION': None, 'MWBE_PERC': None, 'PERC_ART': None, 'FACILITY_FEE_ELIGIBLE': None, 'URL': None, 'THUMB': None, 'DESIGN_ESTCOST': None, 'DESIGN_ACTCOST': None, 'CONST_ESTCOST': None, 'CONST_ACTCOST': None, 'AfterHoursContact': None, 'AfterHoursPhone': None}}}]}, {'id': 'fire', 'name': 'Fire', 'domains': {}, 'templates': [{'name': 'Fire', 'description': '', 'drawingTool': 'esriFeatureEditToolNone', 'prototype': {'attributes': {'PROJ_ID': None, 'PROJ_NAME': None, 'PROJ_DESC': None, 'PROJ_CAT': None, 'DEPT': 'fire', 'STATUS': None, 'STATUS_NOTES': None, 'DESIGN_PERC_COMPLETE': None, 'DESIGN_PLANSTART': None, 'DESIGN_PLANEND': None, 'DESIGN_ACTSTART': None, 'DESIGN_ACTEND': None, 'CONST_PERC_COMPLETE': None, 'CONST_PLANSTART': None, 'CONST_PLANEND': None, 'CONST_ACTSTART': None, 'CONST_ACTEND': None, 'ESTCOST': None, 'ACTCOST': None, 'FUNDING_SOURCE': None, 'FUNDING_SOURCE_2': None, 'FUNDING_SOURCE_NOTES': None, 'LOCATION': None, 'COUNCIL_DISTRICT': None, 'CAC_DISTRICT': None, 'PROJECT_MANAGER': None, 'PM_EMAIL': None, 'PM_PHONE': None, 'CONSULTANT': None, 'CONTRACTOR': None, 'MWBE_PARTICIPATION': None, 'MWBE_PERC': None, 'PERC_ART': None, 'FACILITY_FEE_ELIGIBLE': None, 'URL': None, 'THUMB': None, 'DESIGN_ESTCOST': None, 'DESIGN_ACTCOST': None, 'CONST_ESTCOST': None, 'CONST_ACTCOST': None, 'AfterHoursContact': None, 'AfterHoursPhone': None}}}]}, {'id': 'hous', 'name': 'Housing & Neighborhoods', 'domains': {}, 'templates': [{'name': 'Housing & Neighborhoods', 'description': '', 'drawingTool': 'esriFeatureEditToolNone', 'prototype': {'attributes': {'PROJ_ID': None, 'PROJ_NAME': None, 'PROJ_DESC': None, 'PROJ_CAT': None, 'DEPT': 'hous', 'STATUS': None, 'STATUS_NOTES': None, 'DESIGN_PERC_COMPLETE': None, 'DESIGN_PLANSTART': None, 'DESIGN_PLANEND': None, 'DESIGN_ACTSTART': None, 'DESIGN_ACTEND': None, 'CONST_PERC_COMPLETE': None, 'CONST_PLANSTART': None, 'CONST_PLANEND': None, 'CONST_ACTSTART': None, 'CONST_ACTEND': None, 'ESTCOST': None, 'ACTCOST': None, 'FUNDING_SOURCE': None, 'FUNDING_SOURCE_2': None, 'FUNDING_SOURCE_NOTES': None, 'LOCATION': None, 'COUNCIL_DISTRICT': None, 'CAC_DISTRICT': None, 'PROJECT_MANAGER': None, 'PM_EMAIL': None, 'PM_PHONE': None, 'CONSULTANT': None, 'CONTRACTOR': None, 'MWBE_PARTICIPATION': None, 'MWBE_PERC': None, 'PERC_ART': None, 'FACILITY_FEE_ELIGIBLE': None, 'URL': None, 'THUMB': None, 'DESIGN_ESTCOST': None, 'DESIGN_ACTCOST': None, 'CONST_ESTCOST': None, 'CONST_ACTCOST': None, 'AfterHoursContact': None, 'AfterHoursPhone': None}}}]}, {'id': 'it', 'name': 'Information Technology', 'domains': {}, 'templates': [{'name': 'Information Technology', 'description': '', 'drawingTool': 'esriFeatureEditToolNone', 'prototype': {'attributes': {'PROJ_ID': None, 'PROJ_NAME': None, 'PROJ_DESC': None, 'PROJ_CAT': None, 'DEPT': 'it', 'STATUS': None, 'STATUS_NOTES': None, 'DESIGN_PERC_COMPLETE': None, 'DESIGN_PLANSTART': None, 'DESIGN_PLANEND': None, 'DESIGN_ACTSTART': None, 'DESIGN_ACTEND': None, 'CONST_PERC_COMPLETE': None, 'CONST_PLANSTART': None, 'CONST_PLANEND': None, 'CONST_ACTSTART': None, 'CONST_ACTEND': None, 'ESTCOST': None, 'ACTCOST': None, 'FUNDING_SOURCE': None, 'FUNDING_SOURCE_2': None, 'FUNDING_SOURCE_NOTES': None, 'LOCATION': None, 'COUNCIL_DISTRICT': None, 'CAC_DISTRICT': None, 'PROJECT_MANAGER': None, 'PM_EMAIL': None, 'PM_PHONE': None, 'CONSULTANT': None, 'CONTRACTOR': None, 'MWBE_PARTICIPATION': None, 'MWBE_PERC': None, 'PERC_ART': None, 'FACILITY_FEE_ELIGIBLE': None, 'URL': None, 'THUMB': None, 'DESIGN_ESTCOST': None, 'DESIGN_ACTCOST': None, 'CONST_ESTCOST': None, 'CONST_ACTCOST': None, 'AfterHoursContact': None, 'AfterHoursPhone': None}}}]}, {'id': 'prcr', 'name': 'Parks, Recreation and Cultural Resources', 'domains': {}, 'templates': [{'name': 'Parks, Recreation and Cultural Resources', 'description': '', 'drawingTool': 'esriFeatureEditToolNone', 'prototype': {'attributes': {'PROJ_ID': None, 'PROJ_NAME': None, 'PROJ_DESC': None, 'PROJ_CAT': None, 'DEPT': 'prcr', 'STATUS': None, 'STATUS_NOTES': None, 'DESIGN_PERC_COMPLETE': None, 'DESIGN_PLANSTART': None, 'DESIGN_PLANEND': None, 'DESIGN_ACTSTART': None, 'DESIGN_ACTEND': None, 'CONST_PERC_COMPLETE': None, 'CONST_PLANSTART': None, 'CONST_PLANEND': None, 'CONST_ACTSTART': None, 'CONST_ACTEND': None, 'ESTCOST': None, 'ACTCOST': None, 'FUNDING_SOURCE': None, 'FUNDING_SOURCE_2': None, 'FUNDING_SOURCE_NOTES': None, 'LOCATION': None, 'COUNCIL_DISTRICT': None, 'CAC_DISTRICT': None, 'PROJECT_MANAGER': None, 'PM_EMAIL': None, 'PM_PHONE': None, 'CONSULTANT': None, 'CONTRACTOR': None, 'MWBE_PARTICIPATION': None, 'MWBE_PERC': None, 'PERC_ART': None, 'FACILITY_FEE_ELIGIBLE': None, 'URL': None, 'THUMB': None, 'DESIGN_ESTCOST': None, 'DESIGN_ACTCOST': None, 'CONST_ESTCOST': None, 'CONST_ACTCOST': None, 'AfterHoursContact': None, 'AfterHoursPhone': None}}}]}, {'id': 'police', 'name': 'Police', 'domains': {}, 'templates': [{'name': 'Police', 'description': '', 'drawingTool': 'esriFeatureEditToolNone', 'prototype': {'attributes': {'PROJ_ID': None, 'PROJ_NAME': None, 'PROJ_DESC': None, 'PROJ_CAT': None, 'DEPT': 'police', 'STATUS': None, 'STATUS_NOTES': None, 'DESIGN_PERC_COMPLETE': None, 'DESIGN_PLANSTART': None, 'DESIGN_PLANEND': None, 'DESIGN_ACTSTART': None, 'DESIGN_ACTEND': None, 'CONST_PERC_COMPLETE': None, 'CONST_PLANSTART': None, 'CONST_PLANEND': None, 'CONST_ACTSTART': None, 'CONST_ACTEND': None, 'ESTCOST': None, 'ACTCOST': None, 'FUNDING_SOURCE': None, 'FUNDING_SOURCE_2': None, 'FUNDING_SOURCE_NOTES': None, 'LOCATION': None, 'COUNCIL_DISTRICT': None, 'CAC_DISTRICT': None, 'PROJECT_MANAGER': None, 'PM_EMAIL': None, 'PM_PHONE': None, 'CONSULTANT': None, 'CONTRACTOR': None, 'MWBE_PARTICIPATION': None, 'MWBE_PERC': None, 'PERC_ART': None, 'FACILITY_FEE_ELIGIBLE': None, 'URL': None, 'THUMB': None, 'DESIGN_ESTCOST': None, 'DESIGN_ACTCOST': None, 'CONST_ESTCOST': None, 'CONST_ACTCOST': None, 'AfterHoursContact': None, 'AfterHoursPhone': None}}}]}, {'id': 'pub', 'name': 'Public Utilities', 'domains': {}, 'templates': [{'name': 'Public Utilities', 'description': '', 'drawingTool': 'esriFeatureEditToolNone', 'prototype': {'attributes': {'PROJ_ID': None, 'PROJ_NAME': None, 'PROJ_DESC': None, 'PROJ_CAT': None, 'DEPT': 'pub', 'STATUS': None, 'STATUS_NOTES': None, 'DESIGN_PERC_COMPLETE': None, 'DESIGN_PLANSTART': None, 'DESIGN_PLANEND': None, 'DESIGN_ACTSTART': None, 'DESIGN_ACTEND': None, 'CONST_PERC_COMPLETE': None, 'CONST_PLANSTART': None, 'CONST_PLANEND': None, 'CONST_ACTSTART': None, 'CONST_ACTEND': None, 'ESTCOST': None, 'ACTCOST': None, 'FUNDING_SOURCE': None, 'FUNDING_SOURCE_2': None, 'FUNDING_SOURCE_NOTES': None, 'LOCATION': None, 'COUNCIL_DISTRICT': None, 'CAC_DISTRICT': None, 'PROJECT_MANAGER': None, 'PM_EMAIL': None, 'PM_PHONE': None, 'CONSULTANT': None, 'CONTRACTOR': None, 'MWBE_PARTICIPATION': None, 'MWBE_PERC': None, 'PERC_ART': None, 'FACILITY_FEE_ELIGIBLE': None, 'URL': None, 'THUMB': None, 'DESIGN_ESTCOST': None, 'DESIGN_ACTCOST': None, 'CONST_ESTCOST': None, 'CONST_ACTCOST': None, 'AfterHoursContact': None, 'AfterHoursPhone': None}}}]}, {'id': 'rcc', 'name': 'Raleigh Convention Center', 'domains': {}, 'templates': [{'name': 'Raleigh Convention Center', 'description': '', 'drawingTool': 'esriFeatureEditToolNone', 'prototype': {'attributes': {'PROJ_ID': None, 'PROJ_NAME': None, 'PROJ_DESC': None, 'PROJ_CAT': None, 'DEPT': 'rcc', 'STATUS': None, 'STATUS_NOTES': None, 'DESIGN_PERC_COMPLETE': None, 'DESIGN_PLANSTART': None, 'DESIGN_PLANEND': None, 'DESIGN_ACTSTART': None, 'DESIGN_ACTEND': None, 'CONST_PERC_COMPLETE': None, 'CONST_PLANSTART': None, 'CONST_PLANEND': None, 'CONST_ACTSTART': None, 'CONST_ACTEND': None, 'ESTCOST': None, 'ACTCOST': None, 'FUNDING_SOURCE': None, 'FUNDING_SOURCE_2': None, 'FUNDING_SOURCE_NOTES': None, 'LOCATION': None, 'COUNCIL_DISTRICT': None, 'CAC_DISTRICT': None, 'PROJECT_MANAGER': None, 'PM_EMAIL': None, 'PM_PHONE': None, 'CONSULTANT': None, 'CONTRACTOR': None, 'MWBE_PARTICIPATION': None, 'MWBE_PERC': None, 'PERC_ART': None, 'FACILITY_FEE_ELIGIBLE': None, 'URL': None, 'THUMB': None, 'DESIGN_ESTCOST': None, 'DESIGN_ACTCOST': None, 'CONST_ESTCOST': None, 'CONST_ACTCOST': None, 'AfterHoursContact': None, 'AfterHoursPhone': None}}}]}, {'id': 'str', 'name': 'Stormwater', 'domains': {}, 'templates': [{'name': 'Stormwater', 'description': '', 'drawingTool': 'esriFeatureEditToolNone', 'prototype': {'attributes': {'PROJ_ID': None, 'PROJ_NAME': None, 'PROJ_DESC': None, 'PROJ_CAT': None, 'DEPT': 'str', 'STATUS': None, 'STATUS_NOTES': None, 'DESIGN_PERC_COMPLETE': None, 'DESIGN_PLANSTART': None, 'DESIGN_PLANEND': None, 'DESIGN_ACTSTART': None, 'DESIGN_ACTEND': None, 'CONST_PERC_COMPLETE': None, 'CONST_PLANSTART': None, 'CONST_PLANEND': None, 'CONST_ACTSTART': None, 'CONST_ACTEND': None, 'ESTCOST': None, 'ACTCOST': None, 'FUNDING_SOURCE': None, 'FUNDING_SOURCE_2': None, 'FUNDING_SOURCE_NOTES': None, 'LOCATION': None, 'COUNCIL_DISTRICT': None, 'CAC_DISTRICT': None, 'PROJECT_MANAGER': None, 'PM_EMAIL': None, 'PM_PHONE': None, 'CONSULTANT': None, 'CONTRACTOR': None, 'MWBE_PARTICIPATION': None, 'MWBE_PERC': None, 'PERC_ART': None, 'FACILITY_FEE_ELIGIBLE': None, 'URL': None, 'THUMB': None, 'DESIGN_ESTCOST': None, 'DESIGN_ACTCOST': None, 'CONST_ESTCOST': None, 'CONST_ACTCOST': None, 'AfterHoursContact': None, 'AfterHoursPhone': None}}}]}, {'id': 'trans', 'name': 'Transportation', 'domains': {}, 'templates': [{'name': 'Transportation', 'description': '', 'drawingTool': 'esriFeatureEditToolNone', 'prototype': {'attributes': {'PROJ_ID': None, 'PROJ_NAME': None, 'PROJ_DESC': None, 'PROJ_CAT': None, 'DEPT': 'trans', 'STATUS': None, 'STATUS_NOTES': None, 'DESIGN_PERC_COMPLETE': None, 'DESIGN_PLANSTART': None, 'DESIGN_PLANEND': None, 'DESIGN_ACTSTART': None, 'DESIGN_ACTEND': None, 'CONST_PERC_COMPLETE': None, 'CONST_PLANSTART': None, 'CONST_PLANEND': None, 'CONST_ACTSTART': None, 'CONST_ACTEND': None, 'ESTCOST': None, 'ACTCOST': None, 'FUNDING_SOURCE': None, 'FUNDING_SOURCE_2': None, 'FUNDING_SOURCE_NOTES': None, 'LOCATION': None, 'COUNCIL_DISTRICT': None, 'CAC_DISTRICT': None, 'PROJECT_MANAGER': None, 'PM_EMAIL': None, 'PM_PHONE': None, 'CONSULTANT': None, 'CONTRACTOR': None, 'MWBE_PARTICIPATION': None, 'MWBE_PERC': None, 'PERC_ART': None, 'FACILITY_FEE_ELIGIBLE': None, 'URL': None, 'THUMB': None, 'DESIGN_ESTCOST': None, 'DESIGN_ACTCOST': None, 'CONST_ESTCOST': None, 'CONST_ACTCOST': None, 'AfterHoursContact': None, 'AfterHoursPhone': None}}}]}]
[]
{'lastEditDate': 1699934478324, 'schemaLastEditDate': 1699934478324, 'dataLastEditDate': 1699934478324}