:   uls-master.bat
:   batch file to automate the entire process of managing of the FCC ULS (Master) files
:   n6lhv@arrl.net (Wayne Smith)
:   created:  28-July-2004
:   updated:  11-Sep-2011

:   functional dependencies
:     -ensure that the external drive is enabled (as I:)


: ALWAYS do this processing, regardless of desired other functionality
:SET RPATH="c:\program files\r\R-2.11.1\bin\rterm"
SET RPATH="c:\program files\r\R-2.13.0\bin\i386\rterm"
net stop MySQL
del i:\mysql\data\.log
net start MySQL
mysqlcheck -v uls --analyze --optimize
:cls
:GOTO END


:GOTO DOWNLOAD
:GOTO EXTRACT
:GOTO PREPROCESS
:GOTO CREATETABLES
:GOTO IMPORTDATA
:GOTO MINORFIXES
:GOTO FREQUENCYDISTRIBUTIONS
:GOTO TRANSFORMDATES
:GOTO FIXCITYNAMES
:GOTO IMPUTELOCATIONDATA
:GOTO CREATEINDEXESBEFOREDELETE
:GOTO ADDITIONALDISTRIBUTIONS
:GOTO JOINUS
:GOTO DELETEUNNEEDEDFREQS
:GOTO DELETENONCA
:GOTO CREATEINDEXESAFTERDELETE
:GOTO JOINCA
:GOTO CREATEINDEXESCA
:GOTO CREATEGEOTABLES
:GOTO CREATEEARTHANDMAPSTABLES
:GOTO CREATEORGTABLES
:GOTO CREATESAMPLETABLES
:GOTO CREATETIMESERIES
:GOTO PLOTTIMESERIES
:GOTO SUMMARYSTATISTICS
:GOTO ANALYZEDIVERSITY
:GOTO ANALYZEDATAMINING
:GOTO ANALYZESOCIALNETWORK
:GOTO EXPORTMYSQL
GOTO EXPORTMSACCESS
:GOTO EXPORTDBASE
:GOTO EXPORTSQLITE
:GOTO EXPORTOOOBASE
:GOTO EXPORTMSEXCEL
:GOTO EXPORTFIXEDWIDTH
:GOTO CREATESUBSCRIPTIONFILES
:GOTO CREATEEARTHANDMAPFILES
:GOTO GENERATESCHEMAS
:GOTO DERIVEFILESIZES
:GOTO UPLOAD
GOTO END

:DOWNLOAD
@call download.bat l_LMpriv
@call download.bat l_LMcomm
@call download.bat l_LMbcast
@call download.bat l_coast
@call download.bat l_micro
@call download.bat l_paging
date /t >download-date.txt


:EXTRACT
@call extract-pkzip.bat l_LMpriv
@call extract-pkzip.bat l_LMcomm
@call extract-pkzip.bat l_LMbcast
@call extract-pkzip.bat l_coast
@call extract-pkzip.bat l_micro
@call extract-pkzip.bat l_paging


