Name: CAMA current

Display Field: sale_grantee_name

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

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• ac_type (type: esriFieldTypeSmallInteger, alias: AC Type, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ac_type_description (type: esriFieldTypeString, alias: AC Type Description, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• account_number (type: esriFieldTypeString, alias: Account Number, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• additional_kitchen (type: esriFieldTypeString, alias: Additional Kitchen, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• address_number (type: esriFieldTypeString, alias: Address Number, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• appraised_building (type: esriFieldTypeDouble, alias: Appraised Building, SQL Type: sqlTypeOther, nullable: true, editable: true)
• appraised_extra_feature (type: esriFieldTypeString, alias: Appraised Extra Feature, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• appraised_land (type: esriFieldTypeDouble, alias: Appraised Land, SQL Type: sqlTypeOther, nullable: true, editable: true)
• appraised_outbuilding (type: esriFieldTypeDouble, alias: Appraised Outbuilding, SQL Type: sqlTypeOther, nullable: true, editable: true)
• appraised_total (type: esriFieldTypeDouble, alias: Appraised Total, SQL Type: sqlTypeOther, nullable: true, editable: true)
• assessed_building (type: esriFieldTypeDouble, alias: Assessed Building, SQL Type: sqlTypeOther, nullable: true, editable: true)
• assessed_extra_feature (type: esriFieldTypeString, alias: Assessed Extra Feature, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• assessed_land (type: esriFieldTypeDouble, alias: Assessed Land, SQL Type: sqlTypeOther, nullable: true, editable: true)
• assessed_outbuilding (type: esriFieldTypeDouble, alias: Assessed Outbuilding, SQL Type: sqlTypeOther, nullable: true, editable: true)
• assessed_total (type: esriFieldTypeDouble, alias: Assessed Total, SQL Type: sqlTypeOther, nullable: true, editable: true)
• attic_type (type: esriFieldTypeString, alias: Attic Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• actual_year_built (type: esriFieldTypeDouble, alias: Actual Year Built, SQL Type: sqlTypeOther, nullable: true, editable: true)
• basement_garage (type: esriFieldTypeDouble, alias: Number of Basement Garages, SQL Type: sqlTypeOther, nullable: true, editable: true)
• basement_type (type: esriFieldTypeString, alias: Basement Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• bathroom_style_description (type: esriFieldTypeString, alias: Bathroom Style Description, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• baths_plumbing (type: esriFieldTypeString, alias: Baths Plumbing, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• baths_plumbing_description (type: esriFieldTypeString, alias: Baths Plumbing Description, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• block (type: esriFieldTypeString, alias: Block, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• block_block_cut (type: esriFieldTypeString, alias: Block Block Cut, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• block_cut (type: esriFieldTypeString, alias: Block Cut, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• book_page (type: esriFieldTypeString, alias: Book Page, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• building_photo (type: esriFieldTypeString, alias: Building Photo, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• cama_site_link (type: esriFieldTypeString, alias: Cama Site Link, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ceiling_wall (type: esriFieldTypeString, alias: Ceiling Wall, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ceiling_wall_description (type: esriFieldTypeString, alias: Ceiling Wall Description, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• co_owner (type: esriFieldTypeString, alias: Co Owner, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• comn_wall (type: esriFieldTypeString, alias: Comn Wall, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• condition (type: esriFieldTypeString, alias: Condition, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• condition_description (type: esriFieldTypeString, alias: Condition Description, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• condo_main_id (type: esriFieldTypeString, alias: Condo Main ID, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• depreciation (type: esriFieldTypeDouble, alias: Depreciation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• effective_area (type: esriFieldTypeString, alias: Effective Area, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• exterior_wall_1_description (type: esriFieldTypeString, alias: Exterior Wall 1 Description, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• exterior_wall_type (type: esriFieldTypeString, alias: Exterior Wall Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• extra_features_count (type: esriFieldTypeString, alias: Extra Features Count, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• effective_year_built (type: esriFieldTypeDouble, alias: Effective Year Built, SQL Type: sqlTypeOther, nullable: true, editable: true)
• family_rooms (type: esriFieldTypeString, alias: Family Rooms, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• finished_basement_area (type: esriFieldTypeDouble, alias: Finished Basement Area, SQL Type: sqlTypeOther, nullable: true, editable: true)
• finished_basement_quality (type: esriFieldTypeString, alias: Finished Basement Quality, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• frame_type (type: esriFieldTypeDouble, alias: Frame Type, SQL Type: sqlTypeOther, nullable: true, editable: true)
• frame_type_description (type: esriFieldTypeString, alias: Frame Type Description, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• func_condition (type: esriFieldTypeString, alias: Func Condition, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• func_condition_description (type: esriFieldTypeString, alias: Func Condition Description, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• gis_tag (type: esriFieldTypeString, alias: GIS Tag, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• grade (type: esriFieldTypeDouble, alias: Grade, SQL Type: sqlTypeOther, nullable: true, editable: true)
• grade_description (type: esriFieldTypeString, alias: Grade Description, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• gross_area_of_primary_building (type: esriFieldTypeString, alias: Gross Area Of Primary Building, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• heat_ac (type: esriFieldTypeString, alias: Heat AC, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• heat_ac_description (type: esriFieldTypeString, alias: Heat AC Description, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• heat_fuel_description (type: esriFieldTypeString, alias: Heat Fuel Description, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• heat_type_description (type: esriFieldTypeString, alias: Heat Type Description, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• instrument (type: esriFieldTypeString, alias: Instrument, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• interior_floor_1_description (type: esriFieldTypeString, alias: Interior Floor 1 Description, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• interior_floor_type (type: esriFieldTypeString, alias: Interior Floor Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• interior_wall_1_description (type: esriFieldTypeString, alias: Interior Wall 1 Description, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• interior_wall_type (type: esriFieldTypeString, alias: Interior Wall Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• kitchen_style_description (type: esriFieldTypeString, alias: Kitchen Style Description, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• land_acres (type: esriFieldTypeDouble, alias: Land Acres, SQL Type: sqlTypeOther, nullable: true, editable: true)
• land_use_note (type: esriFieldTypeString, alias: Land Use Note, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• living_area (type: esriFieldTypeDouble, alias: Living Area, SQL Type: sqlTypeOther, nullable: true, editable: true)
• location (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• lot (type: esriFieldTypeString, alias: Lot, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• lot_cut (type: esriFieldTypeString, alias: Lot Cut, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• lot_lot_cut (type: esriFieldTypeString, alias: Lot Lot Cut, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• mailing_address (type: esriFieldTypeString, alias: Mailing Address, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• mailing_address_2 (type: esriFieldTypeString, alias: Mailing Address 2, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• mailing_city (type: esriFieldTypeString, alias: Mailing City, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• mailing_state (type: esriFieldTypeString, alias: Mailing State, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• mailing_zip (type: esriFieldTypeString, alias: Mailing Zip, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• map (type: esriFieldTypeString, alias: Map, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• map_block_lot (type: esriFieldTypeString, alias: Map Block Lot, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• map_cut (type: esriFieldTypeString, alias: Map Cut, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• map_map_cut (type: esriFieldTypeString, alias: Map Map Cut, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• match_id (type: esriFieldTypeString, alias: Match ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• model (type: esriFieldTypeString, alias: Model, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• neighborhood (type: esriFieldTypeString, alias: Neighborhood, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• number_of_fireplaces (type: esriFieldTypeDouble, alias: Number of Fireplaces, SQL Type: sqlTypeOther, nullable: true, editable: true)
• number_of_bathrooms (type: esriFieldTypeDouble, alias: Number Of Bathrooms, SQL Type: sqlTypeOther, nullable: true, editable: true)
• number_of_bedrooms (type: esriFieldTypeDouble, alias: Number Of Bedrooms, SQL Type: sqlTypeOther, nullable: true, editable: true)
• number_of_buildings (type: esriFieldTypeDouble, alias: Number Of Buildings, SQL Type: sqlTypeOther, nullable: true, editable: true)
• number_of_half_baths (type: esriFieldTypeDouble, alias: Number Of Half Baths, SQL Type: sqlTypeOther, nullable: true, editable: true)
• number_of_units (type: esriFieldTypeDouble, alias: Number Of Units, SQL Type: sqlTypeOther, nullable: true, editable: true)
• occupancy (type: esriFieldTypeDouble, alias: Occupancy, SQL Type: sqlTypeOther, nullable: true, editable: true)
• outbuilding_count (type: esriFieldTypeDouble, alias: Outbuilding Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• owner (type: esriFieldTypeString, alias: Owner, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• parcel_depth (type: esriFieldTypeDouble, alias: Parcel Depth, SQL Type: sqlTypeOther, nullable: true, editable: true)
• parcel_frontage (type: esriFieldTypeDouble, alias: Parcel Frontage, SQL Type: sqlTypeOther, nullable: true, editable: true)
• parcel_id (type: esriFieldTypeString, alias: Parcel ID, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• parcel_match (type: esriFieldTypeString, alias: Parcel Match, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• percentage_of_common_wall (type: esriFieldTypeString, alias: Percentage Of Common Wall, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• permit_count (type: esriFieldTypeDouble, alias: Permit Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• phy_condition (type: esriFieldTypeString, alias: Phy Condition, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• phy_condition_description (type: esriFieldTypeString, alias: Phy Condition Description, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• pid (type: esriFieldTypeString, alias: PID, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• pre_yr_assessed_building (type: esriFieldTypeDouble, alias: Pre Year Assessed Building, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pre_yr_assessed_extra_feature (type: esriFieldTypeString, alias: Pre Year Assessed Extra Feature, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• pre_yr_assessed_land (type: esriFieldTypeDouble, alias: Pre Year Assessed Land, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pre_yr_assessed_outbuilding (type: esriFieldTypeDouble, alias: Pre Year Assessed Outbuilding, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pre_yr_assessed_total (type: esriFieldTypeDouble, alias: Pre Year Assessed Total, SQL Type: sqlTypeOther, nullable: true, editable: true)
• price (type: esriFieldTypeString, alias: Price, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• prior_book_page (type: esriFieldTypeString, alias: Prior Book Page, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• prior_sale_date (type: esriFieldTypeString, alias: Prior Sale Date, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• prior_sale_price (type: esriFieldTypeDouble, alias: Prior Sale Price, SQL Type: sqlTypeOther, nullable: true, editable: true)
• property_address (type: esriFieldTypeString, alias: Property Address, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• property_city (type: esriFieldTypeString, alias: Property City, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• property_zip (type: esriFieldTypeInteger, alias: Property Zip, SQL Type: sqlTypeOther, nullable: true, editable: true)
• qualified (type: esriFieldTypeString, alias: Qualified, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• replacement_cost_new (type: esriFieldTypeDouble, alias: Replacement Cost New, SQL Type: sqlTypeOther, nullable: true, editable: true)
• replacement_cost_new_less_depre (type: esriFieldTypeDouble, alias: Replacement Cost New Less Depreciation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• roof_cover_description (type: esriFieldTypeString, alias: Roof Cover Description, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• roof_structure_description (type: esriFieldTypeString, alias: Roof Structure Description, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• rooms_partitions (type: esriFieldTypeString, alias: Rooms Partitions, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• rooms_partitions_description (type: esriFieldTypeString, alias: Rooms Partitions Description, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• sale_date (type: esriFieldTypeString, alias: Sale Date, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• sale_grantee_name (type: esriFieldTypeString, alias: Sale Grantee Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• sale_grantor_name (type: esriFieldTypeString, alias: Sale Grantor Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• sale_price (type: esriFieldTypeDouble, alias: Sale Price, SQL Type: sqlTypeOther, nullable: true, editable: true)
• sketch (type: esriFieldTypeString, alias: Sketch, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• sketch_url (type: esriFieldTypeString, alias: Sketch Url, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• state_use (type: esriFieldTypeString, alias: State Use, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• state_use_description (type: esriFieldTypeString, alias: State Use Description, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• stories (type: esriFieldTypeDouble, alias: Stories, SQL Type: sqlTypeOther, nullable: true, editable: true)
• street_name (type: esriFieldTypeString, alias: Street Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• style_desc (type: esriFieldTypeString, alias: Style Desc, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• style_description (type: esriFieldTypeString, alias: Style Description, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• total_extra_fixtures (type: esriFieldTypeString, alias: Total Extra Fixtures, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• total_rooms (type: esriFieldTypeDouble, alias: Total Rooms, SQL Type: sqlTypeOther, nullable: true, editable: true)
• town_id (type: esriFieldTypeSmallInteger, alias: Town ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• type_of_septic (type: esriFieldTypeString, alias: Type Of Septic, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• type_of_well (type: esriFieldTypeString, alias: Type Of Well, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• unit (type: esriFieldTypeString, alias: Unit, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• unit_cut (type: esriFieldTypeString, alias: Unit Cut, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• unit_unit_cut (type: esriFieldTypeString, alias: Unit Unit Cut, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• validity_code (type: esriFieldTypeString, alias: Validity Code, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• valuation_year (type: esriFieldTypeDouble, alias: Valuation Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
• wall_height (type: esriFieldTypeDouble, alias: Wall Height, SQL Type: sqlTypeOther, nullable: true, editable: true)
• wall_height_description (type: esriFieldTypeString, alias: Wall Height Description, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• water_frontage_in_feet (type: esriFieldTypeString, alias: Water Frontage In Feet, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• zone (type: esriFieldTypeString, alias: Zone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• zone_description (type: esriFieldTypeString, alias: Zone Description, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: CAMA_2023
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• Owner_owns_parcel (0) -- Related To: SCCOG Parcels 2024 (12)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 10/8/2024 8:01:28 PM

Schema Last Edit Date: 10/8/2024 8:01:28 PM

Data Last Edit Date: 9/11/2024 4:15:59 AM

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