Name: File Plan Database 2020

Display Field: FileCaseNumber

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• FileCaseNumber ( type: esriFieldTypeString, alias: FileCaseNumber, length: 255 )
• APNNumber ( type: esriFieldTypeString, alias: APNNumber, length: 255 )
• Project ( type: esriFieldTypeString, alias: Project, length: 50 )
• APNNumber_1 ( type: esriFieldTypeString, alias: APNNumber_1, length: 50 )
• APNNumber2 ( type: esriFieldTypeString, alias: APNNumber2, length: 20 )
• APNNumber3 ( type: esriFieldTypeString, alias: APNNumber3, length: 20 )
• APNNumber4 ( type: esriFieldTypeString, alias: APNNumber4, length: 20 )
• ProjectDescription ( type: esriFieldTypeString, alias: ProjectDescription, length: 100 )
• SPR ( type: esriFieldTypeString, alias: SPR, length: 50 )
• ProjectStreetNumber ( type: esriFieldTypeString, alias: ProjectStreetNumber, length: 20 )
• StreetName ( type: esriFieldTypeString, alias: StreetName, length: 50 )
• Applicant_sFirstName ( type: esriFieldTypeString, alias: Applicant_sFirstName, length: 50 )
• Applicant_sLastName ( type: esriFieldTypeString, alias: Applicant_sLastName, length: 50 )
• Applicant_sCompany ( type: esriFieldTypeString, alias: Applicant_sCompany, length: 50 )
• Applicant_sAddress ( type: esriFieldTypeString, alias: Applicant_sAddress, length: 50 )
• Applicant_sCity ( type: esriFieldTypeString, alias: Applicant_sCity, length: 30 )
• Applicant_sState ( type: esriFieldTypeString, alias: Applicant_sState, length: 5 )
• Applicant_sZipCode ( type: esriFieldTypeString, alias: Applicant_sZipCode, length: 20 )
• Applicant_sEmail ( type: esriFieldTypeString, alias: Applicant_sEmail, length: 50 )
• Applicant_sphone ( type: esriFieldTypeString, alias: Applicant_sphone, length: 20 )
• Applicant_sfax ( type: esriFieldTypeString, alias: Applicant_sfax, length: 20 )
• PropertyOwner_sFirstName ( type: esriFieldTypeString, alias: PropertyOwner_sFirstName, length: 50 )
• PropertyOwner_sLastName ( type: esriFieldTypeString, alias: PropertyOwner_sLastName, length: 50 )
• PropertyOwner_sAddress ( type: esriFieldTypeString, alias: PropertyOwner_sAddress, length: 50 )
• PropertyOwner_sCity ( type: esriFieldTypeString, alias: PropertyOwner_sCity, length: 30 )
• PropertyOwner_sState ( type: esriFieldTypeString, alias: PropertyOwner_sState, length: 5 )
• PropertyOwner_sZip ( type: esriFieldTypeString, alias: PropertyOwner_sZip, length: 20 )
• PropertyOwner_sEmail ( type: esriFieldTypeString, alias: PropertyOwner_sEmail, length: 50 )
• PropertyOwner_sPhone ( type: esriFieldTypeString, alias: PropertyOwner_sPhone, length: 20 )
• PropertyOwner_sFax ( type: esriFieldTypeString, alias: PropertyOwner_sFax, length: 20 )
• PropertyOwner_sCell ( type: esriFieldTypeString, alias: PropertyOwner_sCell, length: 20 )
• Consultant_sName ( type: esriFieldTypeString, alias: Consultant_sName, length: 50 )
• Consultant_sCoName ( type: esriFieldTypeString, alias: Consultant_sCoName, length: 50 )
• Consultant_sAddress ( type: esriFieldTypeString, alias: Consultant_sAddress, length: 50 )
• Consultant_sCity ( type: esriFieldTypeString, alias: Consultant_sCity, length: 30 )
• Consultant_sState ( type: esriFieldTypeString, alias: Consultant_sState, length: 5 )
• Consultant_sZip ( type: esriFieldTypeString, alias: Consultant_sZip, length: 20 )
• Consultant_sPhone ( type: esriFieldTypeString, alias: Consultant_sPhone, length: 20 )
• Consultant_sCellPhone ( type: esriFieldTypeString, alias: Consultant_sCellPhone, length: 20 )
• Consultant_sEmail ( type: esriFieldTypeString, alias: Consultant_sEmail, length: 50 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 100 )
• SubmittalDate ( type: esriFieldTypeDate, alias: SubmittalDate, length: 8 )
• Initial_ReturnDate ( type: esriFieldTypeString, alias: Initial_ReturnDate, length: 50 )
• ReasonForReturn ( type: esriFieldTypeString, alias: ReasonForReturn, length: 50 )
• ApplicationCompleteDate ( type: esriFieldTypeString, alias: ApplicationCompleteDate, length: 50 )
• F_DaysToFirstReview ( type: esriFieldTypeInteger, alias: F_DaysToFirstReview )
• EnvironmentalReview ( type: esriFieldTypeString, alias: EnvironmentalReview, length: 50 )
• NOI_NOD ( type: esriFieldTypeDate, alias: NOI_NOD, length: 8 )
• DateNoticeSentToPublisher ( type: esriFieldTypeDate, alias: DateNoticeSentToPublisher, length: 8 )
• DateNoticeSentToPropertyOwner ( type: esriFieldTypeDate, alias: DateNoticeSentToPropertyOwner, length: 8 )
• Pre_DAB ( type: esriFieldTypeDate, alias: Pre_DAB, length: 8 )
• DAB ( type: esriFieldTypeDate, alias: DAB, length: 8 )
• DRB ( type: esriFieldTypeDate, alias: DRB, length: 8 )
• HPC ( type: esriFieldTypeDate, alias: HPC, length: 8 )
• PC ( type: esriFieldTypeDate, alias: PC, length: 8 )
• CC ( type: esriFieldTypeDate, alias: CC, length: 8 )
• Resolution ( type: esriFieldTypeString, alias: Resolution, length: 20 )
• Action ( type: esriFieldTypeString, alias: Action, length: 50 )
• ApplicationAppealEndDate ( type: esriFieldTypeDate, alias: ApplicationAppealEndDate, length: 8 )
• ApprovalDate ( type: esriFieldTypeDate, alias: ApprovalDate, length: 8 )
• OriginalExpDate ( type: esriFieldTypeDate, alias: OriginalExpDate, length: 8 )
• ExpDateWithExtension ( type: esriFieldTypeDate, alias: ExpDateWithExtension, length: 8 )
• DateExtensionLetterSent ( type: esriFieldTypeDate, alias: DateExtensionLetterSent, length: 8 )
• BuildingPermitNumber ( type: esriFieldTypeString, alias: BuildingPermitNumber, length: 50 )
• DatePermitIssued ( type: esriFieldTypeDate, alias: DatePermitIssued, length: 8 )
• StaffAssignedTo_ ( type: esriFieldTypeString, alias: StaffAssignedTo_, length: 50 )
• MapUpdated ( type: esriFieldTypeSmallInteger, alias: MapUpdated )
• ApplicationFee ( type: esriFieldTypeDouble, alias: ApplicationFee )
• CurrentProject ( type: esriFieldTypeSmallInteger, alias: CurrentProject )
• ReceiptNumber ( type: esriFieldTypeInteger, alias: ReceiptNumber )
• ProjectType ( type: esriFieldTypeString, alias: ProjectType, length: 50 )
• SortOrder ( type: esriFieldTypeString, alias: SortOrder, length: 255 )
• UnivProjNumber ( type: esriFieldTypeString, alias: UnivProjNumber, length: 50 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata