Query sql distance google map jobs

...diagram, relational schema, database dump, SQL files, and queries for a library database system. Requirements: - ER Diagram: An ER diagram is required with rationalities similar to the example provided in this link: - Relational Schema: Develop a relational schema that effectively models the database. - Database Dump: Provide a database dump for the system. - SQL Files and Queries: The project should include a set of SQL files and queries that effectively interact with the database. - Managerial Queries: Develop a minimum of 20 managerial queries that will be used to analyze and manage the library database. Deadline: This project must be completed by Monday. Ideal Skills: - Proficiency in database design and SQL - Experience with ER diagram creation - A...

...facing some persistent issues with Google Search Console and I need an expert to help me resolve them. Key tasks involved: - Fixing Indexing Issues: There are some pages on my site that aren't being indexed properly by Google. This could be due to various reasons like crawling errors, server problems, etc. - Resolving Sitemap Errors: I've been receiving errors related to the sitemap of my website. This could be contributing to the indexing problems. - Addressing Mobile Usability Issues: Google has flagged some mobile usability issues on my site. I want to ensure my website is fully mobile-friendly and complies with Google's guidelines. Ideal Skills and Experience: - Strong understanding of Google Search Console: You should have a deep unders...

I'm seeking a skilled freelancer to help me standardize and improve the formatting of my Google Sheet. The main focus will be on creating consistent cell styles for optimal readability. Specific requirements include: - Implementing a minimalist and clean design theme throughout the sheet - Creating a uniform style for all cells, making sure the data is easy to understand at a glance The ideal candidate will have: - Proficiency in Google Sheets, with a strong understanding of formatting options and best practices - A keen eye for design and the ability to create a clean, minimalist look - Experience with data visualization and turning complex information into easily digestible formats If you're confident in your ability to transform a spreadsheet into a visually...

...to half page to accompany the chapter number and chapter sub title e.g. chapter 1, a new life, chapter 2 exciting plans. Each small illustration should depict a scene from the up and coming chapter and include some background. 12-year old explorers displaying characteristics of curiosity. One specific scene to be illustrated is when the young explorers gather around to study a secret map. They each have small backpacks and would be standing on a small path in front of a rock face. There is no specific requirement regarding the interaction between the characters. Other scenes depict their young mothers being handed an old ribbon bound file. The four children setting up tents with the rundown Manor House partially in view behind dense bushes. The four children struggling to pus...

I'm looking for an expert to create and oversee a Google Ads campaign for my e-commerce business. - Goal: The primary goal of this campaign is to increase sales. Your strategies should be geared towards this objective. - Target Audience: The target audience for this campaign is a national one. You should have an understanding of how to tailor ads to draw attention from across the country. Our customer base is largely Business to Business, and we are wanting to market Australia wide. - Google Shopping ads have traditionally worked well for us also. The ideal freelancer for this project should have demonstrable experience in managing Google Ads for e-commerce businesses, ideally in the industrial fittings industry, with a strong track record of increasing sales...

...business based in the Grey Industry, we're looking for a Google Ads expert with a proven track record in lead generation. Key Requirements: - The main goal of our campaign is to generate B2C leads. Your experience in targeting and appealing to this demographic is crucial. - Expertise in Google Ads and a strong understanding of lead generation strategies is a must. - A background in the Grey Industry or similar industries is a definite plus, but not mandatory. Key Deliverables: - Develop a Google Ads campaign tailored to our B2C audience to effectively generate leads. - Monitor and optimize the campaign to ensure a high lead conversion rate. Skills and Experience: - Proven experience in successful lead generation campaigns on Google Ads. - Strong under...

We talk about it :)

...create a customized inventory management app using Google AppSheet and MySQL. The app will cater to a user base of less than 50, but it needs to be designed and optimized for scalable growth. It should be intuitive, easy to use, and have a professional interface. Key features that need to be incorporated into the app include: - Real-time inventory tracking - Sales and purchase order management - Product barcode scanning As the app will be handling crucial data for my business, security and reliability are of utmost importance. The developer should have experience in creating and integrating secure databases, as well as a track record of building robust, scalable applications. The successful freelancer should have: - Proficiency in Google AppSheet and MySQL - Experienc...

Update Version for Heliopolis IFC Blender+FBX+ Unreal with google cesium Map

Update Version for Santa Lucia IFC Blender+FBX+ Unreal with google cesium Map

I'm seeking a skilled analyst to develop a geographic profile map that displays crime rates within the city. The goal of this representation is to visualize and understand patterns in city-level criminal activities. Ideal Skills and Experience: - Proficient in Geographic Information Systems (GIS) or similar software for cartographic design - Background in criminology or relevant areas is beneficial - Familiarity with data extraction from various online sources Project Responsibilities: - Extract data from internet sources - Analyze and present the data in a geo-visual format - Maintain accuracy in representing crime rates across the city

...Outputs required: - Exterior design and visual (in color) of (1) Western (street view), (2) Northern (ocean facing) and (3) Eastern (front door) elevations. No interior design required. - A visual (in color) of the Western side from street level is also required. The middle of the street is 18 meters from the current house, with the proposed addition of the pool and deck, this will reduce the distance to 14m. The street is 45m above sea level and the ground floor (floor / deck level) is 57m above sea level. The first floor (floor level) is 60 meters above sea level. The design should follow a modern aesthetic. I like earthy neutral colors to create a warm and inviting look. Ideal candidates should have: - Proven expertise in 3D modeling and rendering, especially in the architec...

I am in need of an expert in Google Ads to help with lead generation for my software, which caters to enterprise companies. Key Requirements: - Develop and execute a Google Ads campaign focused on targeting enterprise companies. - Regularly monitor and optimize the campaign to ensure leads are being generated consistently. - Provide regular reports on the performance of the campaign, including the number of leads generated and the ROI. - Explain your actions at each step. Ideal Skills and Experience: - Proven track record of successful lead generation campaigns targeting enterprise companies. - Extensive experience with Google Ads, particularly in the B2B software industry. - Strong analytical skills to interpret campaign performance data and make data-driven decisi...

My Wordpress site has some issues. Also a lot error alerts in Google search console need expert to fix that

I'm looking for a seasoned AWS Data Engineer with over 8 years of experience to support me in handling data extraction and transformation tasks. Key Responsibilities: - Data Extraction: The engineer will be responsible for extracting structured data held in SQL databases. - Data Transformation: You will be required to transform the extracted data into a usable format for our analytics and reporting. Skills and Experience: - 8+ years of experience as an AWS Data Engineer. - Proficient in working with structured data, in particular, SQL databases. - Extensive experience in data transformation. - Expertise in AWS services, especially Amazon S3 and Glue. Your support will be essential in ensuring the smooth flow of our data processes. Please provide examples of your past ...

I am searching for a freelancer to enhance my local search rankings by creating and managing map citations on Google My Business to reach the top 3 positions with guaranteed results. If you cannot provide a guarantee, please do not apply for this job. Key Responsibilities: - Create high-quality Google Map Citations for my business - Ensure all information is up-to-date and accurate - Regularly monitor and update the citations to maintain their effectiveness Ideal Candidate: - Experience in local SEO and Google My Business - Proven track record in improving local search rankings through map citations - Detail-oriented and a stickler for accuracy - Capable of managing and updating the citations on an ongoing basis - Strong communication skills for ...

I'm in need of someone with strong experience in PostgreSQL for some critical tasks. - The ideal candidate should be well-versed in PostgreSQL, with a background in both database administration ...be well-versed in PostgreSQL, with a background in both database administration and development. - You must be able to handle complex issues that may arise with the database and be capable of performance tuning when necessary. - I expect you to understand the nuances of PostgreSQL and be able to provide solutions to potential problems with the database. - Any experience with data migration, query optimization and database design will be a plus. Please make sure to include your past work and experience with PostgreSQL in your application. Your detailed project proposals are high...

i have one php script which used to load in a few seconds now takes 4 minutes not sure why it suddenly lags need optimised - the mysql query hittin some bottleneck somewhere by looks of it

I'm in need of a skilled individual who is proficient in both PHP and Google Gemini. The primary task is to integrate this platform with my PHP website. Key requirements include: - Basic data syncing: The main goal is to ensure that the PHP website and Google Gemini can share important data seamlessly. This includes basic data such as user information, clicks, and impressions. The ideal candidate must have: - Demonstrated expertise in PHP and Google Gemini. - Prior experience in integrating Google Gemini with websites. - Strong communication skills to understand my requirements and provide updates on the integration process.

I'm in need of a Google Adsense expert to set up my account and ensure that my website is compliant with Adsense policies. Key Requirements: - Setting up Google Adsense account: I need help with the initial setup of my Adsense account to ensure it is done correctly. - Ensuring compliance: As I'm not sure if my website is currently compliant with Adsense policies, the freelancer should review my website and make necessary adjustments to ensure compliance. Ideal Freelancer: - Proven experience with setting up Google Adsense accounts and optimizing them for maximum revenue. - Good understanding of Google Adsense policies and experience in ensuring website compliance. - Communication skills: The freelancer should be able to explain the changes made and...

I'm seeking a highly skilled professional to develop an Google Map API of my hotel. This API based project should include some distinctive customised data, such as: * Hotel Amenities: Don't worry about detailing each amenity, this was left vague on purpose. * Nearby Attractions: Not only should you include their names but also a description, how far they are from the hotel, and their rating. * Room Rates: Standard and peak rates. * Pickup and Drop Facility: A briefing about it * Cab Requirements: I do have some specific needs when it comes to this, but you'll learn more about them later. * "Book Now” Button: Yes, I even need a button on the map. Your experience in Google Maps API, data customization, and interactive design will be inv...

...effectively set up Google Analytics on my Shopify store. This is crucial for my business as I aim to leverage the insights for various business objectives: - Tracking website traffic: Accurate data on website visitors will help me understand my audience, their preferences, and how they interact with the site. - Understanding customer behavior: By setting up Analytics to track user behavior, I can gain insights into what my customers are interested in, how they navigate the site, and what factors influence their purchasing decisions. - Improving marketing strategies: With Analytics, I aim to track the effectiveness of my marketing campaigns, understand which channels bring in the most valuable traffic, and optimize my marketing efforts accordingly. As I already have an existing ...

I am seeking the expertise of a skilled App Developer to produce a mobile application for both iOS and Android devices with dual functionality. This application will serve as a comprehensive guide for tourists and a platform f...experience. * Shopping-cart functionality and a secure checkout system are a must to facilitate transactions on the platform. Ideal Skills & Experience: * Proficiency in iOS and Android App Development. * Experience in creating apps with e-commerce and information features. * Strong UI/UX design skills. * Understanding of user registration and secure checkout systems. * Knowledge in integrating map services for location-based features is an asset. If you have substantial experience in these areas, I welcome your bid. Let's collaborate to bring t...

I'm in need of a Google Ads expert who can set up my campaign to specifically target a Business-to-Business (B2B) audience. Key Requirements: - Adjust Audience Targeting: I need the freelancer to adjust the targeting settings in Google Ads to exclude consumers and focus solely on businesses. This is crucial for the success of my campaign. - Optimize for B2B Conversions: The ideal candidate should have experience in B2B advertising. I want to ensure that the ad copy, creatives, and overall strategy are tailored for business professionals and decision-makers. Ideal Skills and Experience: - Strong Background in Google Ads: You should have a proven track record of running successful Google Ads campaigns with a focus on audience targeting. - B2B Advertisin...

Certified Google Ads Expert.......

I'm looking...an existing machine learning model into a Discord bot. The bot should cater to three main functionalities - sending daily race predictions, responding to user queries about race outcomes, and providing real-time race updates. Key Requirements: - Integrate an existing machine learning model into a Discord bot - Implement a feature to send daily race predictions on a specific channel - Develop a query system that effectively responds to user queries about race outcomes - Enable the bot to provide real-time race updates Your Skills: - Proficiency in machine learning model integration with Discord bots - Experience in developing chatbots, particularly for Discord - Knowledge of horse racing and related terminologies - Ability to create an efficient and responsive r...

...based on the transport's distance, size, and location. The logistician contacts these couriers via Outlook to inquire about availability and pricing. Selection and Confirmation: Upon receiving responses, the logistician selects the best courier based on price and availability. The logistician fills out an order form in Excel, converts it to PDF, and sends it to the chosen courier to confirm the shipment. Automate File Transfer Based on Client and Project: Implement a system that automatically transfers the transport query from one file to another in the local drive based on the client and the current project folders. Project Goals: Automate Courier Selection: Develop a way to automatically select suitable couriers from the database based on predefined criteria (...

