US Cemetery List and Database


DOWNLOAD IMMEDIATELY AFTER PURCHASE!
US Cemeteries List and Database
Single-site license
$39.95


The US Cemeteries List and Database download is a very useful tool for Genealogy researchers, Webmasters, SEO consultants, and Pay Per Click marketers.

Our US Cemeteries List and Database contains 138,407 precise data records for US cemeteries, each with 11 columns of useful data. Last updated on August 1, 2011. The data is formatted as a CSV file and thus can be easily imported into MySQL (see MySQL instructions below), Microsoft SQL Server, Oracle, PostgreSQL, and any other database. This product is a great time saver and you may use it as an information source, a web site development resource or for a genealogy development project. In short our product allows you to create applications which target cemetery locations geographically across the country. We understand you are looking for information and you need it right now! No need to wait any longer - our cemeteries database becomes available for immediate download upon purchase.

Fields in the US Cemeteries List and Database


Name Type Description
id Number Unique cemetery record identifier.
cemetery_name Character Official cemetery name as defined in INCITS 446-2008, Identifying Attributes for Named Physical and Cultural Geographic Features (Except Roads and Highways) of the United States, Its Territories, Outlying Areas, and Freely Associated Areas, and the Waters of the Same to the Limit of the Twelve-Mile Statutory Zone.
state_abbrev Character The unique two letter alphabetic code and the unique two number code for a US State as specified in INCITS 38:200x, (Formerly FIPS 5-2) Codes for the Identification of the States, the District of Columbia, Puerto Rico, and the Insular Areas of the United States.
state_code Character
county_name Character The name and unique three number code for a county or county equivalent as specified in INCITS 31:200x, (Formerly FIPS 6-4) Codes for the Identification of Counties and Equivalent Entities of the United States, its Possessions, and Insular Areas.
county_code Character
lat_dms Character The official cemetery location as defined in INCITS 446-2008, Identifying Attributes for Named Physical and Cultural Geographic Features (Except Roads and Highways) of the United States, Its Territories, Outlying Areas, and Freely Associated Areas, and the Waters of the Same to the Limit of the Twelve-Mile Statutory Zone.

NAD 83
DMS-degrees/minutes/seconds
DEC-decimal degrees.

Note: Records showing "Unknown" and zeros for the latitude and longitude DMS and decimal fields, respectively, indicate that the coordinates of the feature are unknown. They are recorded in the database as zeros to satisfy the format requirements of a numerical data type. They are not errors and do not reference the actual geographic coordinates at 0 latitude, 0 longitude.
long_dms Character
lat_dec Number
long_dec Number
elev_in_m  Number Elevation in meters above (-below) sea level of the surface at the primary coordinates from National Elevation Dataset
elev_in_ft  Number Elevation in feet above (-below) sea level of the surface at the primary coordinates from National Elevation Dataset

US Cemeteries List and Database sample data

You may want to download and evaluate our US Cemeteries List and Database sample data to make sure you understand what you are going to get before you make the purchase decision. Our sample data includes about 140 records and will allow you to familiarize yourself with our data format, practice the import procedure, run SQL queries etc.

Download US Cemeteries List and Database sample data


How to import the US Cemeteries list and database to MySQL

First create a table for the data using something like this:

CREATE TABLE `us_cemeteries` (
  `id` int(6) NOT NULL,
  `cemetery_name` varchar(110) NOT NULL,
  `state_abbrev` varchar(2) NOT NULL,
  `state_code` varchar(2) NOT NULL,
  `county_name` varchar(26) NOT NULL,
  `county_code` varchar(3) NOT NULL,
  `lat_dms` varchar(7) NOT NULL,
  `long_dms` varchar(8) NOT NULL,
  `lat_dec` decimal(9,7) NOT NULL,
  `long_dec` decimal(10,7) NOT NULL,
  `elev_in_m` varchar(5) NOT NULL,
  `elev_in_ft` varchar(5) NOT NULL,
  PRIMARY KEY (`id`)
) CHARSET=utf8;

Of course you may decide to use another table name. The next and final step is to run the 'load data' command to place the data in the table created in the first step.

load data infile 'your_path_here/us_cemeteries.csv' 
into table us_cemeteries
fields terminated by ',' 
optionally enclosed by '"' 
lines terminated by '\r\n';

What if the target database is on a remote computer? In that case you first need to connect your MySQL Command Line Client to the remote server. Something like this

mysql --host=www.yourdomainname.com -Dyourdatabasename --password=yourpassword --user=yourusername

Then use the 'load data' command but this time with the 'local' optionm

load data local infile 'your_path_here/us_cemeteries.csv' 
into table us_cemeteries
fields terminated by ',' 
optionally enclosed by '"' 
lines terminated by '\r\n';

How to get the list of cemeteries in a specific county?

For example you want the list of cemeteries in Fulton County, Georgia. Use a SQL query like this:

SELECT * from us_cemeteries
WHERE state_abbrev='GA' AND county_name='Fulton' 
ORDER BY cemetery_name

How to make use of the latitude and longtitude paramaters?

They can be used for example to show location of a cemetery using Google Maps API. You will use 'lat_dec' and 'long_dec' for this purpose. The code to map Lea Cemetery near North Little Rock, Arkansas will look something like this:

var map;
function initialize() {
    var myOptions = {
        zoom: 8,
        center: new google.maps.LatLng(34.8223128, -92.2134817),
        mapTypeId: google.maps.MapTypeId.ROADMAP
    };
    map = new google.maps.Map(document.getElementById('map_canvas'), myOptions);
    var marker = new google.maps.Marker({position: myOptions.center, map: map, title:"Lea Cemetery"});   
}
google.maps.event.addDomListener(window, 'load', initialize);

This code uses Google Maps JavaScript API v3. Please feel free to view the html source code of this article to see all of the details of displaying the map. The final result is visible below.

How to find all cemeteries near given city?

This is a frequent question that many mapping and genealogy research applications must be able to solve. Our solution assumes you also have US City and County List and Database for web developers installed. First we have to create two indexes on the us_cemeteries table:

ALTER TABLE `us_cemeteries` 
ADD INDEX `lat_dec_idx` (`lat_dec` ASC), 
ADD INDEX `long_dec_idx` (`long_dec` ASC);

The next step is to add a spatial search stored procedure to perform all of the 'heavy lifting'

DELIMITER $$
CREATE PROCEDURE cemeteries_near_city(IN populated_place_id int, IN dist int)
BEGIN
declare long1 double; 
declare long2 double;
declare lat1 double; 
declare lat2 double;
declare mylat double;
declare mylon double;
SELECT long_dec, lat_dec INTO mylon, mylat 
FROM cities_and_counties 
WHERE id = populated_place_id LIMIT 1;
set lat1 = mylat-(dist/69); 
set long1 = mylon-dist/abs(cos(radians(mylat))*69);
set lat2 = mylat+(dist/69);
set long2 = mylon+dist/abs(cos(radians(mylat))*69);
SELECT id,cemetery_name,county_name,lat_dec,long_dec, 
3956 * 2 * ASIN(SQRT(POWER(SIN((mylat - lat_dec) * 
pi()/180 / 2), 2) + COS(mylat * pi()/180) *
COS(lat_dec * pi()/180) * POWER(SIN((mylon - long_dec) * 
pi()/180 / 2), 2) )) AS distance 
FROM us_cemeteries 
WHERE long_dec between long1 AND long2
AND lat_dec BETWEEN lat1 AND lat2
HAVING distance < dist ORDER BY distance;
END $$ 
DELIMITER ;

Now, assume you want to find all cemeteries within 15 miles from Missoula, MT. You need to lookup Missoula, MT in the cities_and_counties table. This will reveal the record id of this city, which is 715262. We are ready to call the stored procedure declared above and pass the id and distance in miles:

mysql> call cemeteries_near_city(715262, 15);
+--------+---------------------------+-------------+------------+--------------+-------------------+
| id     | cemetery_name             | county_name | lat_dec    | long_dec     | distance          |
+--------+---------------------------+-------------+------------+--------------+-------------------+
| 717687 | Saint Mary Cemetery       | Missoula    | 46.8802014 | -114.0087210 | 0.890059742232603 |
| 717688 | Saint Mary Cemetery       | Missoula    | 46.8874237 | -113.9981651 |  1.07302677551624 |
| 715263 | Missoula Cemetery         | Missoula    | 46.8929792 | -114.0209435 |  1.91991447821854 |
| 716882 | Post Cemetery             | Missoula    | 46.8468678 | -114.0576109 |  3.47362506650278 |
| 719460 | Sunset Memorial Gardens   | Missoula    | 46.8904788 | -114.1015012 |  5.22893442097235 |
| 711324 | Florence-Carlton Cemetery | Missoula    | 46.6788120 | -114.0789974 |  13.9407614744006 |
| 711515 | Frenchtown Cemetery       | Missoula    | 47.0154778 | -114.2156722 |  14.3918803386836 |
+--------+---------------------------+-------------+------------+--------------+-------------------+
7 rows in set (0.00 sec)

Query OK, 0 rows affected (0.03 sec)

A PHP/MySQL solution would in most cases create indexes and the stored procedure from the phpMyAdmin and call the stored procedure from the PHP code.


NOTE: This list can be used in conjunction with US State List for web developers., US City and County List and Database for web developers, and US Churches List and Database for web developers.

Share this article!    Bookmark US Cemetery List and Database at Delicious Digg US Cemetery List and Database Share US Cemetery List and Database with your Twitter followers Share US Cemetery List and Database at StumbleUpon Add US Cemetery List and Database to your Technorati favorites Share US Cemetery List and Database on Facebook Share US Cemetery List and Database on Blinklist Share US Cemetery List and Database on Diigo Share US Cemetery List and Database on Reddit Share US Cemetery List and Database on Linked In Seed the vine with US Cemetery List and Database Share US Cemetery List and Database on Mixx Share US Cemetery List and Database on DZone