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'