Geo Viewer

NoSQLBosoter can only display GEO JSON data and does not support legacy legacy coordinate pairs. Could you show me a sample JSON data?

GEO JSON Object:

<field>: { type: <GeoJSON type> , coordinates: <coordinates> }

GEO Point Sample:

"point" : {

"type" : "Point",

"coordinates" : [-73.856077,40.848447]

},

And, we just upload a new build 5.1.7 which fixes a GEO Viewer bug, please download and give it a try.

MacOS: https://nosqlbooster.com/s3/download/releasesv5/nosqlbooster4mongo-5.1.7.dmg

/* 1 */

{

"InstanceTitle" : "MRSS Clock In App 2.0",

"TemplateTitle" : "MRSS Clock In App 2.0",

"Note" : "",

"Created" : ISODate("2019-04-11T08:49:52.281+01:00"),

"Updated" : ISODate("2019-04-11T08:56:50.713+01:00"),

"InstanceId" : "d06706c576dc41eaa301b0eed37cb985",

"StepTitle" : "Scan Scaffolder ID - QR Code",

"StaffDetail" : "Gary",

"LatLong" : "51.3427241956677,-0.489405904294238",

"Geo" : {

"type" : "Point",

"coordinates" : [

"-0.489405904294238",

"51.3427241956677"

]

},

"ReportedTime" : ISODate("2019-04-11T08:55:47.643+01:00"),

"EventTime" : ISODate("2019-04-11T08:55:47.643+01:00"),

"TsheetDate" : "2019-04-11",

"TsheetTime" : "07:56",

"ActualInputTime" : "08:55:47",

"Line" : null,

"DocumentLink" : "https://wfpnea89dda.azurewebsites.net/#/view?template=instancesPanel&h=4&instance=d06706c576dc41eaa301b0eed37cb985",

"DiffTime" : 0,

"Action" : "-"

},

/* 2 */

{

"InstanceTitle" : "MRSS Clock In App 2.0",

"TemplateTitle" : "MRSS Clock In App 2.0",

"Note" : "",

"Created" : ISODate("2019-04-11T08:49:52.281+01:00"),

"Updated" : ISODate("2019-04-11T08:56:50.713+01:00"),

"InstanceId" : "d06706c576dc41eaa301b0eed37cb985",

"StepTitle" : "Scan Scaffolder ID - QR Code",

"StaffDetail" : "Harrz",

"LatLong" : "51.3426832154301,-0.48943801401306",

"Geo" : {

"type" : "Point",

"coordinates" : [

"-0.48943801401306",

"51.3426832154301"

]

},

"ReportedTime" : ISODate("2019-04-11T08:55:55.608+01:00"),

"EventTime" : ISODate("2019-04-11T08:55:55.608+01:00"),

"TsheetDate" : "2019-04-11",

"TsheetTime" : "07:56",

"ActualInputTime" : "08:55:55",

"Line" : null,

"DocumentLink" : "https://wfpnea89dda.azurewebsites.net/#/view?template=instancesPanel&h=4&instance=d06706c576dc41eaa301b0eed37cb985",

"DiffTime" : 0,

"Action" : "-"

},

/* 3 */

{

"InstanceTitle" : "MRSS Clock In App 2.0",

"TemplateTitle" : "MRSS Clock In App 2.0",

"Note" : "",

"Created" : ISODate("2019-04-11T08:49:52.281+01:00"),

"Updated" : ISODate("2019-04-11T08:56:50.713+01:00"),

"InstanceId" : "d06706c576dc41eaa301b0eed37cb985",

"StepTitle" : "Scan Scaffolder ID - QR Code",

"StaffDetail" : "Matt",

"LatLong" : "51.3426629407945,-0.489377272769625",

"Geo" : {

"type" : "Point",

"coordinates" : [

"-0.489377272769625",

"51.3426629407945"

]

},

"ReportedTime" : ISODate("2019-04-11T08:56:07.006+01:00"),

"EventTime" : ISODate("2019-04-11T08:56:07.006+01:00"),

"TsheetDate" : "2019-04-11",

"TsheetTime" : "07:56",

"ActualInputTime" : "08:56:07",

"Line" : null,

"DocumentLink" : "https://wfpnea89dda.azurewebsites.net/#/view?template=instancesPanel&h=4&instance=d06706c576dc41eaa301b0eed37cb985",

"DiffTime" : 0,

"Action" : "-"

},

/* 4 */

