class Biketown(models.Model):
route_id = models.IntegerField(blank=True, null=True)
payment_plan = models.TextField(blank=True, null=True)
start_hub = models.TextField(blank=True, null=True)
start_latitude = models.FloatField(blank=True, null=True)
start_longitude = models.FloatField(blank=True, null=True)
start_date = models.DateField(blank=True, null=True)
start_time = models.TimeField(blank=True, null=True)
end_hub = models.TextField(blank=True, null=True)
end_latitude = models.FloatField(blank=True, null=True)
end_longitude = models.FloatField(blank=True, null=True)
end_date = models.DateField(blank=True, null=True)
end_time = models.TimeField(blank=True, null=True)
trip_type = models.TextField(blank=True, null=True)
bike_id = models.IntegerField(blank=True, null=True)
bike_name = models.TextField(blank=True, null=True)
distance_miles = models.FloatField(blank=True, null=True)
duration_text = models.TextField(blank=True, null=True)
rental_access_path = models.TextField(blank=True, null=True)
multiple_rental = models.TextField(blank=True, null=True)
start_geom_4326 = models.GeometryField(blank=True, null=True)
end_geom_4326 = models.GeometryField(blank=True, null=True)
class Meta:
managed = False
db_table = 'biketown'
class Runlet(models.Model):
run = models.ForeignKey(Run, blank=True)
lat0 = models.FloatField(db_index=True, blank=True)
lon0 = models.FloatField(db_index=True, blank=True)
loc0 = models.GeometryField(srid=100000, blank=True)
t0 = models.IntegerField(db_index=True, blank=True)
latn = models.FloatField(db_index=True, blank=True)
lonn = models.FloatField(db_index=True, blank=True)
locn = models.GeometryField(srid=100000, blank=True)
tn = models.IntegerField(db_index=True, blank=True)
path = models.ForeignKey(Path, blank=True)
distance = models.FloatField(db_index=True, blank=True)
stop = models.TextField(blank=True)
stop_seq = models.IntegerField(blank=True)
class Buurtcombinatie(models.Model):
ogc_fid = models.AutoField(primary_key=True)
gml_id = models.CharField(max_length=255)
id = models.CharField(max_length=255, blank=True, null=True)
vollcode = models.CharField(max_length=255, blank=True, null=True)
naam = models.CharField(max_length=255, blank=True, null=True)
display = models.CharField(max_length=255, blank=True, null=True)
type = models.CharField(max_length=255, blank=True, null=True)
uri = models.CharField(max_length=255, blank=True, null=True)
wkb_geometry = models.GeometryField(blank=True, null=True)
wkb_geometry_simplified = models.GeometryField(srid=0, blank=True, null=True)
class Meta:
managed = False
db_table = 'buurtcombinatie'
class GaB28010(models.Model):
ogc_fid = models.AutoField(primary_key=True)
geoid = models.CharField(max_length=50, blank=True, null=True)
name = models.CharField(max_length=50, blank=True, null=True)
# b28010_001e = models.FloatField(blank=True, null=True)
# b28010_001m = models.FloatField(blank=True, null=True)
total_has_computing_devices = models.FloatField(blank=True,
null=True,
db_column='b28010_002e')
# b28010_002m = models.FloatField(blank=True, null=True)
# b28010_003e = models.FloatField(blank=True, null=True)
# b28010_003m = models.FloatField(blank=True, null=True)
# b28010_004e = models.FloatField(blank=True, null=True)
# b28010_004m = models.FloatField(blank=True, null=True)
# b28010_005e = models.FloatField(blank=True, null=True)
# b28010_005m = models.FloatField(blank=True, null=True)
total_smartphone_nodesktop = models.FloatField(blank=True,
null=True,
db_column='b28010_006e')
# b28010_006m = models.FloatField(blank=True, null=True)
total_no_computer = models.FloatField(blank=True,
null=True,
db_column='b28010_007e')
# b28010_007m = models.FloatField(blank=True, null=True)
wkb_geometry = models.GeometryField(blank=True, null=True)
class Meta:
managed = False
db_table = 'ga_b28010'
class OGRGeom(models.Model):
"""adding attribute fields"""
ogr_geom = models.GeometryField()
objects = models.GeoManager()
class Meta:
abstract = True
class PdxMsa2010CensusBlockGroups(models.Model):
ogc_fid = models.AutoField(primary_key=True)
state = models.CharField(max_length=50, blank=True, null=True)
county = models.CharField(max_length=50, blank=True, null=True)
tract = models.CharField(max_length=50, blank=True, null=True)
tract_no = models.FloatField(blank=True, null=True)
bg = models.CharField(max_length=50, blank=True, null=True)
trbg = models.CharField(max_length=50, blank=True, null=True)
fips = models.CharField(max_length=50, blank=True, null=True)
pop10 = models.IntegerField(blank=True, null=True)
du10 = models.IntegerField(blank=True, null=True)
vac10 = models.IntegerField(blank=True, null=True)
white = models.IntegerField(blank=True, null=True)
black = models.IntegerField(blank=True, null=True)
aian = models.IntegerField(blank=True, null=True)
asian = models.IntegerField(blank=True, null=True)
nhpi = models.IntegerField(blank=True, null=True)
other_race = models.IntegerField(blank=True, null=True)
pop_2_race = models.IntegerField(blank=True, null=True)
hispanic = models.IntegerField(blank=True, null=True)
wkb_geometry = models.GeometryField(blank=True, null=True)
class Meta:
managed = False
db_table = 'pdx_msa_2010_census_block_groups'
class Spots(models.Model):
name = models.CharField(max_length=100)
country = models.CharField(max_length=100)
country_code = models.CharField(max_length=5)
state = models.CharField(max_length=100)
city = models.CharField(max_length=100)
full_address = models.CharField(max_length=250)
postal_code = models.CharField(max_length=20)
lat = models.DecimalField(max_digits=22,
decimal_places=16,
blank=False,
null=True)
lng = models.DecimalField(max_digits=22,
decimal_places=16,
blank=False,
null=True)
geom = models.GeometryField(srid=4326, blank=False, null=True)
position = models.PointField(null=True, blank=False)
user = models.ForeignKey(User,
related_name='spots_user_id',
on_delete=models.CASCADE)
is_active = models.BooleanField(default=True)
is_deleted = models.BooleanField(default=False)
updated_date = models.DateTimeField(auto_now=True)
created_date = models.DateTimeField(auto_now_add=True)
class RegionalBoundary(models.Model): geom = models.GeometryField(blank=True, null=True) region = models.CharField(max_length=50, blank=True, null=True) class Meta: managed = False db_table = 'Regional_Boundary'
class Gauge01MinMinimal(models.Model):
id = models.BigIntegerField(blank=True, primary_key=True)
code = models.BigIntegerField(blank=True, null=True)
province = models.TextField(blank=True, null=True)
river_name = models.TextField(blank=True, null=True)
station_name = models.TextField(blank=True, null=True)
catchment_area = models.FloatField(blank=True, null=True)
# place= models.GeometryField(blank=True, null=True)
place = models.GeometryField(blank=True, db_column='point', null=True)
#def __init__(self, *args, **kwargs):
# super(models.Model, self).__init__(*args, **kwargs)
# self.filterby = None
class Meta:
managed = False # Created from a view. Don't remove.
# db_table = 'get_gauge_01min_minimal'
db_table = 'get_gauge_01min_geoj_new'
app_label = 'argentina'
# Methods
def get_absolute_url(self):
"""Returns the url to access a particular instance of MyModelName."""
return reverse('gauge-detail', args=[str(self.code)])
def get_download_url(self):
"""Returns the url to download data as excel file."""
return reverse('download-discharge', args=[str(self.code)])
def __str__(self):
"""String for representing the MyModelName object (in Admin site etc.)."""
return self.station_name
class Geometry(models.Model):
"""
Stores geographical geometries, eg. LAU1, MSOA, IG, LSOA, DZ polygons
Uses zoom-specific resolutions to minimise download size to user
"""
type = models.CharField(max_length=200, choices=GEOMETRY_CHOICES)
name = models.CharField(max_length=200)
code = models.CharField(max_length=200)
zoom = models.IntegerField(default=0)
geometry = models.GeometryField(null=True, blank=True)
def _get_geometry(self):
return self.geometry
geom = property(_get_geometry)
class Meta:
indexes = [
models.Index(fields=[
'type',
]),
models.Index(fields=[
'code',
]),
models.Index(fields=['zoom']),
models.Index(fields=[
'geometry',
]),
]
class CurrentPermits(models.Model):
permit_id = models.TextField(primary_key=True)
entry_date = models.DateField(blank=True, null=True)
issue_date = models.DateField(blank=True, null=True)
permit_category = models.TextField(blank=True, null=True)
type = models.TextField(blank=True, null=True)
district = models.TextField(blank=True, null=True)
city_state = models.TextField(blank=True, null=True)
location = models.TextField(blank=True, null=True)
cross_street = models.TextField(blank=True, null=True)
street_number = models.TextField(blank=True, null=True)
direction = models.TextField(blank=True, null=True)
street = models.TextField(blank=True, null=True)
street_type = models.TextField(blank=True, null=True)
city = models.TextField(blank=True, null=True)
state = models.TextField(blank=True, null=True)
zip_code = models.TextField(blank=True, null=True)
comments = models.TextField(blank=True, null=True)
expiration_date = models.DateField(blank=True, null=True)
final_date = models.DateField(blank=True, null=True)
effect_date = models.DateField(blank=True, null=True)
lat_lng = models.TextField(blank=True, null=True)
longitude = models.FloatField(blank=True, null=True)
latitude = models.FloatField(blank=True, null=True)
geom_point = models.GeometryField(blank=True, null=True, srid=4326)
class Meta:
managed = False
db_table = 'current_permits'
in_db = 'multnomah_county_permits'
class Line(models.Model):
route_id = models.IntegerField(db_index=True, null=True)
line = models.CharField(max_length=8)
line_geom = models.GeometryField(srid=100000, blank=True)
direction = models.IntegerField(db_index=True, blank=True)
numtag = models.CharField(max_length=16)
tag = models.CharField(max_length=16)
class FMA(models.Model):
fma = models.CharField(max_length=2, primary_key=True)
geom = models.GeometryField(srid=4326, blank=True, null=True)
class Meta:
managed = False
db_table = 'fma_shapes'
class ViewAnnualincome2018ChoGeom(models.Model):
地域コード = models.CharField(primary_key=True,
max_length=11,
blank=True,
null=False)
地域区分 = models.CharField(max_length=1, blank=True, null=True)
都道府県名 = models.CharField(max_length=10, blank=True, null=True)
市区町村名 = models.CharField(max_length=20, blank=True, null=True)
地域名 = models.CharField(max_length=30, blank=True, null=True)
秘匿合算符号 = models.CharField(max_length=2, blank=True, null=True)
一般世帯数 = models.FloatField(blank=True, null=True)
年収300万円未満世帯数 = models.FloatField(blank=True, null=True)
年収300_500万円未満世帯数 = models.FloatField(
db_column='年収300～500万円未満世帯数', blank=True,
null=True) # Field renamed to remove unsuitable characters.
年収500_700万円未満世帯数 = models.FloatField(
db_column='年収500～700万円未満世帯数', blank=True,
null=True) # Field renamed to remove unsuitable characters.
年収700_1000万円未満世帯数 = models.FloatField(
db_column='年収700～1000万円未満世帯数', blank=True,
null=True) # Field renamed to remove unsuitable characters.
年収1000_1500万円未満世帯数 = models.FloatField(
db_column='年収1000～1500万円未満世帯数', blank=True,
null=True) # Field renamed to remove unsuitable characters.
年収1500万円以上世帯数 = models.FloatField(blank=True, null=True)
年収1000万円以上世帯数 = models.FloatField(blank=True, null=True)
geom = models.GeometryField(blank=True, null=True)
class Meta:
managed = False # Created from a view. Don't remove.
db_table = 'view_annualincome2018_cho_geom'
class Blocks(models.Model):
gid = models.AutoField(primary_key=True)
field_gid = models.FloatField(
db_column='__gid', blank=True, null=True
) # Field renamed because it contained more than one '_' in a row. Field renamed because it started with '_'.
district = models.CharField(max_length=254, blank=True, null=True)
blkname = models.CharField(max_length=254, blank=True, null=True)
drd_dcode = models.CharField(max_length=254, blank=True, null=True)
drd_blkcod = models.CharField(max_length=254, blank=True, null=True)
count = models.DecimalField(max_digits=65535,
decimal_places=65535,
blank=True,
null=True)
blockcode = models.CharField(max_length=254, blank=True, null=True)
no_of_pt = models.FloatField(blank=True, null=True)
no_of_hap = models.FloatField(blank=True, null=True)
slno = models.FloatField(blank=True, null=True)
dt_code = models.DecimalField(max_digits=65535,
decimal_places=65535,
blank=True,
null=True)
corr_block = models.CharField(max_length=254, blank=True, null=True)
cat = models.CharField(max_length=254, blank=True, null=True)
cat_2004 = models.CharField(max_length=254, blank=True, null=True)
dt2001 = models.CharField(max_length=2, blank=True, null=True)
geom = models.GeometryField(blank=True, null=True)
class Meta:
managed = False
db_table = 'blocks'
class AnswerGroup_StudentGroup(models.Model):
"""Stores common value for the answers to a particular QuestionGroup for a
group value"""
studentgroup = models.ForeignKey(
"schools.StudentGroup",
on_delete=models.DO_NOTHING)
questiongroup = models.ForeignKey(
"QuestionGroup",
on_delete=models.DO_NOTHING)
group_value = models.CharField(max_length=100, null=True, blank=True)
created_by = models.ForeignKey(
User,
null=True,
on_delete=models.DO_NOTHING)
date_of_visit = models.DateTimeField(default=timezone.now)
respondent_type = models.ForeignKey(
RespondentType,
null=True,
on_delete=models.DO_NOTHING)
comments = models.CharField(max_length=2000, null=True, blank=True)
is_verified = models.BooleanField(default=False)
status = models.ForeignKey(
"common.Status",
on_delete=models.DO_NOTHING)
location = models.GeometryField(null=True)
mobile = models.CharField(max_length=32, null=True)
entered_at = models.DateTimeField(default=timezone.now, null=True)
class Countries(models.Model):
gid = models.AutoField(primary_key=True)
name = models.CharField(max_length=254, blank=True, null=True)
name_long = models.CharField(max_length=254, blank=True, null=True)
formal_en = models.CharField(max_length=254, blank=True, null=True)
sov_a3 = models.CharField(max_length=254, blank=True, null=True)
postal = models.CharField(max_length=254, blank=True, null=True)
abbrev = models.CharField(max_length=254, blank=True, null=True)
continent = models.CharField(max_length=254, blank=True, null=True)
region_un = models.CharField(max_length=254, blank=True, null=True)
subregion = models.CharField(max_length=254, blank=True, null=True)
region_wb = models.CharField(max_length=254, blank=True, null=True)
pop_est = models.BigIntegerField(blank=True, null=True)
pop_rank = models.BigIntegerField(blank=True, null=True)
gdp_md_est = models.DecimalField(max_digits=65535,
decimal_places=65535,
blank=True,
null=True)
pop_year = models.BigIntegerField(blank=True, null=True)
lastcensus = models.BigIntegerField(blank=True, null=True)
gdp_year = models.BigIntegerField(blank=True, null=True)
economy = models.CharField(max_length=254, blank=True, null=True)
income_grp = models.CharField(max_length=254, blank=True, null=True)
geom = models.GeometryField(blank=True, null=True)
class Meta:
managed = False
db_table = 'countries'
class TrimetStopEvents(models.Model):
service_date = models.DateField(blank=True, null=True)
vehicle_number = models.IntegerField(blank=True, null=True)
train = models.IntegerField(blank=True, null=True)
route_number = models.IntegerField(blank=True, null=True)
direction = models.IntegerField(blank=True, null=True)
trip_number = models.IntegerField(blank=True, null=True)
service_key = models.TextField(blank=True, null=True)
stop_time = models.IntegerField(blank=True, null=True)
arrive_time = models.IntegerField(blank=True, null=True)
seconds_late = models.IntegerField(blank=True, null=True)
leave_time = models.IntegerField(blank=True, null=True)
dwell = models.IntegerField(blank=True, null=True)
location_id = models.IntegerField(blank=True, null=True)
door = models.IntegerField(blank=True, null=True)
lift = models.IntegerField(blank=True, null=True)
ons = models.IntegerField(blank=True, null=True)
offs = models.IntegerField(blank=True, null=True)
estimated_load = models.IntegerField(blank=True, null=True)
train_mileage = models.FloatField(blank=True, null=True)
from_location = models.IntegerField(blank=True, null=True)
mileage_there = models.FloatField(blank=True, null=True)
left_there = models.IntegerField(blank=True, null=True)
travel_miles = models.FloatField(blank=True, null=True)
travel_seconds = models.IntegerField(blank=True, null=True)
x_coordinate = models.FloatField(blank=True, null=True)
y_coordinate = models.FloatField(blank=True, null=True)
geom_point_4326 = models.GeometryField(blank=True, null=True)
class Meta:
managed = False
db_table = 'trimet_stop_events'
in_db = 'trimet_stop_events'
class OrCensusBlockPolygons(models.Model):
census_block = models.CharField(primary_key=True, max_length=255)
geom_polygon_4326 = models.GeometryField(blank=True, null=True)
class Meta:
managed = False
db_table = 'or_census_block_polygons'
in_db = 'passenger_census'
class NairobiSubCounties(models.Model):
gid = models.AutoField(primary_key=True)
constituen = models.CharField(max_length=50, blank=True, null=True)
geom = models.GeometryField(blank=True, null=True)
class Meta:
managed = False
db_table = 'nairobi_sub_counties'
class State(models.Model):
ogc_fid = models.IntegerField(primary_key=True)
wkb_geometry = models.GeometryField()
geo_id = models.CharField(max_length=200)
state = models.CharField(max_length=200)
name = models.CharField(max_length=200)
lsad = models.CharField(max_length=200)
censusarea = models.DecimalField(max_digits=9, decimal_places=2)
class LarshbjGeoModel(models.Model):
name = models.CharField(max_length=50)
category = models.CharField(max_length=50, null=True)
user_id = models.IntegerField()
geom = models.GeometryField()
geom_type = models.CharField(max_length=50)
def __str__(self):
return self.name
class TmBoundary(models.Model):
ogc_fid = models.AutoField(primary_key=True)
area_sq_mi = models.FloatField(blank=True, null=True)
acres = models.FloatField(blank=True, null=True)
wkb_geometry = models.GeometryField(blank=True, null=True)
class Meta:
managed = False
db_table = 'tm_boundary'
class RouteStop(models.Model):
seq = models.IntegerField(db_index=True, blank=True)
route = models.ForeignKey(Route, blank=True)
tag = models.CharField(max_length=24, db_index=True, blank=True)
title = models.CharField(max_length=64, db_index=True, blank=True)
lat = models.FloatField(db_index=True, blank=True)
lon = models.FloatField(db_index=True, blank=True)
loc = models.GeometryField(srid=100000, blank=True)
stopid = models.IntegerField(db_index=True, blank=True)
class Stop(models.Model):
tag = models.CharField(max_length=8, blank=True)
stop_id = models.CharField(max_length=8, blank=True)
lat = models.FloatField(blank=True)
lon = models.FloatField(blank=True)
loc = models.GeometryField(srid=100000, blank=True)
title = models.CharField(max_length=64, db_index=True, blank=True)
x = models.FloatField(blank=True)
y = models.FloatField(blank=True)
class City(models.Model):
name = models.CharField(max_length=150)
boundary = models.GeometryField()
is_enabled = models.BooleanField(
default=False
) # For now, we are only going to show Oklahoma City's boundaries
def __str__(self):
return self.name
class Metadata(Base):
"""
Image metadata
**Parameters**
key: string
A unique identifier for the data
acquired: datetime
Timestamp for when the data was collected
published: datetime
Timestamp for when the data was published
processed: datetime
Timestamp for when the data was processed
source: int
A foreign key to the :py:class:`Source` for this data
bytes: long
Total bytes
pixels: long
Total pixels
cloud_fraction: float
Percentage of cloud free pixels
fill_fraction: float
Percentage of (not) nodata pixels
geom: geometry
Shape for the geometry
data: dict
Everything
groups: list
Access control list
"""
key = models.CharField(max_length=256)
acquired = models.DateTimeField(db_index=True, null=True)
published = models.DateTimeField(db_index=True, null=True)
processed = models.DateTimeField(db_index=True, null=True)
product = models.ForeignKey(Product, db_index=True)
bytes = models.BigIntegerField(blank=True, null=True)
pixels = models.BigIntegerField(blank=True, null=True)
cloud_fraction = models.FloatField(db_index=True, null=True)
fill_fraction = models.FloatField(db_index=True, null=True)
geom = models.GeometryField(null=True)
data = JSONField()
groups = ArrayField(models.CharField(max_length=80, blank=True))
def __unicode__(self):
return self.key
class Meta:
db_table = 'metadata'
unique_together = ('key', 'product')
class SageVoronoiPolygons(models.Model):
id = models.AutoField(primary_key=True)
intersecta = models.BooleanField(blank=True, null=True)
site_name = models.TextField(blank=True, null=True)
poligonos = models.GeometryField(srid=4326, blank=True, null=True)
objects = GeoManager()
class Meta:
managed = False
db_table = 'sage_voronoi_polygons'
class Places(models.Model):
geom = models.GeometryField(blank=True, null=True)
osm_id = models.BigIntegerField(blank=True, null=True)
name = models.CharField(max_length=48, blank=True, null=True)
type = models.CharField(max_length=16, blank=True, null=True)
population = models.BigIntegerField(blank=True, null=True)
class Meta:
managed = False
db_table = 'places'
class Districtnew(models.Model):
geom = models.GeometryField(blank=True, null=True)
model = models.CharField(max_length=17, blank=True, null=True)
district_n = models.CharField(max_length=29, blank=True, null=True)
district = models.CharField(max_length=8, blank=True, null=True)
fid = models.IntegerField(blank=True, null=True)
class Meta:
managed = False
db_table = 'districtnew'
