search

cityofaustin / atd-data-tech

Austin Transportation Data & Technology Services
18 stars 2 forks source link

Pull NBP List with updated fields from AMANDA and Export table to CSV file. #20002

Closed atdservicebot closed 5 days ago

atdservicebot commented 6 days ago

What application are you using?

ArcGIS

Describe the problem.

Zach said he can help me gather specific data from AMANDA. I have all the RSN #'s and nee emails and addresses from the applicants

How soon do you need this?

Flexible — An extended timeline is OK

Requested By Margaret R.

Request ID: DTS24-119400

ATD-ZachB commented 5 days ago

List was not able to be pulled from the new GIS data layers because permits that are more than 2 weeks expired are not brought into the data set.

Charlie was able to query the AMANDA db to populate the requested fields for each FOLDERRSN.

List is being sent via email to requestor!

Charlie-Henry commented 5 days ago

query:

select fp.FOLDERRSN, p.EMAILADDRESS, p.NAMEFIRST || ' ' || p.NAMELAST AS name
from FOLDERPEOPLE fp
         left join people p on p.PEOPLERSN = fp.PEOPLERSN
where fp.FOLDERRSN in (12309933,
                       12319940,
                       12307768
    )
  and fp.PEOPLECODE = 1