{

"InstanceTitle" : "MRSS Clock In App 2.0",

"TemplateTitle" : "MRSS Clock In App 2.0",

"Note" : "",

"Created" : ISODate("2019-04-11T08:49:52.281+01:00"),

"Updated" : ISODate("2019-04-11T08:56:50.713+01:00"),

"InstanceId" : "d06706c576dc41eaa301b0eed37cb985",

"StepTitle" : "Scan Scaffolder ID - QR Code",

"StaffDetail" : "Marc",

"LatLong" : "51.3426734522219,-0.489381496602861",

"Geo" : {

"type" : "Point",

"coordinates" : [

"-0.489381496602861",

"51.3426734522219"

]

},

"ReportedTime" : ISODate("2019-04-11T08:56:13.989+01:00"),

"EventTime" : ISODate("2019-04-11T08:56:13.989+01:00"),

"TsheetDate" : "2019-04-11",

"TsheetTime" : "07:56",

"ActualInputTime" : "08:56:13",

"Line" : null,

"DocumentLink" : "https://wfpnea89dda.azurewebsites.net/#/view?template=instancesPanel&h=4&instance=d06706c576dc41eaa301b0eed37cb985",

"DiffTime" : 0,

"Action" : "-"

},

/* 5 */

{

"InstanceTitle" : "MRSS Clock In App 2.0",

"TemplateTitle" : "MRSS Clock In App 2.0",

"Note" : "",

"Created" : ISODate("2019-04-11T08:49:52.281+01:00"),

"Updated" : ISODate("2019-04-11T08:56:50.713+01:00"),

"InstanceId" : "d06706c576dc41eaa301b0eed37cb985",

"StepTitle" : "Scan Scaffolder ID - QR Code",

"StaffDetail" : "John",

"LatLong" : "51.3427595516148,-0.489363184215889",

"Geo" : {

"type" : "Point",

"coordinates" : [

"-0.489363184215889",

"51.3427595516148"

]

},

"ReportedTime" : ISODate("2019-04-11T08:56:28.330+01:00"),

"EventTime" : ISODate("2019-04-11T08:56:28.330+01:00"),

"TsheetDate" : "2019-04-11",

"TsheetTime" : "07:56",

"ActualInputTime" : "08:56:28",

"Line" : null,

"DocumentLink" : "https://wfpnea89dda.azurewebsites.net/#/view?template=instancesPanel&h=4&instance=d06706c576dc41eaa301b0eed37cb985",

"DiffTime" : 0,

"Action" : "-"

},

/* 6 */

{

"InstanceTitle" : "MRSS Clock In App 2.0",

"TemplateTitle" : "MRSS Clock In App 2.0",

"Note" : "",

"Created" : ISODate("2019-04-14T14:36:12.117+01:00"),

"Updated" : ISODate("2019-04-14T14:39:34.570+01:00"),

"InstanceId" : "aabf54f6945543d9a6ba1b30f1b806a4",

"StepTitle" : "Scan Scaffolder ID - QR Code",

"StaffDetail" : "*197.JW974394C.5887742.Tom.Scott-*",

"LatLong" : "51.342590701517,-0.489372365852279",

"Geo" : {

"type" : "Point",

"coordinates" : [

"-0.489372365852279",

"51.342590701517"

]

},

"ReportedTime" : ISODate("2019-04-14T14:38:50.429+01:00"),

"EventTime" : ISODate("2019-04-14T14:38:50.429+01:00"),

"TsheetDate" : "2019-04-14",

"TsheetTime" : "13:39",

"ActualInputTime" : "14:38:50",

"Line" : null,

"DocumentLink" : "https://wfpnea89dda.azurewebsites.net/#/view?template=instancesPanel&h=4&instance=aabf54f6945543d9a6ba1b30f1b806a4",

"DiffTime" : 0,

"Action" : "-"

},

/* 7 */

