267 rows where qSpecies_id = 100 sorted by rowid descending

View and edit SQL

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)
193841 211046 DPW Maintained 1 Pinus Spp :: Pine Spp 100 251 Wildwood Way 6 Sidewalk: Curb side : Yard Tree Private 2     19 Width 3ft   5995705.57302 2093291.07499 37.7275324053909 -122.457089894179 (37.7275324053909, -122.457089894179) 9 7 4 28861 40
193767 251050 DPW Maintained 1 Pinus Spp :: Pine Spp 100 5800x Geary Blvd 1 Median : Yard Tree DPW 1     4 Width 10ft   5988878.2157 2112618.8979 37.7802069893248 -122.482107186669 (37.7802069893248, -122.482107186669) 11 6 2 55 26
193417 141493 DPW Maintained 1 Pinus Spp :: Pine Spp 100 2901 TURK BLVD 17 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   5996968.2673 2111507.0382 37.7776213292106 -122.45403981827 (37.7776213292106, -122.45403981827) 15 6 2 54 16
193255 185171 DPW Maintained 1 Pinus Spp :: Pine Spp 100 2500 Sunset Blvd 23 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5985156.5992 2097759.0465 37.7391888105651 -122.493886370266 (37.7391888105651, -122.493886370266) 1 8 3 29491 35
192604 24284 DPW Maintained 1 Pinus Spp :: Pine Spp 100 300X Winding Way 22 Median : Cutout Tree DPW 1     6 8   6001646.2933309 2086550.8578367 37.7093646550959 -122.436070699117 (37.7093646550959, -122.436070699117) 9 7 6 28861 5
192591 808 DPW Maintained 1 Pinus Spp :: Pine Spp 100 600X 39th Ave 6 Median : Cutout Tree DPW 1     3 6-HOA   5983831.1679936 2111715.0127262 37.7774303425616 -122.499500145383 (37.7774303425616, -122.499500145383) 11 6 2 55 26
192049 234489 DPW Maintained 1 Pinus Spp :: Pine Spp 100 4067 20th St 2 Front Yard : Yard Tree Private 2     12 Width 3ft   6003294.37691 2104155.43702 37.7577963243568 -122.431630684215 (37.7577963243568, -122.431630684215) 2 4 5 28862 3
185727 185166 DPW Maintained 1 Pinus Spp :: Pine Spp 100 2500 Sunset Blvd 17 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5985143.9825 2097713.2278 37.7390622665176 -122.493926616722 (37.7390622665176, -122.493926616722) 1 8 3 29491 35
183847 185496 DPW Maintained 1 Pinus Spp :: Pine Spp 100 2400 Sunset Blvd 50 unknown : Yard Tree Private 2     1 Width 0ft   5985141.6583 2098649.8553 37.7416338578085 -122.494003662835 (37.7416338578085, -122.494003662835) 1 8 3 29491 35
182791 13404 DPW Maintained 1 Pinus Spp :: Pine Spp 100 360 Marietta Dr 2 Median : Cutout Tree DPW 1     40 5x1000   5999647.998558 2097391.335153 37.7390163784819 -122.44375539278 (37.7390163784819, -122.44375539278) 9 7 4 59 40
182249 173897 Undocumented 4 Pinus Spp :: Pine Spp 100 90x Knollview Way 1 Back Yard : Yard Tree Private 2       3x3   5997593 2101480 37.7501254274205 -122.451155378281 (37.7501254274205, -122.451155378281) 1 5 4 63 38
177971 200796 Undocumented 4 Pinus Spp :: Pine Spp 100 700 Jamestown Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6015315.685 2088368.925 37.7151238332906 -122.388953494511 (37.7151238332906, -122.388953494511) 10 3 8 58 1
177806 211048 DPW Maintained 1 Pinus Spp :: Pine Spp 100 50 Garcia Ave 24 Sidewalk: Curb side : Yard Tree Private 2     25 Width 3ft   5994800.34548 2099248.4883 37.743837969354 -122.460650781424 (37.743837969354, -122.460650781424) 1 8 4 59 40
177628 93925 Permitted Site 7 Pinus Spp :: Pine Spp 100 3711 19th Ave 2 Sidewalk: Curb side : Yard Tree Private 2           5990297.3 2090806 37.7203969366505 -122.475604756889 (37.7203969366505, -122.475604756889) 1 8 4 64 14
176168 3760 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1062X Carolina St 2 Median : Cutout Tree DPW 1     20     6012453.5755993 2103020.9691678 37.7551962258659 -122.399874507795 (37.7551962258659, -122.399874507795) 10 3 8 28856 29
175590 110271 Undocumented 4 Pinus Spp :: Pine Spp 100 298X 28TH ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004269 2099559 37.7452307768148 -122.427932506483 (37.7452307768148, -122.427932506483) 2 7 5 63 22
175552 234488 DPW Maintained 1 Pinus Spp :: Pine Spp 100 4090 20th St 7 : Yard Tree Private 2     16 Width 3ft   6003119.17834 2104176.3954 37.7578439389691 -122.432238089941 (37.7578439389691, -122.432238089941) 2 4 5 28862 3
175429 187119 DPW Maintained 1 Pinus Spp :: Pine Spp 100 2600 Sunset Blvd 55 Sidewalk: Property side : Yard Tree Private 2     4 Width 0ft   5985168.1593 2097316.6584 37.7379748077492 -122.493813809362 (37.7379748077492, -122.493813809362) 1 8 3 29491 35
174020 12499 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1200X Lake Merced Blvd 1 Median : Cutout Tree DPW 1     18 8   5987438.4549992 2087542.2692131 37.7112694082243 -122.485247377649 (37.7112694082243, -122.485247377649) 1 8 4 64 14
173188 29631 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1110X Junipero Serra Blvd 4 Median : Cutout Tree DPW 1     3 3X3   5991107.8990451 2089843.5367701 37.717801208369 -122.47273266668 (37.717801208369, -122.47273266668) 9 8 4 64 40
171763 106405 Significant Tree 6 Pinus Spp :: Pine Spp 100 4849X 19th St   Front Yard : Yard Tree Private 2         Permit Number 772769 5999644.57626 2104777.09851 37.7592957011711 -122.444297841065 (37.7592957011711, -122.444297841065) 2 4 5 28862 3
169924 187279 DPW Maintained 1 Pinus Spp :: Pine Spp 100 2401 Sunset Blvd 62 Median : Yard Tree DPW 1     4 Width 0ft   5984952.4466 2098301.7622 37.7406670151021 -122.494632227246 (37.7406670151021, -122.494632227246) 1 8 3 29491 35
169637 20525 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1303X Sunset Blvd 3 Sidewalk: Curb side : Cutout Tree DPW 1     3 6O   5984802.8376111 2106327.3646052 37.7626943540195 -122.495741360313 (37.7626943540195, -122.495741360313) 1 8 3 56 35
168059 187335 DPW Maintained 1 Pinus Spp :: Pine Spp 100 2200 Sunset Blvd 20 Sidewalk: Property side : Yard Tree Private 2     4 Width 0ft   5985078.6769 2099672.3252 37.744437598438 -122.49429677682 (37.744437598438, -122.49429677682) 1 8 3 29491 35
167995 3761 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1074 Carolina St 1 Median : Cutout Tree DPW 1     12 18   6012458 2102979 37.7550812343514 -122.399856259894 (37.7550812343514, -122.399856259894) 10 3 8 28856 29
167992 181494 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1400 Sunset Blvd 54 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984852.1847 2105397.6443 37.7601444918652 -122.495502114318 (37.7601444918652, -122.495502114318) 1 8 3 56 35
167924 23578 DPW Maintained 1 Pinus Spp :: Pine Spp 100 3100X Van Ness Ave 1 Median : Cutout Tree DPW 1     24 9   6005553.2513401 2120985.4040713 37.8041350589608 -122.425015980687 (37.8041350589608, -122.425015980687) 5 1 1 28858 32
167631 112904 Undocumented 4 Pinus Spp :: Pine Spp 100 727 BURNETT AVE   Back Yard : Yard Tree Private 2       3x3   5999303 2101616 37.750596607185 -122.44525189688 (37.750596607185, -122.44525189688) 2 5 5 63 38
167459 107680 Permitted Site 7 Pinus Spp :: Pine Spp 100 330 Seacliff Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   10/10/2014 12:00:00 AM 3   Permit Number 773561 5986760.07251 2115557.06448 37.7881509278055 -122.489650845774 (37.7881509278055, -122.489650845774) 11 6 1 55 33
165349 110711 Undocumented 4 Pinus Spp :: Pine Spp 100 2999X Turk St 17 Sidewalk: Property side : Cutout Tree Private 2       5x3   5996638 2111487 37.7775473668867 -122.455180869531 (37.7775473668867, -122.455180869531) 15 6 2 54 16
162240 93928 Permitted Site 7 Pinus Spp :: Pine Spp 100 737 Gonzalez Dr 3 Sidewalk: Curb side : Yard Tree Private 2   04/28/2010 12:00:00 AM     Permit Number 53387 5988857.6 2089713.7 37.7173141872637 -122.480501360019 (37.7173141872637, -122.480501360019) 1 8 4 64 14
161472 185163 DPW Maintained 1 Pinus Spp :: Pine Spp 100 2500 Sunset Blvd 13 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5985155.9352 2097682.682 37.7389790952829 -122.493883039881 (37.7389790952829, -122.493883039881) 1 8 3 29491 35
157910 16689 DPW Maintained 1 Pinus Spp :: Pine Spp 100 620 Noriega St 1 Median : Cutout Tree DPW 1     12 2   5992122.8128645 2103567.9103998 37.7555435761415 -122.470223454796 (37.7555435761415, -122.470223454796) 1 8 4 56 12
154648 110701 Undocumented 4 Pinus Spp :: Pine Spp 100 2999X Turk St 7 Sidewalk: Property side : Cutout Tree Private 2       5x3   5996638 2111487 37.7775473668867 -122.455180869531 (37.7775473668867, -122.455180869531) 15 6 2 54 16
154492 20647 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1501X Sunset Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 60   5984817.9532367 2104951.7766639 37.7589182591611 -122.495587616201 (37.7589182591611, -122.495587616201) 1 8 3 56 35
152496 186156 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1700 Sunset Blvd 41 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984977.8278 2103337.3397 37.7544948232836 -122.49491566635 (37.7544948232836, -122.49491566635) 1 8 3 56 35
151873 187220 DPW Maintained 1 Pinus Spp :: Pine Spp 100 2401 Sunset Blvd 3 Sidewalk: Property side : Yard Tree Private 2     29 Width 0ft   5984921.2891 2098780.6261 37.7419800224632 -122.494775253241 (37.7419800224632, -122.494775253241) 1 8 3 29491 35
151588 11197 DPW Maintained 1 Pinus Spp :: Pine Spp 100 180 Idora Ave 3 Median : Cutout Tree DPW 1     3 8   5995389.3079719 2099438.232962 37.7443928282829 -122.458628033721 (37.7443928282829, -122.458628033721) 1 8 4 59 40
151364 20534 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1303X Sunset Blvd 12 Sidewalk: Curb side : Cutout Tree DPW 1     6 6O   5984802.8376111 2106327.3646052 37.7626943540195 -122.495741360313 (37.7626943540195, -122.495741360313) 1 8 3 56 35
148969 23882 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1500X Webster St 5 Median : Cutout Tree DPW 1     20 12   6003644.6262703 2113904.6308207 37.7845850728987 -122.431115216253 (37.7845850728987, -122.431115216253) 13 9 11 29490 41
146890 815 DPW Maintained 1 Pinus Spp :: Pine Spp 100 600X 39th Ave 13 Median : Cutout Tree DPW 1     3 6-HOA   5983831.1679936 2111715.0127262 37.7774303425616 -122.499500145383 (37.7774303425616, -122.499500145383) 11 6 2 55 26
144141 141485 DPW Maintained 1 Pinus Spp :: Pine Spp 100 2901 TURK BLVD 9 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   5996846.7484 2111491.4026 37.7775714294456 -122.454459061112 (37.7775714294456, -122.454459061112) 15 6 2 54 16
141912 234486 DPW Maintained 1 Pinus Spp :: Pine Spp 100 787 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2     29 Width 3ft   6003746.3772 2103694.46852 37.756556224011 -122.430034597112 (37.756556224011, -122.430034597112) 2 4 5 28862 3
140163 194432 DPW Maintained 1 Pinus Spp :: Pine Spp 100 900x Carolina St 64 Median : Yard Tree DPW 1     17     6012507.9331 2102881.18314 37.754815434199 -122.399676708016 (37.754815434199, -122.399676708016) 10 3 8 28856 29
139990 186132 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1700 Sunset Blvd 17 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984975.4043 2103142.7715 37.753960450821 -122.494909702152 (37.753960450821, -122.494909702152) 1 8 3 56 35
137765 100745 Permitted Site 7 Pinus Spp :: Pine Spp 100 760 Duboce Ave 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002024.1 2108325.5 37.7691742163209 -122.436322258742 (37.7691742163209, -122.436322258742) 15 5 5 29492 9
137660 183336 DPW Maintained 1 Pinus Spp :: Pine Spp 100 4711 Lincoln Way 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   5981096.0962 2106871.8479 37.7639715747264 -122.508601850774 (37.7639715747264, -122.508601850774) 1 8 3 56 35
137658 91427 DPW Maintained 1 Pinus Spp :: Pine Spp 100 800X Portola Dr 1 Median : Cutout Tree DPW 1   10/10/2005 12:00:00 AM   4x4   5996711.121131 2099335.742872 37.7441872967186 -122.454050104178 (37.7441872967186, -122.454050104178) 1 7 4 59 40
136225 186490 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1400 Lower Great Hwy 36 unknown : Yard Tree Private 2     1 Width 0ft   5980883.265 2105397.7493 37.7599115788226 -122.509228480711 (37.7599115788226, -122.509228480711) 1 8 3 56 35
135916 141536 DPW Maintained 1 Pinus Spp :: Pine Spp 100 2901 TURK BLVD 7 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   5996809.4424 2111483.7219 37.7775482006436 -122.454587559354 (37.7775482006436, -122.454587559354) 15 6 2 54 16
135364 185161 DPW Maintained 1 Pinus Spp :: Pine Spp 100 2500 Sunset Blvd 10 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5985124.0613 2097656.7845 37.7389061227579 -122.493991335448 (37.7389061227579, -122.493991335448) 1 8 3 29491 35
134476 245149 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1192 Page St 6 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 0ft   6000871.2374 2109327.7689 37.7718606240856 -122.440381827143 (37.7718606240856, -122.440381827143) 15 5 11 29492 9
133753 141484 DPW Maintained 1 Pinus Spp :: Pine Spp 100 2901 TURK BLVD 8 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5996823.7065 2111503.4721 37.7776032476224 -122.454539642462 (37.7776032476224, -122.454539642462) 15 6 2 54 16
130886 187232 DPW Maintained 1 Pinus Spp :: Pine Spp 100 2401 Sunset Blvd 15 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984921.2891 2098611.514 37.7415156862998 -122.494762787921 (37.7415156862998, -122.494762787921) 1 8 3 29491 35
130527 234484 DPW Maintained 1 Pinus Spp :: Pine Spp 100 310 Liberty St 42 Sidewalk: Curb side : Yard Tree Private 2     17 Width 3ft   6003878.87158 2103925.4289 37.7571978893843 -122.42959285554 (37.7571978893843, -122.42959285554) 2 4 5 28862 3
130182 185865 DPW Maintained 1 Pinus Spp :: Pine Spp 100 2000 Sunset Blvd 8 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5985059.0462 2100990.2907 37.7480552245721 -122.494461791049 (37.7480552245721, -122.494461791049) 1 8 3 29491 35
130013 181474 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1400 Sunset Blvd 34 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984899.5262 2105276.2272 37.7598138863622 -122.495329430578 (37.7598138863622, -122.495329430578) 1 8 3 56 35
129083 185537 DPW Maintained 1 Pinus Spp :: Pine Spp 100 2201 Sunset Blvd 21 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984862.7264 2100065.7068 37.7455050775816 -122.495072479787 (37.7455050775816, -122.495072479787) 1 8 3 29491 35
125688 117419 Undocumented 4 Pinus Spp :: Pine Spp 100 452 OAK ST 1 Front Yard : Yard Tree Private 2           6004802 2110240 37.774588415373 -122.426850015779 (37.774588415373, -122.426850015779) 7 9 11 28852 10
124810 107321 DPW Maintained 1 Pinus Spp :: Pine Spp 100 400X JUNIPERO SERRA BLVD 4 Median : Cutout Tree DPW 1     14     5991395 2094254 37.7299278633008 -122.47206158935 (37.7299278633008, -122.47206158935) 9 8 4 64 40
124287 211045 DPW Maintained 1 Pinus Spp :: Pine Spp 100 380 Santa Clara Ave 6 Sidewalk: Curb side : Yard Tree Private 2     33 Width 3ft   5993150.7745 2095420.35942 37.7332318444736 -122.466076441693 (37.7332318444736, -122.466076441693) 9 8 4 59 40
123375 234485 DPW Maintained 1 Pinus Spp :: Pine Spp 100 3690 21st St 3 Sidewalk: Property side : Yard Tree Private 2     21 Width 3ft   6003802.67178 2103657.18078 37.7564570287815 -122.429837250793 (37.7564570287815, -122.429837250793) 2 4 5 28862 3
116302 110705 Undocumented 4 Pinus Spp :: Pine Spp 100 2999X Turk St 11 Sidewalk: Property side : Cutout Tree Private 2       5x3   5996638 2111487 37.7775473668867 -122.455180869531 (37.7775473668867, -122.455180869531) 15 6 2 54 16
113538 11196 DPW Maintained 1 Pinus Spp :: Pine Spp 100 180 Idora Ave 2 Median : Cutout Tree DPW 1     3 8   5995389.3079719 2099438.232962 37.7443928282829 -122.458628033721 (37.7443928282829, -122.458628033721) 1 8 4 59 40
113217 255048 Significant Tree 6 Pinus Spp :: Pine Spp 100 45 Eagle St 3 Front Yard : Yard Tree Private 2       Width 3ft   6000118.88808 2104341.86796 37.7581277146448 -122.44262619575 (37.7581277146448, -122.44262619575) 2 4 5 28862 3
113118 141491 DPW Maintained 1 Pinus Spp :: Pine Spp 100 2901 TURK BLVD 15 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   5996944.1281 2111502.1006 37.7776063877102 -122.454122966753 (37.7776063877102, -122.454122966753) 15 6 2 54 16
112548 3763 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1074 Carolina St 1 Median : Cutout Tree DPW 1     12 18   6012456.6037355 2102966.9856684 37.7550481677782 -122.399860245008 (37.7550481677782, -122.399860245008) 10 3 8 28856 29
107393 98343 Undocumented 4 Pinus Spp :: Pine Spp 100 2999x Turk St 1 Sidewalk: Property side : Cutout Tree Private 2   02/01/2012 12:00:00 AM   5x3 Permit Number 768613 5996638 2111487 37.7775473668867 -122.455180869531 (37.7775473668867, -122.455180869531) 15 6 2 54 16
105498 93932 Significant Tree 6 Pinus Spp :: Pine Spp 100     Front Yard : Yard Tree Private 2   04/28/2010 12:00:00 AM     Permit Number 53387 5990375.96797 2090932.55284 37.7207489795508 -122.475342064841 (37.7207489795508, -122.475342064841) 1 8 4 64 14
104875 211050 DPW Maintained 1 Pinus Spp :: Pine Spp 100 50 Garcia Ave 26 Sidewalk: Curb side : Yard Tree Private 2     20 Width 3ft   5994765.06139 2099250.41987 37.7438412428942 -122.460772924632 (37.7438412428942, -122.460772924632) 1 8 4 59 40
103685 248958 Significant Tree 6 Pinus Spp :: Pine Spp 100 98x Rosewood Dr 1 Sidewalk: Curb side : Cutout Tree Private 2   03/06/2017 12:00:00 AM 3 3x3   5994824 2095658 37.7339807377795 -122.460308897898 (37.7339807377795, -122.460308897898) 9 8 4 59 40
101304 24281 DPW Maintained 1 Pinus Spp :: Pine Spp 100 300X Winding Way 19 Median : Cutout Tree DPW 1     3 8   6001646.2933309 2086550.8578367 37.7093646550959 -122.436070699117 (37.7093646550959, -122.436070699117) 9 7 6 28861 5
99835 20781 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1701X Sunset Blvd 8 Sidewalk: Curb side : Cutout Tree DPW 1     18 60   5984888.092725 2103630.7874996 37.7552952964732 -122.49524762816 (37.7552952964732, -122.49524762816) 1 8 3 56 35
99587 110713 Undocumented 4 Pinus Spp :: Pine Spp 100 2999X Turk St 19 Sidewalk: Property side : Cutout Tree Private 2       5x3   5996638 2111487 37.7775473668867 -122.455180869531 (37.7775473668867, -122.455180869531) 15 6 2 54 16
98857 211044 DPW Maintained 1 Pinus Spp :: Pine Spp 100 372 Santa Clara Ave 3 Sidewalk: Curb side : Yard Tree Private 2     53 Width 3ft   5993146.9743 2095534.41654 37.7335447977497 -122.466097865337 (37.7335447977497, -122.466097865337) 9 8 4 59 40
98050 110259 Undocumented 4 Pinus Spp :: Pine Spp 100 655 SANCHEZ ST   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003729.2 2104438 37.7585968119418 -122.430147043342 (37.7585968119418, -122.430147043342) 2 4 5 28862 3
97619 187039 DPW Maintained 1 Pinus Spp :: Pine Spp 100 2501 Sunset Blvd 58 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984947.4301 2097783.6094 37.7392440133349 -122.494611382457 (37.7392440133349, -122.494611382457) 1 8 3 29491 35
97021 105907 Significant Tree 6 Pinus Spp :: Pine Spp 100 1837 30TH AVE 1 Front Yard : Yard Tree Private 2     6     5986904 2102674 37.7527860393128 -122.488205804709 (37.7527860393128, -122.488205804709) 1 8 3 56 35
96210 211047 DPW Maintained 1 Pinus Spp :: Pine Spp 100 50 Garcia Ave 23 Sidewalk: Curb side : Yard Tree Private 2     14 Width 3ft   5994823.08708 2099248.01179 37.7438379693465 -122.460572112329 (37.7438379693465, -122.460572112329) 1 8 4 59 40
96144 186012 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1900 Sunset Blvd 7 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5985010.9219 2101736.8552 37.750102270029 -122.494683232466 (37.750102270029, -122.494683232466) 1 8 3 29491 35
93834 87762 Permitted Site 7 Pinus Spp :: Pine Spp 100 747 Howard St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/28/2008 12:00:00 AM   3x3 Permit Number 50415 6012202 2113577 37.7841666723804 -122.401486377799 (37.7841666723804, -122.401486377799) 6 2 9 28853 34
93621 20546 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1303X Sunset Blvd 24 Sidewalk: Curb side : Cutout Tree DPW 1     3 6O   5984802.8376111 2106327.3646052 37.7626943540195 -122.495741360313 (37.7626943540195, -122.495741360313) 1 8 3 56 35
93191 110709 Undocumented 4 Pinus Spp :: Pine Spp 100 2999X Turk St 15 Sidewalk: Property side : Cutout Tree Private 2       5x3   5996638 2111487 37.7775473668867 -122.455180869531 (37.7775473668867, -122.455180869531) 15 6 2 54 16
91858 234491 DPW Maintained 1 Pinus Spp :: Pine Spp 100 24 Saturn St 5 Side Yard : Yard Tree Private 2     17 Width 3ft   6000385.28479 2106021.72649 37.7627553749804 -122.44182544749 (37.7627553749804, -122.44182544749) 15 5 5 28862 3
90765 113415 DPW Maintained 1 Pinus Spp :: Pine Spp 100 450 PORTOLA DR   Sidewalk: Curb side : Cutout Tree DPW 1     60 3x3   5998094 2100018 37.7461398052423 -122.449317577522 (37.7461398052423, -122.449317577522) 2 7 5 63 7
90517 249887 DPW Maintained 1 Pinus Spp :: Pine Spp 100 230 Greenwich St 23 Back Yard : Yard Tree Private 2     9 Width 0ft   6011491.95227 2120439.55706 37.8029699659421 -122.404426114084 (37.8029699659421, -122.404426114084) 3 1 10 28860 6
90455 186135 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1700 Sunset Blvd 20 Sidewalk: Property side : Yard Tree Private 2     5 Width 0ft   5984963.2871 2103177.7384 37.7540557509571 -122.494954183766 (37.7540557509571, -122.494954183766) 1 8 3 56 35
90168 91487 DPW Maintained 1 Pinus Spp :: Pine Spp 100 750x Brotherhood Way 21 Median : Cutout Tree DPW 1   03/15/2007 12:00:00 AM 3     5991053.474445 2088092.036965 37.7129888676025 -122.472793145921 (37.7129888676025, -122.472793145921) 1 8 4 64 14
85674 141489 DPW Maintained 1 Pinus Spp :: Pine Spp 100 2901 TURK BLVD 13 Sidewalk: Curb side : Cutout Tree Private 2     27 Width 0ft   5996912.3083 2111498.8089 37.777595524924 -122.45423280375 (37.777595524924, -122.45423280375) 15 6 2 54 16
85558 186783 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1200 Sunset Blvd 51 Sidewalk: Property side : Yard Tree Private 2     25 Width 0ft   5984862.3254 2106838.1239 37.7641002392741 -122.49557329041 (37.7641002392741, -122.49557329041) 1 8 3 56 35
84766 181408 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1500 Sunset Blvd 41 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984930.7159 2104693.9263 37.7582168762917 -122.495178621433 (37.7582168762917, -122.495178621433) 1 8 3 56 35
84533 185510 DPW Maintained 1 Pinus Spp :: Pine Spp 100 2200 Sunset Blvd 57 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5985082.4009 2099946.5475 37.7451907564521 -122.494304109241 (37.7451907564521, -122.494304109241) 1 8 3 29491 35
83939 141495 DPW Maintained 1 Pinus Spp :: Pine Spp 100 2901 TURK BLVD 19 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   5996998.9899 2111511.9757 37.7776366478442 -122.45393389566 (37.7776366478442, -122.45393389566) 15 6 2 54 16
80145 110707 Undocumented 4 Pinus Spp :: Pine Spp 100 2999X Turk St 13 Sidewalk: Property side : Cutout Tree Private 2       5x3   5996638 2111487 37.7775473668867 -122.455180869531 (37.7775473668867, -122.455180869531) 15 6 2 54 16
78297 234492 DPW Maintained 1 Pinus Spp :: Pine Spp 100 33 Mars St 1 Sidewalk: Property side : Yard Tree Private 2     28 Width 3ft   5999611.22264 2105612.60046 37.7615878796102 -122.444473240453 (37.7615878796102, -122.444473240453) 15 5 5 28862 3
72931 234470 DPW Maintained 1 Pinus Spp :: Pine Spp 100 3717 23rd St 3 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6005016.09462 2102506.34942 37.7533657549424 -122.425558901529 (37.7533657549424, -122.425558901529) 2 4 5 28862 22
72516 258223 Significant Tree 6 Pinus Spp :: Pine Spp 100 53 Starr King Way 1 Sidewalk: Property side : Cutout Tree Private 2       Width 3ft Permit Number 782966 6005764 2113984 37.784922869937 -122.423788535241 (37.784922869937, -122.423788535241) 13 9 11 28858 41
72299 200142 Undocumented 4 Pinus Spp :: Pine Spp 100 700 Jamestown Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6015325.0376 2088350.2198 37.7150729908419 -122.388919862472 (37.7150729908419, -122.388919862472) 10 3 8 58 1
70928 182054 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1358 30th Ave 3 Sidewalk: Curb side : Yard Tree Private 2     11 Width 0ft   5986815.973 2106023.5284 37.7619777922823 -122.48875640159 (37.7619777922823, -122.48875640159) 1 8 3 56 35
70203 141487 DPW Maintained 1 Pinus Spp :: Pine Spp 100 2901 TURK BLVD 11 Sidewalk: Curb side : Cutout Tree Private 2     25 Width 0ft   5996890.9122 2111495.5172 37.7775852598057 -122.45430658183 (37.7775852598057, -122.45430658183) 15 6 2 54 16

Next page

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