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'
