2 Replies Latest reply on May 28, 2013 1:22 PM by Allan Walker

    combining two location markers from two data sets on one map

    Alrich Lynch

      I have two locations markers with lat / long coordinates in two separate excel files. I want to show the two on one map. For example, warehouses with their own coordinates are in Warehouse.xls and retail stores with their coordinates are in Retail.xls. TThere doesn't seem to be a way to link the data along the lat / long and thus I can only show retail locations OR warehouse locations. I want to beable to show both at the same time.

        • 1. Re: combining two location markers from two data sets on one map
          Alex Kerin

          The simplest would be to put them in one Excel sheet. I did kind of manage it by adding a third file with a list of all locations, but this may not be possible for you. Equally I couldn't get the map background to work.

          • 2. Re: combining two location markers from two data sets on one map
            Allan Walker

            Hello Alrich,

             

            I'd advise using a custom SQL connection: something like this:

             

            SELECT  [MWShapeID]

            ,[Police_Time]

            ,[Fire_Time]

            ,a.[Code]

            ,a.[Campus_ID]

            ,[Fire_Date]

                  ,[sub_polygon_id]

                  ,[point_order]

                  ,b.[Latitude]

                  ,b.[Longitude]

                  ,[Nature of Crime]

                  ,[Event Number]

                  ,[Date of Occurrence]

                  ,[General Location]

                  ,[Case Status]

                  ,[Fire_Latitude]

                  ,[Fire_Longitude]

                  ,[Police_Latitude]

                  ,[Police_Longitude]

                  ,[Full Building Name]

                  ,[LOCATION]

                  ,[NATURE OF FIRE]

                  ,[CASE NUMBER]

              FROM [mapper_campus].[dbo].[Campus_Features] AS a

              JOIN [mapper_campus].[dbo].[Campus_Points] as b

              ON a.[Campus_ID]=b.[Campus_ID]

              LEFT JOIN  [mapper_campus].[dbo].[Police Log]AS c

              ON a.[Code]=c.[Code]

              LEFT JOIN [mapper_campus].[dbo].[XREF] AS x

            ON a.[Code]=x.[Code]

            LEFT JOIN [mapper_campus].[dbo].[Fire] AS f

            ON f.[Code]= a.[Code]

             

             

            In this example, we join the shapefile to both Police and Fire incidents.  Blog post here.

             

            Best Regards,

             

            Allan