{ "layers": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 1, "name": "CIP Project Locations", "type": "Feature Layer", "description": "This is a point feature that represents the location of CIP projects and is used in multi-scale maps.", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102642, "latestWkid": 2226, "xyTolerance": 0.0032808333333333335, "zTolerance": 2.0E-5, "mTolerance": 2.0E-5, "falseX": -17463800, "falseY": -46132600, "xyUnits": 3048.0060960121914, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 150000, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "56fda9e70d9e3ac406341f60b0cb3e1b", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAAwAAAAMCAYAAABWdVznAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAA0UlEQVQokWNhIBGwUKqBiyGkqJhBSc+egYmFleHZnTMMa6b0MHx78xybBlaGjN6VDI6RPnARQyc7BgVtO4Z51QEMT249RdUQmJPP4BCBUAwD2tYmDO4J1Qxzq7JQNSjoWzIwMmJ3uISSNaaTGBlwqGYAASZMDU/vHWH4/TOQgZUdU/nL+8cwNaxs72MQFPFgsAlyhWv6/5+B4dS2qwznz5VhagCBGcVuDN+/1zFIyjszMDGyMLx4dJbh8+tyhrOrv2PXAAILa5oYGBhAGCsgOaYBPOs14dBfYBAAAAAASUVORK5CYII=", "contentType": "image/png", "width": 9, "height": 9, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -214588.95977716148, "ymin": -214715.70504674315, "xmax": 6496793.750304587, "ymax": 1938909.2022617608, "spatialReference": { "wkid": 102642, "latestWkid": 2226, "xyTolerance": 0.003280833333333333, "zTolerance": 2.0E-5, "mTolerance": 2.0E-5, "falseX": -115211800, "falseY": -93821500, "xyUnits": 3047.9052786321176, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "PROJNAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PROJNAME", "type": "esriFieldTypeString", "alias": "Project Name", "length": 50, "domain": null }, { "name": "TOTCOST", "type": "esriFieldTypeDouble", "alias": "Total Cost", "domain": null }, { "name": "TOTLEN", "type": "esriFieldTypeDouble", "alias": "Total Length", "domain": null }, { "name": "TOTAREA", "type": "esriFieldTypeDouble", "alias": "Total Area", "domain": null }, { "name": "TOTPNT", "type": "esriFieldTypeDouble", "alias": "Point Count", "domain": null }, { "name": "DATESTART", "type": "esriFieldTypeDate", "alias": "Expected Start Date", "length": 8, "domain": null }, { "name": "DATECOMP", "type": "esriFieldTypeDate", "alias": "Date Completed", "length": 8, "domain": null }, { "name": "CIPSTAT", "type": "esriFieldTypeString", "alias": "CIP Status", "length": 50, "domain": { "type": "codedValue", "name": "CIPStatus", "description": "The status of the CIP", "codedValues": [ { "name": "Proposed", "code": "Proposed" }, { "name": "Completed", "code": "Completed" }, { "name": "Approved", "code": "Approved" }, { "name": "Funded", "code": "Funded" }, { "name": "Under Construction", "code": "Under Construction" }, { "name": "Canceled", "code": "Canceled" }, { "name": "In Design", "code": "In Design" }, { "name": "Pavement Moratorium", "code": "Pavement Moratorium" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "Notes", "length": 200, "domain": null }, { "name": "PRJMAN", "type": "esriFieldTypeString", "alias": "Project Manager", "length": 50, "domain": { "type": "codedValue", "name": "CIPProjManager", "description": "A domain used to identify the name of the project manager", "codedValues": [ { "name": "A LeBlanc", "code": "A LeBlanc" }, { "name": "C Jones", "code": "C Jones" }, { "name": "Public Works", "code": "Public Works" }, { "name": "S Lemmon", "code": "S Lemmon" }, { "name": "Utilities", "code": "Utilities" }, { "name": "V Gonzalez", "code": "V Gonzalez" }, { "name": "Water Treatment", "code": "Water Treatment" }, { "name": "D DeMaster", "code": "D DeMaster" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CREATNAME", "type": "esriFieldTypeString", "alias": "Created By", "length": 50, "domain": null }, { "name": "CREATDATE", "type": "esriFieldTypeDate", "alias": "Date Created", "length": 8, "domain": null }, { "name": "LINK", "type": "esriFieldTypeString", "alias": "Link to Report", "length": 175, "domain": null }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "length": 50, "domain": null }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update", "length": 8, "domain": null }, { "name": "PROJTYPE", "type": "esriFieldTypeString", "alias": "Project Type", "length": 80, "domain": { "type": "codedValue", "name": "CIPProjectType", "description": "The type of CIP", "codedValues": [ { "name": "Streets", "code": "Streets" }, { "name": "Other", "code": "Other" }, { "name": "Water", "code": "Water" }, { "name": "Sanitary Sewer", "code": "Sanitary Sewer" }, { "name": "Stormwater", "code": "Stormwater" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MANPHONE", "type": "esriFieldTypeString", "alias": "Contact Phone", "length": 80, "domain": null }, { "name": "MANEMAIL", "type": "esriFieldTypeString", "alias": "Contact Email", "length": 80, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "CIPID", "type": "esriFieldTypeString", "alias": "CIP ID", "length": 20, "domain": null }, { "name": "CIP_INTERAGENCYMAP", "type": "esriFieldTypeString", "alias": "CIP INTERAGENCY MAP", "length": 3, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "NA", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CIPFISCALYEAR", "type": "esriFieldTypeInteger", "alias": "CIPFISCALYEAR", "domain": null }, { "name": "FUNDSOURCE", "type": "esriFieldTypeString", "alias": "Funding Source", "length": 80, "domain": { "type": "codedValue", "name": "CIPFundingSource", "description": "The funding source for the CIP", "codedValues": [ { "name": "System Revenues", "code": "System Revenues" }, { "name": "Other", "code": "Other" }, { "name": "Water Enterprise Fund", "code": "Water Enterprise Fund" }, { "name": "Other Agencies", "code": "Other Agencies" }, { "name": "Solid Waste and Recycling Enterprise Fund", "code": "Solid Waste and Recycling Enterprise Fund" }, { "name": "FEMA", "code": "FEMA" }, { "name": "General Fund", "code": "General Fund" }, { "name": "Measure T", "code": "Measure T" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CIP_IMPROVEMENTTYPE", "type": "esriFieldTypeString", "alias": "CIP Improvement Type", "length": 30, "domain": null }, { "name": "CONSTRUCTION_CREW", "type": "esriFieldTypeString", "alias": "CONSTRUCTION CREW", "length": 50, "domain": { "type": "codedValue", "name": "ConstructionCrew", "description": "Used in Water CIP", "codedValues": [ { "name": "City", "code": "City" }, { "name": "Contractor", "code": "Contractor" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CIPComponent", "type": "esriFieldTypeString", "alias": "CIP COMPONENT", "length": 20, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R130_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G424PROJNAME", "fields": "PROJNAME", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_424_CIPPRIOR", "fields": "CIPComponent", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_130", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_130", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S52_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "CIPProjects", "relatedTableId": 10, "role": "esriRelRoleDestination", "keyField": "PROJNAME", "cardinality": "esriRelCardinalityOneToOne", "composite": true, "catalogID": "{659954DE-D14C-4C4C-8A12-9FC178028CC9}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Pacific Standard Time", "respectsDaylightSaving": false }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "7bfe6ff4978a409bafcbc7c5a2e65962" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 10, "name": "CIP Project Outlines", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 102642, "latestWkid": 2226, "xyTolerance": 0.0032808333333333335, "zTolerance": 2.0E-5, "mTolerance": 2.0E-5, "falseX": -17463800, "falseY": -46132600, "xyUnits": 3048.0060960121914, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 150000, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 255, 190, 190, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 0, 0, 255 ], "width": 0.4 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -214758.36495016143, "ymin": -214758.3647383228, "xmax": 6732138.306517422, "ymax": 1941265.3855415136, "spatialReference": { "wkid": 102642, "latestWkid": 2226, "xyTolerance": 0.003280833333333333, "zTolerance": 2.0E-5, "mTolerance": 2.0E-5, "falseX": -115211800, "falseY": -93821500, "xyUnits": 3047.9052786321176, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "PROJNAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PROJNAME", "type": "esriFieldTypeString", "alias": "Project Name", "length": 50, "domain": null }, { "name": "TOTCOST", "type": "esriFieldTypeInteger", "alias": "Total Cost", "domain": null }, { "name": "TOTLEN", "type": "esriFieldTypeDouble", "alias": "Total Length", "domain": null }, { "name": "TOTAREA", "type": "esriFieldTypeDouble", "alias": "Total Area", "domain": null }, { "name": "TOTPNT", "type": "esriFieldTypeDouble", "alias": "Point Count", "domain": null }, { "name": "DATESTART", "type": "esriFieldTypeDate", "alias": "Expected Start Date", "length": 8, "domain": null }, { "name": "DATECOMP", "type": "esriFieldTypeDate", "alias": "Date Completed", "length": 8, "domain": null }, { "name": "CIPSTATUS", "type": "esriFieldTypeString", "alias": "CIP Status", "length": 50, "domain": { "type": "codedValue", "name": "CIPStatus", "description": "The status of the CIP", "codedValues": [ { "name": "Proposed", "code": "Proposed" }, { "name": "Completed", "code": "Completed" }, { "name": "Approved", "code": "Approved" }, { "name": "Funded", "code": "Funded" }, { "name": "Under Construction", "code": "Under Construction" }, { "name": "Canceled", "code": "Canceled" }, { "name": "In Design", "code": "In Design" }, { "name": "Pavement Moratorium", "code": "Pavement Moratorium" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "Notes", "length": 200, "domain": null }, { "name": "PRJMAN", "type": "esriFieldTypeString", "alias": "Project Manager", "length": 50, "domain": { "type": "codedValue", "name": "CIPProjManager", "description": "A domain used to identify the name of the project manager", "codedValues": [ { "name": "A LeBlanc", "code": "A LeBlanc" }, { "name": "C Jones", "code": "C Jones" }, { "name": "Public Works", "code": "Public Works" }, { "name": "S Lemmon", "code": "S Lemmon" }, { "name": "Utilities", "code": "Utilities" }, { "name": "V Gonzalez", "code": "V Gonzalez" }, { "name": "Water Treatment", "code": "Water Treatment" }, { "name": "D DeMaster", "code": "D DeMaster" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CREATNAME", "type": "esriFieldTypeString", "alias": "Created By", "length": 50, "domain": null }, { "name": "CREATDATE", "type": "esriFieldTypeDate", "alias": "Date Created", "length": 8, "domain": null }, { "name": "LINK", "type": "esriFieldTypeString", "alias": "Link to Report", "length": 175, "domain": null }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "length": 50, "domain": null }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update", "length": 8, "domain": null }, { "name": "PROJTYPE", "type": "esriFieldTypeString", "alias": "Project Type", "length": 80, "domain": { "type": "codedValue", "name": "CIPProjectType", "description": "The type of CIP", "codedValues": [ { "name": "Streets", "code": "Streets" }, { "name": "Other", "code": "Other" }, { "name": "Water", "code": "Water" }, { "name": "Sanitary Sewer", "code": "Sanitary Sewer" }, { "name": "Stormwater", "code": "Stormwater" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FUNDSOURCE", "type": "esriFieldTypeString", "alias": "Funding Source", "length": 80, "domain": { "type": "codedValue", "name": "CIPFundingSource", "description": "The funding source for the CIP", "codedValues": [ { "name": "System Revenues", "code": "System Revenues" }, { "name": "Other", "code": "Other" }, { "name": "Water Enterprise Fund", "code": "Water Enterprise Fund" }, { "name": "Other Agencies", "code": "Other Agencies" }, { "name": "Solid Waste and Recycling Enterprise Fund", "code": "Solid Waste and Recycling Enterprise Fund" }, { "name": "FEMA", "code": "FEMA" }, { "name": "General Fund", "code": "General Fund" }, { "name": "Measure T", "code": "Measure T" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MANPHONE", "type": "esriFieldTypeString", "alias": "Contact Phone", "length": 80, "domain": null }, { "name": "MANEMAIL", "type": "esriFieldTypeString", "alias": "Contact Email", "length": 80, "domain": { "type": "codedValue", "name": "CIPProjManEMAIL", "description": "Email address choices for CIP Projects", "codedValues": [ { "name": "aleblanc@cityofnapa.org", "code": "aleblanc@cityofnapa.org" }, { "name": "chrisjones@cityofnapa.org", "code": "chrisjones@cityofnapa.org" }, { "name": "slemmon@cityofnapa.org", "code": "slemmon@cityofnapa.org" }, { "name": "vgonzalez@cityofnapa.org", "code": "vgonzalez@cityofnapa.org" }, { "name": "ddemaster@cityofnapa.org", "code": "ddemaster@cityofnapa.org" }, { "name": "water@cityofnapa.org", "code": "water@cityofnapa.org" }, { "name": "engineering@cityofnapa.org", "code": "engineering@cityofnapa.org" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "CIPID", "type": "esriFieldTypeString", "alias": "CIP ID", "length": 20, "domain": null }, { "name": "CIPFISCALYEAR", "type": "esriFieldTypeSmallInteger", "alias": "CIP FYEAR", "domain": null }, { "name": "CIP_INTERAGENCYMAP", "type": "esriFieldTypeString", "alias": "CIP INTERAGENCY MAP", "length": 3, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "NA", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CIP_IMPROVEMENT_TYPE", "type": "esriFieldTypeString", "alias": "CIP IMPROVE TYPE", "length": 30, "domain": { "type": "codedValue", "name": "CIP_ImprovementType ", "description": "Type of CIP Improvement", "codedValues": [ { "name": "Abandon", "code": "Abandon" }, { "name": "New", "code": "New" }, { "name": "Reduce", "code": "Reduce" }, { "name": "Rehab", "code": "Rehab" }, { "name": "Replace", "code": "Replace" }, { "name": "Upgrade", "code": "Upgrade" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SHAPE.STArea()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STArea()", "domain": null }, { "name": "SHAPE.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null }, { "name": "Plan_Year", "type": "esriFieldTypeString", "alias": "Plan Year", "length": 50, "domain": { "type": "codedValue", "name": "CIPPlannedFiscalYear", "description": "Capital Improvement planned fiscal year", "codedValues": [ { "name": "FY 12-13", "code": "FY 12-13" }, { "name": "FY 13-14", "code": "FY 13-14" }, { "name": "FY 14-15", "code": "FY 14-15" }, { "name": "FY 15-16", "code": "FY 15-16" }, { "name": "FY 16-17", "code": "FY 16-17" }, { "name": "FY 17-18", "code": "FY 17-18" }, { "name": "FY 18-19", "code": "FY 18-19" }, { "name": "FY 19-20", "code": "FY 19-20" }, { "name": "FY 20-21", "code": "FY 20-21" }, { "name": "FY 21-22", "code": "FY 21-22" }, { "name": "FY 22-23", "code": "FY 22-23" }, { "name": "FY 23-24", "code": "FY 23-24" }, { "name": "FY 24-25", "code": "FY 24-25" }, { "name": "FY 25-26", "code": "FY 25-26" }, { "name": "FY 26-27", "code": "FY 26-27" }, { "name": "FY 27-28", "code": "FY 27-28" }, { "name": "FY 28-29", "code": "FY 28-29" }, { "name": "FY 29-30", "code": "FY 29-30" }, { "name": "FY 30-31", "code": "FY 30-31" }, { "name": "FY 31-32", "code": "FY 31-32" }, { "name": "FY 32-33", "code": "FY 32-33" }, { "name": "FY 33-34", "code": "FY 33-34" }, { "name": "FY 34-35", "code": "FY 34-35" }, { "name": "FY 35-40", "code": "FY 35-40" }, { "name": "FY 40-45", "code": "FY 40-45" }, { "name": "FY 45-50", "code": "FY 45-50" }, { "name": "FY 50-55", "code": "FY 50-55" }, { "name": "FY 55-60", "code": "FY 55-60" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CONSTRUCTION_CREW", "type": "esriFieldTypeString", "alias": "CONSTRUCTION_CREW", "length": 50, "domain": { "type": "codedValue", "name": "ConstructionCrew", "description": "Used in Water CIP", "codedValues": [ { "name": "City", "code": "City" }, { "name": "Contractor", "code": "Contractor" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CIPComponent", "type": "esriFieldTypeString", "alias": "CIPComponent", "length": 20, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 1000, "domain": null }, { "name": "BudgetFund", "type": "esriFieldTypeString", "alias": "Budget Fund", "length": 50, "domain": { "type": "codedValue", "name": "CIPBudgetFund", "description": "Budget Fund for CIP Projects", "codedValues": [ { "name": "Water Distribution", "code": "WD" }, { "name": "Water Transmission", "code": "WT" }, { "name": "Water Quality", "code": "WQ" }, { "name": "Water Supply", "code": "WS" }, { "name": "Water Administration", "code": "WA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Diameter", "type": "esriFieldTypeDouble", "alias": "Diameter", "domain": null }, { "name": "PipeMaterial", "type": "esriFieldTypeString", "alias": "Pipe Material", "length": 32, "domain": null }, { "name": "CIPMethod", "type": "esriFieldTypeString", "alias": "CIP Method", "length": 50, "domain": { "type": "codedValue", "name": "piCIPMethod", "description": "Denotes the CIP Method", "codedValues": [ { "name": "Open Cut", "code": "OC" }, { "name": "Horizontal Directional Drilling", "code": "HDD" }, { "name": "Pipe Burst", "code": "PB" }, { "name": "Abandon", "code": "AB" }, { "name": "Slip-Line", "code": "SL" }, { "name": "CIPP", "code": "CIPP" }, { "name": "Above Ground", "code": "AG" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CostLinear", "type": "esriFieldTypeInteger", "alias": "Cost Linear", "domain": null }, { "name": "CostOther", "type": "esriFieldTypeInteger", "alias": "Cost Other", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R145_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G439PROJNAME", "fields": "PROJNAME", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_439_CIPPRIOR", "fields": "CIPComponent", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_145", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_145", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S67_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "CIPProjectsLocations", "relatedTableId": 1, "role": "esriRelRoleOrigin", "keyField": "PROJNAME", "cardinality": "esriRelCardinalityOneToOne", "composite": true, "catalogID": "{659954DE-D14C-4C4C-8A12-9FC178028CC9}" }, { "id": 1, "name": "CIPProjectsOverview", "relatedTableId": 11, "role": "esriRelRoleDestination", "keyField": "PROJNAME", "cardinality": "esriRelCardinalityOneToOne", "composite": true, "catalogID": "{D3D0F591-A151-4933-9ADF-4C47E67C2141}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Pacific Standard Time", "respectsDaylightSaving": false }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "SHAPE.STArea()", "shapeLengthFieldName": "SHAPE.STLength()", "units": "esriFeet", "mapUnits": {"uwkid": 9003} }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "7bfe6ff4978a409bafcbc7c5a2e65962" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 11, "name": "CIP Project Overviews", "type": "Feature Layer", "description": "A polygon that represents an overview of the CIP project.", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 102642, "latestWkid": 2226, "xyTolerance": 0.0032808333333333335, "zTolerance": 2.0E-5, "mTolerance": 2.0E-5, "falseX": -17463800, "falseY": -46132600, "xyUnits": 3048.0060960121914, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 150000, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 215, 192, 252, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.4 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -214818.36483016238, "ymin": -214818.36461832374, "xmax": 6732198.306069337, "ymax": 1903287.6675338447, "spatialReference": { "wkid": 102642, "latestWkid": 2226, "xyTolerance": 0.003280833333333333, "zTolerance": 2.0E-5, "mTolerance": 2.0E-5, "falseX": -115211800, "falseY": -93821500, "xyUnits": 3047.9052786321176, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "PROJNAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PROJNAME", "type": "esriFieldTypeString", "alias": "Project Name", "length": 50, "domain": null }, { "name": "TOTCOST", "type": "esriFieldTypeDouble", "alias": "Total Cost", "domain": null }, { "name": "TOTLEN", "type": "esriFieldTypeDouble", "alias": "Total Length", "domain": null }, { "name": "TOTAREA", "type": "esriFieldTypeDouble", "alias": "Total Area", "domain": null }, { "name": "TOTPNT", "type": "esriFieldTypeDouble", "alias": "Point Count", "domain": null }, { "name": "DATESTART", "type": "esriFieldTypeDate", "alias": "Expected Start Date", "length": 8, "domain": null }, { "name": "DATECOMP", "type": "esriFieldTypeDate", "alias": "Date Completed", "length": 8, "domain": null }, { "name": "CIPSTATUS", "type": "esriFieldTypeString", "alias": "CIP Status", "length": 50, "domain": { "type": "codedValue", "name": "CIPStatus", "description": "The status of the CIP", "codedValues": [ { "name": "Proposed", "code": "Proposed" }, { "name": "Completed", "code": "Completed" }, { "name": "Approved", "code": "Approved" }, { "name": "Funded", "code": "Funded" }, { "name": "Under Construction", "code": "Under Construction" }, { "name": "Canceled", "code": "Canceled" }, { "name": "In Design", "code": "In Design" }, { "name": "Pavement Moratorium", "code": "Pavement Moratorium" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "Notes", "length": 200, "domain": null }, { "name": "PRJMAN", "type": "esriFieldTypeString", "alias": "Project Manager", "length": 50, "domain": { "type": "codedValue", "name": "CIPProjManager", "description": "A domain used to identify the name of the project manager", "codedValues": [ { "name": "A LeBlanc", "code": "A LeBlanc" }, { "name": "C Jones", "code": "C Jones" }, { "name": "Public Works", "code": "Public Works" }, { "name": "S Lemmon", "code": "S Lemmon" }, { "name": "Utilities", "code": "Utilities" }, { "name": "V Gonzalez", "code": "V Gonzalez" }, { "name": "Water Treatment", "code": "Water Treatment" }, { "name": "D DeMaster", "code": "D DeMaster" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CREATNAME", "type": "esriFieldTypeString", "alias": "Created By", "length": 50, "domain": null }, { "name": "CREATDATE", "type": "esriFieldTypeDate", "alias": "Date Created", "length": 8, "domain": null }, { "name": "LINK", "type": "esriFieldTypeString", "alias": "Link to Report", "length": 175, "domain": null }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "length": 50, "domain": null }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update", "length": 8, "domain": null }, { "name": "PROJTYPE", "type": "esriFieldTypeString", "alias": "Project Type", "length": 80, "domain": { "type": "codedValue", "name": "CIPProjectType", "description": "The type of CIP", "codedValues": [ { "name": "Streets", "code": "Streets" }, { "name": "Other", "code": "Other" }, { "name": "Water", "code": "Water" }, { "name": "Sanitary Sewer", "code": "Sanitary Sewer" }, { "name": "Stormwater", "code": "Stormwater" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FUNDSOUR", "type": "esriFieldTypeString", "alias": "Funding Source", "length": 80, "domain": { "type": "codedValue", "name": "CIPFundingSource", "description": "The funding source for the CIP", "codedValues": [ { "name": "System Revenues", "code": "System Revenues" }, { "name": "Other", "code": "Other" }, { "name": "Water Enterprise Fund", "code": "Water Enterprise Fund" }, { "name": "Other Agencies", "code": "Other Agencies" }, { "name": "Solid Waste and Recycling Enterprise Fund", "code": "Solid Waste and Recycling Enterprise Fund" }, { "name": "FEMA", "code": "FEMA" }, { "name": "General Fund", "code": "General Fund" }, { "name": "Measure T", "code": "Measure T" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MANPHONE", "type": "esriFieldTypeString", "alias": "Contact Phone", "length": 80, "domain": null }, { "name": "MANEMAIL", "type": "esriFieldTypeString", "alias": "Contact Email", "length": 80, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "CIPID", "type": "esriFieldTypeString", "alias": "CIP ID", "length": 20, "domain": null }, { "name": "CIPPRIORITY", "type": "esriFieldTypeString", "alias": "CIPPRIORITY", "length": 20, "domain": null }, { "name": "CIP_INTERAGENCYMAP", "type": "esriFieldTypeString", "alias": "CICIP INTERAGENCY MAP", "length": 3, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "NA", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CIPFISCALYEAR", "type": "esriFieldTypeInteger", "alias": "CIPFISCALYEAR", "domain": null }, { "name": "SHAPE.STArea()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STArea()", "domain": null }, { "name": "SHAPE.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null }, { "name": "PLAN_YEAR", "type": "esriFieldTypeString", "alias": "PLAN_YEAR", "length": 50, "domain": null }, { "name": "CONSTRUCTION_CREW", "type": "esriFieldTypeString", "alias": "CONSTRUCTION CREW", "length": 50, "domain": { "type": "codedValue", "name": "ConstructionCrew", "description": "Used in Water CIP", "codedValues": [ { "name": "City", "code": "City" }, { "name": "Contractor", "code": "Contractor" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R144_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G438PROJNAME", "fields": "PROJNAME", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_144", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_144", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S66_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "CIPProjects", "relatedTableId": 10, "role": "esriRelRoleOrigin", "keyField": "PROJNAME", "cardinality": "esriRelCardinalityOneToOne", "composite": true, "catalogID": "{D3D0F591-A151-4933-9ADF-4C47E67C2141}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Pacific Standard Time", "respectsDaylightSaving": false }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "SHAPE.STArea()", "shapeLengthFieldName": "SHAPE.STLength()", "units": "esriFeet", "mapUnits": {"uwkid": 9003} }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "7bfe6ff4978a409bafcbc7c5a2e65962" } ], "tables": [] }