...would need a thorough diagnosis and resolution. Additionally, I'm experiencing some uncertainty with my Google Merchant Center listings, but I'm not sure of the details. Key Responsibilities: - Diagnosing and fixing errors on my website - as the specifics of the issue are currently unknown, an analytical approach and problem solving skills will be required. - Troubleshooting and correcting any issues in my Google Merchant Center listings - this may involve identifying missing products, incorrect prices, or discrepancies in product descriptions. Ideal Skills and Experience: - Proven experience in website troubleshooting and error resolution. - A thorough understanding of Google Merchant Center and experience with product listings. - Excellent ana...

I'm currently experiencing an issue with Google Adsense on my WordPress site. I have not attempted any fixes yet. I'm looking for someone who's well-versed in this area to help me out. Key Points: - Fixing Google Adsense issue on a WordPress site - Must have experience in handling similar issues - I have access to the file manager, so you can make necessary changes Ideal Skills: - Strong understanding of Google Adsense and how it interacts with WordPress - Experience in resolving issues - Proficient in using WordPress file manager Please reach out if you think you can help.

I'm seeking an expert in Google Sheets to help me create a functional document geared towards tracking paint and repair tasks, and cleaning schedules across a busy summer camp campus. This sheet will be regularly updated by our facility maintenance team. The ideal candidate should: - Have substantial experience in creating dynamic and user-friendly Google Sheets. - Understand logistics and scheduling in a maintenance setting. Key features of the Sheet should include: - A system for recording painting/repair locations. - Fields for indicating the type of paint or repair needed. - An integrated cleaning schedule that doesn't disrupt ongoing summer camp activities. - A remark section to note if the cleaning crew has cleaned, dusted and removed furniture from the area...

I am looking for a skilled Google Ads expert to help me run an effective campaign. - Ideal candidate will have expertise in all areas of Google Ads: Search, Display, and Video Campaigns. - The primary goal of this campaign is to increase website traffic. - The target audience for these campaigns is yet to be determined. The successful candidate should be able to provide insights on the target audience and develop a strategy that can effectively drive traffic to my website. You should be able to propose a campaign that can provide measurable results. The ideal candidate should have a proven track record of managing successful Google Ads campaigns, ideally for clients with similar goals.

Please develop a Python script to retrieve restaurant data from Google Maps using the Maps/Places API. The script should specifically target restaurants that have a phone number but *without* a website. The inputs I need to enter are: - Location (latitude and longitude) - Search Radius (meters) - Restaurant Type (including catch all types in the "Food and Drink" category) Key Data to Retrieve, output in a .CSV: - Name - Address - Phone Number - Google Maps URL Ideal skillset: - Proficient in Python - Strong experience with Google Maps/Places API - Ability to deliver results promptly and efficiently - Attention to detail to ensure accurate data retrieval

I'm in need of a developer familiar with Google Maps API to create an interactive map feature for my website. This map should allow users to enter their street address. Once done, it should show an aerial image of their house and give an estimate of the square footage of the landscape without structures. Key requirements: - Users should be able to directly input their street address on the website to obtain the aerial image and square footage estimate. - The map should be interactive, but only for viewing purposes. No advanced interactions like drawing or area selection are needed. Ideal skills and experience: - Proficient in Google Maps API and integrating it into websites. - Experience in developing interactive elements on websites. - Strong unde...

I'm seeking a seasoned Google AdWords specialist to help increase the traffic to my e-commerce website. Key Points: - I'm looking to drive more visitors to my site, helping to establish a broader online presence. - I am open to a strategy that will increase both quality and quantity of traffic to the site. - While the project primarily focuses on increasing website traffic, I'm also open to suggestions that can help boost conversions. Skills & Experience: - Strong expertise in Google AdWords and PPC campaigns with a proven track record of success. - Prior experience working with e-commerce businesses is a big plus. - Excellent knowledge of driving website traffic and understanding of e-commerce dynamics. - A creative and analytical approach to optimizing...

I'm in need of a skilled and experienced developer that can assist me in automating several tasks, organizing files and data on Google Drive using Google App Script and Java programming language. Key Tasks: - Create scripts to automate Folders and files - Improve file organization and management on Google Drive - Develop custom solutions using Java Ideal Skills: - Proficient in Google App Script and Java - Strong background in automating tasks - Proven experience in organizing and managing files - Prior experience with Google Drive is a plus Your expertise and knowledge in these areas are crucial for the success of this project. Looking forward to collaborating with a proactive and skilled developer.

Please Sign Up or Login to see details.

Hi, I'm Courtney Cunningham from Ride Candy. I'm looking for a proficient web developer to help enhance our website's Slingshot rental return process. - **Interactive Elements**: I require a chatbot for customer support, an interactive map for locating rental return locations, and an animated slider for showcasing our Slingshot models. These elements will make our site more dynamic and customer-friendly. - **UI Improvements**: I'm open to your suggestions on how to improve the user interface. This could involve optimizing the navigation menu, ensuring consistent branding elements throughout the website, and enhancing the overall visual design and aesthetics. - **SEO Optimization**: While I haven't provided specific requirements for SEO, any suggestions or...

...Windows platform. Ideal Skills & Experience: - Proficiency in Desktop Application Development - Strong MySQL and Database Monitoring Skills - Experience with WYSIWYG Template Management - Previous experience in PDF generation applications - Knowledge of Windows Application Development Additional Notes: a. application will need to determine which template to use based on a query b. Must be able to create, edit templates in an easy wysiwyg way. c. naming convention based on db record. d. Ability to add an option password to the PDF required. e. The resulting PDF must be stored in up to 2 locations (one maybe a unc path with username and password required) f. must be able to use multipl...

I'm in need of an SEO expert who ca...search engine rankings for my 2 e-commerce sites Zen-Cart based shopping carts (both sites are pretty similar, both hosted on the same server). Key Requirements: - The website primarily consists of product listings (shopping cart) hence familiarity with e-commerce SEO is essential. - The focus of our SEO efforts will be on improving the search engine rankings to attract more organic traffic. Fix Google indexing and make sure there are no error pages. Skills and Experience: - Proven track record of improving search engine rankings for e-commerce websites. - Strong understanding of SEO principles and best practices. - Proficiency in keyword research and optimization. - Ability to work with e-commerce platforms such as Shopify or WooComm...

Seeking a skillful designer to craft an isometric map for our 2D/3D mobile game. I crave for a real-life touch, rather than cartoonish, to the graphics of our urban-themed game. Key features: - Realistic style: Your artistic expertise in creating life-like assets will be essential. - Urban environment: Understanding of city architecture and significant elements is preferred. - Map content: Your creation will involve designing detailed elements like buildings, streets, and parks to depict a comprehensive cityscape. Previous experience in game map design, particularly for mobile games, will be a considerable advantage. Proficiency in designing in both 2D and 3D is essential. Feel free to share a portfolio demonstrating your graphic design prowess in urban se...

...information: Clearing out obsolete information to keep the website current and relevant Functionality Improvements: - Edit Wordpress Astra Pro essentials Theme: Enhance the theme and improve its YOAST SEO - Layout Enhancement: Refine the layout of the website to be more user-friendly and visually appealing - Pages & Features: I have a specific set of pages (6), a video, a contact page featuring a map, and an enquiry as well as email form. The ideal candidate should have: - Proficiency in Wordpress, Astra Pro, and YOAST SEO - Experience in logo design and overall website design - Strong command of adding and curating website content - An eye for detail and aesthetics - Good communication skills If you believe you have the skills and experience to deliver this multi-facete...

...paper cell records from Google Take Out that need to be converted into an easily searchable and readable format. Key points: - Data formats: Both digital and paper - Required output: PDF document - Analysis: I need you to analyze the number patterns for this data, specifically looking at numbers used once versus those repeated over multiple years. This analysis should be done thoroughly and presented in a clear, easy-to-understand manner. Ideal freelancer skills and experience: - Proficient in data conversion and organization - Skilled in creating and working with PDF documents - Experience in data analysis, especially patterns and number analysis - Ability to create visual representations, such as charts and graphs - Strong attention to detail and accuracy. 1. Google...

