CARVIEW |
Select Language
HTTP/2 200
date: Wed, 23 Jul 2025 20:28:52 GMT
content-type: text/html; charset=utf-8
vary: X-PJAX, X-PJAX-Container, Turbo-Visit, Turbo-Frame, X-Requested-With,Accept-Encoding, Accept, X-Requested-With
etag: W/"b3c63e077f6aa781f9245021bfbcab0b"
cache-control: max-age=0, private, must-revalidate
strict-transport-security: max-age=31536000; includeSubdomains; preload
x-frame-options: deny
x-content-type-options: nosniff
x-xss-protection: 0
referrer-policy: no-referrer-when-downgrade
content-security-policy: default-src 'none'; base-uri 'self'; child-src github.githubassets.com github.com/assets-cdn/worker/ github.com/assets/ gist.github.com/assets-cdn/worker/; connect-src 'self' uploads.github.com www.githubstatus.com collector.github.com raw.githubusercontent.com api.github.com github-cloud.s3.amazonaws.com github-production-repository-file-5c1aeb.s3.amazonaws.com github-production-upload-manifest-file-7fdce7.s3.amazonaws.com github-production-user-asset-6210df.s3.amazonaws.com *.rel.tunnels.api.visualstudio.com wss://*.rel.tunnels.api.visualstudio.com objects-origin.githubusercontent.com copilot-proxy.githubusercontent.com proxy.individual.githubcopilot.com proxy.business.githubcopilot.com proxy.enterprise.githubcopilot.com *.actions.githubusercontent.com wss://*.actions.githubusercontent.com productionresultssa0.blob.core.windows.net/ productionresultssa1.blob.core.windows.net/ productionresultssa2.blob.core.windows.net/ productionresultssa3.blob.core.windows.net/ productionresultssa4.blob.core.windows.net/ productionresultssa5.blob.core.windows.net/ productionresultssa6.blob.core.windows.net/ productionresultssa7.blob.core.windows.net/ productionresultssa8.blob.core.windows.net/ productionresultssa9.blob.core.windows.net/ productionresultssa10.blob.core.windows.net/ productionresultssa11.blob.core.windows.net/ productionresultssa12.blob.core.windows.net/ productionresultssa13.blob.core.windows.net/ productionresultssa14.blob.core.windows.net/ productionresultssa15.blob.core.windows.net/ productionresultssa16.blob.core.windows.net/ productionresultssa17.blob.core.windows.net/ productionresultssa18.blob.core.windows.net/ productionresultssa19.blob.core.windows.net/ github-production-repository-image-32fea6.s3.amazonaws.com github-production-release-asset-2e65be.s3.amazonaws.com insights.github.com wss://alive.github.com api.githubcopilot.com api.individual.githubcopilot.com api.business.githubcopilot.com api.enterprise.githubcopilot.com; font-src github.githubassets.com; form-action 'self' github.com gist.github.com copilot-workspace.githubnext.com objects-origin.githubusercontent.com; frame-ancestors 'none'; frame-src viewscreen.githubusercontent.com notebooks.githubusercontent.com; img-src 'self' data: blob: github.githubassets.com media.githubusercontent.com camo.githubusercontent.com identicons.github.com avatars.githubusercontent.com private-avatars.githubusercontent.com github-cloud.s3.amazonaws.com objects.githubusercontent.com release-assets.githubusercontent.com secured-user-images.githubusercontent.com/ user-images.githubusercontent.com/ private-user-images.githubusercontent.com opengraph.githubassets.com copilotprodattachments.blob.core.windows.net/github-production-copilot-attachments/ github-production-user-asset-6210df.s3.amazonaws.com customer-stories-feed.github.com spotlights-feed.github.com objects-origin.githubusercontent.com *.githubusercontent.com; manifest-src 'self'; media-src github.com user-images.githubusercontent.com/ secured-user-images.githubusercontent.com/ private-user-images.githubusercontent.com github-production-user-asset-6210df.s3.amazonaws.com gist.github.com; script-src github.githubassets.com; style-src 'unsafe-inline' github.githubassets.com; upgrade-insecure-requests; worker-src github.githubassets.com github.com/assets-cdn/worker/ github.com/assets/ gist.github.com/assets-cdn/worker/
server: github.com
content-encoding: gzip
accept-ranges: bytes
set-cookie: _gh_sess=LKWs6duTh98A9sASeVIn7bO9ed2YLQketxS3t0DEmsPVz9Zit15PCBVVS7Gae50BSYOGFP%2Fgjyj%2BK47FiRq1%2B4LAJEE9VX6CFUUZXpTBfFJ1f2FZx5rhKyTTv6ohdiFosL73zQ1t7aBiMyA9sUFuwlqUO5qNLujJ50AmMd0imsmUC2zn6Xri%2BpM3uqaxvVV1FTcvyPKG9gtG3%2B%2BOo0EaBDG8AnVOSAX%2B68UClcVkd4y8nNWfsMwbKhZcMvbGAEGCfS3TElT0jVbMV3b0asPeMw%3D%3D--NQlxwJ%2BUZk86f7%2Bj--9Ij3IxBC5ApoozKKmn0rtw%3D%3D; Path=/; HttpOnly; Secure; SameSite=Lax
set-cookie: _octo=GH1.1.438216795.1753302532; Path=/; Domain=github.com; Expires=Thu, 23 Jul 2026 20:28:52 GMT; Secure; SameSite=Lax
set-cookie: logged_in=no; Path=/; Domain=github.com; Expires=Thu, 23 Jul 2026 20:28:52 GMT; HttpOnly; Secure; SameSite=Lax
x-github-request-id: 8564:35B563:1098B8E:13BA825:68814604
Working with 189MB JSON document · thedevsaddam/gojsonq Wiki · GitHub
Skip to content
Navigation Menu
{{ message }}
-
Notifications
You must be signed in to change notification settings - Fork 141
Working with 189MB JSON document
Saddam H edited this page Jul 1, 2018
·
1 revision
Input File:
Size: 189MB
Link: https://github.com/zemirco/sf-city-lots-json
Array size: 206560
Sample Code:
package main
import (
"fmt"
"time"
"github.com/davecgh/go-spew/spew"
"github.com/thedevsaddam/gojsonq"
)
func main() {
t1 := time.Now()
// load file and decode
jq := gojsonq.New().
File("./city.json")
t2 := time.Now()
// run query against the data
jq.From("features").WhereEqual("properties.MAPBLKLOT", "6092026")
spew.Dump(jq.Get(), jq.Errors())
fmt.Println("Total time: ", time.Since(t1))
fmt.Println("Query time: ", time.Since(t2))
}
Time taken:
Total time: 8.254741002s // file open, read, decoding and query
Query time: 216.347892ms // only query
Output:
go run main.go
([]interface {}) (len=1 cap=1) {
(map[string]interface {}) (len=3) {
(string) (len=4) "type": (string) (len=7) "Feature",
(string) (len=10) "properties": (map[string]interface {}) (len=9) {
(string) (len=9) "BLOCK_NUM": (string) (len=4) "6092",
(string) (len=7) "FROM_ST": (string) (len=3) "814",
(string) (len=6) "STREET": (string) (len=6) "PERSIA",
(string) (len=7) "ST_TYPE": (string) (len=3) "AVE",
(string) (len=8) "ODD_EVEN": (string) (len=1) "E",
(string) (len=9) "MAPBLKLOT": (string) (len=7) "6092026",
(string) (len=6) "BLKLOT": (string) (len=7) "6092026",
(string) (len=7) "LOT_NUM": (string) (len=3) "026",
(string) (len=5) "TO_ST": (string) (len=3) "814"
},
(string) (len=8) "geometry": (map[string]interface {}) (len=2) {
(string) (len=4) "type": (string) (len=7) "Polygon",
(string) (len=11) "coordinates": ([]interface {}) (len=1 cap=1) {
([]interface {}) (len=5 cap=8) {
([]interface {}) (len=3 cap=4) {
(float64) -122.42950545086512,
(float64) 37.7196273202666,
(float64) 0
},
([]interface {}) (len=3 cap=4) {
(float64) -122.42957956336745,
(float64) 37.71966264926639,
(float64) 0
},
([]interface {}) (len=3 cap=4) {
(float64) -122.42940162924815,
(float64) 37.71989812199502,
(float64) 0
},
([]interface {}) (len=3 cap=4) {
(float64) -122.42932751546155,
(float64) 37.719862792903164,
(float64) 0
},
([]interface {}) (len=3 cap=4) {
(float64) -122.42950545086512,
(float64) 37.7196273202666,
(float64) 0
}
}
}
}
}
}
([]error) <nil>
Total time: 8.254741002s
Query time: 216.347892ms
If you find the package useful please don't forget to star the repository
Clone this wiki locally
You can’t perform that action at this time.