Get registered projects — GetProjects • TABS

Returns a df of projects registered in the TABS database

Usage

GetProjects(
  county = NULL,
  city = NULL,
  reg_begin = "",
  reg_end = "",
  owner = "",
  project = "",
  facility = "",
  address = ""
)

Arguments

county: The Texas county where the physical project is
city: The Texas city where the physical project is
reg_begin: The start date for searching projects Date Format: mm/dd/yy
reg_end: The cutoff date for searching projects Date Format: mm/dd/yy
owner: Search by the owner of a project
project: Search by project name
facility: Search by the facility name
address: Search by the physical address of a project

Value

Projects based on the given criteria

Examples

GetProjects(
  county = "Caldwell",
  reg_begin = "03/01/24",
  reg_end = "04/01/24"
)
#> # A tibble: 2 × 13
#>   ProjectId                ProjectNumber DataVersionId ProjectName ProjectStatus
#>   <chr>                    <chr>                 <int> <chr>       <chr>        
#> 1 2d1d3a91-4163-4a87-83c5… TABS20240143…        900001 Downtown R… Review Compl…
#> 2 c6f14339-97c4-47c3-865d… TABS20240138…        900001 Caldwell C… Review Compl…
#> # ℹ 8 more variables: ProjectCreatedOn <chr>, FacilityName <chr>, City <chr>,
#> #   County <chr>, TypeOfWork <chr>, EstimatedCost <dbl>,
#> #   EstimatedStartDate <chr>, EstimatedEndDate <chr>
GetProjects(
  city = "Austin",
  owner = "Tesla",
  reg_begin = "01/01/20",
  reg_end = "01/01/24"
)
#> # A tibble: 18 × 13
#>    ProjectId               ProjectNumber DataVersionId ProjectName ProjectStatus
#>    <chr>                   <chr>                 <int> <chr>       <chr>        
#>  1 5e9807b6-2e19-4321-ad2… TABS20240050…        900001 Tesla - Au… Review Compl…
#>  2 10bfef25-1f11-4d69-b02… TABS20240050…        900001 Tesla - Au… Review Compl…
#>  3 cb51ea73-45d2-42e9-841… TABS20240050…        900001 Tesla - Au… Review Compl…
#>  4 f4fe51eb-f383-49a4-a44… TABS20240016…        900001 Tesla - CY… Review Compl…
#>  5 73e58c62-18a8-4cc5-a27… TABS20240015…        900001 Tesla - Au… Project Regi…
#>  6 1a606421-df95-45f2-a2b… TABS20230224…        900001 Tesla - Au… Review Compl…
#>  7 6eeb5963-58b7-41b6-8cf… TABS20230145…        900001 Tesla - Au… Review Compl…
#>  8 cb1db4ea-f42d-4246-b90… TABS20230090…        900001 Tesla Inc.  Project Clos…
#>  9 e85eb537-95c8-407e-bc5… TABS20230089…        900001 Tesla Inc.  Review Compl…
#> 10 73e05b7b-333a-4fca-903… TABS20230089…        900001 Tesla Inc.  Review Compl…
#> 11 b45fdc21-7e8f-41a5-bca… TABS20230089…        900001 Tesla Inc.  Project Clos…
#> 12 c3942697-0d34-4ff2-981… TABS20230089…        900001 Tesla Inc.  Review Compl…
#> 13 78770e35-799a-4bec-86a… TABS20230079…        900001 Tesla Inc.  Review Compl…
#> 14 f231061e-6e6a-4e0b-b88… TABS20220057…        900001 Tesla Inc.  Review Compl…
#> 15 b2ceedb5-f47c-412c-8b4… TABS20220057…        900001 Tesla Inc.  Review Compl…
#> 16 b0acf81d-bf5e-495b-a53… TABS20220057…        900001 Tesla Inc.  Review Compl…
#> 17 c0d2c11c-73ee-47c0-993… TABS20220057…        900001 Tesla Inc.  Review Compl…
#> 18 e1b5be59-bc3a-4fc5-969… TABS20220057…        900001 Tesla Inc.  Review Compl…
#> # ℹ 8 more variables: ProjectCreatedOn <chr>, FacilityName <chr>, City <chr>,
#> #   County <chr>, TypeOfWork <chr>, EstimatedCost <dbl>,
#> #   EstimatedStartDate <chr>, EstimatedEndDate <chr>