I need to calculate the population statistics within a 10 minute drivetime catchment from a point and within 1 Km Buffer from a point in MapInfo, how can I do that can someone please elaborate? I have a population thematic map and I have made a buffer on one location and I need to find the total population living within that area? I am also using a Drivetime addon with MapInfo for drive time catchments and Mapinfo to make Buffers.
Many thanks
[GIS] How to obtain statistics within a Buffer/Catchment in MapInfo
buffercatchment-areamapinfo
Related Solutions
STBuffer and STIntersects are the functions you want I think. This is an example of getting the location records within a 10m buffer around the point:
select * from locations where shape.STIntersects(geography::STPointFromText('POINT(32.113, -81.3225)', 4326).STBuffer(10))=1
Where 4326 is the SRID (assuming the data is in WGS84) and 'shape' is the name of the spatial column
Question part 1 - how do you create combined buffers, or convert existing buffers into one?
I don't know what version of QGIS you are using, or whether this feature is missing in older versions, but the Buffer tool has an option to "Dissolve buffer results". Note the pointer position in the following image:
Note that because my data are different, I've set the buffer distance to 200 m. You should set yours to 1609 m = 1 mile.
Question part 2 - How would I then find the number of ponds (onsite and offsite, not counting the pond being queried) within 1 km of each on-site pond (individually).
While you may want to dissolve buffers for visual display, you cannot use dissolved buffers to answer this question, since it sounds like you want a count for each pond separately. So even though the buffers overlap, that is OK, since a pond could fall in the search radius of more than one onsite pond, and you want it to count for each. Use Vector→Analysis Tools→Points in polygon:
Since each buffer was constructed from a point, to get the count of ponds not including the central pond, use the Field Calculator tool to update the pond_count field to pond_count less one. Open the attribute table and click the "Toggle editing mode" button in the upper left. Then click the "Open Field Calculator" button in the upper right. Check "Update existing field", set the field to pond_count, and in the Expression box enter pond_count - 1:
Hit OK once only, and close the dialog. Save your edits and toggle editing off.
If the ponds have some kind of unique identifier, it should propagate through each step of the process to your final shapefile, which will be a polygon layer of buffers with the count of all ponds within a 1 mile radius.
Sub-question - if one of the buffers dissects a symbol for a pond will it count the pond, or only if the centre point falls within the buffer? (i.e. could the size of the symbol affect the result?)
QGIS and other GISes treat points as a mathematical point (i.e., infinitesimally small). The size of the symbol you use to visualize your data is irrelevant to the calculation. Some spatial query operations may have different results depending on whether a point falls exactly on a polygon boundary (in general GIS terminology, the difference between "contains" and "contains completely"), but I'm pretty sure the QGIS Points-in-Polygon tool will count a point on the edge as being within the polygon. I haven't tested it though. It's unlikely to make a difference in this dataset. It's more likely to be important in a situation where points and polygons are constructed on some common base, such as a street grid, and you need to decide what to do with points that fall at the exact boundary between two neighboring polygons.
Best Answer
You should use the Table > Update Column command to calculate the population. Depending on how your population data is stored (point or polygon), how the dialog is filled out will differ:
In the examples:
CatchPopn is the attribute in the drivetime catchments table DTCatch that will receive the calculated population count
PopnCol is the population count attribute in the population source table Population
Points
Polygons
You might also want to look up dasymetric areal interpolation techniques.