[Python] Anyone have experience with PostGIS and/or GeoAlchemy?

[Monique Blake]

Hi everyone,

Sorry for the delay. Yes I'm stuck on something. So I have this pgloader
file and I create my Location column (which is currently of text datatype).
I wanted to make it into a point datatype and ran into an error when I
attempted to do so: Location geometry(point).
https://github.com/Munnu/Stroll-Safely/blob/master/csv_files/ny_final_csv.load

In my csv, which is somewhat too large to display the original, but here's
a small sample has the Location column written as "(40.6227027620001,
-73.9883732929999)":
https://raw.githubusercontent.com/Munnu/Stroll-Safely/master/csv_files/unit_test_crime_data.csv

How can I make that field into a point type when I attempt to pgload it? I
know it's looking for something along the lines of point(40.6227027620001
-73.9883732929999) in order to work.

Thank you.

On Tue, May 17, 2016 at 12:07 PM, Gregory Dillon <gregorydillon at gmail.com>
wrote:

> I'm also interested in this topic.
>
> On Mon, May 16, 2016 at 10:48 PM, Monique Blake <moniqueblake4 at gmail.com>
> wrote:
>
>> Hi everyone,
>>
>> I'm working on a mapping project and have been hitting my head against
>> PostGIS and Geoalchemy. Wanted to know if there is someone who might be
>> able to walk me through it.
>>
>> _______________________________________________
>> Python mailing list
>> Python at lists.noisebridge.net
>> http://www.noisebridge.net/mailman/listinfo/python
>>
>>
>
>
> --
> Let's stay in touch.  Greg
>
> This message may contain confidential information that may also be
> privileged. Unless you are the intended recipient or are authorized to
> received information for the intended recipient, you may not use, copy, or
> disclose the message in whole or in part. If you have received this message
> in error, please advise the sender by reply email and delete all copies of
> the message. Thank you.
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.noisebridge.net/pipermail/python/attachments/20160520/ec13d900/attachment-0003.html>