Re: [MI-L] update sql server column
I am trying to update a SQL table column based on where the features of that table are contained within specific polygons(from a .tab table). The code below gives me a temp table on my C drive with the column properly updated. What I can't figure out is how to get the values in that column on the temp table to update the SQL table where primary id = primary id?
Hope that makes more sense.
-Bob
"Ian Tidy" <[EMAIL PROTECTED]> on Tuesday, October 03, 2006 at 3:30 PM -0700 wrote:
Bob,
Couple of things, first have you tried adding 'Server hdbc Commit' and / or 'Server Refresh temp_tablename'.
What is sounds to me like you are trying to do is update a SQL table based where the features of that table intersect specific polygons. Is that correct?
If this is what you are trying to do, then that is easy enough.
The code you show modifies the SQL table structure, and you cannot do it this way.
Sorry I can't correct your code, I don't fully understand what you are trying to do. If you can explain what your are trying to do a bit more, then I might be able to offer some suggestions.
Cheers Ian
__
Ian Tidy
GIS Administrator
Works Asset Department
Napier City Council
Hastings St, Private Bag 6010, Napier, New Zealand
Phone +64-6-835-7579 Ext. 8115
Fax +64-6-834-4195
mailto:[EMAIL PROTECTED]
http://www.napier.govt.nz
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Robert DeRubeis
Sent: Wednesday, 4 October 2006 9:43 a.m.
To: mapinfo-l@lists.directionsmag.com
Subject: [MI-L] update sql server column
I'm trying to write a mapbasic app that will update a table in a SQL server 2000 database from a .tab polygon table where the polygon table contains the table in SQL server (which has lat and long fields from which I can create points). Is this possible to do?
I've connected to the sql server using the following code-
__
Dim hdbc as Integer
Dim hstmt as Integer
hdbc=server_connect("QELIB", connect_string)
hstmt=server_execute(hdbc, "Select * from tablename")
Server hstmt Fetch Into "temp_tablename"
Server hstmt close
Open table "c:\polygonboundary.TAB" Interactive
Set style symbol makesymbol(32,255,10)
Create map for temp_tablename coordsys earth projection 1,74
Update temp_tablename
Set Obj-CreatePoint(Long, Lat)
Commit Table temp_tablename Interactive
Add Column "temp_tablename"(column) From polygonboundary Set To 'column of polygonboundary' Where Contains
Commit Table temp_tablename Interactive
Server hdbc Disconnect
__
The above code will only update the temp_tablename and NOT the table in SQL server. I also tried the following server command- hstmt=Server_Execute(hdbc, "Update tablename Set column_name=700"), which worked and changed the rows in the SQL table, but does not account for where the polygon table contains the points.
Any help is appreciated.
Thanks,
Bob
___
MapInfo-L mailing list
MapInfo-L@lists.directionsmag.com
http://www.directionsmag.com/mailman/listinfo/mapinfo-l
[MI-L] update sql server column
I'm trying to write a mapbasic app that will update a table in a SQL server 2000 database from a .tab polygon table where the polygon table contains the table in SQL server (which has lat and long fields from which I can create points). Is this possible to do?
I've connected to the sql server using the following code-
__
Dim hdbc as Integer
Dim hstmt as Integer
hdbc=server_connect("QELIB", connect_string)
hstmt=server_execute(hdbc, "Select * from tablename")
Server hstmt Fetch Into "temp_tablename"
Server hstmt close
Open table "c:\polygonboundary.TAB" Interactive
Set style symbol makesymbol(32,255,10)
Create map for temp_tablename coordsys earth projection 1,74
Update temp_tablename
Set Obj-CreatePoint(Long, Lat)
Commit Table temp_tablename Interactive
Add Column "temp_tablename"(column) From polygonboundary Set To 'column of polygonboundary' Where Contains
Commit Table temp_tablename Interactive
Server hdbc Disconnect
__
The above code will only update the temp_tablename and NOT the table in SQL server. I also tried the following server command- hstmt=Server_Execute(hdbc, "Update tablename Set column_name=700"), which worked and changed the rows in the SQL table, but does not account for where the polygon table contains the points.
Any help is appreciated.
Thanks,
Bob
___
MapInfo-L mailing list
MapInfo-L@lists.directionsmag.com
http://www.directionsmag.com/mailman/listinfo/mapinfo-l
[MI-L] update sql server column
I'm trying to write a mapbasic app that will update a table in a SQL server 2000 database from a .tab polygon table where the polygon table contains the table in SQL server (which has lat and long fields from which I can create points). Is this possible to do?
I've connected to the sql server using the following code-
__
Dim hdbc as Integer
Dim hstmt as Integer
hdbc=server_connect("QELIB", connect_string)
hstmt=server_execute(hdbc, "Select * from tablename")
Server hstmt Fetch Into "temp_tablename"
Server hstmt close
Open table "c:\polygonboundary.TAB" Interactive
Set style symbol makesymbol(32,255,10)
Create map for temp_tablename coordsys earth projection 1,74
Update temp_tablename
Set Obj-CreatePoint(Long, Lat)
Commit Table temp_tablename Interactive
Add Column "temp_tablename"(column) From polygonboundary Set To 'column of polygonboundary' Where Contains
Commit Table temp_tablename Interactive
Server hdbc Disconnect
__
The above code will only update the temp_tablename and NOT the table in SQL server. I also tried the following server command- hstmt=Server_Execute(hdbc, "Update tablename Set column_name=700"), which worked and changed the rows in the SQL table, but does not account for where the polygon table contains the points.
Any help is appreciated.
Thanks,
Bob
___
MapInfo-L mailing list
MapInfo-L@lists.directionsmag.com
http://www.directionsmag.com/mailman/listinfo/mapinfo-l
[MI-L] Centering Thematic Legends
I recently updated MI Pro from 7.8 to 8.5 and noticed that when I create a thematic legend, everything is Left justified. Using v7.8, the title, subtitle and ranges would all come up centered. Somewhere in v8.0 or 8.5 (I assume) mapinfo changed this to be left justified. I'd like to have the thematic legends centered like they were in v7.8. Does anyone know a way to do this? Thanks, Bob ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
Re: [MI-L] [Spam] saving to pdf form
I use eDocPrinter PDF Pro to create pdf files. It works as a printer in windows so any windows application when you choose print, just change to the eDocPrinter, and it will it as a pdf. It's worked great for me, even with large layouts in MapInfo. The link to download is below. http://www.iteksoft.com/modules.php?op=modload&name=Sections&file=index&req=viewarticle&artid=1&page=1 Hope this helps. -Bob [EMAIL PROTECTED] on Thursday, June 22, 2006 at 5:20 AM -0700 wrote: once I have a workspace or layout saved, how can I turn this into a PDF or pdf type of file so I can email it to a coworker? I package it all but have to send all the files which are to big to send in our company email Check out AOL.com today. Breaking news, video search, pictures, email and IM. All on demand. Always Free. ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
[MI-L] csv export error
List, I'm trying to export a MapInfo table to a .csv format, but I'm getting the following error message: "Unable to access string resource (3286)". Can anyone tell me why this is occurring? I am running MapInfo Pro V 7.8 with the latest patches installed on Win XP. Thanks, Bob ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
Re: [MI-L] sql select
That's what the problem was. Table A was not mappable and Table B was mappable. I made Table A mappable and ran the same query and it selected the records from Table A. Thanks for the help. -Bob "Mike Mayer" <[EMAIL PROTECTED]> on Thursday, April 13, 2006 at 9:46 AM -0700 wrote: Are the records in Table A mappable? If so, try going to table maintainence and uncheck the box that makes the table mappable and try again. We came across this same problem and that solution seemed to work, but I’m not sure why! You may need to try switching the table order again as well. Mike Mayer GIS Technician Strongbow Exploration Inc. Suite 800 - 625 Howe St. Vancouver, BC V6C 2T6 (604)668-8370 www.strongbowexploration.com From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Robert DeRubeis Sent: Thursday, April 13, 2006 9:22 AM To: mapinfo-l@lists.directionsmag.com Subject: [MI-L] sql select List, I'm having a problem with a selection query. I have 2 tables both editable with a common column named "ID". Table B is my "deleted" records which I want to find in table A to delete. When I run the following sql select statement- Select * from Table A, Table B where Table A.ID = Table B.ID It selects the records, but only from Table B, not from Table A which is the table I need to delete them from. I also tried switching around the table order (Select * from Table B, Table A where Table B.ID = Table A.ID), but it still only selects records from Table B, not table A. How can I get it to select the records in Table A, not the records in Table B? Thanks, -Bob ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
[MI-L] sql select
List, I'm having a problem with a selection query. I have 2 tables both editable with a common column named "ID". Table B is my "deleted" records which I want to find in table A to delete. When I run the following sql select statement- Select * from Table A, Table B where Table A.ID = Table B.ID It selects the records, but only from Table B, not from Table A which is the table I need to delete them from. I also tried switching around the table order (Select * from Table B, Table A where Table B.ID = Table A.ID), but it still only selects records from Table B, not table A. How can I get it to select the records in Table A, not the records in Table B? Thanks, -Bob ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
[MI-L] landuse classification
List, Can anyone provide a way of telling me what particular landuse code (ie-commercial, residential, etc) a particular address is in? I have a list of over 1,000 addresses across the US that I would like to do this for. If anyone has done this or knows of anyone who could do this, please let me know. Thanks, -Bob ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
[MI-L] printer
List, I just changed to a new printer (from HP 2500 to HP 2800). If I go and change a saved workspace in page setup to the new printer and do a search and replace on all the other windows-in this case replace HP 2500 with HP 2800 in notepad- the workspace takes about twice as long to open. Why are the workspaces all so slow to open? That is the only change I have made. Do I have to delete the old 2500 printer from my system, and if so is would this cause any problems with any saved workspaces? I'm running MI Pro 7.8 on Win XP. Thanks, Bob ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
[MI-L] saving workspace in mapbasic
Hi list, I have a mapbasic program I wrote with 3 seperate push buttons. The first opens a dialog box to open a workspace. The second closes a list of the old streetpro bottom portion of the hwy shields for every state that is no longer used, but referenced in the saved workspace. The third button saves the workspace. My problem is in getting mapbasic to resave the current workspace. I'm using the following command- Run menu command 109. This has the correct workspace name that was opened up, but prompts the user to select save workspace and the directory where it is prompting to be saved in is not the correct directory where that workspace was opened. Is there a way to simply have the workspace saved to the same directory it was opened up in so that it overwrites the old workspace and no longer references the old streetpro tables? I cannot define a certain directory for the workspaces to be saved because they are all in many different directories. I'm using v7.8 on winXP. Any help is appreciated. Thansk, Bob ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
Re: [MI-L] Labelling....
Mike,
Label as expression, then use the following-
Str$("Column Name in your table")
This labels the numeric column as a string, removing any commas.
-Bob
"Mike Mayer" <[EMAIL PROTECTED]> on Friday, January 13, 2006
at 11:23 AM -0700 wrote:
>Hello List,
>
>Yet another labelling question. This may be an easy one..anyways we have
>to
>label a bunch of points and we need to get rid of the comma in the number,
>any suggestions on how this can be done. I've tried using an expression,
>but can't seem to figure out a logical one, or one that works. Any
>suggestions are greatly appreciated. Thanks in advance.
>
>
>
>Mike Mayer
>
>GIS Technician
>
>Strongbow Exploration Inc.
>
>Suite 800 - 625 Howe St. Vancouver, BC V6C 2T6
>
>(604)668-8370
>
> www.strongbowexploration.com
>
>
>
>___
>MapInfo-L mailing list
>MapInfo-L@lists.directionsmag.com
>http://www.directionsmag.com/mailman/listinfo/mapinfo-l
___
MapInfo-L mailing list
MapInfo-L@lists.directionsmag.com
http://www.directionsmag.com/mailman/listinfo/mapinfo-l
Re: [MI-L] voronoi polgon
I finally found the reason for the incorrectly shaped voronoi polygons. It seems the Projection your points are in effects the shape of the voronoi polygons created. The points table I used to create the voronoi polygons from was in a Longitude/Latitude Projection, which created the inaccuracies. When I saved the table and changed the projection to Regional Equal-Area Projectons (North America), the new voronoi polygons from these points was correct. Thanks to all for the help. -Bob "Karl Kliparchuk" <[EMAIL PROTECTED]> on Thursday, January 12, 2006 at 10:43 AM -0700 wrote: >I think the problem may occur at the edges, as the voroni polys are drawn >based on points. You may want to consider placing dummy points around >the edges of your data distribution in order to constrain the polygons. > >Karl > >GIS Business Manager >McElhanney Consulting Services Ltd. >100 - 780 Beatty Street >Vancouver, BC Canada >V6B 2M1 >Tel (604) 683-8521 >Email: [ mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] >web: [ http://www.mcelhanney.com/mcsl ]www.mcelhanney.com/mcsl >web: [ http://www.MapsByAir.com ]www.MapsByAir.com > >>>> Robert DeRubeis <[EMAIL PROTECTED]> 01/12/06 9:32 AM >>> > >I got the same results with only 26 points as with all 15,000 so I guess >the number of points doesn't seem to matter. Something seems to be off a >little in MI Pro as to how it creates the voronoi polygons. > >-Bob > >Peter Horsbøll Møller <[EMAIL PROTECTED]> on Thursday, January 12, 2006 at 9:17 >AM -0700 wrote: >>Have you tried to create voronoi on just those two stores and approx. 30 >>stores around these ? >>This should give them same result as when you create for all your 58000 >>stores >> >> >>Peter Horsbøll Møller >>GIS Developer, MTM >>Geographical Information & IT >> >>COWI A/S >>Odensevej 95 >>DK-5260 Odense S. >>Denmark >> >>Tel +45 6311 4900 >>Direct +45 6311 4908 >>Mob +45 5156 1045 >>Fax +45 6311 4949 >>E-mail [ [ mailto:[EMAIL PROTECTED] ]mailto:[EMAIL PROTECTED] [EMAIL >>PROTECTED] >>[ [ http://www.cowi.dk/gis ]http://www.cowi.dk/gis ][ >http://www.cowi.dk/gis ]http://www.cowi.dk/gis >> >> >> >> >> >>---From: >>Robert DeRubeis [[ mailto:[EMAIL PROTECTED] >]mailto:[EMAIL PROTECTED] >>Sent: Thursday, January 12, 2006 4:41 PM >>To: mapinfo-l@lists.directionsmag.com >>Cc: Peter Horsbøll Møller >>Subject: Re: [MI-L] voronoi polgon >> >> >>I have used the Distance Calculator in MI Pro v7.8 and that gave the >>correct closest store location. But I'm wanting to assign some 58,000 >>customers to the closest store. The number of customers will vary >>depending on how many customers fall within that particular voronoi >>polygon, which is anywhere from zero and up. >> >>The whole problem seems to be the voronoi for each store is not >>representing an area closest to that store for some reason. I'm creating >>voronoi polygons from over 15,000 points. Could that be the cause of the >>problem? Has anyone else had any similar problems? >> >>Thanks, >>Bob >> >>Peter Horsbøll Møller <[ [ mailto:[EMAIL PROTECTED] ]mailto:[EMAIL PROTECTED] >[EMAIL PROTECTED]> on Wednesday, >>January 11, 2006 at 2:22 PM -0700 wrote: >>Bob, >> >>That sounds kind of strange. The voronoi for each store should represent >>the area closer to each store than to any other store - just as you >>expect. >>And therefore each customer should be within that voronoi that also >>contains the store they are closest to. >> >>Have you tried using the DistanceCalculator, that came with MapInfo 7.8 - >>or even the improved one for MapInfo 8.0 ? This tool will give you the >>nearest x stores for each customer. x can be 1, 2 or as many as like. So >>this would be another way of getting the result, you are looking for. >> >>The tool from MapInfo 8.0 the result will be represented as a line >>between the customer and the store. I'm not sure if this also is the case >>with the 7.8 tool >> >>Peter Horsbøll Møller >>GIS Developer, MTM >>Geographical Information & IT >> >>COWI A/S >>Odensevej 95 >>DK-5260 Odense S. >>Denmark >> >>Tel +45 6311 4900 >>Direct +45 6311 4908 >>Mob +45 5156 1045 >>Fax +45 6311 4949 >>
Re: [MI-L] voronoi polgon
I finally found the reason for the incorrectly shaped voronoi polygons. It seems the Projection your points are in effects the shape of the voronoi polygons created. The points table I used to create the voronoi polygons from was in a Longitude/Latitude Projection, which created the inaccuracies. When I saved the table and changed the projection to Regional Equal-Area Projectons (North America), the new voronoi polygons from these points was correct. Thanks to all for the help. -Bob "Karl Kliparchuk" <[EMAIL PROTECTED]> on Thursday, January 12, 2006 at 10:43 AM -0700 wrote: >I think the problem may occur at the edges, as the voroni polys are drawn >based on points. You may want to consider placing dummy points around >the edges of your data distribution in order to constrain the polygons. > >Karl > >GIS Business Manager >McElhanney Consulting Services Ltd. >100 - 780 Beatty Street >Vancouver, BC Canada >V6B 2M1 >Tel (604) 683-8521 >Email: [ mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] >web: [ http://www.mcelhanney.com/mcsl ]www.mcelhanney.com/mcsl >web: [ http://www.MapsByAir.com ]www.MapsByAir.com > >>>> Robert DeRubeis <[EMAIL PROTECTED]> 01/12/06 9:32 AM >>> > >I got the same results with only 26 points as with all 15,000 so I guess >the number of points doesn't seem to matter. Something seems to be off a >little in MI Pro as to how it creates the voronoi polygons. > >-Bob > >Peter Horsbøll Møller <[EMAIL PROTECTED]> on Thursday, January 12, 2006 at 9:17 >AM -0700 wrote: >>Have you tried to create voronoi on just those two stores and approx. 30 >>stores around these ? >>This should give them same result as when you create for all your 58000 >>stores >> >> >>Peter Horsbøll Møller >>GIS Developer, MTM >>Geographical Information & IT >> >>COWI A/S >>Odensevej 95 >>DK-5260 Odense S. >>Denmark >> >>Tel +45 6311 4900 >>Direct +45 6311 4908 >>Mob +45 5156 1045 >>Fax +45 6311 4949 >>E-mail [ [ mailto:[EMAIL PROTECTED] ]mailto:[EMAIL PROTECTED] [EMAIL >>PROTECTED] >>[ [ http://www.cowi.dk/gis ]http://www.cowi.dk/gis ][ >http://www.cowi.dk/gis ]http://www.cowi.dk/gis >> >> >> >> >> >>---From: >>Robert DeRubeis [[ mailto:[EMAIL PROTECTED] >]mailto:[EMAIL PROTECTED] >>Sent: Thursday, January 12, 2006 4:41 PM >>To: mapinfo-l@lists.directionsmag.com >>Cc: Peter Horsbøll Møller >>Subject: Re: [MI-L] voronoi polgon >> >> >>I have used the Distance Calculator in MI Pro v7.8 and that gave the >>correct closest store location. But I'm wanting to assign some 58,000 >>customers to the closest store. The number of customers will vary >>depending on how many customers fall within that particular voronoi >>polygon, which is anywhere from zero and up. >> >>The whole problem seems to be the voronoi for each store is not >>representing an area closest to that store for some reason. I'm creating >>voronoi polygons from over 15,000 points. Could that be the cause of the >>problem? Has anyone else had any similar problems? >> >>Thanks, >>Bob >> >>Peter Horsbøll Møller <[ [ mailto:[EMAIL PROTECTED] ]mailto:[EMAIL PROTECTED] >[EMAIL PROTECTED]> on Wednesday, >>January 11, 2006 at 2:22 PM -0700 wrote: >>Bob, >> >>That sounds kind of strange. The voronoi for each store should represent >>the area closer to each store than to any other store - just as you >>expect. >>And therefore each customer should be within that voronoi that also >>contains the store they are closest to. >> >>Have you tried using the DistanceCalculator, that came with MapInfo 7.8 - >>or even the improved one for MapInfo 8.0 ? This tool will give you the >>nearest x stores for each customer. x can be 1, 2 or as many as like. So >>this would be another way of getting the result, you are looking for. >> >>The tool from MapInfo 8.0 the result will be represented as a line >>between the customer and the store. I'm not sure if this also is the case >>with the 7.8 tool >> >>Peter Horsbøll Møller >>GIS Developer, MTM >>Geographical Information & IT >> >>COWI A/S >>Odensevej 95 >>DK-5260 Odense S. >>Denmark >> >>Tel +45 6311 4900 >>Direct +45 6311 4908 >>Mob +45 5156 1045 >>Fax +45 6311 4949 >>
Re: [MI-L] voronoi polgon
I got the same results with only 26 points as with all 15,000 so I guess the number of points doesn't seem to matter. Something seems to be off a little in MI Pro as to how it creates the voronoi polygons. -Bob Peter Horsbøll Møller <[EMAIL PROTECTED]> on Thursday, January 12, 2006 at 9:17 AM -0700 wrote: >Have you tried to create voronoi on just those two stores and approx. 30 >stores around these ? >This should give them same result as when you create for all your 58000 >stores > > >Peter Horsbøll Møller >GIS Developer, MTM >Geographical Information & IT > >COWI A/S >Odensevej 95 >DK-5260 Odense S. >Denmark > >Tel +45 6311 4900 >Direct +45 6311 4908 >Mob +45 5156 1045 >Fax +45 6311 4949 >E-mail [ mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] >[ http://www.cowi.dk/gis ]http://www.cowi.dk/gis > > > > > >---From: >Robert DeRubeis [mailto:[EMAIL PROTECTED] >Sent: Thursday, January 12, 2006 4:41 PM >To: mapinfo-l@lists.directionsmag.com >Cc: Peter Horsbøll Møller >Subject: Re: [MI-L] voronoi polgon > > >I have used the Distance Calculator in MI Pro v7.8 and that gave the >correct closest store location. But I'm wanting to assign some 58,000 >customers to the closest store. The number of customers will vary >depending on how many customers fall within that particular voronoi >polygon, which is anywhere from zero and up. > >The whole problem seems to be the voronoi for each store is not >representing an area closest to that store for some reason. I'm creating >voronoi polygons from over 15,000 points. Could that be the cause of the >problem? Has anyone else had any similar problems? > >Thanks, >Bob > >Peter Horsbøll Møller <[ mailto:[EMAIL PROTECTED] [EMAIL PROTECTED]> on >Wednesday, >January 11, 2006 at 2:22 PM -0700 wrote: >Bob, > >That sounds kind of strange. The voronoi for each store should represent >the area closer to each store than to any other store - just as you >expect. >And therefore each customer should be within that voronoi that also >contains the store they are closest to. > >Have you tried using the DistanceCalculator, that came with MapInfo 7.8 - >or even the improved one for MapInfo 8.0 ? This tool will give you the >nearest x stores for each customer. x can be 1, 2 or as many as like. So >this would be another way of getting the result, you are looking for. > >The tool from MapInfo 8.0 the result will be represented as a line >between the customer and the store. I'm not sure if this also is the case >with the 7.8 tool > >Peter Horsbøll Møller >GIS Developer, MTM >Geographical Information & IT > >COWI A/S >Odensevej 95 >DK-5260 Odense S. >Denmark > >Tel +45 6311 4900 >Direct +45 6311 4908 >Mob +45 5156 1045 >Fax +45 6311 4949 >E-mail [ mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] >[ http://www.cowi.dk/gis ]http://www.cowi.dk/gis > >-Original Message- >From: [ mailto:[EMAIL PROTECTED] >[EMAIL PROTECTED] [[ >mailto:[EMAIL PROTECTED] >]mailto:[EMAIL PROTECTED] On Behalf Of Robert >DeRubeis >Sent: Wednesday, January 11, 2006 5:58 PM >To: [ mailto:mapinfo-l@lists.directionsmag.com >[EMAIL PROTECTED] >Subject: [MI-L] voronoi polgon > >List, > >I have 2 point tables, stores and customers. I would like to find all >the customers that are the closest distance to a particular store so I >can assign information from the store to those customers. I created a >voronoi polygon from the store points, then did a select statement where >customer points are within store voronoi polygon. > >My problem is that I noticed in certain cases that some customer points >fell into a store voronoi polygon, but was actually closer to another >store. I measured the distance in MI Pro Ver 7.8 and it was not a big >difference (8.19 instead of 7.78 miles), but wondered why the inaccuracy? > >Thanks, >Bob ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
Re: [MI-L] voronoi polgon
I have used the Distance Calculator in MI Pro v7.8 and that gave the correct closest store location. But I'm wanting to assign some 58,000 customers to the closest store. The number of customers will vary depending on how many customers fall within that particular voronoi polygon, which is anywhere from zero and up. The whole problem seems to be the voronoi for each store is not representing an area closest to that store for some reason. I'm creating voronoi polygons from over 15,000 points. Could that be the cause of the problem? Has anyone else had any similar problems? Thanks, Bob Peter Horsbøll Møller <[EMAIL PROTECTED]> on Wednesday, January 11, 2006 at 2:22 PM -0700 wrote: >Bob, > >That sounds kind of strange. The voronoi for each store should represent >the area closer to each store than to any other store - just as you >expect. >And therefore each customer should be within that voronoi that also >contains the store they are closest to. > >Have you tried using the DistanceCalculator, that came with MapInfo 7.8 - >or even the improved one for MapInfo 8.0 ? This tool will give you the >nearest x stores for each customer. x can be 1, 2 or as many as like. So >this would be another way of getting the result, you are looking for. > >The tool from MapInfo 8.0 the result will be represented as a line >between the customer and the store. I'm not sure if this also is the case >with the 7.8 tool > >Peter Horsbøll Møller >GIS Developer, MTM >Geographical Information & IT > >COWI A/S >Odensevej 95 >DK-5260 Odense S. >Denmark > >Tel+45 6311 4900 >Direct +45 6311 4908 >Mob+45 5156 1045 >Fax+45 6311 4949 >E-mail [EMAIL PROTECTED] >http://www.cowi.dk/gis > >-Original Message- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of Robert >DeRubeis >Sent: Wednesday, January 11, 2006 5:58 PM >To: mapinfo-l@lists.directionsmag.com >Subject: [MI-L] voronoi polgon > >List, > >I have 2 point tables, stores and customers. I would like to find all >the customers that are the closest distance to a particular store so I >can assign information from the store to those customers. I created a >voronoi polygon from the store points, then did a select statement where >customer points are within store voronoi polygon. > >My problem is that I noticed in certain cases that some customer points >fell into a store voronoi polygon, but was actually closer to another >store. I measured the distance in MI Pro Ver 7.8 and it was not a big >difference (8.19 instead of 7.78 miles), but wondered why the inaccuracy? > >Thanks, >Bob > > >___ >MapInfo-L mailing list >MapInfo-L@lists.directionsmag.com >http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
[MI-L] voronoi polgon
List, I have 2 point tables, stores and customers. I would like to find all the customers that are the closest distance to a particular store so I can assign information from the store to those customers. I created a voronoi polygon from the store points, then did a select statement where customer points are within store voronoi polygon. My problem is that I noticed in certain cases that some customer points fell into a store voronoi polygon, but was actually closer to another store. I measured the distance in MI Pro Ver 7.8 and it was not a big difference (8.19 instead of 7.78 miles), but wondered why the inaccuracy? Thanks, Bob ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
[MI-L] printer
List, I just changed to a new printer (from HP 2500 to HP 2800). If I go and change a saved workspace in page setup to the new printer and do a search and replace on all the other windows-in this case replace HP 2500 with HP 2800 in notepad- the workspace takes about twice as long to open. Why are the workspaces all so slow to open? That is the only change I have made. Do I have to delete the old 2500 printer from my system, and if so is would this cause any problems with any saved workspaces? I'm running MI Pro 7.8 on Win XP. Thanks, Bob ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
Re: [MI-L] new printer
That is the case, there are 6 map windows and 1 layout window. If I do a replace all "old printer name" with "new printer name" for every workspace, I remove all the old printer references. However, it does not take into account the margin settings for the different printers, so I would still have to go into page setup to adjust, then move or resize the layout to make sure it is in the printable area. I've done this for one workspace so it references the new printer then saved it, but now when it is opened it is much slower compared to when it was referencing the old printer. I still have both printers added under windows printers and they are both assigned with the same port IP address on the network. Thanks, -Bob "Ben A Greenberg" <[EMAIL PROTECTED]> on Wednesday, December 28, 2005 at 11:48 AM -0700 wrote: >Since a window can contain maps, browsers and legends as well as layouts, >the workspace is probably referencing every open window, not just the >layout. > >-Original Message- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] Behalf Of Robert >DeRubeis >Sent: Wednesday, December 28, 2005 11:55 AM >To: mapinfo-l@lists.directionsmag.com >Subject: [MI-L] new printer > > >List, > >We just got a new printer (HP 2800) to replace an old one that died (HP >2500). When I opened one workspace in notepad, I noticed it referenced >the printer 7 times(see below), even though there is only one layout in >the workspace. Is this a bug in MI Pro, that it keeps appending the >following. > >- >Set Window FrontWindow() Printer > Name "HP 2500CM Printer" Orientation Portrait Copies 1 > Papersize 1 >- >Is there a way to update the hundreds of workspaces I currently have saved >to reflect the new printer? Some workspaces contain multiple layouts with >different size papers and orientations like 8x11 landscape, 8x11 portrait, >11x17 landscape or 11x17 portrait. > >I am using MI Pro 7.8 on XP Professional. > >Thanks, >Bob > >___ >MapInfo-L mailing list >MapInfo-L@lists.directionsmag.com >http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
[MI-L] new printer
List, We just got a new printer (HP 2800) to replace an old one that died (HP 2500). When I opened one workspace in notepad, I noticed it referenced the printer 7 times(see below), even though there is only one layout in the workspace. Is this a bug in MI Pro, that it keeps appending the following. - Set Window FrontWindow() Printer Name "HP 2500CM Printer" Orientation Portrait Copies 1 Papersize 1 - Is there a way to update the hundreds of workspaces I currently have saved to reflect the new printer? Some workspaces contain multiple layouts with different size papers and orientations like 8x11 landscape, 8x11 portrait, 11x17 landscape or 11x17 portrait. I am using MI Pro 7.8 on XP Professional. Thanks, Bob ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
MI-L hurricane katrina data
List- Does anyone know if there is any place to get flooding data for katrina to be used in MapInfo Pro? I'm trying to do some analysis by identifying the areas that have been effected. Thanks, -Bob
MI-L add columns to multiple tables
I'm trying to write an mbx that will take multiple point tables, with different names and from different sub-directories (C:\AKdata, C:\ALdata, C:\ARdata, etc), add the first 2 letters of the table name to a new column called "state", then add "lat", "lon" columns and update those columns accordingly. If any table already contains columns named "state", "lat", or "lon", I still need it to be updated as stated above. Thanks for the help. -Bob
MI-L custom labels
Anyone wanting the program, you can contact me at [EMAIL PROTECTED] Thanks, Bob DeRubeis GIS Analyst 1-602-263-6811 x5454 [EMAIL PROTECTED] "Holler, Bill" <[EMAIL PROTECTED]> writes: > >Greetings, > >I think that the described program would be useful; especially for >workspaces that were used as masters for other workspaces. I for one >would find this useful. > >Bill Holler MS GISP >GIS Administrator >Information Specialist >Data Services Division >Town of Wethersfield, CT >(860) 271-2854 >[EMAIL PROTECTED] > > > >-Original Message- >From: Robert DeRubeis [mailto:[EMAIL PROTECTED] >Sent: Wednesday, July 13, 2005 3:17 PM >To: mapinfo-l@lists.directionsmag.com >Subject: MI-L custom labels > > >List, > >I'm trying to find out how many MIPro users would be interested in a >program we created. MIPro users already know the problems associated >with having custom labels inside saved workspaces. When a table is >updated or overwritten (rearranging the rowid), the label no longer >corresponds to the new table. > >This program is a windows application that searches for all .wor files >by directory, and clears all custom labels. This is the same as doing a >"clear custom labels..." from a map window, but this will do every map >window within the workspace and within the directory specified. This >can be performed on a single table, multiple tables or all tables >through the windows text dialog box. It can also be run in test mode, >which returns the workspace name and complete directory locations, >before any action is taken. > >Please let me know if you are interested or see a use for the program. >I ran into this problem when getting StreetPro updates that are >referenced in many, many workspaces with custom labels. I couldn't use >the data without first getting rid of the custom labels. Now if only MI >had a better way to display labels, but that's another subject > >Thanks, >-Bob
MI-L custom labels
List, I'm trying to find out how many MIPro users would be interested in a program we created. MIPro users already know the problems associated with having custom labels inside saved workspaces. When a table is updated or overwritten (rearranging the rowid), the label no longer corresponds to the new table. This program is a windows application that searches for all .wor files by directory, and clears all custom labels. This is the same as doing a "clear custom labels..." from a map window, but this will do every map window within the workspace and within the directory specified. This can be performed on a single table, multiple tables or all tables through the windows text dialog box. It can also be run in test mode, which returns the workspace name and complete directory locations, before any action is taken. Please let me know if you are interested or see a use for the program. I ran into this problem when getting StreetPro updates that are referenced in many, many workspaces with custom labels. I couldn't use the data without first getting rid of the custom labels. Now if only MI had a better way to display labels, but that's another subject Thanks, -Bob
MI-L demox error message
List, Does anyone know what a .demox file is? I have one associated with one of my MapInfo Tables that I can't figure out how or why it got there. If I delete it, when I start up MI Pro 7.8, I get the following error message- "ParseError: An exception occurred! Type:RuntimeException, Message:The primary document entity could not be opened. Id=C:\Data\"filename.demox" at line 0 and column 0 while processing "C:\Data\"filename.demox" Thanks, Bob
MI-L email in mapbasic
List, I'm trying to send an email with a .txt attachment throught mapbasic. Does anyone know if this is possible or not? I'm using mapbasic v7.8 and the email software being used is called FirstClass. Any help is appreciated. Thanks, Bob - List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 15430
Re: MI-L points with same lat/lon
Thanks Peter. That is more along the lines of what I was expecting. It works great. Very cool. -Bob Peter Horsbøll Møller <[EMAIL PROTECTED]> writes: >Hi Robert, > >I'm not sure whether you saw this solution I sent before. I just checked >and found some errors in it, but it works, without saving any queries ! > >Grouping all reocrds by LAT and long, and counting the number of records >at the same location: >Select LAT, LONG, LAT + "#" + LONG "LAT_LONG", Count(*) "NUMPOINTS" > From > Group By LAT, LONG > Order By NUMPOINTS Desc > > is the name of the table with the recoords > >To select the points where more than 1 point is found in the same >location, enter the following in SQL Select > >Select * > From > Where (LAT + "#" + LONG) In (Select LAT_LONG From Selection Where >NUMPOINTS > 1) > >Now you should have a selection of all points that were located were at >least one other point also was located > >Peter Horsbøll Møller >GIS Developer >Geographical Information & IT > >COWI A/S >Odensevej 95 >DK-5260 Odense S. >Denmark > >Tel+45 6311 4900 >Direct +45 6311 4908 >Mob+45 5156 1045 >Fax+45 6311 4949 >E-mail [EMAIL PROTECTED] >http://www.cowi.dk > > >-Original Message- >From: Robert DeRubeis [mailto:[EMAIL PROTECTED] >Sent: Monday, May 17, 2004 6:47 PM >To: [EMAIL PROTECTED] >Subject: Re: MI-L points with same lat/lon > > >Saving the count query and the last step was what I was missing and it >worked fine. I thought it wouldn't take so many steps and having to save >query results, etc., but better more steps with it being able to be done, >than it can't do it. Thanks to all -Bob > > >"Spencer Simpson" <[EMAIL PROTECTED]> writes: >>Assuming you've done the following (which it sounds like you've done): >> >>1. Update the lon and lat columns with centroidX and centroidY 2. Make >>the group-by query (group by lat and lon. 3. Make the query where >>count>1 >> >>You should then: >> >>3. Save the result of query 2 to its own table (we'll call it >>DUPLOCS.TAB). 4. Close the query tables generated in steps 1 and 2, >>then open the table you saved in step 3 (DUPLOCS). >>5. If the original table has 1 records or more, index its lat column, >>and the lat column of DUPLOCS. >>6. Perform a SQL Select: >> >>select * from ORIGTAB, DUPLOCS where (origtab.lon=duplocs.lon) and >>(origtab.lat=duplocs.lat) >> >> >>Viola'! >> >>Hope this helps >>Spencer >> >> >>-Original Message- >>From: Robert DeRubeis [mailto:[EMAIL PROTECTED] >>Sent: Monday, May 17, 2004 12:02 PM >>To: [EMAIL PROTECTED] >>Cc: Kir Luong; Peter Horsb¿ll M¿ller >>Subject: Re: MI-L points with same lat/lon >> >>I've done this, and found that I have 100's of duplications of 2 or more, >>but I need all of the records that are duplicates.When a count query >>is done it does not select all records with matching lat/lon's. It >>returns, for example, >>Count Lat Lon >>6 49.715709 -123.156264 >>5 49.709248 -124.916418 >>4 43.745795 -79.526276 >>etc, etc.. >> >>There are 15 records above with the same lat/lon. I need to be able to >>select all 15 records? -Bob >> >>"Kir Luong" <[EMAIL PROTECTED]> writes: >>>If the lat or long is the same then a count and group by function on >>>those variables should give you the records that are identical (group >>>by >>>clause) and how many duplication (count function): >>>I'm not sure the mapinfo SqL...but something like: >>> >>>Select count(*),lat >>>from table1 >>>group by lat >>>having count(*) > 1; >>>execute; ===> returns a table of all lats that are duplicated and the >>>number of duplication >>> >>>likewise for the longs. Hope this helps. >>> >>>kir. >>> >>>-Original Message- >>>From: Robert DeRubeis [mailto:[EMAIL PROTECTED] >>>Sent: Friday, May 14, 2004 3:03 PM >>>To: [EMAIL PROTECTED] >>>Subject: MI-L points with same lat/lon >>> >>> >>>List- >>>Is there a way to select all records from one table where the values >>>in 2 different columns are identical? I wanted to select all records >>>where
Re: MI-L points with same lat/lon
Saving the count query and the last step was what I was missing and it worked fine. I thought it wouldn't take so many steps and having to save query results, etc., but better more steps with it being able to be done, than it can't do it. Thanks to all -Bob "Spencer Simpson" <[EMAIL PROTECTED]> writes: >Assuming you've done the following (which it sounds like you've done): > >1. Update the lon and lat columns with centroidX and centroidY >2. Make the group-by query (group by lat and lon. >3. Make the query where count>1 > >You should then: > >3. Save the result of query 2 to its own table (we'll call it >DUPLOCS.TAB). >4. Close the query tables generated in steps 1 and 2, then open the table >you saved in step 3 (DUPLOCS). >5. If the original table has 1 records or more, index its lat column, >and the lat column of DUPLOCS. >6. Perform a SQL Select: > >select * from ORIGTAB, DUPLOCS where (origtab.lon=duplocs.lon) and >(origtab.lat=duplocs.lat) > > >Viola'! > >Hope this helps >Spencer > > >-Original Message- >From: Robert DeRubeis [mailto:[EMAIL PROTECTED] >Sent: Monday, May 17, 2004 12:02 PM >To: [EMAIL PROTECTED] >Cc: Kir Luong; Peter Horsb¿ll M¿ller >Subject: Re: MI-L points with same lat/lon > >I've done this, and found that I have 100's of duplications of 2 or more, >but I need all of the records that are duplicates.When a count query >is done it does not select all records with matching lat/lon's. It >returns, for example, >Count Lat Lon >6 49.715709 -123.156264 >5 49.709248 -124.916418 >4 43.745795 -79.526276 >etc, etc.. > >There are 15 records above with the same lat/lon. I need to be able to >select all 15 records? >-Bob > >"Kir Luong" <[EMAIL PROTECTED]> writes: >>If the lat or long is the same then a count and group by function on >>those variables should give you the records that are identical (group by >>clause) and how many duplication (count function): >>I'm not sure the mapinfo SqL...but something like: >> >>Select count(*),lat >>from table1 >>group by lat >>having count(*) > 1; >>execute; ===> returns a table of all lats that are duplicated and the >>number of duplication >> >>likewise for the longs. Hope this helps. >> >>kir. >> >>-Original Message- >>From: Robert DeRubeis [mailto:[EMAIL PROTECTED] >>Sent: Friday, May 14, 2004 3:03 PM >>To: [EMAIL PROTECTED] >>Subject: MI-L points with same lat/lon >> >> >>List- >>Is there a way to select all records from one table where the values in 2 >>different columns are identical? I wanted to select all records where the >>lat of 1st record = lat of 2nd record AND lon of 1st record = lon of 2nd >>record. I'm trying to identify where and how many points are right on >top >>of each other and if they need to be dispersed or better geocoding. >> >>The table has about 30,000 points and I'm using MIPro 6.5. >>Thanks, >>-Bob >> >> >>- >>List hosting provided by Directions Magazine | www.directionsmag.com | >>To unsubscribe, e-mail: [EMAIL PROTECTED] >>For additional commands, e-mail: [EMAIL PROTECTED] >>Message number: 11767 >> >> >>This communication is intended for the use of the recipient to which it >>is addressed, and may contain confidential, personal and or privileged >>information. Please contact us immediately if you are not the intended >>recipient of this communication, and do not copy, distribute, or take >>action relying on it. Any communication received in error, or subsequent >>reply, should be deleted or destroyed > > >- >List hosting provided by Directions Magazine | www.directionsmag.com | >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >Message number: 11790 - List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11794
Re: MI-L points with same lat/lon
I've done this, and found that I have 100's of duplications of 2 or more, but I need all of the records that are duplicates.When a count query is done it does not select all records with matching lat/lon's. It returns, for example, Count Lat Lon 6 49.715709 -123.156264 5 49.709248 -124.916418 4 43.745795 -79.526276 etc, etc.. There are 15 records above with the same lat/lon. I need to be able to select all 15 records? -Bob "Kir Luong" <[EMAIL PROTECTED]> writes: >If the lat or long is the same then a count and group by function on >those variables should give you the records that are identical (group by >clause) and how many duplication (count function): >I'm not sure the mapinfo SqL...but something like: > >Select count(*),lat >from table1 >group by lat >having count(*) > 1; >execute; ===> returns a table of all lats that are duplicated and the >number of duplication > >likewise for the longs. Hope this helps. > >kir. > >-Original Message- >From: Robert DeRubeis [mailto:[EMAIL PROTECTED] >Sent: Friday, May 14, 2004 3:03 PM >To: [EMAIL PROTECTED] >Subject: MI-L points with same lat/lon > > >List- >Is there a way to select all records from one table where the values in 2 >different columns are identical? I wanted to select all records where the >lat of 1st record = lat of 2nd record AND lon of 1st record = lon of 2nd >record. I'm trying to identify where and how many points are right on top >of each other and if they need to be dispersed or better geocoding. > >The table has about 30,000 points and I'm using MIPro 6.5. >Thanks, >-Bob > > >- >List hosting provided by Directions Magazine | www.directionsmag.com | >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >Message number: 11767 > > >This communication is intended for the use of the recipient to which it >is addressed, and may contain confidential, personal and or privileged >information. Please contact us immediately if you are not the intended >recipient of this communication, and do not copy, distribute, or take >action relying on it. Any communication received in error, or subsequent >reply, should be deleted or destroyed - List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11790
MI-L points with same lat/lon
List- Is there a way to select all records from one table where the values in 2 different columns are identical? I wanted to select all records where the lat of 1st record = lat of 2nd record AND lon of 1st record = lon of 2nd record. I'm trying to identify where and how many points are right on top of each other and if they need to be dispersed or better geocoding. The table has about 30,000 points and I'm using MIPro 6.5. Thanks, -Bob - List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11767
Re: MI-L Printing large size prints
I did not get any "out of memory" errors. It doesn't seem to be a printer driver issue either since it prints fine on everything except really long sheets and I tried printing the same long sheet to a different plotter using a different driver and it did the same thing. I believe it is a memory issue since I was able to print four 36"x54" sheets correctly. I guess the 512 RAM I have is only good enough to do around 36"x60" plots, maybe, but you don't know what that limit is until it doesn't work. Thanks for everyone's help and suggestions. -Bob "Spencer Simpson" <[EMAIL PROTECTED]> writes: >The most likely reason is that your plotter does not have enough memory to >hold the entire printout at once. > >1. Make sure that your plotter is not displaying an "out of memory" >error. >2. Try rasterizing the printout on your commputer rather than >in the plotter. >3. Try printing one "really long page" at a time. >4. Try printing to four 36" x 54" sheets (one page at a time) >just to see if everything comes out. > >Hope this helps. >Spencer > >-Original Message- >From: Robert DeRubeis [mailto:[EMAIL PROTECTED] >Sent: Monday, March 08, 2004 1:18 PM >To: MapInfo Listers >Subject: MI-L Printing large size prints > > >List- >I created a large layout window in MapInfo Pro and I'm having problems >getting it to print correctly. The size I'm looking to print out is 6'x9' >or 72"x108". My plotter is limited to 36" so I set up the layout to print >the job on 2 pages both 36"x108". It did this with no problem and is >exactly what I'm looking for with 2 long sheets 9' long. The problem I >have >is when it prints, part of the end of the map is being cut off, but it >still >looks fine in the layout window. The layout window shows from California >to >Nova Scotia, but when printed out it cuts off everything east of New >Hampshire. > >Any help is appreciated as I am stumped with why it prints differently >than >what the layout when shows. I am using MIPro 6.5 on XP printing to an >HP650 >plotter. Thanks, Bob > > >- >List hosting provided by Directions Magazine | www.directionsmag.com | To >unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >Message number: 10734 > > > >- >List hosting provided by Directions Magazine | www.directionsmag.com | >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >Message number: 10736 > > Bob DeRubeis GIS/Mapping 1-602-263-6811 X5454 - List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 10739
MI-L Printing large size prints
List- I created a large layout window in MapInfo Pro and I'm having problems getting it to print correctly. The size I'm looking to print out is 6'x9' or 72"x108". My plotter is limited to 36" so I set up the layout to print the job on 2 pages both 36"x108". It did this with no problem and is exactly what I'm looking for with 2 long sheets 9' long. The problem I have is when it prints, part of the end of the map is being cut off, but it still looks fine in the layout window. The layout window shows from California to Nova Scotia, but when printed out it cuts off everything east of New Hampshire. Any help is appreciated as I am stumped with why it prints differently than what the layout when shows. I am using MIPro 6.5 on XP printing to an HP650 plotter. Thanks, Bob - List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 10735
MI-L Printing large size prints
List- I created a large layout window in MapInfo Pro and I'm having problems getting it to print correctly. The size I'm looking to print out is 6'x9' or 72"x108". My plotter is limited to 36" so I set up the layout to print the job on 2 pages both 36"x108". It did this with no problem and is exactly what I'm looking for with 2 long sheets 9' long. The problem I have is when it prints, part of the end of the map is being cut off, but it still looks fine in the layout window. The layout window shows from California to Nova Scotia, but when printed out it cuts off everything east of New Hampshire. Any help is appreciated as I am stumped with why it prints differently than what the layout when shows. I am using MIPro 6.5 on XP printing to an HP650 plotter. Thanks, Bob - List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 10734
MI-L Printing large size prints
List- I created a large layout window in MapInfo Pro and I'm having problems getting it to print correctly. The size I'm looking to print out is 6'x9' or 72"x108". My plotter is limited to 36" so I set up the layout to print the job on 2 pages both 36"x108". It did this with no problem and is exactly what I'm looking for with 2 long sheets 9' long. The problem I have is when it prints, part of the end of the map is being cut off, but it still looks fine in the layout window. The layout window shows from California to Nova Scotia, but when printed out it cuts off everything east of New Hampshire. Any help is appreciated as I am stumped with why it prints differently than what the layout when shows. I am using MIPro 6.5 on XP printing to an HP650 plotter. Thanks, Bob - List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 10732
Re: MI-L mapbasic code to select pts within regions
Peter, Thank you. That was exactly what I was looking for. I can now make simple changes to the code and do this for other similar tables. Thank you so much. -Bob Peter Horsbøll Møller <[EMAIL PROTECTED]> writes: >Hi Bob, > >Try this: > >Sub CreateSubSet > >DimoRegion As Object, > szPath, szState As String > > szPath = "C:\" > > Fetch First From USA > Do Until EOT(USA) > oRegion = USE.OBJ > szState = USE.STATE > > Select * From CITIES > Where OBJ Within oRegion > Into CUR__SELECTED NoSelect > > Commit Table CUR__SELECTED As szPath & "CITIES" & szState & ".TAB" > Close Table CUR__SELECTED > > Fetch Next From USA > Loop > > Note "Proces done!" > >End Sub > >Peter Horsbøll Møller >GIS Developer >Geographical Information & IT > >COWI A/S >Odensevej 95 >DK-5260 Odense S >Denmark > >Tel+45 6311 4900 >Direct +45 6311 4908 >Mob+45 5156 1045 >Fax+45 6311 4949 >E-mail [EMAIL PROTECTED] >http://www.cowi.dk > >*CHANGE OF ADDRESS - COWI's offices in Odense are now under the same >roof* >On December 8th. 2003, Geographical Information & IT moved from >Rugaardsvej 55, 5000 Odense C to Odensevej 95, 5260 Odense S. >Please note our new telephone, direct and telefax numbers. > > > >> -Original Message- >> From: Robert DeRubeis [mailto:[EMAIL PROTECTED] >> Sent: Thursday, February 19, 2004 7:39 PM >> To: MapInfo Listers >> Subject: MI-L mapbasic code to select pts within regions >> >> >> Hi all, >> >> I'm trying to create an mb to do the following- 1)select all >> points from one table that fall in a certain region in >> another table, then 2) save them to a new table with the name >> of the region it fell in. >> >> For example, if I had a point table (cities) and a region >> table (usa), select all cities that fall within each seperate >> state boundary. The end result would be 50 seperate tables >> saved as citiesAL, citiesAZ, citiesCA, etc. Each new table >> created would contain only city points that fell within that >> state boundary. >> >> I can do this in MIPro with the boundary select tool, but >> would have to manually select inside each state, then do a >> save copy as, give it a name, etc 50 times. >> >> Any help is very appreciated. >> Thanks, >> Bob >> >> >> - >> List hosting provided by Directions Magazine | >> www.directionsmag.com | To unsubscribe, e-mail: >> [EMAIL PROTECTED] >> For additional commands, e-mail: >> [EMAIL PROTECTED] >> Message number: 10531 >> >> >> > >- >List hosting provided by Directions Magazine | www.directionsmag.com | >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >Message number: 10533 - List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 10537
MI-L mapbasic code to select pts within regions
Hi all, I'm trying to create an mb to do the following- 1)select all points from one table that fall in a certain region in another table, then 2) save them to a new table with the name of the region it fell in. For example, if I had a point table (cities) and a region table (usa), select all cities that fall within each seperate state boundary. The end result would be 50 seperate tables saved as citiesAL, citiesAZ, citiesCA, etc. Each new table created would contain only city points that fell within that state boundary. I can do this in MIPro with the boundary select tool, but would have to manually select inside each state, then do a save copy as, give it a name, etc 50 times. Any help is very appreciated. Thanks, Bob - List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 10531
MI-L Update thematic map symbols
Does anyone know of a way to update a thematic map in MIPro? I have 8 points and created a thematic map so it each point would have a different symbol. Now I added two additional points to the table, that I need to show as two seperate and different symbols than the rest, but the thematic in pro does not update to show the new points. It shows them together as "all others", which I cannot seperate into different symbols for each point. If I forget about the thematic and update the table to the symbols I want, I get the correct symbols on the map, but I lose the symbol description, which is pretty long for each point symbol that I don't want to keep typing out each time there is an update (for example- red star = Dongguan Nine Dragons Paper Industries Co., Ltd. (Headquarters Office)). Currently running win2000, MIPro v6.0. Any help would be appreciated. Thanks, -Bob - List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 8870
Re: SV: MI-L Update table with sql
It does work great. Anyway to do this to all map windows at once, instead of just one at a time? Sören Lindqvist <[EMAIL PROTECTED]> writes: >Lars > >Many thanks, works like magic, no need for MapBasic. Great. > >Regards >Sören > >-Ursprungligt meddelande- >Från: Lars V. Nielsen, GisPro [mailto:[EMAIL PROTECTED] >Skickat: den 10 september 2003 17:29 >Till: Sören Lindqvist >Kopia: [EMAIL PROTECTED] >Ämne: Re: MI-L Update table with sql > >Hi Sören, > >Just put them into a text file, and add 3 line in the top with this >content (maybe even just the first) : >Line 1 : !Workspace >Line 2 : !Version 300 >Line 3 : !Charset WindowsLatin1 > >Save with a "wor" extension. >Run "Add workspace" in Pro, select your file and magic happens :-) > >Best regards/Med venlig hilsen >Lars V. Nielsen >GisPro, Denmark >http://www.gispro.dk/ >http://www.gispro.biz/ >http://hjem.get2net.dk/lars-online/ >WGS84: 10.26'40"E 55.20'20"N >- Original Message - >From: "Sören Lindqvist" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Wednesday, September 10, 2003 3:53 PM >Subject: MI-L Update table with sql > > >> Dear list >> >> I got loads of sql questions (about 60) when updating table. >> Is there a possibility to run through all this at once instead of >> hitting enter buttom for every row in MapBasic window? >> >> If yes, how is it done or written? >> >> My sql looks something like this >> >> Select * from tableA where class = "1" And area = "46" And land = "16" >> into tableAB >> Update tableAB Set town = "100" >> Update tableAB Set pop = "1000" close table tableAB >> Select * from tableA where class = "2" And area = "44" And land = "20" >> into tableAC >> Update tableAC Set town = "200" >> Update tableAC Set pop = "2000" close table tableAC >> Etc. >> Etc. >> >> Regards >> Soren >> >> >> >> >> >> - >> List hosting provided by Directions Magazine | www.directionsmag.com | >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: >[EMAIL PROTECTED] >> Message number: 8324 >> >> > > >- >List hosting provided by Directions Magazine | www.directionsmag.com | >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >Message number: 8332 - List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 8353
MI-L map window information
Hi all, I have a bunch of saved workspaces with many map windows and layouts in each saved workspace. Is there a way to get the following information from the map window- Zoom, center X, center Y. And from the layout windows- Scale on paper 1 in = ?? for each of the different windows without having to go into each one manually? Each map window and layout window has its own title so I was hoping to somehow reference the window information to the titles. I'm currently running MIPro v6.0 Thanks, Bob - List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 8341
MI-L MapInfo Performance
We are looking at getting a new computer to run MapInfo Pro and would like any feedback as to different types of specs. I'm assuming the standard with cpu and hard drive space-the most we can afford the better, but is a 2.4 ghz more worth it than say a 1.8 ghz? Does MI Pro run faster/better on a Pentium4, Celeron or AMD? And how does that compare to their price? The majority of the mapping being done is referencing StreetPro data and other internal data in .tab format from a server over the network. The biggest issue I have currently is the time involved in editing these labels with a machine 3 years old. It is a PIII, 550mhz, 64mb graphics card, 392 RAM running win2000. It is taking sometimes 20-40 seconds to move a single label so I believe a faster computer is in order. Any suggestions are appreciated. Thanks in advance, Bob - List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 8064
Re: RE: MI-L Create line between points
The connect the dot programs were exactly what I was looking for. Thanks for everyone's help. -Bob "Adam, Jason" <[EMAIL PROTECTED]> writes: >There's aother one called ConnectTheDots and I've attached 2 versions to >this note. >Hope that helps, >Jason > > >-Original Message- >From: Robert DeRubeis [mailto:[EMAIL PROTECTED] >Sent: Wednesday, June 25, 2003 7:26 PM >To: 'MapInfo-L' >Subject: MI-L Create line between points > > >If I had a table of different points, is there a way to create a line >between those points going from point 1 to point 2, then from point 2 to >point 3, etc? I can set up the table so the starting point would be the >first row and the ending point would be the last row if needed. > >I was looking around for an mbx I had previously downloaded called >spidermap or something similar, but forgot where I found it before. I'm >not sure if that would be able to do this or not, but if you know what I >am referring to I would like to know where I could download it again. > >Thanks, >Bob > > >- >List hosting provided by Directions Magazine | www.directionsmag.com | >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >Message number: 7401 > > Bob DeRubeis GIS/Mapping 1-602-263-6811 X5454 - List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 7408
MI-L Create line between points
If I had a table of different points, is there a way to create a line between those points going from point 1 to point 2, then from point 2 to point 3, etc? I can set up the table so the starting point would be the first row and the ending point would be the last row if needed. I was looking around for an mbx I had previously downloaded called spidermap or something similar, but forgot where I found it before. I'm not sure if that would be able to do this or not, but if you know what I am referring to I would like to know where I could download it again. Thanks, Bob - List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 7401
MI-L Update Column
Does anyone know of a way to update a column in one table based on TWO columns from another table? I have a U.S. city table I would like to update a column with, but I need the two tables to match between BOTH city and state columns (ideally a third column to include the county), not just the city column because that same city exists in multiple states. Any programs or ideas how this could be done? I am using MIPro v6.0. Thanks in advance, -Bob - List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 7388
MI-L City Table List
Does anybody have or know where to get a complete U.S. city table list? What I am ideally looking for is a complete list of cities/towns with the following columns=> City, State, County, Population (if possible), Lat, Lon. I have downloaded and used the city places file(s) from USGS, but I have spent many hours correcting the many inaccuracies associated with the USGS file. Anywhere from cities with the wrong county and wrong lat/lon to listing cities as "ppl" that are not supposed to be. I do not want city subdivisions included with real city names. These are also included in MapInfo's U.S. city table (CityInfo-U.S. product). I have even spent the time combined all the city boundaries for each state that comes with Streetpro to create one big U.S. file. This new file works out great in that I have all the columns I wanted- even population I got by running it through TargetPro. The only problem I have is that it only contains 25,148 cities, so I am still missing thousands of smaller cities that do not have boundaries in the Streetpro product. Any help or information would be appreciated. Thanks, Bob DeRubeis GIS/Mapping 1-602-263-6811 X5454 - List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 5600
Fwd: Re(2): MI-L Mapinfo printing extra paper
Thanks to everyone for all your help and suggestions. I changed the setting on the plotter itself to "inked area only" and that seemed to fix the problem. Thanks again. -Bob [EMAIL PROTECTED] writes: > > >I think there is a setting on the plotter to set the page size. Set the >page >size to "auto" or "inked area only". > >Cheers > >Steve Smith >email: [EMAIL PROTECTED] >Australian Bureau of Statistics (ABS) >Geography/Spatial Consulting and Mapping (SC&M) >ABS Level 3 South 319 (02) 6252-6824 > > > >|+---> >|| "Robert DeRubeis"| >|| || uhaul.com> | >|| | >|| 05/11/2002 06:10 | >|| | >|+---> > >>| > | > | > | To: [EMAIL PROTECTED] > | > | cc: (bcc: Steve Smith/Staff/ABS) > | > | Subject: MI-L Mapinfo printing extra paper > | > >>| > > > > >Hi there, > >I have a problem when printing from a layout in mapinfo 6.0. I am using a >HP650 plotter on win98. If I do a custom paper size and put in something >less than 36" width (like 30x30") it will print out the map fine, but will >also spit out extra paper, out to about 42". If I put the custom page >size to 36" width (like 30x36), then it cuts it correctly without the >excess paper out to 42". > >Has anyone else run into this? > >Bob DeRubeis >GIS/Mapping >1-602-263-6811 >X5454 > > >- >List hosting provided by Directions Magazine | www.directionsmag.com | >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >Message number: 3901 > > > > > > > >--- >ABS Web Site: www.abs.gov.au Bob DeRubeis GIS/Mapping 1-602-263-6811 X5454 - List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 4019
Re: MI-L Strange Problem with Layouts
It could be your layout setting. Look under layout->options and make sure "show frame contents" is not on Never. See if that's the problem. -Bob [EMAIL PROTECTED] writes: >I am running Mapinfo 6.5 under NT and have 258 mb of ram. I have a >strange problem with Layouts that seems to be related to memory. When I >open a layout window, a map frame appears but no map. Other frames such >as a legend do appear and text appears. The entire layout prints >properly, even though the map does not appear on the screen layout. > >Any suggestions? > > >Richard Block >Department of Sociology >Loyola University >6525 N Sheridan Rd. >Chicago IL 60626 > >Telephone 773 508 3454 >FAX 773 508 7099 >email [EMAIL PROTECTED] > > >- >List hosting provided by Directions Magazine | www.directionsmag.com | >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >Message number: 3932 > > Bob DeRubeis GIS/Mapping 1-602-263-6811 X5454 - List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 3935
Re: MI-L Mapinfo printing extra paper
Yes, there is an advanced tab and the autorotate is checked. The whole map frame, borders, etc is within the 30x30 page size and under layout->options it shows only 1 page. It prints only one sheet, but it spits out an extra 14" of blank paper after the map. So instead of the 30x30 sheet with just the map, I end up with a 44x30 sheet that I have to trim 14" off from the bottom. -Bob [EMAIL PROTECTED] writes: >Does the 650 print dialog have an "advanced" tab? >If so, you should be able to find an "auto rotate" button which should >help. >Other than that, you might try to zoom into your layout and make sure >that the >edges are away from the paper edges. I have notice my layouts, at times, >have >caused different peoples computers to spit out extra pages b/c my margins >are >set-up one way, and theirs another. On their computer, my layout that >was one >page, is no 2 or four. >I hope this helps >rm > >Robert DeRubeis wrote: > >> Hi there, >> >> I have a problem when printing from a layout in mapinfo 6.0. I am >using a >> HP650 plotter on win98. If I do a custom paper size and put in >something >> less than 36" width (like 30x30") it will print out the map fine, but >will >> also spit out extra paper, out to about 42". If I put the custom page >> size to 36" width (like 30x36), then it cuts it correctly without the >> excess paper out to 42". >> >> Has anyone else run into this? >> >> Bob DeRubeis >> GIS/Mapping >> 1-602-263-6811 >> X5454 >> >> - >> List hosting provided by Directions Magazine | www.directionsmag.com | >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> Message number: 3901 - List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 3909
MI-L Mapinfo printing extra paper
Hi there, I have a problem when printing from a layout in mapinfo 6.0. I am using a HP650 plotter on win98. If I do a custom paper size and put in something less than 36" width (like 30x30") it will print out the map fine, but will also spit out extra paper, out to about 42". If I put the custom page size to 36" width (like 30x36), then it cuts it correctly without the excess paper out to 42". Has anyone else run into this? Bob DeRubeis GIS/Mapping 1-602-263-6811 X5454 - List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 3901