{

"InstanceTitle" : "MRSS Clock In App 2.0",

"TemplateTitle" : "MRSS Clock In App 2.0",

"Note" : "",

"Created" : ISODate("2019-04-14T14:36:12.117+01:00"),

"Updated" : ISODate("2019-04-14T14:39:34.570+01:00"),

"InstanceId" : "aabf54f6945543d9a6ba1b30f1b806a4",

"StepTitle" : "Scan Scaffolder ID - QR Code",

"StaffDetail" : "*257.JP598447D.907311.Terry.Wescott-*",

"LatLong" : "51.3419937025513,-0.489274198584569",

"Geo" : {

"type" : "Point",

"coordinates" : [

"-0.489274198584569",

"51.3419937025513"

]

},

"ReportedTime" : ISODate("2019-04-14T14:39:06.888+01:00"),

"EventTime" : ISODate("2019-04-14T14:39:06.888+01:00"),

"TsheetDate" : "2019-04-14",

"TsheetTime" : "13:39",

"ActualInputTime" : "14:39:06",

"Line" : null,

"DocumentLink" : "https://wfpnea89dda.azurewebsites.net/#/view?template=instancesPanel&h=4&instance=aabf54f6945543d9a6ba1b30f1b806a4",

"DiffTime" : 0,

"Action" : "-"

},

/* 8 */

{

"InstanceTitle" : "MRSS Clock In App 2.0",

"TemplateTitle" : "MRSS Clock In App 2.0",

"Note" : "",

"Created" : ISODate("2019-04-14T14:36:12.117+01:00"),

"Updated" : ISODate("2019-04-14T14:39:34.570+01:00"),

"InstanceId" : "aabf54f6945543d9a6ba1b30f1b806a4",

"StepTitle" : "Scan Scaffolder ID - QR Code",

"StaffDetail" : "*347.JH124295D..Jason.Saunders-*",

"LatLong" : "51.3422604030836,-0.489315639199066",

"Geo" : {

"type" : "Point",

"coordinates" : [

"-0.489315639199066",

"51.3422604030836"

]

},

"ReportedTime" : ISODate("2019-04-14T14:39:15.332+01:00"),

"EventTime" : ISODate("2019-04-14T14:39:15.332+01:00"),

"TsheetDate" : "2019-04-14",

"TsheetTime" : "13:39",

"ActualInputTime" : "14:39:15",

"Line" : null,

"DocumentLink" : "https://wfpnea89dda.azurewebsites.net/#/view?template=instancesPanel&h=4&instance=aabf54f6945543d9a6ba1b30f1b806a4",

"DiffTime" : 0,

"Action" : "-"

},

/* 9 */

{

"InstanceTitle" : "MRSS Clock In App 2.0",

"TemplateTitle" : "MRSS Clock In App 2.0",

"Note" : "",

"Created" : ISODate("2019-04-14T14:36:12.117+01:00"),

"Updated" : ISODate("2019-04-14T14:39:34.570+01:00"),

"InstanceId" : "aabf54f6945543d9a6ba1b30f1b806a4",

"StepTitle" : "Scan Scaffolder ID - QR Code",

"StaffDetail" : "*436.PH302468A..Sean.Smith-*",

"LatLong" : "51.3423787741559,-0.489291868844407",

"Geo" : {

"type" : "Point",

"coordinates" : [

"-0.489291868844407",

"51.3423787741559"

]

},

"ReportedTime" : ISODate("2019-04-14T14:39:24.650+01:00"),

"EventTime" : ISODate("2019-04-14T14:39:24.650+01:00"),

"TsheetDate" : "2019-04-14",

"TsheetTime" : "13:39",

"ActualInputTime" : "14:39:24",

"Line" : null,

"DocumentLink" : "https://wfpnea89dda.azurewebsites.net/#/view?template=instancesPanel&h=4&instance=aabf54f6945543d9a6ba1b30f1b806a4",

"DiffTime" : 0,

"Action" : "-"

},

/* 10 */

{

"InstanceTitle" : "MRSS Clock In App 2.0",

"TemplateTitle" : "MRSS Clock In App 2.0",

"Note" : "",

"Created" : ISODate("2019-04-14T14:36:12.117+01:00"),

"Updated" : ISODate("2019-04-14T14:39:34.570+01:00"),

"InstanceId" : "aabf54f6945543d9a6ba1b30f1b806a4",

"StepTitle" : "Scan Scaffolder ID - QR Code",

"StaffDetail" : "*240.JN050690C.01011798.Tony .Nash-*",

"LatLong" : "51.3424132913661,-0.489320455126413",

"Geo" : {

"type" : "Point",

"coordinates" : [

"-0.489320455126413",

"51.3424132913661"

]

},

"ReportedTime" : ISODate("2019-04-14T14:39:32.590+01:00"),

"EventTime" : ISODate("2019-04-14T14:39:32.590+01:00"),

"TsheetDate" : "2019-04-14",

"TsheetTime" : "13:39",

"ActualInputTime" : "14:39:32",

"Line" : null,

"DocumentLink" : "https://wfpnea89dda.azurewebsites.net/#/view?template=instancesPanel&h=4&instance=aabf54f6945543d9a6ba1b30f1b806a4",

"DiffTime" : 0,

"Action" : "-"

},

