convert csv census tract to text in browser version

[cbach1620]

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.

[mbloch]

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.

[cbach1620]

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