View In:   ArcGIS Online Map Viewer

Name: Billboards

Display Field: StreetName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: The dataset is used for the collection of statewide billboard permits. This dataset provides attributes on the current statewide billboard permits. These attributes include descriptors based on location, permit number, material, sign type, content and owner. When provided, there are also images attached for each billboard.

Copyright Text: Michigan Department of Transportation, Development Services Division: Utility Coordination, Permits and Agreements Department

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 5000000.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: -93.70188176299996
YMin: 41.70783534900005
XMax: -80.77188154799995
YMax: 47.30349042000006
Spatial Reference: 4326  (4326)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• PR ( type: esriFieldTypeString, alias: PR, editable: true, nullable: true, length: 11, defaultValue: null, modelName: PR )
• PRMP ( type: esriFieldTypeDouble, alias: PRMP, editable: true, nullable: true, defaultValue: null, modelName: PRMP )
• CS ( type: esriFieldTypeString, alias: CS, editable: true, nullable: true, length: 11, defaultValue: null, modelName: CS )
• CSMP ( type: esriFieldTypeDouble, alias: CSMP, editable: true, nullable: true, defaultValue: null, modelName: CSMP )
• Route ( type: esriFieldTypeString, alias: Route, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Route , Coded Values: [I-69: I-69] , [I-75: I-75] , [I-94: I-94] , ...270 more... )
• StreetName ( type: esriFieldTypeString, alias: Street Name, editable: true, nullable: true, length: 100, defaultValue: null, modelName: StreetName )
• RoadBound ( type: esriFieldTypeString, alias: Road Bound, editable: true, nullable: true, length: 10, defaultValue: null, modelName: RoadBound , Coded Values: [Eastbound: Eastbound] , [Southbound: Southbound] , [Northbound: Northbound] , ...1 more... )
• SideOfRoad ( type: esriFieldTypeString, alias: Side of the Road, editable: true, nullable: true, length: 5, defaultValue: null, modelName: SideOfRoad , Coded Values: [North: North] , [East: East] , [South: South] , ...1 more... )
• County ( type: esriFieldTypeString, alias: County, editable: true, nullable: true, length: 15, defaultValue: null, modelName: County , Coded Values: [Alcona: Alcona] , [Alger: Alger] , [Allegan: Allegan] , ...80 more... )
• PermitNumber ( type: esriFieldTypeInteger, alias: Permit Number, editable: true, nullable: true, defaultValue: null, modelName: PermitNumber )
• SecondPermitNumber ( type: esriFieldTypeInteger, alias: Second Permit Number, editable: true, nullable: true, defaultValue: null, modelName: SecondPermitNumber )
• SecondaryPr ( type: esriFieldTypeString, alias: PR (Secondary), editable: true, nullable: true, length: 7, defaultValue: null, modelName: SecondaryPr )
• SecondaryPrMp ( type: esriFieldTypeDouble, alias: PR MP (Secondary), editable: true, nullable: true, defaultValue: null, modelName: SecondaryPrMp )
• SecondaryCs ( type: esriFieldTypeString, alias: CS (Secondary), editable: true, nullable: true, length: 11, defaultValue: null, modelName: SecondaryCs )
• SecondaryCsMp ( type: esriFieldTypeDouble, alias: CS MP (Secondary), editable: true, nullable: true, defaultValue: null, modelName: SecondaryCsMp )
• SecondaryRoute ( type: esriFieldTypeString, alias: Route (Secondary), editable: true, nullable: true, length: 15, defaultValue: null, modelName: SecondaryRoute , Coded Values: [I-69: I-69] , [I-75: I-75] , [I-94: I-94] , ...270 more... )
• SecondaryStreetName ( type: esriFieldTypeString, alias: Street Name (Secondary), editable: true, nullable: true, length: 100, defaultValue: null, modelName: SecondaryStreetName )
• SecondaryRoadBound ( type: esriFieldTypeString, alias: Road Bound (Secondary), editable: true, nullable: true, length: 100, defaultValue: null, modelName: SecondaryRoadBound , Coded Values: [Eastbound: Eastbound] , [Southbound: Southbound] , [Northbound: Northbound] , ...1 more... )
• SecondarySideOfRoad ( type: esriFieldTypeString, alias: Side of the Road (Secondary), editable: true, nullable: true, length: 100, defaultValue: null, modelName: SecondarySideOfRoad , Coded Values: [North: North] , [East: East] , [South: South] , ...1 more... )
• DigitalPermitNumber ( type: esriFieldTypeString, alias: Digital Permit #, editable: true, nullable: true, length: 10, defaultValue: null, modelName: DigitalPermitNumber )
• PermitStatus ( type: esriFieldTypeString, alias: Permit Status, editable: true, nullable: true, length: 30, defaultValue: null, modelName: PermitStatus , Coded Values: [H: Hearing Pending] , [I: Issued] , [N: Reinstated] , ...5 more... )
• Map21 ( type: esriFieldTypeString, alias: MAP-21, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Map21 , Coded Values: [Yes: Yes] , [No: No] )
• SignOwner ( type: esriFieldTypeString, alias: Permit Holder, editable: true, nullable: true, length: 100, defaultValue: null, modelName: SignOwner )
• SignType ( type: esriFieldTypeString, alias: Sign Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SignType , Coded Values: [A: Advertising] , [C: Cluster] , [D: Directional] , ...4 more... )
• SignPostType ( type: esriFieldTypeString, alias: Sign Post (#/Type), editable: true, nullable: true, length: 50, defaultValue: null, modelName: SignPostType , Coded Values: [1-Wood: 1-Wood] , [2-Wood: 2-Wood] , [3-Wood: 3-Wood] , ...18 more... )
• MessageDisplay ( type: esriFieldTypeString, alias: Message Display, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MessageDisplay , Coded Values: [Static: Static] , [Digital: Digital] , [Tri-Vision: Tri-Vision] )
• SignLegend ( type: esriFieldTypeString, alias: Sign Legend, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SignLegend )
• BusinessServiceSign ( type: esriFieldTypeString, alias: Business/Service Sign, editable: true, nullable: true, length: 3, defaultValue: null, modelName: BusinessServiceSign , Coded Values: [Yes: Yes] , [No: No] )
• Illuminated ( type: esriFieldTypeString, alias: Illuminated, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Illuminated , Coded Values: [Yes: Yes] , [No: No] )
• ViewingConeAgreement ( type: esriFieldTypeString, alias: Viewing Cone Agreement, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ViewingConeAgreement , Coded Values: [Default: Default] , [Shifted: Shifted] )
• Height ( type: esriFieldTypeDouble, alias: Sign Height (ft), editable: true, nullable: true, defaultValue: null, modelName: Height )
• Width ( type: esriFieldTypeDouble, alias: Sign Width (ft), editable: true, nullable: true, defaultValue: null, modelName: Width )
• FileNumber ( type: esriFieldTypeString, alias: File Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FileNumber )
• MdotRegions ( type: esriFieldTypeString, alias: Region, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MdotRegions , Coded Values: [Superior: Superior] , [North: North] , [Grand: Grand] , ...4 more... )
• InspectionDate ( type: esriFieldTypeDate, alias: Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InspectionDate )
• PreviousInspectionDate ( type: esriFieldTypeDate, alias: Previous Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PreviousInspectionDate )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Templates:

• Name: Billboards
  Description:
  Prototype:
  PreviousInspectionDate: null
  PR: null
  PRMP: null
  CS: null
  CSMP: null
  Route: null
  StreetName: null
  RoadBound: null
  SideOfRoad: null
  County: null
  PermitNumber: null
  SecondPermitNumber: null
  SecondaryPr: null
  SecondaryPrMp: null
  SecondaryCs: null
  SecondaryCsMp: null
  SecondaryRoute: null
  SecondaryStreetName: null
  SecondaryRoadBound: null
  SecondarySideOfRoad: null
  DigitalPermitNumber: null
  PermitStatus: null
  Map21: null
  SignOwner: null
  SignType: null
  SignPostType: null
  MessageDisplay: null
  SignLegend: null
  BusinessServiceSign: null
  Illuminated: null
  ViewingConeAgreement: null
  Height: null
  Width: null
  FileNumber: null
  MdotRegions: null
  InspectionDate: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: SystemCreateDate
• Creator Field: UserCreate
• Edit Date Field: SystemModifiedDate
• Editor Field: UserModified

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata