Query sql distance google mapроботи
...domain for our web application hosted on Google Cloud Platform (GCP). The ideal candidate should have extensive experience with GCP, CI/CD pipelines, and HTTPS configuration. Scope of Work: 1. CI/CD Implementation: - Set up a CI/CD pipeline using GitHub Actions for automated testing, building, and deployment of both frontend and backend applications. - Integrate the pipeline with our GCP infrastructure, including Compute Engine, Cloud SQL, and Cloud Storage. 2. Logging Setup: - Configure logging for all services: -- Frontend (Nginx, ): Log HTTP requests, errors, and application logs. -- Backend (Gunicorn, Django): Log application errors, access logs, and system logs. -- Celery and Beat: Log task execution and periodic tasks. -- Database (Cloud SQL): Log database...
I'm in need of a seasoned Google Ads professional who can help me with both setting up new Google Ads campaigns and optimizing my existing ones. The main goal of these campaigns is to generate leads from a B2C audience. Key Requirements: - Proven experience in setting up successful Google Ads campaigns - Ability to optimize existing campaigns to improve lead generation - Strong understanding of B2C lead generation strategies - Prior experience working with both B2C and B2B audiences on Google Ads is a plus - Excellent analytical skills to monitor and improve campaign performance
I'm looking for a seasoned specialist in Google Ads, specifically skilled in generating consumer leads. The primary goal of this campaign is to effectively generate consumer leads for a business operating within the food industry. - **Objective**: Generate a significant number of consumer leads. If a consumer searches my food category, my number should show up. - **Industry**: Food. The ideal freelancer for this project would have: - Substantial experience with Google Ads. Setting up ads and fine tuning to get desired results. - A proven track record in creating successful lead generation campaigns. - Basic understanding of the food industry and its audience.
use Oracle PL SQL teach me how to install free Oracle DB on my local windows 11 acceptance: I can run your code on my computer ; all code work on my computer when I run it by myself You have 2 days you provide code to simulate input data (both code versions: python and sql)-> transactions data *****you provide SQL code to calculate per day summary for each day for each product for each store for 3 years SIMULATION data for 3 years 100 products 20 stores 5 USA states random dates and prices promotion for 30 promotions per year , each promotion happen for 7 to 15 products, for example promotion at may 10, 2023 happen for product ids: 34, 65, 12, 78, 5, 23, 41. When 34 for 20%; 65 for 30%; 12 for 40%; 78 for 10%; 5 for 15%; 23 for 70%; 41 for 30% randoml...
...). The job is to implementing the feature of Travel Route Map Creation using Leaflet and OpenStreetMap (both free, opensource). There is a tutorial here Users will be able to search a place in map, create lines of different colors from one place to another, add/tie blog posts, links and pictures with the map, dates, notes and then only map creator can download the map as Image/PDF. Leaflet free plugin is there for this. Each created map should have unique link. Creator of map can embed the map in his blog, allow/disallow download, optionally can export inside blog pdf. See one map I created for this job as example Please see the attached
Project Description: We are seeking an experienced Google Ads expert to manage and optimize multiple Google Ads accounts targeting the niche of dog owners. The selected freelancer will be responsible for managing 10 different Google Ads accounts and optimizing a total of 15 different campaigns over the course of one month. Responsibilities: Account Management: Manage and oversee 10 Google Ads accounts effectively. Campaign Optimization: Optimize a total of 15 campaigns within the dog owners niche to improve performance and ROI. Keyword Research: Conduct thorough keyword research to identify high-performing keywords relevant to the niche. Ad Copy Optimization: Continuously optimize ad copies to improve click-through rates and conversions. Bid Management: Monit...
I need an edited process map, ensuring all boxes are the same size and the fonts are consistent. Key requirements are: - **Uniform Box Size**: Make sure all the boxes in the process map have the same size and align with each other. - **Font Consistency**: Ensure the text in all boxes has the same font and size. Use Arial, Times New Roman, or any other professional business font. - **Overall Neatness and Cleanliness**: The edited map should look neat and presentable. The content of the map should not be changed, only the presentation. The key skills required for this task are attention to detail, proficiency with editing tools, and an eye for design.
We are looking for a skilled freelancer to integrate Google Customer Reviews into our Google merchant.
We are looking for 5-10 years of .Net experienced developer who can also have experienced in React and .Net based web development. Long terms multiple projects development. Using Mainly Azure SQL server database with Visual Studio .Net Core API. Graph QL and EF. Worked on Azure Key Vault, Azure Logic app, Azure function is bonus.
use Oracle PL SQL teach me how to install free Oracle DB on my local windows 11 acceptance: I can run your code on my computer ; all code work on my computer when I run it by myself You have 2 days *****you provide code to simulate input data -> transactions data *****you provide SQL code to calculate per day summary for each day for each product for each store for 3 years SIMULATION data for 3 years 100 products 20 stores 5 USA states randomly 30 to 170 transactions per day for given product for usual price randomly 200 to 600 transactions per day for given product for promotion random dates and prices promotion for 30 promotions per year , each promotion happen for 7 to 15 products, for example promotion at may 10, 2023 happen for product ids: 34, 65, 12, 78,...
As a real estate professional, I'm in need of a Certified SEM Expert with extensive experience in Google Ads to help me boost my product sales. Key Responsibilities: - Implement creative and strategic Google Ads campaigns to drive qualified leads - Optimize ad spend and conversions to ensure a high ROI - Monitor and analyze campaign performance and provide regular reports Ideal Candidate: - Proven track record in managing real estate-focused Google Ads campaigns - In-depth understanding of the real estate market - Google Ads certification - Strong analytical and problem-solving skills - Excellent communication and reporting abilities Please include examples of your past work in your proposal, particularly those that have led to an increase in sales for r...
...letters 2: Letter Quality ( Paper weight, Sizes, Cost per letter etc configuration in JSON array) What we need -------------------- - Standalone PHP Script where we will be able to select an item from provided JSON. - Through DHL API we will validate the provided addresses(in the form of exel or csv) if each individual address is valid - or we should be able to select the areas of over choice over google map is shown in the provided video - this funcationaly is also provided over DHL api I think. and there demographic filters can also be applied which are provided be DHL api also shown in the video Please apply only if you the the required experience. these links may help
I am looking for an expert in Google Ads to manage a campaign aimed at boosting sales nationally. The campaign's primary goal is to increase the sales of our medium-priced products, ranging between $50 to $200. The ideal candidate for the job should: - Be a Google Ads certified professional - Have a demonstrable track record in running successful sales campaigns, preferably at the national level. - Have excellent knowledge of Google Ads strategies and algorithms to target the right customers efficiently. My goal is to increase our sales significantly and ensure our ads get the best visibility and result in higher conversions. Your expertise in driving traffic and generating leads will be key to the success of this project.
...ready, and the SQL tables have been set up. The main features of this project include: - **Dashboard:** This should display data from the other 3 pages in a list format as well as in a bar chart. - **Page 1 - Callback List:** A simple list of data from the 'callback' table. - **Page 2 - Token List:** A simple list of data from the 'token' table. - **Page 3 - Name List:** A simple list of data from the 'name' table. For the dashboard, I'm looking for a clean, professional design and prefer the use of bar charts for the graphical representation of the data. User authentication should be straightforward, requiring only an email and password for access. Ideal Skills and Experience: - Proficient in Laravel - Experience in creating admin dash...
I'm seeking an experienced professional adept at developing and managing Google Ads, particularly within the realm of Display Network campaigns. Your key responsibility will be to increase website traffic to help boost our online presence. Proficiency in analyzing performance reports, monitoring bid management, and optimizing adverts for best ROI is required. To apply, please share: - Your level of expertise and knowledge with Google Display Network - Proven experience in successfully increasing website traffic through Google Ads - Certification in Google Ads will be a plus Only freelancers with extensive experience working with Google Ads are encouraged to apply.
...skilled professional to assist in our Google Ads marketing campaign with the primary goal of generating leads at a national level. Key Requirements: - Experience in designing and implementing Google Ads campaigns focused on lead generation - Ability to target national audiences effectively - Proven track record of delivering on lead generation targets - Experience in the Healthcare industry (preferred but not mandatory) Your tasks will include: - Setting up the campaign to focus on lead generation - Designing highly effective ad copy and visuals - Continuously monitoring and optimizing the campaign to maximize lead generation - Providing regular reports on campaign performance If you have a proven record of helping businesses generate leads through Google Ads, p...
I am searching for an expert with a depth of understanding in developing autonomous navigation for mobile robots using Deep Reinforcement Learning (DRL) and LIDAR data. Here are the project goals: - Real-time mapping and localization: The robot needs to be able to understand its environment in real-time by creating and updating a map of its surroundings. - Obstacle avoidance and path planning: It should be proficient in navigational decision-making to identify and avoid obstructions while effectively charting out its path. - Efficient navigation and movement: The robot should operate smoothly and proficiently, with minimal redundancies and maximum efficiency in its paths. Moreover, I'll provide a guide and a base GitHub repo, but will need you to skillfully integrate and cus...
We have a project developed with VS2022, c#, datatables, SQL database, javascript and similar.... The user experience is not good. We need a professional and nice interface and user experience, but, mantain our actual code and funcionality.
I'm looking for a freelancer who can help optimize my text and image-based daily news blog for Google Discover. Key Points: - The blog is updated daily and covers news content. - The main goal is to make the content more visible on Google Discover. The ideal candidate should have a strong understanding of Google's Discover algorithm and proven experience in optimizing blogs for the platform. Familiarity with news content and SEO strategies for news websites is a big plus.
Hi, I am looking for a developer to maintain, make upgrades and fix bugs on my current website and booking system. The system has been done in SQL written in C# by my old developer. He has had a change of career and can no longer work on things but is happy to do a handover to make things easier. This will be an ongoing business relationship and not a one off thing so will need someone with good communication and accurate times of completion. Thanks, Luke.
...4, ensuring all features and functionalities remain intact. Optimize SQL Queries: Review and optimize all SQL queries to handle heavy loads efficiently. The current system experiences performance issues during peak times, and the new version should resolve these. Fix Bugs and Security Issues: Identify and fix any existing bugs and security vulnerabilities in the current project. Ensure the new version adheres to the latest security standards. API Integration: Connect the backend with the frontend using APIs. The APIs should be well-documented, secure, and efficient, allowing seamless communication between the backend and frontend. Requirements: Proven experience with CodeIgniter 3 and 4. Strong knowledge of SQL query optimization. Expertise in identifyin...
I am in need of a highly skilled developer who can create an on-demand freight application that will be available on both iOS and Android platforms. The app will offer a wide range of freight services, including local delivery, long-distance shipping, and overnight services. Key functionality: - Real-time Tracking: The app should provide a seamless real-time tracking feature to ensure customers can monitor their shipments throughout the entire process. - In-App Payment: A secure payment gateway integrated into the app is essential for facilitating smooth and hassle-free transactions for our users. - Driver Rating System: I want a driver rating system that allows customers to provide feedback on the service they received, helping us maintain high-quality services. Ideal skills and ...
Google Ads Month Management. Google AdWords PPC Services
looks like you're encountering a MySQL error related to an incorrect DATETIME value in your query. This error typically occurs when the format of the date and time being used in the query does not match the expected format in MySQL, or when an empty string is being used where a datetime value is resolve this issue, you should first check the format of the 'date_scheduled' values in your 'banners' table to ensure they are in the correct DATETIME format. You might also need to modify your query to handle cases where 'date_scheduled' might be empty or incorrectly you're not sure how to proceed or need further assistance with checking or adjusting your database, you can manage and review your MySQL databases and their tables from S...
I'm looking for a skilled PPC specialist to help me create and manage a PPC campaign on Google Ads. The primary goal of this campaign is to increase my website traffic. The task includes: - Conducting thorough research to identify the best keywords and phrases for the campaign - Crafting compelling ad copies that resonate with my target audience - Setting up and managing the campaign to ensure optimal performance - Regular monitoring and tweaking of the campaign to maximize results Ideal skills and experience for this job include: - Proven track record of successful PPC campaigns, particularly on Google Ads - Strong keyword research capabilities - Proficiency in crafting engaging ad copies - Experience in optimizing campaigns for traffic generation - Excellent analytic...
I'm in search of a knowledgeable Google Ads expert to assist me in boosting online sales for my antique store. Key Requirements: - Experience in crafting and managing Google Ads campaigns, particularly for e-commerce or antique businesses, is essential. - Proven track record of delivering increased online sales using Google Ads. - Strong understanding of how to target specific demographics, such as collectors of specific antiques. Target Audience: - My primary target audience consists of collectors of specific antiques. Geographic Targeting: - The ads will be targeted towards specific countries or regions outside my own. If you have the necessary expertise and are equipped to help me achieve my goal of increasing online sales for my antique store, please ...
...cloth designs based on an existing PSD template. The project involves: - Designing a large stand-up banner and table cloth (8ft x 4ft) - Adhering to the provided PSD template style The final deliverables should be: - High-quality and print-ready designs - Utilizing the existing template while introducing new and creative elements - Designs should be suitable for a large format and visual from a distance As I'm not familiar with the printing terminology, I'll need you to ensure the design includes what is needed for a professional print job. Ideal skills and experience for this job include: - Proficiency in Adobe Photoshop/Illustrator - Experience in large format print design - Ability to maintain a consistent style while introducing new elements - Strong communica...
...gateway WhatsApp Integration: WhatsApp Invoicing: Send invoices and order updates via WhatsApp to keep customers informed. Customer Enquiries: Enable customers to make inquiries through WhatsApp, enhancing communication and support. - **Tracking System**: Order Tracking: Monitor orders from placement to delivery, providing real-time updates. Delivery Tracking: Include a geo-location feature with map integration to track delivery drivers and shipment status. Customer Satisfaction: Monitor customer feedback and ratings for deliveries. . - **Customer Management**: A comprehensive customer management system is essential to handle orders, complaints, returns, and inquiries. - **Support System**: Ticketing System: Integrated ticket system to manage customer support queries and iss...
Hi there! I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.
I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.
As a local contractor, I'm looking for a skilled and experienced Google Ads expert to help me generate leads within our city. My target audience is homeowners, and the main focus of this campaign is to generate high-quality leads. Key Requirements: - Proven experience in running successful Google Ads campaigns - Deep understanding of lead generation techniques - Prior experience working with local businesses - A clear understanding of the homeowner market The ideal freelancer would be able to set up, monitor and optimize the campaign to ensure a steady flow of leads. A keen eye for detail and a collaborative approach to work would be highly valued.
I'm looking for a skilled professional who can meticulously guide me in video call through setting up a VPN using Google Cloud and OpenVPN. The primary aim is to ensure secure remote access to a MySQL database from my Windows laptop. Key requirements: - In-depth knowledge of Google Cloud and OpenVPN - Proven experience in configuring secure VPNs - Expertise in MySQL database security and remote access Your role will be to provide detailed, step-by-step instructions on how to properly configure the VPN to meet my security needs. Please bear in mind that I may require access to the MySQL database from multiple remote locations, but most likely will only need it running from 1 remote laptop - the VPN should be flexible enough to accommodate this added functionalit...
My website currently has an average performance in search engine rankings and I am primarily looking to enhance this on Google. I'm in need of a SEO expert who can identify and implement both On-page and Off-page techniques to improve my site's visibility and ranking. Key Requirements: - Experience in SEO: A proven track record of increasing search rankings for clients. - Google SEO Knowledge: A comprehensive understanding of Google's algorithms and best practices. - On-page & Off-page SEO Skills: Proficiency in both these areas, including content optimization, link building, and other relevant strategies. Your work will be critical in boosting our online presence and driving more organic traffic to our site.
I'm seeking an experienced SEO professional to help me rank 10 keywords on Google. Key Requirements: - On-page & Off-page SEO: You should be proficient in both to help my website achieve better visibility on Google. - Keyword Research: I have some specific keywords in mind, but I also need your expertise to identify other relevant keywords that can aid our goal of increasing website traffic. Additional Information: - The primary goal of this SEO campaign is to drive more visitors to my website. Therefore, the successful completion of this project should result in a noticeable increase in organic traffic. Ideal Skills: - Proficient in both on-page and off-page SEO - Experienced in keyword research and selection - Proven track record of increasing website traffic...
I need a script that can scrape the Google Play store specific data from list of apps in the search result url of any keyword. Need data in Excel spreadsheet. Eg : if i search cat in playstore, i need the below mentioned details of first 100 apps shown in the search result. Key Project Details: - I require the script to scrape app names, descriptions, emails, download counts, and URL of the app. - The scraped data should be compiled into an Excel spreadsheet format for my review and analysis. - deploy the script into my server The Ideal Freelancer: - Proficient in web scraping tools and techniques - Experience working with Google Play store data - Competent in automating data extraction and processing - Ability to deliver a reliable, daily scraping solution - python expe...
...for a perfect fit. 2. Messaging system: An integrated messaging system will permit players to converse, coordinate, and plan games. Experience in developing seamless communication tools is beneficial. 3. Game scheduling/calendar: A calendar feature for easy game scheduling is crucial. I expect your prowess in creating intuitive date-time functionalities to shine through here. 4. Field locator/map: Leveraging mapping APIs to find nearby playing fields will be a valuable element. The ideal candidate will have experience using mapping technologies. Finally, users should be able to sign up with their email and password. Therefore, experience in user authentication techniques is highly desired. With these in place, we'll ensure a convenient and easy-to-use platform for soccer...
...some notes ; I would like them to be able to edit them after allow users to see a list of all open jobs and be able to click on them to open them and edit as needed client management - need to be able to search existing clients or add new ones as well as view any jobs open or closed for the client. job photo uploads need to be optimized for mobile phones / tablets I would also like to add a map of the address for jobs and clients. Overall I need the interface simple and functional but looking good jquery ui perhaps. I would like the ability to email or print a pdf of the job as a nicely formatted report. We plan to add functions down the road and will plan to use the same person. this is a VERY simple inhouse version of house call pro or jobber The budget is tigh...
I need a diligent professional to create a 2D drawing of the floor plan of my house. The original plan is lost. The task includes: - Visiting my home in Waco Texas (zip code 76704) to take accurate measurements - Applying these measurements into a visually appealing floor plan. Previous experience in drafting is required, with added value if you have a background in architecture. A keen eye for detail and excellent drawing skills are crucial for this job. Quick turn around time is meeded.
I am seeking a professional who can automate various tasks between ClickUp, Zapier, Mailchimp, and Google Sheets. This will include: - Data syncing among all four applications, set to be updated daily. - Automating my email marketing process via Mailchimp. - Automating task management via ClickUp. Specific Tasks: - Automation of task creation in ClickUp. - Automation of sending out emails based on changes in task status. Skills and Experience Required: - Proven experience in working with ClickUp, Zapier, Mailchimp, and Google Sheets - Proficient in automating processes and task management - Strong data management skills - Experience in email marketing automation is an asset This automation project will help streamline my business processes, so efficiency...
Build an ISO for a raspberry pi (with cellular notecard) to scan for unique cell phones in a specific range and log the unique phone ID and timestamps/ping (distance) from the raspberry pi and store in mysql database using cellular adapter.
I'm in need of a proficient expert who can assist me with running queries on DuckDB using data originating from Amazon S3. This task primarily involves: - Interacting with semi-structured data such as XML and JSON - Processing a substantial data volume ranging from 1GB to 1TB The ideal freelancer should have the following capabilities: - Deep understanding and experience with DuckDB and Amazon S3 - Strong skills in handling and querying semi-structured data - Experience in managing and processing large volumes of data Please note: it's critical that the freelancer have experience with managing these sorts of tasks previously and has a solid understanding of large volume data manipulation.
I'm looking for a Google Ads expert who can help me create and manage a video ad campaign with the primary objectives being to enhance brand visibility and drive more traffic to my website.
I need a Google Sheets expert to help me put together an extensive and detailed cricket schedule for the upcoming English summer season. Tasks Include: - Including International, Domestic, and Club tournaments and teams in the schedule - Organizing fixtures based on the date Additional Details: - Each fixture should have comprehensive information about the venue - Match timings should be included - Broadcast details for each match should be provided Ideal Skills: - Proficiency in Google Sheets - Knowledge of cricket and its various tournaments - Attention to detail to ensure that all necessary information is included - Time management skills to complete the project in a timely manner more details--- ### Task Description: Google Sheets Data Entry Expert for Cricket ...
...QR code for every name. Drivers must be able to clock in and clock out while driving. what should parents be able to do? 1. Real time tracking of bus location on google map 2. only see data about his children. 3. see what time his/her child gets on/off and at what location 4. being given the bus in which his or her child is sitting. 5. being able to see his child's monthly report of where they got in/out and at what time. 6. which bus is suspended, why and the bus details what should the administrator be able to do? - blacklist/suspend driver - see driver speed -view route record - Real time tracking of bus location on google map - all drivers send messages push notification - all parents send messages push notification -accept/approve new driver -acce...
I'm searching for a talented graphic designer to c...create bold and vibrant t-shirt designs, with a focus on the theme of Free Palestine. The designs should cater to activists and supporters, so they should be both eye-catching and meaningful. Key Requirements: - Design Style: The designs should be bold and vibrant - Target Audience: Activists and supporters - Theme: Free Palestine Specific Imagery to Include: - Palestinian flag - Olive branches - Map of Palestine - Watermelon Ideal Skills: - Proficiency in graphic design software - Understanding of t-shirt design and printing - Experience in creating designs for activism or political causes Please include relevant samples of your previous work in your bid. I look forward to seeing your creativity and commitment to this i...
We are looking for developers who are proficient in WooCommerce and Google Sheet API to help with our ongoing project to improve some of it's functionalities and features. Key Responsibilities: - Assist in setting up WooCommerce functionalities on a website, including product catalog, shopping cart, and payment gateway integration. - Implement integration with Google Sheet API for specific data processing & syncing requirements. Ideal Candidate: - Proficient in WooCommerce, including setting up product catalog, shopping cart, and payment gateway integration. - Experienced in integrating external APIs, specifically Google Sheet API, App Scripts Programming. - A good understanding of data processing and how to leverage Google Sheet for such purposes. T...
I'm seeking an adept professional to develop a cross-platform app for real estate. Available on iOS, Android, and Web, the app's functionalities must include: - Pr...registration/login: Smooth user registration and login process. - Agent registration/login: Smooth Agent registration and login process. - Property listing details: Detailed information showcased for each property listing on Map. - Contact agent/owner: Messaging feature facilitates communication between users and property agents/owners. Ideal candidates will have a proven mobile and web app development track record, preferably in real estate. Proficiency in implementing the aforementioned functionalities and features is critical. Note: The properties and land must also be visualized on the Map. I...
I need historical stock prices and income statement data, deliver python script to collect this data for an arbitrary stock from google finance.
Hello, This is a $20 project. Looking for a freelancer to develop a python script to retrieve restaurant data from Google Maps using the Maps/Places API. The script should target restaurants that have a phone number and *do not* have a website. The inputs I need to enter are: - Location (latitude and longitude) - Search Radius (in meters) - Ensure the business/place is a restaurant, bakery, etc. Key Data to Retrieve, output in a .CSV: - Business Name - Address - Phone Number - Google Maps URL Thank you, trooper501
