-- Name: _locationnarrative_is_cultivated(text); Type: FUNCTION; Schema: public; Owner: -

--

CREATE FUNCTION _locationnarrative_is_cultivated(locationnarrative text) RETURNS boolean

    LANGUAGE sql IMMUTABLE STRICT

    AS $_$

SELECT

    $1 LIKE '%cultivated%'

OR  $1 LIKE '%cultivad%'

OR  $1 LIKE '%ornamental%'

OR  $1 LIKE '%garden%'

OR  $1 LIKE '%jardin%'

OR  $1 LIKE '%jard?n%'

OR  $1 LIKE '%jardim%'

OR  $1 LIKE '%plantation%'

OR  $1 LIKE '%plantacion%'

OR  $1 LIKE '%plantaci?n%'

OR  $1 LIKE '%universit%'

OR  $1 LIKE '%universidad%'

OR  $1 LIKE '%campus%' 

OR  $1 LIKE '%urban%'

OR  $1 LIKE '%greenhouse%'

OR  $1 LIKE '%arboretum%'

OR  $1 LIKE '%farm%'

OR  $1 LIKE '%weed%'

OR  $1 LIKE '%corn field%'

$_$;

--