View In:   ArcGIS Online Map Viewer

Name: GISDB.DBO.structure_existing_point

Display Field: structname

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 41ffe6e97cb243f183693f07df59e760

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

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: 1.3467281553623289E7
YMin: 380151.27548761666
XMax: 1.3501085290953547E7
YMax: 413649.4932113886
Spatial Reference: PROJCS["NAD_1983_HARN_StatePlane_Michigan_South_FIPS_2113_Feet_Intl",GEOGCS["GCS_North_American_1983_HARN",DATUM["D_North_American_1983_HARN",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",13123359.58005249],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-84.36666666666666],PARAMETER["Standard_Parallel_1",42.1],PARAMETER["Standard_Parallel_2",43.66666666666666],PARAMETER["Latitude_Of_Origin",41.5],UNIT["Foot",0.3048]],VERTCS["NAVD_1988",VDATUM["North_American_Vertical_Datum_1988"],PARAMETER["Vertical_Shift",0.0],PARAMETER["Direction",1.0],UNIT["Foot",0.3048]]

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [91, 54, 135, 255]
Size: 4.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: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: true
Supports Query With LOD Spatial Reference: true

HasZ: true

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: ObjectIdentifier )
• subtypeid ( modelName: SUBTYPEID, nullable: true, editable: true, defaultValue: 200115, alias: SubTypeIdentifier, type: esriFieldTypeInteger )
• buildng_id ( modelName: buildng_id, nullable: true, editable: true, defaultValue: null, length: 20, alias: PKBuildngID, type: esriFieldTypeString )
• map_id ( modelName: map_id, nullable: true, editable: true, defaultValue: null, alias: PKMapID, type: esriFieldTypeInteger )
• meta_id ( modelName: meta_id, nullable: true, editable: true, defaultValue: null, length: 20, alias: FKMetaID, type: esriFieldTypeString )
• media_id ( modelName: media_id, nullable: true, editable: true, defaultValue: null, length: 20, alias: FKMediaID, type: esriFieldTypeString )
• coord_id ( modelName: coord_id, nullable: true, editable: true, defaultValue: null, length: 20, alias: FKCoordID, type: esriFieldTypeString )
• structname ( modelName: structname, nullable: true, editable: true, defaultValue: null, length: 30, alias: Structname, type: esriFieldTypeString )
• str_stat_d ( modelName: str_stat_d, nullable: true, editable: true, defaultValue: null, length: 16, alias: StrStatDOM, type: esriFieldTypeString )
• str_type_d ( modelName: str_type_d, nullable: true, editable: true, defaultValue: null, length: 16, alias: StrTypeDOM, type: esriFieldTypeString )
• str_use_d ( modelName: str_use_d, nullable: true, editable: true, defaultValue: null, length: 16, alias: StrUseDOM, type: esriFieldTypeString )
• str_cnd_d ( modelName: str_cnd_d, nullable: true, editable: true, defaultValue: null, length: 16, alias: StrCndDOM, type: esriFieldTypeString )
• designcode ( modelName: designcode, nullable: true, editable: true, defaultValue: null, length: 20, alias: Designcode, type: esriFieldTypeString )
• presntcode ( modelName: presntcode, nullable: true, editable: true, defaultValue: null, length: 20, alias: Presntcode, type: esriFieldTypeString )
• heattype_d ( modelName: heattype_d, nullable: true, editable: true, defaultValue: null, length: 16, alias: HeattypeDOM, type: esriFieldTypeString )
• cooltype_d ( modelName: cooltype_d, nullable: true, editable: true, defaultValue: null, length: 16, alias: CooltypeDOM, type: esriFieldTypeString )
• no_occup ( modelName: no_occup, nullable: true, editable: true, defaultValue: null, alias: NoOccup, type: esriFieldTypeSmallInteger )
• areainside ( modelName: areainside, nullable: true, editable: true, defaultValue: null, alias: Areainside, type: esriFieldTypeDouble )
• areafloor ( modelName: areafloor, nullable: true, editable: true, defaultValue: null, alias: Areafloor, type: esriFieldTypeDouble )
• areausable ( modelName: areausable, nullable: true, editable: true, defaultValue: null, alias: Areausable, type: esriFieldTypeDouble )
• areaperocc ( modelName: areaperocc, nullable: true, editable: true, defaultValue: null, alias: Areaperocc, type: esriFieldTypeDouble )
• areagndcov ( modelName: areagndcov, nullable: true, editable: true, defaultValue: null, alias: Areagndcov, type: esriFieldTypeDouble )
• areas_u_d ( modelName: areas_u_d, nullable: true, editable: true, defaultValue: null, length: 16, alias: AreasUOM, type: esriFieldTypeString )
• structhght ( modelName: structhght, nullable: true, editable: true, defaultValue: null, alias: Structhght, type: esriFieldTypeDouble )
• height_u_d ( modelName: height_u_d, nullable: true, editable: true, defaultValue: null, length: 16, alias: HeightUOM, type: esriFieldTypeString )
• floor_elev ( modelName: floor_elev, nullable: true, editable: true, defaultValue: null, alias: FloorElev, type: esriFieldTypeDouble )
• elev_u_d ( modelName: elev_u_d, nullable: true, editable: true, defaultValue: null, length: 16, alias: ElevUOM, type: esriFieldTypeString )
• portbl_wgt ( modelName: portbl_wgt, nullable: true, editable: true, defaultValue: null, alias: PortblWgt, type: esriFieldTypeDouble )
• weight_u_d ( modelName: weight_u_d, nullable: true, editable: true, defaultValue: null, length: 16, alias: WeightUOM, type: esriFieldTypeString )
• no_levels ( modelName: no_levels, nullable: true, editable: true, defaultValue: null, alias: NoLevels, type: esriFieldTypeSmallInteger )
• built_date ( modelName: built_date, nullable: true, editable: true, defaultValue: null, alias: BuiltDate, type: esriFieldTypeInteger )
• occup_date ( modelName: occup_date, nullable: true, editable: true, defaultValue: null, alias: OccupDate, type: esriFieldTypeInteger )
• movin_date ( modelName: movin_date, nullable: true, editable: true, defaultValue: null, alias: MovinDate, type: esriFieldTypeInteger )
• inspc_date ( modelName: inspc_date, nullable: true, editable: true, defaultValue: null, alias: InspcDate, type: esriFieldTypeInteger )
• demol_date ( modelName: demol_date, nullable: true, editable: true, defaultValue: null, alias: DemolDate, type: esriFieldTypeInteger )
• address_id ( modelName: address_id, nullable: true, editable: true, defaultValue: null, length: 50, alias: FKAddressID, type: esriFieldTypeString )
• dstrict_id ( modelName: dstrict_id, nullable: true, editable: true, defaultValue: null, length: 20, alias: FKDstrictID, type: esriFieldTypeString )
• landuse_id ( modelName: landuse_id, nullable: true, editable: true, defaultValue: null, length: 20, alias: FKLanduseID, type: esriFieldTypeString )
• instln_id ( modelName: instln_id, nullable: true, editable: true, defaultValue: null, length: 20, alias: FKInstlnID, type: esriFieldTypeString )
• project_id ( modelName: project_id, nullable: true, editable: true, defaultValue: null, length: 50, alias: FKProjectID, type: esriFieldTypeString )
• narrative ( modelName: narrative, nullable: true, editable: true, defaultValue: null, length: 240, alias: Narrative, type: esriFieldTypeString )
• user_flag ( modelName: user_flag, nullable: true, editable: true, defaultValue: null, length: 20, alias: UserFlag, type: esriFieldTypeString )
• str_use2_d ( modelName: str_use2_d, nullable: true, editable: true, defaultValue: null, length: 16, alias: StrUse2DOM, type: esriFieldTypeString )
• area_size ( modelName: area_size, nullable: true, editable: true, defaultValue: null, alias: AreaSize, type: esriFieldTypeDouble )
• area_u_d ( modelName: area_u_d, nullable: true, editable: true, defaultValue: null, length: 16, alias: AreaUOM, type: esriFieldTypeString )
• perim ( modelName: perim, nullable: true, editable: true, defaultValue: null, alias: Perim, type: esriFieldTypeDouble )
• perim_u_d ( modelName: perim_u_d, nullable: true, editable: true, defaultValue: null, length: 16, alias: PerimUOM, type: esriFieldTypeString )
• vehwei_id ( modelName: vehwei_id, nullable: true, editable: true, defaultValue: null, length: 20, alias: FKVehweiID, type: esriFieldTypeString )
• str_mat_d ( modelName: str_mat_d, nullable: true, editable: true, defaultValue: null, length: 16, alias: StrMatDOM, type: esriFieldTypeString )
• facil_id ( modelName: facil_id, nullable: true, editable: true, defaultValue: null, length: 20, alias: FKFacilID, type: esriFieldTypeString )
• grid_value ( modelName: grid_value, nullable: true, editable: true, defaultValue: null, alias: GridValue, type: esriFieldTypeDouble )
• rrdstat_id ( modelName: rrdstat_id, nullable: true, editable: true, defaultValue: null, length: 20, alias: FKRrdstatID, type: esriFieldTypeString )
• fut_stat_d ( modelName: fut_stat_d, nullable: true, editable: true, defaultValue: null, length: 16, alias: FutStatDOM, type: esriFieldTypeString )
• coord_x ( modelName: coord_x, nullable: true, editable: true, defaultValue: null, alias: CoordX, type: esriFieldTypeDouble )
• coord_y ( modelName: coord_y, nullable: true, editable: true, defaultValue: null, alias: CoordY, type: esriFieldTypeDouble )
• coord_z ( modelName: coord_z, nullable: true, editable: true, defaultValue: null, alias: CoordZ, type: esriFieldTypeDouble )
• owner_id ( modelName: owner_id, nullable: true, editable: true, defaultValue: null, length: 50, alias: FKOwnerID, type: esriFieldTypeString )
• sur_crs_id ( modelName: sur_crs_id, nullable: true, editable: true, defaultValue: null, length: 20, alias: FKSurCrsID, type: esriFieldTypeString )
• river_mile ( modelName: river_mile, nullable: true, editable: true, defaultValue: null, alias: RiverMile, type: esriFieldTypeDouble )
• value_cont ( modelName: value_cont, nullable: true, editable: true, defaultValue: null, alias: ValueCont, type: esriFieldTypeInteger )
• a_cost ( modelName: a_cost, nullable: true, editable: true, defaultValue: null, alias: ACost, type: esriFieldTypeDouble )
• isr_code_d ( modelName: isr_code_d, nullable: true, editable: true, defaultValue: null, length: 16, alias: IsrCodeDOM, type: esriFieldTypeString )
• buildng_no ( modelName: buildng_no, nullable: true, editable: true, defaultValue: null, length: 16, alias: BuildngNo, type: esriFieldTypeString )
• facil_no ( modelName: facil_no, nullable: true, editable: true, defaultValue: null, length: 20, alias: FacilNo, type: esriFieldTypeString )
• date_acqrd ( modelName: date_acqrd, nullable: true, editable: true, defaultValue: null, alias: DateAcqrd, type: esriFieldTypeInteger )
• prv_cost ( modelName: prv_cost, nullable: true, editable: true, defaultValue: null, alias: PrvCost, type: esriFieldTypeDouble )
• date_prv ( modelName: date_prv, nullable: true, editable: true, defaultValue: null, alias: DatePrv, type: esriFieldTypeInteger )
• sch_typ_d ( modelName: sch_typ_d, nullable: true, editable: true, defaultValue: null, length: 16, alias: SchTypDOM, type: esriFieldTypeString )
• naics_code ( modelName: NAICS_code, nullable: true, editable: true, defaultValue: null, alias: NAICSCode, type: esriFieldTypeInteger )
• naics_desc ( modelName: NAICS_desc, nullable: true, editable: true, defaultValue: null, length: 80, alias: NAICSDesc, type: esriFieldTypeString )
• num_ambul ( modelName: num_ambul, nullable: true, editable: true, defaultValue: null, alias: NumAmbul, type: esriFieldTypeInteger )
• pol_type ( modelName: pol_type, nullable: true, editable: true, defaultValue: null, length: 16, alias: PolType, type: esriFieldTypeString )
• phn_typ_d ( modelName: phn_typ_d, nullable: true, editable: true, defaultValue: null, length: 16, alias: PhnTypDOM, type: esriFieldTypeString )
• num_trucks ( modelName: num_trucks, nullable: true, editable: true, defaultValue: null, alias: NumTrucks, type: esriFieldTypeInteger )
• num_ems ( modelName: num_ems, nullable: true, editable: true, defaultValue: null, alias: NumEms, type: esriFieldTypeInteger )
• headqtr_d ( modelName: headqtr_d, nullable: true, editable: true, defaultValue: null, length: 16, alias: HeadqtrDOM, type: esriFieldTypeString )
• hazmat_d ( modelName: hazmat_d, nullable: true, editable: true, defaultValue: null, length: 16, alias: HazmatDOM, type: esriFieldTypeString )
• gov_mgt_d ( modelName: gov_mgt_d, nullable: true, editable: true, defaultValue: null, length: 16, alias: GovMgtDOM, type: esriFieldTypeString )
• ems_typ_d ( modelName: ems_typ_d, nullable: true, editable: true, defaultValue: null, length: 16, alias: EmsTypDOM, type: esriFieldTypeString )
• edu_typ_d ( modelName: edu_typ_d, nullable: true, editable: true, defaultValue: null, length: 16, alias: EduTypDOM, type: esriFieldTypeString )
• edu_lev_d ( modelName: edu_lev_d, nullable: true, editable: true, defaultValue: null, length: 16, alias: EduLevDOM, type: esriFieldTypeString )
• num_ff ( modelName: num_ff, nullable: true, editable: true, defaultValue: null, alias: NumFf, type: esriFieldTypeInteger )
• poc_id ( modelName: poc_id, nullable: true, editable: true, defaultValue: null, length: 50, alias: FKPocID, type: esriFieldTypeString )
• intagr_d ( modelName: intagr_d, nullable: true, editable: true, defaultValue: null, length: 16, alias: IntagrDOM, type: esriFieldTypeString )
• demreasn_d ( modelName: demreasn_d, nullable: true, editable: true, defaultValue: null, length: 16, alias: DemreasnDOM, type: esriFieldTypeString )
• rail_typ_d ( modelName: rail_typ_d, nullable: true, editable: true, defaultValue: null, length: 16, alias: RailTypDOM, type: esriFieldTypeString )
• demol_by_d ( modelName: demol_by_d, nullable: true, editable: true, defaultValue: null, length: 16, alias: DemolByDOM, type: esriFieldTypeString )

Templates:

• Name: GISDB.DBO.structure_existing_point
  Description:
  Prototype:
  naics_code: null
  edu_typ_d: null
  value_cont: null
  str_stat_d: null
  a_cost: null
  owner_id: null
  headqtr_d: null
  demol_by_d: null
  facil_no: null
  subtypeid: 200115
  inspc_date: null
  cooltype_d: null
  elev_u_d: null
  no_occup: null
  str_use_d: null
  rail_typ_d: null
  project_id: null
  edu_lev_d: null
  areainside: null
  media_id: null
  gov_mgt_d: null
  buildng_no: null
  str_use2_d: null
  poc_id: null
  intagr_d: null
  str_mat_d: null
  grid_value: null
  structhght: null
  naics_desc: null
  instln_id: null
  no_levels: null
  narrative: null
  address_id: null
  phn_typ_d: null
  num_ambul: null
  date_acqrd: null
  portbl_wgt: null
  river_mile: null
  prv_cost: null
  ems_typ_d: null
  areagndcov: null
  landuse_id: null
  movin_date: null
  dstrict_id: null
  areafloor: null
  num_ff: null
  sur_crs_id: null
  date_prv: null
  heattype_d: null
  presntcode: null
  occup_date: null
  areausable: null
  rrdstat_id: null
  num_ems: null
  map_id: null
  user_flag: null
  hazmat_d: null
  height_u_d: null
  perim: null
  num_trucks: null
  sch_typ_d: null
  areaperocc: null
  demol_date: null
  area_u_d: null
  floor_elev: null
  coord_id: null
  vehwei_id: null
  meta_id: null
  structname: null
  isr_code_d: null
  str_type_d: null
  coord_x: null
  coord_y: null
  designcode: null
  buildng_id: null
  areas_u_d: null
  facil_id: null
  built_date: null
  area_size: null
  coord_z: null
  weight_u_d: null
  perim_u_d: null
  fut_stat_d: null
  demreasn_d: null
  str_cnd_d: null
  pol_type: 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

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