Introductie

Weetmeer.nl is een experiment van Braxwell Labs.
Geografische, demografische, politieke en economische informatie over gemeenten wordt verzameld uit verschillende bronnen om vervolgens op verschillende manieren gecombineerd te worden.

Dit resulteert in verrassende uitkomsten en visualisaties, die op www.weetmeer.nl regelmatig gepubliceerd zullen worden.

Voor meer informatie kunt u contact opnemen met Jasper Soetendal (j.soetendal@braxwell.com)

Voorbeelden:

 


   
   
   


Geplaatst op Thu 11 Sep '08, 17:24 door Jasper (Laatste wijziging: Wed 20 Jan '10, 15:14)
Bijlagen:
voorbeeld-Utrechtx450.png (52.09 Kb, 794 keer geopend)
voorbeeld-Utrechtx1000.png (157.4 Kb, 213 keer geopend)
------------------------------ Output for debugging: ------------------------------ SESSION : checked -> true
COOKIE : PHPSESSID -> 9746ddb98970c6d28f9b3a695fcff8de
0.10673 sec - 1) returnFirst: SELECT * FROM splace WHERE splaceID = 3
0.11834 sec - 2) returnFirst: SELECT * FROM ban WHERE splaceID = 3 AND ip LIKE '38.107.191.108'
0.12261 sec - currentuserID: 0 0.12352 sec - 3) doSQL: INSERT into pageview(splaceID, moduleID, ID, userID, groupID, visitorID, phpsessID, ip, datetime) VALUES (3, 0, 0, 0, 0, 0, '9746ddb98970c6d28f9b3a695fcff8de', '38.107.191.108', NOW())
0.15024 sec - userID:
groupID:
moduleID:
parentID:
mapID:
MenuID:
ID:
reactieID:
subID:
0.15029 sec - 4) returnFirst: SELECT * FROM subsplace WHERE userID = 0 AND groupID = 0
0.15082 sec - 5) getQuery: SELECT * from module WHERE splaceID = 3 AND showNormal > 0 order by volgorde
0.15141 sec - 6) getQuery: SELECT modulecontenttype.* FROM modulecontenttype LEFT JOIN module ON(module.moduleID = modulecontenttype.moduleID) WHERE module.splaceID = 3 OR modulecontenttype.moduleID = 0 GROUP BY modulecontenttype.contenttypeID, modulecontenttype.moduleID
0.15375 sec - 7) getQuery: SELECT * FROM module WHERE splaceID = 3
0.15425 sec - 8) returnFirst: SELECT * from module LEFT JOIN moduletype ON (module.moduletypeID = moduletype.moduletypeID) WHERE module.splaceID = 3 AND module.moduleID = 67
0.15492 sec - 9) returnFirst: SELECT * FROM module WHERE moduleID = 67
0.15526 sec - 10) getQuery: SELECT * from childtype WHERE moduletypeID = 4 AND contenttypeID = 0 order by volgorde
0.16976 sec - 11) returnFirst: SELECT * FROM contenttype, modulecontenttype WHERE contenttype.contenttypeID = modulecontenttype.contenttypeID AND modulecontenttype.moduleID = 67 AND contenttype.contenttypeID = 9
0.17606 sec - 12) getQuery: SELECT content.*, user.username, user.avatar, user.profileID as profileID, user.score as userscore from content LEFT JOIN user ON (content.creatorID = user.userID) WHERE content.parentID = 0 AND content.moduleID = 67 AND content.contenttypeID = 9 AND content.userID=0 AND content.groupID=0 ORDER BY volgorde
0.19335 sec - Contenttype ID: 9 => type: menu
0.19352 sec - 13) returnFirst: SELEcT * FROM content WHERE contentID = 55438
0.19413 sec - 14) returnFirst: SELEcT * FROM content WHERE contentID = 55440
0.19474 sec - 15) getQuery: SELECT * from childtype WHERE moduletypeID = 4 AND contenttypeID = 9 order by volgorde
0.19506 sec - 16) returnFirst: SELECT * FROM contenttype, modulecontenttype WHERE contenttype.contenttypeID = modulecontenttype.contenttypeID AND modulecontenttype.moduleID = 67 AND contenttype.contenttypeID = 8
0.19598 sec - 17) getQuery: SELECT content.*, user.username, user.avatar, user.profileID as profileID, user.score as userscore, xc_page.*, content.contentID as contentID from content LEFT JOIN user ON (content.creatorID = user.userID) LEFT JOIN xc_page ON (xc_page.contentID = content.contentID) WHERE content.parentID = 55438 AND content.contenttypeID = 8 ORDER BY volgorde
0.19682 sec - Contenttype ID: 8 => type: tab
0.19781 sec - 18) returnQuery: SELECT extendTable AS result FROM contenttype WHERE contenttypeID = 8
0.19827 sec - 19) getQuery: SELECT file.* from attachment LEFT JOIN file ON (attachment.fileID = file.fileID) WHERE attachment.contentID = 55441 AND attachment.type = 0
0.21275 sec - 20) doSQL: UPDATE LOW_PRIORITY content SET views = views + 1 WHERE contentID = 55441
0.21325 sec - 21) getNumRows: SELECT * FROM childtype, module WHERE childtype.moduletypeID = module.moduletypeID AND module.moduleID = 67
0.21379 sec - 22) getQuery: SELECT * FROM block, module WHERE block.moduleID = module.moduleID AND block.splaceID = 3 AND block.target LIKE '%;67;%' AND block.position like '1%' order by block.volgorde