Name: MD_ExecutiveHomes

Display Field: GISLink

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

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:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• ID (type: esriFieldTypeDouble, alias: ID, SQL Type: sqlTypeOther, nullable: false, editable: true)
• AssessmentID (type: esriFieldTypeDouble, alias: AssessmentID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Description (type: esriFieldTypeString, alias: Description, SQL Type: sqlTypeOther, length: 60, nullable: false, editable: true)
• Story (type: esriFieldTypeString, alias: Story, SQL Type: sqlTypeOther, length: 30, nullable: false, editable: true)
• Occupancy (type: esriFieldTypeString, alias: Occupancy, SQL Type: sqlTypeOther, length: 30, nullable: false, editable: true)
• ExteriorWall (type: esriFieldTypeString, alias: ExteriorWall, SQL Type: sqlTypeOther, length: 30, nullable: false, editable: true)
• RoofType (type: esriFieldTypeString, alias: RoofType, SQL Type: sqlTypeOther, length: 30, nullable: false, editable: true)
• YearBuilt (type: esriFieldTypeString, alias: YearBuilt, SQL Type: sqlTypeOther, length: 4, nullable: false, editable: true)
• ActualAge (type: esriFieldTypeSmallInteger, alias: ActualAge, SQL Type: sqlTypeOther, nullable: false, editable: true)
• EffectiveYearBuilt (type: esriFieldTypeString, alias: EffectiveYearBuilt, SQL Type: sqlTypeOther, length: 4, nullable: false, editable: true)
• EffectiveAge (type: esriFieldTypeSmallInteger, alias: EffectiveAge, SQL Type: sqlTypeOther, nullable: false, editable: true)
• YearRemodeled (type: esriFieldTypeString, alias: YearRemodeled, SQL Type: sqlTypeOther, length: 4, nullable: false, editable: true)
• HeatingType (type: esriFieldTypeString, alias: HeatingType, SQL Type: sqlTypeOther, length: 30, nullable: false, editable: true)
• CoolingType (type: esriFieldTypeString, alias: CoolingType, SQL Type: sqlTypeOther, length: 30, nullable: false, editable: true)
• LivingUnits (type: esriFieldTypeSmallInteger, alias: LivingUnits, SQL Type: sqlTypeOther, nullable: false, editable: true)
• Bedrooms (type: esriFieldTypeSmallInteger, alias: Bedrooms, SQL Type: sqlTypeOther, nullable: false, editable: true)
• FamilyRooms (type: esriFieldTypeSmallInteger, alias: FamilyRooms, SQL Type: sqlTypeOther, nullable: false, editable: true)
• OtherRooms (type: esriFieldTypeSmallInteger, alias: OtherRooms, SQL Type: sqlTypeOther, nullable: false, editable: true)
• FullBaths (type: esriFieldTypeSmallInteger, alias: FullBaths, SQL Type: sqlTypeOther, nullable: false, editable: true)
• HalfBaths (type: esriFieldTypeSmallInteger, alias: HalfBaths, SQL Type: sqlTypeOther, nullable: false, editable: true)
• AdditionalFixtures (type: esriFieldTypeSmallInteger, alias: AdditionalFixtures, SQL Type: sqlTypeOther, nullable: false, editable: true)
• PlumbingRoughIns (type: esriFieldTypeSmallInteger, alias: PlumbingRoughIns, SQL Type: sqlTypeOther, nullable: false, editable: true)
• Whirlpools (type: esriFieldTypeSmallInteger, alias: Whirlpools, SQL Type: sqlTypeOther, nullable: false, editable: true)
• HotTubs (type: esriFieldTypeSmallInteger, alias: HotTubs, SQL Type: sqlTypeOther, nullable: false, editable: true)
• EquipmentRating (type: esriFieldTypeString, alias: EquipmentRating, SQL Type: sqlTypeOther, length: 15, nullable: false, editable: true)
• KitchenRating (type: esriFieldTypeString, alias: KitchenRating, SQL Type: sqlTypeOther, length: 15, nullable: false, editable: true)
• BathRating (type: esriFieldTypeString, alias: BathRating, SQL Type: sqlTypeOther, length: 15, nullable: false, editable: true)
• InteriorRating (type: esriFieldTypeString, alias: InteriorRating, SQL Type: sqlTypeOther, length: 15, nullable: false, editable: true)
• ExteriorRating (type: esriFieldTypeString, alias: ExteriorRating, SQL Type: sqlTypeOther, length: 15, nullable: false, editable: true)
• MasonrySF (type: esriFieldTypeSmallInteger, alias: MasonrySF, SQL Type: sqlTypeOther, nullable: false, editable: true)
• MasonryFireplaceStacks (type: esriFieldTypeSmallInteger, alias: MasonryFireplaceStacks, SQL Type: sqlTypeOther, nullable: false, editable: true)
• MasonryFireplaceAdditionalStori (type: esriFieldTypeSmallInteger, alias: MasonryFireplaceAdditionalStori, SQL Type: sqlTypeOther, nullable: false, editable: true)
• MasonryFireplaceOpenings (type: esriFieldTypeSmallInteger, alias: MasonryFireplaceOpenings, SQL Type: sqlTypeOther, nullable: false, editable: true)
• MetalFireplaceStacks (type: esriFieldTypeSmallInteger, alias: MetalFireplaceStacks, SQL Type: sqlTypeOther, nullable: false, editable: true)
• MetalFireplaceAdditionalStories (type: esriFieldTypeSmallInteger, alias: MetalFireplaceAdditionalStories, SQL Type: sqlTypeOther, nullable: false, editable: true)
• MetalFireplaceOpenings (type: esriFieldTypeSmallInteger, alias: MetalFireplaceOpenings, SQL Type: sqlTypeOther, nullable: false, editable: true)
• GasFireplaceOpenings (type: esriFieldTypeSmallInteger, alias: GasFireplaceOpenings, SQL Type: sqlTypeOther, nullable: false, editable: true)
• BasementGarageStalls (type: esriFieldTypeSmallInteger, alias: BasementGarageStalls, SQL Type: sqlTypeOther, nullable: false, editable: true)
• ShedDormersLF (type: esriFieldTypeSmallInteger, alias: ShedDormersLF, SQL Type: sqlTypeOther, nullable: false, editable: true)
• GableDormersLF (type: esriFieldTypeSmallInteger, alias: GableDormersLF, SQL Type: sqlTypeOther, nullable: false, editable: true)
• Grade (type: esriFieldTypeString, alias: Grade, SQL Type: sqlTypeOther, length: 5, nullable: false, editable: true)
• CDURating (type: esriFieldTypeString, alias: CDURating, SQL Type: sqlTypeOther, length: 15, nullable: false, editable: true)
• PercentComplete (type: esriFieldTypeDouble, alias: PercentComplete, SQL Type: sqlTypeOther, nullable: false, editable: true)
• PercentGoodOverride (type: esriFieldTypeDouble, alias: PercentGoodOverride, SQL Type: sqlTypeOther, nullable: false, editable: true)
• FullBasementSF (type: esriFieldTypeSmallInteger, alias: FullBasementSF, SQL Type: sqlTypeOther, nullable: false, editable: true)
• CrawlSpaceSF (type: esriFieldTypeSmallInteger, alias: CrawlSpaceSF, SQL Type: sqlTypeOther, nullable: false, editable: true)
• RecRoomSF (type: esriFieldTypeSmallInteger, alias: RecRoomSF, SQL Type: sqlTypeOther, nullable: false, editable: true)
• RecRoomRating (type: esriFieldTypeString, alias: RecRoomRating, SQL Type: sqlTypeOther, length: 15, nullable: false, editable: true)
• FBLASF (type: esriFieldTypeSmallInteger, alias: FBLASF, SQL Type: sqlTypeOther, nullable: false, editable: true)
• FirstFloorSF (type: esriFieldTypeSmallInteger, alias: FirstFloorSF, SQL Type: sqlTypeOther, nullable: false, editable: true)
• SecondFloorSF (type: esriFieldTypeSmallInteger, alias: SecondFloorSF, SQL Type: sqlTypeOther, nullable: false, editable: true)
• ThirdFloorSF (type: esriFieldTypeSmallInteger, alias: ThirdFloorSF, SQL Type: sqlTypeOther, nullable: false, editable: true)
• HalfStorySF (type: esriFieldTypeSmallInteger, alias: HalfStorySF, SQL Type: sqlTypeOther, nullable: false, editable: true)
• FinishedAtticSF (type: esriFieldTypeSmallInteger, alias: FinishedAtticSF, SQL Type: sqlTypeOther, nullable: false, editable: true)
• UnfinishedAtticSF (type: esriFieldTypeSmallInteger, alias: UnfinishedAtticSF, SQL Type: sqlTypeOther, nullable: false, editable: true)
• UnfinishedAreaSF (type: esriFieldTypeSmallInteger, alias: UnfinishedAreaSF, SQL Type: sqlTypeOther, nullable: false, editable: true)
• SFLA (type: esriFieldTypeSmallInteger, alias: SFLA, SQL Type: sqlTypeOther, nullable: false, editable: true)
• MarketValue (type: esriFieldTypeInteger, alias: MarketValue, SQL Type: sqlTypeOther, nullable: false, editable: true)
• TaxClass (type: esriFieldTypeString, alias: TaxClass, SQL Type: sqlTypeOther, length: 20, nullable: false, editable: true)
• AssessedValue (type: esriFieldTypeInteger, alias: AssessedValue, SQL Type: sqlTypeOther, nullable: false, editable: true)
• AssessedAs (type: esriFieldTypeString, alias: AssessedAs, SQL Type: sqlTypeOther, length: 18, nullable: false, editable: true)
• GISLink (type: esriFieldTypeString, alias: GISLink, SQL Type: sqlTypeOther, length: 32, nullable: false, editable: true)
• SketchFilename (type: esriFieldTypeString, alias: SketchFilename, SQL Type: sqlTypeOther, length: 25, nullable: false, editable: true)
• PhotoFilename (type: esriFieldTypeString, alias: PhotoFilename, SQL Type: sqlTypeOther, length: 25, nullable: false, editable: true)
• PhotoFilename2 (type: esriFieldTypeString, alias: PhotoFilename2, SQL Type: sqlTypeOther, length: 25, nullable: false, editable: true)
• PhotoFilename3 (type: esriFieldTypeString, alias: PhotoFilename3, SQL Type: sqlTypeOther, length: 25, nullable: false, editable: true)
• PhotoFilename4 (type: esriFieldTypeString, alias: PhotoFilename4, SQL Type: sqlTypeOther, length: 25, nullable: false, editable: true)
• PhotoFilename5 (type: esriFieldTypeString, alias: PhotoFilename5, SQL Type: sqlTypeOther, length: 25, nullable: false, editable: true)
• PhotoFilename6 (type: esriFieldTypeString, alias: PhotoFilename6, SQL Type: sqlTypeOther, length: 25, nullable: false, 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: MD_ExecutiveHomes
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• PhotoFilename5:
• PhotoFilename6:
• ID: 0
• Description:
• Story:
• Occupancy:
• ExteriorWall:
• RoofType:
• YearBuilt:
• ActualAge: 0
• EffectiveYearBuilt:
• EffectiveAge: 0
• YearRemodeled:
• HeatingType:
• CoolingType:
• LivingUnits: 0
• Bedrooms: 0
• FamilyRooms: 0
• OtherRooms: 0
• FullBaths: 0
• HalfBaths: 0
• AdditionalFixtures: 0
• PlumbingRoughIns: 0
• Whirlpools: 0
• HotTubs: 0
• EquipmentRating:
• KitchenRating:
• BathRating:
• InteriorRating:
• ExteriorRating:
• MasonrySF: 0
• MasonryFireplaceStacks: 0
• MasonryFireplaceAdditionalStori: 0
• MasonryFireplaceOpenings: 0
• MetalFireplaceStacks: 0
• MetalFireplaceAdditionalStories: 0
• MetalFireplaceOpenings: 0
• GasFireplaceOpenings: 0
• BasementGarageStalls: 0
• ShedDormersLF: 0
• GableDormersLF: 0
• Grade:
• CDURating:
• PercentComplete: 0
• PercentGoodOverride: 0
• FullBasementSF: 0
• CrawlSpaceSF: 0
• RecRoomSF: 0
• RecRoomRating:
• FBLASF: 0
• FirstFloorSF: 0
• SecondFloorSF: 0
• ThirdFloorSF: 0
• HalfStorySF: 0
• FinishedAtticSF: 0
• UnfinishedAtticSF: 0
• UnfinishedAreaSF: 0
• SFLA: 0
• MarketValue: 0
• TaxClass:
• AssessedValue: 0
• AssessedAs:
• GISLink:
• SketchFilename:
• PhotoFilename:
• PhotoFilename2:
• PhotoFilename3:
• PhotoFilename4:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/3/2026 5:16:15 PM

Schema Last Edit Date: 3/3/2026 5:16:15 PM

Data Last Edit Date: 3/3/2026 5:15:34 PM

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