Sql stored procedure zipcode distance jobs
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 need a skilled designer for my brand LOGO & BROCHURE GRAPHICS DESIGN . I only have lit...can only supply the TEXT CONTENT & PHOTOS but all are with my project consultant, but the logo and brochure will be designed by you and the due date for the project is 20 of next month 2024. The company name is RANDAL FURNITURE INC and is based on importing and exporting of furniture. That is all i can provide from my end and I need a more perfect and Creative job?. HERE ARE THE DETAILS AND PROCEDURE OF THE JOB: 1) MY WEBSITE IS UNDER CONSTRUCTION WHICH WOULD BE REGISTER VERY SOON 2) I DON'T HAVE LOGO BUT NEED A CUSTOMIZED LOGO FROM YOU 3) I COULD ONLY SUPPLY THE TEXT CONTENT AND PHOTO AND ...
I'm in need of a highly skilled developer to create an admin dashboard for an e-commerce site. This will involve managing callback values for various e-commerce events such as sales, cancellations, and renewals. These values need to be stored in a MySQL database. Additionally, email notifications need to be sent to both the admin and users, triggered by specific e-commerce events. Key Requirements: - Develop an admin dashboard for managing callback values - Utilize a MySQL database for storing the callback values - Implement a system for automated email notifications upon e-commerce event triggers Skills & Experience: - Strong proficiency in MySQL - Extensive experience in e-commerce site development - Proficient in creating admin dashboards - Skilled in implementing aut...
I'm seeking an experienced patent expert who is adept at filing in the United States to assist me with a process invention. Despite conducting a preliminary search suggesting it's a novel procedure, your expertise will be vital in cross-verifying this and guiding me through the entire patenting process. Key requirements: - Strong familiarity with US patent law - Experience with process-related patents - Proficiency in patent search to confirm the novelty of the invention - Timely and effective communication skills An ideal candidate will have previous experience in filing process-related patents, adept in patent search, and knowledgeable in US patent laws. Demonstrated capability to manage deadlines while maintaining high-quality work will be highly appreciated.
Description: We are seeking a skilled freelancer to integrate social media login functionality into our WordPress web...utilizing the PeepSo theme with integrated plugins. The task involves creating developer accounts, obtaining API access, and remotely installing keys and APIs. Please note that admin access will not be provided; all installation must be performed remotely. Deliverables: - Developer accounts created & validated on selected social media platforms. - API access keys and tokens securely generated and stored. - Integrated social media login functionality on the WordPress website. Additional Information: The freelancer will be required to have expertise in WordPress development, PHP, and API integration. Familiarity with PeepSo theme and social media login APIs...
...PHP programming: The ideal candidate should have experience with Cora PHP programming, specifically related to integrating website content with Facebook. - Facebook page sharing: The articles should be shared only on my business page, ensuring they reach my target audience. Your duties will include: - Developing the automation process: You'll be responsible for creating a seamless, automatic procedure that shares the articles to my business Facebook page as soon as they're uploaded to my website. - Testing and debugging: After setting up the automation, you will need to test it thoroughly to ensure it works as intended. Any issues that arise will need to be identified and resolved promptly. This is a crucial project for me, as I am aiming to maintain a consistent onli...
...of the shipment. Courier Selection: The logistician identifies 3 or 4 potential couriers from a database 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. Project Goals: Automate Courier Selection: Develop a way to automatically select suitable couriers from the database based on predefined criteria (distance, size, location). Automate Communication: Automate the process of contacting couriers via Outlook, includ...
We have a laravel web API for a native mobile frontend. We need some fixes completed. Our code is stored on bitbucket currently.
Please Sign Up or Login to see details.
I need a desktop application that can carefully monitor a MySQL database on my Windows system. The app should be able to perform the followi...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 multiple tables in the DB, All joins will be provided. e. PDF will have a custom header / footer and pagination p...
I r...account. - Bypass Google's second verification: My Gmail account is currently secure with two-step SMS verification. However, the difficulty is that I don't possess access to the phone where the verification code is sent via SMS. Thus, I need assistance in circumventing this verification to recover my Gmail account. - Remote data wipe: Since my phone has been stolen, I wish to delete all data stored on it remotely. I'm looking for a professional with understanding in Google’s verification systems and proficient knowledge in remotely wiping data from an Android device. Privacy and accuracy are paramount in this task along with a swift completion. Your previous experience in cyber security would be appreciated in ensuring a smooth recovery and data deletio...
...of functionalities to: - Add new contacts - Update existing contact information - Track sales performance Ideal freelancers should have substantial experience in CRM database development, with knowledge of implementing web-based solutions. Familiarity with training or course-based entities would be a bonus. Your expertise ought to allow seamless additions, updates, and performance tracking of stored information. Demonstrable success in similar projects will be advantageous. I value clean, user-friendly interfaces that can handle the detailed tasks required. Be ready to suggest the best platforms for a web-based CRM as this is vital for the project's success. The system should be secure, reliable and designed for ease-of-use for non-technical personnel. If you have a trac...
...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 ...
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 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...
I need a simple webpage to display high scores for my clicking game. The game is mostly written in .JS files and the data is stored locally as "cookies". I would like the highscores to be saved as records in a database called "Highscores". Key Requirements: - Create a simple webpage that displays high scores from the game - Integrate the highscore system with the locally stored data - Match the design of the highscore page to the existing game's design Additional Information: - I'm not sure if I need user authentication to submit scores, please provide advice on this - I would like the highscore page to have a design that matches the game's aesthetic - this includes font, color schemes, and layout. Ideal Freelancer: - Proficient in Java...
...backend server can use a framework Spring Boot (for Java) to process the uploaded images. Image Processing and Data Extraction On the server, you can use OCR (Optical Character Recognition) technology to recognize and extract data from images. Libraries like Tesseract OCR (available for Python, JavaScript, and other languages) can be useful for this task. Data Storage The extracted data can then be stored in a MYSQL database. Data Synchronization with the Computer The data can be immediately available on a computer via the web application or a specialized desktop application. Real-time synchronization can be achieved using technologies like WebSockets. Security and Authentication It is important to ensure the security of the application by using HTTPS protocol, user authenticatio...
...assist with creating interactive dashboards and generating data visualizations. The selected expert will be expected to work with data from both Excel spreadsheets and SQL databases, so experience with these sources is crucial. I will be looking for an advanced level of expertise, as the job will involve complex data modeling and designing sophisticated, interactive visual reports. A strong understanding of data analysis and visualization techniques is essential. Key responsibilities and qualifications include: - Creating interactive dashboards - Generating data visualizations - Working with data from Excel spreadsheets and SQL databases - Demonstrable advanced level of Power BI experience - Advanced knowledge of data modeling - Proficient in designing sophisticated, in...
I'm in need of an experienced SQL Server data warehouse designer to help with a project of integrating and consolidating data from different sources. Key requirements: - Expertise in SQL Server: You should be able to design, implement and optimize data warehouse solutions on SQL Server. Understanding data warehouse design principles is essential. - Data Integration: You'll need to work with some of our developers / power users to source data and establish automated integration; experience with integrating relational databases and APIs from web services is crucial. - Data Consolidation: You should be able to create a cohesive, consolidated dataset from these different sources applying appropriate design principles. - Medium-sized project: The data needing in...
...setup -> deploy our existing project to a new VPS using gitlab 2) Woocommerce -> continue long term development work on our existing custom plugin. Transfer the existing production woocommerce to this staging server. 3) ongoing long term development of our CRM app Other components of our stack which are a HUGE ADDED BENEFIT if you can work on them -> .NET ASP, WEB API + MS SQL DETAILS HERE -> PRIORITY IS TO HAVE A DEVELOPER ON OUR TEAM (LONG TERM) THAT CAN FOR NOW ALSO WORK WEEKENDS AS WE HAVE SEVERAL EMERGENCIES TO FINISH URGENTLY. Someone who can efficiently manage Linux VPS and efficiently use GITLAB is critical. Initially we need part of the hours to be worked in the first weeks from 8:00PM- 2:00am UTC -3 (Brazil Time) later you can work on
...gitlab and code in ., .NET ASP, WEB API + MS SQL. We also have woocommerce and have developed and will continue to develop plugins, so PHP and understanding of woocommerce plugins is a plus but not a necessity. Prerequisites: For the long term project the *STARTING* wage will be as stated below. 1) Accept initial hourly rate of U$5.00 2) If awarded, accept and start work IMMEDIATELY 3) Have MINIMUM OF 20+ hours a week for long term ongoing support and development. 4) Work hours: predominantly 20:00 to 02:00 (UTC -3 Brazil TIME) 5) Be available to work on weekends. Our projects use: GITLAB so you need to be proficient and be able to use our existing pipelines and also create your own. Our stack: , ag-grid, C#, .NET API, MS SQL 2017 , WooCommerce digital product s...
Hi, I want a video editor who can edit according to my given instructions. PROCEDURE: I will send you trimmed video of raw footage. A document will be provided with all instructions what to add in stock footage, text animation, transitions etc. all the stock footages will all provided by me. I will provide this for both Instagram reel send YouTube video. I will also send you subtitles file for Instagram reel. You only have to follow the instructions and first send me the first draft of edited video. I will tell you the required changes in the video. After doing all the changes you have to send me the project file. The changes will be only 1 time not multiple times. REQUIREMENTS ADOBE PREMIERE PRO EXPERIENCE IN INSTAGRAM AND YOUTUBE VIDEO EDITING. TIMELY DELIVER VIDE...
Hello, We are F12Design, a platform where customers and designers come together and collaborate on graphic design projects. We would like to build an interactive dashboard to make the workflow simple and effective. Here are a few things on our mind: Languages - (Please free to suggest your own) Backend - PHP, jQuery, and SQL Frontend - HTML, CSS, and JavaScript For Real-time Demo/Example - Please sign up for and check their dashboard ########################################################## Social Login/Create account (Separate customer and Designer Login) ########################################################### Customer Dashboard Order Handling -------------- Past Orders Order Requirements (Quiz* and additional comments) Order Updates Order Delivery Date Order Tracking
...communication uses high-frequency bands, communication may become challenging depending on the device's location and surrounding environment. Therefore, this technology aims to provide a system that facilitates reliable high-frequency communication between the mobile device and the vehicle's equipment. 【2 Technology Description】 This technology relates to devices equipped with the ability to measure distance to other equipment using wireless communication, and a feature to notify users when communication is obstructed. With this technology, users can quickly understand the situation when communication disruptions occur with vehicle equipment. Please search for this technology. 【3 Reference information】 This technology pertains to devices that perform authentication pro...
...on a vehicle. Traditionally, there has been a smart system utilizing electronically authenticated keys through wireless communication with the vehicle. However, a new method using sound authentication with a device worn on the user's ear has been proposed. While this device offers a novel way to authenticate with the vehicle, using standard communication protocols allows authentication from a distance, which could lead to risks of unauthorized access by third parties. Therefore, the goal of this technology is to provide an improved vehicle control system that reduces the risk of such unauthorized manipulations.【2 Technology Description】 This technology involves a system that authenticates devices based on the user's biometric information and then provides notifications ...
I am looking for a skilled assistant to help create detailed Standard Operating Procedure (SOP) documentation from various sources, including videos, courses, summaries, structures, existing SOPs, and other materials I provide. The goal is to simplify and condense these resources into clear, easy-to-follow SOPs that anyone can understand. The final SOPs should include screenshots and other visual aids using tools like Scribehow or similar applications. Additionally, the completed SOPs must be translated into Finnish, and both English and Finnish versions should be delivered to me. Key Responsibilities: - Create comprehensive SOP documentation with step-by-step instructions. - Simplify and summarize information from videos, courses, summaries, and existing documents. - Ensure the S...
I'm searching for a professional who is proficient in SQL coding specifically for MySQL database design. PowerShell scripting or similar would also be beneficial. This is a basic level project taking existing Local government procedures and converting them into SQL based processes. An example of which would be creating a import procedure for traffic count data that is presented in a text format (example attached) Ideal Skills: - Experienced with MySQL Database Design - Well-versed in SQL coding - Ability to simplify complex instructions - PowerShell for anything not possible in SQL This project will demand creativity and intelligence to design procedures that simplify data entry processes. Please only bid if you can offer solutions according...
I am looking for a skilled assistant to help create detailed Standard Operating Procedure (SOP) documentation from various sources, including videos, courses, summaries, structures, existing SOPs, and other materials I provide. The goal is to simplify and condense these resources into clear, easy-to-follow SOPs that anyone can understand, even a child. The final SOPs should include screenshots and other visual aids using tools like Scribehow or similar applications. Additionally, the completed SOPs must be translated into Finnish, and both English and Finnish versions should be delivered to me. Key Responsibilities: - Create comprehensive SOP documentation with step-by-step instructions. - Simplify and summarize information from videos, courses, summaries, and existing documents. ...
Hi, I want a video editor who can edit according to my given instructions. PROCEDURE: I will send you trimmed video of raw footage. A document will be provided with all instructions what to add in stock footage, text animation, transitions etc. all the stock footages will all provided by me. I will provide this for both Instagram reel send YouTube video. I will also send you subtitles file for Instagram reel. You only have to follow the instructions and first send me the first draft of edited video. I will tell you the required changes in the video. After doing all the changes you have to send me the project file. The changes will be only 1 time not multiple times. REQUIREMENTS ADOBE PREMIERE PRO EXPERIENCE IN INSTAGRAM AND YOUTUBE VIDEO EDITING. TIMELY DELIVER VIDE...
...program that will retrieve an xls file from an email inbox in order to geocode the addresses present in the file via the Google Maps API and insert the geographic coordinates into an SQL table. You can follow these steps: 1. Retrieve the xls file from the mailbox - cron every hour 2. Normalize the xls file for integration into a MySQL table 3. Configure access to SQL database from JavaScript. 4. Insert data into table via SQL query 5. Retrieve addresses to be geocoded from the SQL table. 6. Use Google Maps API to geocode each address. 7. Insert the geographical coordinates (latitude and longitude) in the SQL table. Each line in the xls file corresponds to a delivery. The file has 15 columns. The column names are, in order: Shipment, Rush order, Mo...
I need assistance with scraping data from a website and delivering it in an Excel file. The specifics of the project are as follows: I am looking for a person who will conduct scraping sessions for our business on a regular basis. Desired skills are knowledge of screen-scraper software, sql, Someone with Python knowledge will be better. Willing to follow instructions. Not cramped up with other jobs or other side hustles. Need to have solid internet connection. Expected work takes 5-10 hours per week, once fully trained. Must be responsible. Able to accept PayPal. - The source of the data is a website. This means the freelancer needs to have experience in web scraping. - The data should be delivered in an Excel file. Proficiency in handling and formatting data into Excel is a mu...
Data Specialist: The Data Specialist is responsible for pr...information that is in databases, organizing and assembling the information so that teams can make decisions using data. Responsabilities: > Access database. > Create dashboards and analysis according to the demand of the business areas. > Update and automate dashboards that need frequent updating. > Provide suggestions of improvements in business areas. Requirements: > Mandarim is a must > SQL > Office Package > Database usage At Shein, we believe that diversity is the force that drives innovation. We are committed to creating an environment where all voices are heard, valued and respected. All our vacancies are inclusive for people with disabilities, women, black people, LGBTQIAPN+ com...
I need a skilled professional who's an expert in Azure Data Factory (ADF) development, SQL, Power BI, and ADF monitoring. Key Tasks: - Creating data pipelines - Building data transformation workflows - Integrating with SQL databases Power BI Usage: - Visualizing data through interactive dashboards - Creating data reports and analytics - Real-time monitoring and alerts ADF Monitoring: - Tracking data pipeline performance - Monitoring data integration processes - Setting up alerts and notifications for job failures. Ideal Skills and Experience: - Expertise in Azure Data Factory (ADF) development - Proficiency in SQL, Power BI, and data visualization - Strong background in monitoring ADF performance - Experience setting up real-time alerts and notifications - Pr...
I'm seeking an independent ASP.NET developer based in India with at least 5 years of experience, strong C# programming skills, and familiarity with SQL Server and Asp.net core. Your English skills will be crucial as direct communication with me is required. Key Responsibilities: - Develop a robust business management system leveraging ASP.NET - Implement user authentication and authorization features - Integrate appropriate APIs to enhance system functionality Ideal Candidate: - Minimum 5 years experience in ASP.NET development - Proficient in C# programming and SQL Server - Familiarity with Asp.net core - Experience in developing business management systems preferred - Strong communication skills for client call Please note that this project is only open to Indian-ba...
... The role may also involve programming. Key points: - Coaching: I need 1/1 coaching via Teams on Data Analysis & Data Visualization within Azure Analytics - Programming: If the opportunity arises, the candidate could get involved in programming using SQL - Proficiency: I consider myself at an Intermediate level with Azure Analytics Ideal Skills and Experience: - Proficient in Azure Analytics: You should have a strong understanding of Azure Analytics, specifically in Data Analysis and Data Visualization - SQL Programming: Experience with SQL is a must as you may be involved in programming for this project - Teaching or Coaching Experience: Prior experience in teaching or coaching Azure Analytics would be advantageous - Strong Communication: The ability to clear...
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...
NO AUTO BIDS - ONLY ZENDESK PRO! 'm in search of an experienced developer skilled in Zendesk API integration for a project related to airline claim forms. I will provide you parts of the template and you will a...form, calculations, API integration and ticket creations. The website should be built in Laravel or secure platform. If you know about EC261 claims it makes it way easier to choose you. You will do the following: - Create a form which is predefined through parameters and questions. - Add airline and airport database and organize the data with live search preview. - Calculations based on airport distance and claim form. - Zendesk ticket creation along with correct ticket numer and relevant information. - Multilingual form and site (Swedish and English). Need someone...
I'm in need of a skilled developer who is experienced with inventory management systems, report production, analytics, user access control, and Windows-based applications. This job involves maintenance of a warranty return tracking software, with specific attention to: -...considered a plus. The overriding purpose of this software is to track and manage warranty returns effectively. Ideally, you should have previous experience in software creation and maintenance for tracking and managing products. The purpose of this project would be Bug fixing and improvement of the software tool already existing. Required: Experience with ER Models architecture Experience with MS SQL server 2017 express as DBMS Experience with Python 3.8.3 and Tkinter GUI toolkit Experience with Powe...
...filter and rank candidates, reducing manual effort and time spent by recruiters in the initial screening process. 8. Data Security and Privacy: • Implement robust data security measures to protect user data and ensure compliance with data protection regulations such as GDPR. • Utilize encryption techniques for securing sensitive information such as user credentials, resumes, and personal data stored in the database. 8.1. Performance and Scalability: • Design the system architecture to be scalable and capable of handling a large volume of users and job listings. • Utilize cloud infrastructure services such as AWS or Azure for scalable hosting and resource provisioning. 8.1. Integration with Third-Party Services: • Integrate with third-party APIs for fu...
I need an adept SQL developer proficient in crafting SQL queries for various tables within our database. The task entails generating four queries, each encompassing approximately 20 conditions that must be met. Utilizing ChatGPT, could you assist in devising these queries?
I'm in need of an experienced SQL Server data warehouse designer to help with a project of integrating and consolidating data from different sources. Key requirements: - Expertise in SQL Server: You should be able to design, implement and optimize data warehouse solutions on SQL Server. Understanding data warehouse design principles is essential. - Data Integration: You'll need to work with some of our developers / power users to source data and establish automated integration; experience with integrating relational databases and APIs from web services is crucial. - Data Consolidation: You should be able to create a cohesive, consolidated dataset from these different sources applying appropriate design principles. - Medium-sized project: The data needing in...
Note: Budget Fix 2000INR and time line 5 Day's I have a project currently in Codeigniter 3, and I'd like it converted to Laravel 10. This pro...will require thorough understanding of both frameworks, and it's crucial that all existing features and functionalities are precisely replicated in the new version. While I don't have specific features to prioritize, I will identify specific elements as the project progresses. Skills and experience required: - Profound knowledge in Codeigniter 3 and Laravel 10 - Expertise in PHP development and SQL databases - Proven experience in similar conversion projects Note: The finalized budget for this project is 2000INR. Please only bid if you can work within this budget. The timeline for project completion can be discussed d...
...whether the lateral distance from the host vehicle to the oncoming vehicle is smaller than a specific distance. Example: The notification device has a function that determines whether there is another vehicle (crossing vehicle) other than the oncoming vehicle when the expected driving route of the other vehicle intersects with the expected route of the oncoming vehicle or the host vehicle, and prohibits the notification operation when it exists. Example: The notification device has a function that determines whether the distance from the host vehicle to the oncoming vehicle is more than a specific threshold, and if it is more than the threshold, it prohibits the notification operation. Example: The notification device has a function that determines whether the ...
I am in need of a skilled programmer to create a bot, effectively ...effectively able to filter out vehicle listings and send them directly to me on whatsapp , twillio etc (any) Key Responsibilities: - The bot should primarily use Craigslist, OfferUp, and Facebook Marketplace platforms for sourcing listings. - The bot should filter vehicle category listings exclusively. Vehicle Filtering Criteria: - Vehicle make and model - Year range - Price range - Distance Ideal Skills: - Experience with bot programming and development - Familiarity with Craigslist, OfferUp, and Facebook Marketplace APIs - Understanding of the automobile market, specifically characteristics and identifiers - Proven track record of creating bots that can quickly and effectively filter sear...
I need a skilled WordPress developer to list custom posts by closest distance to the current users address, which has been added via an ACF Google Map in the user profile. The list of posts will appear on the users profile page which is set up in Each custom post already has a latitude and longitude as post meta using ACF. I just need help with extracting the latitude and longitude from the Google map in the user profile and sorting the posts according to distance from those coordinates. Ideal Skills and Experience: - Extensive experience with WordPress custom post types and custom fields. - Proficiency with Advanced Custom Fields (ACF) Google Map integration. - Prior experience implementing distance sorting on WordPress websites. This is an urgent project so ...
...high-complexity T-SQL stored procedure used for data analysis that I need translated into PySpark code. The procedure involves advanced SQL operations, temporary tables, and dynamic SQL. It currently handles over 10GB of data. - Skills Required: - Strong understanding and experience in PySpark and T-SQL languages - Proficiency in transforming high complexity SQL scripts to PySpark - Experience with large volume data processing - Job Scope: - Understand the functionality of the existing T-SQL stored procedure - Rewrite the procedure to return the same results using PySpark - Test the new script with the provided data set The successful freelancer will assure that the new PySpark script can...
I need a custom custom GPT model in OpenAI called "GPT-Invoices". The objective of this project is to enable the GPT model to analyze invoices stored in a OneDrive folder and answer various queries related to these invoices. Once this functionality is implemented, I want to integrate it with Excel to call the GPT model directly from Excel cells and receive responses in the same cells. Project Requirements: GPT-Invoices Setup: The custom GPT "GPT-Invoices" should be able to analyze invoices stored in a OneDrive folder. The OneDrive folder will have subfolders for each month containing our company’s purchasing and selling invoices. The GPT should be capable of answering questions related to these invoices. For example: "Sum all subtotals of inv...
I seek an experienced engineer equipped with both mechanical and aeronautical skills. The mission is to create a high-quality rendering ...equipped with both mechanical and aeronautical skills. The mission is to create a high-quality rendering for an octocopter drone, intending for agricultural chemical spraying tasks. Confidentiality is paramount so signing a Non-Disclosure Agreement (NDA) will be required. KEY DETAILS: - Purpose: Agriculture chemical spraying - Payload: Accommodate 250 lbs (not including drone weight) - Flight distance: Up to 5 miles Technical drawing skills, a solid understanding of drone aerodynamics, and experience in mechanical drone development will come in handy for this project. Reach out if you find this interesting and we can delve deeper into the speci...
App Requirements - **User Management:** Account creation and login via email or Google account, admin panel for managing user accounts. - **User Profile:** Profile completion with name, photo, description, and payment information. - **Geolocation and Filters:** Find nearby services using geolocation, filter services by category, distance, etc. - **Service Posting:** Service providers can publish services with details, photos, and prices, users can view service details. - **Messaging:** Integrated messaging system for users and service providers. - **Payment System:** Secure payments for services, admin management of transactions and commissions. - **Admin Panel and Statistics:** Dashboard for managing users, services, and transactions, view usage statistics and reports. - **Testing ...
