Calgary Input tool

When i select a Calgary data file with Calgary input tool, i couldn't write query due to there is no field names under fields section. Does anyone could give me some suggestion? Thanks! Sharon

Datasets

Calgary

Accepted answers

rohanonline

It may be worth checking -

* is the input file extension .cydb?

* what are the datatypes of the fields - you can check this by using normal input tool for the file and having a select tool

I can't think of other reasons right now. Is it possible to share some extract of that file?

All comments

rohanonline

It may be worth checking -

* is the input file extension .cydb?

* what are the datatypes of the fields - you can check this by using normal input tool for the file and having a select tool

I can't think of other reasons right now. Is it possible to share some extract of that file?

sharon_liu

Yes. The input file extension is .cydb. The Calgary datasets contain these columns

Field	Type	Size
Field 1	V_WString	32
Field 2	SpatialObj	536870911
Field 3	String	5
Field 4	V_String	254
Field 5	V_String	254
Field 6	String	3
Field 7	V_String	254
Field 8	V_String	3
Field 9	Double	8

Thanks a lot for your help

Sharon

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703