A demonstration. This is not the city's website. It is a working proposal for the City of San Juan, built with the city's real seal, officials and departments. 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.

Public Works and Maintenance

Fleet, GPS and maintenance

Where the city's 186 vehicles are, what they are doing, and which ones are about to strand somebody. Positions are demonstration data; the streets, City Hall, the library, the cemetery and the airport are where they actually are.

  • 186Vehicles
  • 11Out of service
  • 89%Service on time
  • $0.44Cost per mile
9
On the road now
2
Stopped, running
3
On site
1
No signal
  • Moving
  • Stopped, engine running
  • On site
  • In the yard
  • No signal
  • City facility

Map data © OpenStreetMap contributors, served by OpenFreeMap. Drawn by MapLibre GL, which is served from this site — no third-party script runs on this page, and no position is sent anywhere.

Every unit, as text

The map is an enhancement. This table is the record, and it is what a screen reader, a printout and a budget hearing get.

Every tracked unit at the demonstration clock, with the position the map draws it at.
UnitDepartmentWhereStateSpeedHeadingPositionLast signal
PD-12PoliceExpressway 83 at N Nebraska AveMoving41 mphEast26.2021, -98.15481 min
PD-19PoliceSioux Rd at N Raul Longoria RdMoving34 mphSouth26.2145, -98.15391 min
PD-24PoliceVirgen de San Juan Blvd at the shrine approachStopped, engine running26.1968, -98.15663 min
FD-01FireCity Hall, 512 S Nebraska AveOn site26.1893, -98.15561 min
FD-04FireSioux Rd at N Nebraska AveMoving46 mphNorthwest26.2145, -98.15481 min
PW-08Public WorksS Standard Ave at the library blockStopped, engine running26.1846, -98.15912 min
PW-15Public WorksW Nolana Loop, brush route Zone BMoving17 mphWest26.2304, -98.15912 min
PW-22Public WorksS Standard Ave reconstructionOn site26.1874, -98.15911 min
SA-06SanitationSioux Rd at S Standard Ave, route 3Moving11 mphEast26.2145, -98.15911 min
SA-11SanitationW Owassa Rd at N Nebraska AveMoving29 mphSouth26.2448, -98.15482 min
UT-04UtilitiesN Nebraska Ave, meter route northMoving13 mphNorth26.1983, -98.15401 min
UT-09UtilitiesCity service yardIn the yard26.1893, -98.15394 min
UT-17UtilitiesCesar Chavez Rd, main breakOn site26.1631, -98.13891 min
PK-03Parks & Recreation610 Sioux Rd groundsMoving6 mphSoutheast26.2138, -98.14232 min
PZ-02Planning & ZoningW Expressway 83 at S Standard AveMoving24 mphWest26.2021, -98.15951 min
PW-31Public WorksNorth of Owassa Rd, past the canalNo signal26.2448, -98.142341 min

Needs attention this morning

  • PD-131 — the state inspection expired six days ago

    A Texas safety inspection lapsed on 31 August. The unit is out on assignment and it should not be: this is the one failure on this screen that is a legal exposure and not a cost. It is also the cheapest thing here to fix.

    Pull it off the road Book the inspection today

  • PW-21 — brake inspection 3,100 miles past due, and it is out working

    A 2013 dump truck idling at the Public Works yard right now. Whichever trigger comes first wins — miles, engine hours or the calendar — and this one passed the mileage trigger in July.

    Call it in now

  • PW-52 — no signal for 38 minutes, north of Mile 10

    It is not lost. It is past the canal where there are no bars, and the recorder in the cab is logging every second of it. The track uploads when it comes back into coverage; the map sits at the last confirmed fix rather than guessing.

    Flag it at the yard

The service queue — whichever trigger comes first wins

Miles, engine hours, or the calendar. Four of these were going to be found the hard way: on the shoulder of Expressway 83 in September, by a crew that then needs a ride back.

Unit Service Due at Current reading Remaining Status
PW-08Brake inspection150,000 mi152,600 mi−2,600 miOverdue — out working now
UT-09Vacuum blower service6,000 hr6,120 hr−120 hrOverdue — waiting on parts
PD-24Texas state safety inspection31 Aug 2026−7 daysExpired — cannot legally be driven
FD-01Annual pump test, NFPA 191130 Sep 202623 daysDue soon
PW-22Hydraulic service4,500 hr4,481 hr19 hrDue — catch it at the yard
FD-04Chassis and module inspection110,000 mi107,100 mi2,900 miDue soon
SA-06Hydraulic and packer service5,200 hr5,140 hr60 hrDue soon
PK-03Mower deck and blades3,200 hr3,148 hr52 hrDue soon — peak season
PZ-02Oil and filter45,000 mi41,900 mi3,100 miNot due

Demonstration data

The campuses, the trustees and the seal are real. Every enrollment figure, bus position, vote and dollar amount on this site is invented, and each page that shows one says so.