A demonstration. This is not the city's website. It is a working proposal for the City of Pharr, built with the city's real seal, officials, departments and video. Every agenda item, vote, vehicle and dollar figure is invented, and each page says so. About this proposal Developed by Pragmatic Business Solutions, LLC (opens in a new tab), a Rio Grande City, TX custom software company.

Staff dashboard

Public Works Supervisor

Opened at 6:00 in the yard, on a phone, before the tailgate meeting. If he cannot dispatch from this screen he will keep using the whiteboard.

Friday 4 September 2026, 6:00 a.m. · 97°F today, 30% rain after five

Needs attention this morning

  • Las Milpas drainage — the backhoe is on site and the contract is not signed

    PW-40 has been at the project since Tuesday doing preparatory work. The notice to proceed is eight days late. Somebody should confirm what the crew is authorised to do before they start cutting.

    Call the city manager's office

  • Water main break — 1408 West Ferguson Avenue

    Leak crew on site since 6:10. 84 accounts out. The pothole patch two blocks over is held until the hole is backfilled.

    Open the work orderNotify the accounts

  • Rain after five — the West Sioux ditch has been open 44 days

    Thirty per cent today, seventy on Sunday. That ditch is what backs up into the yards on Moorefield.

    Assign the drainage crew

  • Eleven jobs are waiting on the electric utility

    Street lights, mostly. They are shown apart from the city's own late work on purpose: if somebody else's fourteen days sit in red next to our own, red stops meaning anything.

    See the eleven

The numbers

Every tile links to the list that produced it. A number nobody can drill into is a brochure.

  • Open service requests

    214

    Across Streets, Drainage and Solid Waste · was 241 last Friday

    Watch

  • Past due more than 14 days

    31

    Oldest is 44 days — the ditch on West Sioux Road. Eleven of the thirty-one are waiting on somebody else.

    Action

  • Days to close, Public Works

    3.1

    Median · target is 4 · was 3.6 last month

    On target

  • Water main breaks this month

    6

    74 this fiscal year against 61 last · most of them on the 1960s line under Cage Boulevard

    Watch

  • Overtime hours this pay period

    288

    The cap is 200 per department · seven people are over 60 individually

    Action

  • Crew on the yard today

    41 of 48

    Drainage crew is 6 of 8. Signs crew is 2 of 3.

    Watch

  • Units out of service

    19 of 340

    PW-21 is in the shop for the fifth time this year and is running $1.42 a mile

    Action

  • Brush collection today

    Zone C

    Two grapple trucks on the route · residents can see their own zone on the app

    On target

Today's board

Work orderJobLocationCrewDaysStatus
WO-8841Clean the drainage ditchW Sioux Rd at MoorefieldDrainage44Past due — rain Sunday
WO-8902Four street lights outE Ridge Rd at S VeteransSigns31Waiting on the utility — ticket 44-9021
WO-8955Six-inch main repair1408 W Ferguson AveLeak crew1In progress — on site 6:10
WO-8961Pothole patch1400 blk W Ferguson AveStreets 23Held until the main is backfilled
WO-8968Dumped mattress and tyres2200 blk S Cage BlvdSolid Waste1Scheduled today
WO-8970Raise a buried meter boxW Sioux Rd at MoorefieldUtilities3Needs the backhoe after Las Milpas

Over the fiscal year

October to September, because that is the Texas fiscal year. September is four days of a month — it is drawn, but it never sets a trend.

Service requests received and closedSeptember is five days of a month, not a collapse. The dip in January is the freeze; the climb from February is when reporting moved online.
  • Received
  • Closed
05001,0001,5002,000Received 1,126Closed 1,088OctReceived 1,012Closed 1,042NovReceived 823Closed 886DecReceived 1,390Closed 1,210JanReceived 1,100Closed 1,264FebReceived 1,214Closed 1,193MarReceived 1,264Closed 1,243AprReceived 1,336Closed 1,298MayReceived 1,445Closed 1,432JunReceived 1,516Closed 1,508JulReceived 1,478Closed 1,537AugReceived 256Closed 248Sep
Table view
MonthReceivedClosed
Oct1,1261,088
Nov1,0121,042
Dec823886
Jan1,3901,210
Feb1,1001,264
Mar1,2141,193
Apr1,2641,243
May1,3361,298
Jun1,4451,432
Jul1,5161,508
Aug1,4781,537
Sep256248
Overtime hours by departmentPublic Utilities is pacing 576 hours this month against 244 in August. Overtime is what a staffing shortage costs when nobody writes it down.
  • Police
  • Fire
  • Public Works
  • Public Utilities
  • Parks, library and admin
05,00010K15KPolice 2,448Fire 1,552Public Works 856Public Utilities 672Parks, library and admin 552OctPolice 2,352Fire 1,608Public Works 784Public Utilities 616Parks, library and admin 504NovPolice 2,816Fire 1,864Public Works 964Public Utilities 756Parks, library and admin 500DecPolice 2,964Fire 2,048Public Works 1,552Public Utilities 1,648Parks, library and admin 592JanPolice 2,384Fire 1,576Public Works 928Public Utilities 804Parks, library and admin 540FebPolice 2,536Fire 1,484Public Works 872Public Utilities 704Parks, library and admin 636MarPolice 2,476Fire 1,432Public Works 904Public Utilities 728Parks, library and admin 684AprPolice 2,592Fire 1,528Public Works 992Public Utilities 776Parks, library and admin 736MayPolice 2,808Fire 1,696Public Works 1,164Public Utilities 884Parks, library and admin 816JunPolice 3,072Fire 1,884Public Works 1,344Public Utilities 1,024Parks, library and admin 888JulPolice 2,976Fire 1,848Public Works 1,272Public Utilities 976Parks, library and admin 856AugPolice 3,072Fire 1,968Public Works 1,776Public Utilities 2,304Parks, library and admin 888Sep
Table view
MonthPoliceFirePublic WorksPublic UtilitiesParks, library and admin
Oct2,4481,552856672552
Nov2,3521,608784616504
Dec2,8161,864964756500
Jan2,9642,0481,5521,648592
Feb2,3841,576928804540
Mar2,5361,484872704636
Apr2,4761,432904728684
May2,5921,528992776736
Jun2,8081,6961,164884816
Jul3,0721,8841,3441,024888
Aug2,9761,8481,272976856
Sep3,0721,9681,7762,304888
Days from application to permit issuedCalendar days, not business days — business days are how a permit office flatters itself. Every line bends in February, when applying and paying moved online.
  • Commercial building
  • Residential building
  • Fence, sign and other
  • Trades
050100150OctNovDecJanFebMarAprMayJunJulAugSepCommercial buildingResidential buildingFence, sign and otherTrades6425.612.25.4calendar days
Table view
MonthCommercial buildingResidential buildingFence, sign and otherTrades
Oct884520.911.2
Nov9442.519.410.4
Dec102492212.2
Jan1125526.315.1
Feb994621.211.9
Mar934118.710.1
Apr8538.917.39
May7934.615.87.9
Jun733214.87.2
Jul6929.5146.5
Aug6627.4135.8
Sep6425.612.25.4