Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have data example an organizations,

which consists, name of organization, facility type, latitude, longitude starting date of facility.My problem is for particular facility i had two or more starting dates, now i want to store those multiple dates in single file, how is it possible? my data is now in excel, i want to make shape file now..

share|improve this question

You can use a One-to-many relationship from a shapefile ("one") to a table ("many").

Store all data that is unique for each facility in a shapefile: facility-id, Geometry, type, lat, log, ...

Store data with one or more values for each facility in a second table e.g. *.dbf (not in a shape file!): facility-id, start-date, ...

Relate (not join!) the shapefile and the table. Use facility-id as keyfield.

You can find more information in ArcGIS help.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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