I have copied this blog over to urbanhealthgis.blogspot.com and will be posting there until further notice.
The main reason is that I want to edit the template and add scripts.
New GPS in Health Research Network (GPS-HRN) website
November 19, 2009 · Leave a Comment
The GPS in Health Research Network (GPS-HRN) is an international network of academics and health researchers interested in GPS technology.
The new website is now live www.gps-hrn.org
→ Leave a CommentCategories: Uncategorized
Built Environment and Schools
November 19, 2009 · Leave a Comment
Here are some websites related to the built environment and schools
Travel to School
Feet First – helping NZ primary schools promote walking.
Safe Routes to School – a US network to advance the Safe Routes to School (SRTS) movement in the United States. SRTS can provide a variety of important benefits to children and their communities, including increasing physical activity, reducing traffic congestion, improving air quality, and enhancing neighborhood safety.
Learning about the Built Environment in Schools
Engaging Places – a built environment education project looking at the supply and demand of built environment education in UK schools.
UNSW Built Environment – schools and community engagement
→ Leave a CommentCategories: Uncategorized
I know this blog looks ugly…
October 7, 2009 · Leave a Comment
But have been too busy calculating access to gaming machine venues across NZ to pretty it up. The gambling access calculations have not been without problems. Will post on problems and solutions when I finish calculating…
→ Leave a CommentCategories: Uncategorized
Community mapping examples
September 10, 2009 · 1 Comment
I recently gave a talk about community mapping at a Living Streets Aotearoa meeting. This post contains the examples of community mapping that I mentioned in the talk. All these examples all fall within my general area of research, i.e. social health and wellbeing, and almost all of these examples use google maps.
Note: By “community mapping” I mean maps made by the community. There are other things it might possible be called or related to: neogeography, participatory mapping, volunteered geographic information, collaborative mapping etc. I didn’t have time to figure out the appropriate name.
Example 1: Mapping the location of fruit and urban edibles
- City Fruit (Seattle)
- Bloomington Urban Harvest
- Fernwood Fruit Tree Project
- Fitzroy Feral Fruit Map
- New Zealand Fruit and Food Share Map
Example 2: Bicycle routes
- MapMyRide
- Bikely
- Ride the City – safe bike routes in NYC,. This is more a map for the community than a map by the community, but I thought it was interesting
Example 3: Walkability & Cycleability audits
- Woodbridge Township Safe Routes to School project - schools & community participate in walkability audits to figure out safe routes to school.
Example 4 – Mapping perceptions of the environment
- Rescue Geography’s Eastside project - not all these are collaborative, but there are interesting google earth and google maps that include stories, quotes, photos, video and ambinet sounds of the city. There is also an interesting cycling perceptions project underway.
→ 1 CommentCategories: Community Mapping · Environment and Health · Health · Wellbeing
Free/Open Source Research Tools
September 3, 2009 · Leave a Comment
The International Journal of Conservation (Oryx) has a good list of free and open source research tools.
Zotero is my favourite.
→ Leave a CommentCategories: Uncategorized
URBAN methods paper published
August 20, 2009 · Leave a Comment
The research design and methods paper for the URBAN (Understanding the Relationship Between physical Activity and Neighbourhood) study has been published in BMC Public Health. This is the project where I calculated walkability for neighbourhoods and use this to select neighbourhoods with high and low walkability for the study.
→ Leave a CommentCategories: Uncategorized
Maori GIS Conference
April 8, 2009 · Leave a Comment
The focus of the conference is Maori GIS projects and GIS related projects relevant to Maori aspirations. It is being held in Christchurch from 13-15 May 2009.
EOI for presenters close 15 April.
http://www.ngaitahu.iwi.nz/Events/2009/GIS-Maori-Conference/
→ Leave a CommentCategories: Conference · GIS · Indigenous
Tagged: Conference, GIS, Indigenous, Maori, NZ
How to convert decimal time into 24 hour time in ArcGIS
February 12, 2009 · 4 Comments
Converting data between csv, Access, Excel and ArcGIS can be a hassle, especially when dates and times are involved.
One of today’s dilemmas was how to convert decimal time into 24 hour time in ArcGIS.
Decimal times converts as follows:
1 = 24:00, 0.75 = 18:00, 0.5 = 12:00, and 0.729167 = 17:30.
In Excel you just change the data format. But today I spent what seemed like hours trying to figure out the formula so I could do it in ArcGIS. This time I didn’t want to resort to importing the data back into Excel and into stuffing around trying to get it to export how I wanted it and then importing back into ArcGIS etc…
Anyway. Here is how to calculate it in ArcGIS (or anything else really).
Given a field with the existing decimal time ([DecTime]). Create fields to store the [Hour] and [Minute].
Calculate as follows:
[Hour] = Int([DecTime]*24)
[Minute] = Int([DecTime*24) - [Hour])*60)
Now you can combine the hour and minute parts of the 24 hour time however you want. For example,
[Time24] = [Hour] * 100 + [Minute]
or
[Time24] = [Hour] & “:” & [Minute]
→ 4 CommentsCategories: GIS · Tips
Tagged: ArcGIS, Calculate, Excel, Format, GIS, HowTo, Time, Tips
