Image download pipeline

[mosqueteiro]

• [x] explore cocoapi/python
• [x] write image download script
• [x] download images to external HD

[mosqueteiro]

pycocotools demo

[mosqueteiro]

plotting image with bbox is written

[mosqueteiro]

load_sql function written, This was helpful which used psycopg2 execute_batch and SQL string composition.

anecdotally tested on categories table

need to run on full database

[mosqueteiro]

all but annotations are working.

after talking with Bob, usually constraints aren't added until the database is populated. He doesn't think this is the issue though...

[mosqueteiro]

re-writing functions into classes for easier use

[mosqueteiro]

Multidimensional arrays in PostgreSQL

• segmentation had arrays of differing lengths so cast to string instead

[mosqueteiro]

saving images

import requests

img_data = requests.get(image_url).content
with open('image_name.jpg', 'wb') as handler:
    handler.write(img_data)

[mosqueteiro]

initial query method written

[mosqueteiro]

DONE! (?)