class PlanetOsmWays(models.Model):
id = models.BigIntegerField(primary_key=True)
nodes = ArrayField(models.BigIntegerField()) # May not be right...
# May not be right...
tags = ArrayField(models.TextField(blank=True, null=True))
class Meta:
managed = False
db_table = 'planet_osm_ways'
class BasinThiruv02012020(models.Model):
gid = models.AutoField(primary_key=True)
id = models.BigIntegerField(blank=True, null=True)
gridcode = models.BigIntegerField(blank=True, null=True)
geom = models.MultiPolygonField(blank=True, null=True)
class Meta:
managed = False
db_table = 'basin_thiruv_02_01_2020'
class TvmWatershed4326(models.Model):
gid = models.AutoField(primary_key=True)
id = models.BigIntegerField(blank=True, null=True)
gridcode = models.BigIntegerField(blank=True, null=True)
geom = models.MultiPolygonField(blank=True, null=True)
class Meta:
managed = False
db_table = 'tvm_watershed_4326'
class Taxon(models.Model):
name = models.CharField(verbose_name=_("Scientific name"), max_length=100)
vernacular_name = models.CharField(verbose_name=_("Vernacular name"),
max_length=100,
blank=True)
inaturalist_push_taxon_id = models.BigIntegerField(
null=True,
blank=True,
help_text="When pushing an observation to iNaturalist, we'll "
"use this taxon_id")
inaturalist_pull_taxon_ids = ArrayField(
models.BigIntegerField(),
blank=True,
null=True,
help_text=
"When pulling observations from iNaturalist, reconcile according "
"to those IDs.")
# Don't use @staticmethod, Django can't serialize this and this is painful to debug.
def get_file_path(filename):
"""
This function is no longer used, but we have to keep it to avoid breaking our migrations
(in particular, this function is used in 0001_initial.py)
"""
return os.path.join('taxon_identification_pictures/',
make_unique_filename(filename))
@property
def inat_pictures_link(self):
return f'https://www.inaturalist.org/taxa/{self.inaturalist_push_taxon_id}/browse_photos?quality_grade=research'
def __str__(self):
return self.name
def to_json(self):
identification_picture_indiv_url = None
if self.identification_picture_individual:
identification_picture_indiv_url = self.identification_picture_individual.url
identification_picture_nest_url = None
if self.identification_picture_nest:
identification_picture_nest_url = self.identification_picture_nest.url
return {
'id': self.pk,
'name': self.name,
'identification_priority': self.identification_priority,
'identification_picture_individual_url':
identification_picture_indiv_url,
'identification_picture_nest_url': identification_picture_nest_url
}
class Meta:
verbose_name_plural = "taxa"
class Parcels(models.Model):
id = models.BigIntegerField()
geom = models.MultiPolygonField(srid=3857, blank=True, null=True)
plot_no = models.BigIntegerField(primary_key=True)
owner = models.CharField(max_length=50, blank=True, null=True),
zone = models.CharField("Parcel Zone", max_length=50, default="Zone A")
class Meta:
managed = False
db_table = 'parcels'
class FeatureGates(models.Model):
gid = models.AutoField(primary_key=True)
id = models.BigIntegerField(blank=True, null=True)
name = models.CharField(max_length=80, blank=True, null=True)
sec_person = models.BigIntegerField(blank=True, null=True)
geom = models.PointField(blank=True, null=True)
class Meta:
managed = False
db_table = 'feature_gates'
class FeatureRds(models.Model):
gid = models.AutoField(primary_key=True)
objectid = models.BigIntegerField(blank=True, null=True)
shape_leng = models.DecimalField(max_digits=65535,
decimal_places=65535,
blank=True,
null=True)
lntype = models.BigIntegerField(blank=True, null=True)
leftln_fid = models.BigIntegerField(blank=True, null=True)
rightln_fi = models.BigIntegerField(blank=True, null=True)
surface = models.CharField(max_length=254, blank=True, null=True)
walk_speed = models.BigIntegerField(blank=True, null=True)
cycle_spee = models.BigIntegerField(blank=True, null=True)
distance = models.DecimalField(max_digits=65535,
decimal_places=65535,
blank=True,
null=True)
way = models.BigIntegerField(blank=True, null=True)
type = models.CharField(max_length=254, blank=True, null=True)
id = models.BigIntegerField(blank=True, null=True)
drive_spee = models.BigIntegerField(blank=True, null=True)
geom = models.MultiLineStringField(blank=True, null=True)
class Meta:
managed = False
db_table = 'feature_rds'
class Province(models.Model):
id_0 = models.BigIntegerField()
iso = models.CharField(max_length=3)
name_0 = models.CharField(max_length=75)
id_1 = models.BigIntegerField()
name_1 = models.CharField(max_length=75)
type_1 = models.CharField(max_length=50)
engtype_1 = models.CharField(max_length=50)
nl_name_1 = models.CharField(max_length=50)
varname_1 = models.CharField(max_length=150)
geom = models.MultiPolygonField(srid=4326)
class CensusTract(models.Model): statefp = models.CharField(max_length=2) countyfp = models.CharField(max_length=3) tractce = models.CharField(max_length=6) affgeoid = models.CharField(max_length=20) geoid = models.CharField(max_length=11) name = models.CharField(max_length=100) lsad = models.CharField(max_length=2) aland = models.BigIntegerField() awater = models.BigIntegerField() geom = models.MultiPolygonField(srid=4269)
class Patient(models.Model):
status_choice = (('M', 'Medication'), ('T', 'Breach'))
referral_choice = (('HS', 'Hospital'), ('DR', 'Doctor'), ('S', 'Self'))
death_choice = (('HM', 'Home'), ('HS', 'Hospital'))
cancer_stage = (
(1, 'Stage 1'),
(2, 'Stage 2'),
(3, 'Stage 3'),
(4, 'Stage 4'),
)
cancer_choices = (
('B', 'Breast'),
('C', 'Cervix'),
('O', 'Oesophagus'),
('P', 'Prostate'),
('R', 'Rectum'),
('L', 'Lung'),
('OT', 'Others'),
)
# gender_choice =(
# ('M','Male'),
# ('F','Female'),
# )
# NHIF number
gid = models.AutoField(primary_key=True)
location = models.CharField(max_length=254, blank=True, null=True)
cancer_typ = models.CharField(max_length=254, blank=True, null=True)
year = models.BigIntegerField(blank=True, null=True)
const_nam = models.CharField(max_length=50, blank=True, null=True)
county_nam = models.CharField(max_length=50, blank=True, null=True)
nhif = models.CharField(max_length=254, blank=True, null=True)
gender = models.CharField(max_length=30)
cancer_sta = models.BigIntegerField(blank=True, null=True)
age = models.BigIntegerField(blank=True, null=True)
status = models.CharField(max_length=3, choices=status_choice)
home_visit = models.BigIntegerField(blank=True, null=True)
referral = models.CharField(max_length=3, choices=referral_choice)
chemothera = models.BigIntegerField(blank=True, null=True)
firstvisit = models.DateField(blank=True, null=True)
phone_numb = models.CharField(max_length=100, blank=True, null=True)
geom = models.PointField(blank=True, null=True)
class Meta:
managed = False
db_table = 'patient'
def __str__(self):
return self.location
class ProvinceBorder(models.Model):
name = models.CharField(max_length=24)
popname = models.CharField(max_length=24)
code = models.CharField(max_length=12)
type = models.BigIntegerField()
display = models.BigIntegerField()
x = models.FloatField()
y = models.FloatField()
py = models.CharField(max_length=50)
geom = models.PolygonField(srid=4326)
reg_id = models.ForeignKey("RegCode", to_field="reg_id", on_delete="SET_NULL")
class Consulta(models.Model):
id = models.IntegerField(primary_key=True)
cpf_cnpj = models.TextField(blank=True, null=True)
geom = models.GeometryField(srid=0, blank=True, null=True)
nome_empresa = models.TextField(blank=True, null=True)
sum = models.BigIntegerField(blank=True, null=True)
max = models.BigIntegerField(blank=True, null=True)
min = models.BigIntegerField(blank=True, null=True)
class Meta:
managed = False
db_table = 'consulta'
class Parcelsstreets(models.Model):
street_uid = models.AutoField(primary_key=True)
niscom = models.BigIntegerField(blank=True, null=True)
street_situation = models.CharField(max_length=200, blank=True, null=True)
street_translation = models.CharField(max_length=200,
blank=True,
null=True)
street_code = models.BigIntegerField(blank=True, null=True)
class Meta:
managed = False
db_table = 'parcelsstreets'
class Kvikkleire(models.Model):
skredomrid = models.BigIntegerField()
skredomrna = models.CharField(max_length=36)
arealkm2 = models.FloatField()
skredfareg = models.CharField(max_length=7)
skredskade = models.BigIntegerField()
skredrisik = models.BigIntegerField()
skredkvalk = models.BigIntegerField()
geom = models.MultiPolygonField(srid=4326)
def __str__(self):
return self.skredomrna
class Proxy(models.Model):
id = models.BigIntegerField(primary_key=True, default=None)
vd = models.OneToOneField(VD,
on_delete=models.SET_DEFAULT,
null=True,
default=None,
related_name='proxy')
guide = JSONField(blank=True,
null=True,
default=None,
db_index=True,
unique=True)
subscribers = models.ManyToManyField(VD,
through='Importer',
related_name='proxies')
started = models.BigIntegerField(blank=True, null=True, default=None)
ended = models.BigIntegerField(blank=True, null=True, default=None)
def __unicode__(self):
if self.vd:
return "%s's proxy" % unicode(self.vd)
return None
def save(self, *args, **kwargs):
if not self.vd:
raise IntegrityError('Proxy.vd must not be None')
if not self.id:
# 나중에 vd 가 바뀔 수 있으며, 이때부터 proxy.id != proxy.vd.id
self.id = self.vd.id
self.guide = convert_to_json(self.guide)
super(Proxy, self).save(*args, **kwargs)
def reload(self):
return Proxy.objects.get(id=self.id)
# TODO : priority 처리 구현
def start(self, high_priority=False):
from importer.task_wrappers import ProxyTaskWrapper
task = ProxyTaskWrapper()
r = task.delay(self.id)
# TODO : 정확한 구현인지 확인
if r.failed():
raise NotImplementedError
return r
@property
def vd_ids(self):
if self.guide and 'type' in self.guide and self.guide['type'] == 'user':
ru = RealUser.objects.get(email=self.guide['email'])
return ru.vd_ids
return [self.vd_id]
class TreeLevel(models.Model):
study = models.CharField(max_length=254,db_index=True)
lat = models.FloatField()
long = models.FloatField()
plot_id = models.BigIntegerField(db_index=True)
plotarea_m = models.BigIntegerField()
year = models.BigIntegerField(db_index=True)
full_speci = models.CharField(max_length=254,db_index=True)
tree_id = models.FloatField(db_index=True)
dbhcm = models.FloatField()
abundance = models.BigIntegerField(db_index=True)
geom = models.PointField(srid=4326,db_index=True)
class Relation_data(models.Model):
token = models.CharField(max_length=200, blank=True, null=True)
nodes_ids = ArrayField(models.BigIntegerField(), blank=True, null=True)
relations_info = ArrayField(ArrayField(
models.CharField(max_length=250, blank=True, null=True)),
blank=True,
null=True)
rels_ids = ArrayField(models.BigIntegerField(), blank=True, null=True)
ways_ids = ArrayField(models.BigIntegerField(), blank=True, null=True)
def __str__(self):
return '{} '.format(self.token)
class StateTemp(models.Model):
GEOID = models.CharField(max_length=2)
NAME = models.CharField(max_length=100)
ALAND = models.BigIntegerField()
AWATER = models.BigIntegerField()
INTPTLAT = models.CharField(max_length=11)
INTPTLON = models.CharField(max_length=12)
mpoly = models.MultiPolygonField()
def __str__(self):
return self.NAME
class River(models.Model):
cat = models.BigIntegerField()
area = models.FloatField()
up_cells = models.BigIntegerField()
discharge = models.FloatField()
width = models.FloatField()
width5 = models.FloatField()
width95 = models.FloatField()
depth = models.FloatField()
depth5 = models.FloatField()
depth95 = models.FloatField()
arcid = models.BigIntegerField()
geom = models.MultiLineStringField(srid=4326)
class Subsamples(models.Model):
subsample_id = models.BigIntegerField(primary_key=True)
version = models.IntegerField()
public_data = models.CharField(max_length=1)
sample = models.ForeignKey(Samples)
user = models.ForeignKey('Users')
grid_id = models.BigIntegerField(blank=True, null=True)
name = models.CharField(max_length=100)
subsample_type = models.ForeignKey(SubsampleType)
class Meta:
managed = False
db_table = 'subsamples'
class PlanetOsmRels(models.Model):
id = models.BigAutoField(primary_key=True)
osm_id = models.BigIntegerField()
version = models.IntegerField()
visible = models.BooleanField()
tags = HStoreField(default=dict)
timestamp = models.DateField(blank=True, null=True)
inner_members = ArrayField(models.BigIntegerField(), default=list)
outer_members = ArrayField(models.BigIntegerField(), default=list)
rel_type = models.CharField(max_length=256, blank=True, null=True)
class Meta:
db_table = "planet_osm_rels"
class Points(models.Model):
nombre = models.CharField(max_length=50, unique=True, db_index=True)
direccion = models.TextField()
horarios = models.TextField(null=True, blank=True)
celular = models.BigIntegerField(null=True, blank=True)
telefono = models.BigIntegerField(null=True, blank=True)
ciudad = models.CharField(max_length=50, null=True, blank=True)
pais = models.CharField(max_length=50, null=True, blank=True)
is_active = models.BooleanField(default=True)
point = models.PointField()
def __str__(self):
return self.nombre
class SpatialTemporalIndex(models.Model):
time_start = models.BigIntegerField(null=True)
time_end = models.BigIntegerField(null=True)
extent = models.PolygonField()
objects = models.GeoManager()
class Meta:
abstract = True
def __unicode__(self):
return '<SpatialTemporalIndex> for %s, %s, %s - %s' % (
self.indexed, self.extent.extent,
util.jdate_to_approx_iso_str(self.time_start),
util.jdate_to_approx_iso_str(self.time_end))
class House(models.Model):
gid = models.AutoField(primary_key=True)
house_type = models.CharField(max_length=50, blank=True, null=True)
area_sq_m_field = models.BigIntegerField(
db_column='area_sq_m_', blank=True,
null=True) # Field renamed because it ended with '_'.
curr_resid = models.CharField(max_length=50, blank=True, null=True)
permanent = models.CharField(max_length=50, blank=True, null=True)
plot_no = models.BigIntegerField(blank=True, null=True)
geom = models.MultiPolygonField(blank=True, null=True)
class Meta:
managed = False
db_table = 'house'
class ParcelsRc(models.Model):
parcels_rc_pk = models.BigIntegerField(primary_key=True)
propertysituationid = models.ForeignKey(Parcels,
db_column='propertysituationid',
on_delete=models.CASCADE,
related_name="rc")
order = models.IntegerField(blank=True, null=True)
polwa = models.CharField(max_length=20, blank=True, null=True)
surfacenottaxable = models.BigIntegerField(blank=True, null=True)
surfacetaxable = models.BigIntegerField(blank=True, null=True)
surfaceverif = models.CharField(max_length=2, blank=True, null=True)
soilindex = models.BigIntegerField(blank=True, null=True)
soilrent = models.CharField(max_length=10, blank=True, null=True)
cadastralincomepersurface = models.BigIntegerField(blank=True, null=True)
cadastralincomepersurfaceotherdi = models.BigIntegerField(blank=True,
null=True)
numbercadastralincome = models.BigIntegerField(blank=True, null=True)
charcadastralincome = models.CharField(max_length=4, blank=True, null=True)
cadastralincome = models.BigIntegerField(blank=True, null=True)
dateendexoneration = models.DateField(blank=True, null=True)
decrete = models.CharField(max_length=40, blank=True, null=True)
datesituation = models.DateField(blank=True, null=True)
class Meta:
managed = False
db_table = 'parcels_rc'
class PlanetOsmRels(models.Model):
id = models.BigIntegerField(primary_key=True)
way_off = models.SmallIntegerField(blank=True, null=True)
rel_off = models.SmallIntegerField(blank=True, null=True)
# May not be right...
parts = ArrayField(models.BigIntegerField(blank=True, null=True))
# May not be right...
members = ArrayField(models.TextField(blank=True, null=True))
# May not be right...
tags = ArrayField(models.TextField(blank=True, null=True))
class Meta:
managed = False
db_table = 'planet_osm_rels'
class Zip(models.Model):
ZCTA5CE = models.CharField(max_length=5)
GEOID = models.CharField(max_length=5)
CLASSFP = models.CharField(max_length=2)
MTFCC = models.CharField(max_length=5)
FUNCSTAT = models.CharField(max_length=1)
ALAND = models.BigIntegerField()
AWATER = models.BigIntegerField()
INTPTLAT = models.CharField(max_length=11)
INTPTLON = models.CharField(max_length=12)
mpoly = models.MultiPolygonField()
def __str__(self):
return 'ZIP: ' + self.ZCTA5CE + ', GEOID: ' + self.GEOID
class RailSystemWideSummary(models.Model):
arrive_quarter_hour = models.FloatField(primary_key=True)
samples = models.BigIntegerField(blank=True, null=True)
p05_seconds_late = models.FloatField(blank=True, null=True)
q1_seconds_late = models.FloatField(blank=True, null=True)
median_seconds_late = models.FloatField(blank=True, null=True)
q3_seconds_late = models.FloatField(blank=True, null=True)
p95_seconds_late = models.FloatField(blank=True, null=True)
iqr_seconds_late = models.FloatField(blank=True, null=True)
total_ons = models.BigIntegerField(blank=True, null=True)
total_offs = models.BigIntegerField(blank=True, null=True)
class Meta:
managed = False
db_table = 'rail_system_wide_summary'
class Zabytki(models.Model):
gid = models.AutoField(primary_key=True)
id = models.BigIntegerField(blank=True, null=True)
id_zabytek = models.BigIntegerField(blank=True, null=True)
nazwa = models.CharField(max_length=100, blank=True, null=True)
godziny_otwarcia = models.CharField(max_length=100, blank=True, null=True)
cena = models.CharField(max_length=100, blank=True, null=True)
adres = models.CharField(max_length=50, blank=True, null=True)
telefon = models.CharField(max_length=20, blank=True, null=True)
geom = models.PointField(srid=4326, blank=True, null=True)
typ = models.CharField(max_length=40, blank=True, null=True)
class Meta:
managed = False
db_table = 'Zabytki'
class Georeference(models.Model):
georef_id = models.BigIntegerField(primary_key=True)
title = models.TextField()
first_author = models.TextField()
second_authors = models.TextField(blank=True)
journal_name = models.TextField()
full_text = models.TextField()
reference_number = models.TextField(blank=True)
reference_id = models.BigIntegerField(null=True, blank=True)
journal_name_2 = models.TextField(blank=True)
doi = models.TextField(blank=True)
publication_year = models.TextField(blank=True)
class Meta:
# managed = False
db_table = 'georeference'