:PREPROCESS
@call preprocess-DeleteBlankLines.bat l_LMpriv-cp
@call preprocess-DeleteBlankLines.bat l_LMpriv-em
@call preprocess-DeleteBlankLines.bat l_LMpriv-en
@call preprocess-DeleteBlankLines.bat l_LMpriv-fr
@call preprocess-DeleteBlankLines.bat l_LMpriv-hd
@call preprocess-DeleteBlankLines.bat l_LMpriv-hs
@call preprocess-DeleteBlankLines.bat l_LMpriv-lo
@call preprocess-DeleteBlankLines.bat l_LMcomm-cp
@call preprocess-DeleteBlankLines.bat l_LMcomm-em
@call preprocess-DeleteBlankLines.bat l_LMcomm-en
@call preprocess-DeleteBlankLines.bat l_LMcomm-fr
@call preprocess-DeleteBlankLines.bat l_LMcomm-hd
@call preprocess-DeleteBlankLines.bat l_LMcomm-hs
@call preprocess-DeleteBlankLines.bat l_LMcomm-lo
@call preprocess-DeleteBlankLines.bat l_LMbcast-cp
@call preprocess-DeleteBlankLines.bat l_LMbcast-em
@call preprocess-DeleteBlankLines.bat l_LMbcast-en
@call preprocess-DeleteBlankLines.bat l_LMbcast-fr
@call preprocess-DeleteBlankLines.bat l_LMbcast-hd
@call preprocess-DeleteBlankLines.bat l_LMbcast-hs
@call preprocess-DeleteBlankLines.bat l_LMbcast-lo
@call preprocess-DeleteBlankLines.bat l_coast-cp
@call preprocess-DeleteBlankLines.bat l_coast-em
@call preprocess-DeleteBlankLines.bat l_coast-en
@call preprocess-DeleteBlankLines.bat l_coast-fr
@call preprocess-DeleteBlankLines.bat l_coast-hd
@call preprocess-DeleteBlankLines.bat l_coast-hs
@call preprocess-DeleteBlankLines.bat l_coast-lo
@call preprocess-DeleteBlankLines.bat l_micro-cp
@call preprocess-DeleteBlankLines.bat l_micro-em
@call preprocess-DeleteBlankLines.bat l_micro-en
@call preprocess-DeleteBlankLines.bat l_micro-fr
@call preprocess-DeleteBlankLines.bat l_micro-hd
@call preprocess-DeleteBlankLines.bat l_micro-hs
@call preprocess-DeleteBlankLines.bat l_micro-lo
@call preprocess-DeleteBlankLines.bat l_paging-cp
@call preprocess-DeleteBlankLines.bat l_paging-em
@call preprocess-DeleteBlankLines.bat l_paging-en
@call preprocess-DeleteBlankLines.bat l_paging-fr
@call preprocess-DeleteBlankLines.bat l_paging-hd
@call preprocess-DeleteBlankLines.bat l_paging-hs
@call preprocess-DeleteBlankLines.bat l_paging-lo
copy /y preprocess-DeleteBlankLines.pl preprocess-DeleteBlankLines-pl.txt

@call preprocess-FixEmbeddedCRLFs.bat l_LMpriv-cp
@call preprocess-FixEmbeddedCRLFs.bat l_LMpriv-em
@call preprocess-FixEmbeddedCRLFs.bat l_LMpriv-en
@call preprocess-FixEmbeddedCRLFs.bat l_LMpriv-fr
@call preprocess-FixEmbeddedCRLFs.bat l_LMpriv-hd
@call preprocess-FixEmbeddedCRLFs.bat l_LMpriv-hs
@call preprocess-FixEmbeddedCRLFs.bat l_LMpriv-lo
@call preprocess-FixEmbeddedCRLFs.bat l_LMcomm-cp
@call preprocess-FixEmbeddedCRLFs.bat l_LMpriv-em
@call preprocess-FixEmbeddedCRLFs.bat l_LMcomm-en
@call preprocess-FixEmbeddedCRLFs.bat l_LMpriv-fr
@call preprocess-FixEmbeddedCRLFs.bat l_LMpriv-hd
@call preprocess-FixEmbeddedCRLFs.bat l_LMpriv-hs
@call preprocess-FixEmbeddedCRLFs.bat l_LMcomm-lo
@call preprocess-FixEmbeddedCRLFs.bat l_LMbcast-cp
@call preprocess-FixEmbeddedCRLFs.bat l_LMbcast-em
@call preprocess-FixEmbeddedCRLFs.bat l_LMbcast-en
@call preprocess-FixEmbeddedCRLFs.bat l_LMbcast-fr
@call preprocess-FixEmbeddedCRLFs.bat l_LMbcast-hd
@call preprocess-FixEmbeddedCRLFs.bat l_LMbcast-hs
@call preprocess-FixEmbeddedCRLFs.bat l_LMbcast-lo
@call preprocess-FixEmbeddedCRLFs.bat l_coast-cp
@call preprocess-FixEmbeddedCRLFs.bat l_coast-em
@call preprocess-FixEmbeddedCRLFs.bat l_coast-en
@call preprocess-FixEmbeddedCRLFs.bat l_coast-fr
@call preprocess-FixEmbeddedCRLFs.bat l_coast-hd
@call preprocess-FixEmbeddedCRLFs.bat l_coast-hs
@call preprocess-FixEmbeddedCRLFs.bat l_coast-lo
@call preprocess-FixEmbeddedCRLFs.bat l_micro-cp
@call preprocess-FixEmbeddedCRLFs.bat l_micro-em
@call preprocess-FixEmbeddedCRLFs.bat l_micro-en
@call preprocess-FixEmbeddedCRLFs.bat l_micro-fr
@call preprocess-FixEmbeddedCRLFs.bat l_micro-hd
@call preprocess-FixEmbeddedCRLFs.bat l_micro-hs
@call preprocess-FixEmbeddedCRLFs.bat l_micro-lo
@call preprocess-FixEmbeddedCRLFs.bat l_paging-cp
@call preprocess-FixEmbeddedCRLFs.bat l_paging-em
@call preprocess-FixEmbeddedCRLFs.bat l_paging-en
@call preprocess-FixEmbeddedCRLFs.bat l_paging-fr
@call preprocess-FixEmbeddedCRLFs.bat l_paging-hd
@call preprocess-FixEmbeddedCRLFs.bat l_paging-hs
@call preprocess-FixEmbeddedCRLFs.bat l_paging-lo
copy /y preprocess-FixEmbeddedCRLFs.pl preprocess-FixEmbeddedCRLFs-pl.txt

@call preprocess-AddDB_IDField.bat l_LMpriv-fr
@call preprocess-AddDB_IDField.bat l_LMcomm-fr
@call preprocess-AddDB_IDField.bat l_LMbcast-fr
@call preprocess-AddDB_IDField.bat l_coast-fr
@call preprocess-AddDB_IDField.bat l_micro-fr
@call preprocess-AddDB_IDField.bat l_paging-fr
@call preprocess-AddDB_IDField.bat l_LMpriv-hs
@call preprocess-AddDB_IDField.bat l_LMcomm-hs
@call preprocess-AddDB_IDField.bat l_LMbcast-hs
@call preprocess-AddDB_IDField.bat l_micro-hs
@call preprocess-AddDB_IDField.bat l_paging-hs
copy /y preprocess-AddDB_IDField.pl preprocess-AddDB_IDField-pl.txt


:CREATETABLES
mysql -vvv <createdbandtables-mysql.sql >createdbandtables-mysql.log


:IMPORTDATA
mysql -vvv <import-l_LMpriv-mysql-50x.sql >import-l_LMpriv-mysql-50x.log
mysql -vvv <import-l_LMcomm-mysql-50x.sql >import-l_LMcomm-mysql-50x.log
mysql -vvv <import-l_LMbcast-mysql-50x.sql >import-l_LMbcast-mysql-50x.log
mysql -vvv <import-l_coast-mysql-50x.sql >import-l_coast-mysql-50x.log
mysql -vvv <import-l_micro-mysql-50x.sql >import-l_micro-mysql-50x.log
mysql -vvv <import-l_paging-mysql-50x.sql >import-l_paging-mysql-50x.log


:MINORFIXES
mysqlcheck -v uls --analyze --optimize
mysql -vvv <qryFixTrailingCRLF.sql >qryFixTrailingCRLF.log
:mysql -vvv <qryPrependZerosForLowBand.sql >qryPrependZerosForLowBand.log
mysql -vvv <qryFixLowerCase.sql >qryFixLowerCase.log
mysql -vvv <qryEOBlankStates.sql >qryEOBlankStates.log
mysql -vvv <qryEOBlankCounties.sql >qryEOBlankCounties.log
mysql -vvv <qryEOBlankCities.sql >qryEOBlankCities.log


:FREQUENCYDISTRIBUTIONS
mysqlcheck -v uls --analyze --optimize
:mysql -vvv <qryFreqDist.sql >qryFreqDist.log


:TRANSFORMDATES
mysqlcheck -v uls --analyze --optimize
mysql -vvv <qryFixDateFormatting.sql >qryFixDateFormatting.log


:FIXCITYNAMES
mysqlcheck -v uls --analyze --optimize
mysql -vvv <qryFixCityNames.sql >qryFixCityNames.log


