Skip to main content
Solved

Changing attribute types of dataset

  • February 27, 2019
  • 4 replies
  • 683 views

jugoslaviaa
Enthusiast
Forum|alt.badge.img+6

Hello,

I have a street centerline data set which has street width information. I would like to buffer the lines by using GeographicallyBufferer based on the width information (to be more precise sum(div(@Value(SURFACEWID),2),16.4042) is my buffer size). However I can not because the street width attribute has long type. Is there any way to change it so that I could use the value of the attribute and use aritmetics with it.

Thanks in advance.

Best answer by david_r

If you need to change the data type of an existing table, you have a few options:

  • Use the data format administration tool (ArcCatalog, PgAdmin, etc) to try and change the data type, when possible
  • Use FME and copy the data into a new table with the modified data type, then delete the old table.
  • Recreate the table from scratch with the correct data type, then reload the data.

 

View original
Did this help you find an answer to your question?

4 replies

david_r
Celebrity
  • Best Answer
  • February 27, 2019

If you need to change the data type of an existing table, you have a few options:

  • Use the data format administration tool (ArcCatalog, PgAdmin, etc) to try and change the data type, when possible
  • Use FME and copy the data into a new table with the modified data type, then delete the old table.
  • Recreate the table from scratch with the correct data type, then reload the data.

 


jugoslaviaa
Enthusiast
Forum|alt.badge.img+6
  • Author
  • Enthusiast
  • February 27, 2019
david_r wrote:

If you need to change the data type of an existing table, you have a few options:

  • Use the data format administration tool (ArcCatalog, PgAdmin, etc) to try and change the data type, when possible
  • Use FME and copy the data into a new table with the modified data type, then delete the old table.
  • Recreate the table from scratch with the correct data type, then reload the data.

 

Thanks for the answer @david_r. What do you mean by copy data into new table? Which transformer does allow me to do that?


david_r
Celebrity
  • February 27, 2019
jugoslaviaa wrote:

Thanks for the answer @david_r. What do you mean by copy data into new table? Which transformer does allow me to do that?

No transformer necessary, just Reader -> Writer.


jugoslaviaa
Enthusiast
Forum|alt.badge.img+6
  • Author
  • Enthusiast
  • February 27, 2019

thanks @david_r! I went for option 2 and it does work.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings