{
 "layers": [
  {
   "currentVersion": 11.3,
   "cimVersion": "3.3.0",
   "id": 0,
   "name": "ITSSQLSandbox.DBO.ATSPM_Signals_07272021",
   "type": "Feature Layer",
   "description": "",
   "geometryType": "esriGeometryPoint",
   "sourceSpatialReference": {
    "wkid": 4326,
    "latestWkid": 4326,
    "xyTolerance": 8.983152841195215E-9,
    "zTolerance": 0.001,
    "mTolerance": 0.001,
    "falseX": -400,
    "falseY": -400,
    "xyUnits": 9.999999999999999E8,
    "falseZ": 0,
    "zUnits": 1,
    "falseM": 0,
    "mUnits": 1
   },
   "copyrightText": "",
   "parentLayer": null,
   "subLayers": [],
   "minScale": 0,
   "maxScale": 0,
   "referenceScale": 0.0,
   "drawingInfo": {
    "renderer": {
     "type": "simple",
     "symbol": {
      "type": "esriSMS",
      "style": "esriSMSCircle",
      "color": [
       0,
       55,
       150,
       255
      ],
      "size": 4,
      "angle": 0,
      "xoffset": 0,
      "yoffset": 0,
      "outline": {
       "color": [
        0,
        0,
        0,
        255
       ],
       "width": 1
      }
     }
    },
    "scaleSymbols": true,
    "transparency": 0,
    "labelingInfo": null
   },
   "defaultVisibility": true,
   "extent": {
    "xmin": -81.59072099999997,
    "ymin": 27.699535000000026,
    "xmax": -80.59735799999999,
    "ymax": 29.201854000000026,
    "spatialReference": {
     "wkid": 4326,
     "latestWkid": 4326,
     "xyTolerance": 8.983152841195215E-9,
     "zTolerance": 2,
     "mTolerance": 0.001,
     "falseX": -400,
     "falseY": -400,
     "xyUnits": 1.125899906842624E13,
     "falseZ": 0,
     "zUnits": 1,
     "falseM": -100000,
     "mUnits": 10000
    }
   },
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText",
   "displayField": "PrimaryName",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "Lat",
     "type": "esriFieldTypeDouble",
     "alias": "Lat",
     "domain": null
    },
    {
     "name": "Long",
     "type": "esriFieldTypeDouble",
     "alias": "Long",
     "domain": null
    },
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "SignalID",
     "type": "esriFieldTypeString",
     "alias": "SignalID",
     "length": 10,
     "domain": null
    },
    {
     "name": "Latitude",
     "type": "esriFieldTypeString",
     "alias": "Latitude",
     "length": 30,
     "domain": null
    },
    {
     "name": "Longitude",
     "type": "esriFieldTypeString",
     "alias": "Longitude",
     "length": 30,
     "domain": null
    },
    {
     "name": "PrimaryName",
     "type": "esriFieldTypeString",
     "alias": "PrimaryName",
     "length": 100,
     "domain": null
    },
    {
     "name": "SecondaryName",
     "type": "esriFieldTypeString",
     "alias": "SecondaryName",
     "length": 100,
     "domain": null
    },
    {
     "name": "RegionID",
     "type": "esriFieldTypeInteger",
     "alias": "RegionID",
     "domain": null
    },
    {
     "name": "ControllerTypeID",
     "type": "esriFieldTypeInteger",
     "alias": "ControllerTypeID",
     "domain": null
    },
    {
     "name": "Enabled",
     "type": "esriFieldTypeSmallInteger",
     "alias": "Enabled",
     "domain": null
    },
    {
     "name": "VersionID",
     "type": "esriFieldTypeInteger",
     "alias": "VersionID",
     "domain": null
    },
    {
     "name": "VersionActionId",
     "type": "esriFieldTypeInteger",
     "alias": "VersionActionId",
     "domain": null
    },
    {
     "name": "Note",
     "type": "esriFieldTypeString",
     "alias": "Note",
     "length": 1073741822,
     "domain": null
    },
    {
     "name": "Start",
     "type": "esriFieldTypeDate",
     "alias": "Start",
     "length": 8,
     "domain": null
    },
    {
     "name": "Shape",
     "type": "esriFieldTypeGeometry",
     "alias": "Shape",
     "domain": null
    }
   ],
   "geometryField": {
    "name": "Shape",
    "type": "esriFieldTypeGeometry",
    "alias": "Shape"
   },
   "indexes": [
    {
     "name": "R374292_pk",
     "fields": "OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "S318201_idx",
     "fields": "Shape",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [
    {
     "id": 0,
     "name": "ITSSQLSandbox.dbo.ATSPM_Approaches",
     "relatedTableId": 1,
     "role": "esriRelRoleOrigin",
     "keyField": "SignalID",
     "cardinality": "esriRelCardinalityOneToMany",
     "composite": false
    }
   ],
   "canModifyLayer": true,
   "canScaleSymbols": false,
   "hasLabels": false,
   "capabilities": "Map,Query,Data",
   "maxRecordCount": 1000,
   "supportsStatistics": true,
   "supportsExceedsLimitStatistics": true,
   "supportsAdvancedQueries": true,
   "supportedQueryFormats": "JSON, geoJSON, PBF",
   "isDataVersioned": false,
   "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": null,
   "preferredTimeReference": null,
   "datesInUnknownTimezone": false,
   "hasMetadata": false,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   },
   "supportsCoordinatesQuantization": true,
   "supportsDynamicLegends": true,
   "serviceItemId": "4ddfe04b6d40430290e7d6cb76b687cf"
  }
 ],
 "tables": [
  {
   "currentVersion": 11.3,
   "cimVersion": "3.3.0",
   "id": 1,
   "name": "ITSSQLSandbox.dbo.ATSPM_Approaches",
   "type": "Table",
   "description": null,
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "SignalID",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "ApproachID",
     "type": "esriFieldTypeInteger",
     "alias": "ApproachID",
     "domain": null
    },
    {
     "name": "SignalID",
     "type": "esriFieldTypeString",
     "alias": "SignalID",
     "length": 10,
     "domain": null
    },
    {
     "name": "DirectionTypeID",
     "type": "esriFieldTypeInteger",
     "alias": "DirectionTypeID",
     "domain": null
    },
    {
     "name": "Description",
     "type": "esriFieldTypeString",
     "alias": "Description",
     "length": 1073741822,
     "domain": null
    },
    {
     "name": "MPH",
     "type": "esriFieldTypeInteger",
     "alias": "MPH",
     "domain": null
    },
    {
     "name": "ProtectedPhaseNumber",
     "type": "esriFieldTypeInteger",
     "alias": "ProtectedPhaseNumber",
     "domain": null
    },
    {
     "name": "IsProtectedPhaseOverlap",
     "type": "esriFieldTypeSmallInteger",
     "alias": "IsProtectedPhaseOverlap",
     "domain": null
    },
    {
     "name": "PermissivePhaseNumber",
     "type": "esriFieldTypeInteger",
     "alias": "PermissivePhaseNumber",
     "domain": null
    },
    {
     "name": "VersionID",
     "type": "esriFieldTypeInteger",
     "alias": "VersionID",
     "domain": null
    },
    {
     "name": "IsPermissivePhaseOverlap",
     "type": "esriFieldTypeSmallInteger",
     "alias": "IsPermissivePhaseOverlap",
     "domain": null
    }
   ],
   "indexes": [
    {
     "name": "R374312_SDE_ROWID_UK",
     "fields": "OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [
    {
     "id": 0,
     "name": "ITSSQLSandbox.DBO.ATSPM_Signals_07272021",
     "relatedTableId": 0,
     "role": "esriRelRoleDestination",
     "keyField": "SignalID",
     "cardinality": "esriRelCardinalityOneToMany",
     "composite": false
    }
   ],
   "capabilities": "Map,Query,Data",
   "maxRecordCount": 1000,
   "supportsStatistics": true,
   "supportsExceedsLimitStatistics": true,
   "supportsAdvancedQueries": true,
   "supportedQueryFormats": "JSON, PBF",
   "isDataVersioned": false,
   "useStandardizedQueries": true,
   "advancedQueryCapabilities": {
    "useStandardizedQueries": true,
    "supportsStatistics": true,
    "supportsPercentileStatistics": true,
    "supportsHavingClause": true,
    "supportsOrderBy": true,
    "supportsDistinct": true,
    "supportsCountDistinct": true,
    "supportsPagination": true,
    "supportsTrueCurve": false,
    "supportsReturningQueryExtent": true,
    "supportsQueryWithDistance": true,
    "supportsSqlExpression": true,
    "supportsTimeRelation": true,
    "supportsAdvancedQueryRelated": true,
    "supportsQueryRelatedPagination": true,
    "supportsSqlFormat": false,
    "supportsQueryAnalytic": true,
    "supportsCurrentUserQueries": true
   },
   "advancedQueryAnalyticCapabilities": {
    "supportsLinearRegression": true,
    "supportsAsync": false,
    "supportsPercentileAnalytic": true
   },
   "dateFieldsTimeReference": null,
   "preferredTimeReference": null,
   "datesInUnknownTimezone": false,
   "hasMetadata": false,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   },
   "serviceItemId": "4ddfe04b6d40430290e7d6cb76b687cf"
  },
  {
   "currentVersion": 11.3,
   "cimVersion": "3.3.0",
   "id": 2,
   "name": "ITSSQLSandbox.dbo.ATSPM_Detectors",
   "type": "Table",
   "description": null,
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "DetectorID",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "ITSSQLSandbox.dbo.ATSPM_Detectors.OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "ITSSQLSandbox.dbo.ATSPM_Detectors.ID",
     "type": "esriFieldTypeDouble",
     "alias": "ID",
     "domain": null
    },
    {
     "name": "ITSSQLSandbox.dbo.ATSPM_Detectors.DetectorID",
     "type": "esriFieldTypeString",
     "alias": "DetectorID",
     "length": 1073741822,
     "domain": null
    },
    {
     "name": "ITSSQLSandbox.dbo.ATSPM_Detectors.DetChannel",
     "type": "esriFieldTypeDouble",
     "alias": "DetChannel",
     "domain": null
    },
    {
     "name": "ITSSQLSandbox.dbo.ATSPM_Detectors.DistanceFromStopBar",
     "type": "esriFieldTypeDouble",
     "alias": "DistanceFromStopBar",
     "domain": null
    },
    {
     "name": "ITSSQLSandbox.dbo.ATSPM_Detectors.MinSpeedFilter",
     "type": "esriFieldTypeDouble",
     "alias": "MinSpeedFilter",
     "domain": null
    },
    {
     "name": "ITSSQLSandbox.dbo.ATSPM_Detectors.DateAdded",
     "type": "esriFieldTypeDate",
     "alias": "DateAdded",
     "length": 8,
     "domain": null
    },
    {
     "name": "ITSSQLSandbox.dbo.ATSPM_Detectors.DateDisabled",
     "type": "esriFieldTypeDate",
     "alias": "DateDisabled",
     "length": 8,
     "domain": null
    },
    {
     "name": "ITSSQLSandbox.dbo.ATSPM_Detectors.LaneNumber",
     "type": "esriFieldTypeDouble",
     "alias": "LaneNumber",
     "domain": null
    },
    {
     "name": "ITSSQLSandbox.dbo.ATSPM_Detectors.MovementTypeID",
     "type": "esriFieldTypeDouble",
     "alias": "MovementTypeID",
     "domain": null
    },
    {
     "name": "ITSSQLSandbox.dbo.ATSPM_Detectors.LaneTypeID",
     "type": "esriFieldTypeDouble",
     "alias": "LaneTypeID",
     "domain": null
    },
    {
     "name": "ITSSQLSandbox.dbo.ATSPM_Detectors.DecisionPoint",
     "type": "esriFieldTypeDouble",
     "alias": "DecisionPoint",
     "domain": null
    },
    {
     "name": "ITSSQLSandbox.dbo.ATSPM_Detectors.MovementDelay",
     "type": "esriFieldTypeDouble",
     "alias": "MovementDelay",
     "domain": null
    },
    {
     "name": "ITSSQLSandbox.dbo.ATSPM_Detectors.ApproachID",
     "type": "esriFieldTypeDouble",
     "alias": "ApproachID",
     "domain": null
    },
    {
     "name": "ITSSQLSandbox.dbo.ATSPM_Detectors.DetectionHardwareID",
     "type": "esriFieldTypeDouble",
     "alias": "DetectionHardwareID",
     "domain": null
    },
    {
     "name": "ITSSQLSandbox.dbo.ATSPM_Detectors.LatencyCorrection",
     "type": "esriFieldTypeDouble",
     "alias": "LatencyCorrection",
     "domain": null
    },
    {
     "name": "ITSSQLSandbox.dbo.ATSPM_Approaches.OBJECTID",
     "type": "esriFieldTypeInteger",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "ITSSQLSandbox.dbo.ATSPM_Approaches.ApproachID",
     "type": "esriFieldTypeInteger",
     "alias": "ApproachID",
     "domain": null
    },
    {
     "name": "ITSSQLSandbox.dbo.ATSPM_Approaches.SignalID",
     "type": "esriFieldTypeString",
     "alias": "SignalID",
     "length": 10,
     "domain": null
    },
    {
     "name": "ITSSQLSandbox.dbo.ATSPM_Approaches.DirectionTypeID",
     "type": "esriFieldTypeInteger",
     "alias": "DirectionTypeID",
     "domain": null
    },
    {
     "name": "ITSSQLSandbox.dbo.ATSPM_Approaches.Description",
     "type": "esriFieldTypeString",
     "alias": "Description",
     "length": 1073741822,
     "domain": null
    },
    {
     "name": "ITSSQLSandbox.dbo.ATSPM_Approaches.MPH",
     "type": "esriFieldTypeInteger",
     "alias": "MPH",
     "domain": null
    },
    {
     "name": "ITSSQLSandbox.dbo.ATSPM_Approaches.ProtectedPhaseNumber",
     "type": "esriFieldTypeInteger",
     "alias": "ProtectedPhaseNumber",
     "domain": null
    },
    {
     "name": "ITSSQLSandbox.dbo.ATSPM_Approaches.IsProtectedPhaseOverlap",
     "type": "esriFieldTypeSmallInteger",
     "alias": "IsProtectedPhaseOverlap",
     "domain": null
    },
    {
     "name": "ITSSQLSandbox.dbo.ATSPM_Approaches.PermissivePhaseNumber",
     "type": "esriFieldTypeInteger",
     "alias": "PermissivePhaseNumber",
     "domain": null
    },
    {
     "name": "ITSSQLSandbox.dbo.ATSPM_Approaches.VersionID",
     "type": "esriFieldTypeInteger",
     "alias": "VersionID",
     "domain": null
    },
    {
     "name": "ITSSQLSandbox.dbo.ATSPM_Approaches.IsPermissivePhaseOverlap",
     "type": "esriFieldTypeSmallInteger",
     "alias": "IsPermissivePhaseOverlap",
     "domain": null
    }
   ],
   "indexes": [
    {
     "name": "R374310_SDE_ROWID_UK",
     "fields": "ITSSQLSandbox.dbo.ATSPM_Detectors.OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "R374312_SDE_ROWID_UK",
     "fields": "ITSSQLSandbox.dbo.ATSPM_Approaches.OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [],
   "capabilities": "Map,Query,Data",
   "maxRecordCount": 1000,
   "supportsStatistics": true,
   "supportsExceedsLimitStatistics": true,
   "supportsAdvancedQueries": true,
   "supportedQueryFormats": "JSON, PBF",
   "isDataVersioned": false,
   "useStandardizedQueries": true,
   "advancedQueryCapabilities": {
    "useStandardizedQueries": true,
    "supportsStatistics": true,
    "supportsPercentileStatistics": true,
    "supportsHavingClause": true,
    "supportsOrderBy": true,
    "supportsDistinct": true,
    "supportsCountDistinct": true,
    "supportsPagination": true,
    "supportsTrueCurve": false,
    "supportsReturningQueryExtent": true,
    "supportsQueryWithDistance": true,
    "supportsSqlExpression": true,
    "supportsTimeRelation": true,
    "supportsAdvancedQueryRelated": true,
    "supportsQueryRelatedPagination": true,
    "supportsSqlFormat": false,
    "supportsQueryAnalytic": true,
    "supportsCurrentUserQueries": true
   },
   "advancedQueryAnalyticCapabilities": {
    "supportsLinearRegression": true,
    "supportsAsync": false,
    "supportsPercentileAnalytic": true
   },
   "dateFieldsTimeReference": null,
   "preferredTimeReference": null,
   "datesInUnknownTimezone": false,
   "hasMetadata": false,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   },
   "serviceItemId": "4ddfe04b6d40430290e7d6cb76b687cf"
  }
 ]
}