Wednesday, January 15, 2003

Photo

I finished up adding a photo to a location. Works pretty well, I think. May do some more (need to preview photo when adding, and have a way to delete it). It’s a really nice feature, makes the whole thing look a LOT nice (plus it’s very cool :P)

More thoughts on doing stuff with AE - I was wondering if there's be a way to post my last loc, and Ron and Paul could do the same - and if we came withing X feet of each other, it would do alert. Seems like there's a lot of stuff that could be done in that direction. Don't know how viable that would be with a lot of users - would need to filter in some way.

Tuesday, January 14, 2003

Voting

Well, finished version #1 of voting, after the gym tonight. Did the db, service, and web work. Went fairly well – it’s nice to see the infrastructure handling all this new stuff. I haven’t had to make any real design or architecture changes in a while (so it’s kinda jelling, I thing. Woot!) One thing that’s still there that needs to get pulled is a *little* bit of security in the sp’s. I’ve pulled all that up to the Service layer, but the findNearLoc call still checks that the user can access the loc (by group and such), which sucks and needs to be changed.

Got www.activehost.com (and they rock so much I can’t believe it) to make a dir writeable, and I’ve figured out how to upload images. I’m a bit beat tonight, so that will probably be done this weekend (so photo’s for locs will be done).

Anyway. It’s really starting to come together, at least for the web and service layer. I have a huge amount to do still, which is daunting, but it’s nice to have at least once piece nearing completing (LOL, one year later).

Site up

Well, www.annotatedearth.com is up and available. Kinda nice to have the real site up. I had some initial problems with the database, but it’s all working very nicely now. I’ve been in clean-up mode on the web. Adding mapping (Yahoo, TerraServer, Mapquest links), general screen cleanup, and adding some new functionality (put in the plumbing and web page to do “my locations”). Probably want to do a pop-up on findloc, listing that, Also need to put delete in on the view location page (hehehe, needing that lot right now, trying to get clean locs in). Also am now doing sortable columns on the data grid.

I also got the user registration (email-based verification) working, put in the about, intro, and dev text.

Two big ones I’d like soon are adding a picture of a location. Still thinking about it – might put in the DB, or upload to a file. Need to see what .NET facilitates best, as I don’t want to have to screw with it much. ‘Course that also means I really need to put user limits on # of locs and picture K or something.

So, it’s going pretty good. I still need to add a new “Find Loc” (one that will search around a city/state/etc., as it’s all loc based now). Yeah, I know, that’s the point of this system, but I’m leaning towards allowing the AE web site to also be a general repository of GPS coords and info.

I’m really hoping to be done with the web (this version, at least), really soon now. I need to “fix” the MFC app, then do a C# client and a VB client. THEN on to PocketPC (99% sure that’s my next target, as I don’t want to have to muck with learning how to program the pilot right now).

I also need to get some more locations in the DB. There’s a few public repositories of locations out there, I’d like to start gathering a list of some good ones and enter them. I’ll also start getting more Columbia locs as I can.

Tuesday, December 31, 2002

Site

Well, I’ve been working on AE off and on since the last entry, but haven’t gotten around to entering new info here (been busy!)

The trip was interesting. I've been thinking of all kinds of things you could use AE for. Like, I was sitting in a restaurant in the mountains and wondered what others were around - users could submit to a restaurant list, rate them, do pics of them (maybe pics of the food and menu?), and then I could have requested a list of those restaurants within 5 miles, sorted by rating. Then could make a comment and rate (and take a pic, etc etc).

Also could be used for driving around a neighborhood and find out what's for rent or sale (maybe a revenue stream there? Charge Realtor to submit their listings).

The web site is almost ready to go. The Add/Find/View functions are all there and working nicely. I spent the weekend working on making it look sharp (colors, navigation, making the grid view look good and sortable, plus minor bug fixed).

I’ve also spent a lot of time getting the web off of the recordsets. Instead of calling the location data object layer, *EVERYTHING* now calls the .NET Service. This means that the same thing that serves up data to clients is the same as what the web uses. Which is REALLY good – all that stuff is in one place, so changes and such can take place there. Plus, the web site is basically now the baseline “client”. Hehehe, anyone could write the same web site, just using that service. Kinda cool, and what I’m trying to get to – the eventual goal is to be the definer of the technology (how it works and hangs, from an enterprise level), and the owner of the data. The rest of it (web sites, clients, whatever) can be written by third parties.

I’ve also finally registered www.AnnotatedEarth.com. I’m just camping the name right now, but hope by the end of the month to upgrade the package to dev on activehost (so I’ll get full .NET + SQL Server 2000)… so it will actually be LIVE! :)

For the most part, I need to test a bit more on the web, add some more web links (right now it just goes to mapquest, would like to do a few more) and fill it out (like location of the day, dev info, user setup, forums, etc.)

After that, I need to finish some clients up. I have a working MFC client (well, not working ATM as I made some slight XML/Service changes – they may not impact it, but I’m not sure). The next will be a VB, and then probably a C# .NET app (should be fairly easy, I hope, as I can rip stuff off from the web site to do that). Then I need to get it on at least one PDA. I’d like to do the Pilot, but don’t want to take the learning curve time, so will probably go with some CE-based device/pocket PC (same thing? Not sure…). I also need to get wireless locally, to test on a laptop. Hope Columbia has some wireless leaks downtown, need to check that out (or arrange for a access point somewhere downtown).

I’d like to go live with the web site soon, just to have it up and running, and to develop against. I’d also like to get a lot more locs. There’s some well know locs (like the SC capital, etc.) that I can enter. The web site itself should be usable – not really useful for the location-aware part of things, but as a straight waypoint registry, it works really nice.

I just wish I had more time to write this stuff – work’s been VERY busy the last couple of months, so I’ve only been able to work on AE on the weekends (usually to tired on weeknights to work on it). The only reason I’m working on a Monday is ‘cause I was so in the groove last night, really nailing this stuff. The big one this weekend was getting the web on top of the service. That had been a major annoyance, and what I considered a big architectural flaw.




ToDo:
- Voting
- Add hyperlink to all locs (let user enter)
- User setup
- User registration
- New “Find Loc” (have “Find Near” and just “Find”)
- Text for web
- Move group logic out of sp to location service. Allow a list to be passed into service. Validate against allowed groups for passed user, and then pass as additional part of where clause
- Add “My locations” to grpup search

Tuesday, July 16, 2002

Trip

I’m planning on taking a trip home to MI this Labor Day. As I’m driving, it would be a perfect time to get some GPS coordinates. I’m not sure exactly what I can have up and running by them, but I’d like to do something. Even if it’s just a local store of data on a lap top, using a hand-held GPS

Friday, July 12, 2002

LOL

I just love being able to re-use stuff. Using the powerful WFC XML wrappers I wrote for NZ, and the RS URL wrappers, I’ve been able to call my .NET GPS Service. I’m able to request a distance around a loc, and get back a list and process it, from a little MFC application. While I was pretty sure it would work, it’s nice to validate it.

Once I’ve got the XML standards down, I can focus on writing the Windows Test App (and then the GPS interface).

App

The first service is up. A loc can be passed, along with the # of feet to calculate, and a list is returned of stuff around that loc. So, in theory, I can just expand upon that and start writing client software. The input is a URL; the output is a XML document

I’ve gotten to the point where I need to formalize all the things that can be done in AE. Right now, the user ID is passed into the stored proc, and it returns all locs in that users groups. Do I want to keep it at that level? Do I want to be able to have the user get all groups, a specific group, or several groups? I need to formalize error handling, and the overall format of the XML document returns.

I’m going to write a quick WFC application to verify that the XML feed is working.