trees

17 rows where SiteOrder = 3 and qSpecies_id = 118

✎ View and edit SQL

This data as json, CSV (advanced)

SiteOrder ✖

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)
7989 132465 DPW Maintained 1 Pittosporum tobira :: Japanese Mockorange 118 1059 Vallejo St 3 Sidewalk: Property side : Yard Tree Private 2     4 Width 4ft   6008496.61422 2118601.48862 37.7977552443725 -122.414661419682 (37.7977552443725, -122.414661419682) 5 1 10 308 21
21712 234015 DPW Maintained 1 Pittosporum tobira :: Japanese Mockorange 118 501 Alabama St 3 Sidewalk: Property side : Yard Tree Private 2     8 Width 2ft   6008997.09738 2105837.44359 37.7627363201354 -122.412027100378 (37.7627363201354, -122.412027100378) 8 4 7 28859 19
23901 211523 DPW Maintained 1 Pittosporum tobira :: Japanese Mockorange 118 401 Victoria St 3 Sidewalk: Property side : Yard Tree Private 2     4 Width 5ft   5993219.9423 2089913.80561 37.7181161851864 -122.465437434695 (37.7181161851864, -122.465437434695) 9 8 6 64 24
29709 132448 DPW Maintained 1 Pittosporum tobira :: Japanese Mockorange 118 181 Marina Blvd 3 Sidewalk: Property side : Yard Tree Private 2     5 Width 10ft   6002667.37889 2121595.19878 37.8056459571542 -122.435046380379 (37.8056459571542, -122.435046380379) 13 9 1 57 17
37002 234024 DPW Maintained 1 Pittosporum tobira :: Japanese Mockorange 118 1457 Noe St 3 Sidewalk: Property side : Yard Tree Private 2     5 Width 3ft   6003332.4002 2099733.23178 37.7456561458138 -122.431183542201 (37.7456561458138, -122.431183542201) 2 7 5 63 22
45206 178422 DPW Maintained 1 Pittosporum tobira :: Japanese Mockorange 118 225 Silver Ave 3 Sidewalk: Property side : Yard Tree Private 2     7 Width 4ft   6002666.77722 2093942.85568 37.7297193641361 -122.433071531246 (37.7297193641361, -122.433071531246) 9 7 6 28861 25
79044 109107 DPW Maintained 1 Pittosporum tobira :: Japanese Mockorange 118 461X Cherry St 3 Sidewalk: Curb side : Cutout Tree Private 2   01/28/2015 12:00:00 AM 3   Permit Number 774020 5996243.86079 2114742.72809 37.7864641110096 -122.456779845468 (37.7864641110096, -122.456779845468) 11 6 1 54 31
82093 211534 DPW Maintained 1 Pittosporum tobira :: Japanese Mockorange 118 289 Joost Ave 3 Sidewalk: Property side : Yard Tree Private 2     16 Width 10ft   6000200.74101 2094921.6506 37.7322667154412 -122.441667078689 (37.7322667154412, -122.441667078689) 9 7 4 63 40
82622 178426 DPW Maintained 1 Pittosporum tobira :: Japanese Mockorange 118 102 Bowdoin St 3 Sidewalk: Property side : Yard Tree Private 2     6 Width 6ft   6008420.44433 2094541.08312 37.7316866608147 -122.413222695081 (37.7316866608147, -122.413222695081) 9 3 7 309 28
85813 234022 DPW Maintained 1 Pittosporum tobira :: Japanese Mockorange 118 541 Grand View Ave 3 Sidewalk: Property side : Yard Tree Private 2     12 Width 5ft   6000039.36468 2101755.51128 37.7510216765301 -122.442715512834 (37.7510216765301, -122.442715512834) 2 4 5 28862 22
102514 132461 DPW Maintained 1 Pittosporum tobira :: Japanese Mockorange 118 1109 Chestnut St 3 Side Yard : Yard Tree Private 2     12     6006461.025 2120401.52473 37.8025831108771 -122.421833058859 (37.8025831108771, -122.421833058859) 5 9 1 28858 32
103012 102477 Undocumented 4 Pittosporum tobira :: Japanese Mockorange 118 760 Victoria St 3 Sidewalk: Property side : Yard Tree Private 2           5993664.7 2092172.3 37.7243431058269 -122.464063971167 (37.7243431058269, -122.464063971167) 9 8 4 59 40
105258 132452 DPW Maintained 1 Pittosporum tobira :: Japanese Mockorange 118 1111 Chestnut St 3 Front Yard : Yard Tree Private 2     3     6006420.79232 2120396.51969 37.8025670993618 -122.421971928556 (37.8025670993618, -122.421971928556) 5 9 1 28858 32
150803 194603 DPW Maintained 1 Pittosporum tobira :: Japanese Mockorange 118 500 Wisconsin St 3 Sidewalk: Property side : Yard Tree Private 2     10 Width 9ft   6012631.4012 2105136.35292 37.7610145177263 -122.399408030156 (37.7610145177263, -122.399408030156) 10 3 8 28856 29
151947 178428 DPW Maintained 1 Pittosporum tobira :: Japanese Mockorange 118 316 Naylor St 3 Sidewalk: Property side : Yard Tree Private 2     6     6002738.37223 2086564.48621 37.7094640587023 -122.432297272501 (37.7094640587023, -122.432297272501) 9 7 6 28861 5
154499 211530 DPW Maintained 1 Pittosporum tobira :: Japanese Mockorange 118 321 Melrose Ave 3 : Yard Tree Private 2     16     5997959.2212 2095523.47143 37.7337912038987 -122.449459834627 (37.7337912038987, -122.449459834627) 9 7 4 59 40
179292 29960 DPW Maintained 1 Pittosporum tobira :: Japanese Mockorange 118 400X Junipero Serra Blvd 3 Median : Cutout Tree DPW 1   04/01/2007 12:00:00 AM 3 3x3   5991377.13547 2094257.77257 37.7299371880305 -122.472123623432 (37.7299371880305, -122.472123623432) 9 8 4 64 40

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);