54 rows where Fire Prevention Districts = 5 and qSpecies_id = 5 sorted by PlantDate

View and edit SQL

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)
8003 21791 Permitted Site 7 Ceratonia siliqua :: Carob 5 2585 Taylor St 6 Sidewalk: Curb side : Cutout Tree Private 2     8 4X4   6008347.28278 2121527.17705 37.8057800612465 -122.415385378175 (37.8057800612465, -122.415385378175) 5 1 10 308 23
9018 126003 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2510 Jones St 8 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 4ft   6007892.37102 2121599.81603 37.8059539308952 -122.416964822665 (37.8059539308952, -122.416964822665) 5 1 10 308 23
19339 21778 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2500X Taylor St 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 5X5   6008409.45282 2121407.87429 37.8054559800011 -122.415161778523 (37.8054559800011, -122.415161778523) 5 1 10 308 23
23100 125989 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2501 Taylor St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6008326.45195 2121634.40634 37.8060733149832 -122.41546506288 (37.8060733149832, -122.41546506288) 5 1 10 308 23
37876 125979 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2500 Taylor St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 4ft   6008389.02756 2121512.5692 37.8057422979318 -122.41523987894 (37.8057422979318, -122.41523987894) 5 1 10 308 23
38272 125985 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2550 Taylor St 6 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 6ft   6008371.27829 2121652.4837 37.8061254702907 -122.415311214049 (37.8061254702907, -122.415311214049) 5 1 10 308 23
49612 125976 DPW Maintained 1 Ceratonia siliqua :: Carob 5 633 Beach St 5 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6007074.37921 2121877.42075 37.8066701158897 -122.419815329109 (37.8066701158897, -122.419815329109) 5 1 1 28858 32
55436 126001 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2510 Jones St 6 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6007899.07258 2121560.79928 37.8058471777553 -122.41693886466 (37.8058471777553, -122.41693886466) 5 1 10 308 23
56492 21779 Permitted Site 7 Ceratonia siliqua :: Carob 5 2535 Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 4x4   6008355.3148 2121474.21304 37.8056350868765 -122.415353830252 (37.8056350868765, -122.415353830252) 5 1 10 308 23
59975 125986 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2550 Taylor St 7 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 6ft   6008368.52895 2121668.47116 37.8061692132974 -122.415321861121 (37.8061692132974, -122.415321861121) 5 1 10 308 23
64093 21787 Permitted Site 7 Ceratonia siliqua :: Carob 5 2585 Taylor St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 4X4   6008331.30284 2121636.25204 37.8060786554609 -122.415448406282 (37.8060786554609, -122.415448406282) 5 1 10 308 23
67416 125984 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2550 Taylor St 5 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 6ft   6008373.73288 2121637.11508 37.8060834098955 -122.41530163086 (37.8060834098955, -122.41530163086) 5 1 10 308 23
67442 21780 Permitted Site 7 Ceratonia siliqua :: Carob 5 2535 Taylor St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 4X4   6008357.89402 2121452.8869 37.805576675639 -122.41534339379 (37.805576675639, -122.41534339379) 5 1 10 308 23
67782 125998 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2510 Jones St 3 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 4ft   6007907.02571 2121498.39071 37.8056762669961 -122.416906917118 (37.8056762669961, -122.416906917118) 5 1 10 308 23
69120 125994 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2501 Taylor St 8 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6008347.52133 2121476.34798 37.8056405108592 -122.415380951989 (37.8056405108592, -122.415380951989) 5 1 10 308 23
71054 21785 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2585 Taylor St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6008161.90241 2121549.79462 37.8058317424248 -122.41602851934 (37.8058317424248, -122.41602851934) 5 1 10 308 23
72985 21790 Permitted Site 7 Ceratonia siliqua :: Carob 5 2585 Taylor St 5 Sidewalk: Curb side : Cutout Tree Private 2     9 4X4   6008342.51156 2121554.8602 37.8058558040212 -122.415403850799 (37.8058558040212, -122.415403850799) 5 1 10 308 23
75395 125996 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2510 Jones St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6007913.10752 2121457.27998 37.8055637294392 -122.41688295558 (37.8055637294392, -122.41688295558) 5 1 10 308 23
77396 125972 DPW Maintained 1 Ceratonia siliqua :: Carob 5 633 Beach St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6006913.21617 2121857.59743 37.8066066057793 -122.420371657826 (37.8066066057793, -122.420371657826) 5 1 1 28858 32
79309 125987 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2550 Taylor St 8 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 6ft   6008367.52131 2121686.8739 37.8062196859398 -122.415326651828 (37.8062196859398, -122.415326651828) 5 1 10 308 23
84314 125975 DPW Maintained 1 Ceratonia siliqua :: Carob 5 633 Beach St 4 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007035.47478 2121873.14157 37.8066561746197 -122.419949661756 (37.8066561746197, -122.419949661756) 5 1 1 28858 32
85002 125991 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2501 Taylor St 5 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6008338.82398 2121554.95666 37.8058558616148 -122.415416619107 (37.8058558616148, -122.415416619107) 5 1 10 308 23
85699 11179 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2750X Hyde St 1 Sidewalk: Curb side : Cutout Tree DPW 1     36 3x3   6006893.59102 2121789.4662 37.8064184289444 -122.4204347354 (37.8064184289444, -122.4204347354) 5 1 1 28858 32
87824 125999 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2510 Jones St 4 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6007905.9664 2121521.7786 37.8057404246312 -122.416912241104 (37.8057404246312, -122.416912241104) 5 1 10 308 23
95994 11181 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2750X Hyde St 3 Sidewalk: Curb side : Cutout Tree DPW 1     14 3X3   6006890.68476 2121823.94924 37.8065129467732 -122.420447242256 (37.8065129467732, -122.420447242256) 5 1 1 28858 32
98799 126000 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2510 Jones St 5 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   6007902.73328 2121542.33791 37.8057966934257 -122.416924887385 (37.8057966934257, -122.416924887385) 5 1 10 308 23
99094 21776 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2500X Taylor St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6008409.45282 2121407.87429 37.8054559800011 -122.415161778523 (37.8054559800011, -122.415161778523) 5 1 10 308 23
107672 125981 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2550 Taylor St 2 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 6ft   6008384.91577 2121552.17509 37.8058508146246 -122.415256913874 (37.8058508146246, -122.415256913874) 5 1 10 308 23
112246 125993 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2501 Taylor St 7 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6008342.47163 2121500.19485 37.8057057045282 -122.415400116539 (37.8057057045282, -122.415400116539) 5 1 10 308 23
122903 125992 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2501 Taylor St 6 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6008341.11218 2121531.47257 37.8057915088426 -122.415407036818 (37.8057915088426, -122.415407036818) 5 1 10 308 23
124920 125982 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2550 Taylor St 3 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 6ft   6008379.56749 2121591.49972 37.8059584895516 -122.415278208017 (37.8059584895516, -122.415278208017) 5 1 10 308 23
125848 125983 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2550 Taylor St 4 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 5ft   6008377.32314 2121617.1276 37.8060287311026 -122.415287790321 (37.8060287311026, -122.415287790321) 5 1 10 308 23
126551 125995 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2501 Taylor St 9 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6008349.66203 2121453.17315 37.8055769989413 -122.415371902112 (37.8055769989413, -122.415371902112) 5 1 10 308 23
131190 126002 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2510 Jones St 7 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6007897.34981 2121579.98706 37.8058997656297 -122.416946186927 (37.8058997656297, -122.416946186927) 5 1 10 308 23
139674 101042 Permitted Site 7 Ceratonia siliqua :: Carob 5 655 Beach St 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 47845 6006837 2121873 37.8066446021589 -122.420636512845 (37.8066446021589, -122.420636512845) 5 1 1 28858 32
140473 11180 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2750X Hyde St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6006892.18437 2121805.14198 37.806461391357 -122.420440716763 (37.806461391357, -122.420440716763) 5 1 1 28858 32
142841 21786 Permitted Site 7 Ceratonia siliqua :: Carob 5 2585 Taylor St 7 Sidewalk: Curb side : Cutout Tree Private 2     8 4X4   6008350.54359 2121501.89618 37.8057108296313 -122.415372302772 (37.8057108296313, -122.415372302772) 5 1 10 308 23
144028 125988 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2501 Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6008319.39655 2121673.00017 37.806178887323 -122.415492213411 (37.806178887323, -122.415492213411) 5 1 10 308 23
145716 101044 Permitted Site 7 Ceratonia siliqua :: Carob 5 655 Beach St 4 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 47845 6006837 2121873 37.8066446021589 -122.420636512845 (37.8066446021589, -122.420636512845) 5 1 1 28858 32
146048 125974 DPW Maintained 1 Ceratonia siliqua :: Carob 5 633 Beach St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6007013.05823 2121870.81717 37.8066485294743 -122.420027073604 (37.8066485294743, -122.420027073604) 5 1 1 28858 32
149796 23565 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2958 Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     18 2X2   6005634.29929 2120573.5209 37.8030087114389 -122.424706189543 (37.8030087114389, -122.424706189543) 5 9 1 28858 32
152398 125977 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2500 Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6008401.62888 2121444.29683 37.8055555474172 -122.415191434251 (37.8055555474172, -122.415191434251) 5 1 10 308 23
154655 125978 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2500 Taylor St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6008392.85025 2121496.40648 37.8056981340166 -122.415225505068 (37.8056981340166, -122.415225505068) 5 1 10 308 23
156506 101043 Permitted Site 7 Ceratonia siliqua :: Carob 5 655 Beach St 3 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 47845 6006837 2121873 37.8066446021589 -122.420636512845 (37.8066446021589, -122.420636512845) 5 1 1 28858 32
161042 101045 Permitted Site 7 Ceratonia siliqua :: Carob 5 655 Beach St 5 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 47845 6006837 2121873 37.8066446021589 -122.420636512845 (37.8066446021589, -122.420636512845) 5 1 1 28858 32
167066 125973 DPW Maintained 1 Ceratonia siliqua :: Carob 5 633 Beach St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6006932.43872 2121860.17562 37.8066147680158 -122.420305317544 (37.8066147680158, -122.420305317544) 5 1 1 28858 32
178863 125997 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2510 Jones St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 4ft   6007910.60432 2121475.90892 37.8056147389887 -122.416892938958 (37.8056147389887, -122.416892938958) 5 1 10 308 23
188712 125990 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2501 Taylor St 4 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6008335.58159 2121584.43449 37.8059366180507 -122.415429928145 (37.8059366180507, -122.415429928145) 5 1 10 308 23
192924 125980 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2550 Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6008387.31056 2121533.89692 37.8058007619722 -122.415247331605 (37.8058007619722, -122.415247331605) 5 1 10 308 23
129067 51546 Permitted Site 7 Ceratonia siliqua :: Carob 5 655 Beach St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/01/2005 12:00:00 AM     Permit Number 47845 6007074.31830792 2121880.33708987 37.8066781199827 -122.419815746942 (37.8066781199827, -122.419815746942) 5 1 1 28858 32
60751 64436 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2445 Larkin St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/16/1988 12:00:00 AM 12   Permit Number 25292 6006658.75135 2119650.10198 37.8005310432266 -122.421095439396 (37.8005310432266, -122.421095439396) 5 9 1 28858 32
34503 21789 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2585 Taylor St 4 Sidewalk: Curb side : Cutout Tree DPW 1   05/20/2015 12:00:00 AM 3 4X4   6008161.90241 2121549.79462 37.8058317424248 -122.41602851934 (37.8058317424248, -122.41602851934) 5 1 10 308 23
122812 23566 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2958 Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/09/2005 12:00:00 AM 6     6005632.06356 2120580.68582 37.8030282582004 -122.424714436346 (37.8030282582004, -122.424714436346) 5 9 1 28858 32
64750 21777 Permitted Site 7 Ceratonia siliqua :: Carob 5 2500X Taylor St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/15/1992 12:00:00 AM 3 3x3   6008409.45282 2121407.87429 37.8054559800011 -122.415161778523 (37.8054559800011, -122.415161778523) 5 1 10 308 23

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