[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_361":362,"_363":364},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_268":-5,"_20":269,"_22":270,"_271":272,"_273":274,"_26":275,"_24":276,"_277":-5,"_278":-5,"_279":57,"_280":281,"_282":48,"_283":-5,"_284":-5,"_285":286},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":25,"_26":27,"_28":-5,"_29":-5,"_30":-5,"_31":-5,"_32":-5},"handle","realcoder","name","CrimeMap","branchName","main","version","path","frontend/components","project",{"_36":215,"_13":14,"_49":216,"_217":-5,"_218":57,"_219":220,"_221":220,"_222":-5,"_223":-5,"_224":225,"_226":161,"_227":48,"_228":48,"_229":-5,"_230":75,"_231":232,"_233":-5,"_234":-5,"_235":-5,"_236":-5,"_237":238,"_239":238,"_240":241,"_242":241,"_243":241,"_244":238,"_245":238,"_246":247,"_248":249,"_250":251,"_252":57},"tree",[83,84,85,86],"file",{"_36":78,"_13":61,"_39":42,"_41":79,"_43":44,"_45":73,"_47":48,"_49":80,"_17":75,"_52":81,"_54":-5,"_56":57,"_58":-5,"_18":82},"contents",[33,34,35],"upstream","pull","ahead","behind","envVars",{"_36":70,"_13":71,"_39":72,"_41":42,"_43":44,"_45":73,"_47":48,"_49":74,"_17":75,"_52":53,"_54":76,"_56":57,"_58":-5,"_18":77},{"_36":62,"_13":63,"_39":64,"_41":42,"_43":44,"_45":65,"_47":48,"_49":66,"_17":67,"_52":53,"_54":68,"_56":57,"_58":-5,"_18":69},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_18":59},"id","a3ded09e-3f9b-11f0-bbad-76b3cceeab13","ReportForm.tsx","fileId","08dd17d6-3f91-11f0-825c-76b3cceeab13","parentId","b4050c00-2af5-4c47-853b-b480158d8ce5","branchId","966b2f30-3f90-11f0-800c-76b3cceeab13","branchVersion",34,"latest",true,"createdAt",["D",1748859815015],8,"fileType","script","content","/** @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}","deleted",false,"label",[60,61,38],"frontend","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}",[60,61,63],"ea73dce4-3f90-11f0-869e-76b3cceeab13","App.tsx","ea73ddb6-3f90-11f0-869e-76b3cceeab13",10,["D",1748855208970],0,"/** @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}",[60,61,71],"ea73f2f6-3f90-11f0-869e-76b3cceeab13","4d66147a-eecb-4262-b628-9610fbc28f8c",["D",1748855208970],"directory",[60,61],{"_36":149,"_13":150,"_39":151,"_41":-5,"_43":44,"_45":152,"_47":48,"_49":153,"_17":75,"_52":81,"_54":-5,"_56":57,"_58":-5,"_93":154,"_18":155},{"_36":111,"_13":60,"_39":79,"_41":-5,"_43":44,"_45":51,"_47":48,"_49":112,"_17":75,"_52":81,"_54":-5,"_56":57,"_58":-5,"_93":113,"_18":114},{"_36":96,"_13":97,"_39":98,"_41":-5,"_43":44,"_45":99,"_47":48,"_49":100,"_17":75,"_52":81,"_54":-5,"_56":57,"_58":-5,"_93":101,"_18":102},{"_36":87,"_13":88,"_39":89,"_41":-5,"_43":44,"_45":90,"_47":48,"_49":91,"_17":75,"_52":24,"_54":92,"_56":57,"_58":-5,"_93":94,"_18":95},"ae8f1536-3f90-11f0-a60d-76b3cceeab13","README.md","ae8f15f4-3f90-11f0-a60d-76b3cceeab13",1,["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.","children",[],[88],"b1debaac-3f90-11f0-984b-76b3cceeab13","shared","57859476-c566-4eb2-bf20-f0d0fb46d05d",2,["D",1748855114039],[103],[97],{"_36":104,"_13":105,"_39":106,"_41":98,"_43":44,"_45":99,"_47":48,"_49":107,"_17":75,"_52":53,"_54":108,"_56":57,"_58":-5,"_93":109,"_18":110},"b1deb2d2-3f90-11f0-984b-76b3cceeab13","types.ts","b1deb3a4-3f90-11f0-984b-76b3cceeab13",["D",1748855114039],"// 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];",[],[97,105],"d621da48-3f90-11f0-97f8-76b3cceeab13",["D",1748855174870],[115,116,117],[60],{"_36":78,"_13":61,"_39":42,"_41":79,"_43":44,"_45":73,"_47":48,"_49":134,"_17":75,"_52":81,"_54":-5,"_56":57,"_58":-5,"_93":135,"_18":136},{"_36":126,"_13":127,"_39":128,"_41":79,"_43":44,"_45":129,"_47":48,"_49":130,"_17":99,"_52":24,"_54":131,"_56":57,"_58":-5,"_93":132,"_18":133},{"_36":118,"_13":119,"_39":120,"_41":79,"_43":44,"_45":121,"_47":48,"_49":122,"_17":75,"_52":53,"_54":123,"_56":57,"_58":-5,"_93":124,"_18":125},"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();",[],[60,119],"4c0fff7c-3f9c-11f0-b1ba-76b3cceeab13","index.html","d621bb30-3f90-11f0-97f8-76b3cceeab13",38,["D",1748860097197],"\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",[],[60,127],["D",1748855208970],[137,138,139],[60,61],{"_36":70,"_13":71,"_39":72,"_41":42,"_43":44,"_45":73,"_47":48,"_49":146,"_17":75,"_52":53,"_54":76,"_56":57,"_58":-5,"_93":147,"_18":148},{"_36":62,"_13":63,"_39":64,"_41":42,"_43":44,"_45":65,"_47":48,"_49":143,"_17":67,"_52":53,"_54":68,"_56":57,"_58":-5,"_93":144,"_18":145},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":140,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_93":141,"_18":142},["D",1748859815015],[],[60,61,38],["D",1748859969451],[],[60,61,63],["D",1748855208970],[],[60,61,71],"b5b31b82-3f90-11f0-9402-76b3cceeab13","backend","be447c83-12c1-4506-935a-fc03bdaf890b",3,["D",1748855120462],[156,157,158],[150],{"_36":192,"_13":193,"_39":194,"_41":151,"_43":44,"_45":152,"_47":48,"_49":195,"_17":75,"_52":81,"_54":-5,"_56":57,"_58":-5,"_93":196,"_18":197},{"_36":168,"_13":169,"_39":170,"_41":151,"_43":44,"_45":171,"_47":48,"_49":172,"_17":75,"_52":81,"_54":-5,"_56":57,"_58":-5,"_93":173,"_18":174},{"_36":159,"_13":160,"_39":161,"_41":151,"_43":44,"_45":162,"_47":48,"_49":163,"_17":90,"_52":164,"_54":165,"_56":57,"_58":-5,"_93":166,"_18":167},"0aa7d48e-3f91-11f0-a354-76b3cceeab13","index.ts","cfe50056-3f90-11f0-905d-76b3cceeab13",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",[],[150,160],"c79f5cb6-3f90-11f0-a2ca-76b3cceeab13","routes","a038936b-2995-4d64-9846-4c2e9a03310f",5,["D",1748855150532],[175,176],[150,169],{"_36":185,"_13":186,"_39":187,"_41":170,"_43":44,"_45":171,"_47":48,"_49":188,"_17":75,"_52":53,"_54":189,"_56":57,"_58":-5,"_93":190,"_18":191},{"_36":177,"_13":178,"_39":179,"_41":170,"_43":44,"_45":180,"_47":48,"_49":181,"_17":75,"_52":53,"_54":182,"_56":57,"_58":-5,"_93":183,"_18":184},"cc1446a8-3f90-11f0-97f8-76b3cceeab13","static.ts","cc144784-3f90-11f0-97f8-76b3cceeab13",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;",[],[150,169,178],"c79f4b40-3f90-11f0-a2ca-76b3cceeab13","reports.ts","c79f4bf4-3f90-11f0-a2ca-76b3cceeab13",["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;",[],[150,169,186],"b5b31d80-3f90-11f0-9402-76b3cceeab13","database","9bf6003d-1533-429a-9316-8d78481b2677",["D",1748855120462],[198,199],[150,193],{"_36":208,"_13":209,"_39":210,"_41":194,"_43":44,"_45":152,"_47":48,"_49":211,"_17":75,"_52":53,"_54":212,"_56":57,"_58":-5,"_93":213,"_18":214},{"_36":200,"_13":201,"_39":202,"_41":194,"_43":44,"_45":203,"_47":48,"_49":204,"_17":75,"_52":53,"_54":205,"_56":57,"_58":-5,"_93":206,"_18":207},"bed7cc1c-3f90-11f0-a015-76b3cceeab13","queries.ts","bed7ccee-3f90-11f0-a015-76b3cceeab13",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}",[],[150,193,201],"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 };",[],[150,193,209],"966ac248-3f90-11f0-800c-76b3cceeab13",["D",1748855067988],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","238dc720-3f90-11f0-ad5b-814c56c8abb0","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","74213d8f-b268-4ac6-b09e-69eb86e44175","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_267":263},"org",{"_11":12,"_261":-5,"_262":263,"_224":225,"_264":265,"_266":57},"branch",{"_17":129,"_13":16,"_36":44,"_253":215,"_254":-5,"_255":-5,"_256":-5,"_257":-5,"_258":-5,"_259":14,"_260":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ4d2g1a0xNT0I4U3dPaFhiU0k2dHdsMDM5RiJ9","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_36":215,"_13":14,"_49":357,"_217":-5,"_218":57,"_219":220,"_221":220,"_222":-5,"_223":-5,"_224":225,"_226":161,"_227":48,"_228":48,"_229":-5,"_230":75,"_231":232,"_233":-5,"_234":-5,"_235":-5,"_236":-5,"_237":238,"_239":238,"_240":241,"_242":241,"_243":241,"_244":238,"_245":238,"_246":358,"_248":359,"_250":360,"_252":57},[303,311,318,320],"files",[303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320],"counts",{"_294":75,"_295":90,"_296":75,"_32":297,"_298":299},[288,289,290],{"_36":78,"_13":61,"_39":42,"_41":79,"_43":44,"_45":73,"_47":48,"_49":80,"_17":75,"_52":81,"_54":-5,"_56":57,"_58":-5,"_18":287},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[60,61],{"_36":70,"_13":71,"_39":72,"_41":42,"_43":44,"_45":73,"_47":48,"_49":74,"_17":75,"_52":53,"_54":76,"_56":57,"_58":-5,"_18":293},{"_36":62,"_13":63,"_39":64,"_41":42,"_43":44,"_45":65,"_47":48,"_49":66,"_17":67,"_52":53,"_54":68,"_56":57,"_58":-5,"_18":292},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_18":291},[60,61,38],[60,61,63],[60,61,71],"pulls","branches","forks",{"_300":75,"_302":75},"connections",{"_300":75,"_301":75},"count","unfilledCount","emptyCount",{"_36":149,"_13":150,"_39":151,"_41":-5,"_43":44,"_45":152,"_47":48,"_49":153,"_17":75,"_52":81,"_54":-5,"_56":57,"_58":-5,"_93":355,"_18":356},{"_36":192,"_13":193,"_39":194,"_41":151,"_43":44,"_45":152,"_47":48,"_49":195,"_17":75,"_52":81,"_54":-5,"_56":57,"_58":-5,"_93":353,"_18":354},{"_36":208,"_13":209,"_39":210,"_41":194,"_43":44,"_45":152,"_47":48,"_49":211,"_17":75,"_52":53,"_54":212,"_56":57,"_58":-5,"_93":351,"_18":352},{"_36":200,"_13":201,"_39":202,"_41":194,"_43":44,"_45":203,"_47":48,"_49":204,"_17":75,"_52":53,"_54":205,"_56":57,"_58":-5,"_93":349,"_18":350},{"_36":168,"_13":169,"_39":170,"_41":151,"_43":44,"_45":171,"_47":48,"_49":172,"_17":75,"_52":81,"_54":-5,"_56":57,"_58":-5,"_93":347,"_18":348},{"_36":185,"_13":186,"_39":187,"_41":170,"_43":44,"_45":171,"_47":48,"_49":188,"_17":75,"_52":53,"_54":189,"_56":57,"_58":-5,"_93":345,"_18":346},{"_36":177,"_13":178,"_39":179,"_41":170,"_43":44,"_45":180,"_47":48,"_49":181,"_17":75,"_52":53,"_54":182,"_56":57,"_58":-5,"_93":343,"_18":344},{"_36":159,"_13":160,"_39":161,"_41":151,"_43":44,"_45":162,"_47":48,"_49":163,"_17":90,"_52":164,"_54":165,"_56":57,"_58":-5,"_93":341,"_18":342},{"_36":111,"_13":60,"_39":79,"_41":-5,"_43":44,"_45":51,"_47":48,"_49":112,"_17":75,"_52":81,"_54":-5,"_56":57,"_58":-5,"_93":339,"_18":340},{"_36":78,"_13":61,"_39":42,"_41":79,"_43":44,"_45":73,"_47":48,"_49":134,"_17":75,"_52":81,"_54":-5,"_56":57,"_58":-5,"_93":337,"_18":338},{"_36":70,"_13":71,"_39":72,"_41":42,"_43":44,"_45":73,"_47":48,"_49":146,"_17":75,"_52":53,"_54":76,"_56":57,"_58":-5,"_93":335,"_18":336},{"_36":62,"_13":63,"_39":64,"_41":42,"_43":44,"_45":65,"_47":48,"_49":143,"_17":67,"_52":53,"_54":68,"_56":57,"_58":-5,"_93":333,"_18":334},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":140,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_93":331,"_18":332},{"_36":126,"_13":127,"_39":128,"_41":79,"_43":44,"_45":129,"_47":48,"_49":130,"_17":99,"_52":24,"_54":131,"_56":57,"_58":-5,"_93":329,"_18":330},{"_36":118,"_13":119,"_39":120,"_41":79,"_43":44,"_45":121,"_47":48,"_49":122,"_17":75,"_52":53,"_54":123,"_56":57,"_58":-5,"_93":327,"_18":328},{"_36":96,"_13":97,"_39":98,"_41":-5,"_43":44,"_45":99,"_47":48,"_49":100,"_17":75,"_52":81,"_54":-5,"_56":57,"_58":-5,"_93":325,"_18":326},{"_36":104,"_13":105,"_39":106,"_41":98,"_43":44,"_45":99,"_47":48,"_49":107,"_17":75,"_52":53,"_54":108,"_56":57,"_58":-5,"_93":323,"_18":324},{"_36":87,"_13":88,"_39":89,"_41":-5,"_43":44,"_45":90,"_47":48,"_49":91,"_17":75,"_52":24,"_54":92,"_56":57,"_58":-5,"_93":321,"_18":322},[],[88],[],[97,105],[319],[97],[],[60,119],[],[60,127],[],[60,61,38],[],[60,61,63],[],[60,61,71],[313,314,315],[60,61],[312,316,317],[60],[],[150,160],[],[150,169,178],[],[150,169,186],[308,309],[150,169],[],[150,193,201],[],[150,193,209],[305,306],[150,193],[304,307,310],[150],["D",1748855067988],{"_11":12,"_267":263},{"_11":12,"_261":-5,"_262":263,"_224":225,"_264":265,"_266":57},{"_17":129,"_13":16,"_36":44,"_253":215,"_254":-5,"_255":-5,"_256":-5,"_257":-5,"_258":-5,"_259":14,"_260":12},"ctx",{"_246":-5,"_284":394,"_395":396,"_397":398,"_399":57,"_400":57,"_401":57,"_402":48,"_403":-5,"_404":-7,"_405":-7,"_406":75,"_407":57,"_408":57,"_409":-5,"_410":57,"_411":57,"_412":57,"_413":-5},"ENV",{"_365":366,"_367":368,"_369":16,"_370":371,"_372":373,"_374":375,"_376":377,"_378":379,"_380":381,"_382":383,"_384":385,"_386":387,"_388":389,"_390":391,"_392":393},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","811aa22498c9b0b5a47e8d778de579cdb990f332","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"]