HELP NEEDED - Camera Database

Started by Mario, April 25, 2018, 12:01:43 PM

Previous topic - Next topic

Mario

I want to update the camera database IMatch users for various purposes.
It's fairly up-to-date right now, but I need to add as many currently used models as possible.

It would be great if you can send me (just reply below) the following info:

1. Camera Make
2. Camera Model
3. Crop Factor or sensor size (w/h) in inches or mm.


How to Find Make and Model

To get the precise make and model for your camera model, use the following variables to the Var Toy:

{File.MD.make}
{File.MD.model}


Note: Camera vendors sometimes use different spellings for the make. Camera models are sometimes named differently, in different countries. We need the exact values.

I'm especially interested in Smart Phones and Tablets.

How to Find the Crop Factor

For this you need to lookup the crop factor in your camera manual or on the Internet.
Google for My Camera Name crop factor, for example.

Alternatively, you can calculate the crop factor from the sensor size. The sensor size should be documented in your camera manual or on the Internet.
To calculate the crop factor, use the following formula:

1. my_sensor_diagonal = √ (width² + height²)    width/height in mm, not inches!

2. Crop factor = 43.27 / my_sensor_diagonal

If the math is over your head, just post your make, model and sensor dimensions and I do the rest.

I could to this myself (and did so, in the past), but this is very time-consuming. You only need to lookup one or maybe 2 models. I need to lookup dozens or hundreds...



-- Mario
IMatch Developer
Forum Administrator
http://www.photools.com  -  Contact & Support - Follow me on 𝕏 - Like photools.com on Facebook

zematima

Hi:

Make - Wiko
Model - Wim
Crop factor - 7.37515

Best regards,
JRosa.



Mario

Thanks. A new brand, didn't had that before!  :)
-- Mario
IMatch Developer
Forum Administrator
http://www.photools.com  -  Contact & Support - Follow me on 𝕏 - Like photools.com on Facebook

DigPeter

#3
My main cameras over recent years are:

Make                Model                    Crop factor

Huawei                      BTV-DL09                         ~7.37             a tablet

Sony                         RX100M3                           2.7

Panasonic                  DMC-FZ200                        5.62

Panasonic                  DMC-FZ50                          4.87

Panasonic                  DMC-FZ100                         5.69   

Panasonic                  DMC-FZ38                               5.69

Carlo Didier

Found these in my database. Crop factors found on https://www.digicamdb.com/specs

And no, I did not own all of those cameras, only a few of them. I just happen to have images made by these cameras.

{File.MD.make}
{File.MD.model}
crop factor

Minolta Co., Ltd.
DiMAGE 5
4.87

NIKON CORPORATION
NIKON D3200
1.5

NIKON CORPORATION
NIKON D600
1

NIKON CORPORATION
NIKON D60
1.52

NIKON CORPORATION
NIKON D90
1.52

NIKON CORPORATION
NIKON 1 J1
2.73

Nikon
LS-5000
(1) slide/negative scanner

NIKON
COOLPIX L10
(1) slide/negative scanner

Canon
Canon EOS-1Ds Mark II
1

Canon
Canon EOS 1000D
1.62

Canon
Canon EOS 10D
1.59

Canon
Canon EOS 20D
1.6

Canon
Canon EOS 30D
1.6

Canon
Canon EOS 40D
1.62

Canon
Canon EOS 5D Mark III
1

Canon
Canon PowerShot A3000 IS
5.62

Canon
Canon PowerShot A400
7.7

Canon
Canon PowerShot S2 IS
6.02

Canon
Canon PowerShot S45
4.87

SONY
DSLR-A200
1.52

SONY
DSLR-A700
1.53

KONICA MINOLTA
DYNAX 7D
1.53

Minolta
Scan Dual II
(1) slide/negative scanner

FUJIFILM
X-T2
1.53

OLYMPUS CORPORATION
E-M10MarkII
2

OLYMPUS IMAGING CORP.
E-M5
2

FUJIFILM
FinePix S7000
4.6

FUJIFILM
FinePix Z100fd
6.02

EASTMAN KODAK COMPANY
KODAK DC280 ZOOM DIGITAL CAMERA
4.6

EASTMAN KODAK COMPANY
KODAK DX6490 ZOOM DIGITAL CAMERA
6.02

jch2103

#5
Google
Pixel 2
5.5mm x 4.1mm
(27 mm equivalent)

Google
Pixel XL (same for Pixel)
Sony IMX378 Exmor RS (1.55µm, 1/2.3")
(26mm equivalent)

LGE
Nexus 5
8 MP Sony Exmor IMX179 1/3.2-inch CMOS sensor
4.6032 x 3.5168mm (according to stackexchange: https://photo.stackexchange.com/questions/54054/calculating-the-field-of-view-for-a-nexus-5)
(30.4mm equivalent)

NIKON CORPORATION
NIKON 1 V3
Crop factor 2.7

I assume you're covered for Nikon full frame and crop sensor DSLRs.

John

BanjoTom

1. Nikon
2. D5300
3. Sensor is: 23.5 x 15.6 mm

— Tom, in Lexington, Kentucky, USA

HaWo

PENTAX
PENTAX K-x
1,5

Canon
Canon PowerShot G2
4,8

FUJIFILM
FinePix F100fd
4,3

OLYMPUS CORPORATION
E-M10MarkII
2
Hans-Wolfgang

Lincoln

canon eos m  crop 1.6
sony a6000  crop 1.53

ColinIM

Very glad to help ...

I own or have owned all of these cameras / mobile phones.

The first line for each entry below VarToy's {File.MD.make}
The second line for each entry below is VarToy's {File.MD.model}


NIKON CORPORATION
NIKON D200
Crop Factor = 1.52

NIKON CORPORATION
NIKON D700
Crop Factor = 1.0

OLYMPUS IMAGING CORP.
XZ-1
Crop Factor = 4.41

Panasonic
DMC-TZ7
Crop Factor = 5.69

Panasonic
DC-TZ200
Crop Factor = 2.73

Konica Minolta Camera, Inc.
DiMAGE A2
Crop Factor = 3.93

SAMSUNG
GT-I9195
Mobile phone model: Samsung S4-mini
Camera (front-facing) sensor size: 1920 x 1080 pixels
Camera (rear-facing) sensor size:  3264 x 2448 pixels

Sony Ericsson
W810i
Mobile phone model: Sony Ericsson W810i Walkman
Camera (rear-facing) sensor size: 1632 x 1224 Pixels (generalised to "2.0 MegaPixels")

Mario

Quote from: Lincoln on April 28, 2018, 02:06:06 AM
canon eos m  crop 1.6
sony a6000  crop 1.53

Ar these names really in lower case?
-- Mario
IMatch Developer
Forum Administrator
http://www.photools.com  -  Contact & Support - Follow me on 𝕏 - Like photools.com on Facebook

Ger

{File.MD.make},{File.MD.model},Crop factor
Canon,Canon EOS 20D,1.6
Canon,Canon EOS 350D DIGITAL,1.6
Canon,Canon EOS 50D,1.6
Canon,Canon EOS 5D,1
Canon,Canon EOS 70D,1.6
Canon,Canon EOS 7D Mark II,1.6
Canon.Canon PowerShot A570 IS   ,6.02
Canon,Canon PowerShot SX230 HS,5.62
samsung,SM-G930F,6.14


Ger

meyersoft

Here we go:

Apple
iPhone 5s

Apple
iPhone 6s

Canon
Canon DIGITAL IXUS 55

Canon
Canon DIGITAL IXUS 70

Canon
Canon DIGITAL IXUS 80 IS

Canon
Canon DIGITAL IXUS 95 IS

Canon
Canon DIGITAL IXUS 800 IS

Canon
Canon DIGITAL IXUS 950 IS

Canon
Canon EOS 5D Mark II

Canon
Canon EOS 5D Mark III

Canon
Canon EOS 6D

Canon
Canon EOS 7D

Canon
Canon EOS 7D Mark II

Canon
Canon EOS 10D

Canon
Canon EOS 40D

Canon
Canon EOS 50D

Canon
Canon EOS 60D

Canon
Canon EOS 70D

Canon
Canon EOS 300D DIGITAL

Canon
Canon EOS 350D DIGITAL

Canon
Canon EOS 400D DIGITAL

Canon
Canon EOS 450D

Canon
Canon EOS 550D

Canon
Canon EOS 700D

Canon
Canon EOS-1D Mark III

Canon
Canon EOS-1D X

Canon
Canon EOS-1Ds Mark II

Canon
Canon IXUS 105

Canon
Canon IXUS 115 HS

Canon
Canon PowerShot A10

Canon
Canon PowerShot A40

Canon
Canon PowerShot A70

Canon
Canon PowerShot A430

Canon
Canon PowerShot A620

Canon
Canon PowerShot G15

Canon
Canon PowerShot SX1 IS

Canon
Canon PowerShot SX230 HS

Canon
EOS 60D

CASIO
QV-4000

CASIO COMPUTER CO.,LTD.
EX-N20

CASIO COMPUTER CO.,LTD.
EX-Z19

CASIO COMPUTER CO.,LTD.
EX-Z120

EASTMAN KODAK COMPANY
KODAK DC4800 ZOOM DIGITAL CAMERA

EASTMAN KODAK COMPANY
KODAK EASYSHARE Z710 ZOOM DIGITAL CAMERA

Eastman Kodak Company
DC210 Zoom (V01.51)

Eastman Kodak Company
KODAK DIGITAL SCIENCE DC260 (V01.00)

FUJICOLOR EUROPE
IS Rescan

FUJIFILM
FinePix A330

FUJIFILM
FinePix F401

FUJIFILM
FinePix HS10 HS11

FUJIFILM
FinePix J27 J28 J29

HUAWEI
U8510

Medion
MD86372

Minolta Co., Ltd.
DiMAGE F100

Minolta Co., Ltd.
DiMAGE Z1

NIKON
COOLPIX L10

NIKON
COOLPIX S3000

NIKON
COOLPIX S5100

NIKON
E4600

NIKON CORPORATION
NIKON D2X

NIKON CORPORATION
NIKON D40

NIKON CORPORATION
NIKON D50

NIKON CORPORATION
NIKON D70s

NIKON CORPORATION
NIKON D80

NIKON CORPORATION
NIKON D200

NIKON CORPORATION
NIKON D3200

NIKON CORPORATION
NIKON D5200

NIKON CORPORATION
NIKON D7000

OLYMPUS CORPORATION
C5060WZ

OLYMPUS IMAGING CORP.
FE320,X835,C540

OLYMPUS IMAGING CORP.
SP590UZ

OLYMPUS IMAGING CORP.
VG120,D705

OLYMPUS OPTICAL CO,.LTD.
C720UZ

OLYMPUS OPTICAL CO.,LTD
C-1Z,D-150Z

OLYMPUS OPTICAL CO.,LTD
C830L,D340R

OLYMPUS OPTICAL CO.,LTD
C3100Z,C3020Z

OLYMPUS OPTICAL CO.,LTD
X200,D560Z,C350Z

Panasonic
DMC-FX7

Panasonic
DMC-FZ20

Panasonic
DMC-FZ28

Panasonic
DMC-FZ150

Panasonic
DMC-LC70

Panasonic
DMC-LZ10

Panasonic
DMC-TZ1

Panasonic
DMC-TZ61

SAMSUNG
GT-I8190

SAMSUNG
GT-I9000

SAMSUNG
GT-I9195

SAMSUNG
GT-I9305

SAMSUNG
GT-S5830

Samsung
GT-S5230

samsung
GT-I9000

samsung
SM-G930F

samsung
SM-J500FN

Samsung Techwin
<KENOX S760  / Samsung S760>

SONY
CYBERSHOT

SONY
DSC-P72

SONY
DSLR-A200

Sorry, too many to look for crop factors.
Puh, there should have been a script...

Mario

Without the crop factors the list is unfortunately of no use.
-- Mario
IMatch Developer
Forum Administrator
http://www.photools.com  -  Contact & Support - Follow me on 𝕏 - Like photools.com on Facebook

Jingo

#14
Quote from: Mario on April 28, 2018, 03:31:12 PM
Without the crop factors the list is unfortunately of no use.

This webpage has most of the info.. you just need to do some quick calcs: https://www.digicamdb.com/cameras/

Pull up all Canons for example and just calculate:

Crop factor =      43.27 mm  /  sensor diagonal in mm    (The sensor diag is right on the page if you pull up say all Canons).


I was thinking of writing a quick app to pull this data automatically... but figured 95% of the camera models have already been reported.. but if there is a need... let me know and I'll see what I can do.

Pescheid

OK. Here is my input:

Canon
Canon PowerShot A70
6.6

Canon
Canon DIGITAL IXUS 70
6.1

FUJIFILM
FinePix S5Pro
1.5

NIKON CORPORATION
NIKON D70
1.5

NIKON CORPORATION
NIKON D200
1.5

NIKON CORPORATION
NIKON D300
1.5

NIKON CORPORATION
NIKON D700
1.0

NIKON CORPORATION
NIKON D810
1.0

Apple
iPhone 5s
6.9

HUAWEI
JMM-L22
7.7

Canon
Canon EOS 5D Mark II
1.0

NIKON CORPORATION
NIKON D7000
1.5


Peter

Mario

Quote from: Jingo on April 28, 2018, 04:57:16 PM
This webpage has most of the info.. you just need to do some quick calcs: https://www.digicamdb.com/cameras/
Pull up all Canons for example and just calculate:
Crop factor =      43.27 mm  /  sensor diagonal in mm    (The sensor diag is right on the page if you pull up say all Canons).

That's exactly the point I've explained above. A user must do this only for a few camera models. Quick.
I must do it for all Canon models. Sloooow.
-- Mario
IMatch Developer
Forum Administrator
http://www.photools.com  -  Contact & Support - Follow me on 𝕏 - Like photools.com on Facebook

Jingo

Quote from: Mario on April 28, 2018, 06:46:25 PM
Quote from: Jingo on April 28, 2018, 04:57:16 PM
This webpage has most of the info.. you just need to do some quick calcs: https://www.digicamdb.com/cameras/
Pull up all Canons for example and just calculate:
Crop factor =      43.27 mm  /  sensor diagonal in mm    (The sensor diag is right on the page if you pull up say all Canons).

That's exactly the point I've explained above. A user must do this only for a few camera models. Quick.
I must do it for all Canon models. Sloooow.

Here is a CSV file of all Nikon's with its crop and diagonal... I can easily do Canon, Pentax, etc if you feel this is useful.


Mario

Awesome. Please do. I assume you wrote a script (I'm currently knee-deep in OpenLayers API and Google Maps API).

CSV files are fine. I can pull them trough a database. Or make this a web service for easier updates in the future.
-- Mario
IMatch Developer
Forum Administrator
http://www.photools.com  -  Contact & Support - Follow me on 𝕏 - Like photools.com on Facebook

Jingo

my pleasure.. I have scrubbing software that I use regularly to grab data from online catalogs... I wrote a script to grab the data and run it off each camera page.  Takes a good 20 minutes to run each type but I will grab some others for you.

Here is Canon.. I'll create an upload the others together.  Enjoy - Andy.

Jingo

#20
Hi Mario - attached is a zip file that contains csv data (camera models, crops and diags) for the following cameras:
     Fujifilm, Leica, Canon, Casio, Kodak, Minolta, Nikon, Olympus, Panasonic, Pentax, Ricoh, Samsung, Sony and Vivitar

I also added these to a google spreadsheet for sharing purposes: https://docs.google.com/spreadsheets/d/13-7wdq_-fn9Rxs1scZcrONqVa2JYYMQavQ7HqH9p95k/edit?usp=sharing

There are still a bunch of other cameras I can collect when I have time... things like HP, Konica and even some tiny companies not to mention some cell phones... happy to get to those tomorrow.

Enjoy! - Andy.


EDIT: Attached the final part of the camera list: Toshiba, Sigma, Sanyo, Rollei, Praktica, & Konica-Minolta

Mario

#21
Thanks for your efforts. Much appreciated  :)

The "Leica" file contains the same data as the "Fuji" file.
Another problem is that the make/model names used in these files don't always match the metadata we get from cameras.

For example, the entry

Canon PowerShot A300 must be resolved to make="Canon", model="Canon PowerShot A300"
"Casio Exilim" must be resolved to make="CASIO COMPUTER CO.,LTD"  model="Exilim"
"Kodak DC280" must be resolved to make="EASTMAN KODAK COMPANY" model="Kodak DC280"

I'm not sure about the "Konica-Mnolta" and "Minolta" cameras entries in your file.
In my database I have some DIMAGE models under "MINOLTA CO., LTD." and others under "KONICA MINOLTA CAMERA, INC.".
Never "Mnolta" alone or "Konica-Minolta". Not a big problem, though. These cameras were never widely used.

In order to lookup the data later, IMatch must be able to match the make/model data coming from the camera precisely.

I will try to clean up the data manually and incorporate the models I don't have already into my database. Thank you again.

Smart Phone data would be interesting. This seems to be even harder to get than for regular cameras.
I have most iPhones but only some Samsung, bq and Sony so far.
-- Mario
IMatch Developer
Forum Administrator
http://www.photools.com  -  Contact & Support - Follow me on 𝕏 - Like photools.com on Facebook

Jingo

Glad to help in some way... sorry about the Leica file - it has been corrected on the spreadsheet as well.  The file got overwritten with the Fuji data... it is now attached.

Yeah - figured some of these camera models/names are NOT based on the actual EXIF data that gets written to the files... but hopefully it is a good starting point to help flesh out your database.  With this list, you may be able to search and find sample images from these camera where the exif data is embedded so you can update the names as needed.

Amazing (and scary) what can be done with scrubbing/data mining software!   ;D

Mario

Thank you.

I wrote an email to the site owner Gregor B. and asked him if it would be OK for me to use the data you have grabbed from his site.
The material is copyrighted and I will only use it with en explicit permission of the site owner. Fair is fair.
-- Mario
IMatch Developer
Forum Administrator
http://www.photools.com  -  Contact & Support - Follow me on 𝕏 - Like photools.com on Facebook

Kucera

SONY
DSC-T200
Crop factor  6.02

and old but still good
KONICA MINOLTA
DiMAGE X50
Crop factor  6.02

Regards, Emil

Mario

Gregor from https://www.digicamdb.com/cameras/ has allowed me to use the data Jingo has extracted.
This brings the camera database quite a bit forward. Still, many models missing. We'll fill that up as we go.

I think I will make the camera database a service. The Map Panel can then download camera data when the user processes files from a camera model not seen before. The Map Panel then caches the data locally so it won't need to request it again. This way I can publish new models immediately when users send me information.
-- Mario
IMatch Developer
Forum Administrator
http://www.photools.com  -  Contact & Support - Follow me on 𝕏 - Like photools.com on Facebook

Jingo

Quote from: Mario on April 29, 2018, 08:25:18 PM
Gregor from https://www.digicamdb.com/cameras/ has allowed me to use the data Jingo has extracted.
This brings the camera database quite a bit forward. Still, many models missing. We'll fill that up as we go.

I think I will make the camera database a service. The Map Panel can then download camera data when the user processes files from a camera model not seen before. The Map Panel then caches the data locally so it won't need to request it again. This way I can publish new models immediately when users send me information.

Awesome.. nice to see folks sharing data!  Please let me know if I can help further... this is a lot of camera details loaded on each page - it would take a very detailed script to grab it all but I'm sure it could be done with some perseverance...

Mario

Thanks. But at least at this point, IMatch only needs the crop factor to calculate the correct FOV angle.
-- Mario
IMatch Developer
Forum Administrator
http://www.photools.com  -  Contact & Support - Follow me on 𝕏 - Like photools.com on Facebook

sinus

I guess, Mario, that you have already the data of some comon Nikon-cameras?
In my case (mostly):

Nikon D750
Nikon D7000
Nikon D100
Nikon D70
Nikon D80

Sony DSC-HX90V
Best wishes from Switzerland! :-)
Markus

Mario

I have most Nikons.

I don't have your SONY. What's the crop factor?
Forget it. I have looked it up for you: https://www.digicamdb.com/specs/sony_cybershot-dsc-hx90v/
-- Mario
IMatch Developer
Forum Administrator
http://www.photools.com  -  Contact & Support - Follow me on 𝕏 - Like photools.com on Facebook

sinus

Quote from: Mario on April 30, 2018, 09:15:36 AM
I have most Nikons.

I don't have your SONY. What's the crop factor?
Forget it. I have looked it up for you: https://www.digicamdb.com/specs/sony_cybershot-dsc-hx90v/

Thanks Mario,
your are faster than a bolt of lightning!  :D
Best wishes from Switzerland! :-)
Markus

Bri Wit

Make Canon
Model Canon EOS 5DS R
Crop Factor 1

nacho02

Here's an old one..
Nikon E885 (from 2002)

CCD-Sensor 1/1,8" 7,2 x 5,3 mm (Cropfaktor 4,8)

Ignacio

Mario

What is the make and the model (exactly) as returned by the variables?

Is the make NIKON? Is the model name "E885" or "NIKON E885" or "E885 (from 2002)" or "NIKON E885 (from 2002)"?
-- Mario
IMatch Developer
Forum Administrator
http://www.photools.com  -  Contact & Support - Follow me on 𝕏 - Like photools.com on Facebook

Jingo

Believe this is the Nikon Coolpix 885,4.87,8.89 from the database....

Mario

Quote from: Jingo on May 05, 2018, 04:27:46 PM
Believe this is the Nikon Coolpix 885,4.87,8.89 from the database....

To find the crop, the map panel takes the contents of the make and model tag and performs a lookup. Hence I need to know exactly what's in these two fields.
-- Mario
IMatch Developer
Forum Administrator
http://www.photools.com  -  Contact & Support - Follow me on 𝕏 - Like photools.com on Facebook

Jingo

Quote from: Mario on May 05, 2018, 04:41:21 PM
Quote from: Jingo on May 05, 2018, 04:27:46 PM
Believe this is the Nikon Coolpix 885,4.87,8.89 from the database....

To find the crop, the map panel takes the contents of the make and model tag and performs a lookup. Hence I need to know exactly what's in these two fields.

Got ya!

PaulS

Hi Mario,

Is your latest list of cameras available for review?  From this thread it appears you may have most of the crop info you need already from Jingo, but you might still need the EXIF make and model for some.

I'd be happy to cross check with the images I have, and it would be faster to just target the ones you are missing.  Having Data-driven Categories makes it quite easy to quickly check  :D

Paul

Mario

You can access the current list in JSON format directly in your browser via this URL:

https://www.photools.com/services/v1/camdb/download
-- Mario
IMatch Developer
Forum Administrator
http://www.photools.com  -  Contact & Support - Follow me on 𝕏 - Like photools.com on Facebook

sinus

Quote from: Mario on May 08, 2018, 08:20:36 AM
You can access the current list in JSON format directly in your browser via this URL:

https://www.photools.com/services/v1/camdb/download

This list is unbelievable  :o how many cameras you have collected.
Phew, model by model, with sometimes only very few changes.  8)
Best wishes from Switzerland! :-)
Markus

Mario

Most of this was done by Jingo and the scripts which pulled the info from https://www.digicamdb.com/cameras/. I asked the site owner Gregor for permission and he thankfully agreed.
Not everything was pulled, though. I have found several camera models in my collection which where not in the database but on Gregor's site.

The IMatch 2018 Map Panel accesses the photools.com camera database dynamically, then caches the information about the cameras used in the local data store. All automatic. If a user wants to use the Map Panel, he/she must be on-line anyway so this is OK.

When camera models are not found in the database, the camera database records that and informs me. I then may try to find the info and update the database.

The user also will see a prompt in the Map Panel in this case, which allows her/him to enter details about his camera (and where to possibly find it) and then can send me the info via email so I can update the database. Since this is a web service, changes done to the database will become immediately available for all IMatch users  :)

I expect quite a number of missing models in the first months after IMatch 2018 has been rolled out. And then only occasional updates when users buy new camera models or smart phones.

Maybe I even add a page where you can lookup your camera model and check if it is in the database.
I'm just too short on time currently. I'm knee-deep in the Map Panel code for directions and FOVs, struggling with the many differences between how OpenLayers works (OpenStreetMap, Bing) and how Google Maps works. I've just lost half a day because I accidentally used 'Bottom' instead of 'bottom' for a font formatting object - which caused OpenLayers to stop rendering markers on the Map. Without any warning or error message...sigh. Took me ages to figure that out...
-- Mario
IMatch Developer
Forum Administrator
http://www.photools.com  -  Contact & Support - Follow me on 𝕏 - Like photools.com on Facebook

Jingo

Quote from: Mario on May 08, 2018, 09:29:56 AM
Most of this was done by Jingo and the scripts which pulled the info from https://www.digicamdb.com/cameras/. I asked the site owner Gregor for permission and he thankfully agreed.
Not everything was pulled, though. I have found several camera models in my collection which where not in the database but on Gregor's site.


That is odd... if you can provide me with an example - I can check the script to see why it wasn't pulled (just for my own knowledge).  I was using his sub-catalog pages by model to grab the data... perhaps these subpages are missing data that exist in the full DB... that is the only way it could have been missed.

Mario

Don't worry.
Maybe it's just a wrong make entry. Camera vendors use all kinds of spellings, and the web site only names them OLYMPUS or NIKON. I've tried to manually correct this,  but Olympus especially seems to randomize the company name in the make tag across their product line. This will sort out itself once user's update the database via the Map Panel.

I first thought about shipping a large JSON with all cameras but then settled for the more modern and dynamic web service approach.
-- Mario
IMatch Developer
Forum Administrator
http://www.photools.com  -  Contact & Support - Follow me on 𝕏 - Like photools.com on Facebook

Jingo

Gotcha... anyway - here is another that I don't think you have.. my current phone:

Huwaei Honor 8

Exif Model: FRD-L14
Crop Factor: 7.38

Mario

Quote from: Jingo on May 08, 2018, 10:23:10 PM
Gotcha... anyway - here is another that I don't think you have.. my current phone:

Huwaei Honor 8

Exif Model: FRD-L14
Crop Factor: 7.38
What is the make?
-- Mario
IMatch Developer
Forum Administrator
http://www.photools.com  -  Contact & Support - Follow me on 𝕏 - Like photools.com on Facebook

PaulS

I've checked my images and have come up with the following additional cameras (in CSV format) that are not in the JSON list.  After a bit of searching I was able to calculate the crop factor for only a few, but most are old phones and not important anyway.  The Canon camera crop factors came from Gregor's site - not sure why Jingo's script didn't catch them.

Make,Model,Crop factor
Apple,iPad Air,7.555
Apple,iPhone 4S,7.613
Apple,iPhone 5c,7.613
Apple,iPhone 6s,7.212
Canon,Canon EOS REBEL T1i,1.613
Canon,Canon PowerShot S400,4.869
Canon,Canon PowerShot SD1100 IS,6.016
Canon,Canon PowerShot SD300,6.016
Canon,Canon PowerShot SD600,6.016
LG Electronics,VS985 4G,
Nokia,Lumia 928,
Research In Motion,BlackBerry 8310,
Research In Motion,BlackBerry 9360,
Research In Motion,BlackBerry 9530,
Research In Motion,BlackBerry 9800,
SAMSUNG,SGH-T959V,
SAMSUNG,SPH-L710,
Samsung Electronics,SGH-F480,
SONY,CYBERSHOT,

PaulS

In checking my images, I also found the following cameras that had different make and/or model metadata than what is on the JSON webpage.  In most cases it is obvious which is the corresponding camera, but in two cases (NIKON E2500 and NIKON E775) I have a added a comment to clarify (again in CSV format).  These were created using IMatch's Text Export module.

Make,Model,Comment
"CASIO COMPUTER CO.,LTD.",EX-Z100,
"CASIO COMPUTER CO.,LTD.",EX-Z75,
EASTMAN KODAK COMPANY,KODAK C875 ZOOM DIGITAL CAMERA,
EASTMAN KODAK COMPANY,KODAK DX7440 ZOOM DIGITAL CAMERA,
EASTMAN KODAK COMPANY,KODAK EASYSHARE C653 ZOOM DIGITAL CAMERA,
EASTMAN KODAK COMPANY,KODAK EASYSHARE Z710 ZOOM DIGITAL CAMERA,
EASTMAN KODAK COMPANY,KODAK EASYSHARE Z8612 IS Digital Camera,
EASTMAN KODAK COMPANY,KODAK EasyShare Z980 Digital Camera,
EASTMAN KODAK COMPANY,KODAK Z740 ZOOM DIGITAL CAMERA,
EASTMAN KODAK COMPANY,KODAK Z7590 ZOOM DIGITAL CAMERA,
FUJIFILM,FinePix A500,
FUJIFILM,FinePix S5Pro,
FUJIFILM,FinePix2600Zoom,
FUJIFILM,FinePix2650,
"Minolta Co., Ltd.",DiMAGE Z1,
NIKON,COOLPIX L120,
NIKON,COOLPIX L18,
NIKON,COOLPIX P90,
NIKON,COOLPIX S560,
NIKON,COOLPIX S8100,
NIKON,E2500,Coolpix 2500
NIKON,E775,Coolpix 775
Panasonic,DMC-FS42,
Panasonic,DMC-FZ28,
Panasonic,DMC-FZ5,
Panasonic,DMC-LZ2,
Samsung Techwin,Digimax L55W / Kenox X15 WIDE,
SONY,DSC-H10,
SONY,DSC-N1,
SONY,DSC-W1,

jch2103

Minor note: The list includes

"PIXEL 2":6.86

The Pixel 2 XL uses the same camera, so the same crop factor. I don't have one to confirm, but should be "PIXEL 2 XL".
John

Jingo

Quote from: PaulS on May 09, 2018, 12:22:37 AM
I've checked my images and have come up with the following additional cameras (in CSV format) that are not in the JSON list.  After a bit of searching I was able to calculate the crop factor for only a few, but most are old phones and not important anyway.  The Canon camera crop factors came from Gregor's site - not sure why Jingo's script didn't catch them.

Make,Model,Crop factor
Apple,iPad Air,7.555
Apple,iPhone 4S,7.613
Apple,iPhone 5c,7.613
Apple,iPhone 6s,7.212
Canon,Canon EOS REBEL T1i,1.613
Canon,Canon PowerShot S400,4.869
Canon,Canon PowerShot SD1100 IS,6.016
Canon,Canon PowerShot SD300,6.016
Canon,Canon PowerShot SD600,6.016
LG Electronics,VS985 4G,
Nokia,Lumia 928,
Research In Motion,BlackBerry 8310,
Research In Motion,BlackBerry 9360,
Research In Motion,BlackBerry 9530,
Research In Motion,BlackBerry 9800,
SAMSUNG,SGH-T959V,
SAMSUNG,SPH-L710,
Samsung Electronics,SGH-F480,
SONY,CYBERSHOT,

It appears that Gregor's database by Camera brand indexes items by "other camera model" names... so for example, the Powershot SD1100 is listed under the canon camera list under is "other known name" the Canon Digital IXUS 80 IS... guess he isn't using all the names a camera can go by when listed by camera brand which is what I used to scrub the site with.

Same goes for the Canon PowerShot SD600 - listed as the Canon Digital IXUS 60... 

Mario

Camera vendors often name cameras differently in different countries. To obfuscate things or to justify different prices for the same hardware  >:(
Hence my approach of "Users will fill the database from their camera models over time" approach. The only that will work. IMatch is used in almost 70 countries...
-- Mario
IMatch Developer
Forum Administrator
http://www.photools.com  -  Contact & Support - Follow me on 𝕏 - Like photools.com on Facebook