View In:   ArcGIS Online Map Viewer

Name: Export091620_0

Display Field: property_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 673e444da6d0465a87fd97ad8b5fc758

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 1155582

Max Scale: 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.25296271687E7
YMin: 3923434.7534999996
XMax: -1.2416190492600001E7
YMax: 3994322.4299999997
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [133, 135, 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:

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: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• valley_location ( modelName: valley_location, nullable: true, editable: true, defaultValue: null, length: 255, alias: Valley Location, type: esriFieldTypeString )
• property_address ( modelName: property_address, nullable: true, editable: true, defaultValue: null, length: 255, alias: Property Address, type: esriFieldTypeString )
• property_city ( modelName: property_city, nullable: true, editable: true, defaultValue: null, length: 255, alias: Property City, type: esriFieldTypeString )
• property_state ( modelName: property_state, nullable: true, editable: true, defaultValue: null, length: 255, alias: Property State, type: esriFieldTypeString )
• property_county ( modelName: property_county, nullable: true, editable: true, defaultValue: null, length: 255, alias: Property County, type: esriFieldTypeString )
• property_zip_code ( modelName: property_zip_code, nullable: true, editable: true, defaultValue: null, length: 255, alias: Property Zip Code, type: esriFieldTypeString )
• property_type ( modelName: property_type, nullable: true, editable: true, defaultValue: null, length: 255, alias: Property Type, type: esriFieldTypeString )
• sale_price ( modelName: sale_price, nullable: true, editable: true, defaultValue: null, alias: Sale Price, type: esriFieldTypeInteger )
• sale_price_comment ( modelName: sale_price_comment, nullable: true, editable: true, defaultValue: null, length: 255, alias: Sale Price Comment, type: esriFieldTypeString )
• size_ ( modelName: size_, nullable: true, editable: true, defaultValue: null, alias: Size, type: esriFieldTypeInteger )
• property_name ( modelName: property_name, nullable: true, editable: true, defaultValue: null, length: 255, alias: Property Name, type: esriFieldTypeString )
• sale_date ( modelName: sale_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Sale Date, type: esriFieldTypeDate )
• sale_status ( modelName: sale_status, nullable: true, editable: true, defaultValue: null, length: 255, alias: Sale Status, type: esriFieldTypeString )
• recording_date ( modelName: recording_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Recording Date, type: esriFieldTypeDate )
• hold_period ( modelName: hold_period, nullable: true, editable: true, defaultValue: null, length: 255, alias: Hold Period, type: esriFieldTypeString )
• non_arms_length_reasons ( modelName: non_arms_length_reasons, nullable: true, editable: true, defaultValue: null, length: 255, alias: Non-Arms Length Reasons, type: esriFieldTypeString )
• sale_condition ( modelName: sale_condition, nullable: true, editable: true, defaultValue: null, length: 255, alias: Sale Condition, type: esriFieldTypeString )
• actual_cap_rate ( modelName: actual_cap_rate, nullable: true, editable: true, defaultValue: null, alias: Actual Cap Rate, type: esriFieldTypeDouble )
• pro_forma_cap_rate ( modelName: pro_forma_cap_rate, nullable: true, editable: true, defaultValue: null, alias: Pro Forma Cap Rate, type: esriFieldTypeDouble )
• buyer_company ( modelName: buyer_company, nullable: true, editable: true, defaultValue: null, length: 255, alias: Buyer Company, type: esriFieldTypeString )
• buyer_true_origin ( modelName: buyer_true_origin, nullable: true, editable: true, defaultValue: null, length: 255, alias: Buyer True Origin, type: esriFieldTypeString )
• buyer_contact ( modelName: buyer_contact, nullable: true, editable: true, defaultValue: null, length: 255, alias: Buyer Contact, type: esriFieldTypeString )
• buyer_true_company ( modelName: buyer_true_company, nullable: true, editable: true, defaultValue: null, length: 255, alias: Buyer True Company, type: esriFieldTypeString )
• buyer_true_contact ( modelName: buyer_true_contact, nullable: true, editable: true, defaultValue: null, length: 255, alias: Buyer True Contact, type: esriFieldTypeString )
• buyers_broker_agent_first_name ( modelName: buyers_broker_agent_first_name, nullable: true, editable: true, defaultValue: null, length: 255, alias: Buyers Broker Agent First Name, type: esriFieldTypeString )
• buyers_broker_agent_last_name ( modelName: buyers_broker_agent_last_name, nullable: true, editable: true, defaultValue: null, length: 255, alias: Buyers Broker Agent Last Name, type: esriFieldTypeString )
• buyers_broker_company ( modelName: buyers_broker_company, nullable: true, editable: true, defaultValue: null, length: 255, alias: Buyers Broker Company, type: esriFieldTypeString )
• seller_company ( modelName: seller_company, nullable: true, editable: true, defaultValue: null, length: 255, alias: Seller Company, type: esriFieldTypeString )
• seller_true_origin ( modelName: seller_true_origin, nullable: true, editable: true, defaultValue: null, length: 255, alias: Seller True Origin, type: esriFieldTypeString )
• seller_contact ( modelName: seller_contact, nullable: true, editable: true, defaultValue: null, length: 255, alias: Seller Contact, type: esriFieldTypeString )
• seller_true_contact ( modelName: seller_true_contact, nullable: true, editable: true, defaultValue: null, length: 255, alias: Seller True Contact, type: esriFieldTypeString )
• seller_true_company ( modelName: seller_true_company, nullable: true, editable: true, defaultValue: null, length: 255, alias: Seller True Company, type: esriFieldTypeString )
• listing_broker_agent_first_name ( modelName: listing_broker_agent_first_name, nullable: true, editable: true, defaultValue: null, length: 255, alias: Listing Broker Agent First Name, type: esriFieldTypeString )
• listing_broker_agent_last_name ( modelName: listing_broker_agent_last_name, nullable: true, editable: true, defaultValue: null, length: 255, alias: Listing Broker Agent Last Name, type: esriFieldTypeString )
• listing_broker_company ( modelName: listing_broker_company, nullable: true, editable: true, defaultValue: null, length: 255, alias: Listing Broker Company, type: esriFieldTypeString )
• amenities ( modelName: amenities, nullable: true, editable: true, defaultValue: null, length: 255, alias: Amenities, type: esriFieldTypeString )
• loading_docks ( modelName: loading_docks, nullable: true, editable: true, defaultValue: null, length: 255, alias: Loading Docks, type: esriFieldTypeString )
• drive_ins ( modelName: drive_ins, nullable: true, editable: true, defaultValue: null, length: 255, alias: Drive Ins, type: esriFieldTypeString )
• power ( modelName: power, nullable: true, editable: true, defaultValue: null, length: 255, alias: Power, type: esriFieldTypeString )
• ceiling_height ( modelName: ceiling_height, nullable: true, editable: true, defaultValue: null, length: 255, alias: Ceiling Height, type: esriFieldTypeString )
• column_spacing ( modelName: column_spacing, nullable: true, editable: true, defaultValue: null, length: 255, alias: Column Spacing, type: esriFieldTypeString )
• sprinklers ( modelName: sprinklers, nullable: true, editable: true, defaultValue: null, length: 255, alias: Sprinklers, type: esriFieldTypeString )
• sprinklers_1 ( modelName: sprinklers_1, nullable: true, editable: true, defaultValue: null, length: 255, alias: Sprinklers_1, type: esriFieldTypeString )
• heating ( modelName: heating, nullable: true, editable: true, defaultValue: null, length: 255, alias: Heating, type: esriFieldTypeString )
• number_of_cranes ( modelName: number_of_cranes, nullable: true, editable: true, defaultValue: null, alias: Number Of Cranes, type: esriFieldTypeInteger )
• sewer ( modelName: sewer, nullable: true, editable: true, defaultValue: null, length: 255, alias: Sewer, type: esriFieldTypeString )
• water ( modelName: water, nullable: true, editable: true, defaultValue: null, length: 255, alias: Water, type: esriFieldTypeString )
• rail_served ( modelName: rail_served, nullable: true, editable: true, defaultValue: null, length: 255, alias: Rail Served, type: esriFieldTypeString )
• office_space ( modelName: office_space, nullable: true, editable: true, defaultValue: null, alias: Office Space, type: esriFieldTypeInteger )
• percent_office ( modelName: percent_office, nullable: true, editable: true, defaultValue: null, alias: Percent Office, type: esriFieldTypeDouble )
• construction_material ( modelName: construction_material, nullable: true, editable: true, defaultValue: null, length: 255, alias: Construction Material, type: esriFieldTypeString )
• comp_id ( modelName: comp_id, nullable: true, editable: true, defaultValue: null, alias: Comp ID, type: esriFieldTypeInteger )
• asking_price ( modelName: asking_price, nullable: true, editable: true, defaultValue: null, alias: Asking Price, type: esriFieldTypeInteger )
• market_time ( modelName: market_time, nullable: true, editable: true, defaultValue: null, alias: Market Time, type: esriFieldTypeInteger )
• down_payment ( modelName: down_payment, nullable: true, editable: true, defaultValue: null, alias: Down Payment, type: esriFieldTypeInteger )
• net_income ( modelName: net_income, nullable: true, editable: true, defaultValue: null, alias: Net Income, type: esriFieldTypeInteger )
• price_per_ac_land ( modelName: price_per_ac_land, nullable: true, editable: true, defaultValue: null, alias: Price Per AC Land, type: esriFieldTypeDouble )
• price_per_sf ( modelName: price_per_sf, nullable: true, editable: true, defaultValue: null, alias: Price Per SF, type: esriFieldTypeDouble )
• price_per_sf_net ( modelName: price_per_sf_net, nullable: true, editable: true, defaultValue: null, alias: Price Per SF Net, type: esriFieldTypeDouble )
• price_per_sf_land ( modelName: price_per_sf_land, nullable: true, editable: true, defaultValue: null, alias: Price Per SF Land, type: esriFieldTypeDouble )
• total_expense_amount ( modelName: total_expense_amount, nullable: true, editable: true, defaultValue: null, alias: Total Expense Amount, type: esriFieldTypeDouble )
• building_operating_expenses ( modelName: building_operating_expenses, nullable: true, editable: true, defaultValue: null, length: 255, alias: Building Operating Expenses, type: esriFieldTypeString )
• building_tax_expenses ( modelName: building_tax_expenses, nullable: true, editable: true, defaultValue: null, length: 255, alias: Building Tax Expenses, type: esriFieldTypeString )
• portfolio_name ( modelName: portfolio_name, nullable: true, editable: true, defaultValue: null, length: 255, alias: Portfolio Name, type: esriFieldTypeString )
• multi_sale_name ( modelName: multi_sale_name, nullable: true, editable: true, defaultValue: null, length: 255, alias: Multi Sale Name, type: esriFieldTypeString )
• building_park ( modelName: building_park, nullable: true, editable: true, defaultValue: null, length: 255, alias: Building Park, type: esriFieldTypeString )
• propertyid ( modelName: propertyid, nullable: true, editable: true, defaultValue: null, alias: PropertyID, type: esriFieldTypeInteger )
• star_rating ( modelName: star_rating, nullable: true, editable: true, defaultValue: null, length: 255, alias: Star Rating, type: esriFieldTypeString )
• market ( modelName: market, nullable: true, editable: true, defaultValue: null, length: 255, alias: Market, type: esriFieldTypeString )
• submarket_name ( modelName: submarket_name, nullable: true, editable: true, defaultValue: null, length: 255, alias: Submarket Name, type: esriFieldTypeString )
• secondary_type ( modelName: secondary_type, nullable: true, editable: true, defaultValue: null, length: 255, alias: Secondary Type, type: esriFieldTypeString )
• location_type ( modelName: location_type, nullable: true, editable: true, defaultValue: null, length: 255, alias: Location Type, type: esriFieldTypeString )
• age ( modelName: age, nullable: true, editable: true, defaultValue: null, alias: Age, type: esriFieldTypeInteger )
• building_class ( modelName: building_class, nullable: true, editable: true, defaultValue: null, length: 255, alias: Building Class, type: esriFieldTypeString )
• land_area_ac ( modelName: land_area_ac, nullable: true, editable: true, defaultValue: null, alias: Land Area AC, type: esriFieldTypeDouble )
• land_area_sf ( modelName: land_area_sf, nullable: true, editable: true, defaultValue: null, alias: Land Area SF, 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 )
• typical_floor__sf_ ( modelName: typical_floor__sf_, nullable: true, editable: true, defaultValue: null, alias: Typical Floor (SF), type: esriFieldTypeInteger )
• number_of_floors ( modelName: number_of_floors, nullable: true, editable: true, defaultValue: null, alias: Number Of Floors, type: esriFieldTypeInteger )
• number_of_parking_spaces ( modelName: number_of_parking_spaces, nullable: true, editable: true, defaultValue: null, alias: Number Of Parking Spaces, type: esriFieldTypeInteger )
• parcel_number_1_min ( modelName: parcel_number_1_min, nullable: true, editable: true, defaultValue: null, length: 255, alias: Parcel Number 1 Min, type: esriFieldTypeString )
• parcel_number_2_max ( modelName: parcel_number_2_max, nullable: true, editable: true, defaultValue: null, length: 255, alias: Parcel Number 2 Max, type: esriFieldTypeString )
• tenancy ( modelName: tenancy, nullable: true, editable: true, defaultValue: null, length: 255, alias: Tenancy, type: esriFieldTypeString )
• vacancy ( modelName: vacancy, nullable: true, editable: true, defaultValue: null, alias: Vacancy, type: esriFieldTypeDouble )
• zoning ( modelName: zoning, nullable: true, editable: true, defaultValue: null, length: 255, alias: Zoning, type: esriFieldTypeString )

Templates:

• Name: New Feature
  Description:
  Prototype:
  non_arms_length_reasons: null
  listing_broker_agent_first_name: null
  price_per_ac_land: null
  column_spacing: null
  pro_forma_cap_rate: null
  land_area_sf: null
  seller_true_origin: null
  recording_date: null
  parcel_number_2_max: null
  property_name: null
  number_of_cranes: null
  parcel_number_1_min: null
  zoning: null
  star_rating: null
  secondary_type: null
  seller_contact: null
  number_of_floors: null
  buyer_true_origin: null
  heating: null
  valley_location: null
  price_per_sf_land: null
  longitude: null
  property_city: null
  percent_office: null
  building_class: null
  buyer_true_company: null
  property_county: null
  hold_period: null
  buyers_broker_company: null
  rail_served: null
  down_payment: null
  water: null
  market: null
  property_address: null
  listing_broker_company: null
  land_area_ac: null
  property_zip_code: null
  price_per_sf_net: null
  total_expense_amount: null
  loading_docks: null
  typical_floor__sf_: null
  price_per_sf: null
  building_tax_expenses: null
  vacancy: null
  drive_ins: null
  buyer_contact: null
  amenities: null
  seller_true_contact: null
  latitude: null
  office_space: null
  property_state: null
  building_park: null
  sprinklers_1: null
  seller_true_company: null
  sale_price_comment: null
  sale_date: null
  building_operating_expenses: null
  sewer: null
  seller_company: null
  property_type: null
  power: null
  actual_cap_rate: null
  construction_material: null
  sprinklers: null
  buyers_broker_agent_last_name: null
  multi_sale_name: null
  tenancy: null
  sale_status: null
  buyer_company: null
  portfolio_name: null
  submarket_name: null
  comp_id: null
  sale_price: null
  location_type: null
  number_of_parking_spaces: null
  buyers_broker_agent_first_name: null
  market_time: null
  buyer_true_contact: null
  size_: null
  listing_broker_agent_last_name: null
  net_income: null
  asking_price: null
  propertyid: null
  sale_condition: null
  ceiling_height: null
  age: 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:   Field Groups   Contingent Values

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