cityofaustin / atd-geospatial

Austin Transportation Data and Technology Services Geospatial Team
1 stars 0 forks source link

Active Parking Permits Web Map - FME to Python #168

Closed jaime-mckeown closed 4 years ago

jaime-mckeown commented 5 years ago

Need to create a new Python script to emulate Mat's FME process for updating the 2 GIS feature layers in AGOL for the Active Parking Permits Web Map.

Active Parking Permits (Updated Daily – I run this Workbench every morning): http://arcg.is/11GzWr Map data page: http://austin.maps.arcgis.com/home/item.html?id=93ced30411234ed191bbf10c9ca61398 App data page: http://austin.maps.arcgis.com/home/item.html?id=3cd9f3250ee64ba88f9c858eedf4ae9c MXD: \coacd.org\dfs\TPSD\ATD\ATD_GIS\Office_of_Special_Events\Map_Requests\ParkingSpacesPermits_Publish.mxd FME Data Workbench \coacd.org\dfs\TPSD\ATD\ATD_GIS\Office_of_Special_Events\OSE_GIS\ParkingSpacesPermits.fmw FME AGOL Publisher Workbench \coacd.org\dfs\TPSD\ATD\ATD_GIS\Office_of_Special_Events\OSE_GIS\ParkingSpacesPermits_Publish.fmw ***Maria Alonso (ACE Event Manager) requested this map – it takes the “Street Events” permits from the AMANDA ROW permits GIS layer, and does a spatial join on the parking spaces to produce the map of affected spaces.

Migrated to atd-data-tech #1647

jaime-mckeown commented 5 years ago

Per Mat Peck:

“Parking_Meter_Spaces” is a merged layer of both the Production layers Parking Meter and Parking Spaces, and it picks up (using the FeatureMerger translator) the new records from MAINT1 if meters or spaces have been added. “Parking_Meter_Spaces” doesn’t change often, so I had a convenience copy in the “FMEserver.gdb” File Geodatabase that I used for my FME tools. Everything circled in red is read from to written to that FGDB. All the magic for this tool happens in the “AMANDA_GIS.amanda_row_permits” layer reader – there is a WHERE clause that pulls all of the street permits that occur within two weeks of today (System Date). Once it’s filtered, it just does a spatial join to the spaces that are near those permits.

jaime-mckeown commented 4 years ago
jaime-mckeown commented 4 years ago

Ran script this morning, it failed as the service definition already existed and the Mxd was logged out of AGOL. I will need to figure out these 2 issues.