:IMPUTELOCATIONDATA
mysqlcheck -v uls --analyze --optimize
mysql -vvv <qryImputeCityFromAddress.sql >qryImputeCityFromAddress.log
mysql -vvv <qryImputeCountyFromCity.sql >qryImputeCountyFromCity.log
mysql -vvv <qryImputeStateFromCounty.sql >qryImputeStateFromCounty.log


:CREATEINDEXESBEFOREDELETE
mysqlcheck -v uls --analyze --optimize
:mysql -vvv <createindexes-mysql.sql >createindexes-mysql.log


:ADDITIONALDISTRIBUTIONS
mysqlcheck -v uls --analyze --optimize
:mysql -vvv <qryDistLocationStateCounty.sql >qryDistLocationStateCounty.log
:mysql -vvv <qryDistLocationStateCountyCity.sql >qryDistLocationStateCountyCity.log


:JOINUS
:mysqlcheck -v uls --analyze --optimize
:: this query is costly...it is not needed for most applications
:mysql -vvv <qryGeoUS-Explain.sql >qryGeoUS-Explain.log
:mysql -vvv <qryGeoUS.sql >qryGeoUS.log
::mysql -vvv <qryGeoUSBlanksOnly.sql >qryGeoUSBlanksOnly.log


:DELETEUNNEEDEDFREQS
mysqlcheck -v uls --analyze --optimize
mysql -vvv <qryDeleteCellular.sql >qryDeleteCellular.log
mysql -vvv <qryDeleteFreqsAbove1GHz.sql >qryDeleteFreqsAbove1GHz.log


:DELETENONCA
mysqlcheck -v uls --analyze --optimize
mysql -vvv <qryDeleteLocationNotStateCAOrBlank.sql >qryDeleteLocationNotStateCAOrBlank.log
mysql -vvv <qryDeleteControlNotStateCA.sql >qryDeleteControlNotStateCA.log
::mysql -vvv <qryDeleteLocationNotBlank.sql >qryDeleteLocationNotBlank.log


:CREATEINDEXESAFTERDELETE
mysqlcheck -v uls --analyze --optimize
mysql -vvv <createindexes-mysql.sql >createindexes-mysql.log


:JOINCA
mysql -vvv <qryGeoStateCA-pre.sql >qryGeoStateCA-pre.log
mysql -vvv <qryGeoStateCA-Analyze.sql >qryGeoStateCA-Analyze.log
mysql -vvv <qryGeoStateCA-Explain.sql >qryGeoStateCA-Explain.log
mysql -vvv <qryGeoStateCA.sql >qryGeoStateCA.log
mysql -vvv <qryGeoStateCA-post.sql >qryGeoStateCA-post.log


:CREATEINDEXESCA
mysqlcheck -v uls --analyze --optimize
mysql -vvv <createindexes-stateCA-mysql.sql >createindexes-stateCA-mysql.log


:CREATEGEOTABLES
mysql -vvv <qryGeoCountiesSoCal.sql >qryGeoCountiesSoCal.log
mysql -vvv <qryGeoCountyLosAngeles.sql >qryGeoCountyLosAngeles.log
mysql -vvv <qryGeoCityLosAngeles.sql >qryGeoCityLosAngeles.log
:mysql -vvv <qryGeoCountiesMetroScan.sql >qryGeoCountiesMetroScan.log
:mysql -vvv <qryGeoCountiesPoliceCall.sql >qryGeoCountiesPoliceCall.log
:mysql -vvv <qryGeoCountiesSCAN.sql >qryGeoCountiesSCAN.log
:mysql -vvv <qryGeoCountiesScanFan.sql >qryGeoCountiesScanFan.log


:CREATEEARTHANDMAPSTABLES
mysqlcheck -v uls --analyze --optimize
mysql -vvv <qryPrepareEarthAndMaps.sql >qryPrepareEarthAndMaps.log
mysql -vvv <createindexes-earthandmaps-mysql.sql >createindexes-earthandmaps-mysql.log


:@call export-msaccess.bat tblGeoCountiesSoCalUnivariate


