pdf reader c# : Deleting text from a pdf Library software component asp.net winforms windows mvc MapInfoProfessionalUserGuide23-part756

Tocanceltheselectionofallselectedobjects,youcaneitherclicktheMapwindowwherethereareno
objectsorchoosetheUnselectAllcommandfromtheQuerymenu.
Querying Your Data in MapInfo Professional
Aqueryisamathematicalquestionthatyouposetoyourdatabasetocollectinformation.InMapInfo
Professional,therearetwoquerybuildersavailableundertheQuerymenu,SelectandSQLSelect.
Figure:SQLQuerytoDetermineHomesAffectedbyAirportNoisePollution
InthecaseofSelect,youcanposeaquestionofasingletable.Forexample,
• Whichofmycustomersspentmorethan$20,000?
• WhichofmycustomersliveinVermont?
InthecaseofSQLSelect,youcanaskyourquestionfromoneorseveraltable(s)ofinformationand
performthesetasks:
• Derivenewcolumns-columnsthatcalculatenewvaluesbasedonthecontentsofyourexisting
columns.
• Aggregateyourdatasothatyouseeonlyalistingofsubtotalsinsteadofseeingyourentiretable.
• Combinetwoormoretablesintooneresultstable.
• Showonlythecolumnsandrowsthatinterestyou.
SelectingandUsingQueries
Selectallowsyoutoqueryatable.Itallowsyoutoselectrecordsandobjectsfromatableaccording
totheirattributes.YoucanuseittohighlightobjectsinaMaporBrowserwindowthatmeetcertain
criteria.Youcanalsocreatearesultstablethatyoucanbrowse,map,orgraphlikeanyothertable.
231
MapInfoProfessionalUserGuide
Chapter9:SelectingandQueryingData
Deleting text from a pdf - delete, remove text from PDF file in C#.net, ASP.NET, MVC, Ajax, WinForms, WPF
Allow C# developers to use mature APIs to delete and remove text content from PDF document
pdf editor online delete text; delete text pdf files
Deleting text from a pdf - VB.NET PDF delete text library: delete, remove text from PDF file in vb.net, ASP.NET, MVC, Ajax, WinForms, WPF
VB.NET Programming Guide to Delete Text from PDF File
how to remove highlighted text in pdf; how to delete text in pdf converter professional
Forinstance,byformulatingquerieswithSelect,youcanaskMapInfoProfessionalto:
• Showonlypostalcoderegionswheretheaveragehouseholdincomeisabove$65,000.
• Showonlypostalcoderegionswherethemedianageis42.
• Showonlythepostalcoderegionswherethehouseholdincomeisabove$65,000andthemedian
ageis42.
• ShowonlyrecordsforallordersreceivedinJulyorSeptember.
• Showcitiesofover100,000peopleinTexas,CaliforniaandFlorida.
WhenyouareworkinginaBrowser,MapInfoProfessionalhighlightstherecordsmeetingthecriteriaof
thequery.WhenyouareworkinginaMapwindow,thegraphicobjectsofthechosenrecordsare
highlighted.Whenyouareworkinginbothwindows,theobjectsinbotharehighlighted.Inallcases,
MapInfoProfessionalautomaticallycreatesaworkingtablecalledSelectionthatcontainstheresultsof
thequery.Youcanbrowse,map,orgraphthistablelikeanyothertable.Thetablecanalsobesaved
asaseparatetablewithSaveCopyAs.
FindinganObjectorStreetAddress
Tofindanobjectorstreetaddress:
Yourtablesmustbemappableandindexed.Ifyouneedtosetupthesecomponents,ontheFilemenu
pointtoNewTable(Import)orontheTablemenupointtoMaintenanceandselectTableStructure.
1. OntheQuerymenu,pointtoFindtoopentheFinddialogbox.
2. ClicktheSearchtabledrop-downlistandchooseatablefromwhichtosearch.
3. Clicktheforobjectsincolumndrop-downlistandchoosethecolumncontainingthelocationinformation
oftheobjectsyouarelookingfor.
Younowhavetheoptionofrefiningthesearch.Usethisoptionwhenyouaretryingtofindanobject
oraddresswhosenameisnotuniqueandisusedforotherobjectsorlocations.
Forexample,whenyouaresearchingforthetownofIpswichinGreatBritain,doyouwantIpswich
inSuffolkcountyorIpswichinEssexcounty.Refiningthesearchbycountyallowsyoutospecifythe
countyforeachtown,ratherthanjustthetownname.
• Optional-ClicktheRefinesearchwithtabledrop-downlistandchoosearefiningtable(thetable
mustcontainregions,suchasstates,counties,censustractsetc.).
• Optional-Clicktheusingboundarynamecolumndrop-downlistandchooseyourrefiningcolumn,
thecolumncontainingthenameoftheboundary.
4. ChecktheFindinFrontWindowOnlycheckboxwhenyouwanttheFindoperationexecutedonly
intheFrontWindow.Whenthischeckboxisunchecked,theFindoperationisexecutedinallwindows.
Whenchecked,iffeaturesarefound,theywillbemarkedwithasymbolinaMapWindow.Ifthe
Browserwindowistheactivewindow,itwillbescrolledsotherecordappearsintheBrowserview.
Whenyouhavefinisheddefiningwheretolookforyoursearchdataandselectingbetweenthefront
mostmapandallmapsthenspecifywhatdatatolookfor.
5. ClickOKtoopentheFinddialogbox.Thisdialogboxallowsyoutospecifywhatdatatolookfor.
ThenameofthecolumnthatyouspecifiedinthefirstFinddialogboxislistedtotheleftofthelist
box(forexample,Street).Whenlocatingastreetaddress,typein"#Name",suchas"30ElmSt"or
"1045TemplarBlvd."WhatyoutypeindependsongeocodingpreferencesspecifiedontheOptions
menuwhenyoupointtoPreferencesandselectAddressMatching.
MapInfoProfessionalcomeswithatextfilecalledMAPINFOW.ABB[MapInfoProfessional
Abbreviations],thatcontainsalistofcommonstreetabbreviations,suchas"St"for"Street"
Note:
and"Blvd."for"Boulevard,"andsoforth.ThesehelpMapInfoProfessionaltoobtainexact
matches.TofamiliarizeyourselfwiththeMAPINFOW.ABBfile,youcantakealookatits
contentsintheNotepadTextEditor.
6. Typethenameoftheobjectoraddressyouaresearchingforinthisbox.IfyouhaveusedtheRefine
optioninthefirstdialogbox,asecondcolumnnameislisted(forexample,ZIP).
MapInfoProfessional12.5
232
QueryingYourDatainMapInfoProfessional
C# PDF insert text Library: insert text into PDF content in C#.net
developers to add multiple text processing functions to PDF document imaging application, such as inserting text to PDF, deleting text from PDF, searching text
how to delete text from a pdf reader; delete text pdf
C# PDF Page Delete Library: remove PDF pages in C#.net, ASP.NET
Provide C# Users with Mature .NET PDF Document Manipulating Library for Deleting PDF Pages in C#. C#.NET Project DLLs for Deleting PDF Document Page.
delete text pdf acrobat professional; how to delete text from a pdf document
7. Typethenameoftherefiningboundaryinthisbox.IfMapInfoProfessionalcannotfindanexact
matchfortheobjectyouspecified,itlistspossiblematches.
8. ClickUporDowntomovetootherpagesandchooseaspecificentryfromthelist.
9. ClickOKandthefindisinitiated.
YoucanalsousetheFindcommandtolocatestreetintersections.Whenyoutypeinthenameof
theobjecttobefoundinthesecondFinddialogbox(enterobjectnametofind),separatethetwo
itemsbyadoubleampersand(&&).Forexample,tofindtheintersectionofCongressStreetand
ChristieStreet,type"CongressStreet&&ChristieStreet."
FindingandDisplayingaSelectedObject
WhenyoucreateaqueryoraSQLquery,youmaywanttoseetheresultsofthatqueryvisuallyonthe
map.
Tofindanddisplayaselectedobject:
1. Dooneofthefollowing:
• OntheQuerymenu,pointtoSelecttoopentheSelectdialogbox
• OntheQuerymenu,pointtoSQLSelecttoopentheSQLSelectdialogbox
TheFindResultsinCurrentMapWindowcheckboxdisplaysinbothdialogboxes.
2. Createyourqueryandverifythatitiscorrect,selectingtheopentablethatyouwanttoquery.
3. SelecttheFindResultsinCurrentMapWindowcheckboxtodisplaytheresultsuponcompletion.
4. ClickOKtodisplaytheresults.
5. Formoreinformation,seeSelectingAllObjectsfromaTableintheHelpSystem.
Figure:QueryResultsofUrbanPopulation>RuralPopulation
233
MapInfoProfessionalUserGuide
Chapter9:SelectingandQueryingData
VB.NET PDF Page Delete Library: remove PDF pages in vb.net, ASP.
Free PDF edit control and component for deleting PDF pages in Visual Basic .NET framework application. DLLs for Deleting Page from PDF Document in VB.NET Class.
how to delete text in pdf converter; acrobat delete text in pdf
VB.NET PDF insert text library: insert text into PDF content in vb
NET users to add multiple text processing functions to PDF document imaging application, such as inserting text to PDF, deleting text from PDF, searching text
how to delete text from pdf reader; how to delete text in a pdf file
MakingQueriesusingtheSelectCommand
MapInfoProfessionalhastwocommandsforselectingobjectsthroughquerying:SelectandSQLSelect.
SelectissimplerandSQLSelectismorepowerful.
Tomakeaquery:
1. ChooseQuery>Select.TheSelectdialogboxdisplays.
2. ClickontheSelectrecordsfromtabledrop-downlistandchoosethetablefromwhichtoselectthe
records.
3. Typeyourqueryexpressioninthethatsatisfybox,orclicktheAssistbuttontodisplaythe
Expressiondialogboxwhichhelpsyouwriteanexpression.
4. TypeanameintheStoreResultsintableboxforthetemporarytablethatstorestheresultsofyour
queryorchooseselection(thedefault).IfSelectionischosen,MapInfoProfessionalautomatically
namesthetableQuery1,Query2etc.
5. Tosortthequerybythevalueinsomecolumn(optional)clicktheSortresultsbycolumndrop-down
listandchoosethecolumncontainingthevalueyouwanttosortwith.
6. ClickOK.ABrowserwindowofyourqueryresultsdisplaysiftheBrowseResultsboxischecked.
YoucanuseSelecttohighlightobjectsinamaporatablethatmeetcertaincriteriaandcreatearesults
tablethatyoucanbrowse,map,orgraphlikeanyothertable.
• WhenyouareworkinginaBrowserwindow,therecordsmeetingthecriteriaofthequeryarehighlighted.
• Whenyouareworkinginamap,thegraphicobjectsofthechosenrecordsarehighlighted.
• WhenyouareworkingwithbothaMapwindowandaBrowserwindow,theobjectsandtherecords
arehighlighted.
Inallcases,aworkingtableisautomaticallycreatedcalledQuery3.Thistablecontainstheresultsof
thequery.Youcanmap,orgraphthistablelikeanyothertable.Thetablecanalsobesavedasa
separatetablewithSaveCopyAs.
• Formoreinformation,seeSavingQueriesandLoadingTemplatesintheHelpSystem.
MakingQueriesusingtheSQLSelectCommand
TocreateaqueryusingSQLSelect:
MapInfoProfessional12.5
234
QueryingYourDatainMapInfoProfessional
C# PDF File & Page Process Library SDK for C#.net, ASP.NET, MVC
PDF to tiff, VB.NET read PDF, VB.NET convert PDF to text, VB.NET Easily manipulate multi-page PDF document file with page inserting, deleting and re
how to delete text in pdf file online; deleting text from a pdf
C#: How to Delete Cached Files from Your Web Viewer
C#.NET rotate PDF pages, C#.NET search text in PDF VB.NET How-to, VB.NET PDF, VB.NET Word, VB Introduce Visual C#.NET Developers the Ways of Deleting Cache Files.
how to delete text from a pdf; how to delete text in pdf document
1. Openthetableyouwishtoquery,ifyouhavenotalreadydoneso.Thetablethatyouqueryisknown
asthebasetable.IfyouuseSQLSelecttoperformaqueryontheWorldtable,theWorldtableis
yourbasetable.
2. ChooseQuery>SQLSelect.FillintheportionsoftheSQLSelectdialogboxthatmeetyourneeds.
WhenyouclickOK,MapInfoProfessionalperformsthequery.
MapInfoProfessionalextractsdatafromyourbasetable,storesthequeryresultsinaspecial,
temporarytable,knownastheresultstable.Theresultstablecontainsonlytherowsandcolumns
thatmeetyourcriteria.ThedefaultnameoftheresultstableisSelection(althoughyoucanspecify
adifferentresultstablenameintheIntoTableNamedfieldintheSQLSelectdialogbox).
3. OpenaMapwindowand/oraBrowserwindowifyouwanttoseethequeryresults.Bydefault,
MapInfoProfessionaldisplaystheresultstableinaBrowserwindowautomatically(unlessyouclear
theBrowseResultscheckboxintheSQLSelectdialogbox).
IfyourresultstableiscalledSelection(thedefaultname),theBrowserwindowshowsadifferent
tablename,suchasQuery1orQuery2.ThisisbecausethemomentyouBrowsetheSelectiontable,
MapInfoProfessionaltakesa"snapshot"ofthetable,andnamesthesnapshotQueryn(wherenis
anumber,oneorgreater).MapInfoProfessionaltakesthesnapshotbecause"Selection"isaspecial
tablename;Selectiondynamicallychangeseverytimeyouselectorde-selectrows.
IntheSQLSelectdialogbox,youcanenteradifferentnameforyourresultstable(e.g.youcan
nameyourresultstableMy_Query).ThispreventsMapInfoProfessionalfromrenamingyourresults
tableQueryn.
4. MapInfoProfessionalautomaticallyselectsallrowsintheresultstable.Thus,afteryouperformSQL
Select,youcanperformoperationsontheentiresetofselectedrows.Forexample,youcouldapply
adifferentfillcolortoallselectedrows(bychoosingOptions>RegionStyle),oryoucouldcutor
copyallselectedrows.
5. Usually,anyalterationsyoumaketotheresultstableareautomaticallyappliedtoyouroriginal(base)
table.Forexample,ifyouuseSQLSelecttoselectsomeoftherowsfromtheOrderstable,andthen
youdeletesomeoftherowsfromyourresultstable,MapInfoProfessionaldeletesthecorresponding
rowsfromyourbasetable(Orders).However,ifyourqueryproducessubtotals,youcanalterthe
resultstablewithoutaffectingthebasetable.
6. ChooseFile>SaveAsifyouwanttomakeapermanentcopyoftheresultstable.Ifyoudonot
performSaveAs,theresultstablewillbedeletedwhenyouexitMapInfoProfessional.
Formoreinformation,seeUsingtheSQLSelectDialogBox'sWhereConditionField,UpdatingaSQL
SelectQueryTableandUsingtheSQLSelectDialogBox'sSelectColumnsFieldTemplatesintheHelp
System.
DisplayingQueryResultsQuickly
WhenyoucreateaqueryoraSQLquery,youcandisplaytheresultsvisuallyonthemap.
Tofindanddisplaytheresultsofaqueryautomatically:
1. Dooneofthefollowing:
• FromtheQuerymenu,selectSelecttodisplaytheSelectdialogbox
• FromtheQuerymenu,selectSQLSelecttodisplaytheSQLSelectdialogbox
235
MapInfoProfessionalUserGuide
Chapter9:SelectingandQueryingData
C# PDF remove image library: remove, delete images from PDF in C#.
VB.NET read PDF, VB.NET convert PDF to text, VB.NET C# PDF - Remove Image from PDF Page. Provide C# Demo Code for Deleting and Removing Image from PDF File Page.
how to erase text in pdf; delete text pdf acrobat
C# Word - Delete Word Document Page in C#.NET
C# Word - Delete Word Document Page in C#.NET. Provides Users with Mature Document Manipulating Function for Deleting Word Pages. Overview.
how to delete text from pdf document; pdf text watermark remover
TheFindResultsinCurrentMapWindowcheckboxdisplaysinbothdialogboxes.Ifthereare
noopenMapwindows,thischeckboxisdisabled.Youcannotsavethischeckboxsettingtoa
template.Thisoptionisclearedbydefault.
2. Createyourqueryandverifythatitiscorrect,selectingtheopentablethatyouwanttoquery.
3. SelecttheFindResultsinCurrentMapWindowcheckboxtodisplaytheresults.ClickOK.
4. Formoreinformation,seeChoosingWhichColumnsAppearintheResultsTableandCreating
StatisticalCalculationsintheHelpSystem.
CreatingQueryExpressions
ToperformaSelectquery,youmustcreateanexpression.Anexpressionisalogicalstatementthatis
usedtoaskyourquestion.Forexample,youhaveatableofapartmentsforrent.Ifyouwanttocreate
atemporarytableofallapartmentsthatcostlessthan$800amonth,youcouldusetheexpression:
• RENT<800
whereRENTisthenameofanumericcolumnthatcontainsthepermonthrentrate.
MapInfoProfessionalsearchestheapartmenttableforallrecordsthatsatisfythisconditionandputs
thoserecordsinatemporarytablethatyoucanmap,browse,graphorcarryoutadditionalqueries.
Youcanalsoperformmathematicaloperationsonyourdata.Forexample,youwanttocreateatemporary
tableofallapartmentsthathaveatotalcostoflessthan$800.Totalcostisequaltothesumoftherent
andthemonthlyutilities.
Youcouldusetheexpression:
• RENT+UTILITIES<800
YouaretellingMapInfoProfessionaltoaddthenumberintheRENTcolumnandthenumberinthe
UTILITIEScolumnandthencomparethatnumberto800.
Formoreinformation,seeCreatingExpressionsfordetailsincreatingavarietyofexpressions.
SpecifyinganExpression
Therearetwowaysofcreatinganexpression.Thefirstmethodistotypeintheexpressiondirectly.
Whenyouarecreatingverysimpleexpressions,thismethodisusuallyfaster.Thesecondmethodisto
clicktheAssistbuttonintheSelectdialogboxandbuildyourexpressionusingthepopupsinthe
Expressiondialogbox.Thismethodisparticularlyusefulwhenyouarejustlearninghowtobuild
expressionsorwhenyouarebuildingverycomplexexpressions.
Tospecifyanexpression:
MapInfoProfessional12.5
236
QueryingYourDatainMapInfoProfessional
1. ChooseQuery>Select.
2. IntheSelectdialogbox,clicktheAssistbutton.
3. IntheExpressiondialogbox,typeyourexpressiondirectlyintothisbox,orchoosefromthedrop-down
listselectionstocreateanexpression.
4. ClickVerifytoverifythatyourexpressionisvalid.
5. ClickOKtoreturntotheSelectdialogbox.
6. ClickOKtoruntheexpression.
TheExpressiondialogboxgivesyouthreedrop-downliststhatyoucanusetobuildyourexpression:
columns,operators,andfunctions.
Columns
Thispopuplistseverycolumninthetablefromwhichyouareselecting.Ifthetablecontainsderived
columnsfrompreviousqueries,thosecolumnswillalsobelisted.
Operators
Thispopupcontainsmathematicalandlogicaloperationsymbols.Themathematicaloperatorsinthis
popupincludeaddition,subtraction,multiplication,division,greaterthan,lessthan,andequalsigns.
Youcanusethesesymbolstocreatemathematicalformulas.Forexample,fromyourtableofsales
representativesyouwanttoselectthosesalesrepresentativeswho,ontheaverage,grossmorethan
$2000permonth.Grosssalesiscomputedbyaddingtogethersalesandcommission.
Youhavetwocolumnsinyourtable:TOTAL_SALES,whichistotalsalesfortheyearforeach
representativeandCOMMISSION,whichistotalcommissionfortheyearforeachrepresentative.You
couldbuildthefollowingexpression:
• (TOTAL_SALES+COMMISSION)/12<2000
ThisexpressiontellsMapInfoProfessionaltoaddthenumberintheTOTAL_SALEScolumnwiththe
numberintheCOMMISSIONcolumn.However,thisgivesyougrosssalesfortheyear.Wewantaverage
grosssalesforthemonth.Therefore,wedividethesumby12,whichwillgiveusamonthlyaverage.
Wethencomparethatfigurewith2000.
TheOperatorspopupalsoincludeslogicaloperatorsconjunctionsAND,NOT,ORandLIKE.TheLIKE
operatorcanbeusedwithtwowildcardcharacters:`%'and`_'.The`%'charactermatcheszeroormore
characters.The`_'charactermatchesonlyonecharacter.
Functions
Thispopupcontainsmathematicalfunctionsthattakeoneormoreparametersandreturnavalue.You
usefunctionstoperformbasicmathematicalfunctionsonthedatainthatcolumn.Forexample:
• abs(<number>)
takestheabsolutevalueofthenumbersinthespecifiedcolumn.
Forexample,ameteorologistwantstoselectalldayswherethetemperatureinhercitywasmorethan
10degreeswarmerorcoolerthanthenationalaverage.Shehasacolumninhertable,AVG_DIFF,that
containsthedifferencebetweenthenationalaverageandcityaverage.
Shecouldcreatethefollowingexpression:
• AVG_DIFF<-10OrAVG_DIFF>10
ThisexpressiontellsMapInfoProfessionaltoselectallrecordsthathaveanaveragedifferenceless
than-10orgreaterthan+10.However,shecouldalsocreatethefollowingexpression:
• abs(AVG_DIFF)>10
ThisexpressiontellsMapInfoProfessionaltoselectallrecordswheretheabsolutevalueoftheaverage
differenceisgreaterthanten.
TheFunctionspopupcontainsmanyotherfunctions,includingarea,perimeter,sin,cos,anddate-related
functions.Foracompletelistoffunctions,seeCreatingExpressions.
237
MapInfoProfessionalUserGuide
Chapter9:SelectingandQueryingData
Verify
Thisbuttonreviewstheexpressionyouhavecreatedandverifiesthatitisvalid.Thisisparticularlyhelpful
ifyouarenewtowritingexpressions.
UsingSelecttoCreateQueries
IngeneraltheprocessforselectingobjectsusingSelectis:
1. OntheQuerymenu,clickSelecttodisplaytheSelectdialogbox.
• SelectRecordsfromTable-Selectthetablefromwhichtoselectrecords.
• thatSatisfy-Createtheexpressiontoselectrecords.
• StoreResultsinTable-Chooseastorageplaceforresults.
• StoreResultsinColumn-Choosecolumnforsorting.
2. Toseealistoftherecordsyouhaveselected,selecttheBrowseResultscheckbox.MapInfo
ProfessionalcreatesaBrowserofthenewselectiontable.
3. TodisplaythequeryresultsinthecurrentlyactiveMapwindow,selectFindResultsinCurrentMap
Window.IftherearenoopenMapwindows,thischeckboxisdisabled.Youcannotsavethischeck
boxsettingtoatemplate.Thisoptionisclearedbydefault.
4. ClickOKtobeginthequery.
MapInfoProfessionalnamesthetableQuery1.ItwillnamethenexttemporaryselectiontableQuery2.
YoucanoverrideMapInfoProfessional'sdefaultnameandgivetheselectionadescriptivename.Type
thenewnameintotheStoreResultsinTablebox.Thetablecanalsobesavedasaseparatetablewith
SaveCopyAs.
Example:Selecting
MapInfoProfessionalmakesfindinginformationandlocationseasy.YoucanusetheSelectfeatureto
createsubsetdatabases.Asanexample,weusetheWORLDtabletoselectcountrieswithaliteracy
rategreaterthan90%.
1. OpentheWORLD.TABtable.
2. OntheQuerymenu,clickSelecttodisplaytheSelectdialogbox.
3. CompletetheSelectdialogbox:
• SelectRecordsfromTable-FromtheSelectrecordsfromtabledrop-downlist,chooseWorld.
• Assist-ClicktheAssistbuttontodisplaytheExpressiondialogbox.
4. CompletetheExpressiondialogboxasshowninthefigure:
FromtheColumnsdrop-downlist,chooseLiteracy.
FromtheOperatorsdrop-downlist,choose>(thegreaterthansign).
MapInfoProfessional12.5
238
QueryingYourDatainMapInfoProfessional
Type90.
ClickVerifytoconfirmthesyntaxofyourexpression.ClickOKtoclosetheVerifydialogbox.
5. ClickOKtoclosetheExpressiondialogbox.TheSelectdialogboxredisplays.
6. SelecttheBrowseResultscheckbox.
7. ClickOK.MapInfoProfessionalcreatesaBrowserthatcontainstheselections.Noticethatthe
selectionsdisplayinboththeWorldmapandBrowser.
MakingaNewTableUsingaSubsetofaFile
ManyofthedatasetsthatareusedwithMapInfoProfessionalincludemoreobjectsandinformation
thannecessaryforsomeprojects.Inmanycasesitiseasiertoworkwithasubsetofthecompletedata
product.Forexample,ifyouweretrackingcrimestatisticsforacountybycensustract,youwouldnot
needthecensustractsfortheentirestate.
Therearetwowaystocreateanewtablethatwillcontainasubsetoftherecordsfromanexistingfile.
Youcaninteractivelyselecttheobjectsrepresentingtherecordsyouwouldliketoputinthenewtable
usingoneoftheselecttools.Or,youcanusetheSQLSelectcommandtochooseasubsetofobjects
basedonanSQLfunction.ForanexampleusingtheSQLSelectcommand,seeExample1-Computing
PopulationDensityUsingArea.Savingtheresultingtableisthesameprocedure,whetheryouchoose
theobjectsinteractivelyoruseanSQLSelectstatement.
ManyofthequeriesonthefollowingpagescanbedoneeitherbyusingtheSQLSelectcommand
orthroughthesimplerSelectcommand.BecauseSQLSelectismoreversatileandmore
commonlyused,theSQLSelectdialogboxisusedinthefollowingexamples.
Note:
InteractivelySelectingObjects
1. OntheFilemenu,clickOpenandopenthetableinaMapwindow.
2. SelecttheobjectsthatwillmakeupthesubsetwiththeSelecttool,RadiusSearchSelectortool,
orPolygonSearchSelectortool.Shift-click
toselectmultipleobjects.
239
MapInfoProfessionalUserGuide
Chapter9:SelectingandQueryingData
3. OntheFilemenu,clickSaveCopyAsandsavetheSelectiontable.Thetablecanbesavedwith
anyfilename.
UsingSQLSelecttoQueryData
Aselectionisasubsetofdatarowsinatable,chosenbasedonthecontentsofoneormorecolumns
fromthetable.Youcreateselectionsbyformulatingquestions,orqueries,aboutyourdata.Howmany
customersliveinthestateofIdaho?Whichpoliceprecincthasthehighestrateofviolentcrime?MapInfo
Professionalstorestheresultsofthesequestionsintemporarytablescalledquerytables.
Inthefirstpartofthischapter,wediscussedselectionsandquerytablesasaresultofusingQuerySelect
command.WenowturnourattentiontoanextremelypowerfulandusefulfeatureinMapInfoProfessional,
queryingbySQLSelect.
WhileMapInfoProfessional'sSelectcommandletsyouformulatesophisticatedqueries,SQLSelect
goesevenfurther.TherecordsinthequerytablegeneratedbytheSelectcommanddonothaveany
informationinthemthatisnotcontainedintherecordsofthebasetable.Theyare,infact,thesame
records.Theyhavebeenarrangedsothattheycanbeviewedtogether.
WithSQLSelectyoucancreatequerytablescontaininginformationthatwasonlyimplicitinthebase
table(s).
TheSQLSelectdialogboxisoneofthemostelaborateonesinMapInfoProfessional.Butdonotbe
intimidated.Onceyoulearnwhateachboxisusedfor,itisfairlysimpletocreatepowerfulselection
statements.Youcantypedirectlyintotheboxesoryoucanusethepopupmenusontherighttoenter
itemsintotheboxes.
Theeasiestwaytodescribethedialogboxistowalkyouthroughanexample,step-by-step.Thisexample
usesdatafromtheWORLDtableincludedinMapInfoProfessional,soyoucantryoutthisSQLSelect
exerciseyourself.Wehaveincludedabriefdescriptionofthepartsofthedialogboxwitheachstep.A
completedescriptionofeachboxisgivenaftertheexample.
MapInfoProfessional12.5
240
QueryingYourDatainMapInfoProfessional
Documents you may be interested
Documents you may be interested