Name: GIS_WEB.dbo.PropertyCard_Details

Display Field: street_name

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• card_detail_id ( type: esriFieldTypeOID, alias: card_detail_id )
• real_estate_master_id ( type: esriFieldTypeInteger, alias: real_estate_master_id )
• record ( type: esriFieldTypeInteger, alias: record )
• card ( type: esriFieldTypeInteger, alias: card )
• record_and_card ( type: esriFieldTypeString, alias: record_and_card, length: 20 )
• age ( type: esriFieldTypeSmallInteger, alias: age )
• roof_type_code ( type: esriFieldTypeSmallInteger, alias: roof_type_code )
• roof_type_desc ( type: esriFieldTypeString, alias: roof_type_desc, length: 50 )
• roof_material_code ( type: esriFieldTypeSmallInteger, alias: roof_material_code )
• roof_material_desc ( type: esriFieldTypeString, alias: roof_material_desc, length: 50 )
• garage_type_code ( type: esriFieldTypeSmallInteger, alias: garage_type_code )
• garage_type_desc ( type: esriFieldTypeString, alias: garage_type_desc, length: 50 )
• garage_no_cars ( type: esriFieldTypeSmallInteger, alias: garage_no_cars )
• carport_code ( type: esriFieldTypeSmallInteger, alias: carport_code )
• carport_desc ( type: esriFieldTypeString, alias: carport_desc, length: 50 )
• carport_no_cars ( type: esriFieldTypeSmallInteger, alias: carport_no_cars )
• story_height ( type: esriFieldTypeSingle, alias: story_height )
• no_rooms ( type: esriFieldTypeSmallInteger, alias: no_rooms )
• no_bedrooms ( type: esriFieldTypeSmallInteger, alias: no_bedrooms )
• no_full_bathrooms ( type: esriFieldTypeSmallInteger, alias: no_full_bathrooms )
• no_half_bathrooms ( type: esriFieldTypeSmallInteger, alias: no_half_bathrooms )
• year_built ( type: esriFieldTypeSmallInteger, alias: year_built )
• heat_code ( type: esriFieldTypeSmallInteger, alias: heat_code )
• heat_desc ( type: esriFieldTypeString, alias: heat_desc, length: 50 )
• foundation_code ( type: esriFieldTypeSmallInteger, alias: foundation_code )
• foundation_description ( type: esriFieldTypeString, alias: foundation_description, length: 50 )
• occupancy_code ( type: esriFieldTypeSmallInteger, alias: occupancy_code )
• occupancy_desc ( type: esriFieldTypeString, alias: occupancy_desc, length: 50 )
• has_air_conditioning ( type: esriFieldTypeSmallInteger, alias: has_air_conditioning )
• has_air_conditioning_desc ( type: esriFieldTypeString, alias: has_air_conditioning_desc, length: 10 )
• no_fireplaces ( type: esriFieldTypeSmallInteger, alias: no_fireplaces )
• no_flues ( type: esriFieldTypeSmallInteger, alias: no_flues )
• total_living_area ( type: esriFieldTypeDouble, alias: total_living_area )
• base_living_area ( type: esriFieldTypeDouble, alias: base_living_area )
• basement_area ( type: esriFieldTypeDouble, alias: basement_area )
• finished_basement_area ( type: esriFieldTypeDouble, alias: finished_basement_area )
• site_characteristic_code ( type: esriFieldTypeSmallInteger, alias: site_characteristic_code )
• site_characteristic_desc ( type: esriFieldTypeString, alias: site_characteristic_desc, length: 50 )
• site_terrain_code ( type: esriFieldTypeSmallInteger, alias: site_terrain_code )
• site_terrain_desc ( type: esriFieldTypeString, alias: site_terrain_desc, length: 50 )
• right_of_way_code ( type: esriFieldTypeSmallInteger, alias: right_of_way_code )
• right_of_way_desc ( type: esriFieldTypeString, alias: right_of_way_desc, length: 50 )
• water_code ( type: esriFieldTypeSmallInteger, alias: water_code )
• water_desc ( type: esriFieldTypeString, alias: water_desc, length: 50 )
• sewer_code ( type: esriFieldTypeSmallInteger, alias: sewer_code )
• sewer_desc ( type: esriFieldTypeString, alias: sewer_desc, length: 50 )
• has_electricity ( type: esriFieldTypeSmallInteger, alias: has_electricity )
• has_electricity_desc ( type: esriFieldTypeString, alias: has_electricity_desc, length: 10 )
• easement_code ( type: esriFieldTypeSmallInteger, alias: easement_code )
• easement_desc ( type: esriFieldTypeString, alias: easement_desc, length: 50 )
• condition_code ( type: esriFieldTypeString, alias: condition_code, length: 2 )
• condition_desc ( type: esriFieldTypeString, alias: condition_desc, length: 50 )
• has_gas ( type: esriFieldTypeSmallInteger, alias: has_gas )
• has_gas_desc ( type: esriFieldTypeString, alias: has_gas_desc, length: 10 )
• house_no ( type: esriFieldTypeInteger, alias: house_no )
• house_no_2 ( type: esriFieldTypeString, alias: house_no_2, length: 5 )
• street_prefix ( type: esriFieldTypeString, alias: street_prefix, length: 2 )
• street_suffix ( type: esriFieldTypeString, alias: street_suffix, length: 10 )
• street_name ( type: esriFieldTypeString, alias: street_name, length: 50 )
• property_city ( type: esriFieldTypeString, alias: property_city, length: 50 )
• property_state ( type: esriFieldTypeString, alias: property_state, length: 50 )
• property_zip ( type: esriFieldTypeInteger, alias: property_zip )
• property_address ( type: esriFieldTypeString, alias: property_address, length: 100 )
• property_city_state_zip ( type: esriFieldTypeString, alias: property_city_state_zip, length: 100 )
• Floor_desc ( type: esriFieldTypeString, alias: Floor_desc, length: 200 )
• interior_wall_desc ( type: esriFieldTypeString, alias: interior_wall_desc, length: 200 )
• exterior_wall_desc ( type: esriFieldTypeString, alias: exterior_wall_desc, length: 200 )

Supported Operations:   Query   Query Attachments   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata