8h
asked Execute command while starting qtconsole
13h
comment Crop and reproject shapefile based on GeoTIFF sample
Nice tip. I tried to reproject and clip at the same time, but I put -clipdst before the filenames, so it didn't work, and I didn't read the error message carefully about partial reprojection possiblity with OGR_ENABLE_PARTIAL_REPROJECTION nor I would have known how to define that option ;)
15h
accepted Crop and reproject shapefile based on GeoTIFF sample
15h
comment Crop and reproject shapefile based on GeoTIFF sample
Thanks, it was countries shapefile, but I managed to get correct output by first cropping to outer rectangle of GeoTIFF file, then reprojecting and then clipping to projected coordinates. I was just hoping that straightforward approach of using georeferenced file as reference exists in gdal/org system.
17h
comment Crop and reproject shapefile based on GeoTIFF sample
Projecting whole globe to destination projection is not possible, so I have to crop the source first, and that is where I stopped in the first place as corner coordinates are not forming rectangle in Natural Earth shapefile source projection. Any suggestions?
20h
asked Crop and reproject shapefile based on GeoTIFF sample
1d
comment Query PostGIS database without creating primary key
Sorry, it's my fault. Before issuing PostgreSQL layer has no primary key. there was one more message: Duplicate field Code found. So that was the real reason why the query didn't load as layer - latter message seems like result from the previous fault.
1d
asked Query PostGIS database without creating primary key
Aug
24
revised DatabaseError: file is encrypted or is not a database
edited body
Aug
24
asked DatabaseError: file is encrypted or is not a database
Aug
23
comment Can we run commands in terminal directly from scite editor?
It is possible to run terminal commands from scite. Just open output pane (F8) and type command. But changing directory I think is impossible and reserved for current folder of the file in opened buffer, if any.
Aug
21
comment Converting DJVU to PDF
@Tim this is old post. (1) hocr can reference multiple pages, but is this implemented in pdfbeads, I don't know so you'll have to try and see. (2) Bookmarks will be lost sure. Possible solution: use bmcconverter to convert djvu bookmarks to pdftk bookmarks, then use this script to convert pdftk bookmarks to pdfmarks, and finally use Ghostscript to write bookmarks in pdfmarks to pdf file example.
Aug
21
awarded Nice Answer
Aug
19
awarded Yearling
Aug
19
awarded Yearling
Aug
17
accepted Cast types on the fly while creating dataframe
Aug
17
comment Cast types on the fly while creating dataframe
@EdChum, read_json would need whole json object it seems, as it does not accept my partial json (dict) as input.
Aug
17
comment Cast types on the fly while creating dataframe
Excellent, df['time_column'] = pd.to_datetime(df['time_column']) works perfect. If you wish to write your comments as answer I'll gladly accept it as correct, otherwise I'll wait a bit and update my question with your comments.
Aug
17
comment Cast types on the fly while creating dataframe
Thanks @EdChum. DataFrame.convert_objects(convert_dates=True, convert_numeric=True) converts string values to floats, but not the datetime strings unfortunately, which perhaps are too arbitrary for the date parser.
Aug
17
revised Cast types on the fly while creating dataframe
edited tags
1 2 3 4 5