3

Over the past couple of months, I have seen a few esri-geodatabases and they seem to be either a text field with a length of 20 or 30. Is 30 the maximum field length?

Clarification: The answer I'm looking for is if there is a Cityworks-specific constraint on the text field length in the esri geodatabase.

Improve this question
2

2 Answers 2

Reset to default
2

I was forwarded an email from a Cityworks CST stating the max field length for a Cityworks FacilityID field is 50.

Improve this answer
1

According to this, the maximum text field length for a file geodatabase is about 2GB. (Not that I've tried that, of course, but I've seen fields as long as 1024 characters.)

UPDATE: If Cityworks Geodatabase is a personal geodatabase (based on MS Access), then the maximum character length for a Text field is 255. See here (at the very bottom).

Improve this answer
4
  • So if I specify a FacilityID of 1024 (not that I would actually do that), Cityworks will accept it? I'll update the question and try to clarify the question.
    – Jay Cummins
    Commented Jan 13, 2011 at 15:47
  • 1
    @Jay Why not just try that to see whether it works? :-)
    – whuber
    Commented Mar 6, 2011 at 4:42
  • At the time, we didn't have actually have Cityworks, but had selected Cityworks (govt red-tape at work). We were creating new featureclasses that we knew would be used in Cityworks. I don't work there anymore, but they still don't have Cityworks--red-tape was extra sticky.
    – Jay Cummins
    Commented Mar 6, 2011 at 11:37
  • 1
    btw, Cityworks says the max field length for a FacilityID field is 50. I mentioned it as a comment and thought someone else would make an answer out of it, but it's been long enough so I'll do it!
    – Jay Cummins
    Commented Mar 6, 2011 at 11:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.