-
Notifications
You must be signed in to change notification settings - Fork 1
/
db.sql
293 lines (227 loc) · 84.2 KB
/
db.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
/*
SQLyog Ultimate v11.11 (64 bit)
MySQL - 5.7.9 : Database - crimenesia
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
/*!40101 SET SQL_MODE=''*/;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`crimenesia` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `crimenesia`;
/*Table structure for table `administrator` */
DROP TABLE IF EXISTS `administrator`;
CREATE TABLE `administrator` (
`username` varchar(20) NOT NULL,
`password` varchar(20) DEFAULT NULL,
`nama` varchar(30) DEFAULT NULL,
`foto` varchar(50) DEFAULT NULL,
`akses` tinyint(1) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`last_login` datetime DEFAULT NULL,
PRIMARY KEY (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table `administrator` */
insert into `administrator`(`username`,`password`,`nama`,`foto`,`akses`,`created_at`,`updated_at`,`last_login`) values ('adminx','123','indro warkop','adminx2017-07-19 15-21-58.jpeg',1,'2017-06-21 14:47:59','2018-01-18 16:56:08','2018-04-23 20:55:07'),('cica','6565','cica riko','cica2017-06-21 16-05-53.jpeg',1,'2017-06-21 16:05:53','2017-06-21 16:05:53',NULL),('wawax','55','wawa baba','wawax2017-11-22 10-59-20.jpeg',0,'2017-06-21 16:06:17','2017-11-22 10:59:21','2017-11-28 12:41:17');
/*Table structure for table `kantor_polisi` */
DROP TABLE IF EXISTS `kantor_polisi`;
CREATE TABLE `kantor_polisi` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nama_kantor` varchar(30) DEFAULT NULL,
`email` varchar(50) DEFAULT NULL,
`id_kota` int(11) DEFAULT NULL,
`alamat` varchar(100) DEFAULT NULL,
`kode_pos` char(5) DEFAULT NULL,
`tlp` varchar(13) DEFAULT NULL,
`ket` mediumtext,
`lat` float DEFAULT NULL,
`long` float DEFAULT NULL,
`path` text,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `id_kota` (`id_kota`),
CONSTRAINT `id_kota` FOREIGN KEY (`id_kota`) REFERENCES `kota` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=latin1;
/*Data for the table `kantor_polisi` */
insert into `kantor_polisi`(`id`,`nama_kantor`,`email`,`id_kota`,`alamat`,`kode_pos`,`tlp`,`ket`,`lat`,`long`,`path`,`created_at`,`updated_at`) values (17,'Polsek Sawahan','polrestabessurabaya@gmail.com',3578,'Jl. Tidar No.171, Petemon, Kec. Sawahan','60252','0315341048','Jumlah penduduk : 188.760 jiwa\r\nLuas wilayah : 6,9 km2\r\n\r\nKelurahan\r\n1. Kelurahan Patemon\r\n2. Kelurahan Sawahan\r\n3. Kelurahan Kupangkrajan\r\n4. Kelurahan Banyuurip\r\n5. Kelurahan Putat Jaya\r\n6. Kelurahan Pakis\r\n\r\nKapolsek Sawahan\r\nKompol Yulianto, SH',-7.25539,112.716,'[{longitude:112.7342037842668,latitude:-7.256141452534629},{longitude:112.732711111625,latitude:-7.255943300806388},{longitude:112.7310122514915,latitude:-7.256162515006938},{longitude:112.7276907431666,latitude:-7.25597805767787},{longitude:112.7274448711408,latitude:-7.257019666668421},{longitude:112.7259432997929,latitude:-7.256884537144924},{longitude:112.7243497812523,latitude:-7.256947889356606},{longitude:112.7193721106895,latitude:-7.256127085147309},{longitude:112.7163971782015,latitude:-7.254988231637348},{longitude:112.7158821537612,latitude:-7.25442188549667},{longitude:112.7154386948189,latitude:-7.254098243335216},{longitude:112.715018407864,latitude:-7.255155207645826},{longitude:112.7148171527642,latitude:-7.256191778921226},{longitude:112.714221117026,latitude:-7.258148747206071},{longitude:112.7131989620896,latitude:-7.262009546155031},{longitude:112.7124406503895,latitude:-7.26745504823981},{longitude:112.712044331529,latitude:-7.268104805809046},{longitude:112.7105039261043,latitude:-7.273199786114378},{longitude:112.7090704306556,latitude:-7.273201920405406},{longitude:112.7086727142681,latitude:-7.275654355959165},{longitude:112.7100877749078,latitude:-7.275651638878158},{longitude:112.7097021682097,latitude:-7.277458681410524},{longitude:112.7126563195008,latitude:-7.278774181595933},{longitude:112.7137375516861,latitude:-7.279100209939258},{longitude:112.7174231678433,latitude:-7.279645293314756},{longitude:112.7153965453564,latitude:-7.285121408023086},{longitude:112.7134832989585,latitude:-7.290468032224521},{longitude:112.7175216194129,latitude:-7.291616426166151},{longitude:112.7237171858652,latitude:-7.29222597657798},{longitude:112.7296222971797,latitude:-7.292887272530165},{longitude:112.731166504984,latitude:-7.291049325712171},{longitude:112.7318180100716,latitude:-7.28877362769809},{longitude:112.7307259043006,latitude:-7.288063044550674},{longitude:112.7301160507379,latitude:-7.287010135635358},{longitude:112.7310437478158,latitude:-7.28625169982237},{longitude:112.7304866867366,latitude:-7.28391023699596},{longitude:112.7293089433584,latitude:-7.281815866557006},{longitude:112.7291173573866,latitude:-7.280312001835962},{longitude:112.7278798613923,latitude:-7.279535526880301},{longitude:112.727896292793,latitude:-7.276928759693432},{longitude:112.7267733445397,latitude:-7.275046605474633},{longitude:112.7342037842668,latitude:-7.256141452534629}]','2017-12-09 05:10:30','2017-12-09 05:10:34'),(18,'Polsek Wonokromo','polrestabessurabaya@gmail.com',3578,'Jl. Joyoboyo No 1, Surabaya','60242','0315679030','Jumlah penduduk : 146.870 jiwa\r\nLuas wilayah : 8,47 km2\r\n\r\nKelurahan\r\n1. Kelurahan Ngagel\r\n2. Kelurahan Ngagelrejo\r\n3. Kelurahan Darmo\r\n4. Kelurahan Sawunggaling\r\n5. Kelurahan Wonokromo\r\n6. Kelurahan Jagir\r\n\r\nKapolsek Wonokromo\r\nKompol I Gede Suartika',-7.2988,112.737,'[{longitude:112.7279178016267,latitude:-7.27683787024511},{longitude:112.727908825249,latitude:-7.27953270134753},{longitude:112.7291696880551,latitude:-7.28034418066937},{longitude:112.7291777747957,latitude:-7.281724952775633},{longitude:112.7310649678365,latitude:-7.286240257216407},{longitude:112.7301149595925,latitude:-7.287022928385422},{longitude:112.7307505915516,latitude:-7.28807675057052},{longitude:112.7318232596294,latitude:-7.288793128848482},{longitude:112.7311663062337,latitude:-7.291061217479185},{longitude:112.7296359498738,latitude:-7.292868493913977},{longitude:112.725175376042,latitude:-7.292397456717839},{longitude:112.7247486950107,latitude:-7.294060894755674},{longitude:112.7239019153142,latitude:-7.294137915946132},{longitude:112.7210868139771,latitude:-7.295950359133259},{longitude:112.7205663889418,latitude:-7.302285684457119},{longitude:112.7202429952611,latitude:-7.306157922681522},{longitude:112.719895797352,latitude:-7.307041918474142},{longitude:112.7207203183262,latitude:-7.307948753927378},{longitude:112.7240377306695,latitude:-7.307647024813482},{longitude:112.7297454379514,latitude:-7.310062495875719},{longitude:112.7304730782726,latitude:-7.309766722251823},{longitude:112.7350353369715,latitude:-7.310478984888126},{longitude:112.7350271294986,latitude:-7.311160732220431},{longitude:112.7389399254738,latitude:-7.312088478574092},{longitude:112.7391847495986,latitude:-7.310847460207232},{longitude:112.7405468726217,latitude:-7.311089364608188},{longitude:112.7416620816792,latitude:-7.305920947190749},{longitude:112.7502834332855,latitude:-7.305803533513861},{longitude:112.7541250401694,latitude:-7.306363065108791},{longitude:112.7563600224793,latitude:-7.306897602675712},{longitude:112.7571955059936,latitude:-7.304504032141921},{longitude:112.7546584975537,latitude:-7.303763024381167},{longitude:112.7572390124345,latitude:-7.293930612274837},{longitude:112.75471787429,latitude:-7.293530964013821},{longitude:112.7513243873713,latitude:-7.292917657783137},{longitude:112.7480032176283,latitude:-7.291495629591878},{longitude:112.7472560848685,latitude:-7.290938123462008},{longitude:112.75057487985,latitude:-7.27727731802159},{longitude:112.7463987431294,latitude:-7.276486874413386},{longitude:112.7440453587555,latitude:-7.277184061783},{longitude:112.7445368876863,latitude:-7.278845866255093},{longitude:112.7463645256118,latitude:-7.28182759981844},{longitude:112.7470318329675,latitude:-7.284329377419121},{longitude:112.7467111067737,latitude:-7.285887147238855},{longitude:112.7450915795323,latitude:-7.287869016155498},{longitude:112.7428254588563,latitude:-7.290085727102472},{longitude:112.7417527128504,latitude:-7.290198731988077},{longitude:112.7400137697289,latitude:-7.289370916896249},{longitude:112.7391983448495,latitude:-7.289184459833901},{longitude:112.7374544800277,latitude:-7.289220274101285},{longitude:112.7361201450554,latitude:-7.289597324790876},{longitude:112.7334961450236,latitude:-7.284452285785812},{longitude:112.7318178715331,latitude:-7.281085734787583},{longitude:112.7279178016267,latitude:-7.27683787024511}]','2017-12-09 05:13:06','2017-12-09 05:13:11'),(19,'Polsek Dukuh Pakis','polrestabessurabaya@gmail.com',3578,'Jl. Dukuh Kupang Barat XVI/6-8, Surabaya','60271','0315678145','Jumlah penduduk : 57.240 jiwa\r\nLuas wilayah : 9,94 km2\r\n\r\nKelurahan\r\n1. Kelurahan Dukuh Kupang\r\n2. Kelurahan Dukuh Pakis\r\n3. Kelurahan Gunung Sari\r\n4. Kelurahan Pradah Kalikendal\r\n\r\nKapolsek Dukuh Pakis\r\nKompol Slamet Sugiarto, SH',-7.28149,112.711,'[{longitude:112.7080668900801,latitude:-7.275838497320297},{longitude:112.7081388813557,latitude:-7.2792323704389},{longitude:112.7066550047832,latitude:-7.278718555828074},{longitude:112.7051095815684,latitude:-7.277033583125125},{longitude:112.6986034134567,latitude:-7.281607108882228},{longitude:112.7011332508617,latitude:-7.284531760319194},{longitude:112.7044582003514,latitude:-7.281774708693909},{longitude:112.7082627158503,latitude:-7.283386946396516},{longitude:112.7070675975241,latitude:-7.288308513920588},{longitude:112.7037494075716,latitude:-7.292834772061238},{longitude:112.6985538406891,latitude:-7.291518479230574},{longitude:112.6938695830031,latitude:-7.289648657693299},{longitude:112.6947254652805,latitude:-7.286468097196541},{longitude:112.6955004238939,latitude:-7.286469681587987},{longitude:112.6956906972892,latitude:-7.28522836667186},{longitude:112.6941396030269,latitude:-7.284700057136019},{longitude:112.6969225015329,latitude:-7.282349080794931},{longitude:112.6963326399643,latitude:-7.281571075657146},{longitude:112.6974060205558,latitude:-7.280477192212215},{longitude:112.6961083341529,latitude:-7.278804031966621},{longitude:112.6910742489107,latitude:-7.278271167397798},{longitude:112.6880603209841,latitude:-7.278619856581808},{longitude:112.6843426534967,latitude:-7.273240783522581},{longitude:112.6796721693115,latitude:-7.280247549899904},{longitude:112.678161474562,latitude:-7.286886380349616},{longitude:112.6786948370814,latitude:-7.287793507451687},{longitude:112.6772035759449,latitude:-7.289497028406762},{longitude:112.6757780587769,latitude:-7.294547676209834},{longitude:112.6776797754544,latitude:-7.295961093370361},{longitude:112.6842084924338,latitude:-7.299065883080639},{longitude:112.6827737323886,latitude:-7.301600465724039},{longitude:112.6863086606593,latitude:-7.301374447342339},{longitude:112.686607718919,latitude:-7.300536154214776},{longitude:112.6885518835002,latitude:-7.299402279726004},{longitude:112.691896469861,latitude:-7.29988907308421},{longitude:112.6960221359138,latitude:-7.301459001451788},{longitude:112.696973167755,latitude:-7.299953064551651},{longitude:112.6973334027388,latitude:-7.301807925584011},{longitude:112.7009663184045,latitude:-7.302533571097694},{longitude:112.7039368410688,latitude:-7.301708088927588},{longitude:112.7048948073803,latitude:-7.300642916915671},{longitude:112.705148487032,latitude:-7.300016352597036},{longitude:112.707384762837,latitude:-7.3018913424822},{longitude:112.7048105149817,latitude:-7.301832927538969},{longitude:112.7040088771223,latitude:-7.307376061017616},{longitude:112.7067011596541,latitude:-7.307987124037777},{longitude:112.7078527721904,latitude:-7.307295570819179},{longitude:112.712852600899,latitude:-7.307142157300805},{longitude:112.7137751648429,latitude:-7.307525592885313},{longitude:112.7199306826845,latitude:-7.307063675639036},{longitude:112.7202449932375,latitude:-7.306214958255564},{longitude:112.7208189331416,latitude:-7.298247374598393},{longitude:112.7210564406997,latitude:-7.295969887880038},{longitude:112.7224261769557,latitude:-7.295160756382696},{longitude:112.7238956807793,latitude:-7.294110599931403},{longitude:112.7247194326947,latitude:-7.294062874054748},{longitude:112.7252123476234,latitude:-7.292405643356462},{longitude:112.7221275874317,latitude:-7.292057498924521},{longitude:112.7172434292989,latitude:-7.291537007493258},{longitude:112.7134837494162,latitude:-7.290454447891825},{longitude:112.7154132362877,latitude:-7.285745331602597},{longitude:112.7173458898509,latitude:-7.279646331903906},{longitude:112.7133985828397,latitude:-7.279000119917868},{longitude:112.7096851571586,latitude:-7.277482052036135},{longitude:112.7100680934907,latitude:-7.275655149588791},{longitude:112.7086729082805,latitude:-7.275727221582006},{longitude:112.7080668900801,latitude:-7.275838497320297}]','2017-12-09 05:34:50','2017-12-09 05:34:56'),(20,'Polsek Karang Pilang','polsekkarangpilangsby@gmail.com',3578,'Jl. Mastrip No. 35 Kedurus, Surabaya','60223','0317663528','Jumlah penduduk : 71.470 jiwa\r\nLuas wilayah : 9,23 km2\r\n\r\nKelurahan\r\n1. Kelurahan Kedurus\r\n2. Kelurahan Kebraon\r\n3. Kelurahan Warugunung\r\n4. Kelurahan Karang Pilang\r\n\r\nKapolsek Karang Pilang\r\nKompol Noerijanto',-7.31651,112.71,'[{longitude:112.7052073969838,latitude:-7.312953903653766},{longitude:112.7017095320726,latitude:-7.315177348679536},{longitude:112.6994601131587,latitude:-7.319424589307788},{longitude:112.6990119546568,latitude:-7.322237347694192},{longitude:112.6982274322909,latitude:-7.32185762581943},{longitude:112.697530386202,latitude:-7.323891274267584},{longitude:112.6907807834142,latitude:-7.322578556199358},{longitude:112.6903192084365,latitude:-7.324719365591942},{longitude:112.6911633594234,latitude:-7.324978661442978},{longitude:112.6913299950961,latitude:-7.324122862394077},{longitude:112.6926057830027,latitude:-7.324416510552308},{longitude:112.6925794727735,latitude:-7.325279231578209},{longitude:112.6953289348269,latitude:-7.326149948734065},{longitude:112.6947558292547,latitude:-7.328632949484448},{longitude:112.6953387675662,latitude:-7.329475202980811},{longitude:112.6953930998022,latitude:-7.33037195525313},{longitude:112.6961982463006,latitude:-7.330826178800032},{longitude:112.6955648918978,latitude:-7.333781834814436},{longitude:112.6801270820116,latitude:-7.329544495879919},{longitude:112.6732300528534,latitude:-7.3337001392114},{longitude:112.6697043010101,latitude:-7.333449916742352},{longitude:112.6669799552042,latitude:-7.334990519160812},{longitude:112.6606683847077,latitude:-7.334016494838394},{longitude:112.6593903598289,latitude:-7.335247737564409},{longitude:112.6567843846944,latitude:-7.332918388528013},{longitude:112.6543840200726,latitude:-7.334477043222324},{longitude:112.6573458616612,latitude:-7.337736058635473},{longitude:112.6601546594055,latitude:-7.337943379997034},{longitude:112.6604816606881,latitude:-7.349779328393596},{longitude:112.6625692866369,latitude:-7.351327173552715},{longitude:112.6680872892664,latitude:-7.351082822471263},{longitude:112.6750231427552,latitude:-7.35126421778434},{longitude:112.6784355160178,latitude:-7.350350793202768},{longitude:112.6825715864007,latitude:-7.347802301202814},{longitude:112.6904734990143,latitude:-7.345447016820086},{longitude:112.696727005255,latitude:-7.342696107894724},{longitude:112.7008862736997,latitude:-7.339248190576708},{longitude:112.7048603228018,latitude:-7.33615566551854},{longitude:112.7080103669447,latitude:-7.331959630967859},{longitude:112.7106457719813,latitude:-7.328873305261212},{longitude:112.7104985924477,latitude:-7.32278313456443},{longitude:112.7108890019925,latitude:-7.320311534398035},{longitude:112.7115507834868,latitude:-7.318650798005313},{longitude:112.7116840133244,latitude:-7.31292268968547},{longitude:112.7052073969838,latitude:-7.312953903653766}]','2017-12-09 05:39:10','2017-12-09 05:39:16'),(21,'Polsek Wiyung','polrestabessurabaya@gmail.com',3578,'Jl. Menganti Wiyung 5','60228','0317521354','Jumlah penduduk : 51.780 jiwa\r\nLuas wilayah : 12,46 km2\r\n\r\nKelurahan\r\n1. Kelurahan Babatan\r\n2. Kelurahan Balasklumprik\r\n3. Kelurahan Jajar Tunggal\r\n4. Kelurahan Wiyung\r\n\r\nKapolsek Wiyung\r\nKompol Drs M. Rasyad',-7.314,112.696,'[{longitude:112.7144843628271,latitude:-7.307931240974797},{longitude:112.7132541124777,latitude:-7.307107273930136},{longitude:112.707639747647,latitude:-7.30661245362156},{longitude:112.7067298480424,latitude:-7.308064338028618},{longitude:112.7041434302683,latitude:-7.307524386834257},{longitude:112.7044033447375,latitude:-7.303721992302647},{longitude:112.7066777682967,latitude:-7.303794130627283},{longitude:112.7073957756655,latitude:-7.302925813870376},{longitude:112.7069850525594,latitude:-7.301442885403593},{longitude:112.7052470816125,latitude:-7.300276457815818},{longitude:112.7044853051658,latitude:-7.301757087547525},{longitude:112.7012051588692,latitude:-7.302336144634579},{longitude:112.6989709116629,latitude:-7.302418654388641},{longitude:112.6973803528144,latitude:-7.301929948475352},{longitude:112.6967845062267,latitude:-7.300027264025622},{longitude:112.695825774963,latitude:-7.301693343436149},{longitude:112.6918139452141,latitude:-7.30020538010747},{longitude:112.6890664712941,latitude:-7.299307045733184},{longitude:112.6867227024514,latitude:-7.300844161374966},{longitude:112.6828591453091,latitude:-7.301739236795316},{longitude:112.6843181088063,latitude:-7.299117512031792},{longitude:112.6774684455093,latitude:-7.295903249555619},{longitude:112.6773001205676,latitude:-7.294704671987704},{longitude:112.6756242749158,latitude:-7.294442696428948},{longitude:112.6772877062474,latitude:-7.289110567180958},{longitude:112.6786706576823,latitude:-7.288061277954573},{longitude:112.6787328247716,latitude:-7.287331646702671},{longitude:112.6778265105122,latitude:-7.286541391501075},{longitude:112.6784246267776,latitude:-7.283946715442249},{longitude:112.6755365654174,latitude:-7.283260328113416},{longitude:112.6753380908601,latitude:-7.285138626660615},{longitude:112.6763053989244,latitude:-7.285255519805789},{longitude:112.6757405815949,latitude:-7.286926863748082},{longitude:112.673928066705,latitude:-7.286590145494304},{longitude:112.6725650043561,latitude:-7.289688541400707},{longitude:112.6717765986632,latitude:-7.289468231568177},{longitude:112.6715100929385,latitude:-7.293324636180119},{longitude:112.6752422011004,latitude:-7.294583151805501},{longitude:112.6752596247449,latitude:-7.298462305689998},{longitude:112.6741292714209,latitude:-7.300159293567547},{longitude:112.6735875134741,latitude:-7.301769808005935},{longitude:112.6745108985696,latitude:-7.303340066020923},{longitude:112.6739923266603,latitude:-7.308725674907805},{longitude:112.6728483972473,latitude:-7.314339980628815},{longitude:112.6723206050066,latitude:-7.317311898925556},{longitude:112.677647574293,latitude:-7.318696126912785},{longitude:112.6757365130344,latitude:-7.326871256140711},{longitude:112.6725916126785,latitude:-7.328315214144894},{longitude:112.6685183779763,latitude:-7.332134815135598},{longitude:112.6697218474434,latitude:-7.333445640456645},{longitude:112.673245335315,latitude:-7.333698734102039},{longitude:112.680155159849,latitude:-7.32954346123333},{longitude:112.6955511309066,latitude:-7.333767546052505},{longitude:112.6961969741723,latitude:-7.330821586695436},{longitude:112.6953946840515,latitude:-7.330391555205065},{longitude:112.6953510629504,latitude:-7.329476783036608},{longitude:112.6947553473837,latitude:-7.328636998310576},{longitude:112.6953362867257,latitude:-7.326146464582036},{longitude:112.6925958044187,latitude:-7.325263687176324},{longitude:112.6926222321559,latitude:-7.324413501687128},{longitude:112.6913376725432,latitude:-7.32412463008707},{longitude:112.6911536898647,latitude:-7.324975717349349},{longitude:112.6903336560581,latitude:-7.324715578296825},{longitude:112.6907750749694,latitude:-7.322573901150176},{longitude:112.6975164430547,latitude:-7.323905297378656},{longitude:112.6982500484008,latitude:-7.32186732145038},{longitude:112.6990115992258,latitude:-7.322238515186531},{longitude:112.6994700963828,latitude:-7.319440792837757},{longitude:112.7017396832619,latitude:-7.315182332851236},{longitude:112.7051879955366,latitude:-7.312967075009331},{longitude:112.7117020499643,latitude:-7.312920652004755},{longitude:112.7119192529119,latitude:-7.310377981578519},{longitude:112.712922383538,latitude:-7.308704146997905},{longitude:112.7144843628271,latitude:-7.307931240974797}]','2017-12-09 05:42:56','2017-12-09 05:43:00'),(22,'Polsek Wonocolo','polrestabessurabaya@gmail.com',3578,'Jl. Margorejo Indah XIX/1','60239','0318416502','umlah penduduk : 81.660 jiwa\r\nLuas wilayah : 6,78 km2\r\n\r\nKelurahan\r\n1. Kelurahan Sidosermo\r\n2. Kelurahan Bendulmerisi\r\n3. Kelurahan Margorejo\r\n4. Kelurahan Jemur Wonosari\r\n5. Kelurahan Siwalan Kerto\r\n\r\nKompol Budi Nurtjahjo, S.H., M.Kn\r\nKapolsek Wonocolo\r\n\r\n\r\n',-7.316,112.753,'[{longitude:112.7294381772395,latitude:-7.337237353449988},{longitude:112.7293980118616,latitude:-7.339585481349536},{longitude:112.7378228896569,latitude:-7.34052121387988},{longitude:112.7374442935695,latitude:-7.344777370061242},{longitude:112.7419251392473,latitude:-7.345216664437127},{longitude:112.7429470532708,latitude:-7.340850730531862},{longitude:112.742060466612,latitude:-7.340633737610086},{longitude:112.7426109668101,latitude:-7.334328341724036},{longitude:112.7434248001623,latitude:-7.330117120507596},{longitude:112.743737734517,latitude:-7.322928437164515},{longitude:112.7469012505803,latitude:-7.3234234531906},{longitude:112.746942261242,latitude:-7.322308838599214},{longitude:112.7458151850383,latitude:-7.320942960220141},{longitude:112.74819263273,latitude:-7.31961774365377},{longitude:112.747399555261,latitude:-7.31882896549044},{longitude:112.7482349786438,latitude:-7.317294031354702},{longitude:112.7507824184344,latitude:-7.317875983075638},{longitude:112.7536751934792,latitude:-7.315667277855057},{longitude:112.753090289436,latitude:-7.315375643905527},{longitude:112.7533570575477,latitude:-7.311318077183873},{longitude:112.7551589357825,latitude:-7.311821320222813},{longitude:112.7555826677251,latitude:-7.311024534846174},{longitude:112.7567148364595,latitude:-7.311192432052449},{longitude:112.7561662176145,latitude:-7.311695894330327},{longitude:112.7566667349803,latitude:-7.312115447823802},{longitude:112.759601973237,latitude:-7.308905951596843},{longitude:112.7587134785267,latitude:-7.308818676641486},{longitude:112.7591981075268,latitude:-7.305791557163409},{longitude:112.7569501048883,latitude:-7.305246630655111},{longitude:112.7564319403619,latitude:-7.306389166770613},{longitude:112.7419119062616,latitude:-7.305933986706792},{longitude:112.7403563065076,latitude:-7.311193440107842},{longitude:112.7393193103753,latitude:-7.310963862052239},{longitude:112.7392040842258,latitude:-7.312106758022031},{longitude:112.7349368338752,latitude:-7.311064733695542},{longitude:112.7294381772395,latitude:-7.337237353449988}]','2017-12-09 05:48:30','2017-12-09 05:48:33'),(23,'Polsek Gayungan','polrestabessurabaya@gmail.com',3578,'Jl. Gayungsari VI No 16-18','60235','0318292903','Jumlah penduduk : 39.830 jiwa\r\nLuas wilayah : 6,07 km2\r\n\r\nKelurahan\r\n1. Kelurahan Dukuh Menanggal\r\n2. Kelurahan Gayungan\r\n3. Kelurahan Ketintang\r\n4. Kelurahan Menanggal\r\n\r\nKapolsek Gayungan\r\nKompol Lukito',-7.3328,112.724,'[{longitude:112.7304805569359,latitude:-7.309620005133486},{longitude:112.7298296125182,latitude:-7.309998289755324},{longitude:112.7241112669562,latitude:-7.307653488127758},{longitude:112.72256640561,latitude:-7.316402851144057},{longitude:112.726412261394,latitude:-7.317611212603985},{longitude:112.7182170222742,latitude:-7.328553083257817},{longitude:112.7198592185645,latitude:-7.328802133554292},{longitude:112.7187838908352,latitude:-7.335572241742868},{longitude:112.7167364816078,latitude:-7.33540886056548},{longitude:112.7165277490123,latitude:-7.338287399124007},{longitude:112.7178723074049,latitude:-7.338504682380413},{longitude:112.7175352034098,latitude:-7.340392354791145},{longitude:112.7161360109707,latitude:-7.339908314608606},{longitude:112.7157452457134,latitude:-7.34167810238111},{longitude:112.7200865401313,latitude:-7.343067629883978},{longitude:112.7196819170581,latitude:-7.344450356516349},{longitude:112.7242654220291,latitude:-7.34588317313618},{longitude:112.724327815656,latitude:-7.346834393598184},{longitude:112.7258737701524,latitude:-7.348256300821915},{longitude:112.7292018620175,latitude:-7.348308935053074},{longitude:112.7331646294838,latitude:-7.348095688395095},{longitude:112.7335398722105,latitude:-7.346619282762767},{longitude:112.7363475992012,latitude:-7.346357678132768},{longitude:112.7366252348773,latitude:-7.344872811505048},{longitude:112.737421916664,latitude:-7.344767754435215},{longitude:112.7378055344861,latitude:-7.340531687449269},{longitude:112.7293721930921,latitude:-7.339592072117169},{longitude:112.7294368419556,latitude:-7.337324719698013},{longitude:112.7303034950239,latitude:-7.3332702461973},{longitude:112.7350456529801,latitude:-7.310466505035189},{longitude:112.7304805569359,latitude:-7.309620005133486}]','2017-12-16 05:55:05','2017-12-09 05:55:09'),(24,'Polsek Jambangan','polsek_jambangan@yahoo.co.id',3578,'Jl. Karah Agung No. 23 Jambangan','60232','0318298603','Jumlah penduduk : 39.230 jiwa\r\nLuas wilayah : 4,19 km2\r\n\r\nKelurahan\r\n1. Kelurahan Pagesangan\r\n2. Kelurahan Kebon Sari\r\n3. Kelurahan Jambangan\r\n4. Kelurahan Karah\r\n\r\nKapolsek Gayungan\r\nKompol Gatot Hariyanto, S.H',-7.31315,112.718,'[{longitude:112.7184991313901,latitude:-7.308316661413909},{longitude:112.7144843029613,latitude:-7.307927732587644},{longitude:112.7129206135277,latitude:-7.308709179726542},{longitude:112.7119083316772,latitude:-7.310373570566306},{longitude:112.7115871695308,latitude:-7.314410347848755},{longitude:112.711520041259,latitude:-7.31858576006384},{longitude:112.7108451592258,latitude:-7.320237744418893},{longitude:112.7104527113457,latitude:-7.322815948880069},{longitude:112.7106117950637,latitude:-7.328864577783818},{longitude:112.708180050607,latitude:-7.331648106644752},{longitude:112.7047856259005,latitude:-7.336224288882343},{longitude:112.7080150721918,latitude:-7.337507359135302},{longitude:112.7175191496039,latitude:-7.34035689720592},{longitude:112.7178834163137,latitude:-7.338540268493272},{longitude:112.7165351355136,latitude:-7.338298265665424},{longitude:112.7167085680488,latitude:-7.335390755751921},{longitude:112.7187781488526,latitude:-7.335559853303243},{longitude:112.7198562078877,latitude:-7.328806260032231},{longitude:112.7182858044321,latitude:-7.32851403435286},{longitude:112.7264099575372,latitude:-7.317612999221642},{longitude:112.722562984974,latitude:-7.316406636460086},{longitude:112.7241174237072,latitude:-7.307642339629179},{longitude:112.7184991313901,latitude:-7.308316661413909}]','2017-12-09 05:57:40','2017-12-09 05:57:43');
/*Table structure for table `kategori_kriminalitas` */
DROP TABLE IF EXISTS `kategori_kriminalitas`;
CREATE TABLE `kategori_kriminalitas` (
`id` tinyint(4) NOT NULL AUTO_INCREMENT,
`nama` varchar(100) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=latin1;
/*Data for the table `kategori_kriminalitas` */
insert into `kategori_kriminalitas`(`id`,`nama`) values (13,'Nyawa'),(14,'Fisik/Badan'),(15,'Kesusilaan'),(17,'Kemerdekaan Orang '),(18,'Hak Milik/Barang (Kekerasan) '),(19,'Hak Milik/Barang'),(20,'Narkotika '),(21,'Penipuan, Penggelapan dan Korupsi '),(22,'Ketertiban Umum ');
/*Table structure for table `kota` */
DROP TABLE IF EXISTS `kota`;
CREATE TABLE `kota` (
`id` int(11) NOT NULL,
`nama` varchar(50) DEFAULT NULL,
`id_provinsi` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `fk_provinsi` (`id_provinsi`),
CONSTRAINT `fk_provinsi` FOREIGN KEY (`id_provinsi`) REFERENCES `provinsi` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table `kota` */
insert into `kota`(`id`,`nama`,`id_provinsi`) values (1101,'KABUPATEN SIMEULUE',11),(1102,'KABUPATEN ACEH SINGKIL',11),(1103,'KABUPATEN ACEH SELATAN',11),(1104,'KABUPATEN ACEH TENGGARA',11),(1105,'KABUPATEN ACEH TIMUR',11),(1106,'KABUPATEN ACEH TENGAH',11),(1107,'KABUPATEN ACEH BARAT',11),(1108,'KABUPATEN ACEH BESAR',11),(1109,'KABUPATEN PIDIE',11),(1110,'KABUPATEN BIREUEN',11),(1111,'KABUPATEN ACEH UTARA',11),(1112,'KABUPATEN ACEH BARAT DAYA',11),(1113,'KABUPATEN GAYO LUES',11),(1114,'KABUPATEN ACEH TAMIANG',11),(1115,'KABUPATEN NAGAN RAYA',11),(1116,'KABUPATEN ACEH JAYA',11),(1117,'KABUPATEN BENER MERIAH',11),(1118,'KABUPATEN PIDIE JAYA',11),(1171,'KOTA BANDA ACEH',11),(1172,'KOTA SABANG',11),(1173,'KOTA LANGSA',11),(1174,'KOTA LHOKSEUMAWE',11),(1175,'KOTA SUBULUSSALAM',11),(1201,'KABUPATEN NIAS',12),(1202,'KABUPATEN MANDAILING NATAL',12),(1203,'KABUPATEN TAPANULI SELATAN',12),(1204,'KABUPATEN TAPANULI TENGAH',12),(1205,'KABUPATEN TAPANULI UTARA',12),(1206,'KABUPATEN TOBA SAMOSIR',12),(1207,'KABUPATEN LABUHAN BATU',12),(1208,'KABUPATEN ASAHAN',12),(1209,'KABUPATEN SIMALUNGUN',12),(1210,'KABUPATEN DAIRI',12),(1211,'KABUPATEN KARO',12),(1212,'KABUPATEN DELI SERDANG',12),(1213,'KABUPATEN LANGKAT',12),(1214,'KABUPATEN NIAS SELATAN',12),(1215,'KABUPATEN HUMBANG HASUNDUTAN',12),(1216,'KABUPATEN PAKPAK BHARAT',12),(1217,'KABUPATEN SAMOSIR',12),(1218,'KABUPATEN SERDANG BEDAGAI',12),(1219,'KABUPATEN BATU BARA',12),(1220,'KABUPATEN PADANG LAWAS UTARA',12),(1221,'KABUPATEN PADANG LAWAS',12),(1222,'KABUPATEN LABUHAN BATU SELATAN',12),(1223,'KABUPATEN LABUHAN BATU UTARA',12),(1224,'KABUPATEN NIAS UTARA',12),(1225,'KABUPATEN NIAS BARAT',12),(1271,'KOTA SIBOLGA',12),(1272,'KOTA TANJUNG BALAI',12),(1273,'KOTA PEMATANG SIANTAR',12),(1274,'KOTA TEBING TINGGI',12),(1275,'KOTA MEDAN',12),(1276,'KOTA BINJAI',12),(1277,'KOTA PADANGSIDIMPUAN',12),(1278,'KOTA GUNUNGSITOLI',12),(1301,'KABUPATEN KEPULAUAN MENTAWAI',13),(1302,'KABUPATEN PESISIR SELATAN',13),(1303,'KABUPATEN SOLOK',13),(1304,'KABUPATEN SIJUNJUNG',13),(1305,'KABUPATEN TANAH DATAR',13),(1306,'KABUPATEN PADANG PARIAMAN',13),(1307,'KABUPATEN AGAM',13),(1308,'KABUPATEN LIMA PULUH KOTA',13),(1309,'KABUPATEN PASAMAN',13),(1310,'KABUPATEN SOLOK SELATAN',13),(1311,'KABUPATEN DHARMASRAYA',13),(1312,'KABUPATEN PASAMAN BARAT',13),(1371,'KOTA PADANG',13),(1372,'KOTA SOLOK',13),(1373,'KOTA SAWAH LUNTO',13),(1374,'KOTA PADANG PANJANG',13),(1375,'KOTA BUKITTINGGI',13),(1376,'KOTA PAYAKUMBUH',13),(1377,'KOTA PARIAMAN',13),(1401,'KABUPATEN KUANTAN SINGINGI',14),(1402,'KABUPATEN INDRAGIRI HULU',14),(1403,'KABUPATEN INDRAGIRI HILIR',14),(1404,'KABUPATEN PELALAWAN',14),(1405,'KABUPATEN S I A K',14),(1406,'KABUPATEN KAMPAR',14),(1407,'KABUPATEN ROKAN HULU',14),(1408,'KABUPATEN BENGKALIS',14),(1409,'KABUPATEN ROKAN HILIR',14),(1410,'KABUPATEN KEPULAUAN MERANTI',14),(1471,'KOTA PEKANBARU',14),(1473,'KOTA D U M A I',14),(1501,'KABUPATEN KERINCI',15),(1502,'KABUPATEN MERANGIN',15),(1503,'KABUPATEN SAROLANGUN',15),(1504,'KABUPATEN BATANG HARI',15),(1505,'KABUPATEN MUARO JAMBI',15),(1506,'KABUPATEN TANJUNG JABUNG TIMUR',15),(1507,'KABUPATEN TANJUNG JABUNG BARAT',15),(1508,'KABUPATEN TEBO',15),(1509,'KABUPATEN BUNGO',15),(1571,'KOTA JAMBI',15),(1572,'KOTA SUNGAI PENUH',15),(1601,'KABUPATEN OGAN KOMERING ULU',16),(1602,'KABUPATEN OGAN KOMERING ILIR',16),(1603,'KABUPATEN MUARA ENIM',16),(1604,'KABUPATEN LAHAT',16),(1605,'KABUPATEN MUSI RAWAS',16),(1606,'KABUPATEN MUSI BANYUASIN',16),(1607,'KABUPATEN BANYU ASIN',16),(1608,'KABUPATEN OGAN KOMERING ULU SELATAN',16),(1609,'KABUPATEN OGAN KOMERING ULU TIMUR',16),(1610,'KABUPATEN OGAN ILIR',16),(1611,'KABUPATEN EMPAT LAWANG',16),(1612,'KABUPATEN PENUKAL ABAB LEMATANG ILIR',16),(1613,'KABUPATEN MUSI RAWAS UTARA',16),(1671,'KOTA PALEMBANG',16),(1672,'KOTA PRABUMULIH',16),(1673,'KOTA PAGAR ALAM',16),(1674,'KOTA LUBUKLINGGAU',16),(1701,'KABUPATEN BENGKULU SELATAN',17),(1702,'KABUPATEN REJANG LEBONG',17),(1703,'KABUPATEN BENGKULU UTARA',17),(1704,'KABUPATEN KAUR',17),(1705,'KABUPATEN SELUMA',17),(1706,'KABUPATEN MUKOMUKO',17),(1707,'KABUPATEN LEBONG',17),(1708,'KABUPATEN KEPAHIANG',17),(1709,'KABUPATEN BENGKULU TENGAH',17),(1771,'KOTA BENGKULU',17),(1801,'KABUPATEN LAMPUNG BARAT',18),(1802,'KABUPATEN TANGGAMUS',18),(1803,'KABUPATEN LAMPUNG SELATAN',18),(1804,'KABUPATEN LAMPUNG TIMUR',18),(1805,'KABUPATEN LAMPUNG TENGAH',18),(1806,'KABUPATEN LAMPUNG UTARA',18),(1807,'KABUPATEN WAY KANAN',18),(1808,'KABUPATEN TULANGBAWANG',18),(1809,'KABUPATEN PESAWARAN',18),(1810,'KABUPATEN PRINGSEWU',18),(1811,'KABUPATEN MESUJI',18),(1812,'KABUPATEN TULANG BAWANG BARAT',18),(1813,'KABUPATEN PESISIR BARAT',18),(1871,'KOTA BANDAR LAMPUNG',18),(1872,'KOTA METRO',18),(1901,'KABUPATEN BANGKA',19),(1902,'KABUPATEN BELITUNG',19),(1903,'KABUPATEN BANGKA BARAT',19),(1904,'KABUPATEN BANGKA TENGAH',19),(1905,'KABUPATEN BANGKA SELATAN',19),(1906,'KABUPATEN BELITUNG TIMUR',19),(1971,'KOTA PANGKAL PINANG',19),(2101,'KABUPATEN KARIMUN',21),(2102,'KABUPATEN BINTAN',21),(2103,'KABUPATEN NATUNA',21),(2104,'KABUPATEN LINGGA',21),(2105,'KABUPATEN KEPULAUAN ANAMBAS',21),(2171,'KOTA B A T A M',21),(2172,'KOTA TANJUNG PINANG',21),(3101,'KABUPATEN KEPULAUAN SERIBU',31),(3171,'KOTA JAKARTA SELATAN',31),(3172,'KOTA JAKARTA TIMUR',31),(3173,'KOTA JAKARTA PUSAT',31),(3174,'KOTA JAKARTA BARAT',31),(3175,'KOTA JAKARTA UTARA',31),(3201,'KABUPATEN BOGOR',32),(3202,'KABUPATEN SUKABUMI',32),(3203,'KABUPATEN CIANJUR',32),(3204,'KABUPATEN BANDUNG',32),(3205,'KABUPATEN GARUT',32),(3206,'KABUPATEN TASIKMALAYA',32),(3207,'KABUPATEN CIAMIS',32),(3208,'KABUPATEN KUNINGAN',32),(3209,'KABUPATEN CIREBON',32),(3210,'KABUPATEN MAJALENGKA',32),(3211,'KABUPATEN SUMEDANG',32),(3212,'KABUPATEN INDRAMAYU',32),(3213,'KABUPATEN SUBANG',32),(3214,'KABUPATEN PURWAKARTA',32),(3215,'KABUPATEN KARAWANG',32),(3216,'KABUPATEN BEKASI',32),(3217,'KABUPATEN BANDUNG BARAT',32),(3218,'KABUPATEN PANGANDARAN',32),(3271,'KOTA BOGOR',32),(3272,'KOTA SUKABUMI',32),(3273,'KOTA BANDUNG',32),(3274,'KOTA CIREBON',32),(3275,'KOTA BEKASI',32),(3276,'KOTA DEPOK',32),(3277,'KOTA CIMAHI',32),(3278,'KOTA TASIKMALAYA',32),(3279,'KOTA BANJAR',32),(3301,'KABUPATEN CILACAP',33),(3302,'KABUPATEN BANYUMAS',33),(3303,'KABUPATEN PURBALINGGA',33),(3304,'KABUPATEN BANJARNEGARA',33),(3305,'KABUPATEN KEBUMEN',33),(3306,'KABUPATEN PURWOREJO',33),(3307,'KABUPATEN WONOSOBO',33),(3308,'KABUPATEN MAGELANG',33),(3309,'KABUPATEN BOYOLALI',33),(3310,'KABUPATEN KLATEN',33),(3311,'KABUPATEN SUKOHARJO',33),(3312,'KABUPATEN WONOGIRI',33),(3313,'KABUPATEN KARANGANYAR',33),(3314,'KABUPATEN SRAGEN',33),(3315,'KABUPATEN GROBOGAN',33),(3316,'KABUPATEN BLORA',33),(3317,'KABUPATEN REMBANG',33),(3318,'KABUPATEN PATI',33),(3319,'KABUPATEN KUDUS',33),(3320,'KABUPATEN JEPARA',33),(3321,'KABUPATEN DEMAK',33),(3322,'KABUPATEN SEMARANG',33),(3323,'KABUPATEN TEMANGGUNG',33),(3324,'KABUPATEN KENDAL',33),(3325,'KABUPATEN BATANG',33),(3326,'KABUPATEN PEKALONGAN',33),(3327,'KABUPATEN PEMALANG',33),(3328,'KABUPATEN TEGAL',33),(3329,'KABUPATEN BREBES',33),(3371,'KOTA MAGELANG',33),(3372,'KOTA SURAKARTA',33),(3373,'KOTA SALATIGA',33),(3374,'KOTA SEMARANG',33),(3375,'KOTA PEKALONGAN',33),(3376,'KOTA TEGAL',33),(3401,'KABUPATEN KULON PROGO',34),(3402,'KABUPATEN BANTUL',34),(3403,'KABUPATEN GUNUNG KIDUL',34),(3404,'KABUPATEN SLEMAN',34),(3471,'KOTA YOGYAKARTA',34),(3501,'KABUPATEN PACITAN',35),(3502,'KABUPATEN PONOROGO',35),(3503,'KABUPATEN TRENGGALEK',35),(3504,'KABUPATEN TULUNGAGUNG',35),(3505,'KABUPATEN BLITAR',35),(3506,'KABUPATEN KEDIRI',35),(3507,'KABUPATEN MALANG',35),(3508,'KABUPATEN LUMAJANG',35),(3509,'KABUPATEN JEMBER',35),(3510,'KABUPATEN BANYUWANGI',35),(3511,'KABUPATEN BONDOWOSO',35),(3512,'KABUPATEN SITUBONDO',35),(3513,'KABUPATEN PROBOLINGGO',35),(3514,'KABUPATEN PASURUAN',35),(3515,'KABUPATEN SIDOARJO',35),(3516,'KABUPATEN MOJOKERTO',35),(3517,'KABUPATEN JOMBANG',35),(3518,'KABUPATEN NGANJUK',35),(3519,'KABUPATEN MADIUN',35),(3520,'KABUPATEN MAGETAN',35),(3521,'KABUPATEN NGAWI',35),(3522,'KABUPATEN BOJONEGORO',35),(3523,'KABUPATEN TUBAN',35),(3524,'KABUPATEN LAMONGAN',35),(3525,'KABUPATEN GRESIK',35),(3526,'KABUPATEN BANGKALAN',35),(3527,'KABUPATEN SAMPANG',35),(3528,'KABUPATEN PAMEKASAN',35),(3529,'KABUPATEN SUMENEP',35),(3571,'KOTA KEDIRI',35),(3572,'KOTA BLITAR',35),(3573,'KOTA MALANG',35),(3574,'KOTA PROBOLINGGO',35),(3575,'KOTA PASURUAN',35),(3576,'KOTA MOJOKERTO',35),(3577,'KOTA MADIUN',35),(3578,'KOTA SURABAYA',35),(3579,'KOTA BATU',35),(3601,'KABUPATEN PANDEGLANG',36),(3602,'KABUPATEN LEBAK',36),(3603,'KABUPATEN TANGERANG',36),(3604,'KABUPATEN SERANG',36),(3671,'KOTA TANGERANG',36),(3672,'KOTA CILEGON',36),(3673,'KOTA SERANG',36),(3674,'KOTA TANGERANG SELATAN',36),(5101,'KABUPATEN JEMBRANA',51),(5102,'KABUPATEN TABANAN',51),(5103,'KABUPATEN BADUNG',51),(5104,'KABUPATEN GIANYAR',51),(5105,'KABUPATEN KLUNGKUNG',51),(5106,'KABUPATEN BANGLI',51),(5107,'KABUPATEN KARANG ASEM',51),(5108,'KABUPATEN BULELENG',51),(5171,'KOTA DENPASAR',51),(5201,'KABUPATEN LOMBOK BARAT',52),(5202,'KABUPATEN LOMBOK TENGAH',52),(5203,'KABUPATEN LOMBOK TIMUR',52),(5204,'KABUPATEN SUMBAWA',52),(5205,'KABUPATEN DOMPU',52),(5206,'KABUPATEN BIMA',52),(5207,'KABUPATEN SUMBAWA BARAT',52),(5208,'KABUPATEN LOMBOK UTARA',52),(5271,'KOTA MATARAM',52),(5272,'KOTA BIMA',52),(5301,'KABUPATEN SUMBA BARAT',53),(5302,'KABUPATEN SUMBA TIMUR',53),(5303,'KABUPATEN KUPANG',53),(5304,'KABUPATEN TIMOR TENGAH SELATAN',53),(5305,'KABUPATEN TIMOR TENGAH UTARA',53),(5306,'KABUPATEN BELU',53),(5307,'KABUPATEN ALOR',53),(5308,'KABUPATEN LEMBATA',53),(5309,'KABUPATEN FLORES TIMUR',53),(5310,'KABUPATEN SIKKA',53),(5311,'KABUPATEN ENDE',53),(5312,'KABUPATEN NGADA',53),(5313,'KABUPATEN MANGGARAI',53),(5314,'KABUPATEN ROTE NDAO',53),(5315,'KABUPATEN MANGGARAI BARAT',53),(5316,'KABUPATEN SUMBA TENGAH',53),(5317,'KABUPATEN SUMBA BARAT DAYA',53),(5318,'KABUPATEN NAGEKEO',53),(5319,'KABUPATEN MANGGARAI TIMUR',53),(5320,'KABUPATEN SABU RAIJUA',53),(5321,'KABUPATEN MALAKA',53),(5371,'KOTA KUPANG',53),(6101,'KABUPATEN SAMBAS',61),(6102,'KABUPATEN BENGKAYANG',61),(6103,'KABUPATEN LANDAK',61),(6104,'KABUPATEN MEMPAWAH',61),(6105,'KABUPATEN SANGGAU',61),(6106,'KABUPATEN KETAPANG',61),(6107,'KABUPATEN SINTANG',61),(6108,'KABUPATEN KAPUAS HULU',61),(6109,'KABUPATEN SEKADAU',61),(6110,'KABUPATEN MELAWI',61),(6111,'KABUPATEN KAYONG UTARA',61),(6112,'KABUPATEN KUBU RAYA',61),(6171,'KOTA PONTIANAK',61),(6172,'KOTA SINGKAWANG',61),(6201,'KABUPATEN KOTAWARINGIN BARAT',62),(6202,'KABUPATEN KOTAWARINGIN TIMUR',62),(6203,'KABUPATEN KAPUAS',62),(6204,'KABUPATEN BARITO SELATAN',62),(6205,'KABUPATEN BARITO UTARA',62),(6206,'KABUPATEN SUKAMARA',62),(6207,'KABUPATEN LAMANDAU',62),(6208,'KABUPATEN SERUYAN',62),(6209,'KABUPATEN KATINGAN',62),(6210,'KABUPATEN PULANG PISAU',62),(6211,'KABUPATEN GUNUNG MAS',62),(6212,'KABUPATEN BARITO TIMUR',62),(6213,'KABUPATEN MURUNG RAYA',62),(6271,'KOTA PALANGKA RAYA',62),(6301,'KABUPATEN TANAH LAUT',63),(6302,'KABUPATEN KOTA BARU',63),(6303,'KABUPATEN BANJAR',63),(6304,'KABUPATEN BARITO KUALA',63),(6305,'KABUPATEN TAPIN',63),(6306,'KABUPATEN HULU SUNGAI SELATAN',63),(6307,'KABUPATEN HULU SUNGAI TENGAH',63),(6308,'KABUPATEN HULU SUNGAI UTARA',63),(6309,'KABUPATEN TABALONG',63),(6310,'KABUPATEN TANAH BUMBU',63),(6311,'KABUPATEN BALANGAN',63),(6371,'KOTA BANJARMASIN',63),(6372,'KOTA BANJAR BARU',63),(6401,'KABUPATEN PASER',64),(6402,'KABUPATEN KUTAI BARAT',64),(6403,'KABUPATEN KUTAI KARTANEGARA',64),(6404,'KABUPATEN KUTAI TIMUR',64),(6405,'KABUPATEN BERAU',64),(6409,'KABUPATEN PENAJAM PASER UTARA',64),(6411,'KABUPATEN MAHAKAM HULU',64),(6471,'KOTA BALIKPAPAN',64),(6472,'KOTA SAMARINDA',64),(6474,'KOTA BONTANG',64),(6501,'KABUPATEN MALINAU',65),(6502,'KABUPATEN BULUNGAN',65),(6503,'KABUPATEN TANA TIDUNG',65),(6504,'KABUPATEN NUNUKAN',65),(6571,'KOTA TARAKAN',65),(7101,'KABUPATEN BOLAANG MONGONDOW',71),(7102,'KABUPATEN MINAHASA',71),(7103,'KABUPATEN KEPULAUAN SANGIHE',71),(7104,'KABUPATEN KEPULAUAN TALAUD',71),(7105,'KABUPATEN MINAHASA SELATAN',71),(7106,'KABUPATEN MINAHASA UTARA',71),(7107,'KABUPATEN BOLAANG MONGONDOW UTARA',71),(7108,'KABUPATEN SIAU TAGULANDANG BIARO',71),(7109,'KABUPATEN MINAHASA TENGGARA',71),(7110,'KABUPATEN BOLAANG MONGONDOW SELATAN',71),(7111,'KABUPATEN BOLAANG MONGONDOW TIMUR',71),(7171,'KOTA MANADO',71),(7172,'KOTA BITUNG',71),(7173,'KOTA TOMOHON',71),(7174,'KOTA KOTAMOBAGU',71),(7201,'KABUPATEN BANGGAI KEPULAUAN',72),(7202,'KABUPATEN BANGGAI',72),(7203,'KABUPATEN MOROWALI',72),(7204,'KABUPATEN POSO',72),(7205,'KABUPATEN DONGGALA',72),(7206,'KABUPATEN TOLI-TOLI',72),(7207,'KABUPATEN BUOL',72),(7208,'KABUPATEN PARIGI MOUTONG',72),(7209,'KABUPATEN TOJO UNA-UNA',72),(7210,'KABUPATEN SIGI',72),(7211,'KABUPATEN BANGGAI LAUT',72),(7212,'KABUPATEN MOROWALI UTARA',72),(7271,'KOTA PALU',72),(7301,'KABUPATEN KEPULAUAN SELAYAR',73),(7302,'KABUPATEN BULUKUMBA',73),(7303,'KABUPATEN BANTAENG',73),(7304,'KABUPATEN JENEPONTO',73),(7305,'KABUPATEN TAKALAR',73),(7306,'KABUPATEN GOWA',73),(7307,'KABUPATEN SINJAI',73),(7308,'KABUPATEN MAROS',73),(7309,'KABUPATEN PANGKAJENE DAN KEPULAUAN',73),(7310,'KABUPATEN BARRU',73),(7311,'KABUPATEN BONE',73),(7312,'KABUPATEN SOPPENG',73),(7313,'KABUPATEN WAJO',73),(7314,'KABUPATEN SIDENRENG RAPPANG',73),(7315,'KABUPATEN PINRANG',73),(7316,'KABUPATEN ENREKANG',73),(7317,'KABUPATEN LUWU',73),(7318,'KABUPATEN TANA TORAJA',73),(7322,'KABUPATEN LUWU UTARA',73),(7325,'KABUPATEN LUWU TIMUR',73),(7326,'KABUPATEN TORAJA UTARA',73),(7371,'KOTA MAKASSAR',73),(7372,'KOTA PAREPARE',73),(7373,'KOTA PALOPO',73),(7401,'KABUPATEN BUTON',74),(7402,'KABUPATEN MUNA',74),(7403,'KABUPATEN KONAWE',74),(7404,'KABUPATEN KOLAKA',74),(7405,'KABUPATEN KONAWE SELATAN',74),(7406,'KABUPATEN BOMBANA',74),(7407,'KABUPATEN WAKATOBI',74),(7408,'KABUPATEN KOLAKA UTARA',74),(7409,'KABUPATEN BUTON UTARA',74),(7410,'KABUPATEN KONAWE UTARA',74),(7411,'KABUPATEN KOLAKA TIMUR',74),(7412,'KABUPATEN KONAWE KEPULAUAN',74),(7413,'KABUPATEN MUNA BARAT',74),(7414,'KABUPATEN BUTON TENGAH',74),(7415,'KABUPATEN BUTON SELATAN',74),(7471,'KOTA KENDARI',74),(7472,'KOTA BAUBAU',74),(7501,'KABUPATEN BOALEMO',75),(7502,'KABUPATEN GORONTALO',75),(7503,'KABUPATEN POHUWATO',75),(7504,'KABUPATEN BONE BOLANGO',75),(7505,'KABUPATEN GORONTALO UTARA',75),(7571,'KOTA GORONTALO',75),(7601,'KABUPATEN MAJENE',76),(7602,'KABUPATEN POLEWALI MANDAR',76),(7603,'KABUPATEN MAMASA',76),(7604,'KABUPATEN MAMUJU',76),(7605,'KABUPATEN MAMUJU UTARA',76),(7606,'KABUPATEN MAMUJU TENGAH',76),(8101,'KABUPATEN MALUKU TENGGARA BARAT',81),(8102,'KABUPATEN MALUKU TENGGARA',81),(8103,'KABUPATEN MALUKU TENGAH',81),(8104,'KABUPATEN BURU',81),(8105,'KABUPATEN KEPULAUAN ARU',81),(8106,'KABUPATEN SERAM BAGIAN BARAT',81),(8107,'KABUPATEN SERAM BAGIAN TIMUR',81),(8108,'KABUPATEN MALUKU BARAT DAYA',81),(8109,'KABUPATEN BURU SELATAN',81),(8171,'KOTA AMBON',81),(8172,'KOTA TUAL',81),(8201,'KABUPATEN HALMAHERA BARAT',82),(8202,'KABUPATEN HALMAHERA TENGAH',82),(8203,'KABUPATEN KEPULAUAN SULA',82),(8204,'KABUPATEN HALMAHERA SELATAN',82),(8205,'KABUPATEN HALMAHERA UTARA',82),(8206,'KABUPATEN HALMAHERA TIMUR',82),(8207,'KABUPATEN PULAU MOROTAI',82),(8208,'KABUPATEN PULAU TALIABU',82),(8271,'KOTA TERNATE',82),(8272,'KOTA TIDORE KEPULAUAN',82),(9101,'KABUPATEN FAKFAK',91),(9102,'KABUPATEN KAIMANA',91),(9103,'KABUPATEN TELUK WONDAMA',91),(9104,'KABUPATEN TELUK BINTUNI',91),(9105,'KABUPATEN MANOKWARI',91),(9106,'KABUPATEN SORONG SELATAN',91),(9107,'KABUPATEN SORONG',91),(9108,'KABUPATEN RAJA AMPAT',91),(9109,'KABUPATEN TAMBRAUW',91),(9110,'KABUPATEN MAYBRAT',91),(9111,'KABUPATEN MANOKWARI SELATAN',91),(9112,'KABUPATEN PEGUNUNGAN ARFAK',91),(9171,'KOTA SORONG',91),(9401,'KABUPATEN MERAUKE',94),(9402,'KABUPATEN JAYAWIJAYA',94),(9403,'KABUPATEN JAYAPURA',94),(9404,'KABUPATEN NABIRE',94),(9408,'KABUPATEN KEPULAUAN YAPEN',94),(9409,'KABUPATEN BIAK NUMFOR',94),(9410,'KABUPATEN PANIAI',94),(9411,'KABUPATEN PUNCAK JAYA',94),(9412,'KABUPATEN MIMIKA',94),(9413,'KABUPATEN BOVEN DIGOEL',94),(9414,'KABUPATEN MAPPI',94),(9415,'KABUPATEN ASMAT',94),(9416,'KABUPATEN YAHUKIMO',94),(9417,'KABUPATEN PEGUNUNGAN BINTANG',94),(9418,'KABUPATEN TOLIKARA',94),(9419,'KABUPATEN SARMI',94),(9420,'KABUPATEN KEEROM',94),(9426,'KABUPATEN WAROPEN',94),(9427,'KABUPATEN SUPIORI',94),(9428,'KABUPATEN MAMBERAMO RAYA',94),(9429,'KABUPATEN NDUGA',94),(9430,'KABUPATEN LANNY JAYA',94),(9431,'KABUPATEN MAMBERAMO TENGAH',94),(9432,'KABUPATEN YALIMO',94),(9433,'KABUPATEN PUNCAK',94),(9434,'KABUPATEN DOGIYAI',94),(9435,'KABUPATEN INTAN JAYA',94),(9436,'KABUPATEN DEIYAI',94),(9471,'KOTA JAYAPURA',94);
/*Table structure for table `kriminalitas` */
DROP TABLE IF EXISTS `kriminalitas`;
CREATE TABLE `kriminalitas` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`judul` varchar(30) DEFAULT NULL,
`waktu` datetime DEFAULT NULL,
`id_kota` int(11) DEFAULT NULL,
`alamat` varchar(100) DEFAULT NULL,
`t_pelaku` text,
`t_korban` text,
`deskripsi_kejadian` text,
`lat` float DEFAULT NULL,
`long` float DEFAULT NULL,
`validasi_data` tinyint(1) DEFAULT NULL,
`id_pengaduan` int(11) DEFAULT NULL,
`id_kat_kriminalitas` tinyint(4) DEFAULT NULL,
`id_kantor_polisi` int(11) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `fk_kota` (`id_kota`),
KEY `fk_kat_kriminalitas` (`id_kat_kriminalitas`),
KEY `fk_kantor_polisi2` (`id_kantor_polisi`),
KEY `fk_pengaduan` (`id_pengaduan`),
CONSTRAINT `fk_kantor_polisi2` FOREIGN KEY (`id_kantor_polisi`) REFERENCES `kantor_polisi` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `fk_kat_kriminalitas` FOREIGN KEY (`id_kat_kriminalitas`) REFERENCES `kategori_kriminalitas` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `fk_kota` FOREIGN KEY (`id_kota`) REFERENCES `kota` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `fk_pengaduan` FOREIGN KEY (`id_pengaduan`) REFERENCES `pengaduan` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=latin1;
/*Data for the table `kriminalitas` */
insert into `kriminalitas`(`id`,`judul`,`waktu`,`id_kota`,`alamat`,`t_pelaku`,`t_korban`,`deskripsi_kejadian`,`lat`,`long`,`validasi_data`,`id_pengaduan`,`id_kat_kriminalitas`,`id_kantor_polisi`,`created_at`,`updated_at`) values (38,'copet di atm BCA','2017-12-31 15:35:00',3578,'jl. dukuh pakis v','pelaku ....','korban ...','kejadian ...',-7.2886,112.712,1,23,18,19,'2017-12-31 15:35:58','2018-01-01 22:51:25'),(39,'tabrak lari mobil dengan motor','2017-12-31 15:43:00',3578,'jl. pulosari I','pelaku ...','korban ...','kejadian ...',-7.30096,112.721,1,24,22,19,'2017-12-31 15:43:22','2018-01-01 22:46:35'),(40,'begal','2017-12-31 17:03:00',3578,'jl. dukuh pakis I','pelaku ..','korban ..','kejadian ..',-7.29541,112.711,2,25,13,19,'2017-12-31 17:03:56','2018-01-01 22:54:37'),(41,'jambret','2017-12-31 17:10:00',3578,'jl.banyu urip','...','...','...',-7.26918,112.716,3,26,18,17,'2017-12-31 17:11:08','2017-12-31 17:11:08'),(42,'begal','2017-12-31 17:12:00',3578,'jl. jarak','...','..','...',-7.28018,112.72,3,27,18,17,'2017-12-31 17:12:26','2017-12-31 17:12:26'),(43,'jambret motot','2017-12-31 17:13:00',3578,'jl.gayungsari barat','..','...','...',-7.33398,112.72,1,28,18,23,'2017-12-31 17:13:40','2017-12-31 17:14:56'),(44,'mutilasi','2017-12-31 22:03:00',3578,'jl.gayung kebonsari','..','..','..',-7.32827,112.721,1,29,13,23,'2017-12-31 22:03:27','2018-01-01 23:08:12'),(45,'copet di indomart','2017-12-31 22:05:00',3578,'jl.raya mayangkara','...','...','...',-7.32483,112.721,1,30,18,23,'2017-12-31 22:05:27','2018-01-01 23:05:40'),(46,'jambret','2017-12-31 22:08:00',3578,'jl. jambangan','...','...','...',-7.31998,112.712,1,31,18,24,'2017-12-31 22:08:45','2018-01-01 23:47:08'),(47,'tabrak lari','2017-12-31 22:10:00',3578,'jl.gayung kebonsari','..','..','..',-7.32914,112.725,1,32,22,23,'2017-12-31 22:10:43','2018-01-10 13:52:38'),(48,'begal mobil','2017-12-31 22:13:00',3578,'jl mayjen sungkono','.','...','...',-7.29144,112.717,3,33,13,19,'2017-12-31 22:13:37','2017-12-31 22:13:37'),(49,'begal motor','2017-12-31 22:15:00',3578,'jl. banyu urip','..','..','..',-7.26918,112.716,3,34,13,17,'2017-12-31 22:15:52','2017-12-31 22:15:52'),(50,'jambret','2017-12-31 22:44:00',3578,'jl.raya menganti','.','..','..',-7.30779,112.669,3,35,18,21,'2017-12-31 22:44:49','2017-12-31 22:44:49'),(51,'jambret','2017-12-31 22:55:00',3578,'jl.mayjen yono suwoyo','..','..','..',-7.28528,112.681,2,36,18,19,'2017-12-31 22:56:11','2018-01-19 05:43:22'),(52,'Copet','1970-01-01 07:00:00',3578,'Jl.raya pagesangan','pelaku xxx','korban xxx','kejadian xxx',-7.33425,112.707,1,NULL,19,24,'2018-01-06 21:32:52','2018-01-06 21:42:09'),(53,'copet di atm xxx','2018-01-19 13:12:00',3578,'jl. jambangan 30','pelaku xxx','korban xxx','kejadian xxx',-7.3299,112.71,3,37,19,24,'2018-01-19 13:13:18','2018-01-19 13:13:18'),(54,'begal','2018-01-19 13:15:00',3578,'jl. dukuh pakis 20','xxxx','xxxxx','xxx xxx',-7.29192,112.713,1,38,13,19,'2018-01-19 13:16:08','2018-01-19 13:18:36'),(55,'pembunuhan xxx','2018-01-24 20:05:00',3515,'Jl. Anggrek Inpres No.28, Kureksari, Waru, Kabupaten Sidoarjo, Jawa Timur 61256, Indonesia','xx.x.x.x.xxx','xx....xxx','mm.....mmm',-7.36024,112.736,3,39,13,24,'2018-01-24 20:05:43','2018-01-24 20:05:43');
/*Table structure for table `masyarakat` */
DROP TABLE IF EXISTS `masyarakat`;
CREATE TABLE `masyarakat` (
`nik` char(20) NOT NULL,
`username` varchar(20) DEFAULT NULL,
`password` varchar(20) DEFAULT NULL,
`nama` varchar(30) DEFAULT NULL,
`jenis_kelamin` tinyint(1) DEFAULT NULL,
`tempat_lahir` varchar(20) DEFAULT NULL,
`tanggal_lahir` date DEFAULT NULL,
`id_kota` int(11) DEFAULT NULL,
`alamat` varchar(100) DEFAULT NULL,
`agama` tinyint(1) DEFAULT NULL,
`pekerjaan` varchar(50) DEFAULT NULL,
`tlp` varchar(13) DEFAULT NULL,
`email` varbinary(30) DEFAULT NULL,
`foto` varchar(100) DEFAULT NULL,
`last_login` datetime DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`nik`),
KEY `fk_kota_2` (`id_kota`),
CONSTRAINT `fk_kota_2` FOREIGN KEY (`id_kota`) REFERENCES `kota` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table `masyarakat` */
insert into `masyarakat`(`nik`,`username`,`password`,`nama`,`jenis_kelamin`,`tempat_lahir`,`tanggal_lahir`,`id_kota`,`alamat`,`agama`,`pekerjaan`,`tlp`,`email`,`foto`,`last_login`,`created_at`,`updated_at`) values ('009','therock','777','indra c e xwz',1,'sby','2010-10-03',3525,'jl. mmmm',0,'xxx','06432','yes@y.com','009_2017-11-28 11-32-56.jpeg','2018-01-29 11:11:01','2017-11-22 11:33:06','2017-11-28 11:32:56'),('1231231231565611','indra','1234','indra cahya edytya',1,'Surabaya','2016-11-08',1172,'jl. xxxxx x x x x x NO. 45',2,'wiraswasta','0318543627','xxx@g.com','default.png','2017-07-03 12:42:42','2017-07-04 12:43:18','2017-07-06 12:43:27'),('1231231231565644','kaka','1234x','rendy cahya',1,'Surabaya','2016-11-08',1172,'jl. xxxxx x x x x x NO. 45',4,'wiraswasta','0318543627','yyx@g.com','1231231231565644_2017-09-10.jpeg','2017-12-26 17:52:20','2017-07-04 12:43:18','2017-09-09 00:38:04'),('1231231231565677','adiago','1234','adiago silva aaa',1,'Surabayax','2016-11-08',1172,'jl. xxxxx x x x x x NO. 45',2,'wiraswasta','0318543627','aa@xx.com','1231231231565677_2017-11-18.jpeg','2017-07-03 12:42:42','2017-07-04 12:43:18','2017-11-18 00:21:35'),('2777',NULL,NULL,'John Pler',1,'Malang','1988-03-03',1112,'jl. x',1,'xx','0921234554','x@x.c','default.png',NULL,'2018-01-02 00:13:58','2018-01-02 00:13:58'),('4556',NULL,'45','herman',1,'Medan','1989-03-31',3578,'jl. xx',2,'POLRI','908888','dfdf@s.com','default.png',NULL,'2018-01-01 23:35:53','2018-01-01 23:35:53'),('4599',NULL,'123','Rama',1,'Malang','1980-12-01',6471,'jl.xx',4,'POLRI','09777','x@x.co','default.png',NULL,'2018-01-01 23:44:22','2018-01-01 23:44:22'),('461304314',NULL,'111','Kasino',1,'x','1977-12-31',1117,'x',3,'x','3','x@f.c','default.png',NULL,'2017-09-08 19:44:59','2017-09-08 19:44:59'),('6499',NULL,NULL,'hihi',1,'malang','2011-01-01',1103,'jl. xxx',2,'ok','987','x@gg.c','default.png',NULL,'2017-11-18 00:27:22','2017-11-18 00:27:22'),('7677',NULL,'666','Didik Oke',1,'Surabaya','1970-04-07',3578,'jl. Achmad Yani 70',0,'POLRI','081776575555','Didik@me.c','7677_2017-12-31.png',NULL,'2017-12-31 15:27:31','2017-12-31 15:27:31'),('775',NULL,'111','Yossi Muray',1,'Jakarta','1966-08-03',3578,'jl. Mayjen Sungkono',0,'POLRI','081556760909','yossi@xmail.com','775_2018-01-18.jpeg',NULL,'2017-12-31 15:12:23','2018-01-18 16:30:23'),('789',NULL,'79','kiko',1,'Malang','1985-04-04',3578,'jl. xx',0,'POLRI','0900000','me@x.co','default.png',NULL,'2017-12-31 17:01:25','2017-12-31 17:01:25'),('8066666',NULL,NULL,'Dayu',1,'Sby','1983-01-31',2102,'Jl. xxx',0,'s','87','s@s.s','8066666_2017-11-20.png',NULL,'2017-11-20 11:24:57','2017-11-20 11:24:57'),('83010',NULL,NULL,'k',1,'Bandung','2010-01-01',1171,'jl. x',0,'x','09','h@g.c','default.png',NULL,'2017-11-18 00:32:01','2017-11-18 00:32:01'),('871000',NULL,NULL,'Nasir',1,'Jakarta','1977-02-02',2171,'jl. xxxxxx',2,'Wiraswasta','031000000','x@x.com','default.png',NULL,'2018-01-10 14:07:24','2018-01-10 14:07:24'),('8899',NULL,'88','Arib B',1,'Jakarta','1981-03-09',3578,'jl. xx',0,'POLRI','081987652424','me@r.com','default.png',NULL,'2017-12-31 16:54:38','2017-12-31 16:54:38'),('8963','k','k','k',2,'kk',NULL,NULL,'k',3,'k','066','jsod@m.com','default.png',NULL,'2017-11-01 16:04:18','2017-11-01 16:04:18'),('900909090',NULL,'1234','Boruto Uzumaki',1,'Surabaya','1980-07-07',3515,'jl. raden patah',1,'POLRI','081299999999','b@g.com','900909090_2018-01-18.png',NULL,'2018-01-18 17:00:53','2018-01-18 17:00:53'),('9098888888888882','x1','123','Koko Nut',1,'Malang','2008-03-04',2171,'Jl. mmmmm',0,'xxx','99','rx@xx.com','9098888888888882_2017-08-17.jpeg',NULL,'2017-08-17 14:41:59','2017-08-17 14:41:59'),('9098888888888883','x2','123','Koko Nut ww',1,'Malang','2008-03-04',1108,'Jl. mmmmm',0,'xxx','990','rx@xx.com','9098888888888883_2017-08-17.jpeg',NULL,'2017-08-17 14:40:38','2017-12-22 23:26:46');
/*Table structure for table `pelaku` */
DROP TABLE IF EXISTS `pelaku`;
CREATE TABLE `pelaku` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ket` text,
`nik` char(20) DEFAULT NULL,
`id_kriminalitas` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `fk_nik` (`nik`),
KEY `fk_kriminalitas` (`id_kriminalitas`),
CONSTRAINT `fk_kriminalitas` FOREIGN KEY (`id_kriminalitas`) REFERENCES `kriminalitas` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `fk_nik` FOREIGN KEY (`nik`) REFERENCES `masyarakat` (`nik`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
/*Data for the table `pelaku` */
insert into `pelaku`(`id`,`ket`,`nik`,`id_kriminalitas`) values (1,'xxx .....','2777',46),(3,'ket ............... ........','871000',38),(4,'keterangan ...........................','871000',39);
/*Table structure for table `pendukung_kriminalitas` */
DROP TABLE IF EXISTS `pendukung_kriminalitas`;
CREATE TABLE `pendukung_kriminalitas` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ket` text,
`dokumen` varchar(30) DEFAULT NULL,
`id_kriminalitas` int(11) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `fk_id_kriminalitas` (`id_kriminalitas`),
CONSTRAINT `fk_id_kriminalitas` FOREIGN KEY (`id_kriminalitas`) REFERENCES `kriminalitas` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=latin1;
/*Data for the table `pendukung_kriminalitas` */
insert into `pendukung_kriminalitas`(`id`,`ket`,`dokumen`,`id_kriminalitas`,`created_at`,`updated_at`) values (21,'saat ...','38_2017-12-31 15-40-11.jpeg',38,'2017-12-31 15:40:11','2017-12-31 15:40:11'),(22,'...','39_2017-12-31 15-44-45.jpeg',39,'2017-12-31 15:44:45','2017-12-31 15:44:45'),(23,'...','39_2017-12-31 15-44-59.jpeg',39,'2017-12-31 15:44:59','2017-12-31 15:44:59'),(24,'...','39_2017-12-31 15-45-20.jpeg',39,'2017-12-31 15:45:20','2017-12-31 15:45:20'),(25,'...','39_2017-12-31 15-45-43.jpeg',39,'2017-12-31 15:45:43','2017-12-31 15:45:43'),(26,'... ....','40_2018-01-01 22-56-23.jpeg',40,'2018-01-01 22:56:23','2018-01-01 22:56:23'),(28,'....','45_2018-01-01 23-05-28.jpeg',45,'2018-01-01 23:05:28','2018-01-01 23:05:28'),(29,'...','44_2018-01-01 23-11-57.jpeg',44,'2018-01-01 23:11:57','2018-01-01 23:11:57'),(30,'...','46_2018-01-01 23-46-55.jpeg',46,'2018-01-01 23:46:55','2018-01-01 23:46:55'),(31,'Bukannya berhenti, Aldhia malah kembali tancap gas melarikan diri dengan mobilnya. Lagi-lagi Aldhia menyerempet sepeda motor nomor polisi D 3491 SAW yang dikemudikan oleh Ilmi Aulia Muhammad. ','47_2018-01-07 10-39-06.jpeg',47,'2018-01-07 10:39:06','2018-01-07 10:45:57'),(32,'Aldhia pada saat itu mengendarai mobil Honda Brio dengan nomor polisi D 1258 ADO dari arah Turangga menuju arah Trans Studio Mall. Entah apa penyebabnya, mobil yang dikendarai Aldhia menyerempet seped','47_2018-01-07 10-40-08.png',47,'2018-01-07 10:40:08','2018-01-07 10:44:06'),(33,'jskskcl','53_2018-01-19 16-35-58.jpeg',53,'2018-01-19 16:35:58','2018-01-19 16:35:58');
/*Table structure for table `pengaduan` */
DROP TABLE IF EXISTS `pengaduan`;
CREATE TABLE `pengaduan` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`waktu` datetime DEFAULT NULL,
`id_pelapor` char(20) DEFAULT NULL,
`id_validator` char(10) DEFAULT NULL,
`id_kantor_polisi` int(11) DEFAULT NULL,
`validasi_pengaduan` tinyint(1) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `fk_validator` (`id_validator`),
KEY `fk_pelapor` (`id_pelapor`),
KEY `fk_kp` (`id_kantor_polisi`),
CONSTRAINT `fk_kp` FOREIGN KEY (`id_kantor_polisi`) REFERENCES `kantor_polisi` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `fk_pelapor` FOREIGN KEY (`id_pelapor`) REFERENCES `masyarakat` (`nik`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `fk_validator` FOREIGN KEY (`id_validator`) REFERENCES `polisi` (`nrp`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=latin1;
/*Data for the table `pengaduan` */
insert into `pengaduan`(`id`,`waktu`,`id_pelapor`,`id_validator`,`id_kantor_polisi`,`validasi_pengaduan`,`created_at`,`updated_at`) values (23,'2017-12-31 15:35:58','009','7676',19,1,'2017-12-31 15:35:58','2018-01-01 22:51:25'),(24,'2017-12-31 15:43:22','009','7676',19,1,'2017-12-31 15:43:22','2018-01-01 22:46:35'),(25,'2017-12-31 17:03:56','009','7676',19,2,'2017-12-31 17:03:56','2018-01-01 22:54:37'),(26,'2017-12-31 17:11:08','009',NULL,17,3,'2017-12-31 17:11:08','2017-12-31 17:11:08'),(27,'2017-12-31 17:12:26','009',NULL,17,3,'2017-12-31 17:12:26','2017-12-31 17:12:26'),(28,'2017-12-31 17:13:40','009','7789',23,1,'2017-12-31 17:13:40','2017-12-31 17:14:56'),(29,'2017-12-31 22:03:27','009','7789',23,1,'2017-12-31 22:03:27','2018-01-01 23:08:12'),(30,'2017-12-31 22:05:27','009','7789',23,1,'2017-12-31 22:05:27','2018-01-01 23:05:40'),(31,'2017-12-31 22:08:45','009','459',24,1,'2017-12-31 22:08:45','2018-01-01 23:47:08'),(32,'2017-12-31 22:10:43','009','7789',23,1,'2017-12-31 22:10:43','2018-01-10 13:52:38'),(33,'2017-12-31 22:13:37','009',NULL,19,3,'2017-12-31 22:13:37','2017-12-31 22:13:37'),(34,'2017-12-31 22:15:51','009',NULL,17,3,'2017-12-31 22:15:51','2017-12-31 22:15:51'),(35,'2017-12-31 22:44:49','009',NULL,21,3,'2017-12-31 22:44:49','2017-12-31 22:44:49'),(36,'2017-12-31 22:56:11','009','7676',19,2,'2017-12-31 22:56:11','2018-01-19 05:43:22'),(37,'2018-01-19 13:13:18','009',NULL,24,3,'2018-01-19 13:13:18','2018-01-19 13:13:18'),(38,'2018-01-19 13:16:08','009','7676',19,1,'2018-01-19 13:16:08','2018-01-19 13:18:36'),(39,'2018-01-24 20:05:43','009',NULL,24,3,'2018-01-24 20:05:43','2018-01-24 20:05:43');
/*Table structure for table `polisi` */
DROP TABLE IF EXISTS `polisi`;
CREATE TABLE `polisi` (
`nrp` char(10) NOT NULL,
`pangkat_polisi` tinyint(1) DEFAULT NULL,
`jabatan_polisi` varchar(300) DEFAULT NULL,
`akses` tinyint(1) DEFAULT NULL,
`nik` char(20) DEFAULT NULL,
`dokumen` varchar(50) DEFAULT NULL,
`id_kantor_polisi` int(11) DEFAULT NULL,
`valid` tinyint(1) DEFAULT NULL,
`last_login` datetime DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`nrp`),
KEY `fk_nik_2` (`nik`),
KEY `fk_kantor_polisi` (`id_kantor_polisi`),
CONSTRAINT `fk_kantor_polisi` FOREIGN KEY (`id_kantor_polisi`) REFERENCES `kantor_polisi` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `fk_nik_2` FOREIGN KEY (`nik`) REFERENCES `masyarakat` (`nik`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table `polisi` */
insert into `polisi`(`nrp`,`pangkat_polisi`,`jabatan_polisi`,`akses`,`nik`,`dokumen`,`id_kantor_polisi`,`valid`,`last_login`,`created_at`,`updated_at`) values ('3434',16,'Komandan Polres',1,'775','3434_2018-01-18.jpeg',19,1,'2018-01-18 17:08:41','2017-12-31 15:14:16','2018-01-18 16:34:59'),('456',17,'jabatan ...',1,'4556','default.jpg',24,1,'2018-01-08 18:18:19','2018-01-01 23:37:49','2018-01-01 23:41:14'),('459',6,'Devisi xx',0,'4599',NULL,24,1,'2018-01-10 13:50:43','2018-01-01 23:45:25','2018-01-06 22:28:03'),('7676',2,'Intel Crime',0,'7677',NULL,19,1,'2018-01-29 11:11:34','2017-12-31 15:28:27','2017-12-31 15:28:27'),('7789',2,'LANTAS',0,'789',NULL,23,1,'2018-01-10 14:02:37','2017-12-31 17:01:51','2017-12-31 17:01:51'),('8899',16,'jabatan ..',1,'8899','default.jpg',23,1,'2018-01-10 14:01:34','2017-12-31 16:57:22','2017-12-31 16:58:55'),('9009',8,'LANTAS',0,'900909090',NULL,19,1,NULL,'2018-01-18 17:01:49','2018-01-18 17:01:49');
/*Table structure for table `polygon_path` */
DROP TABLE IF EXISTS `polygon_path`;
CREATE TABLE `polygon_path` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`kecamatan` varchar(50) DEFAULT NULL,
`path` text,
`fk_kota` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `fk_kota_polygon` (`fk_kota`),
CONSTRAINT `fk_kota_polygon` FOREIGN KEY (`fk_kota`) REFERENCES `kota` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
/*Data for the table `polygon_path` */
insert into `polygon_path`(`id`,`kecamatan`,`path`,`fk_kota`) values (1,'Sawahan','[{longitude:112.7342037842668,latitude:-7.256141452534629},{longitude:112.732711111625,latitude:-7.255943300806388},{longitude:112.7310122514915,latitude:-7.256162515006938},{longitude:112.7276907431666,latitude:-7.25597805767787},{longitude:112.7274448711408,latitude:-7.257019666668421},{longitude:112.7259432997929,latitude:-7.256884537144924},{longitude:112.7243497812523,latitude:-7.256947889356606},{longitude:112.7193721106895,latitude:-7.256127085147309},{longitude:112.7163971782015,latitude:-7.254988231637348},{longitude:112.7158821537612,latitude:-7.25442188549667},{longitude:112.7154386948189,latitude:-7.254098243335216},{longitude:112.715018407864,latitude:-7.255155207645826},{longitude:112.7148171527642,latitude:-7.256191778921226},{longitude:112.714221117026,latitude:-7.258148747206071},{longitude:112.7131989620896,latitude:-7.262009546155031},{longitude:112.7124406503895,latitude:-7.26745504823981},{longitude:112.712044331529,latitude:-7.268104805809046},{longitude:112.7105039261043,latitude:-7.273199786114378},{longitude:112.7090704306556,latitude:-7.273201920405406},{longitude:112.7086727142681,latitude:-7.275654355959165},{longitude:112.7100877749078,latitude:-7.275651638878158},{longitude:112.7097021682097,latitude:-7.277458681410524},{longitude:112.7126563195008,latitude:-7.278774181595933},{longitude:112.7137375516861,latitude:-7.279100209939258},{longitude:112.7174231678433,latitude:-7.279645293314756},{longitude:112.7153965453564,latitude:-7.285121408023086},{longitude:112.7134832989585,latitude:-7.290468032224521},{longitude:112.7175216194129,latitude:-7.291616426166151},{longitude:112.7237171858652,latitude:-7.29222597657798},{longitude:112.7296222971797,latitude:-7.292887272530165},{longitude:112.731166504984,latitude:-7.291049325712171},{longitude:112.7318180100716,latitude:-7.28877362769809},{longitude:112.7307259043006,latitude:-7.288063044550674},{longitude:112.7301160507379,latitude:-7.287010135635358},{longitude:112.7310437478158,latitude:-7.28625169982237},{longitude:112.7304866867366,latitude:-7.28391023699596},{longitude:112.7293089433584,latitude:-7.281815866557006},{longitude:112.7291173573866,latitude:-7.280312001835962},{longitude:112.7278798613923,latitude:-7.279535526880301},{longitude:112.727896292793,latitude:-7.276928759693432},{longitude:112.7267733445397,latitude:-7.275046605474633},{longitude:112.7342037842668,latitude:-7.256141452534629}]',3578),(4,'Karang Pilang','[{longitude:112.7052073969838,latitude:-7.312953903653766},{longitude:112.7017095320726,latitude:-7.315177348679536},{longitude:112.6994601131587,latitude:-7.319424589307788},{longitude:112.6990119546568,latitude:-7.322237347694192},{longitude:112.6982274322909,latitude:-7.32185762581943},{longitude:112.697530386202,latitude:-7.323891274267584},{longitude:112.6907807834142,latitude:-7.322578556199358},{longitude:112.6903192084365,latitude:-7.324719365591942},{longitude:112.6911633594234,latitude:-7.324978661442978},{longitude:112.6913299950961,latitude:-7.324122862394077},{longitude:112.6926057830027,latitude:-7.324416510552308},{longitude:112.6925794727735,latitude:-7.325279231578209},{longitude:112.6953289348269,latitude:-7.326149948734065},{longitude:112.6947558292547,latitude:-7.328632949484448},{longitude:112.6953387675662,latitude:-7.329475202980811},{longitude:112.6953930998022,latitude:-7.33037195525313},{longitude:112.6961982463006,latitude:-7.330826178800032},{longitude:112.6955648918978,latitude:-7.333781834814436},{longitude:112.6801270820116,latitude:-7.329544495879919},{longitude:112.6732300528534,latitude:-7.3337001392114},{longitude:112.6697043010101,latitude:-7.333449916742352},{longitude:112.6669799552042,latitude:-7.334990519160812},{longitude:112.6606683847077,latitude:-7.334016494838394},{longitude:112.6593903598289,latitude:-7.335247737564409},{longitude:112.6567843846944,latitude:-7.332918388528013},{longitude:112.6543840200726,latitude:-7.334477043222324},{longitude:112.6573458616612,latitude:-7.337736058635473},{longitude:112.6601546594055,latitude:-7.337943379997034},{longitude:112.6604816606881,latitude:-7.349779328393596},{longitude:112.6625692866369,latitude:-7.351327173552715},{longitude:112.6680872892664,latitude:-7.351082822471263},{longitude:112.6750231427552,latitude:-7.35126421778434},{longitude:112.6784355160178,latitude:-7.350350793202768},{longitude:112.6825715864007,latitude:-7.347802301202814},{longitude:112.6904734990143,latitude:-7.345447016820086},{longitude:112.696727005255,latitude:-7.342696107894724},{longitude:112.7008862736997,latitude:-7.339248190576708},{longitude:112.7048603228018,latitude:-7.33615566551854},{longitude:112.7080103669447,latitude:-7.331959630967859},{longitude:112.7106457719813,latitude:-7.328873305261212},{longitude:112.7104985924477,latitude:-7.32278313456443},{longitude:112.7108890019925,latitude:-7.320311534398035},{longitude:112.7115507834868,latitude:-7.318650798005313},{longitude:112.7116840133244,latitude:-7.31292268968547},{longitude:112.7052073969838,latitude:-7.312953903653766}]',3578),(5,'Wiyung','[{longitude:112.7144843628271,latitude:-7.307931240974797},{longitude:112.7132541124777,latitude:-7.307107273930136},{longitude:112.707639747647,latitude:-7.30661245362156},{longitude:112.7067298480424,latitude:-7.308064338028618},{longitude:112.7041434302683,latitude:-7.307524386834257},{longitude:112.7044033447375,latitude:-7.303721992302647},{longitude:112.7066777682967,latitude:-7.303794130627283},{longitude:112.7073957756655,latitude:-7.302925813870376},{longitude:112.7069850525594,latitude:-7.301442885403593},{longitude:112.7052470816125,latitude:-7.300276457815818},{longitude:112.7044853051658,latitude:-7.301757087547525},{longitude:112.7012051588692,latitude:-7.302336144634579},{longitude:112.6989709116629,latitude:-7.302418654388641},{longitude:112.6973803528144,latitude:-7.301929948475352},{longitude:112.6967845062267,latitude:-7.300027264025622},{longitude:112.695825774963,latitude:-7.301693343436149},{longitude:112.6918139452141,latitude:-7.30020538010747},{longitude:112.6890664712941,latitude:-7.299307045733184},{longitude:112.6867227024514,latitude:-7.300844161374966},{longitude:112.6828591453091,latitude:-7.301739236795316},{longitude:112.6843181088063,latitude:-7.299117512031792},{longitude:112.6774684455093,latitude:-7.295903249555619},{longitude:112.6773001205676,latitude:-7.294704671987704},{longitude:112.6756242749158,latitude:-7.294442696428948},{longitude:112.6772877062474,latitude:-7.289110567180958},{longitude:112.6786706576823,latitude:-7.288061277954573},{longitude:112.6787328247716,latitude:-7.287331646702671},{longitude:112.6778265105122,latitude:-7.286541391501075},{longitude:112.6784246267776,latitude:-7.283946715442249},{longitude:112.6755365654174,latitude:-7.283260328113416},{longitude:112.6753380908601,latitude:-7.285138626660615},{longitude:112.6763053989244,latitude:-7.285255519805789},{longitude:112.6757405815949,latitude:-7.286926863748082},{longitude:112.673928066705,latitude:-7.286590145494304},{longitude:112.6725650043561,latitude:-7.289688541400707},{longitude:112.6717765986632,latitude:-7.289468231568177},{longitude:112.6715100929385,latitude:-7.293324636180119},{longitude:112.6752422011004,latitude:-7.294583151805501},{longitude:112.6752596247449,latitude:-7.298462305689998},{longitude:112.6741292714209,latitude:-7.300159293567547},{longitude:112.6735875134741,latitude:-7.301769808005935},{longitude:112.6745108985696,latitude:-7.303340066020923},{longitude:112.6739923266603,latitude:-7.308725674907805},{longitude:112.6728483972473,latitude:-7.314339980628815},{longitude:112.6723206050066,latitude:-7.317311898925556},{longitude:112.677647574293,latitude:-7.318696126912785},{longitude:112.6757365130344,latitude:-7.326871256140711},{longitude:112.6725916126785,latitude:-7.328315214144894},{longitude:112.6685183779763,latitude:-7.332134815135598},{longitude:112.6697218474434,latitude:-7.333445640456645},{longitude:112.673245335315,latitude:-7.333698734102039},{longitude:112.680155159849,latitude:-7.32954346123333},{longitude:112.6955511309066,latitude:-7.333767546052505},{longitude:112.6961969741723,latitude:-7.330821586695436},{longitude:112.6953946840515,latitude:-7.330391555205065},{longitude:112.6953510629504,latitude:-7.329476783036608},{longitude:112.6947553473837,latitude:-7.328636998310576},{longitude:112.6953362867257,latitude:-7.326146464582036},{longitude:112.6925958044187,latitude:-7.325263687176324},{longitude:112.6926222321559,latitude:-7.324413501687128},{longitude:112.6913376725432,latitude:-7.32412463008707},{longitude:112.6911536898647,latitude:-7.324975717349349},{longitude:112.6903336560581,latitude:-7.324715578296825},{longitude:112.6907750749694,latitude:-7.322573901150176},{longitude:112.6975164430547,latitude:-7.323905297378656},{longitude:112.6982500484008,latitude:-7.32186732145038},{longitude:112.6990115992258,latitude:-7.322238515186531},{longitude:112.6994700963828,latitude:-7.319440792837757},{longitude:112.7017396832619,latitude:-7.315182332851236},{longitude:112.7051879955366,latitude:-7.312967075009331},{longitude:112.7117020499643,latitude:-7.312920652004755},{longitude:112.7119192529119,latitude:-7.310377981578519},{longitude:112.712922383538,latitude:-7.308704146997905},{longitude:112.7144843628271,latitude:-7.307931240974797}]',3578),(6,'Wonocolo','[{longitude:112.7294381772395,latitude:-7.337237353449988},{longitude:112.7293980118616,latitude:-7.339585481349536},{longitude:112.7378228896569,latitude:-7.34052121387988},{longitude:112.7374442935695,latitude:-7.344777370061242},{longitude:112.7419251392473,latitude:-7.345216664437127},{longitude:112.7429470532708,latitude:-7.340850730531862},{longitude:112.742060466612,latitude:-7.340633737610086},{longitude:112.7426109668101,latitude:-7.334328341724036},{longitude:112.7434248001623,latitude:-7.330117120507596},{longitude:112.743737734517,latitude:-7.322928437164515},{longitude:112.7469012505803,latitude:-7.3234234531906},{longitude:112.746942261242,latitude:-7.322308838599214},{longitude:112.7458151850383,latitude:-7.320942960220141},{longitude:112.74819263273,latitude:-7.31961774365377},{longitude:112.747399555261,latitude:-7.31882896549044},{longitude:112.7482349786438,latitude:-7.317294031354702},{longitude:112.7507824184344,latitude:-7.317875983075638},{longitude:112.7536751934792,latitude:-7.315667277855057},{longitude:112.753090289436,latitude:-7.315375643905527},{longitude:112.7533570575477,latitude:-7.311318077183873},{longitude:112.7551589357825,latitude:-7.311821320222813},{longitude:112.7555826677251,latitude:-7.311024534846174},{longitude:112.7567148364595,latitude:-7.311192432052449},{longitude:112.7561662176145,latitude:-7.311695894330327},{longitude:112.7566667349803,latitude:-7.312115447823802},{longitude:112.759601973237,latitude:-7.308905951596843},{longitude:112.7587134785267,latitude:-7.308818676641486},{longitude:112.7591981075268,latitude:-7.305791557163409},{longitude:112.7569501048883,latitude:-7.305246630655111},{longitude:112.7564319403619,latitude:-7.306389166770613},{longitude:112.7419119062616,latitude:-7.305933986706792},{longitude:112.7403563065076,latitude:-7.311193440107842},{longitude:112.7393193103753,latitude:-7.310963862052239},{longitude:112.7392040842258,latitude:-7.312106758022031},{longitude:112.7349368338752,latitude:-7.311064733695542},{longitude:112.7294381772395,latitude:-7.337237353449988}]',3578),(8,'Jambangan','[{longitude:112.7184991313901,latitude:-7.308316661413909},{longitude:112.7144843029613,latitude:-7.307927732587644},{longitude:112.7129206135277,latitude:-7.308709179726542},{longitude:112.7119083316772,latitude:-7.310373570566306},{longitude:112.7115871695308,latitude:-7.314410347848755},{longitude:112.711520041259,latitude:-7.31858576006384},{longitude:112.7108451592258,latitude:-7.320237744418893},{longitude:112.7104527113457,latitude:-7.322815948880069},{longitude:112.7106117950637,latitude:-7.328864577783818},{longitude:112.708180050607,latitude:-7.331648106644752},{longitude:112.7047856259005,latitude:-7.336224288882343},{longitude:112.7080150721918,latitude:-7.337507359135302},{longitude:112.7175191496039,latitude:-7.34035689720592},{longitude:112.7178834163137,latitude:-7.338540268493272},{longitude:112.7165351355136,latitude:-7.338298265665424},{longitude:112.7167085680488,latitude:-7.335390755751921},{longitude:112.7187781488526,latitude:-7.335559853303243},{longitude:112.7198562078877,latitude:-7.328806260032231},{longitude:112.7182858044321,latitude:-7.32851403435286},{longitude:112.7264099575372,latitude:-7.317612999221642},{longitude:112.722562984974,latitude:-7.316406636460086},{longitude:112.7241174237072,latitude:-7.307642339629179},{longitude:112.7184991313901,latitude:-7.308316661413909}]',3578),(9,'Wonokromo','[{longitude:112.7279178016267,latitude:-7.27683787024511},{longitude:112.727908825249,latitude:-7.27953270134753},{longitude:112.7291696880551,latitude:-7.28034418066937},{longitude:112.7291777747957,latitude:-7.281724952775633},{longitude:112.7310649678365,latitude:-7.286240257216407},{longitude:112.7301149595925,latitude:-7.287022928385422},{longitude:112.7307505915516,latitude:-7.28807675057052},{longitude:112.7318232596294,latitude:-7.288793128848482},{longitude:112.7311663062337,latitude:-7.291061217479185},{longitude:112.7296359498738,latitude:-7.292868493913977},{longitude:112.725175376042,latitude:-7.292397456717839},{longitude:112.7247486950107,latitude:-7.294060894755674},{longitude:112.7239019153142,latitude:-7.294137915946132},{longitude:112.7210868139771,latitude:-7.295950359133259},{longitude:112.7205663889418,latitude:-7.302285684457119},{longitude:112.7202429952611,latitude:-7.306157922681522},{longitude:112.719895797352,latitude:-7.307041918474142},{longitude:112.7207203183262,latitude:-7.307948753927378},{longitude:112.7240377306695,latitude:-7.307647024813482},{longitude:112.7297454379514,latitude:-7.310062495875719},{longitude:112.7304730782726,latitude:-7.309766722251823},{longitude:112.7350353369715,latitude:-7.310478984888126},{longitude:112.7350271294986,latitude:-7.311160732220431},{longitude:112.7389399254738,latitude:-7.312088478574092},{longitude:112.7391847495986,latitude:-7.310847460207232},{longitude:112.7405468726217,latitude:-7.311089364608188},{longitude:112.7416620816792,latitude:-7.305920947190749},{longitude:112.7502834332855,latitude:-7.305803533513861},{longitude:112.7541250401694,latitude:-7.306363065108791},{longitude:112.7563600224793,latitude:-7.306897602675712},{longitude:112.7571955059936,latitude:-7.304504032141921},{longitude:112.7546584975537,latitude:-7.303763024381167},{longitude:112.7572390124345,latitude:-7.293930612274837},{longitude:112.75471787429,latitude:-7.293530964013821},{longitude:112.7513243873713,latitude:-7.292917657783137},{longitude:112.7480032176283,latitude:-7.291495629591878},{longitude:112.7472560848685,latitude:-7.290938123462008},{longitude:112.75057487985,latitude:-7.27727731802159},{longitude:112.7463987431294,latitude:-7.276486874413386},{longitude:112.7440453587555,latitude:-7.277184061783},{longitude:112.7445368876863,latitude:-7.278845866255093},{longitude:112.7463645256118,latitude:-7.28182759981844},{longitude:112.7470318329675,latitude:-7.284329377419121},{longitude:112.7467111067737,latitude:-7.285887147238855},{longitude:112.7450915795323,latitude:-7.287869016155498},{longitude:112.7428254588563,latitude:-7.290085727102472},{longitude:112.7417527128504,latitude:-7.290198731988077},{longitude:112.7400137697289,latitude:-7.289370916896249},{longitude:112.7391983448495,latitude:-7.289184459833901},{longitude:112.7374544800277,latitude:-7.289220274101285},{longitude:112.7361201450554,latitude:-7.289597324790876},{longitude:112.7334961450236,latitude:-7.284452285785812},{longitude:112.7318178715331,latitude:-7.281085734787583},{longitude:112.7279178016267,latitude:-7.27683787024511}]',3578),(10,'Dukuh Pakis','[{longitude:112.7080668900801,latitude:-7.275838497320297},{longitude:112.7081388813557,latitude:-7.2792323704389},{longitude:112.7066550047832,latitude:-7.278718555828074},{longitude:112.7051095815684,latitude:-7.277033583125125},{longitude:112.6986034134567,latitude:-7.281607108882228},{longitude:112.7011332508617,latitude:-7.284531760319194},{longitude:112.7044582003514,latitude:-7.281774708693909},{longitude:112.7082627158503,latitude:-7.283386946396516},{longitude:112.7070675975241,latitude:-7.288308513920588},{longitude:112.7037494075716,latitude:-7.292834772061238},{longitude:112.6985538406891,latitude:-7.291518479230574},{longitude:112.6938695830031,latitude:-7.289648657693299},{longitude:112.6947254652805,latitude:-7.286468097196541},{longitude:112.6955004238939,latitude:-7.286469681587987},{longitude:112.6956906972892,latitude:-7.28522836667186},{longitude:112.6941396030269,latitude:-7.284700057136019},{longitude:112.6969225015329,latitude:-7.282349080794931},{longitude:112.6963326399643,latitude:-7.281571075657146},{longitude:112.6974060205558,latitude:-7.280477192212215},{longitude:112.6961083341529,latitude:-7.278804031966621},{longitude:112.6910742489107,latitude:-7.278271167397798},{longitude:112.6880603209841,latitude:-7.278619856581808},{longitude:112.6843426534967,latitude:-7.273240783522581},{longitude:112.6796721693115,latitude:-7.280247549899904},{longitude:112.678161474562,latitude:-7.286886380349616},{longitude:112.6786948370814,latitude:-7.287793507451687},{longitude:112.6772035759449,latitude:-7.289497028406762},{longitude:112.6757780587769,latitude:-7.294547676209834},{longitude:112.6776797754544,latitude:-7.295961093370361},{longitude:112.6842084924338,latitude:-7.299065883080639},{longitude:112.6827737323886,latitude:-7.301600465724039},{longitude:112.6863086606593,latitude:-7.301374447342339},{longitude:112.686607718919,latitude:-7.300536154214776},{longitude:112.6885518835002,latitude:-7.299402279726004},{longitude:112.691896469861,latitude:-7.29988907308421},{longitude:112.6960221359138,latitude:-7.301459001451788},{longitude:112.696973167755,latitude:-7.299953064551651},{longitude:112.6973334027388,latitude:-7.301807925584011},{longitude:112.7009663184045,latitude:-7.302533571097694},{longitude:112.7039368410688,latitude:-7.301708088927588},{longitude:112.7048948073803,latitude:-7.300642916915671},{longitude:112.705148487032,latitude:-7.300016352597036},{longitude:112.707384762837,latitude:-7.3018913424822},{longitude:112.7048105149817,latitude:-7.301832927538969},{longitude:112.7040088771223,latitude:-7.307376061017616},{longitude:112.7067011596541,latitude:-7.307987124037777},{longitude:112.7078527721904,latitude:-7.307295570819179},{longitude:112.712852600899,latitude:-7.307142157300805},{longitude:112.7137751648429,latitude:-7.307525592885313},{longitude:112.7199306826845,latitude:-7.307063675639036},{longitude:112.7202449932375,latitude:-7.306214958255564},{longitude:112.7208189331416,latitude:-7.298247374598393},{longitude:112.7210564406997,latitude:-7.295969887880038},{longitude:112.7224261769557,latitude:-7.295160756382696},{longitude:112.7238956807793,latitude:-7.294110599931403},{longitude:112.7247194326947,latitude:-7.294062874054748},{longitude:112.7252123476234,latitude:-7.292405643356462},{longitude:112.7221275874317,latitude:-7.292057498924521},{longitude:112.7172434292989,latitude:-7.291537007493258},{longitude:112.7134837494162,latitude:-7.290454447891825},{longitude:112.7154132362877,latitude:-7.285745331602597},{longitude:112.7173458898509,latitude:-7.279646331903906},{longitude:112.7133985828397,latitude:-7.279000119917868},{longitude:112.7096851571586,latitude:-7.277482052036135},{longitude:112.7100680934907,latitude:-7.275655149588791},{longitude:112.7086729082805,latitude:-7.275727221582006},{longitude:112.7080668900801,latitude:-7.275838497320297}]',3578),(12,'Gayungan','[{longitude:112.7304805569359,latitude:-7.309620005133486},{longitude:112.7298296125182,latitude:-7.309998289755324},{longitude:112.7241112669562,latitude:-7.307653488127758},{longitude:112.72256640561,latitude:-7.316402851144057},{longitude:112.726412261394,latitude:-7.317611212603985},{longitude:112.7182170222742,latitude:-7.328553083257817},{longitude:112.7198592185645,latitude:-7.328802133554292},{longitude:112.7187838908352,latitude:-7.335572241742868},{longitude:112.7167364816078,latitude:-7.33540886056548},{longitude:112.7165277490123,latitude:-7.338287399124007},{longitude:112.7178723074049,latitude:-7.338504682380413},{longitude:112.7175352034098,latitude:-7.340392354791145},{longitude:112.7161360109707,latitude:-7.339908314608606},{longitude:112.7157452457134,latitude:-7.34167810238111},{longitude:112.7200865401313,latitude:-7.343067629883978},{longitude:112.7196819170581,latitude:-7.344450356516349},{longitude:112.7242654220291,latitude:-7.34588317313618},{longitude:112.724327815656,latitude:-7.346834393598184},{longitude:112.7258737701524,latitude:-7.348256300821915},{longitude:112.7292018620175,latitude:-7.348308935053074},{longitude:112.7331646294838,latitude:-7.348095688395095},{longitude:112.7335398722105,latitude:-7.346619282762767},{longitude:112.7363475992012,latitude:-7.346357678132768},{longitude:112.7366252348773,latitude:-7.344872811505048},{longitude:112.737421916664,latitude:-7.344767754435215},{longitude:112.7378055344861,latitude:-7.340531687449269},{longitude:112.7293721930921,latitude:-7.339592072117169},{longitude:112.7294368419556,latitude:-7.337324719698013},{longitude:112.7303034950239,latitude:-7.3332702461973},{longitude:112.7350456529801,latitude:-7.310466505035189},{longitude:112.7304805569359,latitude:-7.309620005133486}]',3578);
/*Table structure for table `provinsi` */
DROP TABLE IF EXISTS `provinsi`;
CREATE TABLE `provinsi` (
`id` int(11) NOT NULL,
`nama` varchar(30) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table `provinsi` */
insert into `provinsi`(`id`,`nama`) values (11,'ACEH'),(12,'SUMATERA UTARA'),(13,'SUMATERA BARAT'),(14,'RIAU'),(15,'JAMBI'),(16,'SUMATERA SELATAN'),(17,'BENGKULU'),(18,'LAMPUNG'),(19,'KEPULAUAN BANGKA BELITUNG'),(21,'KEPULAUAN RIAU'),(31,'DKI JAKARTA'),(32,'JAWA BARAT'),(33,'JAWA TENGAH'),(34,'DI YOGYAKARTA'),(35,'JAWA TIMUR'),(36,'BANTEN'),(51,'BALI'),(52,'NUSA TENGGARA BARAT'),(53,'NUSA TENGGARA TIMUR'),(61,'KALIMANTAN BARAT'),(62,'KALIMANTAN TENGAH'),(63,'KALIMANTAN SELATAN'),(64,'KALIMANTAN TIMUR'),(65,'KALIMANTAN UTARA'),(71,'SULAWESI UTARA'),(72,'SULAWESI TENGAH'),(73,'SULAWESI SELATAN'),(74,'SULAWESI TENGGARA'),(75,'GORONTALO'),(76,'SULAWESI BARAT'),(81,'MALUKU'),(82,'MALUKU UTARA'),(91,'PAPUA BARAT'),(94,'PAPUA');
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;