Comprehensive list of Content_Type values in Attachment Tables?

AlfredBaldenweck — Wed, 27 Apr 2022 19:15:09 GMT

Hi all,

I was wondering if there's a comprehensive list of values for the "Content_Type" field in an attachment table?

I'd be fine with even a list of prefixes (image, application)

I see someone else had this question elsewhere but it was never answered.

Thanks!

Re: Comprehensive list of Content_Type values in Attachment Tables?

jcarlson — Wed, 27 Apr 2022 19:23:09 GMT

I think the answer is "there isn't one".

You can attach pretty much anything you want.

Re: Comprehensive list of Content_Type values in Attachment Tables?

AlfredBaldenweck — Wed, 27 Apr 2022 19:26:49 GMT

Thanks for the reply, Josh

I'm trying to filter some stuff based on content type, and knowing what all the options are would help.

Most of the examples you used would appear as "Unknown"

Re: Comprehensive list of Content_Type values in Attachment Tables?

jcarlson — Wed, 27 Apr 2022 19:54:39 GMT

Interesting... the exe comes in as application/x-msdownload, the tarball as application/x-gzip. The others, "Unknown".

I'd originally misunderstood the post, but I see what you mean now. According to the Pro SDK docs, it's just pulling in the MIME type. I tried adding a few random selections from the full list of MIME types, and most came in as "Unknown". Clearly, there's a subset list of MIME types that Pro is recognizing, but I can't seem to find it.

I would agree that having the comprehensive list would be useful.

Re: Comprehensive list of Content_Type values in Attachment Tables?

jcarlson — Wed, 27 Apr 2022 20:05:26 GMT

Here we go. Browse to C:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3\Lib and look for the file mimetypes.py.

In that file, scroll to line 413 to find the types_map, re-posted here:

types_map = _types_map_default = { '.js' : 'application/javascript', '.mjs' : 'application/javascript', '.json' : 'application/json', '.doc' : 'application/msword', '.dot' : 'application/msword', '.wiz' : 'application/msword', '.bin' : 'application/octet-stream', '.a' : 'application/octet-stream', '.dll' : 'application/octet-stream', '.exe' : 'application/octet-stream', '.o' : 'application/octet-stream', '.obj' : 'application/octet-stream', '.so' : 'application/octet-stream', '.oda' : 'application/oda', '.pdf' : 'application/pdf', '.p7c' : 'application/pkcs7-mime', '.ps' : 'application/postscript', '.ai' : 'application/postscript', '.eps' : 'application/postscript', '.m3u' : 'application/vnd.apple.mpegurl', '.m3u8' : 'application/vnd.apple.mpegurl', '.xls' : 'application/vnd.ms-excel', '.xlb' : 'application/vnd.ms-excel', '.ppt' : 'application/vnd.ms-powerpoint', '.pot' : 'application/vnd.ms-powerpoint', '.ppa' : 'application/vnd.ms-powerpoint', '.pps' : 'application/vnd.ms-powerpoint', '.pwz' : 'application/vnd.ms-powerpoint', '.wasm' : 'application/wasm', '.bcpio' : 'application/x-bcpio', '.cpio' : 'application/x-cpio', '.csh' : 'application/x-csh', '.dvi' : 'application/x-dvi', '.gtar' : 'application/x-gtar', '.hdf' : 'application/x-hdf', '.latex' : 'application/x-latex', '.mif' : 'application/x-mif', '.cdf' : 'application/x-netcdf', '.nc' : 'application/x-netcdf', '.p12' : 'application/x-pkcs12', '.pfx' : 'application/x-pkcs12', '.ram' : 'application/x-pn-realaudio', '.pyc' : 'application/x-python-code', '.pyo' : 'application/x-python-code', '.sh' : 'application/x-sh', '.shar' : 'application/x-shar', '.swf' : 'application/x-shockwave-flash', '.sv4cpio': 'application/x-sv4cpio', '.sv4crc' : 'application/x-sv4crc', '.tar' : 'application/x-tar', '.tcl' : 'application/x-tcl', '.tex' : 'application/x-tex', '.texi' : 'application/x-texinfo', '.texinfo': 'application/x-texinfo', '.roff' : 'application/x-troff', '.t' : 'application/x-troff', '.tr' : 'application/x-troff', '.man' : 'application/x-troff-man', '.me' : 'application/x-troff-me', '.ms' : 'application/x-troff-ms', '.ustar' : 'application/x-ustar', '.src' : 'application/x-wais-source', '.xsl' : 'application/xml', '.rdf' : 'application/xml', '.wsdl' : 'application/xml', '.xpdl' : 'application/xml', '.zip' : 'application/zip', '.au' : 'audio/basic', '.snd' : 'audio/basic', '.mp3' : 'audio/mpeg', '.mp2' : 'audio/mpeg', '.aif' : 'audio/x-aiff', '.aifc' : 'audio/x-aiff', '.aiff' : 'audio/x-aiff', '.ra' : 'audio/x-pn-realaudio', '.wav' : 'audio/x-wav', '.bmp' : 'image/bmp', '.gif' : 'image/gif', '.ief' : 'image/ief', '.jpg' : 'image/jpeg', '.jpe' : 'image/jpeg', '.jpeg' : 'image/jpeg', '.png' : 'image/png', '.svg' : 'image/svg+xml', '.tiff' : 'image/tiff', '.tif' : 'image/tiff', '.ico' : 'image/vnd.microsoft.icon', '.ras' : 'image/x-cmu-raster', '.bmp' : 'image/x-ms-bmp', '.pnm' : 'image/x-portable-anymap', '.pbm' : 'image/x-portable-bitmap', '.pgm' : 'image/x-portable-graymap', '.ppm' : 'image/x-portable-pixmap', '.rgb' : 'image/x-rgb', '.xbm' : 'image/x-xbitmap', '.xpm' : 'image/x-xpixmap', '.xwd' : 'image/x-xwindowdump', '.eml' : 'message/rfc822', '.mht' : 'message/rfc822', '.mhtml' : 'message/rfc822', '.nws' : 'message/rfc822', '.css' : 'text/css', '.csv' : 'text/csv', '.html' : 'text/html', '.htm' : 'text/html', '.txt' : 'text/plain', '.bat' : 'text/plain', '.c' : 'text/plain', '.h' : 'text/plain', '.ksh' : 'text/plain', '.pl' : 'text/plain', '.rtx' : 'text/richtext', '.tsv' : 'text/tab-separated-values', '.py' : 'text/x-python', '.etx' : 'text/x-setext', '.sgm' : 'text/x-sgml', '.sgml' : 'text/x-sgml', '.vcf' : 'text/x-vcard', '.xml' : 'text/xml', '.mp4' : 'video/mp4', '.mpeg' : 'video/mpeg', '.m1v' : 'video/mpeg', '.mpa' : 'video/mpeg', '.mpe' : 'video/mpeg', '.mpg' : 'video/mpeg', '.mov' : 'video/quicktime', '.qt' : 'video/quicktime', '.webm' : 'video/webm', '.avi' : 'video/x-msvideo', '.movie' : 'video/x-sgi-movie', }

Re: Comprehensive list of Content_Type values in Attachment Tables?

AlfredBaldenweck — Wed, 27 Apr 2022 21:47:33 GMT

This is great. Thank you so much for tracking that down.

Re: Comprehensive list of Content_Type values in Attachment Tables?

YuriiYanov — Thu, 15 Feb 2024 07:28:51 GMT

Well interesting, found 2 .bmp types is it any error or how it understand:

'.bmp' : 'image/x-ms-bmp', '.bmp' : 'image/bmp',

topic Re: Comprehensive list of Content_Type values in Attachment Tables? in ArcGIS Pro Questions

Comprehensive list of Content_Type values in Attachment Tables?

Re: Comprehensive list of Content_Type values in Attachment Tables?

Re: Comprehensive list of Content_Type values in Attachment Tables?

Re: Comprehensive list of Content_Type values in Attachment Tables?

Re: Comprehensive list of Content_Type values in Attachment Tables?

Re: Comprehensive list of Content_Type values in Attachment Tables?

Re: Comprehensive list of Content_Type values in Attachment Tables?