View In:   ArcGIS Online Map Viewer

Name: Flood Inspections Graffiti

Display Field: inspector_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

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

Supports Datum Transformation: true

Extent:

XMin: 3211655.747180715
YMin: 1915839.8825433105
XMax: 7284620.830564976
YMax: 5532820.113463387
Spatial Reference: 102646  (2230)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: activity_code
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
N/A
Default Label: null
UniqueValueInfos:
• Value: 184
  Label: 184 - Graffiti Paint/Spray - Flood (SF)
  Description:
  Symbol:
  
• Value: 188
  Label: 188 - Graffiti Contracts (SF)
  Description:
  Symbol:
  
• Value: 192
  Label: 192 - Graffiti Pressure Wash (SF)
  Description:
  Symbol:
  
• Value: 193
  Label: 193 - Graffiti Hand Roll - Flood (SF)
  Description:
  Symbol:
  
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
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: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: activity_code

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ChannelStatus ( type: esriFieldTypeString, alias: Channel Status, editable: true, nullable: true, length: 50, defaultValue: Repairs Needed, modelName: RepairStatus , Coded Values: [Repairs Needed: Repairs Needed] , [Work Ongoing: Work Ongoing] , [Repairs Completed: Repairs Completed] , ...2 more... )
• Deficiency_NO ( type: esriFieldTypeString, alias: Deficiency, editable: true, nullable: true, length: 500, defaultValue: null, modelName: Deficiency )
• RepairRecommendations_NO ( type: esriFieldTypeString, alias: Repair recommendations, editable: true, nullable: true, length: 500, defaultValue: null, modelName: RepairRecommendations )
• PermitsNeeded_NO ( type: esriFieldTypeString, alias: Permits Needed, editable: true, nullable: true, length: 10, defaultValue: null, modelName: RPermitsNeeded )
• EngineerEvalNeeded_NO ( type: esriFieldTypeString, alias: Engineer Evaluation Needed, editable: true, nullable: true, length: 10, defaultValue: null, modelName: EngineerEvalNeeded )
• Comments_NO ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 500, defaultValue: null, modelName: Comments )
• Category_NO ( type: esriFieldTypeString, alias: Category, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ActivityType )
• WorkQuantity ( type: esriFieldTypeDouble, alias: Work Quantity, editable: true, nullable: true, defaultValue: null, modelName: WorkQuantity )
• WorkUnit_NO ( type: esriFieldTypeString, alias: Work Unit, editable: true, nullable: true, length: 10, defaultValue: null, modelName: WorkUnit )
• Activity_NO ( type: esriFieldTypeString, alias: ActivityNO, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Activity )
• FEMA ( type: esriFieldTypeString, alias: FEMA, editable: true, nullable: true, length: 10, defaultValue: No, modelName: FEMA , Coded Values: [Yes: Yes] , [No: No] )
• ReachNum ( type: esriFieldTypeString, alias: Reach Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ReachNum )
• wo_no_NO ( type: esriFieldTypeString, alias: wo_no, editable: true, nullable: true, length: 10, defaultValue: null, modelName: wo_no )
• Facility ( type: esriFieldTypeString, alias: Facility, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Facility )
• DeficiencyList_NO ( type: esriFieldTypeString, alias: DeficiencyList_NO, editable: true, nullable: true, length: 100, defaultValue: null, modelName: DeficiencyList )
• CreatedBy_NO ( type: esriFieldTypeString, alias: CreatedBy, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CreatedBy )
• ModifiedBy_NO ( type: esriFieldTypeString, alias: ModifiedBy, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ModifiedBy )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: Created Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• JOC ( type: esriFieldTypeString, alias: JOC, editable: true, nullable: true, length: 10, defaultValue: No, modelName: JOC , Coded Values: [Yes: Yes] , [No: No] )
• join_id ( type: esriFieldTypeDouble, alias: join_id, editable: true, nullable: true, defaultValue: null, modelName: join_id )
• repair_recommend ( type: esriFieldTypeString, alias: Repair Recommendation, editable: true, nullable: true, length: 500, defaultValue: null, modelName: repair_recommend )
• work_unit ( type: esriFieldTypeString, alias: Work Unit, editable: true, nullable: true, length: 25, defaultValue: null, modelName: work_unit )
• unit_cost ( type: esriFieldTypeDouble, alias: Unit Cost, editable: true, nullable: true, defaultValue: null, modelName: unit_cost )
• corp_deficiency_photo_reqd ( type: esriFieldTypeString, alias: Deficiency Photo Required, editable: true, nullable: true, length: 25, defaultValue: Yes, modelName: corp_deficiency_photo_reqd , Coded Values: [Yes: Yes] , [No: No] )
• eng_eval_need ( type: esriFieldTypeString, alias: Engineering Eval Required, editable: true, nullable: true, length: 50, defaultValue: No, modelName: eng_eval_need , Coded Values: [Yes: Yes] , [No: No] )
• work_order_num ( type: esriFieldTypeString, alias: Work Order Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: work_order_num )
• supp_info ( type: esriFieldTypeString, alias: Supplemental Info, editable: true, nullable: true, length: 500, defaultValue: null, modelName: supp_info )
• instruct_notes ( type: esriFieldTypeString, alias: Instruction Notes, editable: true, nullable: true, length: 500, defaultValue: null, modelName: instruct_notes )
• activity_code ( type: esriFieldTypeString, alias: Activity, editable: true, nullable: false, length: 100, defaultValue: null, modelName: activity_code )
• inspector_name ( type: esriFieldTypeString, alias: Inspector Name, editable: true, nullable: false, length: 100, defaultValue: null, modelName: inspector_name , Coded Values: [Alec Gamez: Alec Gamez] , [Corinne Ruiz: Corinne Ruiz] , [Eddie Perez: Eddie Perez] , ...25 more... )
• deficiency_loc ( type: esriFieldTypeString, alias: Deficiency Location, editable: true, nullable: true, length: 500, defaultValue: null, modelName: deficiency_loc )
• category_code ( type: esriFieldTypeInteger, alias: Category Code, editable: true, nullable: true, defaultValue: 1, modelName: cat_code )
• PL8499 ( type: esriFieldTypeString, alias: PL8499, editable: true, nullable: true, length: 15, defaultValue: No, modelName: PL8499 , Coded Values: [Yes: Yes] , [No: No] )
• latitude ( type: esriFieldTypeDouble, alias: latitude, editable: true, nullable: true, defaultValue: null, modelName: latitude )
• longitude ( type: esriFieldTypeDouble, alias: longitude, editable: true, nullable: true, defaultValue: null, modelName: longitude )
• distance_ds ( type: esriFieldTypeDouble, alias: distance_ds, editable: true, nullable: true, defaultValue: null, modelName: distance_ds )
• eng_comments ( type: esriFieldTypeString, alias: eng_comments, editable: true, nullable: true, length: 500, defaultValue: null, modelName: eng_comments )
• taskid ( type: esriFieldTypeInteger, alias: taskid, editable: true, nullable: true, defaultValue: 0, modelName: taskid )
• mip_fiscal_yr ( type: esriFieldTypeString, alias: mip_fiscal_yr, editable: true, nullable: true, length: 50, defaultValue: null, modelName: mip_fiscal_yr )
• last_revisit_date ( type: esriFieldTypeDate, alias: last_revisit_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: last_revisit_date )
• joc_submit_date ( type: esriFieldTypeDate, alias: joc_submit_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: joc_submit_date )
• complete_date ( type: esriFieldTypeDate, alias: complete_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: complete_date )
• engineer_name ( type: esriFieldTypeString, alias: engineer_name, editable: true, nullable: true, length: 75, defaultValue: null, modelName: engineer_name )
• reach_ds_distance ( type: esriFieldTypeDouble, alias: reach_ds_distance, editable: true, nullable: true, defaultValue: null, modelName: reach_ds_distance )
• reach_desc ( type: esriFieldTypeString, alias: reach_desc, editable: true, nullable: true, length: 150, defaultValue: null, modelName: reach_desc )
• inspect_area ( type: esriFieldTypeSmallInteger, alias: inspect_area, editable: true, nullable: true, defaultValue: null, modelName: inspect_area )
• side ( type: esriFieldTypeString, alias: side, editable: true, nullable: true, length: 10, defaultValue: null, modelName: side )
• dimensions ( type: esriFieldTypeString, alias: dimensions, editable: true, nullable: true, length: 50, defaultValue: null, modelName: dimensions )
• thomas_guide ( type: esriFieldTypeString, alias: thomas_guide, editable: true, nullable: true, length: 25, defaultValue: null, modelName: thomas_guide )
• JOCPROJGUID_FK ( type: esriFieldTypeGUID, alias: JOCPROJGUID_FK, editable: true, nullable: true, length: 38, defaultValue: null, modelName: JOCPROJGUID_FK )
• CRM ( type: esriFieldTypeString, alias: CRM, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CRM , Coded Values: [Yes: Yes] , [No: No] )
• insp_date ( type: esriFieldTypeDate, alias: Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: insp_date )
• Project_Name ( type: esriFieldTypeString, alias: Project_Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Project_Name )
• Charge_Number ( type: esriFieldTypeString, alias: Charge_Number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Charge_Number )
• District ( type: esriFieldTypeString, alias: District, editable: true, nullable: true, length: 255, defaultValue: null, modelName: District )
• City ( type: esriFieldTypeString, alias: City, editable: true, nullable: true, length: 255, defaultValue: null, modelName: City )
• GraffitiID ( type: esriFieldTypeString, alias: GraffitiID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GraffitiID )

Types:

ID: 184
Name: 184
Domains:
• ChannelStatus:
  Inherited
• FEMA:
  Inherited
• JOC:
  Inherited
• corp_deficiency_photo_reqd:
  Inherited
• eng_eval_need:
  Inherited
• inspector_name:
  Inherited
• PL8499:
  Inherited
• CRM:
  Inherited
Templates:
• Name: 184 - Graffiti Paint/Spray - Flood (SF)
  Description:
  Prototype:
  GraffitiID: null
  Activity_NO: null
  Project_Name: null
  unit_cost: null
  corp_deficiency_photo_reqd: Yes
  instruct_notes: null
  activity_code: 184
  deficiency_loc: null
  ChannelStatus: Repairs Needed
  Deficiency_NO: null
  RepairRecommendations_NO: null
  PermitsNeeded_NO: null
  EngineerEvalNeeded_NO: null
  Comments_NO: null
  Category_NO: null
  WorkQuantity: null
  WorkUnit_NO: null
  FEMA: No
  ReachNum: null
  wo_no_NO: null
  Facility: null
  DeficiencyList_NO: null
  CreatedBy_NO: null
  ModifiedBy_NO: null
  City: null
  District: null
  Charge_Number: null
  JOC: No
  join_id: null
  repair_recommend: null
  work_unit: null
  eng_eval_need: No
  work_order_num: null
  supp_info: null
  inspector_name:
  category_code: 7
  PL8499: null
  latitude: null
  longitude: null
  distance_ds: null
  eng_comments: null
  taskid: null
  mip_fiscal_yr: null
  last_revisit_date: null
  joc_submit_date: null
  complete_date: null
  engineer_name: null
  reach_ds_distance: null
  reach_desc: null
  inspect_area: null
  side: null
  dimensions: null
  thomas_guide: null
  JOCPROJGUID_FK: null
  CRM: null
  insp_date: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 188
