| FOSSLC is a non-profit organization that specializes in technology and know-how to record conferences with excellent quality. Click on the icons below to view great videos from communities we are actively involved with: | ||||||||
|
|
 |
 |
 |
 |
 |
 |
 |
|
UCOSP - End of Semester Result
11 Dec
Posted by shawnjan
in Blog, gcc, UCOSP Fall 2010, Ingres, Intern, UCOSP
The end of the semester has come, and despite not having completed the goal of fully implementing KML conversion in Ingres, I have learned a lot. It turned out that after all of the efforts to go with OGR/GDAL to do our conversion, a build issue prevented us from completing that goal. The conversion from WKB in KML worked fine in an external file to Ingres. The stubs were working fine in Ingres. But when it came to integrating them together, we ran into a circular dependancy issue, where GDAL/OGR and Ingres were linking to each other, and despite our efforts to see what we could do to circumvent the issue, in the end we were defeated by the evil build problem ;).
So in the end, it was deemed that there wasn't enough time in the semester left for me to implement a function in C that converted geometry objects into KML, but that does not mean its not something I intend to complete! Ingres is an open source project, and as discussed with Andrew, he and Chuck will continue to support me. And so my new goal is to have KML implemented before the start of my next semester of school.
After we ran into this issue, it was discussed that the last few things I had to do for this project were to implement a stub for fromKML in addition to asKML, which I completed. I also integrated my changes into the UCOSP_fall2010 branch, which was a fork of the more recent geo_phase2 branch recently created. To do this, I went around to see which commits were needed in this package (as there were a few that did not need to be there, such as any of the OGR stuff), and I did a "git cherry-pick <commit>" for each commit I wanted to integrate. Here is my branch on my fork of Ingres in github:
https://github.com/jansepar/Ingres/commits/UCOSP_fall2010
Here are some same usages of my additions to the Ingres open source project:
When you use askml in the select statement, it will show the value of row, which when using askml, displays "Functionality is not implemented, this is a stub!".
* select askml(there) from pointtable;\gExecuting . . .┌────────────────────────────────┐│col1 │├────────────────────────────────┤│Functionality is not implemented, this is a stub!││Functionality is not implemented, this is a stub!││Functionality is not implemented, this is a stub!│└────────────────────────────────┘(3 rows)
When you use fromkml to insert data into the table, it simply inserts the following data into the database "fromKML functionality is not implemented, this is a stub!".
* insert into pointtable (there) values (geomfromkml('<kml></kml>'));\gExecuting . . .(1 row)* select * from pointtable;\gExecuting . . .┌────────────────────────────────┐│there │├────────────────────────────────┤│\001\000????\025\000\000\000\025\000\000\000\001\001\000\000\000\000\000\000\000\000\000$@\000\000\000\000\000\000$@\001\001\000\000\000\000\000\000\000\000\000$@\000\000\000\000\000\000$@\000\000││fromKML functionality is not implemented, this is a stub!││\001\000????\025\000\000\000\025\000\000\000\001\001\000\000\000\000\000\000\000\000\000$@\000\000\000\000\000\000$@\001\001\000\000\000\000\000\000\000\000\000$@\000\000\000\000\000\000$@x\000││fromKML functionality is not implemented, this is a stub!│└────────────────────────────────┘(4 rows)
Thanks for those of your who have helped me throughout this semester (Thanks in particular to Andrew and Chuck!), and as I mentioned before, despite this being the end of the semester, its not the end of our work together.
Shawn Jansepar
Share this page:
- shawnjan's blog
- Login to post comments