User:Econterms
Revision as of 17:25, 4 September 2020 by Econterms (talk | contribs) (→Ambitions: new Latin American project)
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:
- http://aero.referata.com/w/index.php?title=Aero_Club_of_Canada&curid=2592&diff=3079&oldid=2668
- http://aero.referata.com/w/index.php?title=Aero_Club_of_Hawaii&curid=2624&diff=3013&oldid=2700
- Patent FR-1914-18744 -- half done with this one
- Patent GB-1909-47
- to find cases that need to be re-matched to the data in the spreadsheets, do a regular search for "IPCs=6.4". Include the quotes to search for this literal string
- List of examples from this site -- for demonstrations and admirable examples
- /Work in progress
- Long-ago design plans for this site, almost all implemented by now: Tables design
- list of all Techtypes and fields within them
Tasks underway
- work on Lua on aero?
- convert these from Orgs to Company table based on Entity type=1: http://aero.referata.com/w/index.php?title=Special%3ASearch&profile=default&search=entity+type%3D1&fulltext=Search
- study the reports on the d'Esterno page, and formulate a bug report, and change the common templates to have "" not
- How can one get a report on patents for which Patents.year.filed is blank or none or badly syntaxed? that's a variable badly needed for analyses of aviation patent spikes circa 1910.
- report on Orgs that might have phone address and cable
|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
- mass updates produce lots of these which need fixing: Category:Pages_using_duplicate_arguments_in_template_calls
- Benton name fixing - wait for mass updates to finish, then standadize this name
- Let's discuss: Special:Interwiki -- what interwiki links serve us best? copy from meta or en.wp? -- ah, we can use w: and follow it with fr or wikt or whatever in the wikimedia world
- create a report and template for patents in an INPADOC family
- task: keep focusing Arthur John Rowledge patent bio
- task: list Template:Compact patent list 2args as a useful thing ; apply it to Barlette case ; make a generalized version ; use the generalized version ; might be put in Lua
- task: remap the data and fields for these records with bad CPCs detected in my stata program:
- Patent FR-1902-316849.1214
- Patent FR-1910-416138
- Patent FR-1910-417097
- Patent FR-1910-417097.1
- Patent FR-1911-426901
- Patent FR-1912-444289
- from front page, can delete?
- Academic reference points
- obsolete front end for Early aero and aviation data
- Redirects to consider for deletion: Special:Log/move ; see also All logs
- 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
- https://www.citylab.com/life/2019/08/where-is-the-midwest-map-geography-great-lakes-rust-belt/597082/
- http://datamp.org/
- http://www.nonesuchtools.com/patent/
- http://web.archive.org/web/20170108103303/http://www.mwtca.org/patent-information.html
- https://historicip.com/
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 | 5,297 |
US | 4,882 |
GB | 3,903 |
DE | 1,168 |
HU | 474 |
BE | 361 |
AT | 333 |
IT | 160 |
CA | 158 |
CH | 151 |
ES | 132 |
RU | 82 |
DK | 60 |
AU | 59 |
MX | 53 |
NO | 49 |
DEG | 29 |
NZ | 28 |
NL | 28 |
LU | 26 |
IN | 16 |
10 | |
FI | 9 |
SU | 5 |
?? | 4 |
SE | 3 |
JP | 2 |
GR | 2 |
AH | 2 |
CU | 2 |
For demonstration
- First Exhibition of the Aeronautical Society of Great Britain
- Aeronautical exhibition in Paris in 1883
- Octave Chanute - key inventor, networker, and publisher
- Patent US-1897-582718
- CPC B64C11/00
- Charles Bartlett Thomas -- spelling of his name
- Georg Wellner -- note different spellings of his name and ambiguities about whether he was from Brunn or Brno
- Patent US-1913-1059247 has a hybrid airplane-aerostat with lots of pix and is a relatively late example of the use of the term airship. Maybe show the use of the word "airship" across sources, and the frequency of this kind of hybrid.
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: http://aero.referata.com/wiki/Aero_Club_of_Springfield
- (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) http://aero.referata.com/wiki/Template_talk:Own_patent_list ; 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 INPI.fr, which does not seem to have direct links to the pages with particular patents. Look for pages linking to INPI.fr 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
Sources
- 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
- fill in these: https://babel.hathitrust.org/cgi/pt?id=nyp.33433015143443;view=1up;seq=12 and follow the pattern of other info on Hathitrust
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
- This query works for the basics:
- [3]
- For data on size of a patent doc:
- [4]
- combined: Actually this is ALL I need, for the first 5000.
- [5]
- /Big uploads of Brockett publication bibliography 2018-2019
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
Ambitions
- /Latin American patents project
- combine 4 kinds of "tech fields" and "Patent categories" into a single multivalued field, maybe "Tech cats" ; this is a lot of work but could be comparable to a Tech cats field in the publications, inventors, clubs, etc tables
- /history of this site
- /Social network analysis project
- /Patents spike project
- /Patents for Asia-Pacific
- /Patent classifications discussion
- /Inventive indexes
- Small patents-on-propellers spreadsheet download - 152 recs with 3 columns
- Big patents-on-propellers spreadsheet download - 152 recs with 20ish columns
- Big patents-on-propellers spreadsheet download - ~175 entries with any version of "propeller" in the Tech fields space