2

Software Used

  • QGIS 2.18.10
  • MS Excel 2016

GitHub Repository With Files (link)

Update 3

Blank file when reprojecting

1. Open the layer

enter image description here

2. Double-click Reproject Layer

enter image description here

3. Select Reprojection Parameters

enter image description here

4. Reprojected layer is blank

enter image description here

5. Error when attempting to import to Excel 2016 Power Map

enter image description here

6. Directory of shapefile

enter image description here



Update 2

Unable to find Processing Tools

Here is something close, but none of the three sub-categories ask for output shapefile.

enter image description here




Update 1

Here are steps ... it appears correct in QGIS but there are still Invalid Geometry Errors in Excel Power Map

NOTE: Just for grins, in Step 5 I saved using NY projection instead of WGS 84 projection and I get same error.

1. Add Delimited Text Layer

enter image description here

2. Select options > OK

enter image description here

3. Select NY Projection

enter image description here

4. Right-click > Save As

enter image description here

5. Select WGS 84 Projection (what Excel accepts)

enter image description here

6. Output

enter image description here



Original Question

I am trying to create shapefile with DSNY_Graffiti_Information.csv

Created Layer from delimited text file

Then I select New York Projection (EPSG:2263)

Finally I save as shapefile in NY_Graffiti_Shapefile.zip

When I attempt to import shapefile to MS Excel 2016 Power Maps I get Invalid regions error

enter image description here

Attempted to use Topology Checker Plugin, but no errors are detected.

How do I fix this?

  • 1
    What projection are you using? Your csv is fine. I just created a shapefile from it in ArcGIS, so it has to be a problem related to the projection you're using in QGIS and Excel. Maybe you're not using the same one for both? – Sergio C. Jul 3 '17 at 5:03
  • @SergioC. I tried with projections WGS84 and New York Projection (EPSG:2263) – Rhonda Jul 3 '17 at 15:10
2

According to this post:

The Custom Regions feature in Power Map allows you to import KML or SHP files which contain custom polygons.

Since you're trying to import point geometry that would explain the Invalid Geometry error.

You could try running a buffer on the points in QGIS to convert them into small circles which might make it acceptable to Excel.

1

Before importing to Excel, make sure you define the projection in QGIS. Select the layer properties --> general --> Reference system and find the New York projection EPSG 2263.

Then right click on the layer again and select save as: The result should be a valid shapefile. I did it myself and works well both in QGIS and ArcGIS. Unfortenately, I don't have a license for Excel Power Maps so I can't try it there, but if ArcGIS opens it, the shapefile should be fine.

  • Hello @sergio-c I'm trying this now ... – Rhonda Jul 4 '17 at 14:31
  • I tried, still not working. Please see updated question for screenshots -- perhaps I overlooked something? – Rhonda Jul 4 '17 at 15:12
  • You should save your shapefile without changing the projection to wgs 1984 but keeping the New York one. That's what making Excel to be "confused". Once you have saved your shapefile, you need to convert it to wgs 1984, you'll get a second shp that you will add to excel. You will find the reproject tool under "processing tools". – Sergio C. Jul 4 '17 at 17:55
  • Unable to find processing tools. Closest thing I can find is Raster > Projections but neither Warp,Assign Projection, nor Extract Projection ask for shapefile or projection. Please see question under Update 2 – Rhonda Jul 4 '17 at 21:10
  • Try this: gis.stackexchange.com/a/218554/99720 – Sergio C. Jul 4 '17 at 21: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.