------------------------------------------------------------ LGBTQ+ SMARTPHONE APPS & SERVICES Wecare.LGBT opensource repository ------------------------------------------------------------ Table of Contents 1. LGBTQ+ Smartphone Apps & Services 1.1 Structure 1.2 How to use the data 1.3 Wecare.LGBT User groups 1.4 How to help 2. About Wecare.LGBT 2.1 Support 2.2 Licence 2.3 Essential Documentation ------------------------- 1. LGBTQ+ SMARTPHONE APPS & SERVICES ------------------------- A database and supporting files relating to LGBTQ+ Smartphone Apps and Services designed specifically for the community around the world. Resources with the status of validated means that the entry is owned and managed by the organization or services. All other entries will be made available as Unvalidated. ------------------------- 1.1 STRUCTURE ------------------------- The database contains 12 fields (columns) and will be available in CSV format. Supporting images (if applicable) will be available via a zipped file and in various image formats (jpegs, gifs and pngs) and sizes. The database schema is as follows: - ------------------------------------------------------- Field Name | Type | Description ------------------------------------------------------- SmAppsId | Text | The unique identifier of the app or service SmAppStatus | Text| The status of the app or service (Validated or Unvalidated) SmAppsName | Text | Teh name of the app or service SmAppsDesc | Text | The description of the app or service SmAppsOwner | Text | The name of the organisation or individual who manages the app or service SmAppsGrp | Text | The group the app or service is tailored towards (Asexual, Bisexual, Gay, General, Heterosexual | Ally, Lesbian, Nonbinary, Other, Refugee, SGL, Support Groups, Transgender, Youth) SmAppsTyp | Text | The app or service type (Business, Chat, Dating, Films, Gaming, Information, Lifestyle, Magazine, Marriage, Media, News, Other, Radio, Social Network, Support (Families), Support (General), Support (Self-Help), Travel) SmAppsTarg | Text | A free form field in which the app or service can highlight the target or intended audience SmAppsGoogle | Url | The link to the Google Play Store for the app or service SmAppsApple | Url | The link to the Apple App Store for the app or service SmAppsLang | Text| The targeted language for the app or service (Arabic, Bengali, English, French, German, Hindi, Italian, Mandarin, Other, Polish, Portuguese, Russian, Spanish, Turkish) SmAppsPricing | Text | The pricing structure of the app or service (Free or Paid) ----------------------------- Sample entries ----------------------------- "ma00191","Validated","Gayther Affinity","Gayther Affinity is a private platform for the LGBTQ+ community and their friends. A space that gives you the freedom to be yourself, helping you communicate with and connect to people similar to yourself from around the world and from all age groups and backgrounds. Get involved with groups discussions, ask questions or quickly search for inclusive business, services, and events near you. Gayther Affinity is committed to safeguarding its users. Through a closed network where user registration is required and enforcing block/report policies and functions to stop online abuse. Signup for your free Affinity account today...more","Ovester","General","Social Network","LGBTQ+","https://gayther.lgbt","https://gayther.lgbt","English","Free" ------------------------- 1.2 HOW TO USE THE DATA ------------------------- The latest CSV file will be available each week. To use the data, subject to the licence terms and conditions, all you need to do is click on the link and download the link to your local machine. The CSV file and structure is designed to help you quickly upload the data into a database or table such as MySQL. The table and text are available in UTF-8 (UCS Transformation Format 8). 1) Visit the download page (https://wecare.lgbt/download) 2) To quickly and easily upload the data to your chosen database or table, many free and paid tools are available to help - - MYSQL TABLE DATA EXPORT/IMPORT WIZARD - information about the MySQL wizard can be found by visiting the MySQL support documents (https://dev.mysql.com/doc/workbench/en/wb-admin-export-import-table.html) - - WORDPRESS - plugins such as WP All Import and WP Ultimate CSV importer can help and be found within the wordpress.org plugins repository (https://en-gb.wordpress.org/plugins/) - - DRUPAL - modules such as CSV Importer and CKEditor can help and be found within the Drupal.org repository (https://www.drupal.org/project/project_module) - - JOOMLA - extensions such as content uploader and vdata can help and found within the Joomla Extensions Directory (https://extensions.joomla.org/) - - WIX - you can upload the CSV file via the 'Content Manager' in your dashboard. Select the collection you want to open, click on the 'show more' icon and select import items ------------------------- 1.3 WECARE.LGBT USER GROUPS ------------------------- The users of the Wecare.LGBT opensource project typically falls into two groups: - - DATA CONTRIBUTORS – the contributors will typically be service, event organizers or LGBTQIA+ individuals wishing to highlight and promote important events, services and tools for the benefit of the wider community - - DATA RECIPIENTS – the recipients, will typically be creators, website owners, influencers, service providers and information tools. The recipients will make the information available to their users and visitors The list is not exhaustive; however, it highlights the two key group ------------------------- 1.4 HOW YOU CAN HELP ------------------------- The nature of open-source projects means that data contributors and recipients can freely share and use publicly available information. Wecare.LGBT endeavours to provide the latest and most up-to-date information to its users and relies on all parties to help promote and keep the data accurate. If you are a data contributor, create an account and manage your profile and relevant listings. Doing so means that the database will be kept up to date and communicated to a wide variety of services and creators. Services, tools, and websites inform the global LGBTQIA+ community on an ongoing basis. Should you be a data contributor and have any information you wish to share. You can do so by using the contact us page or emailing us at data@wecare.LGBT. Wecare.LGBT is free to use the tool, and we appreciate all those wishing to take part and contribute to the accuracy and completeness of the data ------------------------- 2. ABOUT WECARE.LGBT ------------------------- Wecare.LGBT is an open-source project focused on collecting, organizing and sharing LGBTQ+ related information with the world. The project was created to ensure that community information is recorded and made available freely in a format that is accessible to all. The project aims to become a central library for all LGBTQ+ related data that will grow over time and become a valuable resource widely accessed and used worldwide. Wecare.LGBT was designed so that those from within the community can add and manage the data. The opensource project has two key objectives. The first objective is to share and promote LGBTQIA+ related information, such as upcoming events and tailored and designed resources for the global community. The second is to ensure that the wider internet and visitors to the various websites offering LGBTQIA+ information have up-to-date and accurate information directly from the service creators or event organizers. The nature of the opensource means that the service or event organizers can choose what they share. Encouraging the various types of websites, services and creators worldwide to use the most up to date information. A central repository that the internet can use freely, subject to the permitted purposes and terms of the opensource To learn more about Wecare.LGBT, please visit https://wecare.LGBT ------------------------- 2.1 SUPPORT ------------------------- If you have any questions or problems regarding any of the Wecare.LGBT, please visit the contact us page (https://wecare.lgbt/contact) or via email (support@wecare.lgbt) ------------------------- 2.2 LICENCE ------------------------- Licenced under the creative commons ShareAlike 4.0 - International Public Licence. Copyright 2021 All rights reserved. Wecare.LGBT For the acceptable use and more information about the licence and attribution, please visit https://wecare.lgbt/licensing#license ------------------------- 2.3 ESSENTIAL DOCUMENTATION ------------------------- - - Wecare.LGBT Disclaimer (https://wecare.lgbt/licensing#disclaimer) - - Wecare.LGBT License - ShareAlike 4.0 - International Public Licence (https://wecare.lgbt/licensing#license) - - Wecare.LGBT Code of Conduct (https://wecare.lgbt/licensing#conduct) - - Wecare.LGBT Privacy Notice (https://wecare.lgbt/privacy) - - Creative Commons Attribution-ShareAlike 4.0 - CC BY-SA 4.0 (https://creativecommons.org/licenses/by-sa/4.0/)