Spatial SQL: Code Reference

5.4 Charecters

5.10

select
    spc_common,
    nta_name, health
from
    nyc_2015_tree_census
limit
    5

5.11

select
    spc_common || ' - ' || health as joined
from
    nyc_2015_tree_census
limit
    5

5.12

select
    concat(spc_common, ' - ', health)
from
    nyc_2015_tree_census
limit
    5

5.13

select
    spc_common,
    left(spc_common, 5) as left,
    right(spc_common, 3) as right
from
    nyc_2015_tree_census
limit
    5

5.14

select
    spc_common,
    initcap(spc_common) as titlecase,
    upper(spc_common) as uppercase,
    lower(spc_common) as lowercase
from
    nyc_2015_tree_census
limit
    5

5.15

select
    spc_common,
    replace(spc_common, 'locust', ' locust') as new_text
from
    nyc_2015_tree_census
limit
    5

5.16

select
    spc_common,
    reverse(spc_common) as backwards
from
    nyc_2015_tree_census
limit
    5

5.17

select
    spc_common,
    length(spc_common) as how_long
from
    nyc_2015_tree_census
limit
    5

5.18

select
    spc_common,
    split_part(spc_common, ' ', 2) as tree_group
from
    nyc_2015_tree_census
limit
    5

5.19

select
	spc_common,
	split_part(
		replace(spc_common, 'locust', ' locust'),
		' ',
		2
	) as tree_group
from
	nyc_2015_tree_census
limit
	5