:CREATEORGTABLES
:mysql -vvv <qryOrgStateCA.sql >qryOrgStateCA.log
:mysql -vvv <qryOrgCountyImperial.sql >qryOrgCountyImperial.log
:mysql -vvv <qryOrgCountyKern.sql >qryOrgCountyKern.log
:mysql -vvv <qryOrgCountyLosAngeles.sql >qryOrgCountyLosAngeles.log
:mysql -vvv <qryOrgCountyOrange.sql >qryOrgCountyOrange.log
:mysql -vvv <qryOrgCountyRiverside.sql >qryOrgCountyRiverside.log
:mysql -vvv <qryOrgCountySanBernardino.sql >qryOrgCountySanBernardino.log
:mysql -vvv <qryOrgCountySanDiego.sql >qryOrgCountySanDiego.log
:mysql -vvv <qryOrgCountySanLuisObispo.sql >qryOrgCountySanLuisObispo.log
:mysql -vvv <qryOrgCountySantaBarbara.sql >qryOrgCountySantaBarbara.log
:mysql -vvv <qryOrgCountyVentura.sql >qryOrgCountyVentura.log


:mysql -vvv <qryOrgCountyLosAngelesMTA.sql >qryOrgCountyLosAngelesMTA.log
:mysql -vvv <qryOrgCityLosAngeles.sql >qryOrgCityLosAngeles.log
:mysql -vvv <qryOrgCityLosAngelesWP.sql >qryOrgCityLosAngelesWP.log
:mysql -vvv <qryOrgAnchor.sql >qryOrgAnchor.log
:mysql -vvv <qryOrgBigRetail.sql >qryOrgBigRetail.log
:mysql -vvv <qryOrgLargeSMR.sql >qryOrgLargeSMR.log
:mysql -vvv <qryOrgCPRA.sql >qryOrgCPRA.log


:CREATESAMPLETABLES
:mysql -vvv <qrySampleLASDSimplex.sql >qrySampleLASDSimplex.log
:mysql -vvv <qrySampleFederal.sql >qrySampleFederal.log
:mysql -vvv <qrySampleRailroad.sql >qrySampleRailroad.log

:mysql -vvv <qryEmulatePoliceCall.sql >qryEmulatePoliceCall.log


:mysql -vvv <qryStatBivariateCallsignByFrequency.sql >qryStatBivariateCallsignByFrequency.log
:mysql -vvv <qryStatBivariateServiceByFrequency.sql >qryStatBivariateServiceByFrequency.log
:mysql -vvv <qryStatBivariateStationByFrequency.sql >qryStatBivariateStationByFrequency.log
:mysql -vvv <qryStatBivariateEntityByFrequency.sql >qryStatBivariateEntityByFrequency.log

:mysql -vvv <qryStatBivariateFrequencyByCallsign.sql >qryStatBivariateFrequencyByCallsign.log
:mysql -vvv <qryStatBivariateServiceByCallsign.sql >qryStatBivariateServiceByCallsign.log
:mysql -vvv <qryStatBivariateStationByCallsign.sql >qryStatBivariateStationByCallsign.log
:mysql -vvv <qryStatBivariateEntityByCallsign.sql >qryStatBivariateEntityByCallsign.log

:mysql -vvv <qryStatBivariateFrequencyByService.sql >qryStatBivariateFrequencyByService.log
:mysql -vvv <qryStatBivariateCallsignByService.sql >qryStatBivariateCallsignByService.log
:mysql -vvv <qryStatBivariateStationByService.sql >qryStatBivariateStationByService.log
:mysql -vvv <qryStatBivariateEntityByService.sql >qryStatBivariateEntityByService.log

:mysql -vvv <qryStatBivariateFrequencyByStation.sql >qryStatBivariateFrequencyByStation.log
:mysql -vvv <qryStatBivariateCallsignByStation.sql >qryStatBivariateCallsignByStation.log
:mysql -vvv <qryStatBivariateServiceByStation.sql >qryStatBivariateServiceByStation.log
:mysql -vvv <qryStatBivariateEntityByStation.sql >qryStatBivariateEntityByStation.log

:mysql -vvv <qryStatBivariateFrequencyByEntity.sql >qryStatBivariateFrequencyByEntity.log
:mysql -vvv <qryStatBivariateCallsignByEntity.sql >qryStatBivariateCallsignByEntity.log
:mysql -vvv <qryStatBivariateServiceByEntity.sql >qryStatBivariateServiceByEntity.log
:mysql -vvv <qryStatBivariateStationByEntity.sql >qryStatBivariateStationByEntity.log


:CREATETIMESERIES
:mysql -vvv <qryTimeSeries1.sql >qryTimeSeries1.log
:mysql -vvv <qryTimeSeries2.sql >qryTimeSeries2.log
:mysql -vvv <qryTimeSeries3.sql >qryTimeSeries3.log
:mysql -vvv <qryTimeSeries4.sql >qryTimeSeries4.log
:mysql -vvv <qryTimeSeries5.sql >qryTimeSeries5.log
:mysql -vvv <qryTimeSeries6.sql >qryTimeSeries6.log


:PLOTTIMESERIES
del liass-call_sign.png
del liass-call_sign.pdf
del liass-call_sign.svg
del liren-call_sign.png
del liren-call_sign.pdf
del liren-call_sign.svg
del liass-call_sign-scaled.png
del liass-call_sign-scaled.pdf
del liass-call_sign-scaled.svg
del liren-call_sign-scaled.png
del liren-call_sign-scaled.pdf
del liren-call_sign-scaled.svg
:%RPATH% --no-save <plot9.r >plot.log


:mysql -vvv <qryPlotYear.sql >qryPlotYear.log
:mysql -vvv <qryPlotTest-Explain.sql >qryPlotTest-Explain.log
:mysql -vvv <qryPlotTest.sql >qryPlotTest.log
:mysql -vvv <createindexes-plottest-mysql.sql >createindexes-plottest-mysql.log

:@call export-plot.bat qryPlotGeoYearFrequencyAll
:@call export-plot.bat qryPlotGeoYearFrequencyUnique
:@call export-plot.bat qryPlotGeoYearFrequencyProportion
:@call export-plot.bat qryPlotGeoYearFrequencyNew

:@call export-plot.bat qryPlotGeoYearFrequency026050
:@call export-plot.bat qryPlotGeoYearFrequency150162
:@call export-plot.bat qryPlotGeoYearFrequency450512
:@call export-plot.bat qryPlotGeoYearFrequency806857
:@call export-plot.bat qryPlotGeoYearFrequency896940

:@call export-plot.bat qryPlotGeoYearFrequencyNew026050
:@call export-plot.bat qryPlotGeoYearFrequencyNew150162
:@call export-plot.bat qryPlotGeoYearFrequencyNew450512
:@call export-plot.bat qryPlotGeoYearFrequencyNew806857
:@call export-plot.bat qryPlotGeoYearFrequencyNew896940

:@call export-plot.bat qryPlotGeoYearCallsignAll
:@call export-plot.bat qryPlotGeoYearCallsignUnique
:@call export-plot.bat qryPlotGeoYearCallsignProportion
:@call export-plot.bat qryPlotGeoYearCallsignEQ464575

:@call export-plot.bat qryPlotGeoYearEntityAll
:@call export-plot.bat qryPlotGeoYearEntityUnique
:@call export-plot.bat qryPlotGeoYearEntityProportion

:@call export-plot.bat qryPlotGeoYearCallsignFrequency
:@call export-plot.bat qryPlotGeoYearCallsignNewFrequency
:@call export-plot.bat qryPlotGeoYearFrequencyCallsign


:SUMMARYSTATISTICS
mysqlcheck -v uls --analyze --optimize
@call summary-statistics.bat


:mysql -vvv <qryAnomalyUHFPairs.sql >qryAnomalyUHFPairs.log


