Questions tagged [conversion]

Data conversion is the process of transferring/translating data from one format to another. In the context of Open Data SE, typically this involves converting data from a proprietary data format, to an open data format.

Filter by
Sorted by
Tagged with
1 vote
0 answers
20 views

U.S. rail terminal location county correspondence table

Does anyone know of a place to get a correspondence table between standard point location codes (SPLC) or freight station accounting codes (FSAC), and county-level federal information processing ...
user avatar
1 vote
0 answers
216 views

How to Convert https://tangrams.github.io/heightmapper coordinates to decimal latitude longitude

how to convert This: 9.70833/36.7798/-478.5508 to decimal latitude longitude to see this location on google maps https://tangrams.github.io/heightmapper/#9.70833/36.7798/-478.5508 my first question ...
user avatar
  • 11
2 votes
0 answers
264 views

Extracting data from PDF tables with multi-line rows: tabula

I am trying to convert large tables in PDF form to CSVs. I was wondering if there are recommendations for how to extract tables in which rows span multiple lines as in the tabula example here? My own ...
user avatar
  • 21
1 vote
0 answers
59 views

How to import a SAS layout or Data Dictionary

Being totally new to SAS, I don't know how to import this layout/dictionary file into SAS® Studio: ********************************************* * ...
user avatar
2 votes
1 answer
126 views

90ies Windows .exe database on CD: Extract underlying data

I would like to extract data from a register stored on a CD from the 90ies. The Windows executable on the CD allows one to browse the database with keywords and by specific variables. However, there ...
user avatar
  • 153
5 votes
1 answer
133 views

Tools and steps for converting 3-star data to 4 star

I am working on a project to upgrade a set of 3-star open data (mostly in CSV and JSON formats) to a 4-star level. I would like to know if there is any guideline for doing so? What tools may be needed ...
user avatar
  • 51
2 votes
1 answer
200 views

Working with Sample Surveys, Statistical Packages, and Fixed Format ASCII Data (.dct ,.do, .sas, .sps) and .dat

US Department of Education sent me National Household Education Surveys Program data via cd-rom and I'm looking for tips/software/best-practices here for converting/viewing/manipulating this data. ...
user avatar
  • 11.8k
8 votes
12 answers
3k views

Best way to convert Excel Files to Open Data Formats

We have plenty of data buried in a lot of Excel files (.xls, .xlsx). The data comprises mainly statistics (first row comtains colum headers, first column contains row headers, rest of data are decimal ...
user avatar
  • 449
8 votes
2 answers
1k views

How can I convert from Census 2010 tracts to Census 2000 tracts?

I have a dataset (it's a bunch of count variables) at the Census 2010 census tract level, and I want to merge it to a bunch of other datasets that are at the Census 2000 tract level. Because it would ...
user avatar
  • 155
5 votes
2 answers
818 views

Is there a tool to convert geoRSS into geoJSON?

I have a geoRSS file that I would like to convert to geoJSON to use it with Leaflet. I found MyGeodata Converter (mentioned on What are the most useful formats in which to release geospatial data?), ...
user avatar
  • 125
13 votes
5 answers
371 views

How to publish open data on my website? (Or: from CSV to RDFa)

I already spent some time importing data in a tabular form from a PDF published by an official institution. I would like to publish this table on my website. The data is nicely formatted in CSV. Is ...
user avatar
  • 231
15 votes
6 answers
394 views

What is the best way to request machine readable data from a FOIA request?

Maybe there is no way to request a specific file type but what is the best way to request a file (paper or digital) that can be converted easiestly?
user avatar