-
Notifications
You must be signed in to change notification settings - Fork 524
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
convert csv census tract to text in browser version #575
Comments
Yes, that allowed the join to work. Thanks! 2 follow-ups, I had looked
through the command list and didn't see anything as direct and helpful as
your email... is there someplace I should have looked to find out about the
use of "import options?" And, when I saved the joined file as geojson I
got this message: RFC 7946 warning: non-WGS84 GeoJSON output. Tip: use
"-proj wgs84" to convert. Should I have type -proj wgs84 in the join
command line?
…On Wed, Feb 22, 2023 at 12:43 PM Matthew Bloch ***@***.***> wrote:
Are you using the website (as opposed to the command line program)? If so,
the problem is that you have already imported the CSV file, and the
Tractmatch field was converted to numbers when the file was imported. You
can enter string-fields=Tractmatch when the CSV is imported (see "Import
options" in the image below). Then the join should work.
[image: image]
<https://user-images.githubusercontent.com/1232222/220754250-e1ee3cc4-55be-43bf-bc41-2ed95a3224f2.png>
—
Reply to this email directly, view it on GitHub
<#575 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/A6CEWP56WE4G23BVAFKD7IDWYZ27HANCNFSM6AAAAAAVEX5KPI>
.
You are receiving this because you authored the thread.Message ID:
***@***.***>
--
*Chip Halbach*
***@***.***
612-396-2057
|
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
I've tried different approaches but cannot get my CSV census tract field Tractmatch to show as text so I can join with a shape file matching field, TRACTCE20 Here is what I wrote as a command at the $ prompt:
join RamseyCrimeIndex3.csv keys=TRACTCE20,Tractmatch string-fields=Tractmatch
I also tried replacing string-fields with field-types:Tractmatch:str
I get an error join keys have mismatched data types, string and number.
The text was updated successfully, but these errors were encountered: