Name: View_OKPublicRecordImprovement

Display Field: account_num

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 25b6cec4f60a4d5b941a2ba2d65d7cbf

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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

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