Name: DEVNET Sales

Display Field: last_chg_login

Type: Table

Geometry Type: N/A

Description: N/A

Copyright Text: N/A

Default Visibility: false

Max Result Window: N/A

Max Record Count: 2000

Standard Max Record Count No Geometry: N/A

Max Record Count Factor: 1

Standard MaxRecord Count: 32000

Tile Max Record Count: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: 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 Result Pagination Token: false
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
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: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Cache Hint: false
Supports Query With Current User: true
Supports Query With Result Type: true

HasZ: false

HasM: false

Has Attachments: false

Has Last Edit Time: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: N/A

Fields:

• OBJECTID ( nullable: false, alias: OBJECTID, type: esriFieldTypeOID )
• last_chg_login ( nullable: true, length: 28, alias: last_chg_login, type: esriFieldTypeString )
• last_chg_datetime ( nullable: true, length: 8, alias: last_chg_datetime, type: esriFieldTypeDate )
• document_number ( nullable: true, length: 15, alias: document_number, type: esriFieldTypeString )
• sale_year ( nullable: true, alias: sale_year, type: esriFieldTypeInteger )
• sale_type ( nullable: true, length: 10, alias: sale_type, type: esriFieldTypeString )
• sale_type_desc ( nullable: true, length: 255, alias: sale_type_desc, type: esriFieldTypeString )
• valid_sale_flag ( nullable: true, length: 1, alias: valid_sale_flag, type: esriFieldTypeString )
• date_of_sale ( nullable: true, length: 8, alias: date_of_sale, type: esriFieldTypeDate )
• department_study ( nullable: true, length: 1, alias: department_study, type: esriFieldTypeString )
• gross_selling_price ( nullable: true, alias: gross_selling_price, type: esriFieldTypeDouble )
• personal_property ( nullable: true, alias: personal_property, type: esriFieldTypeDouble )
• adjustment ( nullable: true, alias: adjustment, type: esriFieldTypeDouble )
• net_selling_price ( nullable: true, alias: net_selling_price, type: esriFieldTypeDouble )
• py_total_value ( nullable: true, alias: py_total_value, type: esriFieldTypeDouble )
• current_total_value ( nullable: true, alias: current_total_value, type: esriFieldTypeDouble )
• py_sales_ratio ( nullable: true, alias: py_sales_ratio, type: esriFieldTypeDouble )
• notes ( nullable: true, length: 255, alias: notes, type: esriFieldTypeString )
• current_sales_ratio ( nullable: true, alias: current_sales_ratio, type: esriFieldTypeDouble )
• partial_bldg_ind ( nullable: true, length: 1, alias: partial_bldg_ind, type: esriFieldTypeString )
• new_const_yn ( nullable: true, length: 1, alias: new_const_yn, type: esriFieldTypeString )
• const_cost_yn ( nullable: true, length: 1, alias: const_cost_yn, type: esriFieldTypeString )
• vacant_land_yn ( nullable: true, length: 1, alias: vacant_land_yn, type: esriFieldTypeString )
• trend_created_date ( nullable: true, length: 8, alias: trend_created_date, type: esriFieldTypeDate )
• trended_selling_price ( nullable: true, alias: trended_selling_price, type: esriFieldTypeDouble )
• trending_factor ( nullable: true, alias: trending_factor, type: esriFieldTypeDouble )
• township_access ( nullable: true, length: 10, alias: township_access, type: esriFieldTypeString )
• trended_by ( nullable: true, length: 28, alias: trended_by, type: esriFieldTypeString )
• date_entered ( nullable: true, length: 8, alias: date_entered, type: esriFieldTypeDate )
• current_land_value ( nullable: true, alias: current_land_value, type: esriFieldTypeDouble )
• current_bldg_value ( nullable: true, alias: current_bldg_value, type: esriFieldTypeDouble )
• tab_number ( nullable: true, alias: tab_number, type: esriFieldTypeInteger )
• sale_validity ( nullable: true, length: 10, alias: sale_validity, type: esriFieldTypeString )
• sale_source ( nullable: true, length: 10, alias: sale_source, type: esriFieldTypeString )
• conveyance_exempt_flag ( nullable: true, length: 1, alias: conveyance_exempt_flag, type: esriFieldTypeString )
• instrument_number ( nullable: true, length: 15, alias: instrument_number, type: esriFieldTypeString )
• filing_date ( nullable: true, length: 8, alias: filing_date, type: esriFieldTypeDate )
• document_type ( nullable: true, length: 10, alias: document_type, type: esriFieldTypeString )
• arms_length_reject_code ( nullable: true, length: 10, alias: arms_length_reject_code, type: esriFieldTypeString )
• ratio_reject_code ( nullable: true, length: 10, alias: ratio_reject_code, type: esriFieldTypeString )
• water_frontage_code ( nullable: true, length: 10, alias: water_frontage_code, type: esriFieldTypeString )
• sale_primary_class ( nullable: true, length: 10, alias: sale_primary_class, type: esriFieldTypeString )
• book ( nullable: true, length: 10, alias: book, type: esriFieldTypeString )
• page ( nullable: true, length: 10, alias: page, type: esriFieldTypeString )
• sequence_no ( nullable: true, alias: sequence_no, type: esriFieldTypeInteger )
• appraiser ( nullable: true, length: 10, alias: appraiser, type: esriFieldTypeString )
• fee_amount ( nullable: true, alias: fee_amount, type: esriFieldTypeDouble )
• sale_land_use ( nullable: true, length: 10, alias: sale_land_use, type: esriFieldTypeString )
• parcel_Number ( nullable: true, length: 20, alias: parcel_Number, type: esriFieldTypeString )
• property_id ( nullable: true, alias: property_id, type: esriFieldTypeInteger )
• reason ( nullable: true, length: 10, alias: reason, type: esriFieldTypeString )
• stamps ( nullable: true, alias: stamps, type: esriFieldTypeDouble )
• property_key ( nullable: true, length: 20, alias: property_key, type: esriFieldTypeString )
• source ( nullable: true, length: 10, alias: source, type: esriFieldTypeString )
• status ( nullable: true, length: 10, alias: status, type: esriFieldTypeString )
• created_date ( nullable: true, length: 8, alias: created_date, type: esriFieldTypeDate )
• deleted_date ( nullable: true, length: 8, alias: deleted_date, type: esriFieldTypeDate )
• grantor ( nullable: true, length: 100, alias: grantor, type: esriFieldTypeString )
• grantee ( nullable: true, length: 100, alias: grantee, type: esriFieldTypeString )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata