Name: Incidents

Display Field:

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Min. Scale: 73957191

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -13822672.8099686
YMin: 3033043.48083996
XMax: -7645975.34471932
YMax: 6269392.86195837
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"RedSphere.png","imageData":"iVBORw0KGgoAAAANSUhEUgAAAEAAAABACAYAAACqaXHeAAAABGdBTUEAALGPC/xhBQAAACBjSFJNAAB6JgAAgIQAAPoAAACA6AAAdTAAAOpgAAA6mAAAF3CculE8AAAACXBIWXMAAA7DAAAOwwHHb6hkAAAAGXRFWHRTb2Z0d2FyZQBQYWludC5ORVQgdjMuNS4xTuc4+QAAB3VJREFUeF7tmPlTlEcexnve94U5mANQbgQSbgiHXHINlxpRIBpRI6wHorLERUmIisKCQWM8cqigESVQS1Kx1piNi4mW2YpbcZONrilE140RCTcy3DDAcL/zbJP8CYPDL+9Ufau7uqb7eZ7P+/a8PS8hwkcgIBAQCAgEBAICAYGAQEAgIBAQCAgEBAICAYGAQEAgIBAQCDx/AoowKXFMUhD3lQrioZaQRVRS+fxl51eBTZUTdZ41U1Rox13/0JF9csGJ05Qv4jSz/YPWohtvLmSKN5iTGGqTm1+rc6weICOBRbZs1UVnrv87T1PUeovxyNsUP9P6n5cpHtCxu24cbrmwKLdj+osWiqrVKhI0xzbmZ7m1SpJ+1pFpvE2DPvGTomOxAoNLLKGLscZYvB10cbYYjrJCb7A5mrxleOBqim+cWJRakZY0JfnD/LieI9V1MrKtwokbrAtU4Vm0A3TJnphJD4B+RxD0u0LA7w7FTE4oprOCMbklEGNrfdGf4IqnQTb4wc0MFTYibZqM7JgjO8ZdJkpMln/sKu16pHZGb7IfptIWg389DPp9kcChWODoMuDdBOhL1JgpisbUvghM7AqFbtNiaFP80RLnhbuBdqi0N+1dbUpWGde9gWpuhFi95yL7sS7BA93JAb+Fn8mh4QujgPeTgb9kAZf3Apd2A+fXQ38yHjOHozB1IAJjOSEY2RSIwVUv4dd4X9wJccGHNrJ7CYQ4GGjLeNNfM+dyvgpzQstKf3pbB2A6m97uBRE0/Ergcxr8hyqg7hrwn0vAtRIKIRX6Y2pMl0RhIj8co9nBGFrvh55l3ngU7YObng7IVnFvGS+BYUpmHziY/Ls2zgP9SX50by/G9N5w6I+ogYvpwK1SoOlHQNsGfWcd9Peqof88B/rTyzF9hAIopAByQzC0JQB9ST5oVnvhnt+LOGsprvUhxNIwa0aY7cGR6Cp7tr8+whkjawIxkRWC6YJI6N+lAKq3Qf/Tx+B77oGfaQc/8hB8w2Xwtw9Bf3kzZspXY/JIDEbfpAB2BKLvVV90Jvjgoac9vpRxE8kciTVCBMMkNirJ7k/tRHyjtxwjKV4Yp3t/6s+R4E+/DH3N6+BrS8E314Dvvg2+/Sb4hxfBf5sP/up2TF3ZhonK1zD6dhwGdwail26DzqgX8MRKiq9ZBpkSkmeYOyPM3m9Jjl+1Z9D8AgNtlAq6bZ70qsZi+q+bwV/7I/hbB8D/dAr8Axq89iz474p/G5++koHJy1sx/lkGdBc2YjA3HF0rHNHuboomuQj/5DgclIvOGCGCYRKFFuTMV7YUAD3VDQaLMfyqBcZORGPy01QKYSNm/rYV/Nd/Av9NHvgbueBrsjDzRQamKKDxT9Kgq1iLkbIUDOSHoiNcgnYHgnYZi+9ZExSbiSoMc2eE2flKcuJLa4KGRQz6/U0wlGaP0feiMH4uFpMXEjBVlYjp6lWY+SSZtim0kulYMiYuJEJXuhTDJ9UYPByOvoIwdCxfgE4bAo0Jh39xLAoVpMwIEQyTyFCQvGpLon9sJ0K3J4OBDDcMH1dj9FQsxkrjMPFRPCbOx2GyfLal9VEcxstioTulxjAFNfROJPqLl6Bnfyg6V7ugz5yBhuHwrZjBdiU5YJg7I8wOpifAKoVIW7uQ3rpOBH2b3ekVjYT2WCRG3o+mIGKgO0OrlIaebU/HYOQDNbQnojB4NJyGD0NPfjA0bwTRE6Q7hsUcWhkWN8yZqSQlWWGECAZLmJfJmbrvVSI8taK37xpbdB/wQW8xPee/8xIGjvlj8IQ/hk4G0JbWcX8MHPVDX4kveoq8ocn3xLM33NCZRcPHOGJYZIKfpQyq7JjHS6yJjcHujLHADgkpuC7h8F8zEVqXSNC2awE69lqhs8AamkO26HrbDt2H7dBVQov2NcW26CiwQtu+BWjdY4n2nZboTbfCmKcCnRyDO/YmyLPnDlHvjDH8G6zhS9/wlEnYR7X00fWrFYuWdVI0ZpuhcbcczW/R2qdAcz6t/bRov4mONeaaoYl+p22rHF0bVNAmKtBvweIXGxNcfFH8eNlC4m6wMWMusEnKpn5hyo48pj9gLe4SNG9QoGGLAk8z5XiaJUd99u8122/IpBA2K9BGg2vWWKAvRYVeLzEa7E1R422m2+MsSTem97nSYnfKyN6/mzATv7AUgqcMrUnmaFlLX3ysM0fj+t/b5lQLtK22QEfyAmiSLKFZpUJ7kBRPXKW4HqCYynWVHKSG2LkyZex1uO1mZM9lKem9Tx9jjY5iNEYo0bKMhn7ZAu0r6H5PpLXCAq0rKJClSjSGynE/QIkrQYqBPe6S2X+AJsY2Ped6iWZk6RlL0c2r5szofRsO9R5S1IfQLRCpQL1aifoYFerpsbkuTImaUJXuXIDiH6/Ys8vm3Mg8L2i20YqsO7fItKLcSXyn0kXccclVqv3MS6at9JU/Ox+ouns+SF6Z4cSupz7l8+z1ucs7LF1AQjOdxfGZzmx8Iu1TRcfnrioICAQEAgIBgYBAQCAgEBAICAQEAgIBgYBAQCAgEBAICAQEAv8H44b/6ZiGvGAAAAAASUVORK5CYII=","contentType":"image/png","width":15,"height":15}}}

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: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• SourceOID (type: esriFieldTypeInteger, alias: SourceOID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ABCDMisc (type: esriFieldTypeString, alias: ABCDMisc, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• ADSPermissionState (type: esriFieldTypeString, alias: ADSPermissionState, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• ContainmentDateTime (type: esriFieldTypeDate, alias: ContainmentDateTime, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ControlDateTime (type: esriFieldTypeDate, alias: ControlDateTime, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CreatedBySystem (type: esriFieldTypeString, alias: CreatedBySystem, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• IncidentSize (type: esriFieldTypeDouble, alias: IncidentSize, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DiscoveryAcres (type: esriFieldTypeDouble, alias: DiscoveryAcres, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DispatchCenterID (type: esriFieldTypeString, alias: DispatchCenterID, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• EstimatedCostToDate (type: esriFieldTypeDouble, alias: EstimatedCostToDate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FinalAcres (type: esriFieldTypeDouble, alias: FinalAcres, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FinalFireReportApprovedByTitle (type: esriFieldTypeString, alias: FinalFireReportApprovedByTitle, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• FinalFireReportApprovedByUnit (type: esriFieldTypeString, alias: FinalFireReportApprovedByUnit, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• FinalFireReportApprovedDate (type: esriFieldTypeDate, alias: FinalFireReportApprovedDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• FireBehaviorGeneral (type: esriFieldTypeString, alias: FireBehaviorGeneral, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• FireBehaviorGeneral1 (type: esriFieldTypeString, alias: FireBehaviorGeneral1, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FireBehaviorGeneral2 (type: esriFieldTypeString, alias: FireBehaviorGeneral2, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FireBehaviorGeneral3 (type: esriFieldTypeString, alias: FireBehaviorGeneral3, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FireCause (type: esriFieldTypeString, alias: FireCause, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• FireCauseGeneral (type: esriFieldTypeString, alias: FireCauseGeneral, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• FireCauseSpecific (type: esriFieldTypeString, alias: FireCauseSpecific, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• FireCode (type: esriFieldTypeString, alias: FireCode, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• FireDepartmentID (type: esriFieldTypeString, alias: FireDepartmentID, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• FireDiscoveryDateTime (type: esriFieldTypeDate, alias: FireDiscoveryDateTime, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• FireMgmtComplexity (type: esriFieldTypeString, alias: FireMgmtComplexity, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• FireOutDateTime (type: esriFieldTypeDate, alias: FireOutDateTime, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• FireStrategyConfinePercent (type: esriFieldTypeSmallInteger, alias: FireStrategyConfinePercent, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FireStrategyFullSuppPercent (type: esriFieldTypeSmallInteger, alias: FireStrategyFullSuppPercent, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FireStrategyMonitorPercent (type: esriFieldTypeSmallInteger, alias: FireStrategyMonitorPercent, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FireStrategyPointZonePercent (type: esriFieldTypeSmallInteger, alias: FireStrategyPointZonePercent, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FSJobCode (type: esriFieldTypeString, alias: FSJobCode, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• FSOverrideCode (type: esriFieldTypeString, alias: FSOverrideCode, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• GACC (type: esriFieldTypeString, alias: GACC, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ICS209ReportDateTime (type: esriFieldTypeDate, alias: ICS209ReportDateTime, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ICS209ReportForTimePeriodFrom (type: esriFieldTypeDate, alias: ICS209ReportForTimePeriodFrom, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ICS209ReportForTimePeriodTo (type: esriFieldTypeDate, alias: ICS209ReportForTimePeriodTo, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ICS209ReportStatus (type: esriFieldTypeString, alias: ICS209ReportStatus, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• IncidentManagementOrganization (type: esriFieldTypeString, alias: IncidentManagementOrganization, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• IncidentName (type: esriFieldTypeString, alias: IncidentName, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• IncidentShortDescription (type: esriFieldTypeString, alias: IncidentShortDescription, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• IncidentTypeCategory (type: esriFieldTypeString, alias: IncidentTypeCategory, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• IncidentTypeKind (type: esriFieldTypeString, alias: IncidentTypeKind, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• InitialLatitude (type: esriFieldTypeDouble, alias: InitialLatitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• InitialLongitude (type: esriFieldTypeDouble, alias: InitialLongitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• InitialResponseAcres (type: esriFieldTypeDouble, alias: InitialResponseAcres, SQL Type: sqlTypeOther, nullable: true, editable: true)
• InitialResponseDateTime (type: esriFieldTypeDate, alias: InitialResponseDateTime, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• IrwinID (type: esriFieldTypeString, alias: IrwinID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• IsFireCauseInvestigated (type: esriFieldTypeSmallInteger, alias: IsFireCauseInvestigated, SQL Type: sqlTypeOther, nullable: true, editable: true)
• IsFireCodeRequested (type: esriFieldTypeSmallInteger, alias: IsFireCodeRequested, SQL Type: sqlTypeOther, nullable: true, editable: true)
• IsFSAssisted (type: esriFieldTypeSmallInteger, alias: IsFSAssisted, SQL Type: sqlTypeOther, nullable: true, editable: true)
• IsMultiJurisdictional (type: esriFieldTypeSmallInteger, alias: IsMultiJurisdictional, SQL Type: sqlTypeOther, nullable: true, editable: true)
• IsReimbursable (type: esriFieldTypeSmallInteger, alias: IsReimbursable, SQL Type: sqlTypeOther, nullable: true, editable: true)
• IsTrespass (type: esriFieldTypeSmallInteger, alias: IsTrespass, SQL Type: sqlTypeOther, nullable: true, editable: true)
• IsUnifiedCommand (type: esriFieldTypeSmallInteger, alias: IsUnifiedCommand, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LocalIncidentIdentifier (type: esriFieldTypeString, alias: LocalIncidentIdentifier, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• ModifiedBySystem (type: esriFieldTypeString, alias: ModifiedBySystem, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PercentContained (type: esriFieldTypeDouble, alias: PercentContained, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PercentPerimeterToBeContained (type: esriFieldTypeDouble, alias: PercentPerimeterToBeContained, SQL Type: sqlTypeOther, nullable: true, editable: true)
• POOCity (type: esriFieldTypeString, alias: POOCity, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• POOCounty (type: esriFieldTypeString, alias: POOCounty, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• POODispatchCenterID (type: esriFieldTypeString, alias: POODispatchCenterID, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• POOFips (type: esriFieldTypeString, alias: POOFips, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• POOJurisdictionalAgency (type: esriFieldTypeString, alias: POOJurisdictionalAgency, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• POOJurisdictionalUnit (type: esriFieldTypeString, alias: POOJurisdictionalUnit, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• POOJurisdictionalUnitParentUnit (type: esriFieldTypeString, alias: POOJurisdictionalUnitParentUnit, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• POOLandownerCategory (type: esriFieldTypeString, alias: POOLandownerCategory, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true)
• POOLandownerKind (type: esriFieldTypeString, alias: POOLandownerKind, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true)
• POOLegalDescPrincipalMeridian (type: esriFieldTypeString, alias: POOLegalDescPrincipalMeridian, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• POOLegalDescQtr (type: esriFieldTypeString, alias: POOLegalDescQtr, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• POOLegalDescQtrQtr (type: esriFieldTypeString, alias: POOLegalDescQtrQtr, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• POOLegalDescRange (type: esriFieldTypeString, alias: POOLegalDescRange, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• POOLegalDescSection (type: esriFieldTypeSmallInteger, alias: POOLegalDescSection, SQL Type: sqlTypeOther, nullable: true, editable: true)
• POOLegalDescTownship (type: esriFieldTypeString, alias: POOLegalDescTownship, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• POOPredictiveServiceAreaID (type: esriFieldTypeString, alias: POOPredictiveServiceAreaID, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• POOProtectingAgency (type: esriFieldTypeString, alias: POOProtectingAgency, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• POOProtectingUnit (type: esriFieldTypeString, alias: POOProtectingUnit, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• POOState (type: esriFieldTypeString, alias: POOState, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• PredominantFuelGroup (type: esriFieldTypeString, alias: PredominantFuelGroup, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• PredominantFuelModel (type: esriFieldTypeString, alias: PredominantFuelModel, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• PrimaryFuelModel (type: esriFieldTypeString, alias: PrimaryFuelModel, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• SecondaryFuelModel (type: esriFieldTypeString, alias: SecondaryFuelModel, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• TotalIncidentPersonnel (type: esriFieldTypeInteger, alias: TotalIncidentPersonnel, SQL Type: sqlTypeOther, nullable: true, editable: true)
• UniqueFireIdentifier (type: esriFieldTypeString, alias: UniqueFireIdentifier, SQL Type: sqlTypeOther, length: 22, nullable: true, editable: true)
• WFDSSDecisionStatus (type: esriFieldTypeString, alias: WFDSSDecisionStatus, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• EstimatedFinalCost (type: esriFieldTypeDouble, alias: EstimatedFinalCost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OrganizationalAssessment (type: esriFieldTypeString, alias: OrganizationalAssessment, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• StrategicDecisionPublishDate (type: esriFieldTypeDate, alias: StrategicDecisionPublishDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CreatedOnDateTime_dt (type: esriFieldTypeDate, alias: CreatedOnDateTime_dt, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ModifiedOnDateTime_dt (type: esriFieldTypeDate, alias: ModifiedOnDateTime_dt, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• IsCpxChild (type: esriFieldTypeSmallInteger, alias: IsCpxChild, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CpxName (type: esriFieldTypeString, alias: CpxName, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• CpxID (type: esriFieldTypeString, alias: CpxID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• SourceGlobalID (type: esriFieldTypeString, alias: SourceGlobalID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• IncidentComplexityLevel (type: esriFieldTypeString, alias: IncidentComplexityLevel, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• ActiveFireCandidate (type: esriFieldTypeInteger, alias: ActiveFireCandidate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Templates:

Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 11/22/2024 4:02:54 AM

Schema Last Edit Date: 11/22/2024 4:02:54 AM

Data Last Edit Date: 11/22/2024 4:02:36 AM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Boxplots   Add Features   Update Features   Delete Features   Apply Edits   Streaming   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat