[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_305":306,"_307":308},"routes/_app.x.$handle.$name",{"_95":94,"_32":45,"_103":85,"_27":104,"_13":14,"_105":-5,"_11":106,"_107":108,"_109":110,"_111":112,"_113":114,"_20":-5,"_115":-5,"_116":-5,"_117":25,"_118":119,"_120":58,"_121":-5,"_122":-5,"_123":124},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":58,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":79,"_80":81,"_82":83,"_84":25},"version",38,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":20,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":33,"_34":20,"_35":36},"deleted",false,"deletedHere","path","frontend/index.html","latestPath","fileId","d621bb30-3f90-11f0-97f8-76b3cceeab13","name","index.html","fileType","content","\n\n \n \n \n Crime Reporting App\n \n \n\n \n \n\n \n \n\n \n \n \n

\n\n \n \n","\n\n \n \n \n Crime Reporting App\n \n \n\n \n \n\n \n \n\n \n \n \n

\n\n \n \n","createdAt",["D",1748860097197],"branchVersion","branchId","966b2f30-3f90-11f0-800c-76b3cceeab13","id","966ac248-3f90-11f0-800c-76b3cceeab13","CrimeMap",["D",1748855067988],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","238dc720-3f90-11f0-ad5b-814c56c8abb0","pinnedFileId","cfe50056-3f90-11f0-905d-76b3cceeab13","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","74213d8f-b268-4ac6-b09e-69eb86e44175","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_95":94,"_102":98},"org",{"_95":94,"_96":-5,"_97":98,"_18":54,"_99":100,"_101":25},"branch",{"_13":14,"_32":85,"_43":42,"_86":44,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":45,"_93":94},"isOwned","main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","realcoder","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ4d2g1a0xNT0I4U3dPaFhiU0k2dHdsMDM5RiJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":301,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":58,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":302,"_80":303,"_82":304,"_84":25},"tree",[168,176,183,185],"files",[168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185],"counts",{"_158":62,"_159":133,"_160":62,"_161":162,"_163":164},"contents",[125,126,127,128],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":152,"_32":153,"_30":154,"_132":-5,"_41":42,"_40":155,"_134":58,"_38":156,"_13":62,"_34":144,"_35":-5,"_24":25,"_137":-5,"_27":157},{"_43":146,"_32":147,"_30":148,"_132":-5,"_41":42,"_40":149,"_134":58,"_38":150,"_13":62,"_34":144,"_35":-5,"_24":25,"_137":-5,"_27":151},{"_43":139,"_32":140,"_30":141,"_132":-5,"_41":42,"_40":142,"_134":58,"_38":143,"_13":62,"_34":144,"_35":-5,"_24":25,"_137":-5,"_27":145},{"_43":129,"_32":130,"_30":131,"_132":-5,"_41":42,"_40":133,"_134":58,"_38":135,"_13":62,"_34":20,"_35":136,"_24":25,"_137":-5,"_27":138},"ae8f1536-3f90-11f0-a60d-76b3cceeab13","README.md","ae8f15f4-3f90-11f0-a60d-76b3cceeab13","parentId",1,"latest",["D",1748855108486],"# Crime Reporting App\n\nA web application that allows users to report crimes in their local area using an interactive map.\n\n## Features\n\n- Interactive map interface for selecting crime location\n- Crime type categorization\n- Anonymous reporting option\n- Real-time crime report viewing\n- Location-based crime filtering\n\n## Project Structure\n\n```\n├── backend/\n│ ├── database/\n│ │ ├── migrations.ts # Database schema setup\n│ │ └── queries.ts # Database query functions\n│ ├── routes/\n│ │ ├── reports.ts # Crime report API endpoints\n│ │ └── static.ts # Static file serving\n│ └── index.ts # Main Hono server\n├── frontend/\n│ ├── components/\n│ │ ├── App.tsx # Main React component\n│ │ ├── CrimeMap.tsx # Interactive map component\n│ │ └── ReportForm.tsx # Crime reporting form\n│ ├── index.html # Main HTML template\n│ ├── index.tsx # Frontend entry point\n│ └── style.css # Custom styles\n├── shared/\n│ └── types.ts # Shared TypeScript types\n└── README.md\n```\n\n## Technology Stack\n\n- **Backend**: Hono (TypeScript API framework)\n- **Database**: SQLite\n- **Frontend**: React with TypeScript\n- **Map**: Leaflet.js\n- **Styling**: TailwindCSS\n\n## API Endpoints\n\n- `GET /api/reports` - Get all crime reports (with optional location filtering)\n- `POST /api/reports` - Submit a new crime report\n- `GET /api/reports/stats` - Get crime statistics by type and area\n\n## Database Schema\n\n### Reports Table\n- `id` - Primary key\n- `crime_type` - Type of crime reported\n- `description` - Detailed description\n- `latitude` - Location latitude\n- `longitude` - Location longitude\n- `address` - Human-readable address\n- `reporter_name` - Reporter name (optional for anonymous reports)\n- `reporter_contact` - Contact information (optional)\n- `is_anonymous` - Boolean flag for anonymous reports\n- `status` - Report status (pending, reviewed, resolved)\n- `created_at` - Timestamp of report creation\n\n## Usage\n\n1. Open the application in your browser\n2. Click on the map to select the crime location\n3. Fill out the crime report form\n4. Submit the report\n5. View existing reports on the map\n\n## Development\n\nThe app automatically serves static files and provides a REST API for crime reports. The database is initialized on first run.","label",[130],"b1debaac-3f90-11f0-984b-76b3cceeab13","shared","57859476-c566-4eb2-bf20-f0d0fb46d05d",2,["D",1748855114039],"directory",[140],"d621da48-3f90-11f0-97f8-76b3cceeab13","frontend","4d66147a-eecb-4262-b628-9610fbc28f8c",8,["D",1748855174870],[147],"b5b31b82-3f90-11f0-9402-76b3cceeab13","backend","be447c83-12c1-4506-935a-fc03bdaf890b",3,["D",1748855120462],[153],"pulls","branches","forks","envVars",{"_165":62,"_167":62},"connections",{"_165":62,"_166":62},"count","unfilledCount","emptyCount",{"_43":152,"_32":153,"_30":154,"_132":-5,"_41":42,"_40":155,"_134":58,"_38":298,"_13":62,"_34":144,"_35":-5,"_24":25,"_137":-5,"_187":299,"_27":300},{"_43":294,"_32":286,"_30":280,"_132":154,"_41":42,"_40":155,"_134":58,"_38":295,"_13":62,"_34":144,"_35":-5,"_24":25,"_137":-5,"_187":296,"_27":297},{"_43":287,"_32":288,"_30":289,"_132":280,"_41":42,"_40":155,"_134":58,"_38":290,"_13":62,"_34":194,"_35":291,"_24":25,"_137":-5,"_187":292,"_27":293},{"_43":277,"_32":278,"_30":279,"_132":280,"_41":42,"_40":281,"_134":58,"_38":282,"_13":62,"_34":194,"_35":283,"_24":25,"_137":-5,"_187":284,"_27":285},{"_43":273,"_32":264,"_30":258,"_132":154,"_41":42,"_40":268,"_134":58,"_38":274,"_13":62,"_34":144,"_35":-5,"_24":25,"_137":-5,"_187":275,"_27":276},{"_43":265,"_32":266,"_30":267,"_132":258,"_41":42,"_40":268,"_134":58,"_38":269,"_13":62,"_34":194,"_35":270,"_24":25,"_137":-5,"_187":271,"_27":272},{"_43":255,"_32":256,"_30":257,"_132":258,"_41":42,"_40":259,"_134":58,"_38":260,"_13":62,"_34":194,"_35":261,"_24":25,"_137":-5,"_187":262,"_27":263},{"_43":247,"_32":248,"_30":56,"_132":154,"_41":42,"_40":249,"_134":58,"_38":250,"_13":133,"_34":251,"_35":252,"_24":25,"_137":-5,"_187":253,"_27":254},{"_43":146,"_32":147,"_30":148,"_132":-5,"_41":42,"_40":149,"_134":58,"_38":244,"_13":62,"_34":144,"_35":-5,"_24":25,"_137":-5,"_187":245,"_27":246},{"_43":240,"_32":222,"_30":216,"_132":148,"_41":42,"_40":235,"_134":58,"_38":241,"_13":62,"_34":144,"_35":-5,"_24":25,"_137":-5,"_187":242,"_27":243},{"_43":232,"_32":233,"_30":234,"_132":216,"_41":42,"_40":235,"_134":58,"_38":236,"_13":62,"_34":194,"_35":237,"_24":25,"_137":-5,"_187":238,"_27":239},{"_43":223,"_32":224,"_30":225,"_132":216,"_41":42,"_40":226,"_134":58,"_38":227,"_13":228,"_34":194,"_35":229,"_24":25,"_137":-5,"_187":230,"_27":231},{"_43":213,"_32":214,"_30":215,"_132":216,"_41":42,"_40":217,"_134":58,"_38":218,"_13":149,"_34":194,"_35":219,"_24":25,"_137":-5,"_187":220,"_27":221},{"_43":209,"_32":33,"_30":31,"_132":148,"_41":42,"_40":14,"_134":58,"_38":210,"_13":142,"_34":20,"_35":37,"_24":25,"_137":-5,"_187":211,"_27":212},{"_43":201,"_32":202,"_30":203,"_132":148,"_41":42,"_40":204,"_134":58,"_38":205,"_13":62,"_34":194,"_35":206,"_24":25,"_137":-5,"_187":207,"_27":208},{"_43":139,"_32":140,"_30":141,"_132":-5,"_41":42,"_40":142,"_134":58,"_38":198,"_13":62,"_34":144,"_35":-5,"_24":25,"_137":-5,"_187":199,"_27":200},{"_43":190,"_32":191,"_30":192,"_132":141,"_41":42,"_40":142,"_134":58,"_38":193,"_13":62,"_34":194,"_35":195,"_24":25,"_137":-5,"_187":196,"_27":197},{"_43":129,"_32":130,"_30":131,"_132":-5,"_41":42,"_40":133,"_134":58,"_38":186,"_13":62,"_34":20,"_35":136,"_24":25,"_137":-5,"_187":188,"_27":189},["D",1748855108486],"children",[],[130],"b1deb2d2-3f90-11f0-984b-76b3cceeab13","types.ts","b1deb3a4-3f90-11f0-984b-76b3cceeab13",["D",1748855114039],"script","// Shared types for the crime reporting app\n\nexport interface CrimeReport {\n id?: number;\n crime_type: string;\n description: string;\n latitude: number;\n longitude: number;\n address?: string;\n reporter_name?: string;\n reporter_contact?: string;\n is_anonymous: boolean;\n status: 'pending' | 'reviewed' | 'resolved';\n created_at?: string;\n}\n\nexport interface CrimeStats {\n crime_type: string;\n count: number;\n}\n\nexport interface LocationFilter {\n lat: number;\n lng: number;\n radius: number; // in kilometers\n}\n\nexport const CRIME_TYPES = [\n 'Theft',\n 'Burglary',\n 'Assault',\n 'Vandalism',\n 'Drug-related',\n 'Vehicle Crime',\n 'Fraud',\n 'Domestic Violence',\n 'Public Disorder',\n 'Other'\n] as const;\n\nexport type CrimeType = typeof CRIME_TYPES[number];",[],[140,191],["D",1748855114039],[184],[140],"d954d454-3f90-11f0-8559-76b3cceeab13","index.tsx","d954d508-3f90-11f0-8559-76b3cceeab13",9,["D",1748855180246],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client?deps=react@18.2.0,react-dom@18.2.0\";\nimport App from \"./components/App.tsx\";\n\nconst root = createRoot(document.getElementById(\"root\")!);\nroot.render();",[],[147,202],"4c0fff7c-3f9c-11f0-b1ba-76b3cceeab13",["D",1748860097197],[],[147,33],"a3ded09e-3f9b-11f0-bbad-76b3cceeab13","ReportForm.tsx","08dd17d6-3f91-11f0-825c-76b3cceeab13","b4050c00-2af5-4c47-853b-b480158d8ce5",34,["D",1748859815015],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport { CRIME_TYPES } from \"../../shared/types.ts\";\n\ninterface ReportFormProps {\n location: { lat: number; lng: number };\n onSubmit: (data: any) => void;\n onClose: () => void;\n}\n\nexport default function ReportForm({ location, onSubmit, onClose }: ReportFormProps) {\n const [formData, setFormData] = useState({\n crime_type: \"\",\n description: \"\",\n address: \"\",\n reporter_name: \"\",\n reporter_contact: \"\",\n is_anonymous: false,\n });\n\n const [isSubmitting, setIsSubmitting] = useState(false);\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n\n if (!formData.crime_type || !formData.description) {\n alert(\"Please fill in all required fields\");\n return;\n }\n\n setIsSubmitting(true);\n try {\n await onSubmit(formData);\n } finally {\n setIsSubmitting(false);\n }\n };\n\n const handleChange = (e: React.ChangeEvent) => {\n const { name, value, type } = e.target;\n setFormData(prev => ({\n ...prev,\n [name]: type === \"checkbox\" ? (e.target as HTMLInputElement).checked : value,\n }));\n };\n\n return (\n

Report a Crime

\n \n ×\n \n

\n\n

\n 📍 Location: {location.lat.toFixed(4)}, {location.lng.toFixed(4)}\n

\n\n

\n {/* Crime Type */}\n

\n \n Crime Type *\n \n \n \n {CRIME_TYPES.map(type => )}\n \n

\n\n {/* Description */}\n

\n \n Description *\n \n \n

\n\n {/* Address */}\n

\n \n Address (Optional)\n \n \n

\n\n {/* Anonymous Reporting */}\n

\n \n \n Submit anonymously\n \n

\n\n {/* Reporter Information (only if not anonymous) */}\n {!formData.is_anonymous && (\n <>\n

\n \n Your Name\n \n \n

\n\n

\n \n Contact Information\n \n \n

\n \n )}\n\n {/* Disclaimer */}\n

\n ⚠️ Important:{\" \"}\n This is not a substitute for emergency services. If you are in immediate danger, call 911 or your local\n emergency number.\n

\n\n {/* Submit Buttons */}\n

\n \n Cancel\n \n \n {isSubmitting ? \"Submitting...\" : \"Submit Report\"}\n \n

\n );\n}",[],[147,222,214],"components","ffebed5e-3f9b-11f0-9f02-76b3cceeab13","CrimeMap.tsx","f7ebfa3c-3f90-11f0-9d2c-76b3cceeab13",36,["D",1748859969451],15,"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useEffect, useRef } from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport type { CrimeReport } from \"../../shared/types.ts\";\n\ninterface CrimeMapProps {\n reports: CrimeReport[];\n selectedLocation: { lat: number; lng: number } | null;\n onLocationSelect: (lat: number, lng: number) => void;\n}\n\ndeclare global {\n interface Window {\n L: any;\n }\n}\n\nexport default function CrimeMap({ reports, selectedLocation, onLocationSelect }: CrimeMapProps) {\n const mapRef = useRef(null);\n const mapInstanceRef = useRef(null);\n const markersRef = useRef([]);\n const selectedMarkerRef = useRef(null);\n\n useEffect(() => {\n if (!mapRef.current || !window.L) return;\n\n // Initialize map\n const map = window.L.map(mapRef.current).setView([40.7128, -74.0060], 13);\n\n // Add tile layer\n window.L.tileLayer(\"https://{s}.tile.openstreetmap.org/{z}/{x}/{y}.png\", {\n attribution: \"© OpenStreetMap contributors\",\n }).addTo(map);\n\n // Try to get user's location\n if (navigator.geolocation) {\n navigator.geolocation.getCurrentPosition(\n (position) => {\n const { latitude, longitude } = position.coords;\n map.setView([latitude, longitude], 13);\n },\n (error) => {\n console.log(\"Geolocation error:\", error);\n // Keep default location\n },\n );\n }\n\n // Add click handler for location selection\n map.on(\"click\", (e: any) => {\n const { lat, lng } = e.latlng;\n onLocationSelect(lat, lng);\n });\n\n mapInstanceRef.current = map;\n\n return () => {\n map.remove();\n };\n }, [onLocationSelect]);\n\n // Update crime report markers\n useEffect(() => {\n if (!mapInstanceRef.current) return;\n\n // Clear existing markers\n markersRef.current.forEach(marker => {\n mapInstanceRef.current.removeLayer(marker);\n });\n markersRef.current = [];\n\n // Add markers for each crime report\n reports.forEach(report => {\n const crimeIcon = window.L.divIcon({\n className: \"crime-marker\",\n html: getCrimeEmoji(report.crime_type),\n iconSize: [20, 20],\n iconAnchor: [10, 10],\n });\n\n const marker = window.L.marker([report.latitude, report.longitude], {\n icon: crimeIcon,\n }).addTo(mapInstanceRef.current);\n\n // Add popup with crime details\n const popupContent = `\n

${report.crime_type}

${report.description}

Status: ${report.status}

Reported: ${new Date(report.created_at || \"\").toLocaleDateString()}

\n ${report.address ? `

Address: ${report.address}

` : \"\"}\n

\n `;\n\n marker.bindPopup(popupContent);\n markersRef.current.push(marker);\n });\n }, [reports]);\n\n // Update selected location marker\n useEffect(() => {\n if (!mapInstanceRef.current) return;\n\n // Remove existing selected marker\n if (selectedMarkerRef.current) {\n mapInstanceRef.current.removeLayer(selectedMarkerRef.current);\n selectedMarkerRef.current = null;\n }\n\n // Add new selected marker\n if (selectedLocation) {\n const selectedIcon = window.L.divIcon({\n className: \"selected-location-marker\",\n html: \"📍\",\n iconSize: [24, 24],\n iconAnchor: [12, 12],\n });\n\n selectedMarkerRef.current = window.L.marker([selectedLocation.lat, selectedLocation.lng], {\n icon: selectedIcon,\n }).addTo(mapInstanceRef.current);\n\n selectedMarkerRef.current.bindPopup(\"Selected location for crime report\").openPopup();\n }\n }, [selectedLocation]);\n\n return (\n

\n Crime Reports\n

\n Selected Location\n

\n );\n}\n\nfunction getCrimeEmoji(crimeType: string): string {\n const emojiMap: Record = {\n \"Theft\": \"💰\",\n \"Burglary\": \"🏠\",\n \"Assault\": \"👊\",\n \"Vandalism\": \"🔨\",\n \"Drug-related\": \"💊\",\n \"Vehicle Crime\": \"🚗\",\n \"Fraud\": \"💳\",\n \"Domestic Violence\": \"🏠\",\n \"Public Disorder\": \"📢\",\n \"Other\": \"⚠️\",\n };\n\n return emojiMap[crimeType] || \"⚠️\";\n}",[],[147,222,224],"ea73dce4-3f90-11f0-869e-76b3cceeab13","App.tsx","ea73ddb6-3f90-11f0-869e-76b3cceeab13",10,["D",1748855208970],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport CrimeMap from \"./CrimeMap.tsx\";\nimport ReportForm from \"./ReportForm.tsx\";\nimport type { CrimeReport } from \"../../shared/types.ts\";\n\nexport default function App() {\n const [reports, setReports] = useState([]);\n const [selectedLocation, setSelectedLocation] = useState<{lat: number, lng: number} | null>(null);\n const [showForm, setShowForm] = useState(false);\n const [loading, setLoading] = useState(true);\n const [error, setError] = useState(null);\n\n // Fetch crime reports\n const fetchReports = async () => {\n try {\n setLoading(true);\n const response = await fetch('/api/reports');\n if (!response.ok) {\n throw new Error('Failed to fetch reports');\n }\n const data = await response.json();\n setReports(data);\n } catch (err) {\n setError(err instanceof Error ? err.message : 'An error occurred');\n } finally {\n setLoading(false);\n }\n };\n\n useEffect(() => {\n fetchReports();\n }, []);\n\n const handleLocationSelect = (lat: number, lng: number) => {\n setSelectedLocation({ lat, lng });\n setShowForm(true);\n };\n\n const handleReportSubmit = async (reportData: any) => {\n try {\n const response = await fetch('/api/reports', {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json',\n },\n body: JSON.stringify({\n ...reportData,\n latitude: selectedLocation?.lat,\n longitude: selectedLocation?.lng,\n }),\n });\n\n if (!response.ok) {\n throw new Error('Failed to submit report');\n }\n\n // Refresh reports and close form\n await fetchReports();\n setShowForm(false);\n setSelectedLocation(null);\n alert('Crime report submitted successfully!');\n } catch (err) {\n alert('Failed to submit report: ' + (err instanceof Error ? err.message : 'Unknown error'));\n }\n };\n\n const handleCloseForm = () => {\n setShowForm(false);\n setSelectedLocation(null);\n };\n\n if (loading) {\n return (\n

Loading crime reports...

\n );\n }\n\n if (error) {\n return (\n

⚠️ Error

{error}

\n \n

\n );\n }\n\n return (\n

\n {/* Header */}\n

🚨 Crime Reporting

Report crimes in your local area

\n {reports.length} reports total\n

\n\n {/* Main Content */}\n

\n {/* Map Section */}\n

Crime Map

\n Click on the map to select a location and report a crime\n

\n \n

\n\n {/* Sidebar */}\n

\n {/* Instructions */}\n

How to Report

\n 1\n Click on the map where the crime occurred\n
\n 2\n Fill out the crime report form\n
\n 3\n Submit your report\n

\n\n {/* Recent Reports */}\n

Recent Reports

\n {reports.slice(0, 10).map((report) => (\n

\n {report.crime_type}\n \n {report.status}\n \n

{report.description}

\n {report.address || `${report.latitude.toFixed(4)}, ${report.longitude.toFixed(4)}`}\n

\n ))}\n

\n\n {/* Report Form Modal */}\n {showForm && selectedLocation && (\n \n )}\n

\n );\n}",[],[147,222,233],"ea73f2f6-3f90-11f0-869e-76b3cceeab13",["D",1748855208970],[178,179,180],[147,222],["D",1748855174870],[177,181,182],[147],"0aa7d48e-3f91-11f0-a354-76b3cceeab13","index.ts",13,["D",1748855262994],"http","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { initializeDatabase } from \"./database/migrations.ts\";\nimport reports from \"./routes/reports.ts\";\nimport staticRoutes from \"./routes/static.ts\";\n\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n throw err;\n});\n\n// Initialize database on startup\nawait initializeDatabase();\n\n// API routes\napp.route(\"/api/reports\", reports);\n\n// Static file serving and main page\napp.route(\"/\", staticRoutes);\n\n// Health check endpoint\napp.get(\"/health\", (c) => {\n return c.json({ status: \"healthy\", timestamp: new Date().toISOString() });\n});\n\n// 404 handler\napp.notFound((c) => {\n return c.json({ error: \"Not found\" }, 404);\n});\n\nexport default app.fetch; // This is the entry point for HTTP vals",[],[153,248],"cc1446a8-3f90-11f0-97f8-76b3cceeab13","static.ts","cc144784-3f90-11f0-97f8-76b3cceeab13","a038936b-2995-4d64-9846-4c2e9a03310f",6,["D",1748855158013],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\n\nconst staticRoutes = new Hono();\n\n// Serve frontend files\nstaticRoutes.get(\"/frontend/*\", (c) => serveFile(c.req.path, import.meta.url));\n\n// Serve shared files\nstaticRoutes.get(\"/shared/*\", (c) => serveFile(c.req.path, import.meta.url));\n\n// Serve the main page with initial data injection\nstaticRoutes.get(\"/\", async (c) => {\n try {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // You could inject initial data here if needed\n // const initialData = await fetchInitialData();\n // const dataScript = ``;\n // html = html.replace(\"\", `${dataScript}`);\n \n return c.html(html);\n } catch (error) {\n console.error(\"Error serving index:\", error);\n return c.text(\"Error loading page\", 500);\n }\n});\n\nexport default staticRoutes;",[],[153,264,256],"routes","c79f4b40-3f90-11f0-a2ca-76b3cceeab13","reports.ts","c79f4bf4-3f90-11f0-a2ca-76b3cceeab13",5,["D",1748855150532],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport type { CrimeReport, LocationFilter } from \"../../shared/types.ts\";\nimport {\n createCrimeReport,\n getAllCrimeReports,\n getCrimeReportsInArea,\n getCrimeStats,\n updateReportStatus\n} from \"../database/queries.ts\";\n\nconst reports = new Hono();\n\n// Get all crime reports or filter by location\nreports.get(\"/\", async (c) => {\n try {\n const lat = c.req.query(\"lat\");\n const lng = c.req.query(\"lng\");\n const radius = c.req.query(\"radius\");\n\n if (lat && lng && radius) {\n const filter: LocationFilter = {\n lat: parseFloat(lat),\n lng: parseFloat(lng),\n radius: parseFloat(radius)\n };\n const reports = await getCrimeReportsInArea(filter);\n return c.json(reports);\n } else {\n const reports = await getAllCrimeReports();\n return c.json(reports);\n }\n } catch (error) {\n console.error(\"Error fetching reports:\", error);\n return c.json({ error: \"Failed to fetch reports\" }, 500);\n }\n});\n\n// Create a new crime report\nreports.post(\"/\", async (c) => {\n try {\n const body = await c.req.json();\n \n // Validate required fields\n if (!body.crime_type || !body.description || !body.latitude || !body.longitude) {\n return c.json({ error: \"Missing required fields\" }, 400);\n }\n\n const report: Omit = {\n crime_type: body.crime_type,\n description: body.description,\n latitude: parseFloat(body.latitude),\n longitude: parseFloat(body.longitude),\n address: body.address,\n reporter_name: body.is_anonymous ? undefined : body.reporter_name,\n reporter_contact: body.is_anonymous ? undefined : body.reporter_contact,\n is_anonymous: Boolean(body.is_anonymous),\n status: 'pending'\n };\n\n const reportId = await createCrimeReport(report);\n \n return c.json({ \n success: true, \n id: reportId,\n message: \"Crime report submitted successfully\" \n }, 201);\n } catch (error) {\n console.error(\"Error creating report:\", error);\n return c.json({ error: \"Failed to create report\" }, 500);\n }\n});\n\n// Get crime statistics\nreports.get(\"/stats\", async (c) => {\n try {\n const stats = await getCrimeStats();\n return c.json(stats);\n } catch (error) {\n console.error(\"Error fetching stats:\", error);\n return c.json({ error: \"Failed to fetch statistics\" }, 500);\n }\n});\n\n// Update report status (for admin use)\nreports.patch(\"/:id/status\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n const { status } = await c.req.json();\n \n if (![\"pending\", \"reviewed\", \"resolved\"].includes(status)) {\n return c.json({ error: \"Invalid status\" }, 400);\n }\n\n await updateReportStatus(id, status);\n return c.json({ success: true, message: \"Status updated successfully\" });\n } catch (error) {\n console.error(\"Error updating status:\", error);\n return c.json({ error: \"Failed to update status\" }, 500);\n }\n});\n\nexport default reports;",[],[153,264,266],"c79f5cb6-3f90-11f0-a2ca-76b3cceeab13",["D",1748855150532],[173,174],[153,264],"bed7cc1c-3f90-11f0-a015-76b3cceeab13","queries.ts","bed7ccee-3f90-11f0-a015-76b3cceeab13","9bf6003d-1533-429a-9316-8d78481b2677",4,["D",1748855135807],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { TABLE_NAME } from \"./migrations.ts\";\nimport type { CrimeReport, CrimeStats, LocationFilter } from \"../../shared/types.ts\";\n\nexport async function createCrimeReport(report: Omit): Promise {\n const result = await sqlite.execute(`\n INSERT INTO ${TABLE_NAME} (\n crime_type, description, latitude, longitude, address,\n reporter_name, reporter_contact, is_anonymous, status\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)\n `, [\n report.crime_type,\n report.description,\n report.latitude,\n report.longitude,\n report.address || null,\n report.reporter_name || null,\n report.reporter_contact || null,\n report.is_anonymous ? 1 : 0,\n report.status\n ]);\n\n return result.lastInsertRowId as number;\n}\n\nexport async function getAllCrimeReports(): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM ${TABLE_NAME} \n ORDER BY created_at DESC\n `);\n\n return result.rows.map(row => ({\n id: row[0] as number,\n crime_type: row[1] as string,\n description: row[2] as string,\n latitude: row[3] as number,\n longitude: row[4] as number,\n address: row[5] as string || undefined,\n reporter_name: row[6] as string || undefined,\n reporter_contact: row[7] as string || undefined,\n is_anonymous: Boolean(row[8]),\n status: row[9] as 'pending' | 'reviewed' | 'resolved',\n created_at: row[10] as string\n }));\n}\n\nexport async function getCrimeReportsInArea(filter: LocationFilter): Promise {\n // Simple bounding box query (for more accuracy, you'd use proper geospatial functions)\n const latDelta = filter.radius / 111; // Rough conversion: 1 degree ≈ 111 km\n const lngDelta = filter.radius / (111 * Math.cos(filter.lat * Math.PI / 180));\n\n const result = await sqlite.execute(`\n SELECT * FROM ${TABLE_NAME} \n WHERE latitude BETWEEN ? AND ?\n AND longitude BETWEEN ? AND ?\n ORDER BY created_at DESC\n `, [\n filter.lat - latDelta,\n filter.lat + latDelta,\n filter.lng - lngDelta,\n filter.lng + lngDelta\n ]);\n\n return result.rows.map(row => ({\n id: row[0] as number,\n crime_type: row[1] as string,\n description: row[2] as string,\n latitude: row[3] as number,\n longitude: row[4] as number,\n address: row[5] as string || undefined,\n reporter_name: row[6] as string || undefined,\n reporter_contact: row[7] as string || undefined,\n is_anonymous: Boolean(row[8]),\n status: row[9] as 'pending' | 'reviewed' | 'resolved',\n created_at: row[10] as string\n }));\n}\n\nexport async function getCrimeStats(): Promise {\n const result = await sqlite.execute(`\n SELECT crime_type, COUNT(*) as count\n FROM ${TABLE_NAME}\n GROUP BY crime_type\n ORDER BY count DESC\n `);\n\n return result.rows.map(row => ({\n crime_type: row[0] as string,\n count: row[1] as number\n }));\n}\n\nexport async function updateReportStatus(id: number, status: 'pending' | 'reviewed' | 'resolved'): Promise {\n await sqlite.execute(`\n UPDATE ${TABLE_NAME} \n SET status = ? \n WHERE id = ?\n `, [status, id]);\n}",[],[153,286,278],"database","b5b315f6-3f90-11f0-9402-76b3cceeab13","migrations.ts","b5b316dc-3f90-11f0-9402-76b3cceeab13",["D",1748855120462],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nconst TABLE_NAME = 'crime_reports_v1';\n\nexport async function initializeDatabase() {\n console.log('Initializing database...');\n \n // Create the crime reports table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n crime_type TEXT NOT NULL,\n description TEXT NOT NULL,\n latitude REAL NOT NULL,\n longitude REAL NOT NULL,\n address TEXT,\n reporter_name TEXT,\n reporter_contact TEXT,\n is_anonymous BOOLEAN NOT NULL DEFAULT 0,\n status TEXT NOT NULL DEFAULT 'pending',\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Create index for location-based queries\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_crime_reports_location \n ON ${TABLE_NAME} (latitude, longitude)\n `);\n\n // Create index for crime type queries\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_crime_reports_type \n ON ${TABLE_NAME} (crime_type)\n `);\n\n console.log('Database initialized successfully');\n}\n\nexport { TABLE_NAME };",[],[153,286,288],"b5b31d80-3f90-11f0-9402-76b3cceeab13",["D",1748855120462],[170,171],[153,286],["D",1748855120462],[169,172,175],[153],["D",1748855067988],{"_95":94,"_102":98},{"_95":94,"_96":-5,"_97":98,"_18":54,"_99":100,"_101":25},{"_13":14,"_32":85,"_43":42,"_86":44,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":45,"_93":94},"ctx",{"_78":-5,"_122":338,"_339":340,"_341":342,"_343":25,"_344":25,"_345":25,"_346":58,"_347":-5,"_348":-7,"_349":-7,"_350":62,"_351":25,"_352":25,"_353":-5,"_354":25,"_355":25,"_356":25,"_357":-5},"ENV",{"_309":310,"_311":312,"_313":85,"_314":315,"_316":317,"_318":319,"_320":321,"_322":323,"_324":325,"_326":327,"_328":329,"_330":331,"_332":333,"_334":335,"_336":337},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v38