NINAnor NOFA issues - Githubissues

NINAnor / NOFA

Docs for the NOFA database

GNU General Public License v3.0

1 stars 0 forks source link

issues

Newest

Newest Most commented Recently updated Oldest Least commented Least recently updated

Update vatnlnr

#53 ninsbl opened 6 years ago
0
Add indices on FK columns

#52 ninsbl opened 7 years ago
0
What about nofa.l_rettighetshaver

#51 ninsbl opened 7 years ago
0
presence ranges - end date

#50 JakobMiksch opened 7 years ago
0
R-function: "Distance to closest fish population" might break

#49 JakobMiksch opened 7 years ago
0
Perimeter Precision

#48 JakobMiksch opened 7 years ago
2
OpenStreetMap Licence

#47 JakobMiksch opened 7 years ago
0
Add Row Level Security on event and occurrence table

#46 ninsbl opened 7 years ago
0
PIKE

#45 andersfi opened 7 years ago
0
change occurrence.fieldNumber from character varying(50) to character varying(250)

#44 andersfi closed 7 years ago
1
add minimumDepthInMeters and maximumDepthInMeters to event table

#43 andersfi closed 7 years ago
1
Rename "match_lake_within_treshold()" function

#42 JakobMiksch closed 7 years ago
0
Missing Indexes on event and occurrence

#41 JakobMiksch closed 7 years ago
2
threshold - wrong spelling

#40 JakobMiksch closed 7 years ago
1
Do we need MATCH FULL?

#39 JakobMiksch closed 7 years ago
3
event."locationID" and occurrence."eventID" NOT NULL

#38 JakobMiksch closed 7 years ago
9
create trigger for attributes of location table

#37 andersfi opened 7 years ago
0
improve match_lake function

#36 andersfi opened 7 years ago
4
Wiki: Explain how to escape quotes in SQL string

#35 JakobMiksch closed 7 years ago
1
2 similar constraints on "event"."datasetID"

#34 JakobMiksch closed 7 years ago
1
2 occurrences without Event

#33 JakobMiksch closed 7 years ago
2
Update NOFA to latest PostGIS version

#32 JakobMiksch closed 7 years ago
3
Link lake.gid to location.waterBodyID with constraint

#31 JakobMiksch closed 7 years ago
3
Comments on (materialized) views

#30 JakobMiksch opened 7 years ago
0
location environment characteristic

#29 andersfi opened 7 years ago
2
Remove redundant location points

#28 JakobMiksch opened 7 years ago
0
Simplify views

#27 JakobMiksch closed 7 years ago
2
typo in nofa.dwc_a_eventcore_emof

#26 JakobMiksch closed 7 years ago
1
run pgAdmin4 as web application on server

#25 JakobMiksch closed 7 years ago
1
Clean up import script folder

#24 JakobMiksch closed 7 years ago
1
Log Table for data INSERT and UPDATE

#23 JakobMiksch opened 7 years ago
1
delete table nofa.l_taxonomicCoverage

#22 andersfi closed 7 years ago
2
add description of l_samplingProtocol to wiki

#21 andersfi closed 7 years ago
0
adding road distance to next village

#20 JakobMiksch opened 7 years ago
2
Count of lakes with fish observation per county

#19 JakobMiksch closed 7 years ago
7
Use pgRouting for connectivity analysis

#18 JakobMiksch closed 7 years ago
2
create occurrence views

#17 andersfi opened 7 years ago
2
batch update establishmentMeans

#16 andersfi closed 7 years ago
2
add basisOfRecord field to occurrence table

#15 andersfi opened 7 years ago
3
Update NOFA with constraints

#14 andersfi closed 7 years ago
1
Update visualization of DB schema

#13 JakobMiksch closed 7 years ago
0
link between location and waterbody table

#12 andersfi closed 7 years ago
4
Make all Foreign keys ON UPDATE CASCADE

#11 ninsbl closed 7 years ago
3
Syncronise NOFA taxon list with GBIF / Artsdatabanken

#10 ninsbl opened 7 years ago
3
add lookup tables for replacing organismQuantityID

#9 ninsbl closed 7 years ago
2
Dropping the occurrence_check constraint

#8 mdsnor closed 7 years ago
3
License

#7 hanna-kaisalakka closed 7 years ago
1
date and year fields in m_reference

#6 mdsnor opened 7 years ago
5
l_taxon should be revised

#5 andersfi closed 7 years ago
7
Reduant terms

#4 andersfi closed 7 years ago
0