View In:   ArcGIS Online Map Viewer

Name: Twinwood Field Inspection

Display Field: reportid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 750f6819fbc54dd597003f55adc0062b

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

Supports Datum Transformation: true

Extent:

XMin: -1.06854596188E7
YMin: 3460785.281199999
XMax: -1.06373187183E7
YMax: 3478223.2344999984
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: Field Inspection
Description: N/A
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
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: true

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• reportid ( type: esriFieldTypeString, alias: Report ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: reportid )
• 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 )
• equipment ( type: esriFieldTypeString, alias: Equipment, editable: true, nullable: true, length: 255, defaultValue: null, modelName: equipment )
• inspector ( type: esriFieldTypeString, alias: Inspector, editable: true, nullable: true, length: 255, defaultValue: null, modelName: inspector , Coded Values: [Daniel VanCleef: Daniel VanCleef] , [Jeremy Rush: Jeremy Rush] )
• contractor ( type: esriFieldTypeString, alias: Contractor, editable: true, nullable: true, length: 255, defaultValue: null, modelName: contractor , Coded Values: [Northtex Construction, LLC: Northtex Construction, LLC] , [R Construction: R Construction] , [Hurtado Construction Company: Hurtado Construction Company] , ...1 more... )
• site_condition ( type: esriFieldTypeString, alias: Site Condition, editable: true, nullable: true, length: 255, defaultValue: null, modelName: site_condition , Coded Values: [dry: Dry] , [wet: Wet] )
• weather ( type: esriFieldTypeString, alias: Weather, editable: true, nullable: true, length: 255, defaultValue: null, modelName: weather , Coded Values: [SL60: Sunny <60] , [SG60: Sunny 60>] , [CL60: Cloudy <60] , ...1 more... )
• daily_notes ( type: esriFieldTypeString, alias: Daily Inspection Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: daily_notes )
• project ( type: esriFieldTypeString, alias: Project, editable: true, nullable: true, length: 255, defaultValue: TBD, modelName: project , Coded Values: [TBD: TBD] , [7777-1301: Orchid Estates Detention & Amenity Lake] , [7777-1072: 1072 Waller County FM 359 Improvements] , ...5 more... )
• client ( type: esriFieldTypeString, alias: Client, editable: true, nullable: true, length: 255, defaultValue: null, modelName: client , Coded Values: [TBD: TBD] , [TW: Twinwood] )
• project_num ( type: esriFieldTypeString, alias: Project Number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: project_num )
• type_of_work ( type: esriFieldTypeString, alias: Type of Work, editable: true, nullable: true, length: 255, defaultValue: null, modelName: type_of_work )
• description ( type: esriFieldTypeString, alias: Description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: description )
• lab_activities ( type: esriFieldTypeString, alias: Lab Activities, editable: true, nullable: true, length: 255, defaultValue: null, modelName: lab_activities )
• num_crews ( type: esriFieldTypeInteger, alias: Number of Crews, editable: true, nullable: true, defaultValue: null, modelName: num_crews )
• station_id ( type: esriFieldTypeString, alias: Station ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: station_id )
• inspect_notes ( type: esriFieldTypeString, alias: Inspection Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: inspect_notes )
• pipe ( type: esriFieldTypeString, alias: Pipe, editable: true, nullable: true, length: 255, defaultValue: null, modelName: pipe , Coded Values: [san: Sanitary Sewer] , [wat: Water] , [stm: Storm] , ...2 more... )
• size ( type: esriFieldTypeDouble, alias: Size, editable: true, nullable: true, defaultValue: null, modelName: size )
• paving ( type: esriFieldTypeString, alias: Paving, editable: true, nullable: true, length: 255, defaultValue: null, modelName: paving , Coded Values: [str: Streets] , [inl: Inlets] , [blk: Blocks] )
• status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 255, defaultValue: ns, modelName: status , Coded Values: [ns: Not-Started] , [st: Started] , [cp: Completed] )
• photourl ( type: esriFieldTypeString, alias: photourls, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: photourl )
• daily_inspect ( type: esriFieldTypeSmallInteger, alias: Daily Inspection Point, editable: true, nullable: true, defaultValue: 0, modelName: daily_inspect , Coded Values: [0: No] , [1: Yes] )
• daily_inspect_added ( type: esriFieldTypeSmallInteger, alias: Daily Inspection Data Added?, editable: true, nullable: true, defaultValue: 0, modelName: daily_inspect_added , Coded Values: [0: No] , [1: Yes] )
• rainfall ( type: esriFieldTypeSmallInteger, alias: Rainfall, editable: true, nullable: true, defaultValue: 0, modelName: rainfall , Coded Values: [0: No] , [1: Yes] )
• workday ( type: esriFieldTypeSmallInteger, alias: Workday, editable: true, nullable: true, defaultValue: 0, modelName: workday , Coded Values: [0: No] , [1: Yes] )
• collected_date ( type: esriFieldTypeDate, alias: Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: collected_date )
• report_created ( type: esriFieldTypeSmallInteger, alias: Report Created?, editable: true, nullable: true, defaultValue: 0, modelName: report_created , Coded Values: [0: No] , [1: Yes] )
• daily_path ( type: esriFieldTypeString, alias: Daily Report Path, editable: true, nullable: true, length: 500, defaultValue: null, modelName: daily_path )
• weekly_path ( type: esriFieldTypeString, alias: Weekly Report Path, editable: true, nullable: true, length: 500, defaultValue: null, modelName: weekly_path )
• d_equipment ( type: esriFieldTypeString, alias: d_equipment, editable: true, nullable: true, length: 75, defaultValue: null, modelName: d_equipment )
• d_inspector ( type: esriFieldTypeString, alias: d_inspector, editable: true, nullable: true, length: 75, defaultValue: null, modelName: d_inspector )
• d_contractor ( type: esriFieldTypeString, alias: d_contractor, editable: true, nullable: true, length: 75, defaultValue: null, modelName: d_contractor )
• d_sitecondition ( type: esriFieldTypeString, alias: d_sitecondition, editable: true, nullable: true, length: 10, defaultValue: null, modelName: d_sitecondition )
• d_weather ( type: esriFieldTypeString, alias: d_weather, editable: true, nullable: true, length: 20, defaultValue: null, modelName: d_weather )
• d_project ( type: esriFieldTypeString, alias: d_project, editable: true, nullable: true, length: 75, defaultValue: null, modelName: d_project )
• d_client ( type: esriFieldTypeString, alias: d_client, editable: true, nullable: true, length: 75, defaultValue: null, modelName: d_client )
• d_projectnum ( type: esriFieldTypeString, alias: d_projectnum, editable: true, nullable: true, length: 20, defaultValue: null, modelName: d_projectnum )
• d_typeofwork ( type: esriFieldTypeString, alias: d_typeofwork, editable: true, nullable: true, length: 75, defaultValue: null, modelName: d_typeofwork )
• d_pipe ( type: esriFieldTypeString, alias: d_pipe, editable: true, nullable: true, length: 30, defaultValue: null, modelName: d_pipe )
• d_paving ( type: esriFieldTypeString, alias: d_paving, editable: true, nullable: true, length: 20, defaultValue: null, modelName: d_paving )
• d_status ( type: esriFieldTypeString, alias: d_status, editable: true, nullable: true, length: 20, defaultValue: null, modelName: d_status )
• d_rainfall ( type: esriFieldTypeString, alias: d_rainfall, editable: true, nullable: true, length: 5, defaultValue: null, modelName: d_rainfall )
• d_workday ( type: esriFieldTypeString, alias: d_workday, editable: true, nullable: true, length: 5, defaultValue: null, modelName: d_workday )
• daily_path_link ( type: esriFieldTypeString, alias: daily_path_link, editable: true, nullable: true, length: 500, defaultValue: null, modelName: daily_path_link )
• weekly_path_link ( type: esriFieldTypeString, alias: weekly_path_link, editable: true, nullable: true, length: 500, defaultValue: null, modelName: weekly_path_link )
• collected_date_txt ( type: esriFieldTypeString, alias: collected_date_txt, editable: true, nullable: true, length: 50, defaultValue: null, modelName: collected_date_txt )
• ds_photourl ( type: esriFieldTypeString, alias: ds_photourl, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: ds_photourl )
• equipment_backhoe ( type: esriFieldTypeString, alias: Backhoe, editable: true, nullable: true, length: 255, defaultValue: No, modelName: equipment_backhoe , Coded Values: [Yes: Yes] , [No: No] )
• equipment_blade ( type: esriFieldTypeString, alias: Blade, editable: true, nullable: true, length: 255, defaultValue: No, modelName: equipment_blade , Coded Values: [Yes: Yes] , [No: No] )
• equipment_compactor ( type: esriFieldTypeString, alias: Compactor, editable: true, nullable: true, length: 255, defaultValue: No, modelName: equipment_compactor , Coded Values: [Yes: Yes] , [No: No] )
• equipment_dozer ( type: esriFieldTypeString, alias: Dozer, editable: true, nullable: true, length: 255, defaultValue: No, modelName: equipment_dozer , Coded Values: [Yes: Yes] , [No: No] )
• equipment_enddump ( type: esriFieldTypeString, alias: End Dump, editable: true, nullable: true, length: 255, defaultValue: No, modelName: equipment_enddump , Coded Values: [Yes: Yes] , [No: No] )
• equipment_excavator ( type: esriFieldTypeString, alias: Excavator, editable: true, nullable: true, length: 255, defaultValue: No, modelName: equipment_excavator , Coded Values: [Yes: Yes] , [No: No] )
• equipment_loader ( type: esriFieldTypeString, alias: Loader, editable: true, nullable: true, length: 255, defaultValue: No, modelName: equipment_loader , Coded Values: [Yes: Yes] , [No: No] )
• equipment_paver ( type: esriFieldTypeString, alias: Paver, editable: true, nullable: true, length: 255, defaultValue: No, modelName: equipment_paver , Coded Values: [Yes: Yes] , [No: No] )
• equipment_roller ( type: esriFieldTypeString, alias: Roller, editable: true, nullable: true, length: 255, defaultValue: No, modelName: equipment_roller , Coded Values: [Yes: Yes] , [No: No] )
• equipment_watertruck ( type: esriFieldTypeString, alias: Water Truck, editable: true, nullable: true, length: 255, defaultValue: No, modelName: equipment_watertruck , Coded Values: [Yes: Yes] , [No: No] )
• equipment_none ( type: esriFieldTypeString, alias: No Equipment, editable: true, nullable: true, length: 255, defaultValue: Yes, modelName: equipment_none , Coded Values: [Yes: Yes] , [No: No] )
• typeofwork_sanitary ( type: esriFieldTypeString, alias: Sanitary, editable: true, nullable: true, length: 255, defaultValue: No, modelName: typeofwork_sanitary , Coded Values: [Yes: Yes] , [No: No] )
• typeofwork_water ( type: esriFieldTypeString, alias: Water, editable: true, nullable: true, length: 255, defaultValue: No, modelName: typeofwork_water , Coded Values: [Yes: Yes] , [No: No] )
• typeofwork_storm ( type: esriFieldTypeString, alias: Storm, editable: true, nullable: true, length: 255, defaultValue: No, modelName: typeofwork_storm , Coded Values: [Yes: Yes] , [No: No] )
• typeofwork_paving ( type: esriFieldTypeString, alias: Paving, editable: true, nullable: true, length: 255, defaultValue: No, modelName: typeofwork_paving , Coded Values: [Yes: Yes] , [No: No] )
• typeofwork_excavation ( type: esriFieldTypeString, alias: Excavation, editable: true, nullable: true, length: 255, defaultValue: No, modelName: typeofwork_excavation , Coded Values: [Yes: Yes] , [No: No] )
• daily_excel ( type: esriFieldTypeString, alias: daily_excel, editable: true, nullable: true, length: 255, defaultValue: null, modelName: daily_excel )
• weekly_excel ( type: esriFieldTypeString, alias: weekly_excel, editable: true, nullable: true, length: 255, defaultValue: null, modelName: weekly_excel )
• photo_list ( type: esriFieldTypeString, alias: photo_list, editable: true, nullable: true, length: 255, defaultValue: null, modelName: photo_list )
• add_contractor ( type: esriFieldTypeString, alias: Contractor, editable: true, nullable: true, length: 255, defaultValue: null, modelName: add_contractor , Coded Values: [Northtex Construction, LLC: Northtex Construction, LLC] , [R Construction: R Construction] , [Hurtado Construction Company: Hurtado Construction Company] , ...1 more... )
• typeofwork_massgrading ( type: esriFieldTypeString, alias: Mass Grading, editable: true, nullable: true, length: 255, defaultValue: No, modelName: typeofwork_massgrading , Coded Values: [Yes: Yes] , [No: No] )
• typeofwork_testing ( type: esriFieldTypeString, alias: Testing, editable: true, nullable: true, length: 255, defaultValue: No, modelName: typeofwork_testing , Coded Values: [Yes: Yes] , [No: No] )
• typeofwork_generalconstruction ( type: esriFieldTypeString, alias: General Construction, editable: true, nullable: true, length: 255, defaultValue: No, modelName: typeofwork_generalconstruction , Coded Values: [Yes: Yes] , [No: No] )
• typeofwork_clearing ( type: esriFieldTypeString, alias: Clearing, editable: true, nullable: true, length: 255, defaultValue: No, modelName: typeofwork_clearing , Coded Values: [Yes: Yes] , [No: No] )
• equipment_chipper ( type: esriFieldTypeString, alias: Chipper, editable: true, nullable: true, length: 255, defaultValue: No, modelName: equipment_chipper , Coded Values: [Yes: Yes] , [No: No] )
• equipment_Offroadtruck ( type: esriFieldTypeString, alias: Off Road Truck, editable: true, nullable: true, length: 255, defaultValue: No, modelName: equipment_Offroadtruck , Coded Values: [Yes: Yes] , [No: No] )

