Project

General

Profile

« Previous | Next » 

Revision 11842

Added by Aaron Marcuse-Kubitza over 11 years ago

inputs/CVS/cvs.~.clean_up.sql: remove plot.realLatitude/realLongitude, since this is private data that should not be publicly visible

View differences:

inputs/CVS/plot_/header.csv
1 
PLOT_ID,authorPlotCode,reference_ID,PARENT_ID,plotObsolete,REPLACEMENTPLOT_ID,realLatitude,realLongitude,locationAccuracy,confidentialityStatus,confidentialityFieldsBlocked,confidentialityReason,latitude,longitude,authorCoordinateType,authorCoordinateUnits,authorE,authorN,authorZone,authorDatum,authorLocation,locationNarrative,plotRationaleNarrative,azimuth,dsgpoly,shape,area,standSize,placementMethod,permanence,layoutNarrative,elevation,elevationAccuracy,elevationRange,slopeAspect,minSlopeAspect,maxSlopeAspect,slopeGradient,minSlopeGradient,maxSlopeGradient,topoPosition,landform,surficialDeposits,rockType,county,cust_cvs_province,stateProvince,COUNTRY,dateentered,submitter_surname,submitter_givenname,submitter_email,accessionCode,notesPublic,notesMgt,revisions,cust_eep_reach,dba_src_ID,continent,area|country|territory,region|state|province,county_,quadrangle,Geographic Name,River Basin
1 
PLOT_ID,authorPlotCode,reference_ID,PARENT_ID,plotObsolete,REPLACEMENTPLOT_ID,locationAccuracy,confidentialityStatus,confidentialityFieldsBlocked,confidentialityReason,latitude,longitude,authorCoordinateType,authorCoordinateUnits,authorE,authorN,authorZone,authorDatum,authorLocation,locationNarrative,plotRationaleNarrative,azimuth,dsgpoly,shape,area,standSize,placementMethod,permanence,layoutNarrative,elevation,elevationAccuracy,elevationRange,slopeAspect,minSlopeAspect,maxSlopeAspect,slopeGradient,minSlopeGradient,maxSlopeGradient,topoPosition,landform,surficialDeposits,rockType,county,cust_cvs_province,stateProvince,COUNTRY,dateentered,submitter_surname,submitter_givenname,submitter_email,accessionCode,notesPublic,notesMgt,revisions,cust_eep_reach,dba_src_ID,continent,area|country|territory,region|state|province,county_,quadrangle,Geographic Name,River Basin
inputs/CVS/plot_/map.csv
5 5 
PARENT_ID,UNUSED#PARENT_ID,,
6 6 
plotObsolete,*plot_--plotObsolete,,
7 7 
REPLACEMENTPLOT_ID,*plot_--REPLACEMENTPLOT_ID,,
8 
realLatitude,UNUSED#realLatitude,,
9 
realLongitude,UNUSED#realLongitude,,
10 8 
locationAccuracy,coordinateUncertaintyInMeters__from_coords,,"assuming units are the same as VegBank's corresponding field (""within this many meters of the reported location"", http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=plot&entity=dba_tabledescription&where=where_tablename&params=plot#locationAccuracy)"
11 9 
confidentialityStatus,accessRights_verbatim,,
12 10 
confidentialityFieldsBlocked,*plot_--confidentialityFieldsBlocked,,

Also available in: Unified diff