{
"currentVersion": 10.91,
"id": 6,
"name": "LACoPW Project Merged Polygons",
"type": "Feature Layer",
"description": "Integrating GIS feature classes with flat table data from other databases is a common goal. Previously, this was done using spatial views and DB links; however, the draw and query performance suffered. To work around performance bottlenecks, an ETL (extract-transform-load) process was chosen so that a single feature class is created. It means that the data is no longer live, but updated periodically.An ITD Task Scheduler runs the update link every weekday (Monday through Friday). Users involved in a project typically request SMP for geometry at the following link (replace PROJECT_ID with the appropriate alphanumeric string): https://apps.intranet/prjmgt/piw3/location.aspx?project_id=PROJECT_ID The feature class is used in the following applications:ViewLA http://pwgis01/viewlaPIW Intranet https://apps.intranet/prjmgt/piw3Active Construction Projects https://pw.lacounty.gov/cons/acp",
"geometryType": "esriGeometryPolygon",
"sourceSpatialReference": {
"wkid": 102645,
"latestWkid": 2229
},
"copyrightText": "LA County Public Works ITD GIS Unit (gis@pw.lacounty.gov) maintains the update routines for this feature class, combining the geometry created by SMP and attributes from the PIW database.\nITD Web Services group oversees the PIW database.\nhttp://intranet2/DivPhoneList/CIO.pdf \n\nThe original geometry is created and edited by Survey/Mapping Division, Mapping & GIS Services section.\nhttp://intranet2/DivPhoneList/SMPM.pdf",
"parentLayer": null,
"subLayers": [],
"minScale": 0,
"maxScale": 0,
"drawingInfo": {
"renderer": {
"type": "uniqueValue",
"field1": "PROJECT_STATUS_SIMPLE",
"field2": "PROJECT_TYPE_SIMPLE",
"field3": null,
"defaultSymbol": null,
"defaultLabel": null,
"uniqueValueInfos": [
{
"symbol": {
"type": "esriSFS",
"style": "esriSFSSolid",
"color": [
0,
112,
255,
255
],
"outline": {
"type": "esriSLS",
"style": "esriSLSSolid",
"color": [
0,
112,
255,
255
],
"width": 2
}
},
"value": "Construction,Water Resources",
"label": "In Construction - Water Resources",
"description": ""
},
{
"symbol": {
"type": "esriSFS",
"style": "esriSFSSolid",
"color": [
212,
3,
0,
255
],
"outline": {
"type": "esriSLS",
"style": "esriSLSSolid",
"color": [
212,
3,
0,
255
],
"width": 2
}
},
"value": "Construction,Transportation",
"label": "In Construction - Transportation",
"description": ""
},
{
"symbol": {
"type": "esriSFS",
"style": "esriSFSSolid",
"color": [
197,
0,
255,
255
],
"outline": {
"type": "esriSLS",
"style": "esriSLSSolid",
"color": [
197,
0,
255,
255
],
"width": 2
}
},
"value": "Construction,Road",
"label": "In Construction - Road",
"description": ""
},
{
"symbol": {
"type": "esriSFS",
"style": "esriSFSSolid",
"color": [
168,
168,
0,
255
],
"outline": {
"type": "esriSLS",
"style": "esriSLSSolid",
"color": [
168,
168,
0,
255
],
"width": 2
}
},
"value": "Construction,Capital Improvement",
"label": "In Construction - Capital Improvement",
"description": ""
},
{
"symbol": {
"type": "esriSFS",
"style": "esriSFSSolid",
"color": [
0,
197,
255,
255
],
"outline": {
"type": "esriSLS",
"style": "esriSLSSolid",
"color": [
0,
197,
255,
255
],
"width": 2
}
},
"value": "Development,Water Resources",
"label": "In Development - Water Resources",
"description": ""
},
{
"symbol": {
"type": "esriSFS",
"style": "esriSFSSolid",
"color": [
255,
167,
127,
255
],
"outline": {
"type": "esriSLS",
"style": "esriSLSSolid",
"color": [
255,
167,
127,
255
],
"width": 2
}
},
"value": "Development,Transportation",
"label": "In Development - Transportation",
"description": ""
},
{
"symbol": {
"type": "esriSFS",
"style": "esriSFSSolid",
"color": [
205,
102,
153,
255
],
"outline": {
"type": "esriSLS",
"style": "esriSLSSolid",
"color": [
205,
102,
153,
255
],
"width": 2
}
},
"value": "Development,Road",
"label": "In Development - Road",
"description": ""
},
{
"symbol": {
"type": "esriSFS",
"style": "esriSFSSolid",
"color": [
255,
255,
0,
255
],
"outline": {
"type": "esriSLS",
"style": "esriSLSSolid",
"color": [
255,
255,
0,
255
],
"width": 2
}
},
"value": "Development,Capital Improvement",
"label": "In Development - Capital Improvement",
"description": ""
}
],
"fieldDelimiter": ","
},
"transparency": 50,
"labelingInfo": null
},
"defaultVisibility": false,
"extent": {
"xmin": -1.336005185015117E7,
"ymin": 3856909.9849584512,
"xmax": -1.3078925901544338E7,
"ymax": 4410093.154234494,
"spatialReference": {
"wkid": 102100,
"latestWkid": 3857
}
},
"hasAttachments": false,
"htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText",
"displayField": "PROJECT_NAME",
"typeIdField": null,
"subtypeFieldName": null,
"subtypeField": null,
"defaultSubtypeCode": null,
"fields": [
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null
},
{
"name": "PROJECT_ID",
"type": "esriFieldTypeString",
"alias": "PROJECT_ID",
"length": 15,
"domain": null
},
{
"name": "PROJECT_NAME",
"type": "esriFieldTypeString",
"alias": "PROJECT_NAME",
"length": 150,
"domain": null
},
{
"name": "PROJECT_STATUS",
"type": "esriFieldTypeString",
"alias": "PROJECT_STATUS",
"length": 25,
"domain": null
},
{
"name": "PROJECT_SCOPE",
"type": "esriFieldTypeString",
"alias": "PROJECT_SCOPE",
"length": 250,
"domain": null
},
{
"name": "BOARD_ACCEPT",
"type": "esriFieldTypeDate",
"alias": "BOARD_ACCEPT",
"length": 8,
"domain": null
},
{
"name": "ACTUAL_BOARD_ACCEPT",
"type": "esriFieldTypeDate",
"alias": "ACTUAL_BOARD_ACCEPT",
"length": 8,
"domain": null
},
{
"name": "FED_STIMULUS_TYPE",
"type": "esriFieldTypeString",
"alias": "FED_STIMULUS_TYPE",
"length": 30,
"domain": null
},
{
"name": "ACTUAL_START",
"type": "esriFieldTypeDate",
"alias": "ACTUAL_START",
"length": 8,
"domain": null
},
{
"name": "ACTUAL_FINISH",
"type": "esriFieldTypeDate",
"alias": "ACTUAL_FINISH",
"length": 8,
"domain": null
},
{
"name": "PROJECTED_FINISH",
"type": "esriFieldTypeDate",
"alias": "PROJECTED_FINISH",
"length": 8,
"domain": null
},
{
"name": "RISK_CATEGORY",
"type": "esriFieldTypeString",
"alias": "RISK_CATEGORY",
"length": 10,
"domain": null
},
{
"name": "LEGAL_NAME",
"type": "esriFieldTypeString",
"alias": "LEGAL_NAME",
"length": 128,
"domain": null
},
{
"name": "DBA_NAME",
"type": "esriFieldTypeString",
"alias": "DBA_NAME",
"length": 128,
"domain": null
},
{
"name": "AWARD",
"type": "esriFieldTypeDate",
"alias": "AWARD",
"length": 8,
"domain": null
},
{
"name": "FIELD_ACCEPT",
"type": "esriFieldTypeDate",
"alias": "FIELD_ACCEPT",
"length": 8,
"domain": null
},
{
"name": "CONSTRUCTION_BEGIN",
"type": "esriFieldTypeDate",
"alias": "CONSTRUCTION_BEGIN",
"length": 8,
"domain": null
},
{
"name": "PROJECT_SUBTYPE",
"type": "esriFieldTypeString",
"alias": "PROJECT_SUBTYPE",
"length": 50,
"domain": null
},
{
"name": "CONSTRUCTION_BEGIN_PUBLIC",
"type": "esriFieldTypeDate",
"alias": "CONSTRUCTION_BEGIN_PUBLIC",
"length": 8,
"domain": null
},
{
"name": "SUP_DISTS",
"type": "esriFieldTypeString",
"alias": "SUP_DISTS",
"length": 50,
"domain": null
},
{
"name": "CENTROID_LAT",
"type": "esriFieldTypeString",
"alias": "CENTROID_LAT",
"length": 50,
"domain": null
},
{
"name": "CENTROID_LNG",
"type": "esriFieldTypeString",
"alias": "CENTROID_LNG",
"length": 50,
"domain": null
},
{
"name": "ADVERTISE",
"type": "esriFieldTypeDate",
"alias": "ADVERTISE",
"length": 8,
"domain": null
},
{
"name": "DESIGN_PLANS_SIGNED",
"type": "esriFieldTypeDate",
"alias": "DESIGN_PLANS_SIGNED",
"length": 8,
"domain": null
},
{
"name": "PROJECT_STARTDATE",
"type": "esriFieldTypeString",
"alias": "PROJECT_STARTDATE",
"length": 50,
"domain": null
},
{
"name": "PROJECT_ENDDATE",
"type": "esriFieldTypeString",
"alias": "PROJECT_ENDDATE",
"length": 50,
"domain": null
},
{
"name": "PROJECT_TYPE",
"type": "esriFieldTypeString",
"alias": "PROJECT_TYPE",
"length": 50,
"domain": null
},
{
"name": "PROJECT_SCOPE_DESC",
"type": "esriFieldTypeString",
"alias": "PROJECT_SCOPE_DESC",
"length": 2000,
"domain": null
},
{
"name": "PROJECT_BUDGET",
"type": "esriFieldTypeDouble",
"alias": "PROJECT_BUDGET",
"domain": null
},
{
"name": "CONTRACT_COST",
"type": "esriFieldTypeDouble",
"alias": "CONTRACT_COST",
"domain": null
},
{
"name": "MAINTENANCE_DISTRICT",
"type": "esriFieldTypeString",
"alias": "MAINTENANCE_DISTRICT",
"length": 10,
"domain": null
},
{
"name": "CON_BEGIN_PUBLIC_DISP",
"type": "esriFieldTypeString",
"alias": "CON_BEGIN_PUBLIC_DISP",
"length": 50,
"domain": null
},
{
"name": "CON_BEGIN_DISP",
"type": "esriFieldTypeString",
"alias": "CON_BEGIN_DISP",
"length": 50,
"domain": null
},
{
"name": "SHOW_ON_INTERNET",
"type": "esriFieldTypeString",
"alias": "SHOW_ON_INTERNET",
"length": 1,
"domain": null
},
{
"name": "PIW_PREFIX",
"type": "esriFieldTypeString",
"alias": "PIW_PREFIX",
"length": 10,
"domain": null
},
{
"name": "CITY_COMMUNITY",
"type": "esriFieldTypeString",
"alias": "CITY_COMMUNITY",
"length": 2000,
"domain": null
},
{
"name": "ENGINEER_EST",
"type": "esriFieldTypeDouble",
"alias": "ENGINEER_EST",
"domain": null
},
{
"name": "SHAPE",
"type": "esriFieldTypeGeometry",
"alias": "SHAPE",
"domain": null
},
{
"name": "COST_ESTIMATE",
"type": "esriFieldTypeString",
"alias": "COST_ESTIMATE",
"length": 2000,
"domain": null
},
{
"name": "COST_ESTIMATE_DISP",
"type": "esriFieldTypeString",
"alias": "COST_ESTIMATE_DISP",
"length": 2000,
"domain": null
},
{
"name": "FS_LOCATION",
"type": "esriFieldTypeString",
"alias": "FS_LOCATION",
"length": 2000,
"domain": null
},
{
"name": "ORIGINAL_GEOTYPE",
"type": "esriFieldTypeString",
"alias": "ORIGINAL_GEOTYPE",
"length": 100,
"domain": null
},
{
"name": "WEBSITE",
"type": "esriFieldTypeString",
"alias": "WEBSITE",
"length": 400,
"domain": null
},
{
"name": "PROJECT_LIMIT",
"type": "esriFieldTypeString",
"alias": "PROJECT_LIMIT",
"length": 2000,
"domain": null
},
{
"name": "PROJECT_STATUS_SIMPLE",
"type": "esriFieldTypeString",
"alias": "PROJECT_STATUS_SIMPLE",
"length": 25,
"domain": null
},
{
"name": "PROJECT_TYPE_SIMPLE",
"type": "esriFieldTypeString",
"alias": "PROJECT_TYPE_SIMPLE",
"length": 50,
"domain": null
},
{
"name": "PAYMENT_ID",
"type": "esriFieldTypeDouble",
"alias": "PAYMENT_ID_NEW",
"domain": null
},
{
"name": "COMBINED_CATEGORY",
"type": "esriFieldTypeString",
"alias": "COMBINED_CATEGORY",
"length": 500,
"domain": null
},
{
"name": "CONSTRUCTION_END",
"type": "esriFieldTypeDate",
"alias": "CONSTRUCTION_END",
"length": 8,
"domain": null
},
{
"name": "COMMUNITY_WKFC_AGRMT",
"type": "esriFieldTypeString",
"alias": "COMMUNITY_WKFC_AGRMT",
"length": 2,
"domain": null
},
{
"name": "COMPLIANCE_LOCAL",
"type": "esriFieldTypeSingle",
"alias": "COMPLIANCE_LOCAL",
"domain": null
},
{
"name": "COMPLIANCE_TARGETED",
"type": "esriFieldTypeSingle",
"alias": "COMPLIANCE_TARGETED",
"domain": null
},
{
"name": "CONTRACTOR_NAME",
"type": "esriFieldTypeString",
"alias": "CONTRACTOR_NAME",
"length": 300,
"domain": null
},
{
"name": "HIRING_GOAL_TYPE",
"type": "esriFieldTypeString",
"alias": "HIRING_GOAL_TYPE",
"length": 60,
"domain": null
},
{
"name": "SHOW_ON_INTERNET_LTWHP",
"type": "esriFieldTypeString",
"alias": "SHOW_ON_INTERNET_LTWHP",
"length": 2,
"domain": null
},
{
"name": "SHAPE.AREA",
"type": "esriFieldTypeDouble",
"alias": "SHAPE.AREA",
"domain": null
},
{
"name": "SHAPE.LEN",
"type": "esriFieldTypeDouble",
"alias": "SHAPE.LEN",
"domain": null
}
],
"geometryField": {
"name": "SHAPE",
"type": "esriFieldTypeGeometry",
"alias": "SHAPE"
},
"indexes": [
{
"name": "HIRGOALTYPIDX",
"fields": "HIRING_GOAL_TYPE",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "R2155533_SDE_ROWID_UK",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "A4303_IX1",
"fields": "SHAPE",
"isAscending": true,
"isUnique": true,
"description": ""
}
],
"subtypes": [],
"relationships": [],
"canModifyLayer": true,
"canScaleSymbols": false,
"hasLabels": false,
"capabilities": "Map,Query,Data",
"maxRecordCount": 8000,
"supportsStatistics": true,
"supportsAdvancedQueries": true,
"supportedQueryFormats": "JSON, geoJSON",
"isDataVersioned": false,
"ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true},
"useStandardizedQueries": true,
"advancedQueryCapabilities": {
"useStandardizedQueries": true,
"supportsStatistics": true,
"supportsHavingClause": true,
"supportsCountDistinct": true,
"supportsOrderBy": true,
"supportsDistinct": true,
"supportsPagination": true,
"supportsTrueCurve": true,
"supportsReturningQueryExtent": true,
"supportsQueryWithDistance": true,
"supportsSqlExpression": true
},
"supportsDatumTransformation": true,
"hasGeometryProperties": true,
"geometryProperties": {
"shapeAreaFieldName": "SHAPE.AREA",
"shapeLengthFieldName": "SHAPE.LEN",
"units": "esriFeet"
},
"dateFieldsTimeReference": {
"timeZone": "Pacific Standard Time",
"respectsDaylightSaving": true
},
"supportsCoordinatesQuantization": true
}