trees

57 rows where qLegalStatus_id = 4 and qSpecies_id = 177

✎ View and edit SQL

This data as json, CSV (advanced)

qLegalStatus_id ✖

  • Undocumented · 57 ✖
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)
1199 116255 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 155 LAGUNA ST 3 Sidewalk: Curb side : Cutout Tree Private 2       7x6   6005176 2109399 37.7723003725615 -122.425496410637 (37.7723003725615, -122.425496410637) 7 9 5 28852 10
10503 233771 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 35 Walter St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/10/2019 03:11:00 PM 3 Width 3ft   6003168.16978 2108097.17278 37.7686122241979 -122.432348677773 (37.7686122241979, -122.432348677773) 15 5 5 28862 3
12604 116259 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 155 LAGUNA ST 7 Sidewalk: Curb side : Cutout Tree Private 2       7x6   6005176 2109399 37.7723003725615 -122.425496410637 (37.7723003725615, -122.425496410637) 7 9 5 28852 10
20378 116241 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 229x HAIGHT ST 4 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6005035 2109517 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154) 7 9 5 28852 10
31119 255523 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 2461 Sacramento St 1 Sidewalk: Property side : Cutout Tree Private 2   07/09/2018 12:00:00 AM 3 3x3   6002905 2115842 37.7898626566676 -122.433812591785 (37.7898626566676, -122.433812591785) 13 9 1 29490 27
42180 114695 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 799x TAYLOR ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009121 2115613 37.7895846457112 -122.412289529495 (37.7895846457112, -122.412289529495) 5 1 10 28858 21
42496 116243 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 229x HAIGHT ST 6 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6005035 2109517 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154) 7 9 5 28852 10
42853 113802 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 806 SHOTWELL ST 4 Front Yard : Yard Tree Private 2           6007931 2103220 37.755489548438 -122.415529041662 (37.755489548438, -122.415529041662) 2 4 7 28859 19
48637 114696 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 799x TAYLOR ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009121 2115613 37.7895846457112 -122.412289529495 (37.7895846457112, -122.412289529495) 5 1 10 28858 21
53752 121107 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 1391 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/09/2016 12:00:00 AM 3 3x3   5993608 2106030 37.7623895873424 -122.465266089176 (37.7623895873424, -122.465266089176) 1 8 11 56 12
55911 100649 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 50 Walter St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003141 2108015 37.7683850571797 -122.432436785894 (37.7683850571797, -122.432436785894) 15 5 5 28862 3
56227 116244 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 229x HAIGHT ST 7 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6005035 2109517 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154) 7 9 5 28852 10
59182 116252 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 229 HAIGHT ST 16 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6005035 2109517 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154) 7 9 5 28852 10
66864 117270 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 481 JERSEY ST 1 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   6002050 2101440 37.7502697725383 -122.435739974128 (37.7502697725383, -122.435739974128) 2 4 5 28862 22
69531 116248 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 229 HAIGHT ST 12 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6005035 2109517 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154) 7 9 5 28852 10
69900 254752 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 701 Lombard St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008942 2120384 37.8026745911634 -122.413246372322 (37.8026745911634, -122.413246372322) 3 1 10 308 23
70345 255525 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 2461 Sacramento St 3 Sidewalk: Property side : Cutout Tree Private 2   07/09/2018 12:00:00 AM 3 3x3   6002905 2115842 37.7898626566676 -122.433812591785 (37.7898626566676, -122.433812591785) 13 9 1 29490 27
74249 116261 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 155 LAGUNA ST 9 Sidewalk: Curb side : Cutout Tree Private 2       7x6   6005176 2109399 37.7723003725615 -122.425496410637 (37.7723003725615, -122.425496410637) 7 9 5 28852 10
77118 100396 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 500X Oak Park Dr 1 Sidewalk: Property side : Yard Tree Private 2   09/18/2012 12:00:00 AM 3 3x9 Permit Number 769101 5994983.3 2103652.8 37.7559416221353 -122.460337221652 (37.7559416221353, -122.460337221652) 1 5 4 63 12
80914 255524 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 2461 Sacramento St 2 Sidewalk: Property side : Cutout Tree Private 2   07/09/2018 12:00:00 AM 3 3x3   6002905 2115842 37.7898626566676 -122.433812591785 (37.7898626566676, -122.433812591785) 13 9 1 29490 27
83740 116253 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 155 LAGUNA ST 1 Sidewalk: Curb side : Cutout Tree Private 2       7x6   6005176 2109399 37.7723003725615 -122.425496410637 (37.7723003725615, -122.425496410637) 7 9 5 28852 10
92392 116250 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 229 HAIGHT ST 14 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6005035 2109517 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154) 7 9 5 28852 10
93318 111178 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 2109 Polk St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006363 2118096 37.7962471953974 -122.422008397548 (37.7962471953974, -122.422008397548) 13 9 10 28858 32
101932 116717 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 690X 03RD ST 4 Sidewalk: Curb side : Cutout Tree Private 2   09/22/2003 12:00:00 AM 5 3x3   6014548 2111604 37.7788798826953 -122.393231883862 (37.7788798826953, -122.393231883862) 6 2 9 28856 34
102477 116246 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 229 HAIGHT ST 9 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6005035 2109517 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154) 7 9 5 28852 10
102669 255526 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 2461 Sacramento St 4 Sidewalk: Property side : Cutout Tree Private 2   07/09/2018 12:00:00 AM 3 3x3   6002905 2115842 37.7898626566676 -122.433812591785 (37.7898626566676, -122.433812591785) 13 9 1 29490 27
102780 116254 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 155 LAGUNA ST 2 Sidewalk: Curb side : Cutout Tree Private 2       7x6   6005176 2109399 37.7723003725615 -122.425496410637 (37.7723003725615, -122.425496410637) 7 9 5 28852 10
103816 116240 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 229x HAIGHT ST 3 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6005035 2109517 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154) 7 9 5 28852 10
107470 112520 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 146x ARLETA AVE 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010471 2087928 37.7136434126305 -122.405667857285 (37.7136434126305, -122.405667857285) 9 7 8 309 39
113350 116238 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 229x HAIGHT ST 1 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6005035 2109517 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154) 7 9 5 28852 10
114910 102005 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 1703 CASTRO ST 2 Sidewalk: Curb side : Cutout Tree Private 2   01/26/2016 12:00:00 AM 3 3x3 Permit Number 776283 6002624 2100623.7 37.7480609930318 -122.433696712327 (37.7480609930318, -122.433696712327) 2 4 5 63 22
114926 116249 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 229 HAIGHT ST 13 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6005035 2109517 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154) 7 9 5 28852 10
120038 116245 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 229 HAIGHT ST 8 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6005035 2109517 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154) 7 9 5 28852 10
120178 116251 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 229 HAIGHT ST 15 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6005035 2109517 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154) 7 9 5 28852 10
120504 254750 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 701 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008942 2120384 37.8026745911634 -122.413246372322 (37.8026745911634, -122.413246372322) 3 1 10 308 23
123771 116260 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 155 LAGUNA ST 8 Sidewalk: Curb side : Cutout Tree Private 2       7x6   6005176 2109399 37.7723003725615 -122.425496410637 (37.7723003725615, -122.425496410637) 7 9 5 28852 10
123948 75029 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 141X Arleta Ave 1 Sidewalk: Curb side : Cutout Tree PUC 8 FUF 02/24/2016 12:00:00 AM 3   This record is for lthe ot between 141-143 Arleta Ave. 6010470.01061258 2087860.00753073 37.7134566637798 -122.405666490875 (37.7134566637798, -122.405666490875) 9 7 8 309 39
125035 255253 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 2178 Pine St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/27/2018 12:00:00 AM 3 3x3   6003537 2115267 37.7883196953611 -122.43158486312 (37.7883196953611, -122.43158486312) 13 9 1 29490 27
132603 74892 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 141X Arleta Ave 2 Sidewalk: Curb side : Cutout Tree PUC 8 FUF 02/24/2016 12:00:00 AM 3   This is for the trees adjacent to the lot between 141-143 Arleta 6010470.01061258 2087860.00753073 37.7134566637798 -122.405666490875 (37.7134566637798, -122.405666490875) 9 7 8 309 39
135717 112521 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 146x ARLETA AVE 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010471 2087928 37.7136434126305 -122.405667857285 (37.7136434126305, -122.405667857285) 9 7 8 309 39
142116 99931 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 801X Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/19/2012 12:00:00 AM   3x3 Permit Number 768924 6003100.6 2103580.4 37.7562064244422 -122.432259777723 (37.7562064244422, -122.432259777723) 2 4 5 28862 22
147693 121108 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 1391 08th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   09/09/2016 12:00:00 AM 3 3x3   5993608 2106030 37.7623895873424 -122.465266089176 (37.7623895873424, -122.465266089176) 1 8 11 56 12
148384 116242 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 229x HAIGHT ST 5 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6005035 2109517 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154) 7 9 5 28852 10
150109 116239 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 229x HAIGHT ST 2 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6005035 2109517 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154) 7 9 5 28852 10
161101 113398 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 603 CLAYTON ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5998367 2108846 37.7703949048055 -122.449009410311 (37.7703949048055, -122.449009410311) 15 5 11 29492 9
163779 116372 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 1306 10TH AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       6x8   5993057 2106542 37.7637636140689 -122.467209006309 (37.7637636140689, -122.467209006309) 1 8 11 56 12
167419 254751 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 701 Lombard St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008942 2120384 37.8026745911634 -122.413246372322 (37.8026745911634, -122.413246372322) 3 1 10 308 23
168854 102006 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 1703 Castro St 3 Sidewalk: Curb side : Cutout Tree Private 2   01/26/2016 12:00:00 AM 3 3x3 Permit Number 776283 6002624 2100623.7 37.7480609930318 -122.433696712327 (37.7480609930318, -122.433696712327) 2 4 5 63 22
170457 116247 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 229 HAIGHT ST 11 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6005035 2109517 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154) 7 9 5 28852 10
170762 256228 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 2461 Sacramento St 5 Sidewalk: Property side : Cutout Tree Private 2       3x3   6002905 2115842 37.7898626566676 -122.433812591785 (37.7898626566676, -122.433812591785) 13 9 1 29490 27
172681 116256 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 155 LAGUNA ST 4 Sidewalk: Curb side : Cutout Tree Private 2       7x6   6005176 2109399 37.7723003725615 -122.425496410637 (37.7723003725615, -122.425496410637) 7 9 5 28852 10
172881 121042 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 2101 Polk St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006363 2118098 37.7962526868942 -122.422008539697 (37.7962526868942, -122.422008539697) 13 9 10 28858 32
177950 113397 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 603 CLAYTON ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5998367 2108846 37.7703949048055 -122.449009410311 (37.7703949048055, -122.449009410311) 15 5 11 29492 9
181198 118312 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 2410 STEINER ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002301 2116562 37.7918052987456 -122.435953913571 (37.7918052987456, -122.435953913571) 13 9 1 29490 27
185404 107849 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 1300x ANZA ST 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   5994625 2112199 37.7793866324847 -122.462196108999 (37.7793866324847, -122.462196108999) 11 6 2 54 11
185678 116258 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 155 LAGUNA ST 6 Sidewalk: Curb side : Cutout Tree Private 2       7x6   6005176 2109399 37.7723003725615 -122.425496410637 (37.7723003725615, -122.425496410637) 7 9 5 28852 10
188472 116257 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 155 LAGUNA ST 5 Sidewalk: Curb side : Cutout Tree Private 2       7x6   6005176 2109399 37.7723003725615 -122.425496410637 (37.7723003725615, -122.425496410637) 7 9 5 28852 10

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