Robot | Path | Permission |
GoogleBot | / | ✔ |
BingBot | / | ✔ |
BaiduSpider | / | ✔ |
YandexBot | / | ✔ |
User-agent: * Disallow: /404 Disallow: /404/ Disallow: /cdn-cgi/ Sitemap: |
Title | Jonathon |
Description | Blog Twitter GitHub Jonathon Bolster web developer, programmer, geek Converting locations from Degree Minutes Seconds to decimal value 19 March 2015 I rec |
Keywords | N/A |
WebSite | bolsterweb.com |
Host IP | 104.21.50.9 |
Location | United States |
Site | Rank |
US$1,365
Last updated: 2023-05-14 21:47:53
bolsterweb.com has Semrush global rank of 0. bolsterweb.com has an estimated worth of US$ 1,365, based on its estimated Ads revenue. bolsterweb.com receives approximately 157 unique visitors each day. Its web server is located in United States, with IP address 104.21.50.9. According to SiteAdvisor, bolsterweb.com is safe to visit. |
Purchase/Sale Value | US$1,365 |
Daily Ads Revenue | US$1 |
Monthly Ads Revenue | US$37 |
Yearly Ads Revenue | US$453 |
Daily Unique Visitors | 10 |
Note: All traffic and earnings values are estimates. |
Host | Type | TTL | Data |
bolsterweb.com. | A | 300 | IP: 104.21.50.9 |
bolsterweb.com. | A | 300 | IP: 172.67.198.181 |
bolsterweb.com. | AAAA | 300 | IPV6: 2606:4700:3034::6815:3209 |
bolsterweb.com. | AAAA | 300 | IPV6: 2606:4700:3032::ac43:c6b5 |
bolsterweb.com. | NS | 86400 | NS Record: arch.ns.cloudflare.com. |
bolsterweb.com. | NS | 86400 | NS Record: fay.ns.cloudflare.com. |
bolsterweb.com. | MX | 300 | MX Record: 10 alt4.aspmx.l.google.com. |
bolsterweb.com. | MX | 300 | MX Record: 5 alt1.aspmx.l.google.com. |
bolsterweb.com. | MX | 300 | MX Record: 5 alt2.aspmx.l.google.com. |
bolsterweb.com. | MX | 300 | MX Record: 1 aspmx.l.google.com. |
bolsterweb.com. | MX | 300 | MX Record: 10 alt3.aspmx.l.google.com. |
bolsterweb.com. | TXT | 3600 | TXT Record: MS=DBA3EC661AE3A647A06144E689ADA4D0C5697212 |
Blog Twitter GitHub Jonathon Bolster web developer, programmer, geek Converting locations from Degree Minutes Seconds to decimal value 19 March 2015 I recently had to create a SQL function to convert latitudes and longitudes from one format to another. The source fields were varchar for each latitude and longitude value held in the format DD MM SS (degrees / minutes / seconds, separated by a space). This needed to be saved into a decimal format. For clarity’s sake, there’s a lot of DECLARE statements: IF OBJECT_ID ( N ’dbo.fnConvertDMSToDecimal’ , N ’FN’ ) IS NOT NULL DROP FUNCTION fnConvertDMSToDecimal ; GO CREATE FUNCTION fnConvertDMSToDecimal ( @ dms varchar ( max )) RETURNS decimal ( 18 , 16 ) BEGIN DECLARE @ firstSpaceLocation int = CHARINDEX ( ’ ’ , @ dms , 1 ) DECLARE @ secondSpaceLocation int = CHARINDEX ( ’ ’ , @ dms , @ firstSpaceLocation + 1 ) DECLARE @ degrees decimal ( 18 , 15 ) = CAST ( SUBSTRING ( @ dms , 1 , @ firstSpaceLocation - 1 ) as real ) DECLARE @ minutes |
HTTP/1.1 301 Moved Permanently Date: Fri, 24 Dec 2021 02:10:06 GMT Connection: keep-alive Cache-Control: max-age=3600 Expires: Fri, 24 Dec 2021 03:10:06 GMT Location: https://bolsterweb.com/ Report-To: {"endpoints":[{"url":"https:\/\/a.nel.cloudflare.com\/report\/v3?s=1dxfGRg%2BLT%2BW94LnKvZkgfMAaYgh5QHBAZ5AggwgwRljsCZI%2FY0Ge5tcNbjrvC66qjg79Pa1qEU3K8Fu9v6mY%2Fn72VRbdD5TAyyMV4q6%2BdlnXNlSD4aqbpE6iCqt0dWQyQ%3D%3D"}],"group":"cf-nel","max_age":604800} NEL: {"success_fraction":0,"report_to":"cf-nel","max_age":604800} Server: cloudflare CF-RAY: 6c264a97ec01f001-EWR alt-svc: h3=":443"; ma=86400, h3-29=":443"; ma=86400, h3-28=":443"; ma=86400, h3-27=":443"; ma=86400 HTTP/2 301 date: Fri, 24 Dec 2021 02:10:06 GMT location: https://jbolster.com/ cache-control: max-age=3600 expires: Fri, 24 Dec 2021 03:10:06 GMT expect-ct: max-age=604800, report-uri="https://report-uri.cloudflare.com/cdn-cgi/beacon/expect-ct" report-to: {"endpoints":[{"url":"https:\/\/a.nel.cloudflare.com\/report\/v3?s=j7E7XkDnlJsU2t4wZrSAsjMpyr%2FI4lFn7iSrEBROiFMIAg54XSlAjjBCA74rRvLcBT3DDJZd49UaefdFgN9jh8mBhK6o2qYqOAUI%2BY%2BApsTaoQjbr72ooGlt4ayUC4%2FjEg%3D%3D"}],"group":"cf-nel","max_age":604800} nel: {"success_fraction":0,"report_to":"cf-nel","max_age":604800} server: cloudflare cf-ray: 6c264a983ee517e9-EWR alt-svc: h3=":443"; ma=86400, h3-29=":443"; ma=86400, h3-28=":443"; ma=86400, h3-27=":443"; ma=86400 HTTP/2 200 date: Fri, 24 Dec 2021 02:10:07 GMT content-type: text/html cache-control: public, must-revalidate, max-age=30 vary: Accept-Encoding strict-transport-security: max-age=10886400; includeSubDomains; preload referrer-policy: same-origin x-content-type-options: nosniff x-xss-protection: 1; mode=block x-dns-prefetch-control: off cf-cache-status: DYNAMIC expect-ct: max-age=604800, report-uri="https://report-uri.cloudflare.com/cdn-cgi/beacon/expect-ct" report-to: {"endpoints":[{"url":"https:\/\/a.nel.cloudflare.com\/report\/v3?s=aD%2FVt97fn8eO0A6kAMU1VqEKYjZ4C%2FEYmrxcdhbKUI%2F2etWoiyy2lZwTfJAeK4qwJWP8JyjISqY5wOyU%2BJJQyy%2BOzRedz3SEdP7ZJ5Nurbs7a37A4KKeWJrkvDJ1TxM%3D"}],"group":"cf-nel","max_age":604800} nel: {"success_fraction":0,"report_to":"cf-nel","max_age":604800} server: cloudflare cf-ray: 6c264a989b398c0f-EWR alt-svc: h3=":443"; ma=86400, h3-29=":443"; ma=86400, h3-28=":443"; ma=86400, h3-27=":443"; ma=86400 |
Domain Name: BOLSTERWEB.COM Registry Domain ID: 85425032_DOMAIN_COM-VRSN Registrar WHOIS Server: whois.cloudflare.com Registrar URL: http://www.cloudflare.com Updated Date: 2021-03-10T20:04:03Z Creation Date: 2002-04-09T19:40:19Z Registry Expiry Date: 2022-04-09T19:40:19Z Registrar: CloudFlare, Inc. Registrar IANA ID: 1910 Domain Status: clientTransferProhibited https://icann.org/epp#clientTransferProhibited Name Server: ARCH.NS.CLOUDFLARE.COM Name Server: FAY.NS.CLOUDFLARE.COM DNSSEC: unsigned >>> Last update of whois database: 2021-12-27T08:08:59Z <<< |