Skip to content

7mary4/geoaccess

BranchesTags
 
 

Repository files navigation

#Welcome to Geolocation Accessibility Challenge

Prototype at http://geoaccess.heroku.com/

Prototype based on discussions on http://tech.groups.yahoo.com/group/geoaccess/

Accessibility information provided by Easy access Chicago

##Current db schema

CREATE TABLE IF NOT EXISTS `attractions` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `AttractionName` varchar(50) NOT NULL,
  `Street` varchar(50) NOT NULL,
  `City` varchar(25) NOT NULL,
  `State` varchar(2) NOT NULL,
  `Zip` varchar(10) NOT NULL,
  `Phone` varchar(20) NOT NULL,
  `Web` varchar(80) NOT NULL,
  `htmlInfo` text NOT NULL,
  `htmlDeaf` text NOT NULL,
  `htmlBlind` text NOT NULL,
  `htmlAccess` text NOT NULL,
  `htmlRestroom` text NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

CREATE TABLE IF NOT EXISTS `hotels` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `Location` varchar(50) NOT NULL,
  `Keywords` text NOT NULL,
  `HotelName` varchar(75) NOT NULL,
  `Description` text NOT NULL,
  `Street` varchar(75) NOT NULL,
  `City` varchar(25) NOT NULL,
  `State` varchar(2) NOT NULL,
  `Zip` varchar(10) NOT NULL,
  `DirectReservationNumber` varchar(20) NOT NULL,
  `ReservationFax` varchar(20) NOT NULL,
  `TollFreeReservationNumber` varchar(20) NOT NULL,
  `Web` varchar(80) NOT NULL,
  `Price` varchar(1) NOT NULL,
  `htmlInfo` text NOT NULL,
  `htmlDeaf` text NOT NULL,
  `htmlBlind` text NOT NULL,
  `htmlAccess` text NOT NULL,
  `htmlGuestroom` text NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `Location` (`Location`),
  FULLTEXT KEY `HotelName` (`HotelName`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=86 ;

CREATE TABLE IF NOT EXISTS `museums` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `MuseumName` varchar(50) NOT NULL,
  `Street` varchar(50) NOT NULL,
  `City` varchar(25) NOT NULL,
  `State` varchar(2) NOT NULL,
  `Zip` varchar(10) NOT NULL,
  `Phone` varchar(20) NOT NULL,
  `TTY` varchar(20) NOT NULL,
  `Web` varchar(80) NOT NULL,
  `htmlInfo` text NOT NULL,
  `htmlDeaf` text NOT NULL,
  `htmlBlind` text NOT NULL,
  `htmlAccess` text NOT NULL,
  `htmlRestroom` text NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=23 ;


CREATE TABLE IF NOT EXISTS `nightclubs` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `NightclubName` varchar(50) NOT NULL,
  `Street` varchar(50) NOT NULL,
  `City` varchar(25) NOT NULL,
  `State` varchar(2) NOT NULL,
  `Zip` varchar(10) NOT NULL,
  `Phone` varchar(20) NOT NULL,
  `Web` varchar(80) NOT NULL,
  `htmlInfo` text NOT NULL,
  `htmlDeaf` text NOT NULL,
  `htmlBlind` text NOT NULL,
  `htmlAccess` text NOT NULL,
  `htmlRestroom` text NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

CREATE TABLE IF NOT EXISTS `parts` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `Location` varchar(50) NOT NULL,
  `Keywords` text NOT NULL,
  `TheatreName` varchar(50) NOT NULL,
  `Description` text NOT NULL,
  `Street` varchar(50) NOT NULL,
  `City` varchar(25) NOT NULL,
  `State` varchar(2) NOT NULL,
  `Zip` varchar(10) NOT NULL,
  `Phone` varchar(20) NOT NULL,
  `Web` varchar(80) NOT NULL,
  `ParkingOffsite` text NOT NULL,
  `ParkingNotes` text NOT NULL,
  `ParkingZone` tinyint(1) NOT NULL DEFAULT '0',
  `ParkingValet` tinyint(1) NOT NULL DEFAULT '0',
  `ParkingPrivate` tinyint(1) NOT NULL DEFAULT '0',
  `ParkingPrivateNoSpace` tinyint(1) NOT NULL DEFAULT '0',
  `ParkingStreet` tinyint(1) NOT NULL DEFAULT '0',
  `DeafNone` tinyint(1) NOT NULL DEFAULT '0',
  `DeafAls` tinyint(1) NOT NULL DEFAULT '0',
  `DeafAlsInfrared` tinyint(1) NOT NULL DEFAULT '0',
  `DeafAlsSennheiser` tinyint(1) NOT NULL DEFAULT '0',
  `DeafAlsHeadsets` tinyint(1) NOT NULL DEFAULT '0',
  `DeafAlsOneEar` tinyint(1) NOT NULL DEFAULT '0',
  `DeafInterpretation` tinyint(1) NOT NULL DEFAULT '0',
  `DeafInterpretationRequest` tinyint(1) NOT NULL DEFAULT '0',
  `DeafInterpretationSchedule` tinyint(1) NOT NULL DEFAULT '0',
  `DeafInterpretationOnline` tinyint(1) NOT NULL DEFAULT '0',
  `DeafCaptioningVFP` tinyint(1) NOT NULL DEFAULT '0',
  `DeafCaptioningVF` tinyint(1) NOT NULL DEFAULT '0',
  `DeafCaptioning` tinyint(1) NOT NULL DEFAULT '0',
  `DeafCaptioningSchedule` tinyint(1) NOT NULL DEFAULT '0',
  `DeafScript` tinyint(1) NOT NULL DEFAULT '0',
  `DeafScriptRequest` tinyint(1) NOT NULL DEFAULT '0',
  `DeafVolumePublicPhone` tinyint(1) NOT NULL DEFAULT '0',
  `DeafElevator` tinyint(1) NOT NULL DEFAULT '0',
  `DeafPublicStrobe` tinyint(1) NOT NULL DEFAULT '0',
  `DeafRestroomStrobe` tinyint(1) NOT NULL DEFAULT '0',
  `DeafTtyPublic` tinyint(1) NOT NULL DEFAULT '0',
  `DeafVolumePhone` tinyint(1) NOT NULL DEFAULT '0',
  `DeafNotes` text NOT NULL,
  `BlindOrientation` tinyint(1) NOT NULL DEFAULT '0',
  `BlindOrientationGroup` tinyint(1) NOT NULL DEFAULT '0',
  `BlindPlaybillsBraille` tinyint(1) NOT NULL DEFAULT '0',
  `BlindPlaybillsLarge` tinyint(1) NOT NULL DEFAULT '0',
  `BlindProgramsBraille` tinyint(1) NOT NULL DEFAULT '0',
  `BlindProgramsLarge` tinyint(1) NOT NULL DEFAULT '0',
  `BrailleAudio` tinyint(1) NOT NULL DEFAULT '0',
  `BrailleAudioFilm` tinyint(1) NOT NULL DEFAULT '0',
  `BlindMenuLarge` tinyint(1) NOT NULL DEFAULT '0',
  `BlindMenuRead` tinyint(1) NOT NULL DEFAULT '0',
  `BlindHeightClearance` tinyint(1) NOT NULL DEFAULT '0',
  `BlindObjects` tinyint(1) NOT NULL DEFAULT '0',
  `BlindElevatorAudible` tinyint(1) NOT NULL DEFAULT '0',
  `BlindSignageElevator` tinyint(1) NOT NULL DEFAULT '0',
  `BlindSignageHoistways` tinyint(1) NOT NULL DEFAULT '0',
  `BlindSignageRestroom` tinyint(1) NOT NULL DEFAULT '0',
  `BlindSignageExits` tinyint(1) NOT NULL DEFAULT '0',
  `BlindInteriorSignageLarge` tinyint(1) NOT NULL DEFAULT '0',
  `BlindInteriorSignageContrast` tinyint(1) NOT NULL DEFAULT '0',
  `BlindInteriorSignageGlare` tinyint(1) NOT NULL DEFAULT '0',
  `BlindDoggy` text NOT NULL,
  `BlindNotes` text NOT NULL,
  `SecondaryEntrance` text NOT NULL,
  `EntranceNotes` text NOT NULL,
  `EntranceLevel` tinyint(1) NOT NULL DEFAULT '0',
  `EntranceSloped` tinyint(1) NOT NULL DEFAULT '0',
  `EntranceDoor` tinyint(1) NOT NULL DEFAULT '0',
  `EntranceTwoDoors` tinyint(1) NOT NULL DEFAULT '0',
  `EntranceThreshold` tinyint(1) NOT NULL DEFAULT '0',
  `EntranceAutomatic` tinyint(1) NOT NULL DEFAULT '0',
  `EntrancePush` tinyint(1) NOT NULL DEFAULT '0',
  `EntranceAutomaticPush` tinyint(1) NOT NULL DEFAULT '0',
  `EntranceLever` tinyint(1) NOT NULL DEFAULT '0',
  `PhysicalEquipmentWheelchair` tinyint(1) NOT NULL DEFAULT '0',
  `PhysicalEquipmentNotes` text NOT NULL,
  `InteriorCorridor` tinyint(1) NOT NULL DEFAULT '0',
  `InteriorAccessNotes` text NOT NULL,
  `ElevatorNone` tinyint(1) NOT NULL DEFAULT '0',
  `ElevatorOneLevel` tinyint(1) NOT NULL DEFAULT '0',
  `ElevatorClearance` tinyint(1) NOT NULL DEFAULT '0',
  `ElevatorCar` tinyint(1) NOT NULL DEFAULT '0',
  `ElevatorControls` tinyint(1) NOT NULL DEFAULT '0',
  `ElevatorNotes` text NOT NULL,
  `FacilitiesBoxOffice` tinyint(1) NOT NULL DEFAULT '0',
  `FacilitiesInfoCounter` tinyint(1) NOT NULL DEFAULT '0',
  `FacilitiesBrochure` tinyint(1) NOT NULL DEFAULT '0',
  `FacilitesCoatCheck` tinyint(1) NOT NULL DEFAULT '0',
  `FacilitiesGiftShop` tinyint(1) NOT NULL DEFAULT '0',
  `FacilitiesPhone` tinyint(1) NOT NULL DEFAULT '0',
  `FacilitiesDrinkFountain` tinyint(1) NOT NULL DEFAULT '0',
  `FacilitiesVending` tinyint(1) NOT NULL DEFAULT '0',
  `FacilitiesAtm` tinyint(1) NOT NULL DEFAULT '0',
  `FacilitiesTicketCounter` tinyint(1) NOT NULL DEFAULT '0',
  `AccessibleFacilitiesNotes` text NOT NULL,
  `FacilitiesBarCounterServiceOnly` tinyint(1) NOT NULL DEFAULT '0',
  `FacilitiesBarCounterNotLowered` tinyint(1) NOT NULL DEFAULT '0',
  `FacilitiesBarTables` tinyint(1) NOT NULL DEFAULT '0',
  `FacilitiesBarCounter` tinyint(1) NOT NULL DEFAULT '0',
  `FacilitiesBarChairs` tinyint(1) NOT NULL DEFAULT '0',
  `FacilitiesBarSofas` tinyint(1) NOT NULL DEFAULT '0',
  `FacilitiesBarChairsArms` tinyint(1) NOT NULL DEFAULT '0',
  `FacilitiesBarNotes` text NOT NULL,
  `PerformanceMoveableSeating` tinyint(1) NOT NULL DEFAULT '0',
  `PerformanceFixedSeating` tinyint(1) NOT NULL DEFAULT '0',
  `PerformanceMoveableArm` tinyint(1) NOT NULL DEFAULT '0',
  `PerformanceBoxes` tinyint(1) NOT NULL DEFAULT '0',
  `PerformanceStage` tinyint(1) NOT NULL DEFAULT '0',
  `PerformanceBackstage` tinyint(1) NOT NULL DEFAULT '0',
  `StageName` varchar(255) NOT NULL,
  `Seats` varchar(4) NOT NULL,
  `WheelchairSeats` varchar(4) NOT NULL,
  `WheelchairSeatLocation` text NOT NULL,
  `WheelchairCompanionSeat` text NOT NULL,
  `PerformanceSpaceNotes` text NOT NULL,
  `Performance2MoveableSeating` tinyint(1) NOT NULL DEFAULT '0',
  `Performance2FixedSeating` tinyint(1) NOT NULL DEFAULT '0',
  `Performance2MoveableArm` tinyint(1) NOT NULL DEFAULT '0',
  `Performance2Boxes` tinyint(1) NOT NULL DEFAULT '0',
  `Performance2Stage` tinyint(1) NOT NULL DEFAULT '0',
  `Performance2Backstage` tinyint(1) NOT NULL DEFAULT '0',
  `StageName2` varchar(255) NOT NULL,
  `Seats2` varchar(4) NOT NULL,
  `WheelchairSeats2` varchar(4) NOT NULL,
  `WheelchairSeatLocation2` text NOT NULL,
  `WheelchairCompanionSeat2` text NOT NULL,
  `Performance2SpaceNotes` text NOT NULL,
  `ExhibitRoute` tinyint(1) NOT NULL DEFAULT '0',
  `ExhibitManeuver` tinyint(1) NOT NULL DEFAULT '0',
  `ExhibitViewable` tinyint(1) NOT NULL DEFAULT '0',
  `ExhibitsNotes` text NOT NULL,
  `PublicRestroomNotAccessible` tinyint(1) NOT NULL DEFAULT '0',
  `PublicRestroomMenWomen` tinyint(1) NOT NULL DEFAULT '0',
  `PublicRestroomUnisex` tinyint(1) NOT NULL DEFAULT '0',
  `PublicRestroomSymbol` tinyint(1) NOT NULL DEFAULT '0',
  `PublicRestroomEntry` tinyint(1) NOT NULL DEFAULT '0',
  `PublicRestroomThreshold` tinyint(1) NOT NULL DEFAULT '0',
  `PublicRestroomManeuver` tinyint(1) NOT NULL DEFAULT '0',
  `PublicRestroomStall` tinyint(1) NOT NULL DEFAULT '0',
  `PublicRestroomStallDoor` tinyint(1) NOT NULL DEFAULT '0',
  `PublicRestroomStallSwing` tinyint(1) NOT NULL DEFAULT '0',
  `PublicRestroomStallOut` tinyint(1) NOT NULL DEFAULT '0',
  `PublicRestroomStallSwingOut` tinyint(1) NOT NULL DEFAULT '0',
  `PublicRestroomGrabBarSideOnly` tinyint(1) NOT NULL DEFAULT '0',
  `PublicRestroomGrabBar` tinyint(1) NOT NULL DEFAULT '0',
  `PublicRestroomTransfer` tinyint(1) NOT NULL DEFAULT '0',
  `PublicRestroomToiletHeight` tinyint(1) NOT NULL DEFAULT '0',
  `PublicRestroomAmbulatoryGrabBar` tinyint(1) NOT NULL DEFAULT '0',
  `PublicRestroomSink` tinyint(1) NOT NULL DEFAULT '0',
  `PublicRestroomInsulatedPipes` tinyint(1) NOT NULL DEFAULT '0',
  `PublicRestroomMirror` tinyint(1) NOT NULL DEFAULT '0',
  `PublicRestroomVending` tinyint(1) NOT NULL DEFAULT '0',
  `PublicRestroomFaucetAutomatic` tinyint(1) NOT NULL DEFAULT '0',
  `PublicRestroomFaucetLever` tinyint(1) NOT NULL DEFAULT '0',
  `PublicRestroomFaucetEither` tinyint(1) NOT NULL DEFAULT '0',
  `PublicRestroomLatch` tinyint(1) NOT NULL DEFAULT '0',
  `PublicRestroomHandle` tinyint(1) NOT NULL DEFAULT '0',
  `PublicRestroomNotes` text NOT NULL,
  `htmlInfo` text NOT NULL,
  `htmlDeaf` text NOT NULL,
  `htmlBlind` text NOT NULL,
  `htmlAccess` text NOT NULL,
  `htmlRestroom` text NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `Location` (`Location`),
  FULLTEXT KEY `Keywords` (`Keywords`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

CREATE TABLE IF NOT EXISTS `restaurants` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `Location` varchar(50) NOT NULL,
  `Keywords` text NOT NULL,
  `RestaurantName` varchar(50) NOT NULL,
  `Description` text NOT NULL,
  `Street` varchar(50) NOT NULL,
  `City` varchar(25) NOT NULL,
  `State` varchar(2) NOT NULL,
  `Zip` varchar(10) NOT NULL,
  `Phone` varchar(20) NOT NULL,
  `Web` varchar(80) NOT NULL,
  `Cusine` varchar(50) NOT NULL,
  `Price` varchar(1) NOT NULL,
  `htmlInfo` text NOT NULL,
  `htmlDeaf` text NOT NULL,
  `htmlBlind` text NOT NULL,
  `htmlAccess` text NOT NULL,
  `htmlRestroom` text NOT NULL,
  `PropertyNotes` text NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `Location` (`Location`),
  FULLTEXT KEY `Keywords` (`Keywords`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=120 ;

CREATE TABLE IF NOT EXISTS `sportsview` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `SportsviewName` varchar(75) NOT NULL,
  `Street` varchar(75) NOT NULL,
  `City` varchar(25) NOT NULL,
  `State` varchar(2) NOT NULL,
  `Zip` varchar(10) NOT NULL,
  `Phone` varchar(20) NOT NULL,
  `Web` varchar(80) NOT NULL,
  `htmlInfo` text NOT NULL,
  `htmlDeaf` text NOT NULL,
  `htmlBlind` text NOT NULL,
  `htmlAccess` text NOT NULL,
  `htmlRestroom` text NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

CREATE TABLE IF NOT EXISTS `theatres` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `Location` varchar(50) NOT NULL,
  `Keywords` text NOT NULL,
  `TheatreName` varchar(50) NOT NULL,
  `Description` text NOT NULL,
  `Street` varchar(50) NOT NULL,
  `City` varchar(25) NOT NULL,
  `State` varchar(2) NOT NULL,
  `Zip` varchar(10) NOT NULL,
  `Phone` varchar(20) NOT NULL,
  `Web` varchar(80) NOT NULL,
  `htmlInfo` text NOT NULL,
  `htmlDeaf` text NOT NULL,
  `htmlBlind` text NOT NULL,
  `htmlAccess` text NOT NULL,
  `htmlRestroom` text NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `Location` (`Location`),
  FULLTEXT KEY `Keywords` (`Keywords`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=28 ;

More to come

About

Geolocation Accessibility prototype

Resources

Readme
Activity

Stars

1 star

Watchers

2 watching

Forks

0 forks
Report repository

Releases

No releases published

Packages

No packages published