/* 11 */

{

"InstanceTitle" : "MRSS Clock In App 2.0",

"TemplateTitle" : "MRSS Clock In App 2.0",

"Note" : "",

"Created" : ISODate("2019-04-14T16:45:23.102+01:00"),

"Updated" : ISODate("2019-04-14T16:47:19.265+01:00"),

"InstanceId" : "5c14ef9a96e448248c1a2d462ecd0e95",

"StepTitle" : "Scan Scaffolder ID - QR Code",

"StaffDetail" : "*332.NM373621A..Lester.Webb-*",

"LatLong" : "51.3426519242315,-0.489132037153805",

"Geo" : {

"type" : "Point",

"coordinates" : [

"-0.489132037153805",

"51.3426519242315"

]

},

"ReportedTime" : ISODate("2019-04-14T16:47:17.238+01:00"),

"EventTime" : ISODate("2019-04-14T16:46:53.097+01:00"),

"TsheetDate" : "2019-04-14",

"TsheetTime" : "16:47",

"ActualInputTime" : "16:46:53",

"Line" : null,

"DocumentLink" : "https://wfpnea89dda.azurewebsites.net/#/view?template=instancesPanel&h=4&instance=5c14ef9a96e448248c1a2d462ecd0e95",

"DiffTime" : -0.40235,

"Action" : "-"

},

/* 12 */

{

"InstanceTitle" : "MRSS Clock In App 2.0",

"TemplateTitle" : "MRSS Clock In App 2.0",

"Note" : "",

"Created" : ISODate("2019-04-14T16:45:23.102+01:00"),

"Updated" : ISODate("2019-04-14T16:47:19.265+01:00"),

"InstanceId" : "5c14ef9a96e448248c1a2d462ecd0e95",

"StepTitle" : "Scan Scaffolder ID - QR Code",

"StaffDetail" : "*249.JH573851D.1916849.Danny.Smith-*",

"LatLong" : "51.3426484981762,-0.489149679516241",

"Geo" : {

"type" : "Point",

"coordinates" : [

"-0.489149679516241",

"51.3426484981762"

]

},

"ReportedTime" : ISODate("2019-04-14T16:47:17.238+01:00"),

"EventTime" : ISODate("2019-04-14T16:47:06.807+01:00"),

"TsheetDate" : "2019-04-14",

"TsheetTime" : "16:47",

"ActualInputTime" : "16:47:06",

"Line" : null,

"DocumentLink" : "https://wfpnea89dda.azurewebsites.net/#/view?template=instancesPanel&h=4&instance=5c14ef9a96e448248c1a2d462ecd0e95",

"DiffTime" : -0.17385,

"Action" : "-"

},

/* 13 */

{

"InstanceTitle" : "MRSS Clock In App 2.0",

"TemplateTitle" : "MRSS Clock In App 2.0",

"Note" : "",

"Created" : ISODate("2019-04-14T16:45:23.102+01:00"),

"Updated" : ISODate("2019-04-14T16:47:19.265+01:00"),

"InstanceId" : "5c14ef9a96e448248c1a2d462ecd0e95",

"StepTitle" : "Scan Scaffolder ID - QR Code",

"StaffDetail" : "*249.JH573851D.1916849.Danny.Smith-*",

"LatLong" : "51.3427484636305,-0.488999644450873",

"Geo" : {

"type" : "Point",

"coordinates" : [

"-0.488999644450873",

"51.3427484636305"

]

},

"ReportedTime" : ISODate("2019-04-14T16:47:17.238+01:00"),

"EventTime" : ISODate("2019-04-14T16:47:15.761+01:00"),

"TsheetDate" : "2019-04-14",

"TsheetTime" : "16:47",

"ActualInputTime" : "16:47:15",

"Line" : null,

"DocumentLink" : "https://wfpnea89dda.azurewebsites.net/#/view?template=instancesPanel&h=4&instance=5c14ef9a96e448248c1a2d462ecd0e95",

"DiffTime" : -0.024616666666666665,

"Action" : "-"

},

/* 14 */

