View In:   ArcGIS Online Map Viewer

Name: PIP_Septic_Permits_SQL

Display Field: Inspector

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: PIP Permits SQL 2-23-2023

Service Item Id: 05f610580b5c46ad9b8bdcfe059c06e1

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

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: 442022.261986611
YMin: 4634602.549462974
XMax: 480857.60347392864
YMax: 4673233.178862851
Spatial Reference: 26915  (26915)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [150, 135, 0, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
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: 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: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• Parcel_ID_Num_Key ( type: esriFieldTypeInteger, alias: Parcel_ID_Num_Key, editable: true, nullable: true, defaultValue: null, modelName: Parcel_ID_Num_Key )
• Inspector ( type: esriFieldTypeString, alias: Inspector, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Inspector )
• Active ( type: esriFieldTypeString, alias: Active, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Active )
• Permit_Ready ( type: esriFieldTypeString, alias: Permit_Ready, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Permit_Ready )
• Permit_Number ( type: esriFieldTypeInteger, alias: Permit_Number, editable: true, nullable: true, defaultValue: null, modelName: Permit_Number )
• Activity_Update ( type: esriFieldTypeString, alias: Activity_Update, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Activity_Update )
• Fiscal_Year ( type: esriFieldTypeInteger, alias: Fiscal_Year, editable: true, nullable: true, defaultValue: null, modelName: Fiscal_Year )
• Date_Issued ( type: esriFieldTypeDate, alias: Date_Issued, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Date_Issued )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Notes )
• System_Type ( type: esriFieldTypeString, alias: System_Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: System_Type )
• Discharge ( type: esriFieldTypeString, alias: Discharge, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Discharge )
• Field1 ( type: esriFieldTypeString, alias: Field1, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Field1 )
• Installer ( type: esriFieldTypeString, alias: Installer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Installer )
• Lateral_Type ( type: esriFieldTypeString, alias: Lateral_Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Lateral_Type )
• Measurements_Complete ( type: esriFieldTypeDate, alias: Measurements_Complete, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Measurements_Complete )
• Measurements_2 ( type: esriFieldTypeString, alias: Measurements_2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Measurements_2 )
• Pump_Info ( type: esriFieldTypeString, alias: Pump_Info, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Pump_Info )
• Permitee_Key ( type: esriFieldTypeInteger, alias: Permitee_Key, editable: true, nullable: true, defaultValue: null, modelName: Permitee_Key )
• Septic_Key ( type: esriFieldTypeOID, alias: Septic_Key, editable: false, nullable: false, defaultValue: null, modelName: Septic_Key )
• Site_Eval_ID_Num ( type: esriFieldTypeInteger, alias: Site_Eval_ID_Num, editable: true, nullable: true, defaultValue: null, modelName: Site_Eval_ID_Num )
• Min_Tank_Size ( type: esriFieldTypeInteger, alias: Min_Tank_Size, editable: true, nullable: true, defaultValue: null, modelName: Min_Tank_Size )
• Final_Inspection_Notes ( type: esriFieldTypeString, alias: Final_Inspection_Notes, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Final_Inspection_Notes )
• Pump_Chamber ( type: esriFieldTypeSmallInteger, alias: Pump_Chamber, editable: true, nullable: true, defaultValue: null, modelName: Pump_Chamber )
• Delivery ( type: esriFieldTypeString, alias: Delivery, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Delivery )
• Formula ( type: esriFieldTypeString, alias: Formula, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Formula )
• Loading_Rate ( type: esriFieldTypeString, alias: Loading_Rate, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Loading_Rate )
• Waste_Rate ( type: esriFieldTypeString, alias: Waste_Rate, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Waste_Rate )
• W_2F ( type: esriFieldTypeString, alias: W_2F, editable: true, nullable: true, length: 255, defaultValue: null, modelName: W_2F )
• W_3F ( type: esriFieldTypeString, alias: W_3F, editable: true, nullable: true, length: 255, defaultValue: null, modelName: W_3F )
• W_2FP ( type: esriFieldTypeString, alias: W_2FP, editable: true, nullable: true, length: 255, defaultValue: null, modelName: W_2FP )
• W_3FP ( type: esriFieldTypeString, alias: W_3FP, editable: true, nullable: true, length: 255, defaultValue: null, modelName: W_3FP )
• Permit_Type ( type: esriFieldTypeString, alias: Permit_Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Permit_Type )
• App_Prop_Contractor ( type: esriFieldTypeInteger, alias: App_Prop_Contractor, editable: true, nullable: true, defaultValue: null, modelName: App_Prop_Contractor )
• Contractor ( type: esriFieldTypeString, alias: Contractor, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Contractor )
• App_Start_Date ( type: esriFieldTypeString, alias: App_Start_Date, editable: true, nullable: true, length: 255, defaultValue: null, modelName: App_Start_Date )
• Permit_Code ( type: esriFieldTypeString, alias: Permit_Code, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Permit_Code )
• Approved_By ( type: esriFieldTypeString, alias: Approved_By, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Approved_By )
• Site_Eval_Evaluator ( type: esriFieldTypeString, alias: Site_Eval_Evaluator, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Site_Eval_Evaluator )
• Site_Eval_Field_Notes ( type: esriFieldTypeString, alias: Site_Eval_Field_Notes, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Site_Eval_Field_Notes )
• Site_Eval_Time ( type: esriFieldTypeString, alias: Site_Eval_Time, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Site_Eval_Time )
• Site_Eval_Date ( type: esriFieldTypeDate, alias: Site_Eval_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Site_Eval_Date )
• Range_Limiting ( type: esriFieldTypeString, alias: Range_Limiting, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Range_Limiting )
• Depth_Sand ( type: esriFieldTypeString, alias: Depth_Sand, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Depth_Sand )
• Gravel_Bed ( type: esriFieldTypeString, alias: Gravel_Bed, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Gravel_Bed )
• Max_Width ( type: esriFieldTypeString, alias: Max_Width, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Max_Width )
• Linear_Loading ( type: esriFieldTypeString, alias: Linear_Loading, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Linear_Loading )
• Sand_Soil ( type: esriFieldTypeString, alias: Sand_Soil, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Sand_Soil )
• Slope ( type: esriFieldTypeString, alias: Slope, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Slope )
• DNR_Created ( type: esriFieldTypeString, alias: DNR_Created, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DNR_Created )
• Permit_Complete ( type: esriFieldTypeString, alias: Permit_Complete, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Permit_Complete )
• Final_Date ( type: esriFieldTypeDate, alias: Final_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Final_Date )
• Final_Complete ( type: esriFieldTypeString, alias: Final_Complete, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Final_Complete )
• Final_Inspector ( type: esriFieldTypeString, alias: Final_Inspector, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Final_Inspector )
• Lat ( type: esriFieldTypeDouble, alias: Lat, editable: true, nullable: true, defaultValue: null, modelName: Lat )
• Long ( type: esriFieldTypeDouble, alias: Long, editable: true, nullable: true, defaultValue: null, modelName: Long )
• Permit_Notes ( type: esriFieldTypeString, alias: Permit_Notes, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Permit_Notes )
• Last_Update ( type: esriFieldTypeDate, alias: Last_Update, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Last_Update )
• Maint_Contract_Rqd ( type: esriFieldTypeString, alias: Maint_Contract_Rqd, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Maint_Contract_Rqd )
• GPS_Confirmed ( type: esriFieldTypeString, alias: GPS_Confirmed, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GPS_Confirmed )
• NPDES_Req ( type: esriFieldTypeString, alias: NPDES_Req, editable: true, nullable: true, length: 255, defaultValue: null, modelName: NPDES_Req )
• NPDES_Permit ( type: esriFieldTypeString, alias: NPDES_Permit, editable: true, nullable: true, length: 255, defaultValue: null, modelName: NPDES_Permit )
• Liner_Req ( type: esriFieldTypeString, alias: Liner_Req, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Liner_Req )
• Sand_Lateral ( type: esriFieldTypeInteger, alias: Sand_Lateral, editable: true, nullable: true, defaultValue: null, modelName: Sand_Lateral )
• Non_Household ( type: esriFieldTypeInteger, alias: Non_Household, editable: true, nullable: true, defaultValue: null, modelName: Non_Household )
• Grade_Drainable ( type: esriFieldTypeInteger, alias: Grade_Drainable, editable: true, nullable: true, defaultValue: null, modelName: Grade_Drainable )
• Grade_Gravel_Depth ( type: esriFieldTypeInteger, alias: Grade_Gravel_Depth, editable: true, nullable: true, defaultValue: null, modelName: Grade_Gravel_Depth )
• Grade_Gravel_Area ( type: esriFieldTypeInteger, alias: Grade_Gravel_Area, editable: true, nullable: true, defaultValue: null, modelName: Grade_Gravel_Area )
• Grade_Rate ( type: esriFieldTypeInteger, alias: Grade_Rate, editable: true, nullable: true, defaultValue: null, modelName: Grade_Rate )
• Bed_Depth ( type: esriFieldTypeInteger, alias: Bed_Depth, editable: true, nullable: true, defaultValue: null, modelName: Bed_Depth )
• Comb_Per_Num ( type: esriFieldTypeString, alias: Comb_Per_Num, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comb_Per_Num )
• Extra ( type: esriFieldTypeString, alias: Extra, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Extra )
• Final_Treatment ( type: esriFieldTypeString, alias: Final_Treatment, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Final_Treatment )
• OutFall_Lat ( type: esriFieldTypeDouble, alias: OutFall_Lat, editable: true, nullable: true, defaultValue: null, modelName: OutFall_Lat )
• OutFall_Long ( type: esriFieldTypeDouble, alias: OutFall_Long, editable: true, nullable: true, defaultValue: null, modelName: OutFall_Long )
• OutFall_Confidence ( type: esriFieldTypeString, alias: OutFall_Confidence, editable: true, nullable: true, length: 255, defaultValue: null, modelName: OutFall_Confidence )
• Pump_Chamber_Min ( type: esriFieldTypeString, alias: Pump_Chamber_Min, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Pump_Chamber_Min )
• Bed_Depth_Max ( type: esriFieldTypeString, alias: Bed_Depth_Max, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Bed_Depth_Max )
• Variances ( type: esriFieldTypeString, alias: Variances, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Variances )
• NOI_Req ( type: esriFieldTypeString, alias: NOI_Req, editable: true, nullable: true, length: 255, defaultValue: null, modelName: NOI_Req )
• City_Water ( type: esriFieldTypeSmallInteger, alias: City_Water, editable: true, nullable: true, defaultValue: null, modelName: City_Water )
• Var_Notes ( type: esriFieldTypeString, alias: Var_Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Var_Notes )
• NPDES_Date ( type: esriFieldTypeDate, alias: NPDES_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: NPDES_Date )
• EncryptedPermitId ( type: esriFieldTypeString, alias: EncryptedPermitId, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EncryptedPermitId )
• Link ( type: esriFieldTypeString, alias: Link, editable: true, nullable: true, length: 104, defaultValue: null, modelName: Link )
• Photo_Web ( type: esriFieldTypeString, alias: Photo_Web, editable: true, nullable: true, length: 292, defaultValue: null, modelName: Photo_Web )

Templates:

• Name: PIP_Septic_Permits_SQL
  Description:
  Prototype:
  Link: null
  Parcel_ID_Num_Key: null
  Inspector: null
  Active: null
  Permit_Ready: null
  Permit_Number: null
  Activity_Update: null
  Fiscal_Year: null
  Date_Issued: null
  Notes: null
  System_Type: null
  Discharge: null
  Field1: null
  Installer: null
  Lateral_Type: null
  Measurements_Complete: null
  Measurements_2: null
  Pump_Info: null
  Permitee_Key: null
  Photo_Web: null
  Site_Eval_ID_Num: null
  Min_Tank_Size: null
  Final_Inspection_Notes: null
  Pump_Chamber: null
  Delivery: null
  Formula: null
  Loading_Rate: null
  Waste_Rate: null
  W_2F: null
  W_3F: null
  W_2FP: null
  W_3FP: null
  Permit_Type: null
  App_Prop_Contractor: null
  Contractor: null
  App_Start_Date: null
  Permit_Code: null
  Approved_By: null
  Site_Eval_Evaluator: null
  Site_Eval_Field_Notes: null
  Site_Eval_Time: null
  Site_Eval_Date: null
  Range_Limiting: null
  Depth_Sand: null
  Gravel_Bed: null
  Max_Width: null
  Linear_Loading: null
  Sand_Soil: null
  Slope: null
  DNR_Created: null
  Permit_Complete: null
  Final_Date: null
  Final_Complete: null
  Final_Inspector: null
  Lat: null
  Long: null
  Permit_Notes: null
  Last_Update: null
  Maint_Contract_Rqd: null
  GPS_Confirmed: null
  NPDES_Req: null
  NPDES_Permit: null
  Liner_Req: null
  Sand_Lateral: null
  Non_Household: null
  Grade_Drainable: null
  Grade_Gravel_Depth: null
  Grade_Gravel_Area: null
  Grade_Rate: null
  Bed_Depth: null
  Comb_Per_Num: null
  Extra: null
  Final_Treatment: null
  OutFall_Lat: null
  OutFall_Long: null
  OutFall_Confidence: null
  Pump_Chamber_Min: null
  Bed_Depth_Max: null
  Variances: null
  NOI_Req: null
  City_Water: null
  Var_Notes: null
  NPDES_Date: null
  EncryptedPermitId: null
  
  Drawing Tool: esriFeatureEditToolPoint

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

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

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