Name: View_OKPublicRecordImprovement

Display Field: account_num

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 11dc0872a5134138ab64d619f7c28ada

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Feature Draw Order:

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: false
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: false
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• account_num ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: account_num, alias: ACCOUNT_NUM )
• building_num ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: building_num, alias: BUILDING_NUM )
• parcel_num ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: parcel_num, alias: PARCEL_NUM )
• property_type ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: property_type, alias: PROPERTY_TYPE )
• neighborhood_code ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: neighborhood_code, alias: NEIGHBORHOOD_CODE )
• owner_occupied ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: owner_occupied, alias: OWNER_OCCUPIED )
• occupancy_code ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: occupancy_code, alias: OCCUPANCY_CODE )
• occupancy_description ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: occupancy_description, alias: OCCUPANCY_DESCRIPTION )
• building_type ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: building_type, alias: BUILDING_TYPE )
• square_feet ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: square_feet, alias: SQUARE_FEET )
• condominium_square_feet ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: condominium_square_feet, alias: CONDOMINIUM_SQUARE_FEET )
• total_basement_square_feet ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: total_basement_square_feet, alias: TOTAL_BASEMENT_SQUARE_FEET )
• finished_basement_square_feet ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: finished_basement_square_feet, alias: FINISHED_BASEMENT_SQUARE_FEET )
• garage_square_feet ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: garage_square_feet, alias: GARAGE_SQUARE_FEET )
• carport_square_feet ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: carport_square_feet, alias: CARPORT_SQUARE_FEET )
• balcony_square_feet ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: balcony_square_feet, alias: BALCONY_SQUARE_FEET )
• porch_square_feet ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: porch_square_feet, alias: PORCH_SQUARE_FEET )
• linear_feet_of_perimeter ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: linear_feet_of_perimeter, alias: LINEAR_FEET_OF_PERIMETER )
• percent_complete ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: percent_complete, alias: PERCENT_COMPLETE )
• condition ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: condition, alias: CONDITION )
• quality ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: quality, alias: QUALITY )
• heat_vent_air_id ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: heat_vent_air_id, alias: HEAT_VENT_AIR_ID )
• heat_vent_air_description ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: heat_vent_air_description, alias: HEAT_VENT_AIR_DESCRIPTION )
• exterior ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: exterior, alias: EXTERIOR )
• interior ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: interior, alias: INTERIOR )
• unit_type ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: unit_type, alias: UNIT_TYPE )
• number_of_stories ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: number_of_stories, alias: NUMBER_OF_STORIES )
• story_height ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: story_height, alias: STORY_HEIGHT )
• square_feet_of_sprinkler_coverage ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: square_feet_of_sprinkler_coverage, alias: SQUARE_FEET_OF_SPRINKLER_COVERAGE )
• roof_type ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: roof_type, alias: ROOF_TYPE )
• roof_cover ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: roof_cover, alias: ROOF_COVER )
• floor_cover ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: floor_cover, alias: FLOOR_COVER )
• foundation_type ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: foundation_type, alias: FOUNDATION_TYPE )
• number_of_rooms ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: number_of_rooms, alias: NUMBER_OF_ROOMS )
• number_of_bedrooms ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: number_of_bedrooms, alias: NUMBER_OF_BEDROOMS )
• number_of_bathrooms ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: number_of_bathrooms, alias: NUMBER_OF_BATHROOMS )
• number_of_units ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: number_of_units, alias: NUMBER_OF_UNITS )
• type_of_construction_id ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: type_of_construction_id, alias: TYPE_OF_CONSTRUCTION_ID )
• type_of_construction_description ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: type_of_construction_description, alias: TYPE_OF_CONSTRUCTION_DESCRIPTION )
• year_built ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: year_built, alias: YEAR_BUILT )
• year_remodeled ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: year_remodeled, alias: YEAR_REMODELED )
• percent_remodeled ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: percent_remodeled, alias: PERCENT_REMODELED )
• adjusted_year_built ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: adjusted_year_built, alias: ADJUSTED_YEAR_BUILT )
• age ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: age, alias: AGE )
• mobilehome_title_number ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: mobilehome_title_number, alias: MOBILEHOME_TITLE_NUMBER )
• mobilehome_serial_number ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: mobilehome_serial_number, alias: MOBILEHOME_SERIAL_NUMBER )
• mobilehome_length ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: mobilehome_length, alias: MOBILEHOME_LENGTH )
• mobilehome_width ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: mobilehome_width, alias: MOBILEHOME_WIDTH )
• mobilehome_make ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: mobilehome_make, alias: MOBILEHOME_MAKE )
• improvement_value ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: improvement_value, alias: IMPROVEMENT_VALUE )
• new_construction_value_for_current_year ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: new_construction_value_for_current_year, alias: NEW_CONSTRUCTION_VALUE_FOR_CURRENT_YEAR )
• new_growth_value_for_current_year ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: new_growth_value_for_current_year, alias: NEW_GROWTH_VALUE_FOR_CURRENT_YEAR )
• building_permit_value ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: building_permit_value, alias: BUILDING_PERMIT_VALUE )
• status ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: status, alias: STATUS )
• account_num_no_prefix ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: account_num_no_prefix, alias: ACCOUNT_NUM_NO_PREFIX )
• status_d ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: virtual coordinate field, alias: STATUS_D )
• account_num_no_prefix_d ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: virtual coordinate field, alias: ACCOUNT_NUM_NO_PREFIX_D )
• account_num_prefix ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: account_num_prefix, alias: ACCOUNT_NUM_PREFIX )
• field57 ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: field57, alias: Field57 )

Templates:

• Name: View_OKPublicRecordImprovement
  Description:
  Prototype:
  number_of_bathrooms: null
  parcel_num: null
  foundation_type: null
  building_num: null
  roof_cover: null
  new_construction_value_for_current_year: null
  linear_feet_of_perimeter: null
  year_remodeled: null
  square_feet: null
  occupancy_description: null
  number_of_stories: null
  number_of_bedrooms: null
  mobilehome_make: null
  account_num_no_prefix: null
  mobilehome_width: null
  roof_type: null
  mobilehome_serial_number: null
  quality: null
  condition: null
  field57: null
  year_built: null
  adjusted_year_built: null
  building_type: null
  status: null
  new_growth_value_for_current_year: null
  condominium_square_feet: null
  heat_vent_air_id: null
  exterior: null
  type_of_construction_description: null
  percent_remodeled: null
  unit_type: null
  status_d: null
  interior: null
  improvement_value: null
  account_num: null
  neighborhood_code: null
  owner_occupied: null
  occupancy_code: null
  mobilehome_title_number: null
  property_type: null
  type_of_construction_id: null
  number_of_units: null
  finished_basement_square_feet: null
  account_num_no_prefix_d: null
  story_height: null
  total_basement_square_feet: null
  percent_complete: null
  square_feet_of_sprinkler_coverage: null
  balcony_square_feet: null
  garage_square_feet: null
  porch_square_feet: null
  floor_cover: null
  account_num_prefix: null
  mobilehome_length: null
  carport_square_feet: null
  age: null
  building_permit_value: null
  heat_vent_air_description: null
  number_of_rooms: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Extract

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata