Difference between revisions of "User:Econterms"
Jump to navigation
Jump to search
(→How to cite CPC and USPC compactly: usually followed by these sections) |
(get rid of refs to referata which isn't responsive) |
||
| (48 intermediate revisions by 3 users not shown) | |||
| Line 2: | Line 2: | ||
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. | 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. | ||
| − | + | * [[/Demo for WikiConference North America 2020]] | |
| − | + | * [[/Aero workshop for Jan 28 2021]] | |
| − | + | ||
| − | + | ||
| − | |||
| − | *[[ | ||
| − | * [[ | ||
| − | |||
* [[List of examples from this site]] -- for demonstrations and admirable examples | * [[List of examples from this site]] -- for demonstrations and admirable examples | ||
* [[/Work in progress]] | * [[/Work in progress]] | ||
* Long-ago design plans for this site, almost all implemented by now: [[Tables design]] | * Long-ago design plans for this site, almost all implemented by now: [[Tables design]] | ||
| − | * [http:// | + | * [http://econterms.net/aero/index.php?title=Special:ViewData&limit=3000&offset=0&tables=Techtypes&fields=_pageName%3DPage%2CEnclosing_categories__full%3DEnclosing+categories%2CSubcategories__full%3DSubcategories%2CAffiliated_concepts__full%3DAffiliated+concepts&order_by=%60_pageName%60 list of all Techtypes and fields within them] |
=== Tasks underway === | === Tasks underway === | ||
| − | * convert these from Orgs to Company table based on Entity type=1: http:// | + | * work on [[Lua on aero]]? |
| + | * convert these from Orgs to Company table based on Entity type=1: http://econterms.net/aero/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 '' | * 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. | * 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. | ||
| − | * [http:// | + | * [http://econterms.net/aero/index.php?title=Special:ViewData&limit=500&offset=1100&tables=Organizations&fields=_pageName%2C+Phone%2C+Address&order_by=%60_pageName%60%2C+%60Phone%60%2C+%60Address%60&format=auto report on Orgs that might have phone address and cable] |
|Original title=Improvements in airships | |Original title=Improvements in airships | ||
|English title=Improvements in airships | |English title=Improvements in airships | ||
|Filing date=1908-10-20 | |Filing date=1908-10-20 | ||
| − | * ''[[Aeronautical Journal]]'', January 1909, | + | * ''[[Aeronautical Journal]]'', January 1909, [https://babel.hathitrust.org/cgi/pt?id=osu.32435061942330&view=1up&seq=55 p31] (on HathiTrust) |
| − | + | *23332 Nov 2 G Fischer and T Walti Airship -- couldn't find this one in other sources, e.g. espacenet or Neilson -- perhaps it was a provisional filing never completed?[[Patent GB-1908-23332]] | |
| − | + | *23435 Nov 3 J I Kay. Aerial multiform, multiplane and sections -- couldn't find this one in other sources, e.g. espacenet or Neilson -- perhaps it was a provisional filing never completed?[[Patent GB-1908-23435]] | |
| − | + | *24126 Nov 10 G J G Jensen Apparatus for controlling airships and flying machines[[Patent GB-1908-24126]] | |
| − | + | *24148 Nov 11 P F Degn Improvements in flying machines[[Patent GB-1908-24148]] | |
| − | + | *24460 [[Patent GB-1908-24460]] | |
| − | + | *24557 [[Patent GB-1908-24557]] | |
| − | + | *24617 [[Patent GB-1908-24617]] | |
| − | 23332 Nov 2 | + | *24650 [[Patent GB-1908-24650]] |
| − | + | *24731 [[Patent GB-1908-24731]] | |
| − | 23435 Nov 3 | + | *24890 [[Patent GB-1908-24890]] |
| − | + | *25166 [[Patent GB-1908-25166]] | |
| − | + | *24928 [[Patent GB-1908-24928]] | |
| − | + | *25102 [[Patent GB-1908-25102]] | |
| − | + | *25315 [[Patent GB-1908-25315]] | |
| − | + | *25490 [[Patent GB-1908-25490]] | |
| − | + | *25581 [[Patent GB-1908-25581]] | |
| − | + | *25672 [[Patent GB-1908-25672]] | |
| − | 24126 Nov 10 | + | *25774 [[Patent GB-1908-25774]] |
| − | 24148 Nov 11 | + | *december |
| − | + | *26606 [[Patent GB-1908-26606]] | |
| − | + | *26214 [[Patent GB-1908-26214]] | |
| − | + | *26289 [[Patent GB-1908-26289]] | |
| − | 24460 | + | *26381 [[Patent GB-1908-26381]] |
| − | 24557 | ||
| − | 24617 | ||
| − | 24650 | ||
| − | |||
| − | 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]] | * mass updates produce lots of these which need fixing: [[:Category:Pages_using_duplicate_arguments_in_template_calls]] | ||
| − | * [http:// | + | * [http://econterms.net/aero/index.php?title=Special%3ASearch&search=BENTON&go=Go Benton name fixing] - wait for mass updates to finish, then standardize 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 | * 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]] | * create a report and template for patents in an [[INPADOC family]] | ||
| Line 80: | Line 58: | ||
* [[Patent FR-1911-426901]] | * [[Patent FR-1911-426901]] | ||
* [[Patent FR-1912-444289]] | * [[Patent FR-1912-444289]] | ||
| − | |||
| − | |||
;from front page, can delete? | ;from front page, can delete? | ||
* [[Academic reference points]] | * [[Academic reference points]] | ||
| Line 87: | Line 63: | ||
* Redirects to consider for deletion: [[Special:Log/move]] ; see also [[Special:Log|All logs]] | * Redirects to consider for deletion: [[Special:Log/move]] ; see also [[Special:Log|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 [[Background jobs running|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 === | === 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. | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=Patents | tables=Patents | ||
| Line 95: | Line 81: | ||
|having=COUNT(*) > 1 | |having=COUNT(*) > 1 | ||
|order by=COUNT(*) DESC | |order by=COUNT(*) DESC | ||
| − | |format= | + | |format=table |
}} | }} | ||
| − | + | * [http://econterms.net/aero/title=Special:CargoExport&tables=Patents&&fields=_pageName%2CFiling_date%2CGrant_date%2COffice%2CInventors%2CInventor_country%2CApplicant_person%2CRelated_to_aircraft%2CTech_fields%2CCPCs%2CNational_tech_categories%2COriginal_title&where=Office%3D%27BE%27&order+by=%60Year_granted%60&limit=5000&format=csv Query for Belgian patents] | |
=== For demonstration === | === For demonstration === | ||
| Line 109: | Line 95: | ||
* [[Georg Wellner]] -- note different spellings of his name and ambiguities about whether he was from Brunn or Brno | * [[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. | * [[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. | ||
| + | * 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. | ||
| + | {{#cargo_query: | ||
| + | tables=Patents | ||
| + | |fields=Patents.Office,COUNT(*) | ||
| + | |group by=Patents.Office | ||
| + | |having=COUNT(*) > 1 | ||
| + | |order by=COUNT(*) DESC | ||
| + | |format=bar chart | ||
| + | }} | ||
=== Requests to Yaron === | === Requests to Yaron === | ||
| + | Crisis questions | ||
| + | * can't upload characters with diacritics regularly ; different problems if such a character is in the page title or just the content | ||
| + | * see [[Patent-temp-test]] | ||
| + | * can we keep the blanks fields when saving from a form | ||
| + | |||
| + | |||
* (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? | * (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? | * (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 | * (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:// | + | * (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://econterms.net/aero/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 [[Inventing Aviation main page|this page]]? | * (13) Is there any way to get counts like the ones shown on [[Special:CargoTables]]? I want to show them on the [[Inventing Aviation main page|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. | * (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. | ||
| Line 120: | Line 121: | ||
* (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. | * (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 | * (18) would like to avoid duplicates in this report: [[USPC 244/49]] which has "or" in its specification | ||
| − | * (19) http:// | + | * (19) http://econterms.net/aero/Template_talk:Own_patent_list ; why can't i add a discussion |
* example of missing info in report: [[Emile-Andre Dandrieux]] | * example of missing info in report: [[Emile-Andre Dandrieux]] | ||
* [[/Tech requests already addressed]] | * [[/Tech requests already addressed]] | ||
| Line 129: | Line 130: | ||
* removal of some duplicates by hand | * removal of some duplicates by hand | ||
* no good way to address fields mis-imported yet. Peter resists doing a new import | * 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 === | === Sources === | ||
| Line 162: | Line 164: | ||
=== Presentations of this wiki, past and future === | === Presentations of this wiki, past and future === | ||
| − | * SSHA, Nov 2016, ([http:// | + | * SSHA, Nov 2016, ([http://econterms.net/aero/images/Record_linking_aero_inventors_1d.pdf paper]), ([http://econterms.net/innovation/images/a/ab/MeyerSSHA2016Aero_0h.pdf slides]) |
* EMWCon, March 2017 [https://www.mediawiki.org/wiki/User:Econterms/Tracking_historical_invention:_the_airplane_and_its_industry examples from this demo] | * EMWCon, March 2017 [https://www.mediawiki.org/wiki/User:Econterms/Tracking_historical_invention:_the_airplane_and_its_industry examples from this demo] | ||
* Appalachian State History and Economics conference, April 2017 | * Appalachian State History and Economics conference, April 2017 | ||
| − | * ESSHC [http:// | + | * ESSHC [http://econterms.net/aero/images/AeroMeyerESSHC2018-small-final.pdf presentation file slightly altered to remove the big image], April 2018 |
| − | * | + | * World Econ History Congress, Boston July 2018, in [http://wehc2018.org/interactive-economic-history-workshop-usable-systems-for-diverse-data/ 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 | * 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. | * to fix large size images. switch formats. On Mac can choose size of jpg file. | ||
| + | * [[/for Sean Keyer's aerospace works in progress, Jan 28, 2021]] | ||
=== Prep for data downloads === | === Prep for data downloads === | ||
| Line 177: | Line 179: | ||
* This query works for the basics: | * This query works for the basics: | ||
| − | * [http:// | + | * [http://econterms.net/aero/Special:ViewData?title=Special%3AViewData&tables=Patents&fields=_pageName,Year_filed,Year_granted,Office,Inventor_country&offset=00&limit=5001] |
* For data on size of a patent doc: | * For data on size of a patent doc: | ||
| − | * [http:// | + | * [http://econterms.net/aero/Special:ViewData?title=Special%3AViewData&tables=Patents&fields=_pageName,Year_filed,Year_granted,Office,Inventor_country,Number_of_text_pages,Number_of_diagram_pages,Number_of_figures,Number_of_claims&offset=00&limit=5001] |
| − | * combined: Actually this | + | * combined: Actually this was ALL I needed. |
| − | * [http:// | + | * [http://econterms.net/aero/Special:ViewData?title=Special%3AViewData&tables=Patents&fields=_pageName,Year_filed,Year_granted,Office,Inventor_country,Applicant_type,Related_to_aircraft,Tech_fields,CPCs,National_tech_categories,First_filing,Number_of_text_pages,Number_of_diagram_pages,Number_of_figures,Number_of_claims&offset=00&limit=16001] |
| + | ; Updated for 2021 workshop with more fields | ||
| + | * [http://econterms.net/aero/Special:ViewData?title=Special%3AViewData&tables=Patents&fields=_pageName,Year_filed,Year_granted,Office,Patent_number,Inventor_country,Applicant_type,Applicant_is_inventor,Tech_fields,Filing_date,Grant_date,Granted,Supplementary_to_patent,Related_to_aircraft,Patent_agent,Assigned_to,National_tech_categories,IPCs,CPCs,First_filing,Number_of_text_pages,Number_of_diagram_pages,Number_of_figures,Number_of_claims&offset=00&limit=16001] | ||
| + | <== now using this for PITCH at end of 2023 | ||
* [[/Big uploads of Brockett publication bibliography 2018-2019]] | * [[/Big uploads of Brockett publication bibliography 2018-2019]] | ||
| − | |||
| − | |||
| − | |||
| − | |||
=== How to cite CPC and USPC compactly === | === How to cite CPC and USPC compactly === | ||
| − | * <nowiki><ref name=esp>{{espCPCcat|F41G3/24}}</ref><ref name=pto>{{ptoCPCcat|F41G|3/24}}</ref | + | * <nowiki><ref name=esp>{{espCPCcat|F41G3/24}}</ref><ref name=pto>{{ptoCPCcat|F41G|3/24}}</ref> |
| − | + | {{References}} | |
{{Standard techtype reports}}</nowiki> | {{Standard techtype reports}}</nowiki> | ||
| + | |||
| + | Use <nowiki>{{subst:{{CPCstart|B60B|1/08}}}}</nowiki> to bring a lot of this quickly and automatically | ||
| + | === Error logs on dreamhost === | ||
| + | * https://help.dreamhost.com/hc/en-us/articles/216512217-Viewing-and-examining-your-error-log-via-SSH | ||
=== Ambitions === | === 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 | * 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]] | * [[/Social network analysis project]] | ||
* [[/Patents spike project]] | * [[/Patents spike project]] | ||
| + | * [[/Patents for Asia-Pacific]] | ||
| + | * [[/Patent classifications discussion]] | ||
| + | * [[/Inventive indexes]] | ||
| + | * [http://econterms.net/aero/Special:ViewData&limit=250&offset=0&tables=Patents&fields=_pageName%2C+English_title%2C+Inventors&where=Tech_fields+HOLDS+%22propellers%22&join_on=&order_by=&group_by=&having=&format=csv Small patents-on-propellers spreadsheet download] - 152 recs with 3 columns | ||
| + | * [http://econterms.net/aero/Special:ViewData&limit=250&offset=0&tables=Patents&fields=_pageName%2C+Year_filed%2C+Year_granted%2C+Office%2C+Patent_number%2C+Inventor_country%2C+Applicant_person%2C+Applicant_firm%2C+Applicant_type%2C+Applicant_is_inventor%2C+Original_title%2C+English_title%2C+Tech_fields%2C+Filing_date%2C+Full_specification_filed_date%2C+Application_number%2C+Grant_date%2C+Granted%2C+Publication_date%2C+Supplementary_to_patent%2C+Related_to_aircraft%2C+Patent_agent%2C+Assigned_to%2C+National_tech_categories%2C+IPCs%2C+CPCs%2C+Family_year%2C+First_filing%2C+Number_of_citations%2C+Number_of_text_pages%2C+Number_of_diagram_pages%2C+Number_of_figures%2C+Number_of_claims&where=Tech_fields+HOLDS+%22propellers%22&join_on=&order_by=&group_by=&having=&format=csv Big patents-on-propellers spreadsheet download] - 152 recs with 20ish columns | ||
| + | * [http://econterms.net/aero/?title=Special:ViewData&limit=250&offset=0&tables=Patents&fields=_pageName%2C+Year_filed%2C+Year_granted%2C+Office%2C+Patent_number%2C+Inventor_country%2C+Applicant_person%2C+Applicant_firm%2C+Applicant_type%2C+Applicant_is_inventor%2C+Original_title%2C+English_title%2C+Tech_fields%2C+Filing_date%2C+Full_specification_filed_date%2C+Application_number%2C+Grant_date%2C+Granted%2C+Publication_date%2C+Supplementary_to_patent%2C+Related_to_aircraft%2C+Patent_agent%2C+Assigned_to%2C+National_tech_categories%2C+IPCs%2C+CPCs%2C+Family_year%2C+First_filing%2C+Number_of_citations%2C+Number_of_text_pages%2C+Number_of_diagram_pages%2C+Number_of_figures%2C+Number_of_claims&where=Tech_fields+HOLDS+LIKE+%27%propellers%%27&join_on=&order_by=&group_by=&having=&format=csv Big patents-on-propellers spreadsheet download] - ~175 entries with any version of "propeller" in the Tech fields space | ||
| + | * [[/Reports on persons]] | ||
Revision as of 17:01, 10 April 2024
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.
- 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://econterms.net/aero/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 (on HathiTrust)
- 23332 Nov 2 G Fischer and T Walti Airship -- couldn't find this one in other sources, e.g. espacenet or Neilson -- perhaps it was a provisional filing never completed?Patent GB-1908-23332
- 23435 Nov 3 J I Kay. Aerial multiform, multiplane and sections -- couldn't find this one in other sources, e.g. espacenet or Neilson -- perhaps it was a provisional filing never completed?Patent GB-1908-23435
- 24126 Nov 10 G J G Jensen Apparatus for controlling airships and flying machinesPatent GB-1908-24126
- 24148 Nov 11 P F Degn Improvements in flying machinesPatent GB-1908-24148
- 24460 Patent GB-1908-24460
- 24557 Patent GB-1908-24557
- 24617 Patent GB-1908-24617
- 24650 Patent GB-1908-24650
- 24731 Patent GB-1908-24731
- 24890 Patent GB-1908-24890
- 25166 Patent GB-1908-25166
- 24928 Patent GB-1908-24928
- 25102 Patent GB-1908-25102
- 25315 Patent GB-1908-25315
- 25490 Patent GB-1908-25490
- 25581 Patent GB-1908-25581
- 25672 Patent GB-1908-25672
- 25774 Patent GB-1908-25774
- december
- 26606 Patent GB-1908-26606
- 26214 Patent GB-1908-26214
- 26289 Patent GB-1908-26289
- 26381 Patent GB-1908-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 standardize 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,285 |
| US | 4,875 |
| GB | 3,898 |
| DE | 1,166 |
| HU | 474 |
| BE | 360 |
| AT | 333 |
| IT | 160 |
| CA | 157 |
| CH | 150 |
| ES | 132 |
| RU | 76 |
| 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.
- 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.
Requests to Yaron
Crisis questions
- can't upload characters with diacritics regularly ; different problems if such a character is in the page title or just the content
- see Patent-temp-test
- can we keep the blanks fields when saving from a form
- (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://econterms.net/aero/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://econterms.net/aero/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.
- /for Sean Keyer's aerospace works in progress, Jan 28, 2021
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 was ALL I needed.
- [5]
- Updated for 2021 workshop with more fields
<== now using this for PITCH at end of 2023
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
Error logs on dreamhost
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
- /Reports on persons
