6,505 reputation
1816
bio website
location
age
visits member for 1 year, 10 months
seen 2 hours ago

9h
comment input range (0-2) values as a integer
Questions about changes to tenets of relational database design in SQL databases are off-topic here
1d
comment input range (0-2) values as a integer
This is a database design issue. You are storing your data incorrectly to do numeric queries. You must change to using TWO columns (lo and hi). Keeping the text flavor is optional, but it is not possible to avoid adding columns.
1d
comment Searching for an algorithm to filter Geo Data
Please edit this question to contain more specific information about the kind of filtering you want to perform. GIS SE is not a research service, and this question may not pass muster as a legitimate question, since there isn't one right answer.
1d
revised Searching for an algorithm to filter Geo Data
removed greeting and redundant signature
1d
revised Why value relation doesn't work when I delete and connect reference layer?
removed thanks
1d
comment Reprojecting in Postgis
The error likely comes from trying to change the geometry SRID in situ (can't have multiple SRIDs in the same table). Your procedure is very risky. You need a different table.
1d
comment input range (0-2) values as a integer
Not really a GIS question, but it sounds like you want to be modelling this with rangeLo and rangeHi columns and a compound query.
1d
comment Reprojecting in Postgis
I would expect a CREATE TABLE foo AS SELECT ...,ST_Transform (...) geom in order to project an existing table without corruping metadata.
1d
comment MS SQL table with geometry field to feature class
Please edit the question to: explain why you aren't using the geometry column in a Query Layer, clarify how you can have "no geodatabase" and add a simple feature class to the connection, include what you meant in the deleted comment about multiple projections, and make this question ask a single question, as per GIS SE policy.
2d
comment When creating any map, what four basic elements should you include?
@MichaelMiles-Stimson Like Slartibartfast? And if you're into memorizing lists, there's this
2d
comment When creating any map, what four basic elements should you include?
The little diagram of a monster with an italicized "Here there be dragons" was always de rigueur when I was learning cartography.
2d
revised Using the Make Query Table for Querying a Many-to-Many relationship
removed thanks
2d
comment Finding a substring within a table of data between 2 string positions in PostgreSQL
Questions about database administration are off-topic here unless they relate directly to Geographical Information Systems, but they can be asked on Database Administrators.
2d
revised Finding a substring within a table of data between 2 string positions in PostgreSQL
removed thanks
2d
comment Duplicate Points
You still need to edit the question to include enough information about the table name and geometry column name, and your initial attempt at a self-join query
2d
revised Duplicate Points
repositioned image
2d
comment Duplicate Points
Please edit the question to show what you have tried so far. It might help to explain why you want this, in case your intended solution isn't the best one.
2d
comment find all the null records for all fields in a shape file
Shapefiles, based as they are on dBase-III+, don't support the concept of numeric nulls. Please edit the question to include the GIS software in use.
2d
revised How to fix the error between two coordinate systems?
removed greeting/thanks
Jul
1
revised Looking to find (or build) a particular Python geoprocessing tool
removed thanks