Create pac-man points at 75-foot intervals along all roads for an organization
Pac-Man Points Generation
Creates points every 75 feet along road geometries for data/photo capture intervals.
-- Choose an organization --
Loading...
Organization Details
Name:
ID:
Roads Found:0
Existing Pac-Man Points:0
How it works:
Points are placed every 75 feet along each road's geometry
Uses the actual road segment locations (already offset from centerlines)
COG (Course Over Ground) will be calculated later - set to NULL for now
Points mark intervals where data/photos can be captured
Optional: Generate for Multiple Environments
Leave all unchecked to generate for current environment only
⚠️ Important: Each environment uses its OWN roads from its OWN database.
DEV roads → DEV points, UAT roads → UAT points, etc.
Configuration
Shapefile method groups roads by centerline side for seamless point distribution. Walking ensures perfectly even spacing.
Distance between pac-man points along roads
Minimum distance required after last point to prevent clustering at road segment ends
⚠️ Caution: For large clients with 10,000-20,000+ pacman points, it's recommended to disable the preview to avoid performance issues.
A solution for better preview handling is currently being worked on.
📊 Generation Preview
0 Pac-Man Points
will be generated and inserted into the database
Roads Processed:0
Interval:75 ft
⚠️ Ready to Generate: Click "Confirm & Replace All Points" to proceed with generating the pac-man points.
This will replace all existing pac-man points for this organization.
🔍 Comparison View: New Preview vs. Database
⚠️ Preview Mode: Compare the new pac-man points (left) with existing database points (right).
Click "Confirm & Replace All Points" to replace all existing pac-man points with the new ones.
New Preview Points
Existing Database Points
Combined View
New Preview
Existing Database
New Preview Stats
Points
0
Roads
0
Interval
22.9 m
Avg COG
-
Existing Database Stats
Points
0
Avg COG
-
Uploaded
-
🆕 New Preview (Fullscreen)
💾 Existing Database (Fullscreen)
🔧 Backfill Pac-Man Road IDs
Fix orphaned Pac-Man points by associating them with nearby roads using spatial matching
⚠️ ACCESS RESTRICTED
This tool ONLY works in PROD environment.
Current environment:
Please switch to PROD using the environment selector at the top of the page.
✅ Connected to PROD Environment - Ready for production updates
Step 1: Select Organization
Select Organization
Loading...
Step 2: Review Statistics
Total Pac-Man Points
-
Points with Road ID
-
Orphaned Points
-
Orphaned Points Map (Missing Road IDs)
50 ftSet to 200ft+ to capture all matches (Pac-Man points are 75ft apart)500 ft
Step 3: Review Results
✅ Dry Run Complete
Total Orphaned Points
-
Successfully Matched
-
-
🟢 High Confidence (<50ft)
-
✅ Will Update
🟡 Medium Confidence (50-200ft)
-
✅ Will Update
🔴 Low Confidence (>200ft)
-
❌ Will Not Update
Matched Points & Roads Preview
Points: 🟢 Very Close Match (<50ft) | 🟡 Good Match (50-200ft) | 🔴 Distant Match (>200ft)
Roads: 🔵 Roads with Pac-Man matches | ⚪ All roads in the system
💡 Pac-Man points are spaced 75ft apart along roads. Set tolerance to 200ft+ to capture all matches.
✅ SUCCESS!
-
Summary
-
Pac-Man points updated with road IDs
These points should now appear as ACTIVE in the platform!
Database Sync
Synchronize organizations from PROD to DEV and UAT environments
Production Environment Required
This feature is only available when connected to the PRODUCTION environment.
Syncs organizations from PROD → DEV and PROD → UAT to maintain consistency across environments.
Feature Unavailable
You are currently in environment.
Please switch to PRODUCTION environment to use the database sync feature.
How Database Sync Works
1Preview shows which organizations exist in PROD but not in DEV/UAT
2Validation checks for duplicate organizations (same ID, different slug)
3Execute creates missing organizations while skipping existing ones
4Note: Only organization records are synced (not shapefiles, roads, or related data)
Sync Results
⚠️ Duplicate Organization Conflicts Detected
The following organizations have matching IDs but different slugs. This usually means a test organization in DEV/UAT is using the same ID as a real client in PROD.
⛔ Sync is blocked until these conflicts are resolved. Please delete the duplicate organizations from DEV/UAT before syncing.
Organizations Synced to DEV
Organizations Synced to UAT
Already Existing (Skipped)
Create Roads
Generate road segments from shapefiles
Road Generation
All shapefiles for the selected organization will be used to generate road segments.
Organization Details
Name:
ID:
Shapefiles Found:0
Existing Roads:0
Generation Method
Length of each road segment in meters
Edit Shapefile Attributes
Modify shapefile attributes without re-uploading files
Shapefile Attribute Editor
Update road attributes like width, surface material, depth, and more. Changes are applied immediately to the database.
-- Choose an organization --
Loading...
Selected:0/ 3,000 max
|
Update Shapefile Mappings
Upload a new shapefile to update existing database records with new column mappings. Records are matched by position (ordered by ID).
-- Choose an organization --
Loading...
Available columns in your shapefile:
Select which shapefile columns to map to database fields:
Audit Logs
Track all user activities and system changes
Time
User
Action
Env
Organization
Status
Details
Showing 0-0 of 0 logs
Client Onboarding
1
Select Organization
2
Upload Shapefiles
3
Configure Mappings
4
Onboard Shapefiles
5
Map Preview
6
Onboard Roads
7
Pac-Man Points
8
Generate Lanes
Select Organization
Choose the organization to onboard shapefiles for.
-- Select an organization --
Loading...
Organization Details
Name
ID
Existing Shapefiles
Select Target Environments
ℹ️ Select one or more environments to upload simultaneously. Each environment is processed independently with full transaction safety.
⚠️ Important: This assumes the organization exists in the selected environments. Each environment is processed in parallel with isolated database connections.
Upload Shapefile
Upload a ZIP file containing the shapefile components (.shp, .shx, .dbf, .prj).
✓ File selected:
Configure Column Mappings
Map shapefile columns to database fields. Leave empty for defaults.
Preview (10 rows)
Loading preview...
Shapefile Type
Select the type of shapefile you're uploading. This will show relevant mapping fields.
Detected:
Column Mapping
Select a column from your shapefile for each field, or leave empty for defaults.
Map to column OR enter custom value (e.g., 26, 27)
Map to column OR enter custom value (e.g., 2, 3)
District Boundaries - Automatic Processing
For district shapefiles, only the geometry (polygon boundaries) is extracted and stored. No column mapping is required.
Shapefile Type: Will be set to district
Geometry: Polygon boundaries will be extracted and stored as LineStrings
Attributes: All attributes will be ignored (districts only need boundaries)
Note: District boundaries will be displayed as outlines (not filled polygons) when queried from the database.
Review & Onboard
Review your selections and start the onboarding process.
Environment
Organization
File
Preview Results
Map Preview
Interactive map showing uploaded road centerlines
📍 Map Controls:
• Zoom: Scroll wheel or +/- buttons
• Pan: Click and drag
• Click on a road line to see details
Load Roads
Create road segments from the onboarded shapefiles.
How it works: Each shapefile centerline is divided into segments of the specified length on both left and right sides, offset perpendicular to the centerline by the specified distance.
Example: A 160-foot centerline with 50-foot segments and 12-foot offset creates: 8 total segments (4 left: 50, 50, 50, 10 @ -12ft | 4 right: 50, 50, 50, 10 @ +12ft)
Configuration
Only for Segmented mode
Distance from centerline (left/right). Not used in OSM mode.
🗺️ Roads Preview
Interactive map showing road segments and original centerlines
📍 Map Legend:
• Blue lines: Original shapefile centerlines
• Red lines: Generated road segments
• Hover over any line to see details
Generate Pac-Man Points
Create pac-man points along the roads generated in the previous step.
Scoped generation: Only generating points for the 0 shapefiles uploaded in this session. Existing pac-man points will not be modified.
Configuration
Distance between pac-man points
Minimum distance from road ends
Generate Lanes
Generate road lanes from the segments onboarded in this session.
Scoped generation: Only generating lanes for the 0 shapefiles uploaded in this session.
Configuration
Clear Shapefiles
Remove all shapefile data for an organization
Warning: This action cannot be undone
This will permanently delete all shapefiles for the selected organization.
Confirmation Required
Organization:
Organization ID:
Shapefiles to Delete:
Clear Roads
Remove all road segments for an organization
Warning: This action cannot be undone
This will permanently delete all road segments for the selected organization. Shapefiles will not be affected.
Confirmation Required
Organization:
Organization ID:
Road Segments to Delete:
View Roads
Visualize existing road segments and shapefiles for any organization
Testing & Visualization
Select an organization to view their road segments and original shapefile centerlines on an interactive map.
Organization Details
Name:
ID:
Shapefiles:0
Road Segments:0
Map Style
Layers
Yellow = within 50 m & COG OK. Red = too far or heading mismatch.
🛣️ Road Segment
📍 Selected Shapefiles (0)
-- Choose an organization --
Loading...
0 shapefiles loaded
—
Shapefile ID
Length
Surface Material
Road FillerAUTO
Detects shapefiles with missing road segments and lets you fill them in automatically.
Select an organization and click Scan.
Loading... for 0 seconds
Generate Lanes
Merge road segments into left/right lanes per shapefile for streamlined navigation
Lane Generation
Merges all road segments on each side of a shapefile centerline into 2 lanes (left + right). Updates road records with lane associations.
-- Choose an organization --
Loading...
Organization
ID:
Shapefiles
0
Roads
0
Existing Lanes
0
Options
Map Layers
Lane
—
Pac-Man Point
—/—
—
Heading
—°
0 marked
PREVIEW
Lane Preview (0 lanes)
Shapefile
Road Name
Side
Roads Merged
Length (ft)
Preview
Road Coverage Audit
Clients whose shapefile centerlines have missing road segments
Loading…
Select a client to view coverage
shapefiles with gaps
Shapefiles with road coverage gaps
Loading map…
Organization creation is only available in the PROD environment. Switch to PROD to create new organizations.