{ "layers": [ { "currentVersion": 10.71, "id": 0, "name": "Districts", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 102642, "latestWkid": 2226 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "Test.dbo.vwPDAssignRoster.DISTRICT", "field2": null, "field3": null, "defaultSymbol": null, "defaultLabel": null, "uniqueValueInfos": [ { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 204, 192, 135, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 0, 0, 255 ], "width": 2 } }, "value": "1", "label": "1", "description": "" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 242, 230, 53, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 0, 0, 255 ], "width": 2 } }, "value": "2", "label": "2", "description": "" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 194, 152, 54, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 0, 0, 255 ], "width": 2 } }, "value": "3", "label": "3", "description": "" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 250, 244, 135, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 0, 0, 255 ], "width": 2 } }, "value": "4", "label": "4", "description": "" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 212, 207, 74, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 0, 0, 255 ], "width": 2 } }, "value": "5", "label": "5", "description": "" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 250, 236, 200, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 0, 0, 255 ], "width": 2 } }, "value": "6", "label": "6", "description": "" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 179, 158, 84, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 0, 0, 255 ], "width": 2 } }, "value": "7", "label": "7", "description": "" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 240, 192, 62, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 0, 0, 255 ], "width": 2 } }, "value": "8", "label": "8", "description": "" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 237, 200, 100, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 0, 0, 255 ], "width": 2 } }, "value": "9", "label": "9", "description": "" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 242, 240, 165, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 0, 0, 255 ], "width": 2 } }, "value": "10", "label": "10", "description": "" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 199, 196, 103, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 0, 0, 255 ], "width": 2 } }, "value": "11", "label": "11", "description": "" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 184, 172, 64, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 0, 0, 255 ], "width": 2 } }, "value": "12", "label": "12", "description": "" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 189, 178, 147, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 0, 0, 255 ], "width": 2 } }, "value": "13", "label": "13", "description": "" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 242, 212, 141, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 0, 0, 255 ], "width": 2 } }, "value": "14", "label": "14", "description": "" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 199, 166, 46, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 0, 0, 255 ], "width": 2 } }, "value": "15", "label": "15", "description": "" } ], "fieldDelimiter": "," }, "transparency": 0, "labelingInfo": [ { "labelPlacement": "esriServerPolygonPlacementAlwaysHorizontal", "where": null, "labelExpression": "[Test.DBO.PD_DISTRICTS.DISTRICT]", "useCodedValues": true, "symbol": { "type": "esriTS", "color": [ 255, 255, 255, 255 ], "backgroundColor": null, "borderLineColor": null, "borderLineSize": null, "verticalAlignment": "bottom", "horizontalAlignment": "center", "rightToLeft": false, "angle": 0, "xoffset": 0, "yoffset": 0, "kerning": true, "haloColor": null, "haloSize": null, "font": { "family": "Arial", "size": 8, "style": "normal", "weight": "bold", "decoration": "none" } }, "minScale": 0, "maxScale": 0 } ] }, "defaultVisibility": true, "extent": { "xmin": -1.3656952977645384E7, "ymin": 4608427.350268649, "xmax": -1.3644152816628082E7, "ymax": 4619545.278885724, "spatialReference": { "wkid": 102100, "latestWkid": 3857 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "Test.DBO.PD_DISTRICTS.DISTRICT", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "Test.DBO.PD_DISTRICTS.OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Test.DBO.PD_DISTRICTS.DISTRICT", "type": "esriFieldTypeInteger", "alias": "DISTRICT", "domain": null }, { "name": "Test.DBO.PD_DISTRICTS.Shape_Leng", "type": "esriFieldTypeDouble", "alias": "Shape_Leng", "domain": null }, { "name": "Test.DBO.PD_DISTRICTS.Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.DISTRICT", "type": "esriFieldTypeInteger", "alias": "DISTRICT", "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.OFF1", "type": "esriFieldTypeInteger", "alias": "OFF1", "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.O1_EMPNO", "type": "esriFieldTypeInteger", "alias": "O1_EMPNO", "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.O1_POSITION", "type": "esriFieldTypeString", "alias": "O1_POSITION", "length": 50, "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.O1_LNAME", "type": "esriFieldTypeString", "alias": "O1_LNAME", "length": 50, "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.O1_FNAME", "type": "esriFieldTypeString", "alias": "O1_FNAME", "length": 50, "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.O1_BADGE", "type": "esriFieldTypeString", "alias": "O1_BADGE", "length": 50, "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.O1_PHONE", "type": "esriFieldTypeString", "alias": "O1_PHONE", "length": 50, "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.O1_EMAIL", "type": "esriFieldTypeString", "alias": "O1_EMAIL", "length": 50, "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.OFF2", "type": "esriFieldTypeInteger", "alias": "OFF2", "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.O2_EMPNO", "type": "esriFieldTypeInteger", "alias": "O2_EMPNO", "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.O2_POSITION", "type": "esriFieldTypeString", "alias": "O2_POSITION", "length": 50, "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.O2_LNAME", "type": "esriFieldTypeString", "alias": "O2_LNAME", "length": 50, "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.O2_FNAME", "type": "esriFieldTypeString", "alias": "O2_FNAME", "length": 50, "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.O2_BADGE", "type": "esriFieldTypeString", "alias": "O2_BADGE", "length": 50, "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.O2_PHONE", "type": "esriFieldTypeString", "alias": "O2_PHONE", "length": 50, "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.O2_EMAIL", "type": "esriFieldTypeString", "alias": "O2_EMAIL", "length": 50, "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.BEATSGT", "type": "esriFieldTypeInteger", "alias": "BEATSGT", "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.BS_EMPNO", "type": "esriFieldTypeInteger", "alias": "BS_EMPNO", "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.BS_POSITION", "type": "esriFieldTypeString", "alias": "BS_POSITION", "length": 50, "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.BS_LNAME", "type": "esriFieldTypeString", "alias": "BS_LNAME", "length": 50, "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.BS_FNAME", "type": "esriFieldTypeString", "alias": "BS_FNAME", "length": 50, "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.BS_BADGE", "type": "esriFieldTypeString", "alias": "BS_BADGE", "length": 50, "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.BS_PHONE", "type": "esriFieldTypeString", "alias": "BS_PHONE", "length": 50, "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.BS_EMAIL", "type": "esriFieldTypeString", "alias": "BS_EMAIL", "length": 50, "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.EWSGT", "type": "esriFieldTypeInteger", "alias": "EWSGT", "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.EWS_EMPNO", "type": "esriFieldTypeInteger", "alias": "EWS_EMPNO", "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.EWS_POSITION", "type": "esriFieldTypeString", "alias": "EWS_POSITION", "length": 50, "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.EWS_LNAME", "type": "esriFieldTypeString", "alias": "EWS_LNAME", "length": 50, "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.EWS_FNAME", "type": "esriFieldTypeString", "alias": "EWS_FNAME", "length": 50, "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.EWS_BADGE", "type": "esriFieldTypeString", "alias": "EWS_BADGE", "length": 50, "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.EWS_PHONE", "type": "esriFieldTypeString", "alias": "EWS_PHONE", "length": 50, "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.EWS_EMAIL", "type": "esriFieldTypeString", "alias": "EWS_EMAIL", "length": 50, "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.LT", "type": "esriFieldTypeInteger", "alias": "LT", "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.LT_EMPNO", "type": "esriFieldTypeInteger", "alias": "LT_EMPNO", "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.LT_POSITION", "type": "esriFieldTypeString", "alias": "LT_POSITION", "length": 50, "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.LT_LNAME", "type": "esriFieldTypeString", "alias": "LT_LNAME", "length": 50, "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.LT_FNAME", "type": "esriFieldTypeString", "alias": "LT_FNAME", "length": 50, "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.LT_BADGE", "type": "esriFieldTypeString", "alias": "LT_BADGE", "length": 50, "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.LT_PHONE", "type": "esriFieldTypeString", "alias": "LT_PHONE", "length": 50, "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.LT_EMAIL", "type": "esriFieldTypeString", "alias": "LT_EMAIL", "length": 50, "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.CHIEF", "type": "esriFieldTypeInteger", "alias": "CHIEF", "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.CH_EMPNO", "type": "esriFieldTypeInteger", "alias": "CH_EMPNO", "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.CH_POSITION", "type": "esriFieldTypeString", "alias": "CH_POSITION", "length": 50, "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.CH_LNAME", "type": "esriFieldTypeString", "alias": "CH_LNAME", "length": 50, "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.CH_FNAME", "type": "esriFieldTypeString", "alias": "CH_FNAME", "length": 50, "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.CH_BADGE", "type": "esriFieldTypeString", "alias": "CH_BADGE", "length": 50, "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.CH_PHONE", "type": "esriFieldTypeString", "alias": "CH_PHONE", "length": 50, "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.CH_EMAIL", "type": "esriFieldTypeString", "alias": "CH_EMAIL", "length": 50, "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.TRAFFIC", "type": "esriFieldTypeInteger", "alias": "TRAFFIC", "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.TR_EMPNO", "type": "esriFieldTypeInteger", "alias": "TR_EMPNO", "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.TR_POSITION", "type": "esriFieldTypeString", "alias": "TR_POSITION", "length": 50, "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.TR_LNAME", "type": "esriFieldTypeString", "alias": "TR_LNAME", "length": 50, "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.TR_FNAME", "type": "esriFieldTypeString", "alias": "TR_FNAME", "length": 50, "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.TR_BADGE", "type": "esriFieldTypeString", "alias": "TR_BADGE", "length": 50, "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.TR_PHONE", "type": "esriFieldTypeString", "alias": "TR_PHONE", "length": 50, "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.TR_EMAIL", "type": "esriFieldTypeString", "alias": "TR_EMAIL", "length": 50, "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.DEPCHIEF", "type": "esriFieldTypeInteger", "alias": "DEPCHIEF", "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.DC_EMPNO", "type": "esriFieldTypeInteger", "alias": "DC_EMPNO", "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.DC_POSITION", "type": "esriFieldTypeString", "alias": "DC_POSITION", "length": 50, "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.DC_LNAME", "type": "esriFieldTypeString", "alias": "DC_LNAME", "length": 50, "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.DC_FNAME", "type": "esriFieldTypeString", "alias": "DC_FNAME", "length": 50, "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.DC_BADGE", "type": "esriFieldTypeString", "alias": "DC_BADGE", "length": 50, "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.DC_PHONE", "type": "esriFieldTypeString", "alias": "DC_PHONE", "length": 50, "domain": null }, { "name": "Test.dbo.vwPDAssignRoster.DC_EMAIL", "type": "esriFieldTypeString", "alias": "DC_EMAIL", "length": 50, "domain": null } ], "geometryField": { "name": "Test.DBO.PD_DISTRICTS.Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R26_pk", "fields": "Test.DBO.PD_DISTRICTS.OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S13_idx", "fields": "Test.DBO.PD_DISTRICTS.Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": false, "canScaleSymbols": false, "hasLabels": true, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "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, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.71, "id": 1, "name": "Beats", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 102642, "latestWkid": 2226 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 0, 0, 0, 0 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 0, 0, 255 ], "width": 1 } }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 1.92706407528242E7, "ymin": 2904146.9239637274, "xmax": 1.927619623520819E7, "ymax": 2909676.917677684, "spatialReference": { "wkid": 102100, "latestWkid": 3857 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "BEAT", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "BEAT", "type": "esriFieldTypeSmallInteger", "alias": "BEAT", "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": null, "subtypes": [], "relationships": [], "canModifyLayer": false, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "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, "supportsCoordinatesQuantization": true } ], "tables": [ { "currentVersion": 10.71, "id": 2, "name": "Test.dbo.vwPDAssignRoster", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "O1_LNAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "DISTRICT", "type": "esriFieldTypeInteger", "alias": "DISTRICT", "domain": null }, { "name": "OFF1", "type": "esriFieldTypeInteger", "alias": "OFF1", "domain": null }, { "name": "O1_EMPNO", "type": "esriFieldTypeInteger", "alias": "O1_EMPNO", "domain": null }, { "name": "O1_POSITION", "type": "esriFieldTypeString", "alias": "O1_POSITION", "length": 50, "domain": null }, { "name": "O1_LNAME", "type": "esriFieldTypeString", "alias": "O1_LNAME", "length": 50, "domain": null }, { "name": "O1_FNAME", "type": "esriFieldTypeString", "alias": "O1_FNAME", "length": 50, "domain": null }, { "name": "O1_BADGE", "type": "esriFieldTypeString", "alias": "O1_BADGE", "length": 50, "domain": null }, { "name": "O1_PHONE", "type": "esriFieldTypeString", "alias": "O1_PHONE", "length": 50, "domain": null }, { "name": "O1_EMAIL", "type": "esriFieldTypeString", "alias": "O1_EMAIL", "length": 50, "domain": null }, { "name": "OFF2", "type": "esriFieldTypeInteger", "alias": "OFF2", "domain": null }, { "name": "O2_EMPNO", "type": "esriFieldTypeInteger", "alias": "O2_EMPNO", "domain": null }, { "name": "O2_POSITION", "type": "esriFieldTypeString", "alias": "O2_POSITION", "length": 50, "domain": null }, { "name": "O2_LNAME", "type": "esriFieldTypeString", "alias": "O2_LNAME", "length": 50, "domain": null }, { "name": "O2_FNAME", "type": "esriFieldTypeString", "alias": "O2_FNAME", "length": 50, "domain": null }, { "name": "O2_BADGE", "type": "esriFieldTypeString", "alias": "O2_BADGE", "length": 50, "domain": null }, { "name": "O2_PHONE", "type": "esriFieldTypeString", "alias": "O2_PHONE", "length": 50, "domain": null }, { "name": "O2_EMAIL", "type": "esriFieldTypeString", "alias": "O2_EMAIL", "length": 50, "domain": null }, { "name": "BEATSGT", "type": "esriFieldTypeInteger", "alias": "BEATSGT", "domain": null }, { "name": "BS_EMPNO", "type": "esriFieldTypeInteger", "alias": "BS_EMPNO", "domain": null }, { "name": "BS_POSITION", "type": "esriFieldTypeString", "alias": "BS_POSITION", "length": 50, "domain": null }, { "name": "BS_LNAME", "type": "esriFieldTypeString", "alias": "BS_LNAME", "length": 50, "domain": null }, { "name": "BS_FNAME", "type": "esriFieldTypeString", "alias": "BS_FNAME", "length": 50, "domain": null }, { "name": "BS_BADGE", "type": "esriFieldTypeString", "alias": "BS_BADGE", "length": 50, "domain": null }, { "name": "BS_PHONE", "type": "esriFieldTypeString", "alias": "BS_PHONE", "length": 50, "domain": null }, { "name": "BS_EMAIL", "type": "esriFieldTypeString", "alias": "BS_EMAIL", "length": 50, "domain": null }, { "name": "EWSGT", "type": "esriFieldTypeInteger", "alias": "EWSGT", "domain": null }, { "name": "EWS_EMPNO", "type": "esriFieldTypeInteger", "alias": "EWS_EMPNO", "domain": null }, { "name": "EWS_POSITION", "type": "esriFieldTypeString", "alias": "EWS_POSITION", "length": 50, "domain": null }, { "name": "EWS_LNAME", "type": "esriFieldTypeString", "alias": "EWS_LNAME", "length": 50, "domain": null }, { "name": "EWS_FNAME", "type": "esriFieldTypeString", "alias": "EWS_FNAME", "length": 50, "domain": null }, { "name": "EWS_BADGE", "type": "esriFieldTypeString", "alias": "EWS_BADGE", "length": 50, "domain": null }, { "name": "EWS_PHONE", "type": "esriFieldTypeString", "alias": "EWS_PHONE", "length": 50, "domain": null }, { "name": "EWS_EMAIL", "type": "esriFieldTypeString", "alias": "EWS_EMAIL", "length": 50, "domain": null }, { "name": "LT", "type": "esriFieldTypeInteger", "alias": "LT", "domain": null }, { "name": "LT_EMPNO", "type": "esriFieldTypeInteger", "alias": "LT_EMPNO", "domain": null }, { "name": "LT_POSITION", "type": "esriFieldTypeString", "alias": "LT_POSITION", "length": 50, "domain": null }, { "name": "LT_LNAME", "type": "esriFieldTypeString", "alias": "LT_LNAME", "length": 50, "domain": null }, { "name": "LT_FNAME", "type": "esriFieldTypeString", "alias": "LT_FNAME", "length": 50, "domain": null }, { "name": "LT_BADGE", "type": "esriFieldTypeString", "alias": "LT_BADGE", "length": 50, "domain": null }, { "name": "LT_PHONE", "type": "esriFieldTypeString", "alias": "LT_PHONE", "length": 50, "domain": null }, { "name": "LT_EMAIL", "type": "esriFieldTypeString", "alias": "LT_EMAIL", "length": 50, "domain": null }, { "name": "CHIEF", "type": "esriFieldTypeInteger", "alias": "CHIEF", "domain": null }, { "name": "CH_EMPNO", "type": "esriFieldTypeInteger", "alias": "CH_EMPNO", "domain": null }, { "name": "CH_POSITION", "type": "esriFieldTypeString", "alias": "CH_POSITION", "length": 50, "domain": null }, { "name": "CH_LNAME", "type": "esriFieldTypeString", "alias": "CH_LNAME", "length": 50, "domain": null }, { "name": "CH_FNAME", "type": "esriFieldTypeString", "alias": "CH_FNAME", "length": 50, "domain": null }, { "name": "CH_BADGE", "type": "esriFieldTypeString", "alias": "CH_BADGE", "length": 50, "domain": null }, { "name": "CH_PHONE", "type": "esriFieldTypeString", "alias": "CH_PHONE", "length": 50, "domain": null }, { "name": "CH_EMAIL", "type": "esriFieldTypeString", "alias": "CH_EMAIL", "length": 50, "domain": null }, { "name": "TRAFFIC", "type": "esriFieldTypeInteger", "alias": "TRAFFIC", "domain": null }, { "name": "TR_EMPNO", "type": "esriFieldTypeInteger", "alias": "TR_EMPNO", "domain": null }, { "name": "TR_POSITION", "type": "esriFieldTypeString", "alias": "TR_POSITION", "length": 50, "domain": null }, { "name": "TR_LNAME", "type": "esriFieldTypeString", "alias": "TR_LNAME", "length": 50, "domain": null }, { "name": "TR_FNAME", "type": "esriFieldTypeString", "alias": "TR_FNAME", "length": 50, "domain": null }, { "name": "TR_BADGE", "type": "esriFieldTypeString", "alias": "TR_BADGE", "length": 50, "domain": null }, { "name": "TR_PHONE", "type": "esriFieldTypeString", "alias": "TR_PHONE", "length": 50, "domain": null }, { "name": "TR_EMAIL", "type": "esriFieldTypeString", "alias": "TR_EMAIL", "length": 50, "domain": null }, { "name": "DEPCHIEF", "type": "esriFieldTypeInteger", "alias": "DEPCHIEF", "domain": null }, { "name": "DC_EMPNO", "type": "esriFieldTypeInteger", "alias": "DC_EMPNO", "domain": null }, { "name": "DC_POSITION", "type": "esriFieldTypeString", "alias": "DC_POSITION", "length": 50, "domain": null }, { "name": "DC_LNAME", "type": "esriFieldTypeString", "alias": "DC_LNAME", "length": 50, "domain": null }, { "name": "DC_FNAME", "type": "esriFieldTypeString", "alias": "DC_FNAME", "length": 50, "domain": null }, { "name": "DC_BADGE", "type": "esriFieldTypeString", "alias": "DC_BADGE", "length": 50, "domain": null }, { "name": "DC_PHONE", "type": "esriFieldTypeString", "alias": "DC_PHONE", "length": 50, "domain": null }, { "name": "DC_EMAIL", "type": "esriFieldTypeString", "alias": "DC_EMAIL", "length": 50, "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true } }, { "currentVersion": 10.71, "id": 3, "name": "PGIS_Field.dbo.arrests", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "FullName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "time_arr", "type": "esriFieldTypeString", "alias": "time_arr", "length": 4, "domain": null }, { "name": "Date_Time", "type": "esriFieldTypeString", "alias": "Date_Time", "length": 20, "domain": null }, { "name": "IncidentNo", "type": "esriFieldTypeString", "alias": "IncidentNo", "length": 15, "domain": null }, { "name": "ChargeDesc", "type": "esriFieldTypeString", "alias": "ChargeDesc", "length": 2147483647, "domain": null }, { "name": "ArrestLoc", "type": "esriFieldTypeString", "alias": "ArrestLoc", "length": 75, "domain": null }, { "name": "FullName", "type": "esriFieldTypeString", "alias": "FullName", "length": 55, "domain": null }, { "name": "Gender", "type": "esriFieldTypeString", "alias": "Gender", "length": 15, "domain": null }, { "name": "Age", "type": "esriFieldTypeString", "alias": "Age", "length": 5, "domain": null }, { "name": "ArrestStatus", "type": "esriFieldTypeString", "alias": "ArrestStatus", "length": 50, "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "DOB", "type": "esriFieldTypeString", "alias": "DOB", "length": 12, "domain": null } ], "indexes": [ { "name": "UQ__arrests__F4B70D84C7AA10BC", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true } } ] }