iamvickyav

Convert OpenStreetMap relation into KML file for Google Maps

Relation Example - https://www.openstreetmap.org/relation/7237808#map=8/28.623/77.775

Use - https://overpass-turbo.eu/ to convert

Query to run

[out:json][timeout:25];

iamvickyav

Convert Python as .exe file with pandas dependency in Windows

Installation

Create following code inside app.py file inside a folder

# app.py
import pandas as pd

iamvickyav

Creating JAR file using CMD

If your source code has other jar files as dependency

Folder Structure

.
├── com
│   ├── vicky

iamvickyav

With User Input

import groovy.sql.GroovyResultSet
import groovy.sql.Sql

import javax.swing.JOptionPane

class Test {

iamvickyav

MySQL Local Setup in MAC

brew install mysql

mysql

$(brew --prefix mysql)/bin/mysqladmin -u root password root

mysql -h localhost -P 3306 -u root -p (Enter password as root to login)

iamvickyav

Refer JAR files in classpath using command

> javac -classpath commons-text-1.9.jar:commons-lang3-3.0.1.jar:. Main.java
> java -classpath commons-text-1.9.jar:commons-lang3-3.0.1.jar:. Main

import org.apache.commons.text.diff.StringsComparator;
import org.apache.commons.text.diff.EditScript;

iamvickyav

version : '3'
services:
  mysql:
    image: mysql
    command: --default-authentication-plugin=mysql_native_password
    environment:
      MYSQL_ROOT_PASSWORD: root
    ports:
      - "3306:3306"
    volumes:

iamvickyav

 <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
            <plugin>
                <artifactId>maven-clean-plugin</artifactId>
                <version>2.5</version>
                <configuration>

iamvickyav

import org.junit.jupiter.api.BeforeEach;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.autoconfigure.web.servlet.AutoConfigureMockMvc;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.boot.test.mock.mockito.MockBean;
import org.springframework.security.test.context.support.WithMockUser;
import org.springframework.test.web.servlet.MockMvc;
import org.springframework.test.web.servlet.setup.MockMvcBuilders;
import org.springframework.web.context.WebApplicationContext;

iamvickyav

@JsonFilter("userFilter")
public class User {

    private Integer id;
    private String name;
    private Date dob;
    private String city;
    
    // constructors, getters & setters are ignored
}