Name: miamidade_procurement_data_2015

Display Field:

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: ObjectId

Unique ID Field:

Name : ObjectId

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• PoNumber (type: esriFieldTypeString, alias: PoNumber, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• CreateDate (type: esriFieldTypeDate, alias: CreateDate, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Amount (type: esriFieldTypeDouble, alias: Amount, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• LineNumber (type: esriFieldTypeInteger, alias: LineNumber, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Commodity (type: esriFieldTypeInteger, alias: Commodity, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Quantity (type: esriFieldTypeDouble, alias: Quantity, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Size (type: esriFieldTypeString, alias: Size, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• UnitCost (type: esriFieldTypeDouble, alias: UnitCost, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• AreaCode (type: esriFieldTypeDouble, alias: AreaCode, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Phone (type: esriFieldTypeString, alias: Phone, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• PhoneExtension (type: esriFieldTypeString, alias: PhoneExtension, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Street (type: esriFieldTypeString, alias: Street, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• State (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• ZipCode (type: esriFieldTypeString, alias: ZipCode, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Country (type: esriFieldTypeString, alias: Country, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• VendorName (type: esriFieldTypeString, alias: VendorName, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• CommodityName (type: esriFieldTypeString, alias: CommodityName, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Term1 (type: esriFieldTypeString, alias: Term1, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Term2 (type: esriFieldTypeString, alias: Term2, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Term3 (type: esriFieldTypeString, alias: Term3, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Term4 (type: esriFieldTypeString, alias: Term4, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Term5 (type: esriFieldTypeString, alias: Term5, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Term6 (type: esriFieldTypeString, alias: Term6, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Term7 (type: esriFieldTypeString, alias: Term7, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Term8 (type: esriFieldTypeString, alias: Term8, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Term9 (type: esriFieldTypeString, alias: Term9, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Term10 (type: esriFieldTypeString, alias: Term10, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• ticket_year (type: esriFieldTypeInteger, alias: ticket_year, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/5/2023 4:09:23 PM

Schema Last Edit Date: 4/5/2023 4:09:23 PM

Data Last Edit Date: 10/4/2021 3:02:13 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat