View In:   ArcGIS Online Map Viewer

Name: Excel Permits Completed 2017

Display Field: placename

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: ExcelPermitsCompleted2017_Ge

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: -1.27321685942E7
YMin: 6169640.206600003
XMax: -1.27253030779E7
YMax: 6183053.549000002
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [76, 230, 0, 255]
Size: 6.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
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: false
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• objectid ( type: esriFieldTypeOID, alias: ObjectID, nullable: false, editable: false )
• status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 1 )
• score ( type: esriFieldTypeDouble, alias: Score, editable: true, nullable: true )
• match_type ( type: esriFieldTypeString, alias: Match_type, editable: true, nullable: true, length: 2 )
• match_addr ( type: esriFieldTypeString, alias: Match_addr, editable: true, nullable: true, length: 500 )
• longlabel ( type: esriFieldTypeString, alias: LongLabel, editable: true, nullable: true, length: 500 )
• shortlabel ( type: esriFieldTypeString, alias: ShortLabel, editable: true, nullable: true, length: 500 )
• addr_type ( type: esriFieldTypeString, alias: Addr_type, editable: true, nullable: true, length: 20 )
• type ( type: esriFieldTypeString, alias: Type, editable: true, nullable: true, length: 50 )
• placename ( type: esriFieldTypeString, alias: PlaceName, editable: true, nullable: true, length: 200 )
• place_addr ( type: esriFieldTypeString, alias: Place_addr, editable: true, nullable: true, length: 500 )
• phone ( type: esriFieldTypeString, alias: Phone, editable: true, nullable: true, length: 25 )
• url ( type: esriFieldTypeString, alias: URL, editable: true, nullable: true, length: 250 )
• rank ( type: esriFieldTypeDouble, alias: Rank, editable: true, nullable: true )
• addbldg ( type: esriFieldTypeString, alias: BuildingName, editable: true, nullable: true, length: 125 )
• addnum ( type: esriFieldTypeString, alias: AddressNumber, editable: true, nullable: true, length: 50 )
• addnumfrom ( type: esriFieldTypeString, alias: AddNumFrom, editable: true, nullable: true, length: 50 )
• addnumto ( type: esriFieldTypeString, alias: AddNumTo, editable: true, nullable: true, length: 50 )
• addrange ( type: esriFieldTypeString, alias: AddressRange, editable: true, nullable: true, length: 100 )
• side ( type: esriFieldTypeString, alias: Side, editable: true, nullable: true, length: 1 )
• stpredir ( type: esriFieldTypeString, alias: StPreDir, editable: true, nullable: true, length: 5 )
• stpretype ( type: esriFieldTypeString, alias: StPreType, editable: true, nullable: true, length: 50 )
• stname ( type: esriFieldTypeString, alias: StName, editable: true, nullable: true, length: 125 )
• sttype ( type: esriFieldTypeString, alias: StType, editable: true, nullable: true, length: 30 )
• stdir ( type: esriFieldTypeString, alias: StDir, editable: true, nullable: true, length: 20 )
• bldgtype ( type: esriFieldTypeString, alias: BldgType, editable: true, nullable: true, length: 20 )
• bldgname ( type: esriFieldTypeString, alias: BldgName, editable: true, nullable: true, length: 50 )
• leveltype ( type: esriFieldTypeString, alias: LevelType, editable: true, nullable: true, length: 20 )
• levelname ( type: esriFieldTypeString, alias: LevelName, editable: true, nullable: true, length: 50 )
• unittype ( type: esriFieldTypeString, alias: UnitType, editable: true, nullable: true, length: 20 )
• unitname ( type: esriFieldTypeString, alias: UnitName, editable: true, nullable: true, length: 50 )
• subaddr ( type: esriFieldTypeString, alias: SubAddress, editable: true, nullable: true, length: 250 )
• staddr ( type: esriFieldTypeString, alias: StAddr, editable: true, nullable: true, length: 300 )
• block ( type: esriFieldTypeString, alias: Block, editable: true, nullable: true, length: 120 )
• sector ( type: esriFieldTypeString, alias: Sector, editable: true, nullable: true, length: 120 )
• nbrhd ( type: esriFieldTypeString, alias: Neighborhood, editable: true, nullable: true, length: 120 )
• district ( type: esriFieldTypeString, alias: District, editable: true, nullable: true, length: 120 )
• city ( type: esriFieldTypeString, alias: City, editable: true, nullable: true, length: 120 )
• metroarea ( type: esriFieldTypeString, alias: MetroArea, editable: true, nullable: true, length: 120 )
• subregion ( type: esriFieldTypeString, alias: Subregion, editable: true, nullable: true, length: 120 )
• region ( type: esriFieldTypeString, alias: Region, editable: true, nullable: true, length: 120 )
• regionabbr ( type: esriFieldTypeString, alias: RegionAbbr, editable: true, nullable: true, length: 50 )
• territory ( type: esriFieldTypeString, alias: Territory, editable: true, nullable: true, length: 120 )
• zone ( type: esriFieldTypeString, alias: Zone, editable: true, nullable: true, length: 100 )
• postal ( type: esriFieldTypeString, alias: Postal, editable: true, nullable: true, length: 20 )
• postalext ( type: esriFieldTypeString, alias: PostalExt, editable: true, nullable: true, length: 10 )
• country ( type: esriFieldTypeString, alias: Country, editable: true, nullable: true, length: 30 )
• langcode ( type: esriFieldTypeString, alias: LangCode, editable: true, nullable: true, length: 5 )
• distance ( type: esriFieldTypeDouble, alias: Distance, editable: true, nullable: true )
• x ( type: esriFieldTypeDouble, alias: X, editable: true, nullable: true )
• y ( type: esriFieldTypeDouble, alias: Y, editable: true, nullable: true )
• displayx ( type: esriFieldTypeDouble, alias: DisplayX, editable: true, nullable: true )
• displayy ( type: esriFieldTypeDouble, alias: DisplayY, editable: true, nullable: true )
• xmin_ ( type: esriFieldTypeDouble, alias: Xmin, editable: true, nullable: true )
• xmax_ ( type: esriFieldTypeDouble, alias: Xmax, editable: true, nullable: true )
• ymin ( type: esriFieldTypeDouble, alias: Ymin, editable: true, nullable: true )
• ymax ( type: esriFieldTypeDouble, alias: Ymax, editable: true, nullable: true )
• exinfo ( type: esriFieldTypeString, alias: ExtraInfo, editable: true, nullable: true, length: 500 )
• in_address ( type: esriFieldTypeString, alias: Address or Place, editable: true, nullable: true, length: 100, defaultValue: )
• in_address2 ( type: esriFieldTypeString, alias: Address2, editable: true, nullable: true, length: 100, defaultValue: )
• in_address3 ( type: esriFieldTypeString, alias: Address3, editable: true, nullable: true, length: 100, defaultValue: )
• in_neighborhood ( type: esriFieldTypeString, alias: Neighborhood, editable: true, nullable: true, length: 50, defaultValue: )
• in_city ( type: esriFieldTypeString, alias: City, editable: true, nullable: true, length: 50, defaultValue: )
• in_subregion ( type: esriFieldTypeString, alias: County, editable: true, nullable: true, length: 50, defaultValue: )
• in_region ( type: esriFieldTypeString, alias: State, editable: true, nullable: true, length: 50, defaultValue: )
• in_postal ( type: esriFieldTypeString, alias: ZIP, editable: true, nullable: true, length: 20, defaultValue: )
• in_postalext ( type: esriFieldTypeString, alias: ZIP4, editable: true, nullable: true, length: 20, defaultValue: )
• in_countrycode ( type: esriFieldTypeString, alias: Country, editable: true, nullable: true, length: 100, defaultValue: )
• user_date_paid ( type: esriFieldTypeString, alias: Date Paid, editable: true, nullable: true, length: 255, defaultValue: )
• user_date_closed ( type: esriFieldTypeDate, alias: Date Closed, editable: true, nullable: true, length: 29 )
• user_building_permit_no_ ( type: esriFieldTypeString, alias: Building Permit No., editable: true, nullable: true, length: 255, defaultValue: )
• user_last_name___business ( type: esriFieldTypeString, alias: Last Name / Business, editable: true, nullable: true, length: 255, defaultValue: )
• user_first__name ( type: esriFieldTypeString, alias: First Name , editable: true, nullable: true, length: 255, defaultValue: )
• user_house__ ( type: esriFieldTypeString, alias: House #, editable: true, nullable: true, length: 255, defaultValue: )
• user_street_name ( type: esriFieldTypeString, alias: Street Name, editable: true, nullable: true, length: 255, defaultValue: )
• user_unit_or_lot__ ( type: esriFieldTypeString, alias: Unit or Lot #, editable: true, nullable: true, length: 255, defaultValue: )
• user_contractor ( type: esriFieldTypeString, alias: Contractor, editable: true, nullable: true, length: 255, defaultValue: )
• user_project_type ( type: esriFieldTypeString, alias: Project Type, editable: true, nullable: true, length: 255, defaultValue: )
• user_project_valuation ( type: esriFieldTypeString, alias: Project Valuation, editable: true, nullable: true, length: 255, defaultValue: )
• user_addy_concat ( type: esriFieldTypeString, alias: addy_concat, editable: true, nullable: true, length: 255, defaultValue: )
• field ( type: esriFieldTypeInteger, alias: Field, editable: true, nullable: true )
• tif ( type: esriFieldTypeString, alias: Inside TIF, editable: true, nullable: true, length: 10 )

Templates:

• Name: Excel Permits Completed 2017
  Description:
  Prototype:
  field: null
  tif: null
  status: null
  score: null
  match_type: null
  match_addr: null
  longlabel: null
  shortlabel: null
  addr_type: null
  type: null
  placename: null
  place_addr: null
  phone: null
  url: null
  rank: null
  addbldg: null
  addnum: null
  addnumfrom: null
  addnumto: null
  addrange: null
  side: null
  stpredir: null
  stpretype: null
  stname: null
  sttype: null
  stdir: null
  bldgtype: null
  bldgname: null
  leveltype: null
  levelname: null
  unittype: null
  unitname: null
  subaddr: null
  staddr: null
  block: null
  sector: null
  nbrhd: null
  district: null
  city: null
  metroarea: null
  subregion: null
  region: null
  regionabbr: null
  territory: null
  zone: null
  postal: null
  postalext: null
  country: null
  langcode: null
  distance: null
  x: null
  y: null
  displayx: null
  displayy: null
  xmin_: null
  xmax_: null
  ymin: null
  ymax: null
  exinfo: null
  in_address:
  in_address2:
  in_address3:
  in_neighborhood:
  in_city:
  in_subregion:
  in_region:
  in_postal:
  in_postalext:
  in_countrycode:
  user_date_paid:
  user_date_closed: null
  user_building_permit_no_:
  user_last_name___business:
  user_first__name:
  user_house__:
  user_street_name:
  user_unit_or_lot__:
  user_contractor:
  user_project_type:
  user_project_valuation:
  user_addy_concat:
  
  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

Supported Operations:   Query   Query Attachments   Calculate   Validate SQL   Generate Renderer   Return Updates   Metadata