{

"InstanceTitle" : "MRSS Clock In App 2.0",

"TemplateTitle" : "MRSS Clock In App 2.0",

"Note" : "",

"Created" : ISODate("2019-04-14T22:01:55.413+01:00"),

"Updated" : ISODate("2019-04-14T22:05:00.443+01:00"),

"InstanceId" : "2e44507fc47246a8a1fc101beeaf604d",

"StepTitle" : "Scan Scaffolder ID - QR Code",

"StaffDetail" : "*347.JH124295D..Jason.Saunders-*",

"LatLong" : "51.3429379323121,-0.489284643575181",

"Geo" : {

"type" : "Point",

"coordinates" : [

"-0.489284643575181",

"51.3429379323121"

]

},

"ReportedTime" : ISODate("2019-04-14T22:04:52.504+01:00"),

"EventTime" : ISODate("2019-04-14T22:04:19.080+01:00"),

"TsheetDate" : "2019-04-14",

"TsheetTime" : "22:04",

"ActualInputTime" : "22:04:19",

"Line" : null,

"DocumentLink" : "https://wfpnea89dda.azurewebsites.net/#/view?template=instancesPanel&h=4&instance=2e44507fc47246a8a1fc101beeaf604d",

"DiffTime" : -0.5570666666666667,

"Action" : "-"

},

/* 15 */

{

"InstanceTitle" : "MRSS Clock In App 2.0",

"TemplateTitle" : "MRSS Clock In App 2.0",

"Note" : "",

"Created" : ISODate("2019-04-14T22:01:55.413+01:00"),

"Updated" : ISODate("2019-04-14T22:05:00.443+01:00"),

"InstanceId" : "2e44507fc47246a8a1fc101beeaf604d",

"StepTitle" : "Scan Scaffolder ID - QR Code",

"StaffDetail" : "*365.JN099838C.01884772.Stuart.Fairbairn-*",

"LatLong" : "51.3430999169738,-0.489425834781759",

"Geo" : {

"type" : "Point",

"coordinates" : [

"-0.489425834781759",

"51.3430999169738"

]

},

"ReportedTime" : ISODate("2019-04-14T22:04:52.504+01:00"),

"EventTime" : ISODate("2019-04-14T22:04:35.339+01:00"),

"TsheetDate" : "2019-04-14",

"TsheetTime" : "22:04",

"ActualInputTime" : "22:04:35",

"Line" : null,

"DocumentLink" : "https://wfpnea89dda.azurewebsites.net/#/view?template=instancesPanel&h=4&instance=2e44507fc47246a8a1fc101beeaf604d",

"DiffTime" : -0.28608333333333336,

"Action" : "-"

},

/* 16 */

{

"InstanceTitle" : "MRSS Clock In App 2.0",

"TemplateTitle" : "MRSS Clock In App 2.0",

"Note" : "",

"Created" : ISODate("2019-04-14T22:01:55.413+01:00"),

"Updated" : ISODate("2019-04-14T22:05:00.443+01:00"),

"InstanceId" : "2e44507fc47246a8a1fc101beeaf604d",

"StepTitle" : "Scan Scaffolder ID - QR Code",

"StaffDetail" : "*433.JX302075D.06428362.Sam.Constantinou-*",

"LatLong" : "51.3434205470091,-0.489788215494082",

"Geo" : {

"type" : "Point",

"coordinates" : [

"-0.489788215494082",

"51.3434205470091"

]

},

"ReportedTime" : ISODate("2019-04-14T22:04:52.504+01:00"),

"EventTime" : ISODate("2019-04-14T22:04:51.250+01:00"),

"TsheetDate" : "2019-04-14",

"TsheetTime" : "22:04",

"ActualInputTime" : "22:04:51",

"Line" : null,

"DocumentLink" : "https://wfpnea89dda.azurewebsites.net/#/view?template=instancesPanel&h=4&instance=2e44507fc47246a8a1fc101beeaf604d",

"DiffTime" : -0.0209,

"Action" : "-"

}

In this screen,I get the tooltip but I don't know how to initiate the viewer - the "p" option does not show?

Just tried the new version - still not working for me, perhaps I am doing this wrong?

In your Geo data, the coordinates are an array of strings, and Geo JSON requires that "coordinates" be an array of numbers.

"Geo" : {

"type" : "Point",

"coordinates" : ["-0.489788215494082","51.3434205470091"] // requires: [-0.489788215494082,51.3434205470091]

},

Thanks so much - I was blind to the string.

All working thanks a million.