result_read = Rread(conn) sampfeat_read = SFread(conn) # run some basic sample queries. vars = core.read.getAllVariables() print "Get all variable: ", vars people = core_read.getAllPersons() print "Get all People: ", people sfs = core_read.getAllSamplingFeatures() print "Get all SamplingFeatures: ", sfs temp = sfs[0] print temp.SamplingFeatureCode val = core.read.getSamplingFeatureByCode(temp.SamplingFeatureCode) sf = core_read.getSamplingFeatureByCode(u"logan_river_outlet") print "Get SamplingFeatures by code: ", sf # The following query shows that you can manipulate geometries within the code # I can get back a union of two geometries # and convert from a string to Geometry type if it is in WKT # Code that is being run: # Geom = self._session.query(Samplingfeature).first() # GeomText = self._session.query(func.ST_Union(Geom.FeatureGeometry,func.ST_GeomFromText(TestGeom)).ST_AsText()).first() print "\n\n------------GeometryTest--------- \n", TestGeom = "POINT (30 10)" print "Static Test Geometry:", TestGeom
dq =DQread(conn)
anno = Annoread(conn)
eq = EQread(conn)
pr = PRread(conn)
ep = EPread(conn)
ei = EIread(conn)
la = LAread(conn)
r = Rread(conn)
cv = CVread(conn)
s = Sread(conn)
#print "Get Geometry Test 1: ",cs.getGeometryTest()
print "Get all equipment: " ,eq.getAllEquipment()
print "Get all dataquality: " ,dq.getAllDataQuality()
print "Get all variable: " ,cs.getAllVariables()
print "Get all People: " ,cs.getAllPersons()#[0].PersonFirstName
print "Get all sites: " , sf.getAllSites()
print "Get all SamplingFEatures: ", cs.getAllSamplingFeatures()
print "Get SamplingFEatures by code: ",cs.getSamplingFeatureByCode("USU-LBR-Mendon")
#print "GeometryTest2: ",cs.getGeometryTest()
#factory = cs._session_factory.getSession()
#print factory.query(Samplingfeature).all()
ei = EIread(conn) la = LAread(conn) r = Rread(conn) cv = CVread(conn) s = Sread(conn) print "Get all equipment: " ,eq.getAllEquipment() print "Get all dataquality: " ,dq.getAllDataQuality() print "Get all variable: " ,cs.getAllVariables() print "Get all People: " ,cs.getAllPerson()#[0].PersonFirstName print "Get all sites: " , sf.getAllSites() print "Get all SamplingFeatures: ", cs.getAllSamplingFeature() print "Get SamplingFeatures by code: ",cs.getSamplingFeatureByCode(u'logan_river_outlet') #shows that you can manipulate geometries within the code #I can get back a union of two geometries( currently the Same Geometry), #and convert from a string to Geometry type if it is in WKT #Code that is being run #Geom = self._session.query(Samplingfeature).first() #TestGeom = "POINT (30 10)" #GeomText = self._session.query(func.ST_Union(Geom.FeatureGeometry,func.ST_GeomFromText(TestGeom)).ST_AsText()).first() print "\n\n------------GeometryTest--------- \n", print cs.getGeometryTest()
for x in allPeople:
print x.PersonFirstName + " " + x.PersonLastName
# Get all of the SamplingFeatures from the database that are Sites
siteFeatures = core_read.getSamplingFeaturesByType('Site')
numSites = len(siteFeatures)
print "\n--------------- Information about Site SamplingFeatures ------------"
print "There are " + str(
numSites
) + " Site SamplingFeatures in the ODM2 database retrieved using getSamplingFeaturesByType()."
print "The list of Site SamplingFeatures includes: "
for x in siteFeatures:
print x.SamplingFeatureCode + ": " + x.SamplingFeatureName
# Now get the SamplingFeature object for a SamplingFeature code
sf = core_read.getSamplingFeatureByCode('USU-LBR-Mendon')
print "\n-------- Information about an individual SamplingFeature ---------"
print(
"The following are some of the attributes of a SamplingFeature retrieved using getSamplingFeatureByCode(): \n"
+ "SamplingFeatureCode: " + sf.SamplingFeatureCode + "\n" +
"SamplingFeatureName: " + sf.SamplingFeatureName + "\n" +
"SamplingFeatureDescription: " + sf.SamplingFeatureDescription + "\n" +
"SamplingFeatureGeotypeCV: " + sf.SamplingFeatureGeotypeCV + "\n"
"SamplingFeatureGeometry: " + sf.FeatureGeometry + "\n" + "Elevation_m: " +
str(sf.Elevation_m))
# Drill down and get objects linked by foreign keys
print "\n------------ Foreign Key Example --------- \n",
# Call getResults, but return only the first result
firstResult = core_read.getResults()[0]
print "The FeatureAction object for the Result is: ", firstResult.FeatureActionObj
core = CoreServices(conn) result_read = Rread(conn) sampfeat_read = SFread(conn) #run some basic sample queries. vars = core.read.getAllVariables() print "Get all variable: ", vars people = core_read.getAllPersons() print "Get all People: ", people sfs = core_read.getAllSamplingFeatures() print "Get all SamplingFeatures: ", sfs temp = sfs[0] print temp.SamplingFeatureCode val = core.read.getSamplingFeatureByCode(temp.SamplingFeatureCode) sf = core_read.getSamplingFeatureByCode(u'logan_river_outlet') print "Get SamplingFeatures by code: ", sf #The following query shows that you can manipulate geometries within the code #I can get back a union of two geometries #and convert from a string to Geometry type if it is in WKT #Code that is being run: #Geom = self._session.query(Samplingfeature).first() #GeomText = self._session.query(func.ST_Union(Geom.FeatureGeometry,func.ST_GeomFromText(TestGeom)).ST_AsText()).first() print "\n\n------------GeometryTest--------- \n", TestGeom = "POINT (30 10)" print "Static Test Geometry:", TestGeom print core_read.getGeometryTest(TestGeom)
for x in allPeople:
print x.PersonFirstName + " " + x.PersonLastName
# Get all of the SamplingFeatures from the database that are Sites
siteFeatures = core_read.getSamplingFeaturesByType('Site')
numSites = len(siteFeatures)
print "\n--------------- Information about Site SamplingFeatures ------------"
print "There are " + str(numSites) + " Site SamplingFeatures in the ODM2 database retrieved using getSamplingFeaturesByType()."
print "The list of Site SamplingFeatures includes: "
for x in siteFeatures:
print x.SamplingFeatureCode + ": " + x.SamplingFeatureName
# Now get the SamplingFeature object for a SamplingFeature code
sf = core_read.getSamplingFeatureByCode('USU-LBR-Mendon')
print "\n-------- Information about an individual SamplingFeature ---------"
print ("The following are some of the attributes of a SamplingFeature retrieved using getSamplingFeatureByCode(): \n" +
"SamplingFeatureCode: " + sf.SamplingFeatureCode + "\n" +
"SamplingFeatureName: " + sf.SamplingFeatureName + "\n" +
"SamplingFeatureDescription: " + sf.SamplingFeatureDescription + "\n" +
"SamplingFeatureGeotypeCV: " + sf.SamplingFeatureGeotypeCV + "\n"
"SamplingFeatureGeometry: " + sf.FeatureGeometry + "\n" +
"Elevation_m: " + str(sf.Elevation_m))
# Drill down and get objects linked by foreign keys
print "\n------------ Foreign Key Example --------- \n",
# Call getResults, but return only the first result
firstResult = core_read.getResults()[0]
print "The FeatureAction object for the Result is: ", firstResult.FeatureActionObj
