trees
7,157 rows where qSpecies_id = 36 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
189132 | 132837 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3159 Clay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5999664.45258 | 2115694.11455 | 37.7892721832246 | -122.445013913784 | (37.7892721832246, -122.445013913784) | 13 | 6 | 1 | 29490 | 27 | |||
189126 | 97863 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 895 Indiana St | 10 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | 10 | 3 | 8 | 28856 | 29 | |||||
189099 | 42732 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1790 Yosemite Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | 11 | Permit Number 42732 | 6013639.7099 | 2093421.36867 | 37.7289037905782 | -122.395100113884 | (37.7289037905782, -122.395100113884) | 10 | 3 | 8 | 58 | 1 | |
189059 | 234178 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 124 Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6004252.99073 | 2109354.05836 | 37.7721247791653 | -122.42868597918 | (37.7721247791653, -122.42868597918) | 7 | 9 | 11 | 28852 | 10 | |||
189043 | 14826 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1269 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4X4 | 6003119.6747 | 2111677.9775 | 37.7784414803533 | -122.432772251133 | (37.7784414803533, -122.432772251133) | 15 | 9 | 11 | 29492 | 41 | |||
189010 | 211619 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 551 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5991171.23204 | 2097691.01361 | 37.7393520808311 | -122.473085724454 | (37.7393520808311, -122.473085724454) | 1 | 8 | 4 | 29491 | 40 | |||
189004 | 187230 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2401 Sunset Blvd | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984931.9096 | 2098648.6859 | 37.741618371959 | -122.4947288063 | (37.741618371959, -122.4947288063) | 1 | 8 | 3 | 29491 | 35 | |||
189001 | 103249 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2659 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6000303.19114 | 2117809.86382 | 37.79511791052 | -122.442955960953 | (37.79511791052, -122.442955960953) | 13 | 9 | 1 | 57 | 27 | |||
188984 | 133024 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1245 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6007939.67704 | 2115816.30321 | 37.7900765071624 | -122.416391200918 | (37.7900765071624, -122.416391200918) | 13 | 1 | 10 | 28858 | 21 | |||
188958 | 138090 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2059 BUSH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6003678.8968 | 2114877.1562 | 37.7872573245386 | -122.431066088157 | (37.7872573245386, -122.431066088157) | 13 | 9 | 11 | 29490 | 27 | |||
188933 | 235291 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 172 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6000145.82525 | 2104897.02487 | 37.7596535745668 | -122.442572894717 | (37.7596535745668, -122.442572894717) | 2 | 4 | 5 | 28862 | 3 | |||
188866 | 104754 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 50 Walnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/28/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781111 | 5998483.43829 | 2116249.0389 | 37.7907283825673 | -122.449140058165 | (37.7907283825673, -122.449140058165) | 13 | 6 | 1 | 54 | 31 | |
188858 | 234032 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 127 Webster St | 2 | : | Tree | Private 2 | 11 | Width 3ft | 6004225.74484 | 2109231.03769 | 37.7717854523628 | -122.428771453444 | (37.7717854523628, -122.428771453444) | 7 | 9 | 11 | 29492 | 10 | |||
188855 | 97858 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 895 Indiana St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | 10 | 3 | 8 | 28856 | 29 | |||||
188849 | 101404 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 428 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 6x9 | 6013479.18569 | 2105074.56282 | 37.7608920714195 | -122.396471560235 | (37.7608920714195, -122.396471560235) | 10 | 3 | 8 | 28856 | 29 | |||
188766 | 104984 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 246 Ritch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/2013 12:00:00 AM | 3 | Permit Number 58498 | 6013841.69397 | 2112138.93882 | 37.780309438982 | -122.395712786018 | (37.780309438982, -122.395712786018) | 6 | 2 | 9 | 28856 | 34 | ||
188728 | 91894 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1340 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/18/2009 12:00:00 AM | 3 | 3x3 | 5991633.728817 | 2106598.350809 | 37.7638360767373 | -122.472135724849 | (37.7638360767373, -122.472135724849) | 11 | 8 | 11 | 56 | 12 | ||
188721 | 15375 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1979 Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/02/2006 12:00:00 AM | 3 | 4X4 | 6006845.42112 | 2106936.21263 | 37.7656323248047 | -122.419546959621 | (37.7656323248047, -122.419546959621) | 8 | 4 | 7 | 28853 | 19 | ||
188710 | 120489 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2145 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 5988804.49322 | 2113292.9951 | 37.7820535826473 | -122.482411629275 | (37.7820535826473, -122.482411629275) | 11 | 6 | 2 | 55 | 26 | |||
188677 | 25169 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2750 Market St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 2X2 | 6001142.45323 | 2105593.76243 | 37.7616234055165 | -122.439176000671 | (37.7616234055165, -122.439176000671) | 15 | 4 | 5 | 28862 | 3 | |||
188632 | 211838 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 123 Hamerton Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 5ft | 6001383.60004 | 2095483.10964 | 37.7338756763249 | -122.43761786859 | (37.7338756763249, -122.43761786859) | 9 | 7 | 5 | 63 | 40 | |||
188610 | 194918 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 650 China Basin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6014988.76083 | 2109070.36256 | 37.7719475560745 | -122.391529924967 | (37.7719475560745, -122.391529924967) | 14 | 3 | 9 | 310 | 20 | |||
188604 | 118065 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 414 36th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 5984711.31641 | 2113070.71562 | 37.7812043122816 | -122.496555535147 | (37.7812043122816, -122.496555535147) | 11 | 6 | 2 | 55 | 26 | |||
188603 | 103545 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 905X Phelps St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10 | 6x12 | 6014832.8 | 2097357.7 | 37.7397784309436 | -122.39125052869 | (37.7397784309436, -122.39125052869) | 10 | 3 | 8 | 58 | 1 | |||
188544 | 41354 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1146 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/03/2000 12:00:00 AM | 8 | Permit Number 42004 | 6009032.08633 | 2116894.1566 | 37.7930974000717 | -122.412687770224 | (37.7930974000717, -122.412687770224) | 3 | 1 | 10 | 28857 | 21 | ||
188534 | 234227 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1210 Shrader St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5997761.79664 | 2106363.60396 | 37.7635442467959 | -122.450923773515 | (37.7635442467959, -122.450923773515) | 15 | 5 | 11 | 29492 | 9 | |||
188513 | 132523 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3700 Divisadero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6000195.23683 | 2121016.31138 | 37.8039158063343 | -122.443559945651 | (37.8039158063343, -122.443559945651) | 13 | 9 | 1 | 57 | 17 | |||
188492 | 3022 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2500 California St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6002320.41047 | 2115449.41202 | 37.7887515207208 | -122.435807114222 | (37.7887515207208, -122.435807114222) | 13 | 6 | 1 | 29490 | 27 | |||
188490 | 93541 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 325 China Basin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/2010 12:00:00 AM | 3x3 | Permit Number 53240 | 6016190.6 | 2109941.9 | 37.774407241214 | -122.387433446454 | (37.774407241214, -122.387433446454) | 14 | 3 | 9 | 310 | 20 | ||
188454 | 236114 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 404 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6003732.02674 | 2109033.88495 | 37.7712161635303 | -122.430465187137 | (37.7712161635303, -122.430465187137) | 15 | 9 | 11 | 29492 | 10 | |||
188427 | 122990 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 148 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 5993687.72704 | 2114499.54301 | 37.7856492885096 | -122.465605683703 | (37.7856492885096, -122.465605683703) | 11 | 6 | 2 | 54 | 11 | |||
188396 | 93150 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 284X Funston Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/2015 12:00:00 AM | 3 | Permit Number 775609 | 5991864.69021 | 2113542.09367 | 37.7829150789203 | -122.471843002028 | (37.7829150789203, -122.471843002028) | 11 | 6 | 2 | 54 | 11 | ||
188394 | 246205 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1357 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5999520.6669 | 2108013.8353 | 37.7681759026799 | -122.444959057744 | (37.7681759026799, -122.444959057744) | 15 | 5 | 11 | 29492 | 9 | |||
188329 | 102460 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 559 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6007888 | 2104678 | 37.7594904656222 | -122.415780983244 | (37.7594904656222, -122.415780983244) | 2 | 4 | 7 | 28859 | 19 | |||
188298 | 245873 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 230 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6001287.71 | 2109606.3036 | 37.7726491151375 | -122.438961187116 | (37.7726491151375, -122.438961187116) | 15 | 5 | 11 | 29492 | 9 | |||
188274 | 133134 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 882 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6007617.11872 | 2120616.93591 | 37.8032397041064 | -122.417847663754 | (37.8032397041064, -122.417847663754) | 5 | 1 | 1 | 308 | 32 | |||
188265 | 256631 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 4805 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999749 | 2104713 | 37.7591256596381 | -122.443932088895 | (37.7591256596381, -122.443932088895) | 2 | 4 | 5 | 28862 | 3 | ||||
188200 | 211775 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 160 San Fernando Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 5ft | 5992116.40883 | 2095617.07148 | 37.7337122371373 | -122.469666808678 | (37.7337122371373, -122.469666808678) | 9 | 8 | 4 | 59 | 40 | |||
188199 | 140031 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 867 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6005046.0942 | 2111937.9886 | 37.7792644753154 | -122.426126551887 | (37.7792644753154, -122.426126551887) | 7 | 9 | 11 | 28852 | 41 | |||
188167 | 235294 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 379 Eureka St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001510.65596 | 2103640.17607 | 37.7562802769191 | -122.437762617176 | (37.7562802769191, -122.437762617176) | 2 | 4 | 5 | 28862 | 3 | |||
188155 | 49351 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1875@ EVANS Marin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2003 12:00:00 AM | 6 | Permit Number 46338 | 6013912.72254 | 2100509.04329 | 37.7483802534545 | -122.394652415188 | (37.7483802534545, -122.394652415188) | 10 | 3 | 8 | 58 | 1 | ||
188151 | 211857 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 427 Joost Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 5999230.5325 | 2094946.3403 | 37.7322791809299 | -122.445023072472 | (37.7322791809299, -122.445023072472) | 9 | 7 | 4 | 59 | 40 | |||
188131 | 97727 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1150 Francisco St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 3x3 | Permit Number 50638 | 6005898.3389 | 2120719.31411 | 37.8034239311172 | -122.423802846647 | (37.8034239311172, -122.423802846647) | 5 | 9 | 1 | 28858 | 32 | |
188124 | 81783 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3031 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2007 12:00:00 AM | 7 | 3x3 | Permit Number 50045 | 6004668.9504 | 2119987.11567 | 37.8013440258604 | -122.428004988233 | (37.8013440258604, -122.428004988233) | 13 | 9 | 1 | 57 | 17 | |
188052 | 211733 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2523 Ocean Ave | 5 | : | Tree | Private 2 | 8 | Width 3ft | 5991297.32334 | 2094728.95859 | 37.7312263275125 | -122.472433877821 | (37.7312263275125, -122.472433877821) | 1 | 8 | 4 | 64 | 40 | |||
188026 | 132556 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 201 Alhambra St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001224.32633 | 2120078.88485 | 37.8014005185653 | -122.43993146986 | (37.8014005185653, -122.43993146986) | 13 | 9 | 1 | 57 | 17 | |||
188012 | 194772 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1151 Newhall St | 4 | : | Tree | Private 2 | 12 | Width 3ft | 6014936.90025 | 2096384.90084 | 37.737113100777 | -122.390822623484 | (37.737113100777, -122.390822623484) | 10 | 3 | 8 | 58 | 1 | |||
187935 | 96343 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 162 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/2011 12:00:00 AM | 3x3 | Permit Number 767899 | 6000230.1 | 2104925 | 37.7597351909121 | -122.442283439502 | (37.7597351909121, -122.442283439502) | 2 | 4 | 5 | 28862 | 3 | ||
187901 | 132933 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2759 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6003510.61781 | 2117869.85232 | 37.7954649678987 | -122.431862065391 | (37.7954649678987, -122.431862065391) | 13 | 9 | 1 | 29490 | 27 | |||
187877 | 1901 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 20 Beideman St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/02/1990 12:00:00 AM | 12 | 3X3 | 6001549.818 | 2113046.7838 | 37.7821107162203 | -122.438301053255 | (37.7821107162203, -122.438301053255) | 15 | 5 | 11 | 29490 | 41 | ||
187866 | 211828 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 151 Lippard Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6001858.00026 | 2095266.22185 | 37.7333071141379 | -122.435962212185 | (37.7333071141379, -122.435962212185) | 9 | 7 | 5 | 63 | 40 | |||
187800 | 234088 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1370 Minna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6006968.20347 | 2107476.57296 | 37.767122942383 | -122.419160614579 | (37.767122942383, -122.419160614579) | 8 | 4 | 7 | 28853 | 19 | |||
187725 | 32785 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1903 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/29/1996 12:00:00 AM | 5 | Permit Number 37152 | 6001293.802 | 2112456.0686 | 37.7804741978788 | -122.439144399891 | (37.7804741978788, -122.439144399891) | 15 | 5 | 11 | 29490 | 41 | ||
187569 | 235003 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 851 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6000893.84079 | 2102572.36421 | 37.7533132318331 | -122.439819215602 | (37.7533132318331, -122.439819215602) | 2 | 4 | 5 | 28862 | 22 | |||
187493 | 132976 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 477 O'Farrell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6009019.65584 | 2114227.5929 | 37.7857749652758 | -122.412542197859 | (37.7857749652758, -122.412542197859) | 14 | 10 | 9 | 28852 | 36 | |||
187403 | 194737 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1201 19th St | 1 | : | Tree | Private 2 | 13 | Width 4ft | 6013962.08957 | 2105226.07234 | 37.7613349452796 | -122.394812007068 | (37.7613349452796, -122.394812007068) | 10 | 3 | 8 | 28856 | 29 | |||
187385 | 18964 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2900X Sacramento St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6000852.43572 | 2115585.85435 | 37.7890426600412 | -122.440895874969 | (37.7890426600412, -122.440895874969) | 13 | 6 | 1 | 29490 | 27 | |||
187363 | 234281 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 825 Shotwell St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6007984.97689 | 2103051.07657 | 37.7550287569967 | -122.415330414561 | (37.7550287569967, -122.415330414561) | 2 | 4 | 7 | 28859 | 19 | |||
187298 | 194872 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 411 China Basin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6016098.84287 | 2109085.27848 | 37.7720500643794 | -122.38769107529 | (37.7720500643794, -122.38769107529) | 14 | 3 | 9 | 310 | 20 | |||
187272 | 132643 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3401 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5997933.43091 | 2116108.28343 | 37.7903104325269 | -122.451032891855 | (37.7903104325269, -122.451032891855) | 11 | 6 | 1 | 54 | 31 | |||
187219 | 133060 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1591 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6006590.00271 | 2117312.4199 | 37.7941084808798 | -122.421167252065 | (37.7941084808798, -122.421167252065) | 13 | 9 | 10 | 28858 | 32 | |||
187090 | 67575 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 565 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 9 | Permit Number 31130 | 6013293.87776 | 2104434.51865 | 37.759124336134 | -122.397067584101 | (37.759124336134, -122.397067584101) | 10 | 3 | 8 | 28856 | 29 | |
187064 | 178491 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 151 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 6002740.81562 | 2092560.25993 | 37.7259272675047 | -122.432716846698 | (37.7259272675047, -122.432716846698) | 9 | 7 | 6 | 28861 | 5 | |||
187054 | 141947 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1101 GOLDEN GATE AVE | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6004269.2573 | 2112179.9344 | 37.7798848612657 | -122.428831206259 | (37.7798848612657, -122.428831206259) | 7 | 9 | 11 | 29490 | 41 | |||
186996 | 178488 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 216 Athens St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6004592.75442 | 2092017.76404 | 37.7245425498726 | -122.426276208897 | (37.7245425498726, -122.426276208897) | 9 | 7 | 6 | 28861 | 5 | |||
186949 | 235165 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1014 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6001904.70664 | 2101086.8276 | 37.7492917910042 | -122.43621713584 | (37.7492917910042, -122.43621713584) | 2 | 4 | 5 | 28862 | 22 | |||
186928 | 234147 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3652 23rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 6ft | 6005333.49326 | 2102564.26655 | 37.7535427109477 | -122.424465388893 | (37.7535427109477, -122.424465388893) | 2 | 4 | 5 | 28859 | 19 | |||
186893 | 115317 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3358 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 4x6 | 5998706.34805 | 2115938.71807 | 37.78988907048 | -122.448346448755 | (37.78988907048, -122.448346448755) | 13 | 6 | 1 | 54 | 31 | |||
186861 | 132694 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 501 Webster St | 3 | : | Tree | Private 2 | 10 | Width 4ft | 6004042.51589 | 2110539.70142 | 37.775368350495 | -122.429498598488 | (37.775368350495, -122.429498598488) | 7 | 9 | 11 | 29492 | 10 | |||
186854 | 132795 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2655 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6002050.88074 | 2116023.82356 | 37.7903133930914 | -122.436780782326 | (37.7903133930914, -122.436780782326) | 13 | 6 | 1 | 29490 | 27 | |||
186745 | 235048 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 480 Collingwood St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 10ft | 6002120.23299 | 2103061.59327 | 37.7547262700185 | -122.435613101668 | (37.7547262700185, -122.435613101668) | 2 | 4 | 5 | 28862 | 22 | |||
186722 | 124696 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 460 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5995622.5625 | 2113043.32898 | 37.7817623224133 | -122.458806288627 | (37.7817623224133, -122.458806288627) | 11 | 6 | 1 | 54 | 31 | |||
186684 | 31406 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 4252 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/1995 12:00:00 AM | Permit Number 34996 | 6002267.38577041 | 2104152.65784175 | 37.7577304284064 | -122.435182242399 | (37.7577304284064, -122.435182242399) | 2 | 4 | 5 | 28862 | 3 | ||
186606 | 248366 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1335 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5999499.0146 | 2108169.9437 | 37.7686033012576 | -122.445045174599 | (37.7686033012576, -122.445045174599) | 15 | 5 | 11 | 29492 | 9 | |||
186580 | 121906 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 316 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5990598.80386 | 2113270.73237 | 37.7820966692338 | -122.476202570147 | (37.7820966692338, -122.476202570147) | 11 | 6 | 2 | 54 | 26 | |||
186537 | 211537 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1418 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5991818.33086 | 2105743.17147 | 37.7614986623468 | -122.47143493159 | (37.7614986623468, -122.47143493159) | 1 | 8 | 4 | 56 | 12 | |||
186513 | 249395 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 350 Turk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6008316.3669 | 2113141.89457 | 37.7827544051414 | -122.414898517856 | (37.7827544051414, -122.414898517856) | 7 | 10 | 9 | 28852 | 36 | |||
186486 | 140000 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 510 FULTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6005286.9724 | 2111680.715 | 37.7785716764961 | -122.425274941179 | (37.7785716764961, -122.425274941179) | 7 | 9 | 11 | 28852 | 41 | |||
186474 | 96940 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 20 Palm Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 5995905.63365 | 2114340.32565 | 37.7853397953414 | -122.457920888412 | (37.7853397953414, -122.457920888412) | 11 | 6 | 1 | 54 | 31 | |||
186472 | 142347 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 740 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 29 | Width 0ft | 5999262.0717 | 2110178.0864 | 37.7741036250478 | -122.44600919318 | (37.7741036250478, -122.44600919318) | 15 | 5 | 11 | 29492 | 16 | |||
186461 | 132859 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 262 Presidio Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5999065.86079 | 2115677.64772 | 37.7891927874745 | -122.447083776301 | (37.7891927874745, -122.447083776301) | 13 | 6 | 1 | 29490 | 31 | |||
186410 | 140586 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1275 MCALLISTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | Width 0ft | 6003103.6642 | 2111676.6433 | 37.7784369089262 | -122.432827542094 | (37.7784369089262, -122.432827542094) | 15 | 9 | 11 | 29492 | 41 | |||
186387 | 132829 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2915 Sacramento St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 6000852.00656 | 2115534.41199 | 37.7889013882227 | -122.440893668013 | (37.7889013882227, -122.440893668013) | 13 | 6 | 1 | 29490 | 27 | |||
186378 | 15379 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1980 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6006767.6479 | 2106864.0633 | 37.7654298386751 | -122.419810840636 | (37.7654298386751, -122.419810840636) | 8 | 4 | 7 | 28853 | 19 | |||
186368 | 236116 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 139 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003320.47554 | 2108734.91383 | 37.7703719402379 | -122.431867407359 | (37.7703719402379, -122.431867407359) | 15 | 9 | 5 | 29492 | 9 | |||
186330 | 116027 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1425 Vallejo St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6006741.74979 | 2118359.37701 | 37.7969917163373 | -122.420716549646 | (37.7969917163373, -122.420716549646) | 13 | 9 | 10 | 28858 | 32 | |||
186293 | 140587 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1275 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | Width 0ft | 6003083.651 | 2111672.1959 | 37.7784235623758 | -122.432896457414 | (37.7784235623758, -122.432896457414) | 15 | 9 | 11 | 29492 | 41 | |||
186264 | 132865 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2227 Baker St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5999785.27194 | 2116584.67954 | 37.7917243358653 | -122.44465993073 | (37.7917243358653, -122.44465993073) | 13 | 6 | 1 | 29490 | 27 | |||
186243 | 235150 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 120 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 6006136.83851 | 2102157.73682 | 37.7524718072504 | -122.421658370061 | (37.7524718072504, -122.421658370061) | 2 | 4 | 5 | 28859 | 19 | |||
186206 | 103529 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 23 Ervine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 6009696.39175 | 2089318.75297 | 37.7174187879145 | -122.408443235483 | (37.7174187879145, -122.408443235483) | 9 | 7 | 8 | 309 | 39 | ||||
186182 | 211659 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 50 Brompton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6002155.33514 | 2095516.95183 | 37.7340124479116 | -122.43495217012 | (37.7340124479116, -122.43495217012) | 2 | 7 | 5 | 63 | 7 | |||
186162 | 140402 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1428 STEINER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6002746.0543 | 2113190.5801 | 37.7825735103842 | -122.434172904782 | (37.7825735103842, -122.434172904782) | 15 | 9 | 11 | 29490 | 41 | |||
186139 | 194998 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 11 Dedman Ct | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6016853.52358 | 2096150.44507 | 37.7365754887703 | -122.384179601306 | (37.7365754887703, -122.384179601306) | 10 | 3 | 8 | 58 | 1 | |||
186135 | 216033 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 4 Lobos St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/05/2017 03:13:00 PM | 3 | 5996833.19651 | 2088697.53049 | 37.7149843051513 | -122.452860296276 | (37.7149843051513, -122.452860296276) | 9 | 8 | 6 | 28861 | 24 | |||
186125 | 98780 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 3601X Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003551.8 | 2121073.9 | 37.8042647862028 | -122.431948468614 | (37.8042647862028, -122.431948468614) | 13 | 9 | 1 | 57 | 17 | ||||
186041 | 49724 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1300@ REVERE Griffith St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2003 12:00:00 AM | Permit Number 46533 | 6017891.63282432 | 2092647.03396297 | 37.727013150708 | -122.380346965446 | (37.727013150708, -122.380346965446) | 10 | 3 | 8 | 58 | 1 | |||
186037 | 133089 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1356 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6006395.42779 | 2119748.75054 | 37.8007870595214 | -122.422013658897 | (37.8007870595214, -122.422013658897) | 13 | 9 | 1 | 28858 | 32 | |||
186035 | 7906 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1200X Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4x4 | 6006011.4004 | 2114196.65348 | 37.7855207268899 | -122.422947727566 | (37.7855207268899, -122.422947727566) | 13 | 9 | 11 | 28858 | 41 | |||
185971 | 52533 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1314 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48632 | 5999791.20217858 | 2113405.47112998 | 37.7829953971352 | -122.444410832869 | (37.7829953971352, -122.444410832869) | 15 | 6 | 1 | 29490 | 31 | ||
185937 | 33306 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1200 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | 9 | 3x3 | Permit Number 37455 | 6009009.17627 | 2117059.26333 | 37.7935494569054 | -122.41277871867 | (37.7935494569054, -122.41277871867) | 3 | 1 | 10 | 28857 | 21 |
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) );