159 rows where Supervisor Districts = 4 and qSpecies_id = 95

View and edit SQL

Supervisor 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)
133754 211353 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 300x Marietta Dr 9 Median : Cutout Tree DPW 1     10 Width 5ft   5999190.61493 2097593.0278 37.7395440797867 -122.445351307915 (37.7395440797867, -122.445351307915) 9 7 4 59 40
135598 63051 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 736 Kirkham St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/19/1986 12:00:00 AM     Permit Number 23522 5992628.76886265 2105279.09141988 37.7602712704712 -122.46859821771 (37.7602712704712, -122.46859821771) 1 8 4 56 12
135636 211331 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1695 10th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 1ft   5993075.52865 2103989.47692 37.7567561226019 -122.466959342101 (37.7567561226019, -122.466959342101) 1 8 4 56 12
137150 211393 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 300 Junipero Serra Blvd 13 : Tree Private 2     20 Width 0ft   5991388.09058 2094530.01431 37.7306853295574 -122.472105586615 (37.7306853295574, -122.472105586615) 9 8 4 64 40
137286 211405 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 501x Ortega St 3 Median : Cutout Tree DPW 1     9 Width 3ft   5992547.15666 2103069.65135 37.7542000101481 -122.468719701149 (37.7542000101481, -122.468719701149) 1 8 4 56 12
139452 211321 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1647 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5990867.38538 2104194.08087 37.7571902136667 -122.474610765969 (37.7571902136667, -122.474610765969) 1 8 4 56 12
139796 63161 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1570 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/17/1986 12:00:00 AM     Permit Number 23698 5992788.51454343 2104780.75252088 37.7589121888889 -122.468009488103 (37.7589121888889, -122.468009488103) 1 8 4 56 12
140380 211402 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 500 Junipero Serra Blvd 77 : Tree Private 2     10 Width 0ft   5991311.70332 2093205.96444 37.7270453991248 -122.472273185163 (37.7270453991248, -122.472273185163) 9 8 4 64 40
140744 211352 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 526 Molimo Dr 1 Sidewalk: Property side : Yard Tree Private 2     13     5997388.71891 2097767.32799 37.7399196411707 -122.451594020245 (37.7399196411707, -122.451594020245) 9 7 4 59 40
140833 416 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 3866 19th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     6     5990882.28531 2090084.77659 37.7184505306428 -122.473530092056 (37.7184505306428, -122.473530092056) 9 8 4 64 40
141150 211426 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 400x Marietta Dr 8 Median : Cutout Tree DPW 1     15 Width 3ft   5999504.16591 2097034.85619 37.7380293669502 -122.444227088834 (37.7380293669502, -122.444227088834) 9 7 4 59 40
141432 66260 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 124 Chaves Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/05/1992 12:00:00 AM     Permit Number 31088 5996714.47770615 2098535.27666339 37.7419896054085 -122.453980699646 (37.7419896054085, -122.453980699646) 9 7 4 59 40
142073 211358 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 300x Marietta Dr 43 Median : Cutout Tree DPW 1     12 Width 5ft   5999479.63051 2097509.53542 37.739331323589 -122.444346022364 (37.739331323589, -122.444346022364) 9 7 4 59 40
145032 47967 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 370 Teresita Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/2002 12:00:00 AM     Permit Number 45697 5997970.64208959 2098199.91881065 37.7411407391747 -122.449613145498 (37.7411407391747, -122.449613145498) 9 7 4 59 40
147011 211424 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 300 Cresta Vista Dr 1 Sidewalk: Property side : Yard Tree Private 2     4 Width 3ft   5996875.09082 2096180.55057 37.7355333076209 -122.453255397218 (37.7355333076209, -122.453255397218) 9 7 4 59 40
147884 211345 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 302 San Fernando Way 6 Sidewalk: Curb side : Yard Tree Private 2     7 Width 8ft   5992079.79113 2094794.73629 37.7314521940467 -122.469733558158 (37.7314521940467, -122.469733558158) 9 8 4 59 40
148208 211340 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 115 Lomita Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5991388.07357 2104492.37979 37.7580394200981 -122.472831792752 (37.7580394200981, -122.472831792752) 1 8 4 56 12
148266 211382 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 2601 Ocean Ave 1 : Tree Private 2     8 Width 3ft   5991018.58342 2094892.51485 37.7316592746545 -122.473409447106 (37.7316592746545, -122.473409447106) 1 8 4 64 40
149214 13412 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 424 Marietta Dr 1 Median : Cutout Tree DPW 1     6 5   5999639.6116279 2097094.1286968 37.7381998416451 -122.443763044504 (37.7381998416451, -122.443763044504) 9 7 4 59 40
149496 47969 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 571 Teresita Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/2002 12:00:00 AM     Permit Number 45699 5998926.83407874 2097073.47260049 37.7381024439433 -122.446225980415 (37.7381024439433, -122.446225980415) 9 7 4 59 40
149531 62763 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 438 Lawton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/12/1986 12:00:00 AM     Permit Number 23117 5992955.71018019 2104609.08107701 37.7584504778466 -122.467418769042 (37.7584504778466, -122.467418769042) 1 8 4 56 12
151428 211432 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 965 Teresita Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5998407.05988 2095671.52023 37.7342233191399 -122.447922184575 (37.7342233191399, -122.447922184575) 9 7 4 59 40
153041 50115 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1644 Ulloa St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/29/2003 12:00:00 AM     Permit Number 46840 5990947.45576914 2098416.9234603 37.7413322844264 -122.473912381937 (37.7413322844264, -122.473912381937) 1 8 4 29491 40
153567 68793 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 2646 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/22/1993 12:00:00 AM     Permit Number 32732 5991785.3639189 2097418.62404016 37.7386397061499 -122.470942510825 (37.7386397061499, -122.470942510825) 1 8 4 29491 40
153763 211391 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 300 Junipero Serra Blvd 7 : Tree Private 2     16 Width 0ft   5991391.10159 2094562.85542 37.7307756772501 -122.472097570057 (37.7307756772501, -122.472097570057) 9 8 4 64 40
154768 11640 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 500X Junipero Serra Blvd 3 Sidewalk: Curb side : Cutout Tree DPW 1     6 4x4   5991362.1134613 2093824.2614448 37.7287460056648 -122.472143968924 (37.7287460056648, -122.472143968924) 9 8 4 64 40
155077 211431 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 278 Mangels Ave 1 Sidewalk: Property side : Yard Tree Private 2     4 Width 2ft   5999570.66466 2095256.06899 37.7331490303839 -122.443869406865 (37.7331490303839, -122.443869406865) 9 7 4 63 40
155344 211320 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1512 18th Ave 1 Sidewalk: Property side : Yard Tree Private 2     9 Width 5ft   5990581.8778 2105043.40496 37.7595056846449 -122.475660168686 (37.7595056846449, -122.475660168686) 1 8 4 56 12
155416 211412 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 100x Casitas Ave 4 Median : Cutout Tree DPW 1     8 Width 3ft   5995479.92696 2096985.75384 37.7376641342833 -122.458137233872 (37.7376641342833, -122.458137233872) 9 7 4 59 40
156501 63178 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 720 Kirkham St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/17/1986 12:00:00 AM     Permit Number 23716 5992676.38910758 2105280.72009122 37.7602784930998 -122.468433641583 (37.7602784930998, -122.468433641583) 1 8 4 56 12
157160 211335 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 501x Ortega St 12 Median : Cutout Tree DPW 1     3 Width 2ft   5992526.64779 2103107.81832 37.7543036219218 -122.468793402415 (37.7543036219218, -122.468793402415) 1 8 4 56 12
159191 67468 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 99 Agua Way 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/08/1992 12:00:00 AM     Permit Number 30989 5996784.33302359 2098587.30616541 37.7421364707665 -122.453742919924 (37.7421364707665, -122.453742919924) 9 7 4 59 40
161479 211337 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 501x Ortega St 9 Median : Cutout Tree DPW 1     3 Width 2ft   5992536.02812 2103096.29648 37.7542725278567 -122.468760124801 (37.7542725278567, -122.468760124801) 1 8 4 56 12
161820 211429 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 300x Marietta Dr 52 Median : Cutout Tree DPW 1     10 Width 5ft   5999576.15591 2097477.53164 37.739248955579 -122.44400998258 (37.739248955579, -122.44400998258) 9 7 4 59 40
166495 29973 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 500X Junipero Serra Blvd 18 Median : Cutout Tree DPW 1   04/01/2007 12:00:00 AM 3 3x3   5991350.6997 2093700.47523 37.7284054591375 -122.472174407226 (37.7284054591375, -122.472174407226) 9 8 4 64 40
166965 272 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 3201X 19th Ave 13 Sidewalk: Curb side : Cutout Tree DPW 1     25 2X2   5990532.43506 2093914.77746 37.7289464910226 -122.475018795259 (37.7289464910226, -122.475018795259) 1 8 4 64 14
167246 56610 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 117 Chaves Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/26/1995 12:00:00 AM     Permit Number 30987 5996756.33540734 2098503.70250218 37.7419053104165 -122.453833690323 (37.7419053104165, -122.453833690323) 9 7 4 59 40
167391 211333 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 633 Kirkham St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   5992869.16618 2105224.2818 37.7601346615088 -122.467762817096 (37.7601346615088, -122.467762817096) 1 8 4 56 12
168145 48651 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 436 Moraga St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/30/2002 12:00:00 AM     Permit Number 45944 5992984.82174841 2103929.91361967 37.756587341409 -122.467268706379 (37.756587341409, -122.467268706379) 1 8 4 56 12
168535 67507 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 427 Flood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/16/1992 12:00:00 AM     Permit Number 31037 5997919.84331621 2094073.6426889 37.7298080658571 -122.449491544159 (37.7298080658571, -122.449491544159) 9 7 4 28861 40
168839 211389 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 2650 Ocean Ave 1 : Tree Private 2     7 Width 3ft   5990873.32433 2095051.49544 37.7320873825274 -122.473923226178 (37.7320873825274, -122.473923226178) 1 8 4 64 40
170639 63052 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 740 Kirkham St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/19/1986 12:00:00 AM     Permit Number 23523 5992616.86380837 2105278.68425229 37.7602694647792 -122.468639361712 (37.7602694647792, -122.468639361712) 1 8 4 56 12
174428 62764 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 445 Lawton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/12/1986 12:00:00 AM     Permit Number 23118 5992939.7007125 2104556.5051909 37.7583051939109 -122.467470313222 (37.7583051939109, -122.467470313222) 1 8 4 56 12
175140 49058 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 634 Miramar Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/07/2003 12:00:00 AM     Permit Number 46225 5995429.55733009 2093557.30564002 37.7282475554757 -122.458063335473 (37.7282475554757, -122.458063335473) 9 7 4 28861 40
178328 57563 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 350 Lawton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/12/1986 12:00:00 AM     Permit Number 23113 5993229.79890114 2104618.42349 37.7584919494469 -122.466471535006 (37.7584919494469, -122.466471535006) 1 8 4 56 12
178593 49057 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 634 Miramar Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/07/2003 12:00:00 AM     Permit Number 46225 5995429.55733009 2093557.30564002 37.7282475554757 -122.458063335473 (37.7282475554757, -122.458063335473) 9 7 4 28861 40
179550 63050 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 614 Kirkham St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/19/1986 12:00:00 AM     Permit Number 23521 5993003.74636017 2105291.91602449 37.7603281373616 -122.467302290195 (37.7603281373616, -122.467302290195) 1 8 4 56 12
181046 211357 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 300x Marietta Dr 42 Median : Cutout Tree DPW 1     7 Width 5ft   5999475.8897 2097510.54989 37.7393338956504 -122.444359029265 (37.7393338956504, -122.444359029265) 9 7 4 59 40
181813 211338 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 501x Ortega St 8 Median : Cutout Tree DPW 1     4 Width 2ft   5992538.26817 2103091.89381 37.7542605686777 -122.46875205787 (37.7542605686777, -122.46875205787) 1 8 4 56 12
184444 50896 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1647 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/26/2004 12:00:00 AM     Permit Number 47405 5990863.99399476 2104190.85036451 37.7571811470474 -122.474622258806 (37.7571811470474, -122.474622258806) 1 8 4 56 12
184533 67508 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 423 Flood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/16/1992 12:00:00 AM     Permit Number 31038 5997945.14259478 2094073.25690369 37.7298084538174 -122.449404054305 (37.7298084538174, -122.449404054305) 9 7 4 28861 40
185893 211336 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 501x Ortega St 10 Median : Cutout Tree DPW 1     2 Width 2ft   5992533.48421 2103100.12483 37.7542828925471 -122.468769200762 (37.7542828925471, -122.468769200762) 1 8 4 56 12
188455 219151 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1500 16th Ave 5 Side Yard : Yard Tree Private 2     15 Width 4ft   5991179.47447 2105124.8493 37.7597639357807 -122.473599345261 (37.7597639357807, -122.473599345261) 1 8 4 56 12
188822 211355 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 300x Marietta Dr 30 Median : Cutout Tree DPW 1     6 Width 5ft   5999309.78108 2097559.20163 37.7394580029801 -122.444936853564 (37.7394580029801, -122.444936853564) 9 7 4 59 40
189289 63163 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1546 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/17/1986 12:00:00 AM     Permit Number 23700 5992783.12624963 2104937.37647653 37.759341926142 -122.468039515949 (37.759341926142, -122.468039515949) 1 8 4 56 12
189999 211343 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 2464 14th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   5992061.49355 2098678.91862 37.7421161210646 -122.470079538139 (37.7421161210646, -122.470079538139) 1 8 4 29491 40
190650 211360 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 205 Granada Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   5995618.4586 2091274.81338 37.7219912298988 -122.457245251188 (37.7219912298988, -122.457245251188) 9 8 4 28861 24
192612 50116 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1645 Ulloa St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/29/2003 12:00:00 AM     Permit Number 46841 5990949.33787022 2098364.95753208 37.7411897083484 -122.473902084012 (37.7411897083484, -122.473902084012) 1 8 4 29491 40
193706 219152 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1500 16th Ave 6 Side Yard : Yard Tree Private 2     15 Width 6ft   5991180.06905 2105137.85002 37.759799666743 -122.473598237272 (37.759799666743, -122.473598237272) 1 8 4 56 12

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