64 rows where Fire Prevention Districts = 5 and qSpecies_id = 95 sorted by qSpecies_id

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)
5534 132290 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1088 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6007835.1443 2118912.8319 37.7985729295487 -122.416972365309 (37.7985729295487, -122.416972365309) 5 1 10 308 32
9570 132301 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 2747 Larkin St 2 Front Yard : Yard Tree Private 2     9     6006508.97625 2120792.8563 37.8036603116463 -122.421694934677 (37.8036603116463, -122.421694934677) 5 9 1 28858 32
22030 66798 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 2727 Polk St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/20/1991 12:00:00 AM     Permit Number 30077 6006105.82573514 2120126.22393826 37.8018071677784 -122.423042648938 (37.8018071677784, -122.423042648938) 5 9 1 28858 32
22121 132286 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 841 Taylor St 3 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   6009132.2753 2115857.39392 37.7902563248256 -122.412267798542 (37.7902563248256, -122.412267798542) 5 1 10 28858 21
25348 132317 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 2555 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6007415.32813 2121203.67481 37.8048393822071 -122.418587599842 (37.8048393822071, -122.418587599842) 5 1 1 28858 32
25773 132289 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1215 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6008278.61159 2117890.90403 37.7957919047152 -122.41536544048 (37.7957919047152, -122.41536544048) 5 1 10 28858 21
26574 100103 Undocumented 4 Pittosporum crassifolium :: Karo Tree 95 461 Jefferson St 1 Sidewalk: Curb side : Cutout Tree Private 2           6007004.8 2122229.7 37.8076334645768 -122.420081138169 (37.8076334645768, -122.420081138169) 5 1 1 308 32
31854 132318 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 2555 Leavenworth St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6007420.0401 2121169.28616 37.8047452249804 -122.418568853475 (37.8047452249804, -122.418568853475) 5 1 1 28858 32
35669 132300 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 2747 Larkin St 1 Front Yard : Yard Tree Private 2     11     6006512.88528 2120797.48529 37.8036732420995 -122.421681736235 (37.8036732420995, -122.421681736235) 5 9 1 28858 32
39811 132331 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 2504 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6007490.25356 2121024.24346 37.8043509271294 -122.418315581892 (37.8043509271294, -122.418315581892) 5 1 1 308 32
40649 67453 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1088 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/05/2010 12:00:00 AM     Permit Number 30960 6007819.98571592 2118911.65470292 37.7985688445608 -122.417024735457 (37.7985688445608, -122.417024735457) 5 1 10 308 32
42509 94981 Undocumented 4 Pittosporum crassifolium :: Karo Tree 95 1088 Green St 2 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   6007813 2118904 37.7985474336912 -122.417048365627 (37.7985474336912, -122.417048365627) 5 1 10 308 32
48213 38489 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1055 Green St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/25/1998 12:00:00 AM 13   Permit Number 40486 6007984.75241 2118886.10151 37.7985079490502 -122.416452778391 (37.7985079490502, -122.416452778391) 5 1 10 28858 21
49160 132325 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 900 Green St 40 Sidewalk: Property side : Yard Tree Private 2     6 Width 5ft   6008540.25783 2119021.27466 37.7989103246077 -122.414540120931 (37.7989103246077, -122.414540120931) 5 1 10 308 32
52152 132336 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 603 Jefferson St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   6007097.46754 2122233.18776 37.8076482617315 -122.419760687214 (37.8076482617315, -122.419760687214) 5 1 1 308 32
55776 132321 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 2555 Leavenworth St 5 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6007427.51407 2121099.77816 37.804554794419 -122.418538057104 (37.804554794419, -122.418538057104) 5 1 1 28858 32
58330 132329 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 19 MacOndray Ln 2 Sidewalk: Property side : Yard Tree Private 2     7     6008551.08148 2119158.28756 37.7992871360415 -122.414512367875 (37.7992871360415, -122.414512367875) 5 1 10 308 32
59423 132310 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1100 Filbert St 14 Sidewalk: Property side : Yard Tree Private 2     8 Width 4ft   6007566.70317 2119578.68729 37.800386097695 -122.41794848495 (37.800386097695, -122.41794848495) 5 1 1 28858 32
60495 65487 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1010 Bush St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/15/1989 12:00:00 AM     Permit Number 28371 6008641.31301466 2115618.72283106 37.7895734304719 -122.413949606824 (37.7895734304719, -122.413949606824) 5 1 10 28858 21
63877 132313 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1100 Filbert St 18 Sidewalk: Property side : Yard Tree Private 2     3 Width 4ft   6007559.94961 2119579.01274 37.8003866112081 -122.417971878101 (37.8003866112081, -122.417971878101) 5 1 1 28858 32
75543 132299 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 2836 Larkin St 9 Side Yard : Yard Tree Private 2     6     6006506.76363 2120995.98891 37.8042179371566 -122.421717028328 (37.8042179371566, -122.421717028328) 5 9 1 28858 32
84159 132307 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1100 Filbert St 7 Sidewalk: Curb side : Yard Tree Private 2     4 Width 4ft   6007590.81408 2119573.14419 37.8003722346607 -122.417864658238 (37.8003722346607, -122.417864658238) 5 1 1 28858 32
85100 132309 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1100 Filbert St 12 Sidewalk: Property side : Yard Tree Private 2     4 Width 4ft   6007568.77173 2119578.83191 37.8003866112029 -122.417941337147 (37.8003866112029, -122.417941337147) 5 1 1 28858 32
95232 132327 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 940 Green St 1 Sidewalk: Property side : Yard Tree Private 2     4 Width 3ft   6008522.89173 2119019.43388 37.798904294645 -122.414600083225 (37.798904294645, -122.414600083225) 5 1 10 308 32
96621 132322 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1900 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6007781.07136 2118924.97659 37.7986032340217 -122.417160336187 (37.7986032340217, -122.417160336187) 5 1 10 308 32
98017 132320 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 2555 Leavenworth St 4 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6007424.3414 2121124.31025 37.8046219747004 -122.418550777108 (37.8046219747004, -122.418550777108) 5 1 1 28858 32
98568 132324 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 93 MacOndray Ln 2 Sidewalk: Property side : Yard Tree Private 2     3     6008139.89535 2119097.87736 37.7990981561251 -122.415930938671 (37.7990981561251, -122.415930938671) 5 1 10 308 32
105152 132306 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1100 Filbert St 4 Sidewalk: Curb side : Yard Tree Private 2     4 Width 4ft   6007602.49027 2119574.77475 37.800377368866 -122.417824369518 (37.800377368866, -122.417824369518) 5 1 1 28858 32
107187 50782 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1191 Pine St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/25/2004 12:00:00 AM     Permit Number 47308 6008219.78042798 2115855.19241784 37.7901990348064 -122.415424817486 (37.7901990348064, -122.415424817486) 5 1 10 28858 21
114761 132288 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1033 Broadway 1 Sidewalk: Property side : Yard Tree Private 2     5 Width 2ft   6008636.07788 2118258.91377 37.7968224531381 -122.41415458606 (37.7968224531381, -122.41415458606) 5 1 10 308 21
118004 132311 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1100 Filbert St 15 Sidewalk: Property side : Yard Tree Private 2     6 Width 4ft   6007565.3892 2119578.71422 37.800386097688 -122.417953033731 (37.800386097688, -122.417953033731) 5 1 1 28858 32
128542 132305 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 7 Sharp Pl 4 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6007487.83058 2119039.7467 37.7989018628862 -122.418183185499 (37.7989018628862, -122.418183185499) 5 1 10 28858 32
130055 114304 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 2508 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3 Permit Number 778637 6007480.44812 2121087.8604 37.8045250511575 -122.41835402794 (37.8045250511575, -122.41835402794) 5 1 1 308 32
131338 132298 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 2836 Larkin St 8 Side Yard : Yard Tree Private 2     19     6006506.15813 2120992.00348 37.8042069600397 -122.421718840462 (37.8042069600397, -122.421718840462) 5 9 1 28858 32
134609 53445 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1136 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/23/1986 12:00:00 AM 10   Permit Number 23060 6007541.25929 2119223.36211 37.7994090319514 -122.418011327765 (37.7994090319514, -122.418011327765) 5 1 1 28858 32
137485 132315 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1100 Filbert St 20 Sidewalk: Property side : Yard Tree Private 2     4 Width 4ft   6007556.34095 2119577.0298 37.8003809634556 -122.417984224885 (37.8003809634556, -122.417984224885) 5 1 1 28858 32
139928 68917 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1918 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/1993 12:00:00 AM 8   Permit Number 32897 6007769.38511 2118997.74512 37.79880238078 -122.417205933618 (37.79880238078, -122.417205933618) 5 1 10 308 32
140520 132334 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 2550 Leavenworth St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6007468.27941 2121161.99604 37.8047279238135 -122.41840139881 (37.8047279238135, -122.41840139881) 5 1 1 308 32
140970 50962 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 2544 Leavenworth St 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 47454 6007484.88144152 2121079.14108349 37.8045013596833 -122.418338067384 (37.8045013596833, -122.418338067384) 5 1 1 308 32
143004 132308 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1100 Filbert St 11 Sidewalk: Property side : Yard Tree Private 2     10 Width 4ft   6007570.65657 2119579.16732 37.8003876382322 -122.417934838623 (37.8003876382322, -122.417934838623) 5 1 1 28858 32
143105 132303 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 7 Sharp Pl 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6007483.3552 2119074.24344 37.7989963303813 -122.418201118888 (37.7989963303813, -122.418201118888) 5 1 10 28858 32
145774 100105 Undocumented 4 Pittosporum crassifolium :: Karo Tree 95 461 Jefferson St 3 Sidewalk: Curb side : Cutout Tree Private 2           6007004.8 2122229.7 37.8076334645768 -122.420081138169 (37.8076334645768, -122.420081138169) 5 1 1 308 32
147575 132333 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 2540 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6007480.55356 2121102.67484 37.8045657337878 -122.418354714096 (37.8045657337878, -122.418354714096) 5 1 1 308 32
153083 132330 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 2500 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6007494.25982 2120977.73519 37.8042234527215 -122.418298418341 (37.8042234527215, -122.418298418341) 5 1 1 308 32
153522 132314 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1100 Filbert St 19 Sidewalk: Property side : Yard Tree Private 2     6 Width 4ft   6007558.42483 2119577.92187 37.8003835301378 -122.417977077086 (37.8003835301378, -122.417977077086) 5 1 1 28858 32
155255 132304 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 7 Sharp Pl 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6007485.98045 2119054.83671 37.7989431921333 -122.418190657993 (37.7989431921333, -122.418190657993) 5 1 10 28858 32
156254 132332 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 2504 Leavenworth St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   6007487.69217 2121044.44677 37.8044062561144 -122.418325879158 (37.8044062561144, -122.418325879158) 5 1 1 308 32
160842 132328 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 19 MacOndray Ln 1 Sidewalk: Property side : Yard Tree Private 2     5     6008548.15408 2119158.80961 37.7992884050024 -122.41452253469 (37.7992884050024, -122.41452253469) 5 1 10 308 32
161997 132319 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 2555 Leavenworth St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007420.89623 2121144.99449 37.804678574419 -122.418564167126 (37.804678574419, -122.418564167126) 5 1 1 28858 32
163881 132323 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1918 Leavenworth St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6007766.33038 2119012.36096 37.7988423403689 -122.417217540261 (37.7988423403689, -122.417217540261) 5 1 10 308 32
164606 132291 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1090 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   6007812.22887 2118908.19187 37.7985589001405 -122.41705133116 (37.7985589001405, -122.41705133116) 5 1 10 308 32
164625 132285 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 841 Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6009123.78815 2115921.15925 37.7904309326946 -122.412301672392 (37.7904309326946, -122.412301672392) 5 1 10 28858 21
167823 62961 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 45 Glover St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/01/1991 12:00:00 AM     Permit Number 29804 6008099.43910832 2118378.4690573 37.7971205654778 -122.416019957286 (37.7971205654778, -122.416019957286) 5 1 10 28858 21
168253 132302 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 7 Sharp Pl 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007481.52711 2119090.40796 37.7990406112023 -122.418208591357 (37.7990406112023, -122.418208591357) 5 1 10 28858 32
169114 132312 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1100 Filbert St 17 Sidewalk: Property side : Yard Tree Private 2     7 Width 4ft   6007562.76127 2119578.76809 37.8003860977016 -122.41796213126 (37.8003860977016, -122.41796213126) 5 1 1 28858 32
173702 62707 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1111 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/20/1986 12:00:00 AM     Permit Number 23047 6007709.6882052 2118843.89920781 37.7983765997638 -122.417401596179 (37.7983765997638, -122.417401596179) 5 1 10 28858 32
177076 42697 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 2502 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2000 12:00:00 AM     Permit Number 42714 6007504.11437077 2120942.44037002 37.8041270967963 -122.41826181189 (37.8041270967963, -122.41826181189) 5 1 1 308 32
180393 63584 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 2401 Larkin St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/19/1992 12:00:00 AM     Permit Number 24210 6006688.3941557 2119426.77030347 37.7999195019292 -122.420976997553 (37.7999195019292, -122.420976997553) 5 9 1 28858 32
181687 100104 Undocumented 4 Pittosporum crassifolium :: Karo Tree 95 461 Jefferson St 2 Sidewalk: Curb side : Cutout Tree Private 2           6007004.8 2122229.7 37.8076334645768 -122.420081138169 (37.8076334645768, -122.420081138169) 5 1 1 308 32
187347 132293 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1009 North Point St 1 Sidewalk: Property side : Yard Tree Private 2     13 Width 4ft   6005925.58045 2121359.44598 37.805183106669 -122.423754118678 (37.805183106669, -122.423754118678) 5 1 1 28858 32
188883 132316 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1275 Greenwich St 1 Sidewalk: Property side : Yard Tree Private 2     9 Width 3ft   6006816.19203 2119756.21492 37.800831276511 -122.420558166429 (37.800831276511, -122.420558166429) 5 1 1 28858 32
190307 132335 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 603 Jefferson St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6007080.77462 2122230.42424 37.80763973344 -122.419818260919 (37.80763973344, -122.419818260919) 5 1 1 308 32
190943 132287 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 926 Taylor St 1 Sidewalk: Curb side : Pot Tree Private 2     7 Width 3ft   6009134.27648 2116171.69815 37.7911194401688 -122.412283098711 (37.7911194401688, -122.412283098711) 5 1 10 28857 21
192087 132326 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 900 Green St 41 Sidewalk: Property side : Yard Tree Private 2     7 Width 5ft   6008538.05329 2119021.31977 37.7989103246178 -122.414547752584 (37.7989103246178, -122.414547752584) 5 1 10 308 32

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