Conversions Module¶

Conversions Module

`csv_to_df(csvfile)` ¶

Reads CSV file and converts to Pandas Dataframe

Parameters:

Name	Type	Description	Default
`csvfile`	`.csv file`	a comma separated values file with coordinates	required

Returns:

Type	Description
`DataFrame`	A Pandas DataFrame

Source code in uassist/conversions.py

def csv_to_df(csvfile):
    """Reads CSV file and converts to Pandas Dataframe

    Args:
        csvfile (.csv file): a comma separated values file with coordinates

    Returns:
        DataFrame: A Pandas DataFrame
    """    
    df = pandas.read_csv(csvfile)
    return df

`csvdf_to_geojson(df, xcol, ycol, fname)` ¶

Converts DataFrame to GeoJSON file

Parameters:

Name	Type	Description	Default
`df`	`DataFrame`	A Pandas DataFrame	required
`xcol`	`str`	name of the X coordinate column	required
`ycol`	`str`	name of the Y coordinate column	required
`fname`	`str`	Filename of the output GeoJSON file	required

Source code in uassist/conversions.py

def csvdf_to_geojson(df, xcol, ycol, fname):
    """Converts DataFrame to GeoJSON file

    Args:
        df (DataFrame): A Pandas DataFrame
        xcol (str): name of the X coordinate column
        ycol (str): name of the Y coordinate column
        fname (str): Filename of the output GeoJSON file
    """    
    coords = geopandas.points_from_xy(x=df[xcol], y=df[ycol])
    gdf = geopandas.GeoDataFrame(df, geometry = coords)
    gdf.to_file(fname, driver='GeoJSON')
    print('{} features saved to GeoJSON file'.format(len(gdf['geometry'])))

`df_to_gdf(df)` ¶

converts dataframe to geodataframe

Parameters:

Name	Type	Description	Default
`df`	`dataframe`	a pandas dataframe	required

Returns:

Type	Description
`geodataframe`	geopandas spatially enabled dataframe

Source code in uassist/conversions.py

def df_to_gdf(df):
    """converts dataframe to geodataframe

    Args:
        df (dataframe): a pandas dataframe

    Returns:
        geodataframe: geopandas spatially enabled dataframe
    """    
    #import geopandas

    gdf = geopandas.GeoDataFrame(
    df, geometry=geopandas.points_from_xy(df.longdd, df.latdd))
    gdf = gdf.drop(columns=['xy_pair'])

    return gdf

`dict_to_df(folderpath)` ¶

Convert dictionary to Pandas Dataframe

Parameters:

Name	Type	Description	Default
`folderpath`	`str`	image directory path	required

Returns:

Type	Description
`dataframe`	a Pandas dataframe

Source code in uassist/conversions.py

def dict_to_df(folderpath):
    """Convert dictionary to Pandas Dataframe

    Args:
        folderpath (str): image directory path

    Returns:
        dataframe: a Pandas dataframe
    """    
    #import pandas

    idict = imgdict(folderpath)

    cols = ['filename','latdd','longdd','altitude','datetime','makemodel','height_width','xy_pair','filepath']

    df = pandas.DataFrame.from_dict(idict, orient='index', columns=cols)

    return df

`img_to_csv(folderpath, fname)` ¶

Create CSV file from image locations and attributes

Parameters:

Name	Type	Description	Default
`folderpath`	`str`	path to directory of images	required
`fname`	`str`	output name	required

Source code in uassist/conversions.py

def img_to_csv(folderpath, fname):
    """Create CSV file from image locations and attributes

    Args:
        folderpath (str): path to directory of images
        fname (str): output name
    """    

    import csv
    import pandas

    df = dict_to_df(folderpath)

    df.to_csv(fname, index=False)

    """
        with open('photos.csv', 'w', newline='') as file:
            fieldnames = ['filename', 'latdd', 'longdd']
            writer = csv.DictWriter(file, fieldnames=fieldnames)
    """

`img_to_geojson(folderpath, fname)` ¶

Create GeoJSON from image locations and attributes

Parameters:

Name	Type	Description	Default
`folderpath`	`str`	Path to directory of images	required
`fname`	`string`	Output filename	required

Source code in uassist/conversions.py

def img_to_geojson(folderpath, fname):
    """Create GeoJSON from image locations and attributes

    Args:
        folderpath (str): Path to directory of images
        fname (string): Output filename
    """ 

    df = dict_to_df(folderpath)
    gdf = df_to_gdf(df)
    gdf.to_file(fname, driver='GeoJSON')

    print('{} geotagged images saved to GeoJSON file'.format(len(gdf['geometry'])))

`img_to_geopackage(folderpath, fname)` ¶

Geopackage file from image locations

Parameters:

Name	Type	Description	Default
`folderpath`	`str`	Path to directory of images	required
`fname`	`string`	Output filename	required

Source code in uassist/conversions.py

def img_to_geopackage(folderpath, fname):
    """Geopackage file from image locations

    Args:
        folderpath (str): Path to directory of images
        fname (string): Output filename
    """ 
    df = dict_to_df(folderpath)
    gdf = df_to_gdf(df)
    gdf.to_file(fname, layer='images', driver='GPKG')

    print('{} geotagged images saved to GeoPackage file'.format(len(gdf['geometry'])))

`img_to_kml(folderpath, fname)` ¶

Create KML file from image locations and attributes

Parameters:

Name	Type	Description	Default
`folderpath`	`str`	path to directory of images	required
`fname`	`str`	output filename	required

Source code in uassist/conversions.py

def img_to_kml(folderpath, fname):
    """Create KML file from image locations and attributes

    Args:
        folderpath (str): path to directory of images
        fname (str): output filename
    """    
    #import fiona
    df = dict_to_df(folderpath)
    gdf = df_to_gdf(df)

    fiona.supported_drivers['KML'] = 'rw'
    gdf.to_file(fname, driver='KML')

    print('{} geotagged images saved to KML file'.format(len(gdf['geometry'])))

`img_to_shp(folderpath, fname)` ¶

Create ESRI Shapefile from image locations and attributes

Parameters:

Name	Type	Description	Default
`folderpath`	`str`	Path to directory of images	required
`fname`	`string`	Output filename	required

Source code in uassist/conversions.py

def img_to_shp(folderpath, fname):
    """Create ESRI Shapefile from image locations and attributes

    Args:
        folderpath (str): Path to directory of images
        fname (string): Output filename
    """    
    df = dict_to_df(folderpath)
    for x in  df.select_dtypes(include=['datetime64']).columns.tolist(): df[x] = df[x].astype(str)
    gdf = df_to_gdf(df)

    gdf.to_file("imgs_shp.shp")

    print('{} geotagged images saved to shapefile'.format(len(gdf['geometry'])))

`imgdict(folderpath)` ¶

Creates dictionary of info from image EXIF data

Parameters:

Name	Type	Description	Default
`folderpath`	`str`	path to directory of images	required

Returns:

Type	Description
`dict`	dictionary of metadata for each image. See docs for schema.

Source code in uassist/conversions.py

def imgdict(folderpath):
    """Creates dictionary of info from image EXIF data

    Args:
        folderpath (str): path to directory of images

    Returns:
        dict: dictionary of metadata for each image. See docs for schema.
    """    

    import os, exifread, datetime, uassist
    from exifread.utils import get_gps_coords

    masterdict = {}

    for filename in os.listdir(folderpath):
        if filename.endswith(".jpg") or filename.endswith(".JPG"): 
            filepath = folderpath + "/" + filename
            f = open(filepath, 'rb')
            tags = exifread.process_file(f, details=False)

            # GPS Altitude Values
            gpsaltval = [c.decimal() for c in tags["GPS GPSAltitude"].values]
            gpsalt = round(gpsaltval[0], 2)

            # GPS Coords
            gps = get_gps_coords(tags)
            latdd = round(gps[0], 7)
            longdd = round(gps[1], 7)

            xy = [latdd, longdd]
            #xyz = [latdd, longdd, gpsalt]

            # timestamps
            datetimestr = str(tags.get("Image DateTime"))
            datetimeobj = datetime.datetime.strptime(datetimestr, '%Y:%m:%d %H:%M:%S')

            # model
            make = str(tags["Image Make"])
            model = str(tags["Image Model"])
            makemodel = (make + " " + model)

            #image width and height
            imgh = str(tags.get("EXIF ExifImageLength"))
            imgw = str(tags.get("EXIF ExifImageWidth"))
            imghw = (imgw + " x " + imgh)

            masterdict[filename] = [filename, latdd, longdd, gpsalt, datetimeobj, makemodel, imghw, xy, filepath]

            continue
        else:
            continue

    return masterdict

Last update: 2021-05-07

Conversions Module¶

csv_to_df(csvfile) ¶

csvdf_to_geojson(df, xcol, ycol, fname) ¶

df_to_gdf(df) ¶

dict_to_df(folderpath) ¶

img_to_csv(folderpath, fname) ¶

img_to_geojson(folderpath, fname) ¶

img_to_geopackage(folderpath, fname) ¶

img_to_kml(folderpath, fname) ¶

img_to_shp(folderpath, fname) ¶

imgdict(folderpath) ¶

`csv_to_df(csvfile)` ¶

`csvdf_to_geojson(df, xcol, ycol, fname)` ¶

`df_to_gdf(df)` ¶

`dict_to_df(folderpath)` ¶

`img_to_csv(folderpath, fname)` ¶

`img_to_geojson(folderpath, fname)` ¶

`img_to_geopackage(folderpath, fname)` ¶

`img_to_kml(folderpath, fname)` ¶

`img_to_shp(folderpath, fname)` ¶

`imgdict(folderpath)` ¶