Re: Storing data on a regular lat/lon grid

>
> Basically, has anyone done any work with storing gridded spatial data? I
>> see
>> lot's of info on Geospatial data, but it's usually cities, stations, etc.,
>> not a regular grid that doesn't change...
>>
>
> well, you could play around with storing information in arrays.
> storing record for each point gives you the most flexibility of
> querying and indexing but is extremely inefficient from storage
> perspective. arrays are better from that point of view and can work
> pretty well as long as you read/write the data in blocks in a fairly
> regular way (and hopefully the layout of your grid doesn't change that
> often).
>

Thanks for your help, I've stored a 2-dimensional array in Postgres,
inserted like this:

{{1,1,3},{2,2,1},{3,1,2}}

But I'm having trouble retrieving it from Java. My jdbc driver is loaded
fine and I'm connecting to the database, but I don't know how to get from a
java.sql Array to an int[] array in Java. I'm using this piece of code to
pull the data from the ResultSet:

Array categoryArray = rs.getArray("category").getArray();

But I don't know what to do with this. I want to end up with an int[] array.
Can anyone suggest something?

Thanks a lot,

--
Mike