Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

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.

share|improve this question
    
Maybe extension-specific questions should not be on this site or did I ask this question poorly?? –  Jay Cummins Jan 13 '11 at 15:53
    
See meta.gis.stackexchange.com/questions/269/… in meta. –  Jay Cummins Jan 13 '11 at 16:13

3 Answers 3

I have tried to find specification information for cityworks dbs before. Extremely hard to find. You might have to find a customer and ask them to find out for you.

I don't even think I've found a good forum for cityworks.

share|improve this answer
    
Yes. That is what I did. Twice. Different answers: 30 and 50! But the 50 value came a forwarded email from Cityworks CST. –  Jay Cummins Jan 13 '11 at 20:57

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).

share|improve this answer
    
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 Jan 13 '11 at 15:47
1  
@Jay Why not just try that to see whether it works? :-) –  whuber Mar 6 '11 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 Mar 6 '11 at 11:37
    
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 Mar 6 '11 at 11:39
up vote 1 down vote accepted

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

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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