გარემოს სტატისტიკის სამსახურის პორტალი

[V0_FILE]json:file="package.json" { "name": "georgian-env-stats", "version": "1.0.0", "description": "Georgian Environmental Statistics Portal", "main": "server.js", "scripts": { "start": "node server.js", "dev": "concurrently \"nodemon server.js\" \"npm run client\"", "client": "webpack serve --mode development", "build": "webpack --mode production", "build:server": "node server.js" }, "dependencies": { "express": "^4.18.2", "cors": "^2.8.5", "path": "^0.12.7", "react": "^18.2.0", "react-dom": "^18.2.0", "highcharts": "^11.2.0", "highcharts-react-official": "^3.2.1" }, "devDependencies": { "@babel/core": "^7.23.0", "@babel/preset-env": "^7.23.0", "@babel/preset-react": "^7.22.0", "babel-loader": "^9.1.3", "css-loader": "^6.8.1", "html-webpack-plugin": "^5.5.3", "style-loader": "^3.3.3", "webpack": "^5.89.0", "webpack-cli": "^5.1.4", "webpack-dev-server": "^4.15.1", "concurrently": "^8.2.2", "nodemon": "^3.0.1" } } [V0_FILE]javascript:file="server.js" const express = require("express") const cors = require("cors") const path = require("path") const app = express() const PORT = process.env.PORT || 5000 // Middleware app.use(cors()) app.use(express.json()) app.use(express.static(path.join(__dirname, "dist"))) // Mock data for the Georgian Environmental Statistics const mockData = { airQuality: [ { city: "თბილისი", pm25: 17.7, status: "838/83", lastUpdated: "მაისი 2025" }, { city: "ბათუმი", pm25: 13.5, status: "838/83", lastUpdated: "მაისი 2025" }, { city: "ქუთაისი", pm25: 15.2, status: "838/83", lastUpdated: "მაისი 2025" }, { city: "რუსთავი", pm25: 19.8, status: "838/83", lastUpdated: "მაისი 2025" }, ], regionalEmissions: [ { region: "რაჭა-ლეჩხუმი და ქვე...", emissions: 45 }, { region: "გურია", emissions: 32 }, { region: "აჭარის არ", emissions: 78 }, { region: "კახეთი", emissions: 156 }, { region: "სამცხე-ჯავახეთი", emissions: 89 }, { region: "მცხეთა-მთიანეთი", emissions: 67 }, { region: "იმერეთი", emissions: 234 }, { region: "შიდა ქართლი", emissions: 123 }, { region: "ქ. თბილისი", emissions: 345 }, { region: "სამეგრელო-ზემო სვან...", emissions: 98 }, { region: "ქვემო ქართლი", emissions: 187 }, ], cityEmissions: [ { city: "თბილისი", captured: 120, emitted: 45 }, { city: "ბათუმი", captured: 80, emitted: 25 }, { city: "გარდაბანი", captured: 60, emitted: 20 }, { city: "ზესტაფონი", captured: 40, emitted: 15 }, { city: "კასპი", captured: 35, emitted: 12 }, { city: "რუსთავი", captured: 90, emitted: 30 }, { city: "ფოთი", captured: 55, emitted: 18 }, { city: "ქუთაისი", captured: 70, emitted: 22 }, ], timeSeriesData: [ { year: 2014, NOx: 45, CO: 38, SO2: 25, PM25: 15, NMVOC: 20 }, { year: 2015, NOx: 42, CO: 35, SO2: 23, PM25: 14, NMVOC: 18 }, { year: 2016, NOx: 40, CO: 33, SO2: 22, PM25: 13, NMVOC: 17 }, { year: 2017, NOx: 38, CO: 31, SO2: 20, PM25: 12, NMVOC: 16 }, { year: 2018, NOx: 36, CO: 29, SO2: 19, PM25: 11, NMVOC: 15 }, { year: 2019, NOx: 34, CO: 27, SO2: 18, PM25: 10, NMVOC: 14 }, { year: 2020, NOx: 32, CO: 25, SO2: 17, PM25: 9, NMVOC: 13 }, { year: 2021, NOx: 30, CO: 23, SO2: 16, PM25: 8, NMVOC: 12 }, { year: 2022, NOx: 28, CO: 21, SO2: 15, PM25: 7, NMVOC: 11 }, { year: 2023, NOx: 26, CO: 19, SO2: 14, PM25: 6, NMVOC: 10 }, ], } // API Routes app.get("/api/air-quality", (req, res) => { res.json(mockData.airQuality) }) app.get("/api/regional-emissions", (req, res) => { res.json(mockData.regionalEmissions) }) app.get("/api/city-emissions", (req, res) => { res.json(mockData.cityEmissions) }) app.get("/api/time-series", (req, res) => { res.json(mockData.timeSeriesData) }) // PC-Axis file download endpoints app.get("/api/download/:type/:format", (req, res) => { const { type, format } = req.params let data let filename switch (type) { case "air-quality": data = mockData.airQuality filename = `air-quality-data.${format}` break case "regional-emissions": data = mockData.regionalEmissions filename = `regional-emissions-data.${format}` break case "city-emissions": data = mockData.cityEmissions filename = `city-emissions-data.${format}` break case "time-series": data = mockData.timeSeriesData filename = `time-series-data.${format}` break default: return res.status(404).json({ error: "Data type not found" }) } if (format === "px") { // Generate PC-Axis format const pcAxisContent = generatePCAxisFile(data, type) res.setHeader("Content-Type", "text/plain") res.setHeader("Content-Disposition", `attachment; filename="${filename}"`) res.send(pcAxisContent) } else if (format === "csv") { // Generate CSV format const csvContent = generateCSVFile(data) res.setHeader("Content-Type", "text/csv") res.setHeader("Content-Disposition", `attachment; filename="${filename}"`) res.send(csvContent) } else if (format === "json") { // Generate JSON format res.setHeader("Content-Type", "application/json") res.setHeader("Content-Disposition", `attachment; filename="${filename}"`) res.json(data) } else { res.status(400).json({ error: "Unsupported format" }) } }) // Helper functions for file generation function generatePCAxisFile(data, type) { let pcAxisContent = `CHARSET="ANSI";\n` pcAxisContent += `AXIS-VERSION="2013";\n` pcAxisContent += `CODEPAGE="utf-8";\n` pcAxisContent += `LANGUAGE="ka";\n` pcAxisContent += `CREATION-DATE="20250925 10:00";\n` pcAxisContent += `TITLE="Georgian Environmental Statistics - ${type}";\n` pcAxisContent += `CONTENTS="Environmental Data";\n` pcAxisContent += `UNITS="Various";\n` pcAxisContent += `STUB="Location";\n` pcAxisContent += `HEADING="Indicator";\n` // Add data values const values = data.map((item) => { if (item.pm25) return item.pm25 if (item.emissions) return item.emissions if (item.captured) return item.captured return Object.values(item).filter((v) => typeof v === "number")[0] || 0 }) pcAxisContent += `VALUES=${JSON.stringify(values)};\n` pcAxisContent += `DATA=\n` pcAxisContent += values.join(" ") + ";\n" return pcAxisContent } function generateCSVFile(data) { if (!data.length) return "" const headers = Object.keys(data[0]) const csvRows = [headers.join(",")] data.forEach((row) => { const values = headers.map((header) => { const value = row[header] return typeof value === "string" ? `"${value}"` : value }) csvRows.push(values.join(",")) }) return csvRows.join("\n") } // Serve React app app.get("*", (req, res) => { res.sendFile(path.join(__dirname, "dist", "index.html")) }) app.listen(PORT, () => { console.log(`Server running on port ${PORT}`) }) [V0_FILE]javascript:file="webpack.config.js" const path = require("path") const HtmlWebpackPlugin = require("html-webpack-plugin") module.exports = { entry: "./src/index.js", output: { path: path.resolve(__dirname, "dist"), filename: "bundle.js", publicPath: "/", }, module: { rules: [ { test: /\.(js|jsx)$/, exclude: /node_modules/, use: { loader: "babel-loader", options: { presets: ["@babel/preset-env", "@babel/preset-react"], }, }, }, { test: /\.css$/, use: ["style-loader", "css-loader"], }, ], }, plugins: [ new HtmlWebpackPlugin({ template: "./public/index.html", filename: "index.html", }), ], devServer: { contentBase: path.join(__dirname, "dist"), port: 3000, historyApiFallback: true, proxy: { "/api": "http://localhost:5000", }, }, resolve: { extensions: [".js", ".jsx"], }, } [V0_FILE]html:file="public/index.html" გარემოს სტატისტიკის სამსახურის პორტალი - საქართველო

JavaScript საჭიროა

ამ საიტის სამუშაოდ JavaScript-ის ჩართვა აუცილებელია.

გთხოვთ ჩართოთ JavaScript თქვენს ბრაუზერში და განაახლოთ გვერდი.

იტვირთება...