Two maps of Detroit on different sides of the globe

1815
13
06-15-2017 03:36 PM
AndreMasnari1
New Contributor II

Hello,
I'm a bit new to GIS and am having a bit of an issue
I have a .csv that i have converted into a feature class- the feature class displays correctly(it is a map of all robberies in Detroit in a given  year).  
I also have a .shp that is all of the locations of the lights in the same city- it also displays correctly, but in a completely different part of the map.
When I add a basemap, the .shp points are all in the correct city, while the .csv created feature class is out in the Atlantic ocean.
I have ensured that all the layers and the data frame are using the same geo reference systems.

I'm at a bit of a loss here.

I've attached both the .shp in a zip and the .csv I'm working with.  Any help would be much appreciated.  

0 Kudos
13 Replies
AndreMasnari1
New Contributor II

Sigh.... 

So, using the exact same data set, but simply a different .csv(burglary instead of robbery), I am having the same issue.  Following the exact same workflow as listed....  How could this be? 

0 Kudos
DanPatterson_Retired
MVP Emeritus

A few lines of the csv and what column you assigned as the X and the Y would be useful.  

Also, the csv will not have a defined coordinate system unless you used the Define Projection tool in arctoolbox, to tell it what it is.

Don't try to load csv files into a dataframe with existing data until you have converted it to a feature layer or shapefile, and define its projection/coordinate system.

If the data are in the range -180 to 180 and -90 to 90, then you undoubtedly have a file with a geographic coordinate system... perhaps GCS WGS84

Details would help

0 Kudos
AndreMasnari1
New Contributor II

A few lines pasted below....
X and Y are Long and Lat

cartodb_idthe_geomrownumcaseidcrimeidcrnoaddresscategoryoffensedescriptionstateoffensefileclassincidentdatehourscaprecinctcouncilneighborhoodcensustractlonlat
2720101000020E610000001DE02098AC354C03108AC1C5A344540518041147912217957141.2E+0900 CARPENTER  /  JUSTINEROBBERYROBBERY - STREET - OTHER WEAPON120001/21/201221111111City Council District 3CITY AIRPORT5106-83.055342.409
6450101000020E61000007CF2B0506BCA54C03108AC1C5A244540529922148604218043261.2E+0902200 SCHAEFERROBBERYROBBERY - STREET - STRONG ARM120002/20/2012204114OAKWOOD HEIGHTS5245-83.162842.284
9970101000020E61000009487855AD3CC54C0AAF1D24D62384540544040149992018216811.2E+0920100 GREENFIELDROBBERYROBBERY - STREET - STRONG ARM120003/25/201208048City Council District 2GREENFIELD5401-83.200442.4405
0 Kudos
DanPatterson_Retired
MVP Emeritus

So you are using Make XY Event Layer I presume... You have the option of specifying the Spatial Reference, so in the absence of other information I would assume a GCS WGS84  aka unprojected data in long lat with a wgs84 datum.

That should load into any file.  If you get the X and Y's mixed up, then you will have issues.  

Now... check for any rows that don't have the correct Long/lat coordinates.  If there are any blank cells in that column, then you are going to have issues... dump any rows that aren't complete before trying to import the data

0 Kudos