如何在typeorm和postgres中使用经度和纬度

import { Entity, Column, PrimaryGeneratedColumn } from 'typeorm';

@Entity()
export class Location {
  @PrimaryGeneratedColumn()
  id: number;

  @Column('double precision')
  latitude: number;

  @Column('double precision')
  longitude: number;
}

import { createConnection } from 'typeorm';

createConnection({
  type: 'postgres',
  host: 'localhost',
  port: 5432,
  username: 'your_username',
  password: 'your_password',
  database: 'your_database',
  entities: [Location],
  synchronize: true,
}).then(() => {
  console.log('Database connected');
}).catch((error) => {
  console.log('Error connecting to database', error);
});

import { getRepository } from 'typeorm';

// 插入数据
const location = new Location();
location.latitude = 40.7128;
location.longitude = -74.0060;

const locationRepository = getRepository(Location);
locationRepository.save(location);

// 查询数据
const locations = await locationRepository.find();
console.log(locations);

import { getRepository } from 'typeorm';

// 查询距离某个位置最近的数据
const nearestLocations = await locationRepository
  .createQueryBuilder('location')
  .select('location')
  .orderBy('ST_Distance(location.point, ST_MakePoint(:longitude, :latitude))', 'ASC')
  .setParameter('longitude', -74.0060)
  .setParameter('latitude', 40.7128)
  .getMany();

console.log(nearestLocations);