marsFetchPrivateSMPRecords: Return query results of private SMPs

In taywater/pwdgsi: Philadelphia Water Department Green Stormwater Infrastructure

Return query results of private SMPs

Description

Returns private SMP tracking number, project name, SMP ID, and plan label.

Usage

marsFetchPrivateSMPRecords(con, tracking_number)

Arguments

con	Formal class PostgreSQL, a connection to the MARS Analysis database
tracking_number	chr, tracking number for the requested SMP

Value

Output will be a dateframe with four columns:

tracking_number	chr, requested SMP tracking number
project name	chr, SMP poject name
smp_id	int, SMP ID
plan_label	chr, name that the SMP is given on the plan set

If a tracking number is not found, that row will include an error message in the "project name" column, and NAs in "smp_id" and "plan_label".

taywater/pwdgsi documentation built on May 4, 2024, 6:53 p.m.