class ChAddresses(models.Model): geom = models.MultiPointField(srid=2056, blank=True, null=True) egid = models.BigIntegerField(blank=True, null=True) edid = models.BigIntegerField(blank=True, null=True) gdekt = models.CharField(max_length=254, blank=True, null=True) gdenr = models.BigIntegerField(blank=True, null=True) gdename = models.CharField(max_length=254, blank=True, null=True) strname = models.CharField(max_length=254, blank=True, null=True) deinr = models.CharField(max_length=254, blank=True, null=True) plz4 = models.BigIntegerField(blank=True, null=True) plzz = models.BigIntegerField(blank=True, null=True) plzname = models.CharField(max_length=254, blank=True, null=True) gkode = models.DecimalField(max_digits=655351, decimal_places=3, blank=True, null=True) gkodn = models.DecimalField(max_digits=655351, decimal_places=3, blank=True, null=True) strsp = models.CharField(max_length=254, blank=True, null=True) strname_de = models.CharField(max_length=254, blank=True, null=True) class Meta: managed = False db_table = 'CH_addresses'
class MapInfo(models.Model): points = models.MultiPointField(null=True, blank=True) lines = models.MultiLineStringField(null=True, blank=True) polys = models.MultiPolygonField(null=True, blank=True) geom = CollectionFrom(points='points', lines='lines', polys='polys') objects = models.GeoManager()
class Poi(models.Model): """ Points of Interest in and around buildings """ name = models.CharField(max_length=255, null=True, blank=True) name_en = models.CharField(max_length=255, null=True, blank=True) name_de = models.CharField(max_length=255, null=True, blank=True) floor_num = models.FloatField(verbose_name=_("floor number"), null=True, blank=True) floor_name = models.CharField(verbose_name=_("floor name"), max_length=200, null=True, blank=True) description = models.CharField(verbose_name=_("description"), max_length=255, null=True, blank=True) enabled = models.BooleanField(verbose_name=_("Activated and enabled"), null=True, blank=True) floor = models.ForeignKey(BuildingFloor, on_delete=models.DO_NOTHING, null=True, blank=True) campus = models.ForeignKey(Campus, on_delete=models.DO_NOTHING, null=True, blank=True) category = models.ForeignKey(PoiCategory, on_delete=models.CASCADE) geom = gis_model.MultiPointField(srid=3857, spatial_index=True, db_column='geom', null=True, blank=True) poi_tags = ArrayField(models.CharField(max_length=50, blank=True), blank=True, null=True) @property def icon(self): if self.category.fk_poi_icon: if self.category.fk_poi_icon.icon: return self.category.fk_poi_icon.icon.url else: return "" else: return "" def __str__(self): return str(self.name) or ''
class AffordableHousing(models.Model): id = models.IntegerField(primary_key=True) name = models.CharField(max_length=50) total_unit = models.IntegerField() affordable = models.IntegerField() address = models.CharField(max_length=100) city = models.CharField(max_length=25) state = models.CharField(max_length=25) zip = models.CharField(max_length=25) concat = models.CharField(max_length=100) county = models.CharField(max_length=50) alcohol_an = models.CharField(max_length=50) developmen = models.IntegerField() elderly = models.IntegerField() ex_release = models.IntegerField() family = models.IntegerField() agricultur = models.IntegerField() homeless = models.IntegerField() physical_d = models.IntegerField() veterans = models.IntegerField() lat = models.FloatField() long = models.FloatField() geom = models.MultiPointField() class Meta: managed = False db_table = 'affordable_housing'
class Synapse(NameLookupMixin, CECIMixin, models.Model): """ Object representing a Synapse """ name = models.BigIntegerField(unique=True) experiment = models.ForeignKey(Experiment, related_name='synapses', on_delete=models.PROTECT) # Parent channel = models.ForeignKey(Channel, related_name='synapses', on_delete=models.PROTECT) # Parent neuron = models.ForeignKey(Neuron, related_name='synapses', on_delete=models.CASCADE, blank=True, null=True) partner_neuron = models.ForeignKey(Neuron, related_name='partner_synapses', on_delete=models.CASCADE, blank=True, null=True) partner_synapse = models.OneToOneField( 'self', blank=True, null=True, related_name='+', # Use partner_synapse for both partners. # No backwards relation on_delete=models.CASCADE) geometry = gis_models.MultiPointField( dim=3, srid=0, spatial_index=False) # [ GISPoint(x,y,z), ... ] keypoint = gis_models.PointField(dim=3, srid=0, spatial_index=False) # GISPoint(x,y,z) polarity = models.IntegerField(choices=Polarity.choices(), default=Polarity.unknown.value) compartment = models.FloatField()
class BaseDocumentIndex(models.Model): content_type = models.CharField(max_length=255, db_index=True) object_id = models.CharField(max_length=255) body = SearchVectorField() output_data = JSONField(null=True, blank=True) search_data = JSONField(null=True, blank=True) metadata = JSONField(null=True, blank=True) geom_point = models.MultiPointField(null=True, blank=True) geom_linestring = models.MultiLineStringField(null=True, blank=True) geom_polygon = models.MultiPolygonField(null=True, blank=True) indexing = models.BooleanField(default=False, db_index=True) objects = DocumentIndexBaseManager() objects_default = models.Manager() def get_geom(self, srid): value = self.geom_point or self.geom_linestring or self.geom_polygon if value: value.transform(srid) return json.loads(value.json) class Meta: abstract = True unique_together = ('content_type', 'object_id') index_together = [['content_type', 'indexing']] indexes = [GinIndex(fields=['body'])] def __str__(self): return '%s: %s' % (self.content_type, self.object_id)
class HealthCentre(models.Model): objectid = models.IntegerField() name = models.CharField(max_length=254) lat = models.FloatField() lon = models.FloatField() osm_id = models.FloatField() timestamp = models.CharField(max_length=20) district = models.CharField(max_length=50) county = models.CharField(max_length=50) subcounty = models.CharField(max_length=50) source = models.CharField(max_length=50) collection = models.CharField(max_length=50) collecti_1 = models.CharField(max_length=50) grade = models.CharField(max_length=50) ownership = models.CharField(max_length=50) grid_dista = models.CharField(max_length=50) hc_name = models.CharField(max_length=254) hc_type = models.CharField(max_length=254) status = models.CharField(max_length=254) x_raw = models.FloatField() y_raw = models.FloatField() dname_2006 = models.CharField(max_length=254) cname_2006 = models.CharField(max_length=254) sname_2006 = models.CharField(max_length=254) pname_2006 = models.CharField(max_length=254) dname_2010 = models.CharField(max_length=254) sname_2010 = models.CharField(max_length=254) subregion = models.CharField(max_length=254) country = models.CharField(max_length=254) x_utm = models.FloatField() y_utm200k = models.FloatField() geom = geomodels.MultiPointField(srid=32636)
class MapData(models.Model): points = models.MultiPointField(null=True, blank=True) lines = models.MultiLineStringField(null=True, blank=True) polys = models.MultiPolygonField(null=True, blank=True) geom = FlatCollectionFrom(points='points', lines='lines', polys='polys') length = models.FloatField(null=True, editable=False) page = models.OneToOneField('pages.Page') objects = models.GeoManager() def get_absolute_url(self): return reverse('maps:show', args=[self.page.pretty_slug]) def save(self, *args, **kwargs): self.length = self.geom.length super(MapData, self).save(*args, **kwargs) def exists(self): """ Returns: True if the MapData currently exists in the database. """ if MapData.objects.filter(page=self.page): return True return False
class TradingCenter(models.Model): objectid = models.IntegerField() id = models.CharField(primary_key=True,max_length=14) name = models.CharField(max_length=20) district = models.CharField(max_length=14) fid_1 = models.CharField(max_length=8) y733_field = models.CharField(max_length=8) y733_id = models.CharField(max_length=8) easting = models.FloatField() northing = models.FloatField() zone = models.CharField(max_length=10) northadj = models.FloatField() gps_update = models.CharField(max_length=11) population = models.CharField(max_length=6) household_field = models.CharField(max_length=11) power_supp = models.CharField(max_length=9) supply1 = models.CharField(max_length=9) action = models.CharField(max_length=10) if_not_tc = models.CharField(max_length=12) no = models.CharField(max_length=9) date_field = models.DateField(null=True, blank=True) area = models.CharField(max_length=9) hh = models.IntegerField() pop = models.IntegerField() ps_grid = models.CharField(max_length=9) ps_minirid = models.CharField(max_length=9) kva = models.CharField(max_length=9) hrs_day = models.CharField(max_length=9) note = models.CharField(max_length=9) n28 = models.CharField(max_length=9) latitude = models.FloatField() longitude = models.FloatField() geom = geomodels.MultiPointField(srid=4326)
class Transport(models.Model): osm_id = models.CharField(max_length=10, unique=True, db_index=True, verbose_name=_("OSM ID")) code = models.IntegerField(verbose_name=_("Code")) fclass = models.CharField(max_length=28, verbose_name=_("Object class")) name = models.CharField(max_length=100, null=True, blank=True, verbose_name=_("Object name")) geom = models.MultiPointField() created = models.DateTimeField(auto_now_add=True, verbose_name=_("Created")) updated = models.DateTimeField(auto_now=True, verbose_name=_("Updated")) deleted = models.BooleanField(default=False, verbose_name=_("Is deleted")) def __str__(self): return f"Transport({self.osm_id})" @staticmethod def mapping(): return { "osm_id": "osm_id", "code": "code", "fclass": "fclass", "name": "name", "geom": "MULTIPOINT", } class Meta: ordering = ["-id"] verbose_name = _("Transport") verbose_name_plural = _("Transports") app_label = "osm"
def get_tipo(self, tipo): """ Obtener el tipo de dato geometrico """ if tipo == Atributos.PUNTO: return models.PointField() elif tipo == Atributos.POLIGONO: return models.PolygonField() elif tipo == Atributos.POLIGONO_MULTIPLE: return models.MultiPolygonField() elif tipo == Atributos.PUNTO_MULTIPLE: return models.MultiPointField() elif tipo == Atributos.LINEA: return models.LineStringField() elif tipo == Atributos.LINEA_MULTIPLE: return models.MultiLineStringField() elif tipo == Atributos.TEXTO: return models.CharField(max_length=255) elif tipo == Atributos.ENTERO: return models.IntegerField() elif tipo == Atributos.FLOTANTE: return models.FloatField() elif tipo == Parametro.IMAGEN: return models.ImageField(upload_to="/") elif tipo == Parametro.DATE: return models.DateField() elif tipo == Parametro.DATETIME: return models.DateTimeField() else: return models.RasterField()
class Rent(models.Model): type = models.CharField(max_length=81) num = models.IntegerField() mpoint = models.MultiPointField() def __str__(self): return self.type
class Sighting(models.Model): objectid = models.IntegerField() num_animal = models.IntegerField( 'How many did you see?', ) animal_type = models.CharField( 'What kind of animal did you see?', max_length=50, choices=ANIMAL_CHOICES ) sighting_date = models.DateTimeField( 'Date of the sighting', ) additional = models.CharField( 'Additional Information', max_length=254, blank=True ) geom = models.MultiPointField( 'Location' ) objects = models.GeoManager() #return string representation of model def __unicode__(self): return self.animal_type
class MelghatHamlets23Apr(models.Model): geom = models.MultiPointField(blank=True, null=True) fid = models.IntegerField(blank=True, null=True) srno = models.DecimalField(max_digits=65535, decimal_places=65535, blank=True, null=True) field_2 = models.CharField(max_length=254, blank=True, null=True) state = models.CharField(max_length=254, blank=True, null=True) district = models.CharField(max_length=254, blank=True, null=True) block = models.CharField(max_length=254, blank=True, null=True) habitation = models.CharField(max_length=254, blank=True, null=True) facility_n = models.CharField(max_length=254, blank=True, null=True) address = models.CharField(max_length=254, blank=True, null=True) file_uploa = models.CharField(max_length=254, blank=True, null=True) facility_c = models.CharField(max_length=254, blank=True, null=True) facility_s = models.CharField(max_length=254, blank=True, null=True) lattitude = models.DecimalField(max_digits=65535, decimal_places=65535, blank=True, null=True) longitude = models.DecimalField(max_digits=65535, decimal_places=65535, blank=True, null=True) class Meta: managed = False db_table = 'melghat_hamlets_23apr'
class LINKStation(models.Model): objectid = models.BigIntegerField() name = models.CharField(max_length=80) latitude = models.FloatField() longitude = models.FloatField() field4 = models.CharField(max_length=80) geom = models.MultiPointField(srid=4326)
class Poi(models.Model): """ Points of Interest in and around buildings """ name = models.CharField(max_length=255) floor_num = models.IntegerField(verbose_name=_("floor number"), null=True, blank=True) # icon_class = models.CharField(max_length=255, blank=True, null=True) # connect to APP Buildings to enable floors for each POI per level ie floor fk_building_floor = models.ForeignKey(BuildingFloor, null=True, blank=True) fk_building = models.ForeignKey(Building, null=True, blank=True) fk_campus = models.ForeignKey(Campus) fk_poi_category = models.ForeignKey(PoiCategory) geom = gis_model.MultiPointField(srid=3857, spatial_index=True, db_column='geom', null=True, blank=True) objects = gis_model.GeoManager() tags = TaggableManager(blank=True) def __str__(self): return str(self.name) or ''
class University(models.Model): osm_id = models.CharField(max_length=80) addr_distr = models.CharField(max_length=80) addr_count = models.CharField(max_length=80) addr_subco = models.CharField(max_length=80) addr_paris = models.CharField(max_length=80) addr_villa = models.CharField(max_length=80) addr_settl = models.CharField(max_length=80) addr_zone = models.CharField(max_length=80) addr_point = models.CharField(max_length=80) addr_block = models.CharField(max_length=80) name = models.CharField(max_length=80) start_date = models.CharField(max_length=80) amenity = models.CharField(max_length=80) isced_leve = models.CharField(max_length=80) opening_ho = models.CharField(max_length=80) phone = models.CharField(max_length=80) operator = models.CharField(max_length=80) operator_t = models.CharField(max_length=80) social_fac = models.CharField(max_length=80) social_f_1 = models.CharField(max_length=80) temporary = models.CharField(max_length=80) toilets = models.CharField(max_length=80) capacity = models.CharField(max_length=80) staff_coun = models.CharField(max_length=80) generator_field = models.CharField(max_length=80) water_supp = models.CharField(max_length=80) drinking_w = models.CharField(max_length=80) fee = models.CharField(max_length=80) school_typ = models.CharField(max_length=20) geom = geomodels.MultiPointField(srid=4326) def __str__(self): return self.name
class Feature(models.Model): shapefile = models.ForeignKey(Shapefile) geom_point = models.PointField(srid=4326, blank=True, null=True) geom_multipoint = \ models.MultiPointField(srid=4326, blank=True, null=True) geom_multilinestring = \ models.MultiLineStringField(srid=4326, blank=True, null=True) geom_multipolygon = \ models.MultiPolygonField(srid=4326, blank=True, null=True) geom_geometrycollection = \ models.GeometryCollectionField(srid=4326, blank=True, null=True) objects = models.GeoManager() def __str__(self): return str(self.id) def __unicode__(self): for geom in [ self.geom_singlepoint, self.geom_multipoint, self.geom_multilinestring, self.geom_multipolygon, self.geom_geometrycollection ]: if geom != None: return str(geom) return "id " + str(self.id)
class MajorWorldCities(models.Model): city_name = models.CharField(max_length=120) cntry_name = models.CharField(max_length=120) pop_class = models.CharField(max_length=120) geom = models.MultiPointField(srid=4326) def __str__(self): return self.city_name
class CommunityActivity(models.Model): code = models.CharField(max_length=256, primary_key=True) metadata = models.OneToOneField('CommunityActivityMetaData', null=True, on_delete=models.CASCADE, to_field='code') mpoly = models.MultiPointField() gc = models.GeometryCollectionField(default=None, null=True)
class Pizzeria(geo_models.Model): hq = geo_models.PointField() directions = geo_models.LineStringField() floor_plan = geo_models.PolygonField() locations = geo_models.MultiPointField() routes = geo_models.MultiLineStringField() delivery_areas = geo_models.MultiPolygonField() all_the_things = geo_models.GeometryCollectionField()
class Ibadah(models.Model): namobj = models.CharField(max_length=50, null=True) fgsibd = models.IntegerField() remark = models.CharField(max_length=50) geom = geomodels.MultiPointField(srid=4326) def __str__(self): return self.remark
class Poi(gis_models.Model): """ Points of Interest in and around buildings """ short_name = gis_models.CharField(verbose_name=_("short name"), max_length=150, null=True, blank=True) long_name = gis_models.CharField(verbose_name=_("long name"), max_length=150, null=True, blank=True) description = gis_models.CharField(verbose_name=_("description"), max_length=255, null=True, blank=True) floor_num = gis_models.IntegerField(verbose_name=_("floor number"), null=True, blank=True) force_mid_point = gis_models.NullBooleanField( verbose_name=_("Force route to this location"), null=True, blank=True) enabled = gis_models.NullBooleanField( verbose_name=_("Activated and enabled"), null=True, blank=True) tree_order = gis_models.IntegerField( verbose_name=_("Tree order in legend"), null=True, blank=True) sort_order = gis_models.IntegerField( verbose_name=_("Sort oder of POI items"), null=True, blank=True) icon_css_name = gis_models.CharField(verbose_name=_("Icon CSS name"), max_length=255, null=True, blank=True) category_main = gis_models.ForeignKey(LtPoiCategoryMain, null=True, blank=True) category_sub = gis_models.ForeignKey(LtPoiCategorySub, null=True, blank=True) fk_access_type = gis_models.ForeignKey(LtAccessType, null=True, blank=True) fk_building_floor = gis_models.ForeignKey(BuildingFloor, null=True, blank=True) fk_building = gis_models.ForeignKey(Building, null=True, blank=True) geom = gis_models.MultiPointField(srid=3857, spatial_index=True, db_column='geom', null=True, blank=True) objects = gis_models.GeoManager() tags = TaggableManager() def __str__(self): return str(self.short_name) or ''
class ModelForGeoDjango(geomodels.Model): geometry = geomodels.GeometryField() point = geomodels.PointField() line_string = geomodels.LineStringField() polygon = geomodels.PolygonField() multi_point = geomodels.MultiPointField() multi_line_string = geomodels.MultiLineStringField() multi_polygon = geomodels.MultiPolygonField() geometry_collection = geomodels.GeometryCollectionField()
class Places(models.Model): osm_id = models.BigIntegerField() name = models.CharField(max_length=48) type = models.CharField(max_length=16) population = models.BigIntegerField() geom = gis_model.MultiPointField(srid=4326) def __str__(self): return self.name
class RoadData(): multipoint = models.MultiPointField() osm_id = models.CharField(max_length=120) def road_len(self): return len(self.multipoint) def __str__(self): return str(self.osm_id)
class Transformer_PBA(models.Model): tag = models.CharField(null=True, blank=True, max_length=15) subtypecod = models.BigIntegerField(null=True, blank=True) op_volt = models.CharField(null=True, blank=True, max_length=2) facilityid = models.CharField(null=True, blank=True, max_length=13) phasedesig = models.BigIntegerField(null=True, blank=True) ratekva = models.FloatField(null=True, blank=True) circuitcou = models.IntegerField(null=True, blank=True) configurat = models.CharField(null=True, blank=True, max_length=2) owner = models.CharField(null=True, blank=True, max_length=1) presenttap = models.CharField(null=True, blank=True, max_length=1) customerty = models.CharField(null=True, blank=True, max_length=1) loadstatus = models.IntegerField(null=True, blank=True) phasea_kva = models.FloatField(null=True, blank=True) phaseb_kva = models.FloatField(null=True, blank=True) phasec_kva = models.FloatField(null=True, blank=True) capnum = models.IntegerField(null=True, blank=True) totalkvar = models.IntegerField(null=True, blank=True) lanum = models.IntegerField(null=True, blank=True) constructi = models.CharField(null=True, blank=True, max_length=1) location = models.CharField(null=True, blank=True, max_length=50) angle = models.FloatField(null=True, blank=True) labeltext = models.CharField(null=True, blank=True, max_length=60) transforme = models.IntegerField(null=True, blank=True) installati = models.IntegerField(null=True, blank=True) creationus = models.CharField(null=True, blank=True, max_length=50) datecreate = models.DateField(null=True, blank=True) lastuser = models.CharField(null=True, blank=True, max_length=50) datemodifi = models.DateField(null=True, blank=True) feederid = models.CharField(null=True, blank=True, max_length=7) feederid2 = models.CharField(null=True, blank=True, max_length=7) feederinfo = models.BigIntegerField(null=True, blank=True) electrictr = models.BigIntegerField(null=True, blank=True) enabled = models.IntegerField(null=True, blank=True) wbs = models.CharField(null=True, blank=True, max_length=55) existingkw = models.FloatField(null=True, blank=True) existingkv = models.FloatField(null=True, blank=True) existing_1 = models.FloatField(null=True, blank=True) workreques = models.CharField(null=True, blank=True, max_length=20) designid = models.CharField(null=True, blank=True, max_length=20) worklocati = models.CharField(null=True, blank=True, max_length=20) workflowst = models.BigIntegerField(null=True, blank=True) workfuncti = models.BigIntegerField(null=True, blank=True) designtext = models.CharField(null=True, blank=True, max_length=100) graphicdes = models.CharField(null=True, blank=True, max_length=10) numberofus = models.BigIntegerField(null=True, blank=True) attachment = models.CharField(null=True, blank=True, max_length=254) matrefno = models.CharField(null=True, blank=True, max_length=30) impact = models.CharField(null=True, blank=True, max_length=500) flag = models.BooleanField(default=False) lat = models.FloatField(null=True, blank=True) long = models.FloatField(null=True, blank=True) geom = models.MultiPointField(srid=4326) def __str__(self): return self.facilityid
class TiposDeDatos(models.Model): # wsg 84 punto_ws84 = models.PointField(srid=4326) # peru punto = models.PointField(srid=32718) multi_punto = models.MultiPointField(srid=32718) poligono = models.PolygonField(srid=32718) multi_poli = models.MultiPolygonField(srid=32718) linea = models.LineStringField(srid=32718) multi_linea = models.MultiLineStringField(srid=32718)
class GWIntraFlow(models.Model): """ 7.6.24 GW_IntraFlow Fluid flow within a feature such as a unit, void, gw body, or even a man-made feature such as a conduit of some kind. """ gw_flow_location = models.MultiPointField( verbose_name="GwFlowLocation", help_text="The location where a fluid is flowing within a feature." )
class ModelForGeoDjango(geomodels.Model): geometry = geomodels.GeometryField() point = geomodels.PointField() line_string = geomodels.LineStringField() polygon = geomodels.PolygonField() multi_point = geomodels.MultiPointField() multi_line_string = geomodels.MultiLineStringField() multi_polygon = geomodels.MultiPolygonField() geometry_collection = geomodels.GeometryCollectionField() class Meta: app_label = 'django_dynamic_fixture'