maximum limits of Hosted Feature Service

3545
1
03-13-2014 05:57 PM
DanMallett
Esri Contributor
Anyone know where to find:

-maximum number of fields in a hosted feature service
-max/min value of Integer (webmap won't allow you to enter anything beyond +/- 999,999,999,999,999 but this may be a UI limit)
-max/min value of Float (webmap won't allow you to enter anything beyond +/- 999,999,999,999,999)
-max/min value of Date (webmap seems to allow 1/1/0100 to 12/31/9999)
-max length of String (I think this is 2GB or approx 1 billion characters)
-maximum number of attachments (assuming sufficient credits)
-maximum attachment size (assuming sufficient credits)

Thanks!
Tags (2)
1 Reply
KhaledHassen
Esri Contributor

Here are some numbers for online FS:

>maximum number of fields in a hosted feature service

You can define up to 30K fields per table. But you might have issues in the platform if you define very large number of fields specially when integrating server/offline/online since this involves different geodatabases that have different limits. But the number is sufficiently large and will support 30K limit.


-max/min value of Integer (webmap won't allow you to enter anything beyond +/- 999,999,999,999,999 but this may be a UI limit) 

Online/server have the limits of the data type value short (esriFieldTypeShort = 2 bytes) versus integer (esriFieldTypeinteger = 4 bytes) versus long (8 bytes = bigint). 

As you know the formula is:

max = 2^(n-1) here n=32 for 4 bytes integer.

for instance min/max for esriFieldTypeInteger = [-2,147,483,648, 2,147,483,647]


>-max/min value of Float (webmap won't allow you to enter anything beyond +/- 999,999,999,999,999) 

The range is the float (4 bytes, 7 digits precision = esriFieldTypeFloat):

[- 3.40E + 38, 3.40E + 38]

>-max/min value of double (esriFieldTypeDouble) 

The range is the double (8 byte, 15 digits precision):

Very large value:

[- 1.79E+308, 1.79E+308]

>-max/min value of Date (webmap seems to allow 1/1/0100 to 12/31/9999)

Actually this is the limit: 0001-01-01 through 9999-12-31


>-max length of String (I think this is 2GB or approx 1 billion characters)

To index a string column in online, the string column needs to be less than 4000 chars.

But if you define the column size = -1 or more than 4000, the max is used (2^30-1 number of chars) but you will not be able to add an index on that string column.


>maximum number of attachments (assuming sufficient credits) 

No limits


>maximum attachment size (assuming sufficient credits) 

Also no limits but we have a 10M limit in the size of the attachment you are adding as a single part attachment from the API. Adding multi part attachment has no limit. So you can add technically add video/etc as a multipart attachment in online. Pl. Let us know if you have this case and we can show best practice of reading such attachments. Pl. note we do support resizing attachment images in online for large size attachment images from the API (w=100 up to w = 2400 and preserving the aspect ratio of the original attachment).

Hope that helps.

Khaled