{"id":3706,"date":"2023-05-22T14:20:29","date_gmt":"2023-05-22T12:20:29","guid":{"rendered":"https:\/\/usemaps.net\/new-tool-in-usemaps-sql-based-selection\/"},"modified":"2023-05-22T14:20:29","modified_gmt":"2023-05-22T12:20:29","slug":"new-tool-in-usemaps-sql-based-selection","status":"publish","type":"post","link":"https:\/\/usemaps.com\/en\/new-tool-in-usemaps-sql-based-selection\/","title":{"rendered":"New tool in Usemaps: SQL-based selection"},"content":{"rendered":"<p>We strive to make Usemaps easy to implement. We want users to be able to learn how to use the system freely in just a few hours. This requires us to create intuitive tools (we&#8217;re trying our best \ud83d\ude42  <\/p>\n<p>For some time now, the \u201cSQL Query\u201d extension has been available, which extends the object selection tools with the ability to enter any SQL query (including all PostGIS functions). This makes it possible to select objects based on spatial and attribute relationships of all data in the System. <\/p>\n<p>For more convenient use, queries can be saved (added to favorites).<\/p>\n<p>This allows you to query, for example, plots that are within a 2000m buffer from the main power supply point and expand queries with additional conditions.<\/p>\n<p>The tool is intended for advanced users who find it more convenient to use spatial SQL than to click through the results \u201cmanually.\u201d<\/p>\n<p>&nbsp;<\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter wp-image-3702 size-full\" style=\"border-radius: 1rem;\" src=\"https:\/\/usemaps.com\/wp-content\/uploads\/2025\/11\/sql.gif\" alt=\"\" width=\"942\" height=\"480\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>We strive to make Usemaps easy to implement. We want users to be able to learn how to use the system freely in just a few hours. This requires us to create intuitive tools (we&#8217;re trying our best \ud83d\ude42 For some time now, the \u201cSQL Query\u201d extension has been available, which extends the object selection [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[35],"tags":[],"class_list":["post-3706","post","type-post","status-publish","format-standard","hentry","category-blog"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>New tool in Usemaps: SQL-based selection - Usemaps<\/title>\n<meta name=\"description\" content=\"We strive to make Usemaps easy to implement. We want users to be able to learn how to use the system freely in just a few hours. This requires us to\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/usemaps.com\/nowe-narzedzie-w-usemaps-selekcja-na-podstawie-sql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"New tool in Usemaps: SQL-based selection - Usemaps\" \/>\n<meta property=\"og:description\" content=\"We strive to make Usemaps easy to implement. We want users to be able to learn how to use the system freely in just a few hours. This requires us to\" \/>\n<meta property=\"og:url\" content=\"https:\/\/usemaps.com\/nowe-narzedzie-w-usemaps-selekcja-na-podstawie-sql\/\" \/>\n<meta property=\"og:site_name\" content=\"Usemaps\" \/>\n<meta property=\"article:published_time\" content=\"2023-05-22T12:20:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/usemaps.com\/wp-content\/uploads\/2025\/11\/sql.gif\" \/>\n<meta name=\"author\" content=\"WK\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"WK\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/usemaps.com\\\/nowe-narzedzie-w-usemaps-selekcja-na-podstawie-sql\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/usemaps.com\\\/nowe-narzedzie-w-usemaps-selekcja-na-podstawie-sql\\\/\"},\"author\":{\"name\":\"WK\",\"@id\":\"https:\\\/\\\/usemaps.com\\\/#\\\/schema\\\/person\\\/a95d3d2ad15a5b4aed8479292b0ee5fe\"},\"headline\":\"New tool in Usemaps: SQL-based selection\",\"datePublished\":\"2023-05-22T12:20:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/usemaps.com\\\/nowe-narzedzie-w-usemaps-selekcja-na-podstawie-sql\\\/\"},\"wordCount\":154,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/usemaps.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/usemaps.com\\\/nowe-narzedzie-w-usemaps-selekcja-na-podstawie-sql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/usemaps.com\\\/wp-content\\\/uploads\\\/2025\\\/11\\\/sql.gif\",\"articleSection\":[\"Blog\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/usemaps.com\\\/nowe-narzedzie-w-usemaps-selekcja-na-podstawie-sql\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/usemaps.com\\\/nowe-narzedzie-w-usemaps-selekcja-na-podstawie-sql\\\/\",\"url\":\"https:\\\/\\\/usemaps.com\\\/nowe-narzedzie-w-usemaps-selekcja-na-podstawie-sql\\\/\",\"name\":\"New tool in Usemaps: SQL-based selection - Usemaps\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/usemaps.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/usemaps.com\\\/nowe-narzedzie-w-usemaps-selekcja-na-podstawie-sql\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/usemaps.com\\\/nowe-narzedzie-w-usemaps-selekcja-na-podstawie-sql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/usemaps.com\\\/wp-content\\\/uploads\\\/2025\\\/11\\\/sql.gif\",\"datePublished\":\"2023-05-22T12:20:29+00:00\",\"description\":\"We strive to make Usemaps easy to implement. We want users to be able to learn how to use the system freely in just a few hours. This requires us to\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/usemaps.com\\\/nowe-narzedzie-w-usemaps-selekcja-na-podstawie-sql\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/usemaps.com\\\/nowe-narzedzie-w-usemaps-selekcja-na-podstawie-sql\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/usemaps.com\\\/nowe-narzedzie-w-usemaps-selekcja-na-podstawie-sql\\\/#primaryimage\",\"url\":\"https:\\\/\\\/usemaps.com\\\/wp-content\\\/uploads\\\/2025\\\/11\\\/sql.gif\",\"contentUrl\":\"https:\\\/\\\/usemaps.com\\\/wp-content\\\/uploads\\\/2025\\\/11\\\/sql.gif\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/usemaps.com\\\/nowe-narzedzie-w-usemaps-selekcja-na-podstawie-sql\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/usemaps.com\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"New tool in Usemaps: SQL-based selection\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/usemaps.com\\\/#website\",\"url\":\"https:\\\/\\\/usemaps.com\\\/\",\"name\":\"Usemaps\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/usemaps.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/usemaps.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/usemaps.com\\\/#organization\",\"name\":\"Usemaps\",\"url\":\"https:\\\/\\\/usemaps.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/usemaps.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/usemaps.com\\\/wp-content\\\/uploads\\\/2025\\\/10\\\/brand.svg\",\"contentUrl\":\"https:\\\/\\\/usemaps.com\\\/wp-content\\\/uploads\\\/2025\\\/10\\\/brand.svg\",\"width\":182,\"height\":38,\"caption\":\"Usemaps\"},\"image\":{\"@id\":\"https:\\\/\\\/usemaps.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/usemaps.com\\\/#\\\/schema\\\/person\\\/a95d3d2ad15a5b4aed8479292b0ee5fe\",\"name\":\"WK\",\"url\":\"https:\\\/\\\/usemaps.com\\\/en\\\/author\\\/wk\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"New tool in Usemaps: SQL-based selection - Usemaps","description":"We strive to make Usemaps easy to implement. We want users to be able to learn how to use the system freely in just a few hours. This requires us to","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/usemaps.com\/nowe-narzedzie-w-usemaps-selekcja-na-podstawie-sql\/","og_locale":"en_US","og_type":"article","og_title":"New tool in Usemaps: SQL-based selection - Usemaps","og_description":"We strive to make Usemaps easy to implement. We want users to be able to learn how to use the system freely in just a few hours. This requires us to","og_url":"https:\/\/usemaps.com\/nowe-narzedzie-w-usemaps-selekcja-na-podstawie-sql\/","og_site_name":"Usemaps","article_published_time":"2023-05-22T12:20:29+00:00","og_image":[{"url":"https:\/\/usemaps.com\/wp-content\/uploads\/2025\/11\/sql.gif","type":"","width":"","height":""}],"author":"WK","twitter_card":"summary_large_image","twitter_misc":{"Written by":"WK","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/usemaps.com\/nowe-narzedzie-w-usemaps-selekcja-na-podstawie-sql\/#article","isPartOf":{"@id":"https:\/\/usemaps.com\/nowe-narzedzie-w-usemaps-selekcja-na-podstawie-sql\/"},"author":{"name":"WK","@id":"https:\/\/usemaps.com\/#\/schema\/person\/a95d3d2ad15a5b4aed8479292b0ee5fe"},"headline":"New tool in Usemaps: SQL-based selection","datePublished":"2023-05-22T12:20:29+00:00","mainEntityOfPage":{"@id":"https:\/\/usemaps.com\/nowe-narzedzie-w-usemaps-selekcja-na-podstawie-sql\/"},"wordCount":154,"commentCount":0,"publisher":{"@id":"https:\/\/usemaps.com\/#organization"},"image":{"@id":"https:\/\/usemaps.com\/nowe-narzedzie-w-usemaps-selekcja-na-podstawie-sql\/#primaryimage"},"thumbnailUrl":"https:\/\/usemaps.com\/wp-content\/uploads\/2025\/11\/sql.gif","articleSection":["Blog"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/usemaps.com\/nowe-narzedzie-w-usemaps-selekcja-na-podstawie-sql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/usemaps.com\/nowe-narzedzie-w-usemaps-selekcja-na-podstawie-sql\/","url":"https:\/\/usemaps.com\/nowe-narzedzie-w-usemaps-selekcja-na-podstawie-sql\/","name":"New tool in Usemaps: SQL-based selection - Usemaps","isPartOf":{"@id":"https:\/\/usemaps.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/usemaps.com\/nowe-narzedzie-w-usemaps-selekcja-na-podstawie-sql\/#primaryimage"},"image":{"@id":"https:\/\/usemaps.com\/nowe-narzedzie-w-usemaps-selekcja-na-podstawie-sql\/#primaryimage"},"thumbnailUrl":"https:\/\/usemaps.com\/wp-content\/uploads\/2025\/11\/sql.gif","datePublished":"2023-05-22T12:20:29+00:00","description":"We strive to make Usemaps easy to implement. We want users to be able to learn how to use the system freely in just a few hours. This requires us to","breadcrumb":{"@id":"https:\/\/usemaps.com\/nowe-narzedzie-w-usemaps-selekcja-na-podstawie-sql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/usemaps.com\/nowe-narzedzie-w-usemaps-selekcja-na-podstawie-sql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/usemaps.com\/nowe-narzedzie-w-usemaps-selekcja-na-podstawie-sql\/#primaryimage","url":"https:\/\/usemaps.com\/wp-content\/uploads\/2025\/11\/sql.gif","contentUrl":"https:\/\/usemaps.com\/wp-content\/uploads\/2025\/11\/sql.gif"},{"@type":"BreadcrumbList","@id":"https:\/\/usemaps.com\/nowe-narzedzie-w-usemaps-selekcja-na-podstawie-sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/usemaps.com\/en\/"},{"@type":"ListItem","position":2,"name":"New tool in Usemaps: SQL-based selection"}]},{"@type":"WebSite","@id":"https:\/\/usemaps.com\/#website","url":"https:\/\/usemaps.com\/","name":"Usemaps","description":"","publisher":{"@id":"https:\/\/usemaps.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/usemaps.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/usemaps.com\/#organization","name":"Usemaps","url":"https:\/\/usemaps.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/usemaps.com\/#\/schema\/logo\/image\/","url":"https:\/\/usemaps.com\/wp-content\/uploads\/2025\/10\/brand.svg","contentUrl":"https:\/\/usemaps.com\/wp-content\/uploads\/2025\/10\/brand.svg","width":182,"height":38,"caption":"Usemaps"},"image":{"@id":"https:\/\/usemaps.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/usemaps.com\/#\/schema\/person\/a95d3d2ad15a5b4aed8479292b0ee5fe","name":"WK","url":"https:\/\/usemaps.com\/en\/author\/wk\/"}]}},"_links":{"self":[{"href":"https:\/\/usemaps.com\/en\/wp-json\/wp\/v2\/posts\/3706","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/usemaps.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/usemaps.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/usemaps.com\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/usemaps.com\/en\/wp-json\/wp\/v2\/comments?post=3706"}],"version-history":[{"count":0,"href":"https:\/\/usemaps.com\/en\/wp-json\/wp\/v2\/posts\/3706\/revisions"}],"wp:attachment":[{"href":"https:\/\/usemaps.com\/en\/wp-json\/wp\/v2\/media?parent=3706"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/usemaps.com\/en\/wp-json\/wp\/v2\/categories?post=3706"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/usemaps.com\/en\/wp-json\/wp\/v2\/tags?post=3706"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}