View In:   ArcGIS Online Map Viewer

Name: Office_to_Residential_Address_Points

Display Field: street_address

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 5e3995a1ae6844bbae2a744c6130e4d7

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: 760307.0895516425
YMin: 2932777.4903455526
XMax: 780800.6446930617
YMax: 2960828.118955478
Spatial Reference: 102686  (2249)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [170, 116, 80, 255]
Size: 6.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[255, 255, 255, 255] Width: 0
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: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
• project_num ( nullable: true, editable: false, defaultValue: null, description: {"fieldValueType":"uniqueIdentifier","value":"Just a unqiue digit ID number for each project (not each building), assigned as projects come in."}, type: esriFieldTypeDouble, modelName: project_num, alias: Project Number )
• street_address ( nullable: true, editable: true, defaultValue: null, length: 255, description: {"fieldValueType":"locationOrPlaceName","value":"Was formally a street address column, but since some sites include multiple buildings, this now serves more as a \"project name\" column. "}, type: esriFieldTypeString, modelName: street_address, alias: Street_Address )
• salesforce_id ( nullable: true, editable: true, defaultValue: null, description: {"fieldValueType":"","value":"The Salesforce Record ID associated with this project. "}, type: esriFieldTypeDouble, modelName: salesforce_id, alias: Salesforce_ID )
• buildings_converted ( nullable: true, editable: true, defaultValue: null, description: {"fieldValueType":"countOrAmount","value":"Number of buildings being converted as part of the project. This is number comes from the applications themselves, and are reported by John Weil."}, type: esriFieldTypeDouble, modelName: buildings_converted, alias: Buildings_Converted )
• total_units ( nullable: true, editable: true, defaultValue: null, description: {"fieldValueType":"countOrAmount","value":"Number of residential units being generated from the project. This is number comes from the applications themselves, and are reported by John Weil."}, type: esriFieldTypeDouble, modelName: total_units, alias: Total_Units )
• iz_units ( nullable: true, editable: true, defaultValue: null, description: {"fieldValueType":"countOrAmount","value":"Number of inclusionary (meeting affordable housing requirements) residential units being generated from the project. This is number comes from the applications themselves, and are reported by John Weil."}, type: esriFieldTypeDouble, modelName: iz_units, alias: IZ_Units )
• sq_feet ( nullable: true, editable: true, defaultValue: null, description: {"fieldValueType":"measurement","value":"The amount of square footage in a project being converted into residential units. This is number comes from the applications themselves, and are reported by John Weil."}, type: esriFieldTypeDouble, modelName: sq_feet, alias: Sq_Feet )
• art80_approved ( nullable: true, editable: true, defaultValue: null, length: 255, description: {"fieldValueType":"binary","value":"Whether or not the project has recieved Article 80 (Large Development Projects) Approval. "}, type: esriFieldTypeString, modelName: art80_approved, alias: Art80_Approved )
• status ( nullable: true, editable: true, defaultValue: null, length: 255, description: {"fieldValueType":"typeOrCategory","value":"What stage the project is in the development pipeline. These are a domain list of values in the source table, in the following order: Applied ➔ Article 80 Filed➔ Article 80 Approved ➔ Under Construction ➔ Completed. "}, type: esriFieldTypeString, modelName: status, alias: Status )
• display_on_web ( modelName: display_on_web, nullable: true, editable: true, defaultValue: null, length: 255, alias: Display_On_Web, type: esriFieldTypeString )
• otr_sam_ids ( nullable: true, editable: true, defaultValue: null, length: 255, description: {"fieldValueType":"uniqueIdentifier","value":"The Live Street Address Management (SAM) Addresses IDs of each address associated with the project. Used to retrieve accurate address data & pin point buildings. Some project points have mutliple SAM ID's listed, seperated by commas, thats okay. "}, type: esriFieldTypeString, modelName: otr_sam_ids, alias: OTR_SAM_IDS )
• web_url ( nullable: true, editable: true, defaultValue: null, length: 256, description: {"fieldValueType":"","value":"Link to the relevant Article 80 Project Page. "}, type: esriFieldTypeString, alias: Web URL )

Templates:

• Name: Office_to_Residential_Address_Points
  Description:
  Prototype:
  street_address: null
  buildings_converted: null
  art80_approved: null
  web_url: null
  iz_units: null
  sq_feet: null
  display_on_web: null
  total_units: null
  otr_sam_ids: null
  project_num: null
  salesforce_id: null
  status: 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