...request a photoshoot. - **Elements:** - Name (client name or nickname) input - Location (address) input - Service type selection - Preferred date & time selection - Next button #### Photoshoot Date Selection Screen (Broker) - **Purpose:** Allow brokers to select a suitable date & photographer for the photoshoot. - **Elements:** - List of available photographers & times (sorted by distance from photographer) - Select this widget - Send request button #### Photoshoot Request Response Screen (Photographer) - **Purpose:** Allow photographers to accept or reject photoshoot requests. - **Elements:** - Photoshoot details (location, service type, time) - Accept button - Reject button #### Photoshoot Notification Screen (Broker) - **Purpose:** Notify ...

...showcases sister radio stations globally. This page should have a map with icon markers pinpointing station locations, a search feature to find stations by name or zip code, and a list of station names accompanied by location information. Map should allow zoom and going to country specific. So users can see entire map of their country with locations. Ideally we want world map to show first. I want tabs where users can switch between USA or world map. This page will go onto and can be with html 5 and css and js. Key Features: - Display of Sister Radio Stations: - An interactive map should be the centerpiece of the affiliates page, showing all sister radio station locations globally. - A static map design with clickable markers is...

I came across a minor issue on my website on Digital ocean cloud server. Refer the below error information. I need someone who can fix me immediately in an hour. Error 500 PleskExceptionDatabase DB query failed: SQLSTATE[HY000] [2002] Connection refused

As the main user of a system integrated with Google Sheets and Zapier, I'm currently grappling with some performance issues. Concretely, there's a challenge with incorrect data output from our automated data and workflow program. I'm seeking an expert to: • Conduct a thorough audit and maintenance of our data-entry automation and workflows • Identify the root cause of the inconsistent output, and provide tailored solutions • Enhance the reliability of the system overall to prevent any future issues. Presenting a solid proficiency in Google Sheets, Zapier, and workflow optimization, your skills will indeed come in handy for the successful troubleshooting, rectification and enhancement of the system. Efficiency and a keen eye to detail will prove...

A business-centric, data-oriented, and analytical mindset. Comprehensive knowledge of data science concepts and disciplines. Knowledge of enterprise information management processes and methodologies. Skills in database design, data security, and data lifecycle ...considerations. . Combinations of experience and education will be considered on a case-by-case basis. Experience in data warehousing and governance. Practical experience in enabling data usability, availability, and efficiency. Experience in data management, quality, metadata management, and modeling. Knowledge of database systems: MS SQL Server, Oracle, or another commercial RDBMS required, Snowflake, or other non-relational database desired. Knowledge of SQL. Experience with scripting languages, especially Python...

I'm in search of a Google Ads expert to help me create a campaign that's focused on generating more leads for my local car rental company. Key Requirements: - Experience with Google Ads: Proven track record of creating, optimizing, and managing successful Google Ads campaigns that have significantly increased leads for businesses. - Understanding of Local Audience: Ability to target and engage with local customers effectively. - Knowledge of the Car Rental Industry: It would be a great advantage if you have worked with car rental companies before or have a good understanding of the industry. The goal of this project is to increase the number of potential customers who show interest in renting our cars and eventually convert into actual bookings. The campaig...

I'm looking for an expert in Microsoft Power Apps to develop...the gathering and insertion of information into a database. Requirements: - Incorporate text inputs, dropdown menus, and date fields for gathering information. - The preferred database language is Microsoft SQL Server but SharePoint can be used as an alternative. Additional Information: - You don't need to worry about any additional features or functionalities. The main goal is to develop a basic, yet effective form for data collection. Ideal candidates should have experience in: - Microsoft Power Apps development. - Integrating Power Apps with databases, specifically Microsoft SQL Server. You should be comfortable working independently and be able to deliver a high-quality, functional solution w...

My primary focus is boosting product sales and traffic through Google Ads. Key requirements for this project are: - Strong skills in setting up and managing Google Ads campaigns. I'm keen on hiring someone who can optimize these adverts to maximize sales. - Experience with On-page SEO is essential. I'm looking at improving the visibility and performance of my website through effective on-page SEO techniques. - Understanding of e-commerce businesses. My main objective is to increase product sales, so having a background in similar projects or e-commerce businesses will be beneficial. A freelancer with a proven track record in improving sales using Google Ads and strong On-page SEO skills will be the perfect fit for this job.