:ANALYZEDIVERSITY
: (doesn't work...yet)
:mysql -vvv <qryStatIQVFrequencyBandByCounty.sql >qryStatIQVFrequencyBandByCounty.log
:mysql -vvv <qryStatIQVCountyCallsignByBand.sql >qryStatIQVCountyCallsignByBand.log
:mysql -vvv <qryStatIQVFrequencyCallsignByCounty.sql >qryStatIQVFrequencyCallsignByCounty.log


:ANALYZEDATAMINING
: (tools not installed on new machine...yet)
::testxslt -in tblOrgBigRetail.xml -xsl xsltOrgBigRetail.xsl -out tblOrgBigRetail.arff -validate
:testxslt -in tblOrgBigRetail.xml -xsl xsltOrgBigRetail.xsl -out tblOrgBigRetail.arff
:pause
:java -Xmx1024m weka.classifiers.trees.J48 -t tblOrgBigRetail.arff >tblOrgBigRetail-weka.txt


:ANALYZESOCIALNETWORK
:mysql -vvv <qryGeoStateCA-dbase.sql >qryGeoStateCA-dbase.log
:del liass-call_sign.png
:del liass-call_sign.pdf
:del liass-call_sign.svg
:@call sna-netdraw.bat tblGeoCountiesSoCal-Frequency
:%RPATH% --no-save <sna1.r >sna.log
:@call sna.bat


:EXPORTMYSQL
@call export-mysql.bat tblDistLocationStateCounty
@call export-mysql.bat tblDistLocationStateCountyCity

:@call export-mysql.bat tblGeoUS
@call export-mysql.bat tblGeoStateCA

@call export-mysql.bat tblGeoCountiesSoCal
@call export-mysql.bat tblGeoCountyLosAngeles
@call export-mysql.bat tblGeoCityLosAngeles
:@call export-mysql.bat tblGeoCountiesMetroScan
:@call export-mysql.bat tblGeoCountiesPoliceCall
:@call export-mysql.bat tblGeoCountiesSCAN
:@call export-mysql.bat tblGeoCountiesScanFan

@call export-mysql.bat tblOrgStateCA
@call export-mysql.bat tblOrgCountyLosAngeles
@call export-mysql.bat tblOrgCountyLosAngelesMTA
@call export-mysql.bat tblOrgCityLosAngeles
@call export-mysql.bat tblOrgCityLosAngelesWP
@call export-mysql.bat tblOrgAnchor
@call export-mysql.bat tblOrgBigRetail
@call export-mysql.bat tblOrgLargeSMR
@call export-mysql.bat tblOrgCPRA

@call export-mysql.bat tblSampleLASDSimplex
@call export-mysql.bat tblSampleFederal
@call export-mysql.bat tblSampleRailroad

:@call export-mysql.bat tblEmulatePoliceCall

@call export-mysql.bat tblStatIQVFrequencyBandByCounty
@call export-mysql.bat tblStatIQVCountyCallsignByBand
@call export-mysql.bat tblStatIQVFrequencyCallsignByCounty


:EXPORTMSACCESS
@call export-msaccess.bat tblGeoStateCA
@call export-msaccess.bat tblGeoCountiesSoCal

:copy /y c:\wsmith\download\tblGeoStateCA-2003.mdb c:\wsmith\download\tblGeoStateCA-2003-prior.mdb
del c:\wsmith\download\tblGeoStateCA-2007-prior.mdb
ren c:\wsmith\download\tblGeoStateCA-2007.mdb tblGeoStateCA-2007-prior.mdb
copy /y tblGeoStateCA-2007.mdb c:\wsmith\download
:copy /y c:\wsmith\download\tblGeoCountiesSoCal-2003.mdb c:\wsmith\download\tblGeoCountiesSoCal-2003-prior.mdb
del c:\wsmith\download\tblGeoCountiesSoCal-2007-prior.mdb
ren c:\wsmith\download\tblGeoCountiesSoCal-2007.mdb tblGeoCountiesSoCal-2007-prior.mdb
copy /y tblGeoCountiesSoCal-2007.mdb c:\wsmith\download


:EXPORTDBASE
mysql -vvv <qryGeoStateCA-dbase.sql >qryGeoStateCA-dbase.log
@call export-dbase.bat tblGeoStateCA
mysql -vvv <qryGeoCountiesSoCal-dbase.sql >qryCountiesSoCal-dbase.log
@call export-dbase.bat tblGeoCountiesSoCal


:EXPORTSQLITE
:@call export-sqlite.bat tblGeoUS
:@call export-sqlite.bat tblGeoStateCA
@call export-sqlite.bat tblGeoCountiesSoCal


:EXPORTOOOBASE
:@call export-ooobase.bat tblGeoStateCA


:EXPORTMSEXCEL
:@call export-spreadsheet.bat tblOrgStateCA
:copy /y export-spreadsheet.pl export-spreadsheet-pl.txt
:(needs work)
:@call export-spreadsheet-org.bat tblSoCalOrgs
:copy /y export-spreadsheet-org.pl export-spreadsheet-org-pl.txt


:EXPORTFIXEDWIDTH
del tblOrgCityLosAngeles-fixedwidth.txt
::del tblStatIQVFrequencyByCounty-fixedwidth.txt
::del tblStatIQVCountyCallsignByBand-fixedwidth.txt
::del tblStatIQVFrequencyCallsignByCounty-fixedwidth.txt
:mysql -vvv <qryExportFixedWidth.sql >qryExportFixedWidth.log


:CREATESUBSCRIPTIONFILES
:%RPATH% --no-save <subscribe4.r >subscribe.log


:CREATEEARTHANDMAPFILES
@call earthandmaps.bat


:GENERATESCHEMAS
:java -jar schemaSpy_4.1.0.jar -cp mysql-connector-java-5.0.4-bin.jar -t mysql -o library -host localhost -db uls -u root
:java -jar schemaSpy_4.1.0.jar -cp mysql-connector-java-5.0.4-bin.jar -t mysql -o library -host localhost -db uls -u wsmith
:java -jar schemaSpy_5.0.0.jar -cp mysql-connector-java-5.1.13-bin.jar -t mysql -o library -host localhost -db uls -u wsmith -gv "c:\Program Files\Graphviz2.26.3"
java -jar schemaSpy_5.0.0.jar -cp mysql-connector-java-5.1.13-bin.jar -t mysql -o library -host localhost -db uls -u wsmith -gv "c:\Program Files\Graphviz"


:DERIVEFILESIZES
perl -w get-filesize.pl tblGeoStateCA-2007.mdb
perl -w get-filesize.pl tblGeoStateCA-2003.mdb
perl -w get-filesize.pl tblGeoStateCA-2000.mdb
perl -w get-filesize.pl tblGeoCountiesSoCal-2007.mdb
perl -w get-filesize.pl tblGeoCountiesSoCal-2003.mdb
perl -w get-filesize.pl tblGeoCountiesSoCal-2000.mdb

move dbase\STATECA5.DBF
perl -w get-filesize.pl stateca5.dbf
move STATECA5.DBF dbase

move dbase\STATECA4.DBF
perl -w get-filesize.pl stateca4.dbf
move STATECA4.DBF dbase

move dbase\STATECA3.DBF
perl -w get-filesize.pl stateca3.dbf
move STATECA3.DBF dbase

move dbase\COSOCAL5.DBF
perl -w get-filesize.pl cosocal5.dbf
move COSOCAL5.DBF dbase

move dbase\COSOCAL4.DBF
perl -w get-filesize.pl cosocal4.dbf
move COSOCAL4.DBF dbase

move dbase\COSOCAL3.DBF
perl -w get-filesize.pl cosocal3.dbf
move COSOCAL3.DBF dbase

perl -w get-filesize.pl tblGeoStateCA.sqlite3x
perl -w get-filesize.pl tblGeoStateCA-with-indexes.sqlite3x
perl -w get-filesize.pl tblGeoStateCA.sqlite2x
perl -w get-filesize.pl tblGeoStateCA-with-indexes.sqlite2x
perl -w get-filesize.pl tblGeoCountiesSoCal.sqlite3x
perl -w get-filesize.pl tblGeoCountiesSoCal-with-indexes.sqlite3x
perl -w get-filesize.pl tblGeoCountiesSoCal.sqlite2x
perl -w get-filesize.pl tblGeoCountiesSoCal-with-indexes.sqlite2x
perl -w get-filesize.pl tblGeoStateCA.xml
perl -w get-filesize.pl tblGeoCountiesSoCal.xml


:UPLOAD
:@call upload.bat
: comment out next line to skip (no, not now)
:@call upload-ncftp.bat


:END
mysqlcheck -v uls --analyze --optimize
net stop MySQL
del i:\mysql\data\.log
SET RPATH=