class Vertices(models.Model):
id = models.FloatField(primary_key=True)
val = models.IntegerField()
geom = models.MultiPointField(srid=4326)
def __unicode__(self):
return self.val
class Paragens(models.Model):
ele = models.FloatField()
time = models.CharField(max_length=24)
magvar = models.FloatField()
geoidheigh = models.FloatField()
name = models.CharField(max_length=254)
cmt = models.CharField(max_length=254)
desc = models.CharField(max_length=254)
src = models.CharField(max_length=254)
link1_href = models.CharField(max_length=254)
link1_text = models.CharField(max_length=254)
link1_type = models.CharField(max_length=254)
link2_href = models.CharField(max_length=254)
link2_text = models.CharField(max_length=254)
link2_type = models.CharField(max_length=254)
sym = models.CharField(max_length=254)
type = models.CharField(max_length=254)
fix = models.CharField(max_length=254)
sat = models.BigIntegerField()
hdop = models.FloatField()
vdop = models.FloatField()
pdop = models.FloatField()
ageofdgpsd = models.FloatField()
dgpsid = models.BigIntegerField()
ql_key = models.CharField(max_length=254)
geom = models.MultiPointField(srid=4326)
def __unicode__(self):
return self.Paragens
class foodlo(models.Model):
contact_na = models.CharField(max_length=254)
company_na = models.CharField(max_length=254)
primary_ad = models.CharField(max_length=254)
primary_ci = models.CharField(max_length=254)
census_tra = models.BigIntegerField()
census_blo = models.BigIntegerField()
x = models.FloatField()
latitude = models.BigIntegerField()
y_1 = models.FloatField()
y = models.FloatField()
longitude = models.BigIntegerField()
naics_code = models.BigIntegerField()
naics_desc = models.CharField(max_length=254)
gender = models.CharField(max_length=254)
title_desc = models.CharField(max_length=254)
contact_et = models.CharField(max_length=254)
hq_branch_field = models.CharField(max_length=254)
year_first = models.BigIntegerField()
population = models.CharField(max_length=254)
source = models.CharField(max_length=254)
geom = models.MultiPointField(srid=4326)
def __unicode__(self):
return self.naics_desc
class TerrebonneAddress(models.Model):
# Regular Django fields corresponding to the attributes in the
# JeffersonAddress shapefile.
ADDRESS = models.CharField(max_length=10, null =True,default=" ")
STREET = models.CharField(max_length=50, null =True)
SUITE = models.CharField(max_length=20, null =True)
ZIP = models.CharField(max_length=10, null =True)
AREA_NAME = models.CharField(max_length=30, null =True)
STREET_NAM = models.CharField(max_length=43, null =True)
ST_TYPE = models.CharField(max_length=5, null =True)
WO_AREA = models.CharField(max_length=30, null =True)
a_Slope = models.FloatField()
u_Intercep = models.FloatField()
FD100Year = models.FloatField()
FD500Year = models.FloatField()
FLD_ZONE = models.CharField(max_length=17, null =True)
BFE = models.FloatField()
Latitude = models.FloatField()
Longitude = models.FloatField()
WSF1 = models.FloatField()
WSF2 = models.FloatField()
# GeoDjango-specific: a geometry field (PointField)
mpoint = models.MultiPointField()
# Returns the string representation of the model.
def __str__(self):
return str(self.ADDRESS)+", "+str(self.STREET)+", "+str(self.SUITE)+", "+str(self.AREA_NAME)+", "+str(self.ZIP)
class Restroom(models.Model):
id = models.BigIntegerField(primary_key=True)
geom = models.MultiPointField(srid=21781, blank=True, null=True)
name = models.CharField(max_length=80, blank=True, null=True)
class Meta:
managed = False
db_table = 'Restroom'
class Location(models.Model):
text = models.CharField(max_length=255)
created_at = models.DateField()
types = models.CharField(max_length=80)
geom = models.MultiPointField(srid=4326)
def __unicode__(self):
return self.text
class Project(models.Model):
geom = models.MultiPointField()
bureau = models.CharField(max_length=1000)
contact = models.CharField(max_length=1000)
name = models.CharField(max_length=1000)
description = models.CharField(max_length=1000)
period = pg_fields.DateRangeField()
original = models.ForeignKey(ApiElement)
class TrLampu(models.Model):
geom = models.MultiPointField(srid=32651)
class Meta:
verbose_name_plural = "Lampu Lalu Lintas"
class Meta:
verbose_name = "Lampu Lalu Lintas"
class Firstaid(models.Model):
id = models.BigIntegerField(primary_key=True)
geom = models.MultiPointField(srid=21781, blank=True, null=True)
name = models.CharField(max_length=80, blank=True, null=True)
altitude = models.IntegerField(blank=True, null=True)
class Meta:
managed = False
db_table = 'FirstAid'
class TitikPuskesmas(models.Model):
no = models.BigIntegerField()
puskesmas = models.CharField(max_length=254)
x = models.FloatField()
y = models.FloatField()
geom = models.MultiPointField(srid=4326)
def __str__(self):
return self.puskesmas
class Town(models.Model):
id = models.AutoField(primary_key=True)
town_name = models.CharField(max_length=50)
town_type = models.CharField(max_length=50)
geom = models.MultiPointField(srid=4326)
objects = models.GeoManager()
class Meta:
verbose_name_plural = 'Towns'
def __unicode__(self):
return self.town_name
class Mine(models.Model):
layer = models.CharField(max_length=21)
name = models.CharField(max_length=200)
name_en = models.CharField(max_length=200)
mineral_na = models.CharField(max_length=100)
mineral_1 = models.CharField(max_length=100)
code_state = models.CharField(max_length=60)
et_id = models.IntegerField()
geom = models.MultiPointField(srid=4236)
def __unicode__(self):
return self.name
class ZabytkiRuchome(models.Model):
nazwa = models.CharField(max_length=254)
rodzaj_dokumentu = models.CharField(max_length=254)
jednostka = models.CharField(max_length=254)
RDLP_lub_zakład = models.CharField(max_length=254)
geometria = models.MultiPointField(srid=4326)
def __str__(self):
return self.nazwa
class Meta:
verbose_name_plural = " Zabytki ruchome"
class Child(models.Model):
id = models.BigIntegerField(primary_key=True)
name = models.CharField(max_length=254)
age = models.BigIntegerField()
sex = models.CharField(max_length=254)
disability = models.CharField(max_length=254)
disab_stat = models.CharField(max_length=254)
learn_stat = models.CharField(max_length=254)
tribe = models.CharField(max_length=254)
religion = models.CharField(max_length=254)
latitude = models.FloatField()
longitude = models.FloatField()
geom = models.MultiPointField(srid=4326)
class places(models.Model):
objectid = models.BigIntegerField()
state_code = models.CharField(max_length=254, null='False')
source = models.CharField(max_length=254, null='False')
name = models.CharField(max_length=254, null='False')
alt_name = models.CharField(max_length=254, null='False')
ward_code = models.CharField(max_length=254, null='False')
is_primary = models.IntegerField()
global_id = models.CharField(max_length=254, null='False')
geom = models.MultiPointField(srid=4326)
def __str__(self):
return 'Name: %s' % self.name
class Swalayan(models.Model):
nama = models.CharField(max_length=50, null=True)
keterangan = models.CharField(max_length=50, null=True)
minimarket = models.CharField(max_length=50, null=True)
geom = models.MultiPointField(srid=32651)
def __str__(self):
return self.nama
class Meta:
verbose_name_plural = "Swalayan"
class Meta:
verbose_name = "Swalayan"
class Fence(models.Model):
name = models.CharField(max_length=30)
fencerange = models.IntegerField(default="200")
color = models.CharField(max_length=30, default="red")
ringcolor = models.CharField(max_length=30, default="f03")
address = models.CharField(max_length=60, default="none")
warnning = models.CharField(max_length=90,
default="Silence Please",
blank=True,
null=True)
geom = models.MultiPointField(srid=4326, blank=True, null=True)
def __unicode__(self):
return self.name
class TrTerminal(models.Model):
point_x = models.FloatField()
point_y = models.FloatField()
nama_obyek = models.CharField(max_length=254)
kls_obyek = models.CharField(max_length=254)
kode = models.CharField(max_length=254)
no_foto = models.CharField(max_length=254)
tgl_survey = models.CharField(max_length=254)
geom = models.MultiPointField(srid=32651)
def __str__(self):
return self.nama_obyek
class Meta:
verbose_name_plural = "Terminal Transportasi"
class Meta:
verbose_name = "Terminal"
class Spouse(models.Model):
id = models.BigIntegerField(primary_key=True)
name = models.CharField(max_length=254)
age = models.BigIntegerField()
sex = models.CharField(max_length=254)
disability = models.CharField(max_length=254)
disab_stat = models.CharField(max_length=254)
learn_stat = models.CharField(max_length=254)
tribe = models.CharField(max_length=254)
death_stat = models.BigIntegerField()
religion = models.CharField(max_length=254)
mar_stat = models.CharField(max_length=254)
employer = models.CharField(max_length=254)
ipm = models.BigIntegerField()
work_stat = models.CharField(max_length=254)
latitude = models.FloatField()
longitude = models.FloatField()
geom = models.MultiPointField(srid=4326)
class Lampadaire(models.Model):
STATE = (
('ok', 'ok'),
('bb', 'Broken Bulb'),
('bl', 'Broken Light'),
)
gid = models.IntegerField(primary_key=True)
ruleid = models.DecimalField(max_digits=10,
decimal_places=0,
blank=True,
null=True)
states = models.CharField(max_length=2, choices=STATE, default='ok')
geom = models.MultiPointField(srid=32628, blank=True, null=True)
objects = models.GeoManager()
class Meta:
managed = True
db_table = 'lampadaire'
class Pendidikan(models.Model):
surveyor = models.CharField(max_length=254, default='')
waktu_surv = models.DateField(default='')
nama = models.CharField(max_length=254, default='')
alamat = models.CharField(max_length=254, default='')
jenjang = models.CharField(max_length=254, default='')
jml_kelas = models.FloatField(default='')
jml_guru = models.FloatField(default='')
jml_siswa = models.FloatField(default='')
fasilitas = models.FloatField(default='')
tahun = models.CharField(max_length=254, default='')
anggaran = models.FloatField(default='')
geom = models.MultiPointField(srid=4326)
def __unicode__(self):
return self.surveyor
class Meta:
verbose_name_plural = 'Pendidikan'
class Infralampu(models.Model):
name = models.CharField(max_length=254, null=True)
descript = models.CharField(max_length=254, null=True)
type = models.CharField(max_length=254, null=True)
comment = models.CharField(max_length=254, null=True)
symbol = models.CharField(max_length=254, null=True)
elevation = models.FloatField(null=True)
date_time_field = models.CharField(max_length=50, null=True)
keterangan = models.CharField(max_length=8, null=True)
geom = models.MultiPointField(srid=32651, null=True)
def __str__(self):
return self.name
class Meta:
verbose_name_plural = "Infrastruktur Lampu Jalan"
class Meta:
verbose_name = "Infrastruktur Lampu Jalan"
class Telekomunikasi(models.Model):
no = models.FloatField()
menara = models.CharField(max_length=254)
longitude = models.FloatField()
lattitude = models.FloatField()
antena_hei = models.FloatField()
site_categ = models.CharField(max_length=254)
desa = models.CharField(max_length=254)
kecamatan = models.CharField(max_length=254)
kabupaten = models.CharField(max_length=254)
geom = models.MultiPointField(srid=32651)
def __str__(self):
return self.menara
class Meta:
verbose_name_plural = "BTS Telekomunikasi"
class Meta:
verbose_name = "BTS Telekomunikasi"
class Sanitasi(models.Model):
fid_field = models.IntegerField()
name = models.CharField(max_length=254)
descript = models.CharField(max_length=254)
type = models.CharField(max_length=254)
comment = models.CharField(max_length=254)
symbol = models.CharField(max_length=254)
datetimes = models.CharField(max_length=24)
elevation = models.FloatField()
keterangan = models.CharField(max_length=254)
geom = models.MultiPointField(srid=32651)
def __str__(self):
return self.keterangan
class Meta:
verbose_name_plural = "Sanitasi"
class Meta:
verbose_name = "Sanitasi"
class Drainase(models.Model):
surveyor = models.CharField(max_length=254)
waktu_surv = models.DateField()
no_kode = models.CharField(max_length=254)
rpru = models.CharField(max_length=254)
kemiringan = models.CharField(max_length=254)
pjg_salura = models.FloatField(default='')
lebar_salu = models.FloatField()
kedalaman = models.FloatField()
kondisi = models.CharField(max_length=254, )
tahun = models.CharField(max_length=254, )
anggaran = models.FloatField()
sumber_dan = models.CharField(max_length=254, )
geom = models.MultiPointField(srid=4326)
def __unicode__(self):
return self.surveyor
class Meta:
verbose_name_plural = 'Drainase'
class TrJembatan(models.Model):
oid_field = models.IntegerField()
name = models.CharField(max_length=254)
base = models.FloatField()
snippet = models.CharField(max_length=254)
labelid = models.IntegerField()
folder_pat = models.CharField(max_length=50)
symbol_id = models.CharField(max_length=50)
alt_mode = models.CharField(max_length=50)
pop_up_inf = models.CharField(max_length=50)
hsl_tabel = models.CharField(max_length=50)
geom = models.MultiPointField(srid=32651)
def __str__(self):
return self.name
class Meta:
verbose_name_plural = "Jembatan"
class Meta:
verbose_name = "Jembatan"
class Kesehatan(models.Model):
surveyor = models.CharField(max_length=254, default='')
waktu_surv = models.DateField(default='')
nama = models.CharField(max_length=254, default='')
alamat = models.CharField(max_length=254, default='')
jenis = models.CharField(max_length=254, default='')
jml_dokter = models.CharField(max_length=254, default='')
jml_perawa = models.CharField(max_length=254, default='')
jml_dosen = models.CharField(max_length=254, default='')
jml_pasien = models.CharField(max_length=254, default='')
fasilitas = models.CharField(max_length=254, default='')
kondisi = models.CharField(max_length=254, default='')
tahun_diba = models.CharField(max_length=254, default='')
anggaran = models.CharField(max_length=254, default='')
sumber_dan = models.CharField(max_length=254, default='')
geom = models.MultiPointField(srid=4326)
def __unicode__(self):
return self.surveyor
class Meta:
verbose_name_plural = 'Fasilitas Kesehatan'
class Jembatan(models.Model):
surveyor = models.CharField(max_length=254, default='')
waktu_surv = models.DateField(default='')
nama = models.CharField(max_length=254, default='')
no_kode = models.CharField(max_length=254, default='')
pal_km = models.CharField(max_length=254, default='')
tipe_sebra = models.CharField(max_length=254, default='')
jenis_jemb = models.CharField(max_length=254, default='')
panjang = models.FloatField(default='')
lebar = models.FloatField(default='')
jml_bentan = models.FloatField(default='')
kondisi = models.CharField(max_length=254, default='')
tahun = models.CharField(max_length=254, default='')
anggaran = models.FloatField(default='')
sumber_dan = models.CharField(max_length=254, default='')
geom = models.MultiPointField(srid=4326)
def __unicode__(self):
return self.surveyor
class Meta:
verbose_name_plural = 'Jembatan'
class JeffersonbuildingdataFSH(models.Model):
# Regular Django fields corresponding to the attributes in the
# JeffersonBUILDING shapefile.
FID_1 = models.BigIntegerField(default=" ")
BLDG_ID = models.CharField(max_length=10, null =True)
HEIGHT = models.FloatField()
FOOTPRINT = models.FloatField() #
address = models.CharField(max_length=100, null =True)
street = models.CharField(max_length=200, null =True)
no_floors = models.FloatField()
DATA_YEAR = models.CharField(max_length=10, null =True)
SFT = models.FloatField()
Area_SqMet = models.FloatField()
FloodDepth = models.FloatField()
FloodDep_1 = models.FloatField()
FloodDep_2 = models.FloatField()
FloodDep_3 = models.FloatField()
ElevationU = models.FloatField()
Elevation = models.FloatField() #
Elevatio_1 = models.FloatField()
FID_2 = models.BigIntegerField()
Source = models.CharField(max_length=50, null =True)
u_intercept = models.FloatField()
a_slope = models.FloatField()
Latitude = models.FloatField()
Longitude = models.FloatField()
FloodZone = models.CharField(max_length=100, null =True)
Parish = models.CharField(max_length=50, null =True)
# GeoDjango-specific: a geometry field (PointField)
mpoint = models.MultiPointField()
# Returns the string representation of the model.
def __str__(self):
return str(self.address)+" , "+str(self.street)
class JalanPoint(models.Model):
surveyor = models.CharField(max_length=254)
waktu_surv = models.DateField()
nomor_ruas = models.CharField(max_length=254)
nama_jalan = models.CharField(max_length=254)
panjang = models.CharField(max_length=254)
lebar = models.CharField(max_length=254)
tpp = models.CharField(max_length=254)
tpu = models.CharField(max_length=254)
lhr = models.CharField(max_length=254)
klasifikas = models.CharField(max_length=254)
status_adm = models.CharField(max_length=254)
tipe_permu = models.CharField(max_length=254)
kondisi_ja = models.CharField(max_length=254)
hambatan = models.CharField(max_length=254)
tahun = models.CharField(max_length=254)
anggaran = models.CharField(max_length=254)
geom = models.MultiPointField(srid=4326)
def __unicode__(self):
return self.surveyor
class Meta:
verbose_name_plural = 'Kondisi Jalan'
