trees

19 rows where Fire Prevention Districts = 15, PlotSize = "Width 0ft" and qSpecies_id = 5

✎ View and edit SQL

This data as json, CSV (advanced)

PlotSize ✖

  • Width 0ft · 19 ✖

Fire Prevention Districts ✖

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)
19336 247504 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1398 Haight St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   5999483.6766 2108789.6708 37.7703040400286 -122.445142787454 (37.7703040400286, -122.445142787454) 15 5 11 29492 9
19461 138737 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2945 BUSH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   5999415.669 2114277.6236 37.7853686673978 -122.445772761062 (37.7853686673978, -122.445772761062) 15 6 1 29490 31
21471 139360 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2807 Bush St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   6000073 2114379 37.7856845299005 -122.443505885647 (37.7856845299005, -122.443505885647) 15 6 1 29490 31
53638 138239 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1509 Lyon St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   5999639.177 2114119.037 37.784945988756 -122.444988088871 (37.784945988756, -122.444988088871) 15 6 1 29490 31
56818 139055 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2693 SUTTER ST 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   5999732.7035 2113978.0164 37.7845641202108 -122.444654378813 (37.7845641202108, -122.444654378813) 15 6 11 29490 31
57482 140579 DPW Maintained 1 Ceratonia siliqua :: Carob 5 949 FILLMORE ST 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6003399.7999 2111643.4846 37.7783626547096 -122.431800729752 (37.7783626547096, -122.431800729752) 15 9 11 29492 41
68552 138242 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1509 Lyon St 4 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5999647.1063 2114070.9654 37.7848144491807 -122.444957199215 (37.7848144491807, -122.444957199215) 15 6 1 29490 31
75012 138241 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1509 Lyon St 3 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   5999646.1152 2114082.8594 37.7848470504501 -122.444961483404 (37.7848470504501, -122.444961483404) 15 6 1 29490 31
97344 138240 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1509 Lyon St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   5999643.6372 2114098.2225 37.7848890921049 -122.444971161243 (37.7848890921049, -122.444971161243) 15 6 1 29490 31
104983 244452 DPW Maintained 1 Ceratonia siliqua :: Carob 5 411 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6003668.1352 2109738.0991 37.7731461435953 -122.430736452264 (37.7731461435953, -122.430736452264) 15 9 11 29492 10
106329 142100 DPW Maintained 1 Ceratonia siliqua :: Carob 5 904 Fell St 5 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6002972.7027 2110318.8393 37.7747012881718 -122.433183544102 (37.7747012881718, -122.433183544102) 15 5 11 29492 10
108294 140580 DPW Maintained 1 Ceratonia siliqua :: Carob 5 949 FILLMORE ST 3 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6003403.4849 2111618.6108 37.7782945663272 -122.43178620552 (37.7782945663272, -122.43178620552) 15 9 11 29492 41
111478 139056 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2693 SUTTER ST 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5999748.2433 2113980.0087 37.7845704772917 -122.444600759792 (37.7845704772917, -122.444600759792) 15 6 11 29490 31
113408 139006 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1504 Lyon St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   5999695.1779 2114053.1244 37.7847682058679 -122.444789604899 (37.7847682058679, -122.444789604899) 15 6 1 29490 31
116533 138243 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1509 Lyon St 5 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 0ft   5999648.5931 2114056.0979 37.7847737117432 -122.444950986247 (37.7847737117432, -122.444950986247) 15 6 1 29490 31
139016 140578 DPW Maintained 1 Ceratonia siliqua :: Carob 5 949 FILLMORE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6003397.0361 2111670.2009 37.7784358543561 -122.431812198827 (37.7784358543561, -122.431812198827) 15 9 11 29492 41
156051 139008 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1504 Lyon St 3 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   5999687.2486 2114098.7181 37.7848929418184 -122.444820316061 (37.7848929418184, -122.444820316061) 15 6 1 29490 31
176339 244469 DPW Maintained 1 Ceratonia siliqua :: Carob 5 665 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6003415.8306 2109638.093 37.7728572538387 -122.431602065027 (37.7728572538387, -122.431602065027) 15 9 11 29492 10
179176 139007 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1504 Lyon St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   5999691.7088 2114071.461 37.7848183554363 -122.444802925313 (37.7848183554363, -122.444802925313) 15 6 1 29490 31

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