0

Update 2

Below are the steps I re-projected shapefile. For some reason it disappears.

In QGIS double-click on shapefile

enter image description here

Right-click and select Set Layer CRS

enter image description here

Select WGS 84

enter image description here

Click OK

enter image description here

Right-click shapefile and select "Save As"

enter image description here

Create new subdirectory to save new shapefile

enter image description here

Click OK in Save Vector Layer

enter image description here

I uncheck the original shapefile and the new shapefile is blank

enter image description here

Update 1

Still struggling, found some clues.

This website, Power Map for Excel gives simple example and links to the Excel spreadsheet and shapefile. When I plug it in, it looks correct.

I went back to my original shapefile and it is plotting the boroughs of New York City across the world.

In QGIS the shapefile looks like this

enter image description here

But when I import into Excel Power Maps it looks like the following.

How to correct this? They are all points on a map instead of shapes AND they are all in the wrong place!

Staten Island in the North Pole

enter image description here

Bronx is South of South Africa

enter image description here

Queens is in the Indian Ocean

enter image description here

Brooklyn is North of the Philippines

enter image description here

Manhattan is North of Indonesia

enter image description here

Original Question

I am very novice at shapefiles and cartography in general.

Finally found a shapefile (shapefile is under Borough Boundaries & Community Districts called "Borough Boundaries Clipped to Shorelines") that does not give errors when I import into Excel 2016 Power Map

I am not sure how to use Shapefile that I successfully imported.

I googled and searched for YouTube. YouTube only shows animation of completed maps, not a how-to.

And the book High Impact Data Visualization in Excel with Power View, 3D Maps, Get & Transform and Power BI, 2nd Edition (free download at allitebooks) gives one or two sentences, not even a tutorial on how to import for use!

Here are the steps, perhaps you will understand

I opened Excel 2016 Power Map > Clicked on Custom Regions

enter image description here

Click on Import New Set

enter image description here

Select BoroName

enter image description here

Click on Import

enter image description here

Map view defaults to the Indian subcontinent, which I find odd because the shapefile is 5 boroughs of New York

enter image description here

I attempt to add a field from my data whose name is BOROUGH. Entire dataset can be downloaded from NYS Open Data

enter image description here

Then I add Custom Region Set and nothing happens.

What am I supposed to do next?

enter image description here

  • Based on the blog post, data had to be in wgs84 (nad83 would likely work too) but your NY data is in a projected coordsys. Somehow you need to reproject it. The graffiti data is not regions but should be imported at addresses or points, but may have the same coordsys problem – mkennedy Jul 3 '17 at 1:40
  • @mkennedy I changed to projection to wgs84 and still doesn't work. I'm hoping to have shapefile of all 5 boroughs. As for graffiti data, I have separate question here, gis.stackexchange.com/questions/246146/… – Rhonda Jul 3 '17 at 15:36
  • Hi Rhonda. How did you change it? Did you reproject it--which should have given you a second shapefile? Or did you change the coordinate system (projection), maybe by replacing the .prj file? The latter updates the metadata only, not the data itself. What software do you have access to, besides the Office one? – mkennedy Jul 3 '17 at 17:44
  • @mkennedy I have access to QGIS. I believe I reprojected it by selecting properties and changing it. When I get home I'll post screenshots (still navigating my way around mapping) – Rhonda Jul 3 '17 at 17:46
  • @mkennedy Please see updated question – Rhonda Jul 3 '17 at 22:12
1

I think you're not quite getting the reprojection right. You've got the right steps, just not the right options.

In the shapefile properties, when you pick Set Layer CRS you need to set the spatial reference to what the layer is, not what you want it to be. For this data it looks like it is EPSG:2263. This is easy to misinterpret - the command intends to set the CRS of the QGIS Layer, not the data file it is drawing. It's usually used when the spatial reference isn't defined in the source data so QGIS can't automatically determine which one to use.

Then when you go to Save As.., this is where you set it to EPSG:4326. This will reproject the data.

The reason it's not working is that when you Set Layer CRS to EPSG:4326 you're assigning the wrong coordinate system and QGIS is accepting what you tell it. Then when you Save As.. and pick EPSG:4326 here too QGIS thinks you're saving to the same coordinate system so it just uses the same coordinates. It then assigns the shapefile to that coordinate system, but the numbers don't make any sense.

  • I'll try this shortly – Rhonda Jul 4 '17 at 0:07
  • Thank you for your help. I have similar issue with creating shapefile from datapoints. I tried the approach of setting it to the projection is actually is, i.e. NY, and then saving to WGS 84. For some reason, EXCEL reports errors. If possible, please assist, gis.stackexchange.com/questions/246146/… – Rhonda Jul 4 '17 at 17:22

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.