46 rows where Zip Codes = 308 and qSpecies_id = 5 sorted by Longitude

View and edit SQL

Zip Codes

  • 308 · 46
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)
81591 21783 Permitted Site 7 Ceratonia siliqua :: Carob 5 2550 TAYLOR ST 3 Sidewalk: Curb side : Cutout Tree Private 2     18 5x5   6008458.6 2121488.8 37.8056809434427 -122.414997429015 (37.8056809434427, -122.414997429015) 3 1 10 308 23
150613 21782 Permitted Site 7 Ceratonia siliqua :: Carob 5 2550 TAYLOR ST 2 Sidewalk: Curb side : Cutout Tree Private 2     18 5x5   6008458.6 2121488.8 37.8056809434427 -122.414997429015 (37.8056809434427, -122.414997429015) 3 1 10 308 23
135227 21781 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2550X Taylor St 1 Sidewalk: Curb side : Cutout Tree DPW 1   08/12/2011 12:00:00 AM 3 4x4   6008458.56586 2121488.77145 37.8056808631332 -122.41499754514 (37.8056808631332, -122.41499754514) 3 1 10 308 23
176301 21784 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2550X Taylor St 4 Sidewalk: Curb side : Cutout Tree DPW 1   02/11/2016 12:00:00 AM 12 4X4   6008458.56586 2121488.77145 37.8056808631332 -122.41499754514 (37.8056808631332, -122.41499754514) 3 1 10 308 23
36850 21792 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2598 Taylor St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6008439.13676 2121624.27905 37.8060518410095 -122.415074380155 (37.8060518410095, -122.415074380155) 3 1 10 308 23
100104 21793 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2598 Taylor St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6008439.13676 2121624.27905 37.8060518410095 -122.415074380155 (37.8060518410095, -122.415074380155) 3 1 10 308 23
142913 21795 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2598 Taylor St 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6008439.13676 2121624.27905 37.8060518410095 -122.415074380155 (37.8060518410095, -122.415074380155) 3 1 10 308 23
145684 21794 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2598 Taylor St 3 Sidewalk: Curb side : Cutout Tree DPW 1     21 4X4   6008439.13676 2121624.27905 37.8060518410095 -122.415074380155 (37.8060518410095, -122.415074380155) 3 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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

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