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

City Manager

Opened at 7:30 with coffee, before the department heads arrive. A good day is a screen where nothing is red and it closes in eight seconds.

Friday 4 September 2026, 7:30 a.m. · Fiscal year 93.1% elapsed

Needs attention this morning

  • Las Milpas drainage — notice to proceed is eight days late

    The commission awarded this on 24 August with a substantial-completion date of 30 April 2027. The contract has not been signed. Every day of slip is a day closer to next year's rain, and the residents who spoke at that meeting were told a date.

    Call the contractorPut it on Monday's agenda

  • Overtime is over budget with a month of the year left

    $1.94M against $1.73M budgeted, and 62% of the overage is in Police. A budget amendment has to come to the commission before 30 September or the year closes out of balance.

    See the department splitDraft the amendment

  • PD-131 is on the road with an expired state inspection

    Six days past. It is a legal exposure rather than a cost, and it is the cheapest thing on this screen to fix.

    Pull it off the road

  • Six records requests are past ten business days

    Four are waiting on the Attorney General for a ruling, which stops the clock. Two are not, and those two are the city's own delay.

    Open the two

The numbers

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

  • Days of cash on hand

    196

    General Fund · policy floor is 120 days · was 188 last month

    On target

  • Revenue collected, year to date

    94.1%

    $88.6M of $94.2M · the year is 93.1% gone · September sales tax posts on the 10th

    On target

  • Overtime against budget

    112.4%

    $1.94M of $1.73M · Police is pacing 2,140 hours against 1,610 in August

    Action

  • Water loss, year to date

    18.4%

    Below the 20% the TWDB expects · this month 16.9% and falling

    On target

  • Days to close a service request

    3.9

    Median · target is 5 · 214 open, 31 past due

    On target

  • Bridge revenue, year to date

    $3.06M

    Crossings are up 6.2% on last year · this is the city's second-largest own-source revenue

    On target

  • Grant spending not yet reimbursed

    $2.61M

    Nine awards · the oldest draw request is 62 days old · the drainage bond pay application is due in the portal on 15 September

    Action

  • Records requests past deadline

    6

    Of 74 open · ten business days under the Public Information Act, and past it the city loses the right to withhold

    Action

What needs a decision from this office this week

ItemDepartmentAmountWaitingStatus
Las Milpas drainage — notice to proceedEngineering$4,180,0008 daysPast due — awarded 24 August
Overtime budget amendmentFinance$210,0004 daysMust reach the commission before 30 September
Drainage bond pay application 3Finance$1,340,0002 daysDue in the portal 15 September
Fleet GPS contract — signatureInnovation & Technology$612,5001 dayAwarded 25 August, ready to sign
Bridge staffing plan for the produce seasonPharr International Bridge6 daysWaiting on CBP hours
Two records requests past deadlineCity Clerk's Office3 daysCity's own delay — not an AG hold

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
Service requests closed within targetIts own chart rather than a second axis on the one above — two scales on one plot invent a relationship the numbers do not contain.
0255075100OctNovDecJanFebMarAprMayJunJulAugSepClosed on time95%percent on time
Table view
MonthClosed on time
Oct91%
Nov92%
Dec88%
Jan76%
Feb83%
Mar87%
Apr90%
May91%
Jun92%
Jul93%
Aug94%
Sep95%
Water produced and water billedThe gap between the two lines is water the city pumped, treated and never got paid for. Phase one of the north loop went into service in June.
  • Produced at the plant
  • Billed to customers
0100200300400OctNovDecJanFebMarAprMayJunJulAugSepProduced at the plantBilled to customers348 MG279 MGmillion gallons
Table view
MonthProduced at the plantBilled to customers
Oct283 MG219 MG
Nov246 MG190 MG
Dec233 MG177 MG
Jan230 MG168 MG
Feb223 MG165 MG
Mar255 MG192 MG
Apr282 MG215 MG
May312 MG240 MG
Jun342 MG265 MG
Jul369 MG289 MG
Aug357 MG282 MG
Sep348 MG279 MG
Water lossAbove 15% the Texas Water Development Board expects mitigation in the next conservation plan. The line has fallen every month since the freeze.
  • Water loss
  • TWDB threshold
0102030OctNovDecJanFebMarAprMayJunJulAugSepWater lossTWDB threshold19.8%15%percent of production
Table view
MonthWater lossTWDB threshold
Oct22.4%15%
Nov22.9%15%
Dec24.1%15%
Jan26.8%15%
Feb25.9%15%
Mar24.6%15%
Apr23.8%15%
May23.1%15%
Jun22.4%15%
Jul21.6%15%
Aug20.9%15%
Sep19.8%15%
Where the city's money came fromThousands of dollars collected. The September sales-tax allocation posts on the 10th, so the tallest recurring block is simply not there yet.
  • Property tax
  • Water and sewer
  • Sales tax
  • Court, permits and other
$0$5,000$10K$15K$20KProperty tax 1,092Water and sewer 2,085Sales tax 1,654Court, permits and other 1,232OctProperty tax 3,328Water and sewer 1,934Sales tax 1,570Court, permits and other 1,149NovProperty tax 9,776Water and sewer 1,862Sales tax 1,773Court, permits and other 1,336DecProperty tax 12,532Water and sewer 1,815Sales tax 2,007Court, permits and other 1,295JanProperty tax 2,704Water and sewer 1,789Sales tax 1,721Court, permits and other 1,326FebProperty tax 936Water and sewer 1,929Sales tax 1,654Court, permits and other 1,513MarProperty tax 499Water and sewer 2,059Sales tax 1,789Court, permits and other 1,336AprProperty tax 385Water and sewer 2,179Sales tax 1,747Court, permits and other 1,248MayProperty tax 302Water and sewer 2,319Sales tax 1,711Court, permits and other 1,201JunProperty tax 270Water and sewer 2,449Sales tax 1,773Court, permits and other 1,139JulProperty tax 229Water and sewer 2,413Sales tax 1,830Court, permits and other 1,253AugProperty tax 31.2Water and sewer 406Sales tax 0Court, permits and other 208Sep
Table view
MonthProperty taxWater and sewerSales taxCourt, permits and other
Oct1,0922,0851,6541,232
Nov3,3281,9341,5701,149
Dec9,7761,8621,7731,336
Jan12,5321,8152,0071,295
Feb2,7041,7891,7211,326
Mar9361,9291,6541,513
Apr4992,0591,7891,336
May3852,1791,7471,248
Jun3022,3191,7111,201
Jul2702,4491,7731,139
Aug2292,4131,8301,253
Sep31.24060208
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
Grant money spent and reimbursedThousands of dollars. The city fronts the cash and claims it back — the gap between the two bars is the city's own money floating somebody else's project.
  • Spent
  • Reimbursed
$0$1,000$2,000$3,000Spent 1,236Reimbursed 0OctSpent 1,164Reimbursed 1,188NovSpent 1,812Reimbursed 1,203DecSpent 1,023Reimbursed 1,764JanSpent 1,764Reimbursed 906FebSpent 2,136Reimbursed 1,830MarSpent 2,004Reimbursed 2,064AprSpent 2,223Reimbursed 2,106MaySpent 2,406Reimbursed 2,232JunSpent 2,082Reimbursed 2,436JulSpent 1,854Reimbursed 1,920AugSpent 288Reimbursed 0Sep
Table view
MonthSpentReimbursed
Oct1,2360
Nov1,1641,188
Dec1,8121,203
Jan1,0231,764
Feb1,764906
Mar2,1361,830
Apr2,0042,064
May2,2232,106
Jun2,4062,232
Jul2,0822,436
Aug1,8541,920
Sep2880
Grant spending still waiting on reimbursementThousands of dollars, cumulative. The policy ceiling is $2,400,000; the balance has been above it since February.
  • Unreimbursed
  • Policy ceiling
$0$1,000$2,000$3,000$4,000OctNovDecJanFebMarAprMayJunJulAugSepUnreimbursedPolicy ceiling3,0572,040$ thousands
Table view
MonthUnreimbursedPolicy ceiling
Oct1,8022,040
Nov1,7752,040
Dec2,4652,040
Jan1,6252,040
Feb2,5982,040
Mar2,9442,040
Apr2,8762,040
May3,0092,040
Jun3,2062,040
Jul2,8052,040
Aug2,7302,040
Sep3,0572,040