trees
19 rows where qSpecies_id = 326 sorted by qCareAssistant
This data as json, CSV (advanced)
qLegalStatus_id ✖
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant ▼ | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8743 | 261207 | Significant Tree 6 | Umbellularia californica :: California Bay 326 | 2301 Leavenworth St | 3 | Side Yard : Yard | Tree | Private 2 | 3x3 | 6007514 | 2120271 | 37.8022840477627 | -122.418179969724 | (37.8022840477627, -122.418179969724) | 5 | 1 | 1 | 28858 | 32 | ||||
13348 | 198717 | DPW Maintained 1 | Umbellularia californica :: California Bay 326 | 1 Jack Balestreri Way | 38 | Front Yard : Yard | Tree | Private 2 | 10 | 6012427.07884 | 2104786.19155 | 37.7600416617243 | -122.400090104772 | (37.7600416617243, -122.400090104772) | 10 | 3 | 8 | 28856 | 29 | ||||
28947 | 198719 | DPW Maintained 1 | Umbellularia californica :: California Bay 326 | 1 Jack Balestreri Way | 40 | Front Yard : Yard | Tree | Private 2 | 5 | 6012426.60188 | 2104780.3365 | 37.760025558456 | -122.40009134316 | (37.760025558456, -122.40009134316) | 10 | 3 | 8 | 28856 | 29 | ||||
34867 | 198712 | DPW Maintained 1 | Umbellularia californica :: California Bay 326 | 1 Jack Balestreri Way | 12 | Front Yard : Yard | Tree | Private 2 | 4 | 6012409.2868 | 2104740.75677 | 37.7599159158162 | -122.400148448317 | (37.7599159158162, -122.400148448317) | 10 | 3 | 8 | 28856 | 29 | ||||
55491 | 198720 | DPW Maintained 1 | Umbellularia californica :: California Bay 326 | 1800 Illinois St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 7ft | 6016247.28658 | 2100667.2131 | 37.7489440726059 | -122.386590499372 | (37.7489440726059, -122.386590499372) | 10 | 3 | 8 | 58 | 1 | |||
56866 | 198718 | DPW Maintained 1 | Umbellularia californica :: California Bay 326 | 1 Jack Balestreri Way | 39 | Front Yard : Yard | Tree | Private 2 | 7 | 6012424.05702 | 2104786.65184 | 37.7600427570935 | -122.400100588189 | (37.7600427570935, -122.400100588189) | 10 | 3 | 8 | 28856 | 29 | ||||
60497 | 198711 | DPW Maintained 1 | Umbellularia californica :: California Bay 326 | 1 Jack Balestreri Way | 11 | Front Yard : Yard | Tree | Private 2 | 9 | 6012390.58934 | 2104733.77688 | 37.7598957080306 | -122.400212623923 | (37.7598957080306, -122.400212623923) | 10 | 3 | 8 | 28856 | 29 | ||||
63577 | 242817 | DPW Maintained 1 | Umbellularia californica :: California Bay 326 | 1001 San Jose Ave | 75 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 8ft | 6005376.58121 | 2097527.53797 | 37.7397154402194 | -122.423958242285 | (37.7397154402194, -122.423958242285) | 2 | 7 | 5 | 28859 | 2 | |||
68375 | 198716 | DPW Maintained 1 | Umbellularia californica :: California Bay 326 | 1 Jack Balestreri Way | 37 | Front Yard : Yard | Tree | Private 2 | 5 | 6012435.45526 | 2104782.66199 | 37.7600324373651 | -122.400060886699 | (37.7600324373651, -122.400060886699) | 10 | 3 | 8 | 28856 | 29 | ||||
75182 | 242818 | DPW Maintained 1 | Umbellularia californica :: California Bay 326 | 1001 San Jose Ave | 76 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 8ft | 6005391.8173 | 2097529.9468 | 37.7397229144901 | -122.423905733564 | (37.7397229144901, -122.423905733564) | 2 | 7 | 5 | 28859 | 2 | |||
103904 | 187619 | DPW Maintained 1 | Umbellularia californica :: California Bay 326 | 27 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005553 | 2098709 | 37.7429694263933 | -122.423432230366 | (37.7429694263933, -122.423432230366) | 2 | 7 | 5 | 28859 | 22 | ||||
142619 | 198714 | DPW Maintained 1 | Umbellularia californica :: California Bay 326 | 1 Jack Balestreri Way | 14 | Front Yard : Yard | Tree | Private 2 | 6 | 6012392.10432 | 2104746.43 | 37.7599305351797 | -122.40020827299 | (37.7599305351797, -122.40020827299) | 10 | 3 | 8 | 28856 | 29 | ||||
163082 | 187620 | DPW Maintained 1 | Umbellularia californica :: California Bay 326 | 33 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005528 | 2098708 | 37.7429652695588 | -122.423518602522 | (37.7429652695588, -122.423518602522) | 2 | 7 | 5 | 28859 | 22 | ||||
166443 | 242816 | DPW Maintained 1 | Umbellularia californica :: California Bay 326 | 2 Trainor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008308.46792 | 2108230.50138 | 37.7692684406077 | -122.41457818386 | (37.7692684406077, -122.41457818386) | 8 | 4 | 7 | 28853 | 19 | |||
170012 | 137083 | DPW Maintained 1 | Umbellularia californica :: California Bay 326 | 3699 Webster St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6002550.0727 | 2121200.59628 | 37.8045558214586 | -122.435424089363 | (37.8045558214586, -122.435424089363) | 13 | 9 | 1 | 57 | 17 | |||
177851 | 191362 | DPW Maintained 1 | Umbellularia californica :: California Bay 326 | 999 Key Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 27 | 6013336.3333 | 2089743.87801 | 37.7187892674983 | -122.39589132572 | (37.7187892674983, -122.39589132572) | 10 | 3 | 8 | 58 | 1 | ||||
189504 | 198713 | DPW Maintained 1 | Umbellularia californica :: California Bay 326 | 1 Jack Balestreri Way | 13 | Front Yard : Yard | Tree | Private 2 | 3 | 6012404.84739 | 2104738.96788 | 37.759910756386 | -122.400163676537 | (37.759910756386, -122.400163676537) | 10 | 3 | 8 | 28856 | 29 | ||||
193943 | 198715 | DPW Maintained 1 | Umbellularia californica :: California Bay 326 | 1 Jack Balestreri Way | 15 | Front Yard : Yard | Tree | Private 2 | 4 | 6012393.75722 | 2104758.14097 | 37.7599627830829 | -122.40020337888 | (37.7599627830829, -122.40020337888) | 10 | 3 | 8 | 28856 | 29 | ||||
40665 | 97022 | Property Tree 8 | Umbellularia californica :: California Bay 326 | 195B Kiska Rd | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | 10 | 3 | 8 | 58 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );