trees
3,267 rows where qSpecies_id = 67 sorted by rowid descending
This data as json, CSV (advanced)
| 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 188644 | 42463 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 642 Mangels Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42605 | 5997178.75826059 | 2095297.24338249 | 37.7331253587306 | -122.452141796626 | (37.7331253587306, -122.452141796626) | 9 | 7 | 4 | 59 | 40 | ||
| 188377 | 10883 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1175X Hudson Ave | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X4 | 6017544.4990408 | 2094830.7506973 | 37.7329900490522 | -122.381698823278 | (37.7329900490522, -122.381698823278) | 10 | 3 | 8 | 58 | 1 | |||
| 188353 | 205816 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 112 Marston Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 5998668.99118 | 2093222.65534 | 37.7275142813492 | -122.446840455715 | (37.7275142813492, -122.446840455715) | 9 | 7 | 4 | 28861 | 40 | ||||
| 188276 | 205689 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 454 Santiago St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5991348.98746 | 2099785.39846 | 37.7451130146704 | -122.472623790365 | (37.7451130146704, -122.472623790365) | 1 | 8 | 4 | 29491 | 40 | |||
| 188208 | 175743 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 262 Chicago Way | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 6ft | 6002717.2522 | 2086712.60101 | 37.7098695521959 | -122.432380838397 | (37.7098695521959, -122.432380838397) | 9 | 7 | 6 | 28861 | 5 | |||
| 188122 | 205837 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 51 Jules Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5994421.47665 | 2090267.87506 | 37.7191575992129 | -122.461309930536 | (37.7191575992129, -122.461309930536) | 9 | 8 | 6 | 28861 | 24 | |||
| 188110 | 220824 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2925 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009486.07185 | 2104504.3869 | 37.7591034718706 | -122.410241780631 | (37.7591034718706, -122.410241780631) | 2 | 4 | 7 | 28859 | 19 | |||
| 188058 | 50847 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 176 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2004 12:00:00 AM | Permit Number 47363 | 6004021.29629095 | 2101032.3582184 | 37.7492622601609 | -122.42889404474 | (37.7492622601609, -122.42889404474) | 2 | 4 | 5 | 28862 | 22 | |||
| 187948 | 54551 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3 Maddux Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/1972 12:00:00 AM | 12 | Permit Number 10346 | 6012799.88912 | 2095700.21699 | 37.7351142990821 | -122.398163266846 | (37.7351142990821, -122.398163266846) | 10 | 3 | 8 | 58 | 1 | ||
| 187941 | 113544 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 182 Gambier St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6005841.47064 | 2092905.54198 | 37.7270506988092 | -122.422022592774 | (37.7270506988092, -122.422022592774) | 9 | 7 | 7 | 309 | 5 | |||
| 187929 | 125786 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2656 Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5999208.49326 | 2117946.86067 | 37.7954315940422 | -122.446753630693 | (37.7954315940422, -122.446753630693) | 13 | 9 | 1 | 57 | 17 | |||
| 187926 | 205730 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 384 Santa Ana Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5992451.0819 | 2094235.05833 | 37.7299369110495 | -122.468409243503 | (37.7299369110495, -122.468409243503) | 9 | 8 | 4 | 59 | 40 | |||
| 187920 | 101146 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 455 Arkansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6012986.24461 | 2104921.29012 | 37.7604437737932 | -122.398165684193 | (37.7604437737932, -122.398165684193) | 10 | 3 | 8 | 28856 | 29 | |||
| 187828 | 222373 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 172 Hancock St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6003180.8835 | 2105075.71823 | 37.7603167625284 | -122.432088908574 | (37.7603167625284, -122.432088908574) | 2 | 4 | 5 | 28862 | 3 | |||
| 187793 | 3452 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 42 Cameo Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 45 | 3X3 | 5999533.14078 | 2099571.88767 | 37.7449971028319 | -122.444309175354 | (37.7449971028319, -122.444309175354) | 2 | 7 | 5 | 63 | 22 | |||
| 187782 | 8946 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4800 Geary Blvd | 6 | Median : Cutout | Tree | DPW 1 | 3 | M6 | 5992178.808881 | 2112763.6040387 | 37.780795730088 | -122.470699570025 | (37.780795730088, -122.470699570025) | 11 | 6 | 2 | 54 | 11 | |||
| 187753 | 121833 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 312 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5989978.60269 | 2113233.847 | 37.7819594078945 | -122.478345463519 | (37.7819594078945, -122.478345463519) | 11 | 6 | 2 | 55 | 26 | |||
| 187729 | 175662 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2001 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5999762.46297 | 2092248.32928 | 37.724901414463 | -122.442990387895 | (37.724901414463, -122.442990387895) | 9 | 7 | 6 | 28861 | 25 | |||
| 187720 | 125843 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1463 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6006477.878 | 2117960.43479 | 37.7958814457163 | -122.421601262209 | (37.7958814457163, -122.421601262209) | 13 | 9 | 10 | 28858 | 32 | |||
| 187669 | 4871 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 48 Crags Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6000859.63404 | 2098067.6041 | 37.7409422881585 | -122.439614591049 | (37.7409422881585, -122.439614591049) | 2 | 7 | 5 | 63 | 7 | |||
| 187653 | 68276 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 543 Bowdoin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 6 | Permit Number 32083 | 6008845.70964 | 2093488.4538 | 37.7288202318587 | -122.411678113946 | (37.7288202318587, -122.411678113946) | 9 | 3 | 7 | 309 | 28 | |
| 187357 | 250224 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 312 Filbert St | 6 | Side Yard : Yard | Tree | Private 2 | 9 | Width 0ft | 6011221.34302 | 2120070.92711 | 37.8019426721638 | -122.405336592216 | (37.8019426721638, -122.405336592216) | 3 | 1 | 10 | 308 | 23 | |||
| 187329 | 59111 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 662 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/1980 12:00:00 AM | 9 | Permit Number 18415 | 5993195.14439 | 2110965.57109 | 37.7759175373362 | -122.467052839991 | (37.7759175373362, -122.467052839991) | 11 | 6 | 2 | 54 | 11 | ||
| 187284 | 54544 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 154 Gaven St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/1972 12:00:00 AM | 11 | Permit Number 10339 | 6009702.32393 | 2095129.77936 | 37.7333749787789 | -122.408832479143 | (37.7333749787789, -122.408832479143) | 10 | 3 | 7 | 309 | 28 | ||
| 187271 | 222166 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4366 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6000838.06906 | 2101731.5452 | 37.7510013707183 | -122.439951801727 | (37.7510013707183, -122.439951801727) | 2 | 4 | 5 | 28862 | 22 | |||
| 187196 | 125857 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1148 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007410.78308 | 2119548.4108 | 37.8002941896961 | -122.418485883829 | (37.8002941896961, -122.418485883829) | 5 | 1 | 1 | 28858 | 32 | |||
| 187185 | 175622 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 700x Mansell St | 18 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6009430.20513 | 2090028.38757 | 37.7193523869705 | -122.40941337645 | (37.7193523869705, -122.40941337645) | 9 | 3 | 8 | 309 | 18 | |||
| 187171 | 220881 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 599 Belvedere St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5998623.62427 | 2105781.05469 | 37.76199401253 | -122.447901054088 | (37.76199401253, -122.447901054088) | 15 | 5 | 11 | 29492 | 9 | |||
| 187163 | 125752 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2870 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5999213.3669 | 2118400.45561 | 37.7966773232594 | -122.446769420986 | (37.7966773232594, -122.446769420986) | 13 | 9 | 1 | 57 | 17 | |||
| 187045 | 112794 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 21x JOICE ST | 5 | Unaccepted Street : Cutout | Tree | Private 2 | 6010276 | 2116206 | 37.7912776248382 | -122.408335175586 | (37.7912776248382, -122.408335175586) | 5 | 1 | 10 | 28857 | 21 | |||||
| 186971 | 9881 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1520 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4X4 | 6005407.78962 | 2115025.03332 | 37.7877611737987 | -122.425095007823 | (37.7877611737987, -122.425095007823) | 13 | 9 | 1 | 28858 | 41 | |||
| 186957 | 118311 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 990 Rhode Island St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011874 | 2103773 | 37.7572288087602 | -122.401931725179 | (37.7572288087602, -122.401931725179) | 10 | 3 | 8 | 28856 | 29 | ||||
| 186923 | 8740 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3300 Geary Blvd | 5 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5996964.8998051 | 2112982.2523578 | 37.7816716864396 | -122.454158044121 | (37.7816716864396, -122.454158044121) | 11 | 6 | 1 | 54 | 31 | |||
| 186897 | 82990 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 737 Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50125 | 6009298.17418 | 2110240.35937 | 37.7748425951352 | -122.411296828379 | (37.7748425951352, -122.411296828379) | 8 | 2 | 9 | 28853 | 34 | |
| 186885 | 10043 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 360 Guerrero St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6005477.51423 | 2106859.76809 | 37.765345281278 | -122.424272816157 | (37.765345281278, -122.424272816157) | 8 | 4 | 5 | 28853 | 19 | |||
| 186848 | 220782 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 200 Florida St | 29 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6009149.20371 | 2106999.46315 | 37.7659354919643 | -122.411583121262 | (37.7659354919643, -122.411583121262) | 8 | 4 | 7 | 28853 | 19 | |||
| 186829 | 199839 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2299 Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6014608 | 2092714 | 37.7270152974991 | -122.39170320083 | (37.7270152974991, -122.39170320083) | 10 | 3 | 8 | 58 | 1 | |||
| 186819 | 43500 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 401 Gates St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2000 12:00:00 AM | Permit Number 43180 | 6008272.42807324 | 2096955.00828501 | 37.7383064636933 | -122.413905114955 | (37.7383064636933, -122.413905114955) | 2 | 7 | 7 | 28859 | 2 | ||
| 186800 | 125820 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2067 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6003140.75191 | 2118205.20485 | 37.7963647854668 | -122.433165835937 | (37.7963647854668, -122.433165835937) | 13 | 9 | 1 | 57 | 17 | |||
| 186753 | 102383 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 471-473 Noe St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/22/2013 12:00:00 AM | 12 | 3x3 | Permit Number 769850 | 6002995 | 2105507 | 37.7614904180073 | -122.432762601795 | (37.7614904180073, -122.432762601795) | 15 | 4 | 5 | 28862 | 3 | |
| 186704 | 44402 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1162 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 7 | Permit Number 43756 | 6001306.88514 | 2087104.50261 | 37.7108655531865 | -122.437283363033 | (37.7108655531865, -122.437283363033) | 9 | 7 | 6 | 28861 | 5 | |
| 186698 | 125877 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 532 Pacific Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6011538.01485 | 2118371.01947 | 37.7972928381608 | -122.404121047862 | (37.7972928381608, -122.404121047862) | 3 | 1 | 10 | 308 | 23 | |||
| 186572 | 125830 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1700 Vallejo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6005331.8246 | 2118206.2485 | 37.7964916986797 | -122.425584329857 | (37.7964916986797, -122.425584329857) | 13 | 9 | 1 | 28858 | 17 | |||
| 186542 | 204529 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 400x Marietta Dr | 29 | Median : Cutout | Tree | DPW 1 | 11 | Width 3ft | 5999184.7705 | 2097021.01068 | 37.7379731233579 | -122.44533039779 | (37.7379731233579, -122.44533039779) | 9 | 7 | 4 | 59 | 40 | |||
| 186527 | 222202 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 552 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6001171.20737 | 2103078.19007 | 37.7547178919379 | -122.438896272856 | (37.7547178919379, -122.438896272856) | 2 | 4 | 5 | 28862 | 22 | |||
| 186515 | 123097 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 601 11th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 1ft | 5992508.59963 | 2111311.3949 | 37.7768274241689 | -122.469452933616 | (37.7768274241689, -122.469452933616) | 11 | 6 | 2 | 54 | 11 | |||
| 186467 | 48734 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 112 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/2002 12:00:00 AM | Permit Number 46014 | 6001443.50423179 | 2107544.90678437 | 37.7669978945619 | -122.438274574244 | (37.7669978945619, -122.438274574244) | 15 | 5 | 5 | 28862 | 3 | |||
| 186455 | 137628 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2111 TURK BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5999819.7212 | 2111906.387 | 37.7788809252276 | -122.444204411788 | (37.7788809252276, -122.444204411788) | 15 | 5 | 11 | 29490 | 16 | |||
| 186447 | 125765 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1700 Beach St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 6001986.0819 | 2121160.28374 | 37.8044130873674 | -122.437372940016 | (37.8044130873674, -122.437372940016) | 13 | 9 | 1 | 57 | 17 | |||
| 186412 | 13167 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1906 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/1993 12:00:00 AM | 26 | 3X3 | 6003216.0169 | 2119655.6641 | 37.8003516396791 | -122.433009083838 | (37.8003516396791, -122.433009083838) | 13 | 9 | 1 | 57 | 17 | ||
| 186375 | 34141 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2466 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/12/1997 12:00:00 AM | 7 | Permit Number 37989 | 5986144.1807 | 2098458.7736 | 37.7411678068726 | -122.490523271138 | (37.7411678068726, -122.490523271138) | 1 | 8 | 3 | 29491 | 35 | ||
| 186369 | 222461 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1008 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6002464.47258 | 2102612.29458 | 37.7535121492774 | -122.434390507519 | (37.7535121492774, -122.434390507519) | 2 | 4 | 5 | 28862 | 22 | |||
| 186357 | 220959 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3325 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006141.66232 | 2103736.00515 | 37.7568056392904 | -122.42175378182 | (37.7568056392904, -122.42175378182) | 2 | 4 | 5 | 28859 | 19 | |||
| 186220 | 77209 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 499X Hearst Ave | 16 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/15/1999 12:00:00 AM | 5 | 3x3 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 | |
| 186002 | 182819 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1803 30th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5986876.4726 | 2102917.9682 | 37.7534543037822 | -122.488318925723 | (37.7534543037822, -122.488318925723) | 1 | 8 | 3 | 56 | 35 | |||
| 185963 | 183532 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2571 28th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 0ft | 5987672.2406 | 2097791.749 | 37.7394254680034 | -122.485190924064 | (37.7394254680034, -122.485190924064) | 1 | 8 | 3 | 29491 | 35 | |||
| 185938 | 205757 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 192 Casitas Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5994977.55307 | 2097082.25063 | 37.737900211736 | -122.459881156894 | (37.737900211736, -122.459881156894) | 9 | 7 | 4 | 59 | 40 | |||
| 185802 | 222198 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4378 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6000769.27118 | 2102309.32258 | 37.7525838915375 | -122.440231140164 | (37.7525838915375, -122.440231140164) | 2 | 4 | 5 | 28862 | 22 | |||
| 185790 | 32080 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3851 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2017 12:00:00 AM | 3 | 3x3 | Permit Number 51784 | 6003941.65438147 | 2105363.49480285 | 37.7611500308423 | -122.429478281048 | (37.7611500308423, -122.429478281048) | 2 | 4 | 5 | 28862 | 3 | |
| 185761 | 125771 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3590 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5997625.81627 | 2115785.01551 | 37.7894052091251 | -122.452073877802 | (37.7894052091251, -122.452073877802) | 11 | 6 | 1 | 54 | 31 | |||
| 185749 | 175736 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 315 Naylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002759.3959 | 2086598.756 | 37.7095593481574 | -122.432227057027 | (37.7095593481574, -122.432227057027) | 9 | 7 | 6 | 28861 | 5 | |||
| 185719 | 222462 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1822 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004552.52358 | 2098188.18805 | 37.7414828769245 | -122.426854521529 | (37.7414828769245, -122.426854521529) | 2 | 7 | 5 | 63 | 7 | |||
| 185666 | 220821 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 855 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6010196.73847 | 2104242.38476 | 37.7584238829769 | -122.407765471296 | (37.7584238829769, -122.407765471296) | 10 | 4 | 7 | 28859 | 19 | |||
| 185615 | 125836 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 12 Golden Ct | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 5ft | 6008214.16509 | 2116540.37994 | 37.7920800761809 | -122.415492776366 | (37.7920800761809, -122.415492776366) | 5 | 1 | 10 | 28858 | 21 | |||
| 185570 | 63460 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 49 Bache St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/17/1987 12:00:00 AM | Permit Number 24051 | 6007223.26460281 | 2095568.0239897 | 37.7344391315139 | -122.417434347924 | (37.7344391315139, -122.417434347924) | 2 | 7 | 7 | 28859 | 2 | ||
| 185550 | 188250 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1039 Jamestown Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | 6013748.16101 | 2089779.78907 | 37.7189107748964 | -122.394470304261 | (37.7189107748964, -122.394470304261) | 10 | 3 | 8 | 58 | 1 | ||||
| 185378 | 82894 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1325 Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52441 | 6008668.81492 | 2110175.98825 | 37.7746305296131 | -122.413469367432 | (37.7746305296131, -122.413469367432) | 8 | 2 | 9 | 28853 | 34 | |
| 185189 | 15229 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1263 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6008515.33313 | 2110876.38716 | 37.7765450403581 | -122.414049853039 | (37.7765450403581, -122.414049853039) | 8 | 2 | 9 | 28853 | 34 | |||
| 185101 | 222326 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3280 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008336.06771 | 2104484.60195 | 37.7589846174619 | -122.414217655545 | (37.7589846174619, -122.414217655545) | 2 | 4 | 7 | 28859 | 19 | |||
| 185079 | 220793 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2431 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6011241.4446 | 2102272.78531 | 37.753074227106 | -122.404013786623 | (37.753074227106, -122.404013786623) | 10 | 4 | 8 | 28859 | 19 | |||
| 185070 | 205786 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 201 Hearst Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5999992.74573 | 2094346.93273 | 37.7306768210812 | -122.442344919278 | (37.7306768210812, -122.442344919278) | 9 | 7 | 4 | 63 | 40 | |||
| 184904 | 222437 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 264 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5999700.34771 | 2105495.73496 | 37.7612720808519 | -122.444156596344 | (37.7612720808519, -122.444156596344) | 15 | 5 | 5 | 28862 | 3 | |||
| 184893 | 200049 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1590 Shafter Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6015007.7446 | 2094143.437 | 37.7309624265756 | -122.390421112537 | (37.7309624265756, -122.390421112537) | 10 | 3 | 8 | 58 | 1 | |||
| 184810 | 92930 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 321 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2x2 | 5992299.8 | 2096997.6 | 37.7375134194845 | -122.469133217923 | (37.7375134194845, -122.469133217923) | 1 | 8 | 4 | 59 | 40 | |||
| 184699 | 56181 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 788 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/03/1973 12:00:00 AM | 8 | Permit Number 12289 | 5991026.9623 | 2110070.57762 | 37.7733347420548 | -122.474487737466 | (37.7733347420548, -122.474487737466) | 11 | 6 | 2 | 54 | 26 | ||
| 184646 | 113694 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 907 FLORIDA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6009441 | 2103786 | 37.7571284172194 | -122.410346937481 | (37.7571284172194, -122.410346937481) | 2 | 4 | 7 | 28859 | 19 | |||
| 184617 | 220939 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 989 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6009179.8123 | 2103380.42673 | 37.7560001596871 | -122.411221579429 | (37.7560001596871, -122.411221579429) | 2 | 4 | 7 | 28859 | 19 | |||
| 184589 | 204508 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 120 Cresta Vista Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5995837.30654 | 2096190.27976 | 37.7355004850657 | -122.456844092381 | (37.7355004850657, -122.456844092381) | 9 | 7 | 4 | 59 | 40 | |||
| 184574 | 205869 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 118 Lakeview Ave | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5997252.76199 | 2089357.29362 | 37.7168198961062 | -122.451457665965 | (37.7168198961062, -122.451457665965) | 9 | 8 | 6 | 28861 | 24 | |||
| 184565 | 204449 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992698.71304 | 2099071.57233 | 37.7432310654588 | -122.467904805677 | (37.7432310654588, -122.467904805677) | 1 | 8 | 4 | 29491 | 40 | |||
| 184537 | 125794 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 101 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6001288.01162 | 2121135.2831 | 37.8043047325274 | -122.439786873275 | (37.8043047325274, -122.439786873275) | 13 | 9 | 1 | 57 | 17 | |||
| 184439 | 10891 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1270X Hudson Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X4 | 6017265.0162454 | 2095327.7862917 | 37.734339374173 | -122.382699652574 | (37.734339374173, -122.382699652574) | 10 | 3 | 8 | 58 | 1 | |||
| 184311 | 64229 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 290 Mullen Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/2003 12:00:00 AM | Permit Number 25022 | 6010413.42426416 | 2099945.44819884 | 37.7466375738905 | -122.406713254495 | (37.7466375738905, -122.406713254495) | 2 | 7 | 7 | 28859 | 2 | ||
| 184208 | 182404 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1543 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5985573.5929 | 2104717.8217 | 37.7583201033903 | -122.492957065208 | (37.7583201033903, -122.492957065208) | 1 | 8 | 3 | 56 | 35 | |||
| 184187 | 205843 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 23 Jules Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5994419.00692 | 2090084.06137 | 37.7186527486105 | -122.461305149717 | (37.7186527486105, -122.461305149717) | 9 | 8 | 6 | 28861 | 24 | |||
| 184175 | 87852 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1800X Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50759 | 6003483 | 2114899 | 37.7873061997009 | -122.431745409173 | (37.7873061997009, -122.431745409173) | 13 | 9 | 11 | 29490 | 27 | |
| 184147 | 205677 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 501x Ortega St | 7 | Median : Cutout | Tree | DPW 1 | 2 | Width 2ft | 5992540.21682 | 2103087.49694 | 37.7542486085892 | -122.468744999088 | (37.7542486085892, -122.468744999088) | 1 | 8 | 4 | 56 | 12 | |||
| 184141 | 222330 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 161 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6005914.56734 | 2096396.79373 | 37.7366410277445 | -122.422017806579 | (37.7366410277445, -122.422017806579) | 2 | 7 | 7 | 28859 | 2 | |||
| 184021 | 113500 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 200x Mansell St | 6 | Median : Cutout | Tree | DPW 1 | 7 | 3x3 | 6011183.30408 | 2090581.60768 | 37.7209694867258 | -122.403392432416 | (37.7209694867258, -122.403392432416) | 10 | 3 | 7 | 309 | 28 | |||
| 183978 | 31357 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2399 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1995 12:00:00 AM | Permit Number 34966 | 5991349.80377986 | 2099091.89396406 | 37.7432088770408 | -122.472570415702 | (37.7432088770408, -122.472570415702) | 1 | 8 | 4 | 29491 | 40 | ||
| 183965 | 182012 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3200 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5986086.649 | 2098251.6594 | 37.7405957660234 | -122.490706957112 | (37.7405957660234, -122.490706957112) | 1 | 8 | 3 | 29491 | 35 | |||
| 183944 | 175645 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 275 De Long St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 10ft | 5993719.51846 | 2086804.65789 | 37.7096080059695 | -122.463485117158 | (37.7096080059695, -122.463485117158) | 9 | 8 | 6 | 28861 | 25 | |||
| 183848 | 98118 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3060@Greenwich Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 23584 | 6001464 | 2118900 | 37.7981772521061 | -122.439017558255 | (37.7981772521061, -122.439017558255) | 13 | 9 | 1 | 57 | 17 | ||||
| 183819 | 10880 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1175X Hudson Ave | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X4 | 6017544.4990408 | 2094830.7506973 | 37.7329900490522 | -122.381698823278 | (37.7329900490522, -122.381698823278) | 10 | 3 | 8 | 58 | 1 | |||
| 183712 | 204419 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 212 Edgewood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5996606.0706 | 2105854.44201 | 37.7620799877156 | -122.454884249331 | (37.7620799877156, -122.454884249331) | 15 | 5 | 11 | 29492 | 12 | |||
| 183527 | 205739 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 32 Mesa Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 5993618.94028 | 2100774.85979 | 37.7479609580525 | -122.464846596315 | (37.7479609580525, -122.464846596315) | 1 | 8 | 4 | 29491 | 40 | |||
| 183460 | 204486 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 74 Ventura Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5994244.88576 | 2101786.49347 | 37.7507747172997 | -122.462755497195 | (37.7507747172997, -122.462755497195) | 1 | 8 | 4 | 29491 | 40 | |||
| 183381 | 199685 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1363 Thomas Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6016033.0091 | 2092958.73 | 37.7277662775145 | -122.386793982618 | (37.7277662775145, -122.386793982618) | 10 | 3 | 8 | 58 | 1 | |||
| 183311 | 9216 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 6300 Geary Blvd | 3 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5987396.5402 | 2112575.6349 | 37.7800019123037 | -122.487229736584 | (37.7800019123037, -122.487229736584) | 11 | 6 | 2 | 55 | 26 | |||
| 183231 | 222464 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 162 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6004463.48445 | 2097560.63727 | 37.7397547306933 | -122.427117700038 | (37.7397547306933, -122.427117700038) | 2 | 7 | 5 | 63 | 7 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );