From Inventing aviation
Jump to: navigation, search

This site has wiki pages for publications, patents, clubs, journals, letters, inventors, and other data associated with the invention of the airplane and early aviation.

Duplicate rows to fix

Per Yaron: There were duplicate rows in the "organizations" spreadsheet, possibly two organizations with the same name, so the imports overwrote the first one's information. Here are some cases:

Tasks underway

|Original title=Improvements in airships |English title=Improvements in airships |Filing date=1908-10-20

  • Aeronautical Journal, January 1909, p31:
  • 23208 31st F W T Taylor. Aerial machine
  • 23316 Nov 2 J L Garsed Improvements in aerial machines
  • 23332 Nov 2 G Fischer and T Walti Airship
  • 23347 Nov 2 A A Holle. Improvements in aeroplanes
  • 23435 Nov 3 J I Kay. Aerial multiform, multiplane and sections
  • 23595 Nov 4 W. Friese-Greene Improvements in and relating to airships, aeroplanes, and the like
  • 23618 Nov 4 S Schutz Propeller for flying machines
  • 23656 Nov 5 A W Abbott. Elevating platform for aeroplanes and other purposes
  • 23798 Nov 6 I E Mercer. Improvements in aerial machines
  • 23907 Nov 7 O Ricaldoni and G A Crocco Improvements in and relating to dirigible aerostats airships
  • 24076 Nov 10 W Wright and O Wright Improvements in or connected with flying machines
  • 24077 Nov 10 w and o wright Improvements in or connected with flying machines
  • 24126 Nov 10 G J G Jensen Apparatus for controlling airships and flying machines
  • 24148 Nov 11 P F Degn Improvements in flying machines
  • 24202 Nov 11 F A D Simori Imprvoements in or relating to dirigible aerial machines
  • 24344 Nov 12 W H Fauber Improvements in aeroplanes
  • 24441
  • 24460
  • 24557
  • 24617
  • 24650
  • 24682
  • 24731
  • 24890
  • 25166
  • 24928
  • 25102
  • 25315
  • 25490
  • 25581
  • 25672
  • 25774
  • december
  • 26606
  • 26214
  • 26289
  • 26381
from front page, can delete?
  • System stuff: At EMWCon 2019 it became clearer why jobs run slowly here ; there isn't much activity in the UI ; there are MORE database operations than user interface operations. this site is mainly a database. Follow instructions and links here to watch the number of jobs waiting.
more links to follow up

Countries with most patents on this wiki

  • This does not restrict to any time period and includes some patents from technologies unrelated to aeronautics. A more complicated "having" clause could sharpen the picture. Switch "format=table" to "format=bar chart" to get a different format.
Office COUNT(*)
FR 4,997
US 4,749
GB 3,649
DE 814
BE 110
AT 76
CA 65
NO 49
CH 39
ES 33
IN 15
?? 7
AU 5
IT 4
RU 3
AH 2
DK 2
SU 2

For demonstration

Requests to Yaron

  • (5) I'd like to rearrange the data entry fields. can put some of them sideways, e.g. the first four on one row? I don’t like to have to scroll and see so much whitespace when editing, notably a patent record. Or, if the rows need to stay the same, can we put the wiki text to one side of the long table of structured elements?
  • (6) there are no options in the "License" drop down menu when uploading an image. Can we add some?
  • (11) for Person table: first names, family names, birth date, death date, key associates (buddies and allies), education in years, key educational institutions (which may overlap with others on this wiki), professions, countries
  • (12) at the bottom of any Organizations page, I see a section called Sources. Don't want it. Is that on the form? Example:
  • (13) Is there any way to get counts like the ones shown on Special:CargoTables? I want to show them on the this page?
  • (14) Service level upgrade only partly worked; paypal accepted payment for the month and records the payment as done. Paypal said it would direct the browser back to the aero site, but instead it returned to an error -- nonexistent page I think. Navigating around sitesettings again, I saw "Notice: Undefined variable: wgWikiGardenSitename in /home/yaron57/public_html/w/extensions/WikiGarden/specials/WG_ServiceLevel.php on line 165". And "service level" is not recorded as up to Premium on the wiki itself.
  • (15) details of the Letter change and the Recreate for an error message to come.
  • (17) please add to the Recreate function in Special:Cargotables two features: a note/mark in Recent changes when it starts to go, and a note when it ends.
  • (18) would like to avoid duplicates in this report: USPC 244/49 which has "or" in its specification
  • (19) ; why can't i add a discussion
  • example of missing info in report: Emile-Andre Dandrieux
  • /Tech requests already addressed
  • seems like searches for amp;amp; don't find them -- one gets back: "No pages were found containing the string "amp;amp;"."
Accomplishments in March 18 research group meeting
  • determined how to cite historical patents on, which does not seem to have direct links to the pages with particular patents. Look for pages linking to for examples.
  • mass search and replaces, replacing e.g. pages with "FR category 5" to say instead simply "FR 5"
  • removal of some duplicates by hand
  • no good way to address fields mis-imported yet. Peter resists doing a new import
  • (20) /Apostrophes in query -- they seem to blow up


  • move these to their own Category:Publications pages
  • Anderson, John D. 1997. A History of Aerodynamics.
  • Cailliez, Jean-Claude. 2004. Alexandre Liwentaal: pionnier Suisse de l'aéronautique Européene entre 1890 et 1914. Genève: Editions Secavia, S-E Cruchet
  • Chadeau, Emmanuel. 1996 Le Rêve et la Puissance: l'avion et son siècle. Fayard. Pp 19-78.
  • Crouch, Tom. 1981/2002 Dream of Wings: Americans and the Airplane, 1875-1905.
  • Dale, Henry. 1992. Early Flying Machines. Oxford University Press.
  • The Flying Book, 1914 edition. 1914. Longmans, Green and Co., London; The Aviation World publishing Co., Ltd., Richmond Hill, Bournemout, Great Britain. (abbreviated FB14 in later tables)
  • Flying, vol 5. July, 1916. Page 250. Online at [1] aka [2]
  • Garber, Lester W. 2005. The Wright Brothers and the Birth of Aviation. Ramsbury, Marlborough, Wiltshire, UK: The Crowood Press.
  • Gibbs-Smith, 1966, The Invention of the Aeroplane -- a concise classic
  • Gunston, Bill. 1993. World Encyclopedia of Aircraft Manufacturers: From the Pioneers to the Present Day. Naval Institute Press: Annapolis, Maryland; and Haynes Publishing/Patrick Stephens Ltd, Sparkford Somerset, UK. (abbreviated simply G in the subsequent tables; e.g.G104 refers to page 104 of this work)
  • Gunston, Bill. 2005. World Encyclopedia of Aircraft Manufacturers: From the Pioneers to the Present Day, 2nd edition. The History Press. (abbreviated 2dG in later tables here)
  • Head, James. 2008. Warped Wings. Mustang, Oklahoma, USA: Tate Publishing.
  • Jakab, 1990, Visions of a flying machine -- Jakab, Peter L. 1990. Visions of a Flying Machine: The Wright Brothers and the Process of Invention. Washington, DC: Smithsonian Institution Press.
  • Kelly, Maurice. 2006. Steam in the Air: the Application of Steam Power in Aviation during the 19th and 20th Centuries. Barnsley, South Yorkshire, England: Pen & Sword Aviation.
  • Palmer, Scott W. 2006. Dictatorship of the Air: Aviation Culture and the Fate of Modern Russia. New York: Cambridge University Press.
  • Payne, L.G.S. 1957. Air Dates. London: Heinemann. pages 3-13.
  • Penrose, Harald. An Ancient Air: A Biography of John Stringfellow of Chard, The Victorian aeronautical pioneer. First published 1988 by Airlife Publishing Ltd; this edition 2000 by Wrens Park Publishing, an imprint of W.J. Williams & Son, Ltd.
  • Randolph, Stella. 1966. Before the Wrights flew: the Story of Gustave Whitehead. New York: G.P. Putnam's Sons.
  • Roseberry, C.R. Glenn Curtiss: Pioneer of Flight. 1972 by C.R. Roseberry. My edition: 1991 Syracuse University Press.
  • Runge and Bernd Lukasch. 2005. Erfinder Leben.
  • Shulman, Seth. 2002. Unlocking the Sky: Glenn Hammond Curtiss and the race to invent the airplane. HarperCollins.
  • Tobin, James. 2003. To Conquer the Air: The Wright Brothers and the Great Race for Flight. New York: Free Press (Simon & Schuster).
  • Von Kármán, Theodore. 1954. Aerodynamics: Selected topics in the light of their historical development. Ithaca, New York: Cornell University Press.

to fold in

  • compare to database letter19.xls

Presentations of this wiki, past and future

  • SSHA, Nov 2016, (paper), (slides)
  • EMWCon, March 2017 examples from this demo
  • Appalachian State History and Economics conference, April 2017
  • ESSHC presentation file slightly altered to remove the big image, April 2018
  • World Econ History Congress, Boston July 2018, in interactive and visualization session
  • future paper: might measure or challenge the idea of national innovation systems by showing the trends were the same in the different countries  ; analyze patent DOCUMENTS across countries ; in terms of length, claims, how they vary as they are filed in additional countries
  • to fix large size images. switch formats. On Mac can choose size of jpg file.

Prep for data downloads

  • The cap on records in ViewData is 5000; three such queries should get all the patents
  • View some columns in each of several ViewData sessions, then copy to a spreadsheet, then save as .csv or .xlsx, import to Stata or anything for analysis
  • Big savings by importing no wiki text, nor patent titles for now

How to cite CPC and USPC compactly

  • <ref name=esp>{{espCPCcat|F41G3/24}}</ref><ref name=pto>{{ptoCPCcat|F41G|3/24}}</ref> {{References}} {{Standard techtype reports}}

Use {{subst:{{CPCstart|B60B|1/08}}}} to bring a lot of this quickly and automatically