Name: 188
Domains:
• ChannelStatus:
  Inherited
• FEMA:
  Inherited
• JOC:
  Inherited
• corp_deficiency_photo_reqd:
  Inherited
• eng_eval_need:
  Inherited
• inspector_name:
  Inherited
• PL8499:
  Inherited
• CRM:
  Inherited
Templates:
• Name: 188 - Graffiti Contracts (SF)
  Description:
  Prototype:
  GraffitiID: null
  Activity_NO: null
  Project_Name: null
  unit_cost: null
  corp_deficiency_photo_reqd: Yes
  instruct_notes: null
  activity_code: 188
  deficiency_loc: null
  ChannelStatus: Repairs Needed
  Deficiency_NO: null
  RepairRecommendations_NO: null
  PermitsNeeded_NO: null
  EngineerEvalNeeded_NO: null
  Comments_NO: null
  Category_NO: null
  WorkQuantity: null
  WorkUnit_NO: null
  FEMA: No
  ReachNum: null
  wo_no_NO: null
  Facility: null
  DeficiencyList_NO: null
  CreatedBy_NO: null
  ModifiedBy_NO: null
  City: null
  District: null
  Charge_Number: null
  JOC: No
  join_id: null
  repair_recommend: null
  work_unit: null
  eng_eval_need: No
  work_order_num: null
  supp_info: null
  inspector_name:
  category_code: 7
  PL8499: null
  latitude: null
  longitude: null
  distance_ds: null
  eng_comments: null
  taskid: null
  mip_fiscal_yr: null
  last_revisit_date: null
  joc_submit_date: null
  complete_date: null
  engineer_name: null
  reach_ds_distance: null
  reach_desc: null
  inspect_area: null
  side: null
  dimensions: null
  thomas_guide: null
  JOCPROJGUID_FK: null
  CRM: null
  insp_date: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 192
Name: 192
Domains:
• ChannelStatus:
  Inherited
• FEMA:
  Inherited
• JOC:
  Inherited
• corp_deficiency_photo_reqd:
  Inherited
• eng_eval_need:
  Inherited
• inspector_name:
  Inherited
• PL8499:
  Inherited
• CRM:
  Inherited
Templates:
• Name: 192 - Graffiti Pressure Wash (SF)
  Description:
  Prototype:
  GraffitiID: null
  Activity_NO: null
  Project_Name: null
  unit_cost: null
  corp_deficiency_photo_reqd: Yes
  instruct_notes: null
  activity_code: 192
  deficiency_loc: null
  ChannelStatus: Repairs Needed
  Deficiency_NO: null
  RepairRecommendations_NO: null
  PermitsNeeded_NO: null
  EngineerEvalNeeded_NO: null
  Comments_NO: null
  Category_NO: null
  WorkQuantity: null
  WorkUnit_NO: null
  FEMA: No
  ReachNum: null
  wo_no_NO: null
  Facility: null
  DeficiencyList_NO: null
  CreatedBy_NO: null
  ModifiedBy_NO: null
  City: null
  District: null
  Charge_Number: null
  JOC: No
  join_id: null
  repair_recommend: null
  work_unit: null
  eng_eval_need: No
  work_order_num: null
  supp_info: null
  inspector_name:
  category_code: 7
  PL8499: null
  latitude: null
  longitude: null
  distance_ds: null
  eng_comments: null
  taskid: null
  mip_fiscal_yr: null
  last_revisit_date: null
  joc_submit_date: null
  complete_date: null
  engineer_name: null
  reach_ds_distance: null
  reach_desc: null
  inspect_area: null
  side: null
  dimensions: null
  thomas_guide: null
  JOCPROJGUID_FK: null
  CRM: null
  insp_date: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 193
Name: 193
Domains:
• ChannelStatus:
  Inherited
• FEMA:
  Inherited
• JOC:
  Inherited
• corp_deficiency_photo_reqd:
  Inherited
• eng_eval_need:
  Inherited
• inspector_name:
  Inherited
• PL8499:
  Inherited
• CRM:
  Inherited
Templates:
• Name: 193 - Graffiti Hand Roll - Flood (SF)
  Description:
  Prototype:
  GraffitiID: null
  Activity_NO: null
  Project_Name: null
  unit_cost: null
  corp_deficiency_photo_reqd: Yes
  instruct_notes: null
  activity_code: 193
  deficiency_loc: null
  ChannelStatus: Repairs Needed
  Deficiency_NO: null
  RepairRecommendations_NO: null
  PermitsNeeded_NO: null
  EngineerEvalNeeded_NO: null
  Comments_NO: null
  Category_NO: null
  WorkQuantity: null
  WorkUnit_NO: null
  FEMA: No
  ReachNum: null
  wo_no_NO: null
  Facility: null
  DeficiencyList_NO: null
  CreatedBy_NO: null
  ModifiedBy_NO: null
  City: null
  District: null
  Charge_Number: null
  JOC: No
  join_id: null
  repair_recommend: null
  work_unit: null
  eng_eval_need: No
  work_order_num: null
  supp_info: null
  inspector_name:
  category_code: 7
  PL8499: null
  latitude: null
  longitude: null
  distance_ds: null
  eng_comments: null
  taskid: null
  mip_fiscal_yr: null
  last_revisit_date: null
  joc_submit_date: null
  complete_date: null
  engineer_name: null
  reach_ds_distance: null
  reach_desc: null
  inspect_area: null
  side: null
  dimensions: null
  thomas_guide: null
  JOCPROJGUID_FK: null
  CRM: null
  insp_date: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata