View In:   ArcGIS Online Map Viewer

Name: Office | Maturity

Display Field: property_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 2e3c90699ae14cfcba43fed4220ee5f3

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: -1.3657786989599999E7
YMin: 5696593.6756
XMax: -1.36544516358E7
YMax: 5704862.885600001
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [99, 161, 0, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

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

• count_ ( modelName: count_, nullable: true, editable: true, defaultValue: null, alias: Count, type: esriFieldTypeInteger )
• market ( modelName: market, nullable: true, editable: true, defaultValue: null, length: 255, alias: Market, type: esriFieldTypeString )
• property_name ( modelName: property_name, nullable: true, editable: true, defaultValue: null, length: 255, alias: Property_Name, type: esriFieldTypeString )
• address ( modelName: address, nullable: true, editable: true, defaultValue: null, length: 255, alias: Address, type: esriFieldTypeString )
• city ( modelName: city, nullable: true, editable: true, defaultValue: null, length: 255, alias: City, type: esriFieldTypeString )
• state ( modelName: state, nullable: true, editable: true, defaultValue: null, length: 255, alias: State, type: esriFieldTypeString )
• sf ( modelName: sf, nullable: true, editable: true, defaultValue: null, alias: SF, type: esriFieldTypeInteger )
• yr_built ( modelName: yr_built, nullable: true, editable: true, defaultValue: null, alias: Yr_Built, type: esriFieldTypeInteger )
• latitude ( modelName: latitude, nullable: true, editable: true, defaultValue: null, alias: Latitude, type: esriFieldTypeDouble )
• longitude ( modelName: longitude, nullable: true, editable: true, defaultValue: null, alias: Longitude, type: esriFieldTypeDouble )
• county ( modelName: county, nullable: true, editable: true, defaultValue: null, length: 255, alias: County, type: esriFieldTypeString )
• loan_status ( modelName: loan_status, nullable: true, editable: true, defaultValue: null, length: 255, alias: Loan_Status, type: esriFieldTypeString )
• loan_amount____ ( modelName: loan_amount____, nullable: true, editable: true, defaultValue: null, alias: Loan_Amount____, type: esriFieldTypeDouble )
• loan_type ( modelName: loan_type, nullable: true, editable: true, defaultValue: null, length: 255, alias: Loan_Type, type: esriFieldTypeString )
• loan_orig_month ( modelName: loan_orig_month, nullable: true, editable: true, defaultValue: null, alias: Loan_Orig_Month, type: esriFieldTypeInteger )
• loan_orig_year ( modelName: loan_orig_year, nullable: true, editable: true, defaultValue: null, alias: Loan_Orig_Year, type: esriFieldTypeInteger )
• loan_mat_month ( modelName: loan_mat_month, nullable: true, editable: true, defaultValue: null, alias: Loan_Mat_Month, type: esriFieldTypeInteger )
• loan_mat_year ( modelName: loan_mat_year, nullable: true, editable: true, defaultValue: null, alias: Loan_Mat_Year, type: esriFieldTypeInteger )
• loan_maturity_date ( modelName: loan_maturity_date, nullable: true, editable: true, defaultValue: null, alias: Loan_Maturity_Date, type: esriFieldTypeDateOnly )
• owner___borrower ( modelName: owner___borrower, nullable: true, editable: true, defaultValue: null, length: 255, alias: Owner___Borrower, type: esriFieldTypeString )
• yr_renovated ( modelName: yr_renovated, nullable: true, editable: true, defaultValue: null, alias: Yr_Renovated, type: esriFieldTypeInteger )
• price____ ( modelName: price____, nullable: true, editable: true, defaultValue: null, length: 255, alias: Price____, type: esriFieldTypeString )
• f______units ( modelName: f______units, nullable: true, editable: true, defaultValue: null, alias: F______Units, type: esriFieldTypeDouble )
• f______sf ( modelName: f______sf, nullable: true, editable: true, defaultValue: null, alias: F______SF, type: esriFieldTypeDouble )
• cap_rate ( modelName: cap_rate, nullable: true, editable: true, defaultValue: null, alias: Cap_Rate, type: esriFieldTypeDouble )
• cap_rate_qualifier ( modelName: cap_rate_qualifier, nullable: true, editable: true, defaultValue: null, length: 255, alias: Cap_Rate_Qualifier, type: esriFieldTypeString )
• loan_purpose ( modelName: loan_purpose, nullable: true, editable: true, defaultValue: null, length: 255, alias: Loan_Purpose, type: esriFieldTypeString )
• term ( modelName: term, nullable: true, editable: true, defaultValue: null, alias: Term, type: esriFieldTypeInteger )
• lender ( modelName: lender, nullable: true, editable: true, defaultValue: null, length: 255, alias: Lender, type: esriFieldTypeString )
• lender_group ( modelName: lender_group, nullable: true, editable: true, defaultValue: null, length: 255, alias: Lender_Group, type: esriFieldTypeString )
• originator ( modelName: originator, nullable: true, editable: true, defaultValue: null, length: 255, alias: Originator, type: esriFieldTypeString )
• special_servicer ( modelName: special_servicer, nullable: true, editable: true, defaultValue: null, length: 255, alias: Special_Servicer, type: esriFieldTypeString )
• ltv ( modelName: ltv, nullable: true, editable: true, defaultValue: null, alias: LTV, type: esriFieldTypeDouble )
• dscr ( modelName: dscr, nullable: true, editable: true, defaultValue: null, alias: DSCR, type: esriFieldTypeDouble )
• debt_yield ( modelName: debt_yield, nullable: true, editable: true, defaultValue: null, alias: Debt_Yield, type: esriFieldTypeDouble )
• amortization_type ( modelName: amortization_type, nullable: true, editable: true, defaultValue: null, length: 255, alias: Amortization_Type, type: esriFieldTypeString )
• apn ( modelName: apn, nullable: true, editable: true, defaultValue: null, length: 255, alias: APN, type: esriFieldTypeString )
• servicer_notes ( modelName: servicer_notes, nullable: true, editable: true, defaultValue: null, length: 827, alias: Servicer_Notes, type: esriFieldTypeString )
• col_am ( modelName: col_am, nullable: true, editable: true, defaultValue: null, length: 255, alias: COL_AM, type: esriFieldTypeString )
• col_an ( modelName: col_an, nullable: true, editable: true, defaultValue: null, length: 255, alias: COL_AN, type: esriFieldTypeString )
• col_ao ( modelName: col_ao, nullable: true, editable: true, defaultValue: null, length: 255, alias: COL_AO, type: esriFieldTypeString )
• col_ap ( modelName: col_ap, nullable: true, editable: true, defaultValue: null, length: 255, alias: COL_AP, type: esriFieldTypeString )
• col_aq ( modelName: col_aq, nullable: true, editable: true, defaultValue: null, length: 255, alias: COL_AQ, type: esriFieldTypeString )
• col_ar ( modelName: col_ar, nullable: true, editable: true, defaultValue: null, length: 255, alias: COL_AR, type: esriFieldTypeString )
• col_as ( modelName: col_as, nullable: true, editable: true, defaultValue: null, length: 255, alias: COL_AS, type: esriFieldTypeString )
• col_at ( modelName: col_at, nullable: true, editable: true, defaultValue: null, length: 255, alias: COL_AT, type: esriFieldTypeString )
• col_au ( modelName: col_au, nullable: true, editable: true, defaultValue: null, length: 255, alias: COL_AU, type: esriFieldTypeString )
• col_av ( modelName: col_av, nullable: true, editable: true, defaultValue: null, length: 255, alias: COL_AV, type: esriFieldTypeString )
• col_aw ( modelName: col_aw, nullable: true, editable: true, defaultValue: null, length: 255, alias: COL_AW, type: esriFieldTypeString )
• col_ax ( modelName: col_ax, nullable: true, editable: true, defaultValue: null, length: 255, alias: COL_AX, type: esriFieldTypeString )
• col_ay ( modelName: col_ay, nullable: true, editable: true, defaultValue: null, length: 255, alias: COL_AY, type: esriFieldTypeString )
• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )

Templates:

• Name: New Feature
  Description:
  Prototype:
  loan_orig_month: null
  county: null
  lender_group: null
  loan_purpose: null
  property_name: null
  dscr: null
  state: null
  loan_mat_month: null
  f______sf: null
  cap_rate_qualifier: null
  apn: null
  longitude: null
  loan_orig_year: null
  f______units: null
  owner___borrower: null
  market: null
  amortization_type: null
  loan_mat_year: null
  city: null
  latitude: null
  originator: null
  loan_type: null
  yr_renovated: null
  debt_yield: null
  lender: null
  sf: null
  price____: null
  term: null
  loan_status: null
  address: null
  col_ax: null
  special_servicer: null
  loan_maturity_date: null
  col_ay: null
  col_av: null
  col_aw: null
  loan_amount____: null
  col_at: null
  col_au: null
  col_ar: null
  ltv: null
  col_as: null
  col_ap: null
  col_aq: null
  count_: null
  cap_rate: null
  col_an: null
  col_ao: null
  yr_built: null
  servicer_notes: null
  col_am: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

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