Street_Tree_List

Data source: data.sfgov.org

856 rows where qSpecies = 97 sorted by qSiteInfo

View and edit SQL

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo ▼ PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
16138 14974 Permitted Site 1 Ceratonia siliqua :: Carob 97 400X Mendell St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Fire Dept 11     12 3X3   6016589.22096 2097595.13367 37.7405276953073 -122.385194050084 (37.7405276953073, -122.385194050084)
16340 17417 Permitted Site 1 Ceratonia siliqua :: Carob 97 1836 Palou Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6013526.86611 2096296.9772700001 37.7367933450374 -122.39569162676099 (37.7367933450374, -122.395691626761)
16423 2503 DPW Maintained 3 Ceratonia siliqua :: Carob 97 1500 Burke Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6016672.43224 2098847.72364 37.743971655361705 -122.384993582204 (37.7439716553617, -122.384993582204)
16483 16521 DPW Maintained 3 Ceratonia siliqua :: Carob 97 375 Newhall St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6016284.3157 2098184.69928 37.742129650455205 -122.38628939735099 (37.7421296504552, -122.386289397351)
16723 2498 DPW Maintained 3 Ceratonia siliqua :: Carob 97 1500 Burke Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6016761.82696 2098799.8032400003 37.7438450200413 -122.384681135251 (37.7438450200413, -122.384681135251)
16790 16509 DPW Maintained 3 Ceratonia siliqua :: Carob 97 325 Newhall St 11 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/03/1992 12:00:00 AM 3 3X3   6016661.92107 2098301.48789 37.742471221974 -122.384991878867 (37.742471221974, -122.384991878867)
16852 16499 DPW Maintained 3 Ceratonia siliqua :: Carob 97 325 Newhall St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6016428.13466 2098327.93774 37.7425309135822 -122.385802093385 (37.7425309135822, -122.385802093385)
16898 2502 DPW Maintained 3 Ceratonia siliqua :: Carob 97 1500 Burke Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6016691.633780001 2098834.3481 37.743935990943996 -122.38492625536001 (37.743935990944, -122.38492625536)
16941 16644 Permitted Site 1 Ceratonia siliqua :: Carob 97 170 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4X4   6002849.247169999 2107272.65524 37.7663302115978 -122.433392876987 (37.7663302115978, -122.433392876987)
16981 16634 DPW Maintained 3 Ceratonia siliqua :: Carob 97 158 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4X4   6002846.26234 2107315.61995 37.7664480128774 -122.43340627149901 (37.7664480128774, -122.433406271499)
17478 5658 DPW Maintained 3 Ceratonia siliqua :: Carob 97 1349-1349 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     100 3X3   6005239.88286 2100530.07402 37.74795200168529 -122.42464442051 (37.7479520016853, -122.42464442051)
18276 16647 Permitted Site 1 Ceratonia siliqua :: Carob 97 178 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/04/2015 12:00:00 AM 14 4x4   6002850.6051900005 2107244.6681 37.7662534427777 -122.433386179722 (37.7662534427777, -122.433386179722)
18731 5529 DPW Maintained 3 Ceratonia siliqua :: Carob 97 895 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     100 4X4   6005093.86648 2103161.8218799997 37.7551699235695 -122.425336590916 (37.7551699235695, -122.425336590916)
18910 21791 Permitted Site 1 Ceratonia siliqua :: Carob 97 2585 Taylor St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 4X4   6008347.28278 2121527.17705 37.8057800612465 -122.41538537817499 (37.8057800612465, -122.415385378175)
19409 16623 DPW Maintained 3 Ceratonia siliqua :: Carob 97 136 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   6002840.1476308 2107468.9628395 37.7668687081336 -122.433438380285 (37.7668687081336, -122.433438380285)
20318 5479 DPW Maintained 3 Ceratonia siliqua :: Carob 97 695 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     20 8   6005031.79334 2104320.1538400003 37.758346924379 -122.42563369543801 (37.758346924379, -122.425633695438)
20488 82142 Permitted Site 1 Ceratonia siliqua :: Carob 97 30 Molimo Dr 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/25/2007 12:00:00 AM   3x3 Permit Number 49838 5998889.06181671 2096571.98929044 37.736723332936 -122.446320512355 (37.736723332936, -122.446320512355)
20496 97187 Undocumented 2 Ceratonia siliqua :: Carob 97 10X Fremont St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 3x3   6013222.5 2116242.1 37.7915413037038 -122.398142826086 (37.7915413037038, -122.398142826086)
20514 5432 Permitted Site 1 Ceratonia siliqua :: Carob 97 499 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     36 3X3   6004968.151269999 2105494.35348 37.761567402922296 -122.42593738121799 (37.7615674029223, -122.425937381218)
21055 5523 DPW Maintained 3 Ceratonia siliqua :: Carob 97 865 Dolores St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     50 3X3   6005084.41522 2103351.40166 37.755689931362795 -122.425382766602 (37.7556899313628, -122.425382766602)
22312 3652 Permitted Site 1 Ceratonia siliqua :: Carob 97 100X Cargo Way 88 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   03/07/2006 12:00:00 AM 3 3X3   6017348.88964 2098746.4497 37.7437309716031 -122.38264747761299 (37.7437309716031, -122.382647477613)
22318 3611 Private 5 Ceratonia siliqua :: Carob 97 100X Cargo Way 47 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   05/31/1996 12:00:00 AM 3 3X3   6018038.2961099995 2098194.83807 37.7422544187983 -122.380225323637 (37.7422544187983, -122.380225323637)
22336 3627 Permitted Site 1 Ceratonia siliqua :: Carob 97 100X Cargo Way 63 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   04/06/2016 12:00:00 AM 3 3X3   6017747.14415 2098409.63099 37.7428281287262 -122.381246979566 (37.7428281287262, -122.381246979566)
22344 3639 Private 5 Ceratonia siliqua :: Carob 97 100X Cargo Way 75 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   03/07/2006 12:00:00 AM 3 3X3   6017551.66161 2098562.89956 37.743238180001995 -122.381933568796 (37.743238180002, -122.381933568796)
23044 16540 DPW Maintained 3 Ceratonia siliqua :: Carob 97 400X Newhall St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     5 0   6016126.25571 2098060.8881 37.741780940152296 -122.386827291768 (37.7417809401523, -122.386827291768)
23049 14686 DPW Maintained 3 Ceratonia siliqua :: Carob 97 775 McAllister St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     16 4X4   6005447.7824 2111997.5051 37.779450588232706 -122.424741179621 (37.7794505882327, -122.424741179621)
23084 16626 DPW Maintained 3 Ceratonia siliqua :: Carob 97 138 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/02/2001 12:00:00 AM 21 3X3   6002836.08721 2107485.6498 37.7669142960875 -122.43345361721 (37.7669142960875, -122.43345361721)
23256 3593 Private 5 Ceratonia siliqua :: Carob 97 100X Cargo Way 29 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   04/06/2016 12:00:00 AM 7 3X3   6018341.35218 2097966.95491 37.7416454132021 -122.379161613636 (37.7416454132021, -122.379161613636)
23379 222925 Undocumented 2 Ceratonia siliqua :: Carob 97 1025 Clayton St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 4ft   5998825.08997 2106348.09575 37.763562478748604 -122.44724507779499 (37.7635624787486, -122.447245077795)
23428 106029 Permitted Site 1 Ceratonia siliqua :: Carob 97 180 Howard St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/05/2015 12:00:00 AM 14 3x3 Permit Number 770222 6014636.89755 2115962.51686 37.790852311826704 -122.39322941879801 (37.7908523118267, -122.393229418798)
23796 189939 Undocumented 2 Ceratonia siliqua :: Carob 97 28 Fremont St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 5ft   6013302.110780001 2116136.01551 37.7912544544909 -122.397859927289 (37.7912544544909, -122.397859927289)
23831 126000 Undocumented 2 Ceratonia siliqua :: Carob 97 2510 Jones St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 4ft   6007902.73328 2121542.33791 37.805796693425705 -122.41692488738501 (37.8057966934257, -122.416924887385)
24342 225069 Undocumented 2 Ceratonia siliqua :: Carob 97 892 Alabama St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6009108.56559 2103972.85995 37.75762285142989 -122.41150982923 (37.7576228514299, -122.41150982923)
24544 189940 Undocumented 2 Ceratonia siliqua :: Carob 97 28 Fremont St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 5ft   6013316.29733 2116121.5529099996 37.791215533629 -122.39780982696001 (37.791215533629, -122.39780982696)
25032 189928 Undocumented 2 Ceratonia siliqua :: Carob 97 43 Fremont St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 5ft   6013312.71119 2116223.04908 37.79149401858479 -122.397829357532 (37.7914940185848, -122.397829357532)
25271 125991 Undocumented 2 Ceratonia siliqua :: Carob 97 2361 Taylor St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6008338.82398 2121554.9566599997 37.805855861614795 -122.41541661910699 (37.8058558616148, -122.415416619107)
25477 225086 Undocumented 2 Ceratonia siliqua :: Carob 97 3689 21st St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6003831.7176 2103603.4271 37.756311078698296 -122.429732966312 (37.7563110786983, -122.429732966312)
25551 138242 Undocumented 2 Ceratonia siliqua :: Carob 97 1509 Lyon St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 0ft   5999647.1063 2114070.9654 37.7848144491807 -122.444957199215 (37.7848144491807, -122.444957199215)
25691 140580 Undocumented 2 Ceratonia siliqua :: Carob 97 949 FILLMORE ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 0ft   6003403.4849 2111618.6108 37.778294566327205 -122.43178620552 (37.7782945663272, -122.43178620552)
25692 222915 Undocumented 2 Ceratonia siliqua :: Carob 97 100 Webster St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 4ft   6004287.81752 2109130.32918 37.7715124442731 -122.42854956011999 (37.7715124442731, -122.42854956012)
25981 47237 Permitted Site 1 Ceratonia siliqua :: Carob 97 1200X Fitzgerald Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/09/2002 12:00:00 AM 9 3x3 Permit Number 45189 6014656.8506 2090563.7281 37.721113790544 -122.391384069594 (37.721113790544, -122.391384069594)
26487 189910 DPW Maintained 3 Ceratonia siliqua :: Carob 97 350 Newhall St 11 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     14 Width 3ft   6016250.22154 2098227.10108 37.742244189916704 -122.386410241063 (37.7422441899167, -122.386410241063)
26761 175842 Undocumented 2 Ceratonia siliqua :: Carob 97 234 Vienna St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6004274.97667 2092050.6197400002 37.724614796925 -122.427377064513 (37.724614796925, -122.427377064513)
26990 222896 Undocumented 2 Ceratonia siliqua :: Carob 97 115 Julian Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 4ft   6006441.81181 2107164.43854 37.76623623692421 -122.420959163358 (37.7662362369242, -122.420959163358)
27151 189948 Undocumented 2 Ceratonia siliqua :: Carob 97 162 Spear St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 1ft   6014781.223780001 2116142.62721 37.79135487007321 -122.392742658052 (37.7913548700732, -122.392742658052)
27662 225079 Undocumented 2 Ceratonia siliqua :: Carob 97 2804 21st St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6009325.524119999 2103958.77383 37.7575963412133 -122.410758500511 (37.7575963412133, -122.410758500511)
27876 222922 Undocumented 2 Ceratonia siliqua :: Carob 97 848 Clayton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 4ft   5998725.13711 2107078.63003 37.7655626303238 -122.44764337315 (37.7655626303238, -122.44764337315)
27998 103976 Permitted Site 1 Ceratonia siliqua :: Carob 97 2440 Geary Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3x3   6000022.661 2113372.9775 37.7829193814773 -122.44360774817 (37.7829193814773, -122.44360774817)
28082 225072 Undocumented 2 Ceratonia siliqua :: Carob 97 902 Florida St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6009377.02442 2103868.3997 37.757351081704606 -122.41057400910299 (37.7573510817046, -122.410574009103)
28181 126002 Undocumented 2 Ceratonia siliqua :: Carob 97 2510 Jones St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 4ft   6007897.34981 2121579.9870599997 37.805899765629704 -122.41694618692699 (37.8058997656297, -122.416946186927)
28582 222901 Undocumented 2 Ceratonia siliqua :: Carob 97 2500 19th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 4ft   6010350.927680001 2105070.60578 37.760706622229705 -122.407290598708 (37.7607066222297, -122.407290598708)
28725 125974 Undocumented 2 Ceratonia siliqua :: Carob 97 633 Beach St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   6007013.058230001 2121870.81717 37.806648529474295 -122.42002707360399 (37.8066485294743, -122.420027073604)
30875 64436 Permitted Site 1 Ceratonia siliqua :: Carob 97 2445 Larkin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/16/1988 12:00:00 AM 12   Permit Number 25292 6006658.75135 2119650.10198 37.8005310432266 -122.421095439396 (37.8005310432266, -122.421095439396)
30923 188479 Undocumented 2 Ceratonia siliqua :: Carob 97 2208 Mariposa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6010817.79084 2106032.71885 37.763374486260204 -122.40574369103201 (37.7633744862602, -122.405743691032)
31183 61726 Permitted Site 1 Ceratonia siliqua :: Carob 97 28 Ceres St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/12/1985 12:00:00 AM 9   Permit Number 21728 6013869.02725 2093995.2493599998 37.7304922999628 -122.39434750633998 (37.7304922999628, -122.39434750634)
31280 189919 Undocumented 2 Ceratonia siliqua :: Carob 97 338 Mission St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   6013770.13743 2116011.13859 37.7909376251249 -122.396231800058 (37.7909376251249, -122.396231800058)
31832 222918 Undocumented 2 Ceratonia siliqua :: Carob 97 140 Carl St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   5997702.832359999 2107152.93734 37.7657081802151 -122.451184638974 (37.7657081802151, -122.451184638974)
32206 115845 Undocumented 2 Ceratonia siliqua :: Carob 97 1500 Bay St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 3x3   6003527.72894 2120738.7231400004 37.8033431135653 -122.432007819421 (37.8033431135653, -122.432007819421)
32238 175841 Undocumented 2 Ceratonia siliqua :: Carob 97 407 Paris St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 2ft   6002201.57312 2091201.22242 37.7221650589433 -122.434483841864 (37.7221650589433, -122.434483841864)
32281 225053 Undocumented 2 Ceratonia siliqua :: Carob 97 300 Sussex St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6001218.80684 2096592.16387 37.736911510559295 -122.438267032523 (37.7369115105593, -122.438267032523)
32338 248196 Undocumented 2 Ceratonia siliqua :: Carob 97 99 Lundy's Ln 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6006902.26536 2099037.70953 37.7439480508589 -122.41879013796101 (37.7439480508589, -122.418790137961)
32636 222888 Undocumented 2 Ceratonia siliqua :: Carob 97 109 Webster St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 4ft   6004218.0 2109157.0 37.771581724556604 -122.428792964354 (37.7715817245566, -122.428792964354)
32837 189922 Undocumented 2 Ceratonia siliqua :: Carob 97 45 Fremont St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 5ft   6013429.98555 2116100.18474 37.791163192164 -122.39741496705099 (37.791163192164, -122.397414967051)
33051 123914 Undocumented 2 Ceratonia siliqua :: Carob 97 389 09th Ave 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5993078.53663 2112857.8084299997 37.7811063777719 -122.467593853963 (37.7811063777719, -122.467593853963)
33356 248279 Undocumented 2 Ceratonia siliqua :: Carob 97 111 Lundy's Ln 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6006822.34586 2098891.67697 37.743542578041 -122.419056125953 (37.743542578041, -122.419056125953)
33365 93109 Permitted Site 1 Ceratonia siliqua :: Carob 97 300 Newhall St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/02/2010 12:00:00 AM 9 3x3 Permit Number 53024 6016621.354169999 2098362.60938 37.7426368051604 -122.385136406214 (37.7426368051604, -122.385136406214)
33581 222905 Undocumented 2 Ceratonia siliqua :: Carob 97 363 Page St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 4ft   6004739.789609999 2109820.49268 37.7734330328342 -122.427035328438 (37.7734330328342, -122.427035328438)
33594 244469 Undocumented 2 Ceratonia siliqua :: Carob 97 665 Page St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 0ft   6003415.8306 2109638.0930000003 37.7728572538387 -122.43160206502701 (37.7728572538387, -122.431602065027)
34084 206003 Undocumented 2 Ceratonia siliqua :: Carob 97 1593 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5991725.497880001 2104502.2556 37.7580860643266 -122.471665566325 (37.7580860643266, -122.471665566325)
34241 125971 Undocumented 2 Ceratonia siliqua :: Carob 97 100 Hyde St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19 Width 4ft   6008148.4886 2112831.1491900003 37.7818917385495 -122.415457300812 (37.7818917385495, -122.415457300812)
34932 222909 Undocumented 2 Ceratonia siliqua :: Carob 97 363 Page St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 4ft   6004826.79581 2109830.90843 37.7734665514719 -122.426735103265 (37.7734665514719, -122.426735103265)
35330 125967 Undocumented 2 Ceratonia siliqua :: Carob 97 3440 Clay St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 6ft   5998347.68841 2115559.3339299997 37.7888268704136 -122.449560024485 (37.7888268704136, -122.449560024485)
35349 189956 Undocumented 2 Ceratonia siliqua :: Carob 97 572 07th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6011467.9689 2109652.48068 37.773349868946205 -122.403749639528 (37.7733498689462, -122.403749639528)
35467 93114 Permitted Site 1 Ceratonia siliqua :: Carob 97 300 Newhall St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/02/2010 12:00:00 AM 6 3x3 Permit Number 53024 6016526.70747 2098382.7110900003 37.7426867642747 -122.385465070679 (37.7426867642747, -122.385465070679)
35568 225084 Undocumented 2 Ceratonia siliqua :: Carob 97 3784 22nd St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6003185.26448 2103031.00379 37.7547027131682 -122.43192775097401 (37.7547027131682, -122.431927750974)
35683 225082 Undocumented 2 Ceratonia siliqua :: Carob 97 543 Hill St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     22 Width 3ft   6002779.31526 2103257.0391599997 37.7553003306644 -122.433347783174 (37.7553003306644, -122.433347783174)
35726 222928 Undocumented 2 Ceratonia siliqua :: Carob 97 912 Clayton St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 4ft   5998758.16977 2106859.07637 37.764961679071796 -122.447513315894 (37.7649616790718, -122.447513315894)
36711 189929 Undocumented 2 Ceratonia siliqua :: Carob 97 43 Fremont St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 5ft   6013297.80377 2116238.25932 37.79153495213429 -122.39788200474399 (37.7915349521343, -122.397882004744)
37108 225085 Undocumented 2 Ceratonia siliqua :: Carob 97 406 Vicksburg St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 5ft   6004142.31119 2101495.14459 37.7505398125629 -122.42850855554701 (37.7505398125629, -122.428508555547)
37675 225057 Undocumented 2 Ceratonia siliqua :: Carob 97 360 Sussex St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 4ft   6001062.01743 2096696.77883 37.7371898399477 -122.438816616317 (37.7371898399477, -122.438816616317)
37728 225083 Undocumented 2 Ceratonia siliqua :: Carob 97 3782 22nd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6003229.02977 2103031.88331 37.7547076090931 -122.431776461616 (37.7547076090931, -122.431776461616)
37750 106035 Permitted Site 1 Ceratonia siliqua :: Carob 97 195X Main St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6014366.747719999 2116104.57878 37.7912273690908 -122.394174082061 (37.7912273690908, -122.394174082061)
37989 199692 Undocumented 2 Ceratonia siliqua :: Carob 97 1343 Thomas Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   6016085.8906 2092920.1706 37.7276633287451 -122.386608480998 (37.7276633287451, -122.386608480998)
38071 125966 Undocumented 2 Ceratonia siliqua :: Carob 97 2198 Filbert St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 4ft   6002473.45784 2118854.30827 37.7981091788388 -122.435521270088 (37.7981091788388, -122.435521270088)
38614 225070 Undocumented 2 Ceratonia siliqua :: Carob 97 890 Alabama St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 3ft   6009108.93583 2103990.9837700003 37.757672636103 -122.411509829221 (37.757672636103, -122.411509829221)
38805 139008 Undocumented 2 Ceratonia siliqua :: Carob 97 1504 Lyon St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 0ft   5999687.2486 2114098.7181 37.7848929418184 -122.444820316061 (37.7848929418184, -122.444820316061)
39112 140022 Undocumented 2 Ceratonia siliqua :: Carob 97 775 MCALLISTER ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 0ft   6005467.685 2112000.1843 37.7794590687234 -122.424672518677 (37.7794590687234, -122.424672518677)
39562 199697 Undocumented 2 Ceratonia siliqua :: Carob 97 1331 Thomas Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 0ft   6016182.8401 2092843.0517 37.7274569422187 -122.386267947878 (37.7274569422187, -122.386267947878)
39568 125980 Undocumented 2 Ceratonia siliqua :: Carob 97 2362 Taylor St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   6008387.31056 2121533.89692 37.8058007619722 -122.415247331605 (37.8058007619722, -122.415247331605)
39687 80561 Undocumented 2 Ceratonia siliqua :: Carob 97 1820X Palou Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/07/2002 12:00:00 AM 15     6013651.87309 2096197.8113799999 37.736528009043795 -122.395252475224 (37.7365280090438, -122.395252475224)
39980 30908 Permitted Site 1 Ceratonia siliqua :: Carob 97 1511 Lyon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/13/1995 12:00:00 AM 7   Permit Number 34730 5999634.2212 2114153.2322 37.7850395970423 -122.44500769339199 (37.7850395970423, -122.445007693392)
40106 248228 Undocumented 2 Ceratonia siliqua :: Carob 97 70 Lundy's Ln 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6006955.04848 2099184.3603 37.744353692775995 -122.41861802300501 (37.744353692776, -122.418618023005)
40687 57316 Permitted Site 1 Ceratonia siliqua :: Carob 97 1515 Lyon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/31/1976 12:00:00 AM 13   Permit Number 16140 5999629.2653 2114178.0114 37.7851073514303 -122.445026621162 (37.7851073514303, -122.445026621162)
40966 125985 Undocumented 2 Ceratonia siliqua :: Carob 97 2362 Taylor St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 6ft   6008371.27829 2121652.4837 37.8061254702907 -122.415311214049 (37.8061254702907, -122.415311214049)
41181 189938 Undocumented 2 Ceratonia siliqua :: Carob 97 28 Fremont St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 5ft   6013289.37156 2116149.2267400003 37.7912900199673 -122.39790493209101 (37.7912900199673, -122.397904932091)
41360 225095 Undocumented 2 Ceratonia siliqua :: Carob 97 231 Waller St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6004583.37564 2109107.4182 37.7714662577942 -122.427525575841 (37.7714662577942, -122.427525575841)
42068 205999 Undocumented 2 Ceratonia siliqua :: Carob 97 60 Chilton Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6001682.52176 2095686.8275900001 37.7344520302196 -122.436598984369 (37.7344520302196, -122.436598984369)
42092 115843 Undocumented 2 Ceratonia siliqua :: Carob 97 1500 Bay St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 3x3   6003556.384769999 2120742.54729 37.80335523820229 -122.431908928161 (37.8033552382023, -122.431908928161)
42255 189935 Undocumented 2 Ceratonia siliqua :: Carob 97 28 Fremont St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 5ft   6013248.49941 2116191.11402 37.791402756277 -122.398049289468 (37.791402756277, -122.398049289468)
42568 189927 Undocumented 2 Ceratonia siliqua :: Carob 97 43 Fremont St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 5ft   6013321.30985 2116211.3881900003 37.7914624793694 -122.39779878780001 (37.7914624793694, -122.3977987878)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 24.284ms · Data source: data.sfgov.org