Templates:

• Name: Field Inspection
  Description:
  Prototype:
  equipment_chipper: No
  equipment_Offroadtruck: No
  reportid: null
  typeofwork_clearing: No
  typeofwork_generalconstruction: No
  typeofwork_testing: No
  typeofwork_massgrading: No
  equipment: null
  inspector: null
  contractor: null
  site_condition: null
  weather: null
  daily_notes: null
  project: TBD
  client: null
  project_num: null
  type_of_work: null
  description: null
  lab_activities: null
  num_crews: null
  station_id: null
  inspect_notes: null
  pipe: null
  size: null
  paving: null
  status: ns
  photourl: null
  daily_inspect: 0
  daily_inspect_added: 0
  rainfall: 0
  workday: 0
  collected_date: null
  report_created: 0
  daily_path: null
  weekly_path: null
  d_equipment: null
  d_inspector: null
  d_contractor: null
  d_sitecondition: null
  d_weather: null
  d_project: null
  d_client: null
  d_projectnum: null
  d_typeofwork: null
  d_pipe: null
  d_paving: null
  d_status: null
  d_rainfall: null
  d_workday: null
  daily_path_link: null
  weekly_path_link: null
  collected_date_txt: null
  ds_photourl: null
  equipment_backhoe: No
  equipment_blade: No
  equipment_compactor: No
  equipment_dozer: No
  equipment_enddump: No
  equipment_excavator: No
  equipment_loader: No
  equipment_paver: No
  equipment_roller: No
  equipment_watertruck: No
  equipment_none: Yes
  typeofwork_sanitary: No
  typeofwork_water: No
  typeofwork_storm: No
  typeofwork_paving: No
  typeofwork_excavation: No
  daily_excel: null
  weekly_excel: null
  photo_list: null
  add_contractor: null
  
  Drawing Tool: esriFeatureEditToolPoint

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

Sync Can Return Changes: true

Is Data Versioned: true

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

Child Resources:   Field Groups   Contingent Values

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