trees
1,746 rows where qSpecies_id = 10 sorted by SiteOrder
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3541 | 258357 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 446 Silliman St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x5 | 6009476.28698 | 2093953.76582 | 37.7301332328809 | -122.409530983744 | (37.7301332328809, -122.409530983744) | 9 | 3 | 7 | 309 | 28 | |||
| 3994 | 256688 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1477 Green St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782620 | |||||||||||
| 4980 | 86291 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1339 25th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/05/2006 12:00:00 AM | 3 | 3x3 | 5988318.888394 | 2106196.850699 | 37.7625412799726 | -122.483571174333 | (37.7625412799726, -122.483571174333) | 1 | 8 | 3 | 56 | 35 | |||
| 9576 | 258366 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 816 Silliman St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6008411.83681 | 2093627.45022 | 37.7291775379757 | -122.413187871426 | (37.7291775379757, -122.413187871426) | 9 | 3 | 7 | 309 | 28 | ||||
| 63697 | 256906 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 2821 37th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/03/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782747 | 5984938.23332 | 2096099.36709 | 37.7346189965322 | -122.4945190539 | (37.7346189965322, -122.4945190539) | 1 | 8 | 3 | 29491 | 35 | |
| 65950 | 108732 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1690 12th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774636 | 5992500.063 | 2103959.44689 | 37.756640436376 | -122.4689473104 | (37.756640436376, -122.4689473104) | 1 | 8 | 4 | 56 | 12 | |
| 132585 | 108666 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 687 45th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774612 | 5981944.00662 | 2111079.67768 | 37.7755749935311 | -122.505981228635 | (37.7755749935311, -122.505981228635) | 11 | 6 | 2 | 55 | 26 | |
| 150987 | 256775 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1286 Church St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/12/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782699 | 6004470.55425 | 2101402.67245 | 37.7503044754011 | -122.427366878539 | (37.7503044754011, -122.427366878539) | 2 | 4 | 5 | 28862 | 22 | |
| 13 | 264822 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2 Harkness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2020 12:00:00 AM | 3 | 4x6 | ||||||||||||
| 47 | 264965 | Undocumented 4 | Melaleuca quinquenervia :: Cajeput 10 | 951 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994993 | 2090257 | 37.7191606150529 | -122.45933361899 | (37.7191606150529, -122.45933361899) | 9 | 8 | 6 | 28861 | 24 | ||||
| 237 | 15807 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 4959 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/1995 12:00:00 AM | 6 | 3X3 | 6000887.014 | 2090089.1979 | 37.7190369816005 | -122.438948290663 | (37.7190369816005, -122.438948290663) | 9 | 7 | 6 | 28861 | 5 | ||
| 272 | 232035 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 39 Scott St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6002379.25876 | 2108512.04182 | 37.769706587622 | -122.435107129612 | (37.769706587622, -122.435107129612) | 15 | 5 | 5 | 29492 | 9 | |||
| 341 | 232113 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 533 Ellsworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/1991 12:00:00 AM | 24 | 4x4 | Permit Number 29534 | 6008027.37409 | 2096368.31937 | 37.7366817787289 | -122.414710885994 | (37.7366817787289, -122.414710885994) | 2 | 7 | 7 | 28859 | 2 | |
| 607 | 34245 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 778 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1997 12:00:00 AM | 8 | Permit Number 38055 | 6011531.92576 | 2104772.40188 | 37.7599538473986 | -122.403185056849 | (37.7599538473986, -122.403185056849) | 10 | 3 | 8 | 28856 | 29 | |
| 619 | 177547 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1202 Sunnydale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 6008380.57452 | 2087049.08192 | 37.7111129665536 | -122.412831047535 | (37.7111129665536, -122.412831047535) | 9 | 7 | 8 | 309 | 39 | |||
| 677 | 144274 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 668 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2020 12:00:00 AM | 3 | Width 3ft | 5981986.54358 | 2111243.64346 | 37.77602769926 | -122.505846244117 | (37.77602769926, -122.505846244117) | 11 | 6 | 2 | 55 | 26 | ||
| 1306 | 78279 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 773 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 16 | 6001349.14865 | 2092521.0021 | 37.7257404495571 | -122.437524926331 | (37.7257404495571, -122.437524926331) | 9 | 7 | 6 | 28861 | 25 | |||
| 1352 | 9226 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 6332 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5987316.8892 | 2112613.5319 | 37.7801013217352 | -122.487508066232 | (37.7801013217352, -122.487508066232) | 11 | 6 | 2 | 55 | 26 | |||
| 1540 | 57965 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 211 Lowell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/1977 12:00:00 AM | 20 | Permit Number 16925 | 5998963.22576 | 2086714.9374 | 37.7096623843901 | -122.445355572527 | (37.7096623843901, -122.445355572527) | 9 | 7 | 6 | 28861 | 5 | ||
| 1570 | 172003 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 440 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 0 | 4x5 | 6009403.11273 | 2093936.36515 | 37.7300813538655 | -122.409782729785 | (37.7300813538655, -122.409782729785) | 9 | 3 | 7 | 309 | 28 | ||
| 1711 | 261518 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 515 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2020 12:00:00 AM | Width 3ft | 5982833.25943 | 2112233.81526 | 37.7787962221578 | -122.50299059962 | (37.7787962221578, -122.50299059962) | 11 | 6 | 2 | 55 | 26 | |||
| 2048 | 232098 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 4430 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6000426.80036 | 2101707.41736 | 37.750911701116 | -122.441372274626 | (37.750911701116, -122.441372274626) | 2 | 4 | 5 | 28862 | 22 | |||
| 2320 | 232087 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 799X Jarboe Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6008934.61347 | 2096926.28751 | 37.7382647699126 | -122.411613566035 | (37.7382647699126, -122.411613566035) | 10 | 7 | 7 | 28859 | 2 | |||
| 2441 | 37478 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1375 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/09/2011 12:00:00 AM | 3x3 | Permit Number 767462 | 5991110.32977564 | 2106057.84846708 | 37.7623216986727 | -122.473906549358 | (37.7623216986727, -122.473906549358) | 1 | 8 | 11 | 56 | 12 | |
| 2494 | 261129 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 158 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2019 12:00:00 AM | 3 | Width 4ft | 6002797 | 2092771 | 37.7265090986579 | -122.432537667232 | (37.7265090986579, -122.432537667232) | 9 | 7 | 6 | 28861 | 5 | ||
| 2587 | 62602 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 790 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1986 12:00:00 AM | 7 | Permit Number 22910 | 5984500.58062 | 2110524.76974 | 37.774201531153 | -122.49709658414 | (37.774201531153, -122.49709658414) | 11 | 6 | 2 | 55 | 26 | |
| 2675 | 78240 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 783 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15 | 6001313.10029 | 2092436.35435 | 37.7255059765042 | -122.43764348307 | (37.7255059765042, -122.43764348307) | 9 | 7 | 6 | 28861 | 25 | |||
| 2886 | 78623 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 440 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6008334.45492 | 2113493.19738 | 37.7837200144185 | -122.414860811987 | (37.7837200144185, -122.414860811987) | 7 | 10 | 9 | 28858 | 36 | |||
| 3316 | 40992 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1300 Illinois St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/04/2005 12:00:00 AM | Permit Number 41816 | 6016132.48160546 | 2103021.5500289 | 37.7554022327395 | -122.387151692888 | (37.7554022327395, -122.387151692888) | 10 | 3 | 8 | 28856 | 29 | ||
| 3466 | 42606 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1450 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | 24 | Permit Number 42674 | 6006095.71991 | 2118663.62857 | 37.7977906821616 | -122.422973606963 | (37.7977906821616, -122.422973606963) | 13 | 9 | 10 | 28858 | 32 | |
| 3487 | 60052 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1427 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/1982 12:00:00 AM | 5 | Permit Number 19551 | 5988338.7048 | 2105586.102 | 37.76086548376 | -122.483457861607 | (37.76086548376, -122.483457861607) | 1 | 8 | 3 | 56 | 35 | |
| 4174 | 15791 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 4859 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/1995 12:00:00 AM | 7 | 3x3 | 6001243.5294 | 2090654.0842 | 37.7206083103718 | -122.437756393358 | (37.7206083103718, -122.437756393358) | 9 | 7 | 6 | 28861 | 5 | ||
| 4513 | 232122 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 310 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6006779.43206 | 2096281.21774 | 37.736372421849 | -122.419019394955 | (37.736372421849, -122.419019394955) | 2 | 7 | 7 | 28859 | 2 | |||
| 4719 | 144225 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 790 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2020 12:00:00 AM | 3 | Width 4ft | 5982634.037 | 2110415.4626 | 37.7737918452551 | -122.503545088531 | (37.7737918452551, -122.503545088531) | 11 | 6 | 2 | 55 | 26 | ||
| 5163 | 210196 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 163 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5998996.17044 | 2093773.42837 | 37.7290452611288 | -122.445748991746 | (37.7290452611288, -122.445748991746) | 9 | 7 | 4 | 28861 | 40 | |||
| 5208 | 193661 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1744 Oakdale Ave | 1 | : | Tree | Private 2 | 12 | Width 3ft | 6014300.46707 | 2096063.18282 | 37.7361943965519 | -122.393000575541 | (37.7361943965519, -122.393000575541) | 10 | 3 | 8 | 58 | 1 | |||
| 5355 | 232084 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 103 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006751.33512 | 2096933.55244 | 37.7381620061748 | -122.419162796319 | (37.7381620061748, -122.419162796319) | 2 | 7 | 7 | 28859 | 2 | |||
| 5528 | 167133 | Section 806 (d) 5 | Melaleuca quinquenervia :: Cajeput 10 | 4564 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/2019 12:00:00 AM | 3 | 3x5 | Permit Number 785333 | 6000784.60188 | 2104670.73247 | 37.7590686222364 | -122.440347461192 | (37.7590686222364, -122.440347461192) | 2 | 4 | 5 | 28862 | 3 | |
| 5942 | 37366 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 125 Street | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1998 12:00:00 AM | Permit Number 39871 | |||||||||||||
| 6490 | 177577 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 522 Bowdoin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008754 | 2093563 | 37.7290197747964 | -122.412000427453 | (37.7290197747964, -122.412000427453) | 9 | 3 | 7 | 309 | 28 | |||
| 6537 | 261310 | Undocumented 4 | Melaleuca quinquenervia :: Cajeput 10 | 1751 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5987774 | 2103374 | 37.7547587692818 | -122.485248582837 | (37.7547587692818, -122.485248582837) | 1 | 8 | 3 | 56 | 35 | ||||
| 6785 | 255190 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 201 Burrows St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 6997 | 210163 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 855 Niagara Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5997165.58678 | 2090928.28629 | 37.7211284832657 | -122.451872256998 | (37.7211284832657, -122.451872256998) | 9 | 8 | 6 | 28861 | 24 | |||
| 7055 | 159208 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 210 Foote Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 08:54:00 AM | 3 | Width 0ft | 5998556.96811 | 2088452.26068 | 37.7144094800835 | -122.446884596259 | (37.7144094800835, -122.446884596259) | 9 | 7 | 6 | 28861 | 25 | ||
| 7061 | 259664 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1850 36th Ave | 1 | Median : Cutout | Tree | Private 2 | 3x3 | 5985092 | 2102600 | 37.7524769742467 | -122.494466484126 | (37.7524769742467, -122.494466484126) | 1 | 8 | 3 | 56 | 35 | ||||
| 7159 | 33199 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 740 Laguna Honda Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1996 12:00:00 AM | Permit Number 37404 | 5995918.52562455 | 2099456.80293437 | 37.7444742187741 | -122.45679946352 | (37.7444742187741, -122.45679946352) | 1 | 5 | 4 | 59 | 40 | ||
| 7344 | 86404 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1739 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/19/2006 12:00:00 AM | 3 | 3x3 | 5988101.813015 | 2103468.563864 | 37.755037507379 | -122.484121863975 | (37.755037507379, -122.484121863975) | 1 | 8 | 3 | 56 | 35 | ||
| 8119 | 249075 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 89 Carr St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6013012 | 2090581 | 37.7210697875011 | -122.397071088995 | (37.7210697875011, -122.397071088995) | 10 | 3 | 8 | 58 | 1 | |||
| 8203 | 33351 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 156 Kenwood Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42327 | 5994316.91365045 | 2093552.57844974 | 37.7281705833725 | -122.461909418866 | (37.7281705833725, -122.461909418866) | 9 | 8 | 4 | 59 | 40 | ||
| 10083 | 232048 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 3678 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6005089.33487 | 2105475.94642 | 37.7615237093792 | -122.425516946371 | (37.7615237093792, -122.425516946371) | 8 | 4 | 5 | 28859 | 19 | |||
| 10246 | 73817 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 125 Morse St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6000831.98332 | 2087914.47159 | 37.7130625393704 | -122.438982739962 | (37.7130625393704, -122.438982739962) | 9 | 7 | 6 | 28861 | 5 | |||
| 10448 | 202192 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1928 Armstrong Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6013154.16149 | 2093432.67733 | 37.7289078285177 | -122.396779493476 | (37.7289078285177, -122.396779493476) | 10 | 3 | 8 | 58 | 1 | ||||
| 10809 | 82390 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1783 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6001502.3544 | 2112144.9743 | 37.7796318765871 | -122.438400625768 | (37.7796318765871, -122.438400625768) | 15 | 5 | 11 | 29490 | 41 | |||
| 10925 | 249073 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 78 Carr St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6012976.71638 | 2090666.07234 | 37.721301414799 | -122.397199017345 | (37.721301414799, -122.397199017345) | 10 | 3 | 8 | 58 | 1 | |||
| 10949 | 66447 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1717 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | 13 | Permit Number 32898 | 6009150.19031 | 2119198.20098 | 37.7994303674837 | -122.41244205838 | (37.7994303674837, -122.41244205838) | 3 | 1 | 10 | 308 | 32 | |
| 11121 | 78902 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1443 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 5989581.2299 | 2105525.1155 | 37.7607702705418 | -122.479156103143 | (37.7607702705418, -122.479156103143) | 1 | 8 | 3 | 56 | 35 | |||
| 11661 | 73117 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 170 Rome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 5998798.49436 | 2089027.53111 | 37.7160028368265 | -122.446091142417 | (37.7160028368265, -122.446091142417) | 9 | 7 | 6 | 28861 | 25 | |||
| 12220 | 43101 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 44 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/2000 12:00:00 AM | 14 | Permit Number 42932 | 6008904.81369 | 2112529.72749 | 37.7811065881247 | -122.412819439978 | (37.7811065881247, -122.412819439978) | 7 | 10 | 9 | 28852 | 36 | |
| 12256 | 78779 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 50 Farragut Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 5997572.00322 | 2087132.19247 | 37.7107285558476 | -122.450193916137 | (37.7107285558476, -122.450193916137) | 9 | 7 | 6 | 28861 | 25 | |||
| 12261 | 177534 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 502 Wayland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6010094.64304 | 2092221.19547 | 37.7254105881115 | -122.407271149051 | (37.7254105881115, -122.407271149051) | 10 | 3 | 7 | 309 | 28 | |||
| 12325 | 42608 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1775 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42675 | 6004555.83509625 | 2118398.4069888 | 37.796975439849 | -122.428283124742 | (37.796975439849, -122.428283124742) | 13 | 9 | 1 | 57 | 17 | ||
| 12383 | 118387 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 5640 Anza St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 5981104.69221 | 2111668.01683 | 37.7771409589636 | -122.508928263307 | (37.7771409589636, -122.508928263307) | 11 | 6 | 2 | 55 | 26 | |||
| 12563 | 46339 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 3724 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50545 | 6005683.95677825 | 2100834.56351367 | 37.7488131299105 | -122.423130469903 | (37.7488131299105, -122.423130469903) | 2 | 4 | 5 | 28859 | 19 | ||
| 12673 | 70698 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 591 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6003529.56495 | 2089763.19093 | 37.7182918362743 | -122.429790778347 | (37.7182918362743, -122.429790778347) | 9 | 7 | 6 | 28861 | 5 | |||
| 12912 | 50271 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 46 Saint Mary's Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/2003 12:00:00 AM | Permit Number 46975 | 6003961.77190842 | 2095882.86717576 | 37.7351195713487 | -122.428732836762 | (37.7351195713487, -122.428732836762) | 2 | 7 | 5 | 28861 | 7 | ||
| 13054 | 201281 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 38 Lydia Ave | 1 | : | Tree | Private 2 | 9 | Width 2ft | 6012822.1573 | 2092867.77977 | 37.7273382507444 | -122.397887653412 | (37.7273382507444, -122.397887653412) | 10 | 3 | 8 | 58 | 1 | |||
| 13119 | 42922 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | Permit Number 42829 | ||||||||||||||
| 13175 | 30752 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1507 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | 11 | 3x3 | Permit Number 34633 | 6015383.6793 | 2093790.5859 | 37.73001441519 | -122.389096804708 | (37.73001441519, -122.389096804708) | 10 | 3 | 8 | 58 | 1 |
| 13400 | 81931 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 234X Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6009287.21527 | 2113626.45246 | 37.7841393898643 | -122.411574026434 | (37.7841393898643, -122.411574026434) | 14 | 10 | 9 | 28852 | 36 | |||
| 13482 | 72809 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 118X Lowell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 3x3 | 5998733.92072 | 2087172.14442 | 37.7109046790814 | -122.446180954109 | (37.7109046790814, -122.446180954109) | 9 | 7 | 6 | 28861 | 5 | ||
| 13627 | 78732 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 53 Foote Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 5998972.2526 | 2087962.75673 | 37.7130891296288 | -122.44541403745 | (37.7130891296288, -122.44541403745) | 9 | 7 | 6 | 28861 | 25 | |||
| 13695 | 39699 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 360 Colon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41085 | 5995865.64470652 | 2094899.35552532 | 37.7319575477065 | -122.456652788497 | (37.7319575477065, -122.456652788497) | 9 | 7 | 4 | 59 | 40 | ||
| 13719 | 264662 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1070 Hollister Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/10/2020 12:00:00 AM | 3x3 | 6014517.40872 | 2089968.05117 | 37.7194704392608 | -122.391824453064 | (37.7194704392608, -122.391824453064) | 10 | 3 | 8 | 58 | 1 | |||
| 13782 | 50191 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 347 Richard Av | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/2003 12:00:00 AM | Permit Number 46897 | |||||||||||||
| 14095 | 262078 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1201 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6001148 | 2087377 | 37.7116047371551 | -122.437852010648 | (37.7116047371551, -122.437852010648) | 9 | 7 | 6 | 28861 | 5 | ||||
| 14298 | 18879 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2315 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/1998 12:00:00 AM | 3 | 3X3 | 6003607.44812 | 2115913.14135 | 37.790097828305 | -122.431387267427 | (37.790097828305, -122.431387267427) | 13 | 9 | 1 | 29490 | 27 | ||
| 14828 | 82804 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 46 Otsego Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6000854.60594 | 2092857.18319 | 37.7266353963958 | -122.4392586043 | (37.7266353963958, -122.4392586043) | 9 | 7 | 6 | 28861 | 25 | |||
| 15074 | 61794 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2112 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/24/1985 12:00:00 AM | 11 | Permit Number 21817 | 6012105.79225 | 2102838.47853 | 37.7546757515047 | -122.401064430306 | (37.7546757515047, -122.401064430306) | 10 | 3 | 8 | 28856 | 29 | |
| 15475 | 148112 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 509 Woolsey St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | 4x5 | 6010229.36415 | 2091734.22439 | 37.7240810061078 | -122.406771124199 | (37.7240810061078, -122.406771124199) | 10 | 3 | 7 | 309 | 28 | |||
| 16295 | 69167 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1357 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1994 12:00:00 AM | 8 | Permit Number 33204 | 5982738.1126 | 2105902.9753 | 37.7614079699737 | -122.502850971641 | (37.7614079699737, -122.502850971641) | 1 | 8 | 3 | 56 | 35 | |
| 16307 | 254265 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 85X Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778120 | ||||||||||
| 16397 | 200789 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1614 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6015325 | 2096036 | 37.7361766159661 | -122.389456416811 | (37.7361766159661, -122.389456416811) | 10 | 3 | 8 | 58 | 1 | |||
| 16512 | 72518 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1385 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 5999282.60736 | 2089782.01796 | 37.718102119793 | -122.444472018286 | (37.718102119793, -122.444472018286) | 9 | 7 | 6 | 28861 | 25 | |||
| 16625 | 259862 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1300x Brussels St | 1 | Side Yard : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
| 16910 | 85922 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1750 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/19/2006 12:00:00 AM | 3 | 3x3 | 5988150.1283 | 2103379.9075 | 37.7547968937654 | -122.483948277297 | (37.7547968937654, -122.483948277297) | 1 | 8 | 3 | 56 | 35 | ||
| 17329 | 42509 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 163 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42623 | 5999007.81241244 | 2093762.41150779 | 37.7290156761066 | -122.445707952741 | (37.7290156761066, -122.445707952741) | 9 | 7 | 4 | 28861 | 40 | ||
| 17795 | 144230 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 696 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2020 12:47:00 PM | 0 | Width 4ft | 5982610.26029 | 2111073.90375 | 37.7755983350405 | -122.503676106264 | (37.7755983350405, -122.503676106264) | 11 | 6 | 2 | 55 | 26 | ||
| 17891 | 201310 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 9 Lydia Ave | 1 | : | Tree | Private 2 | 5 | Width 2ft | 6012935.48709 | 2092735.05755 | 37.7269801335046 | -122.397486565679 | (37.7269801335046, -122.397486565679) | 10 | 3 | 8 | 58 | 1 | |||
| 18315 | 261539 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 723 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2020 12:00:00 AM | 3 | Width 4ft | 5981936 | 2110809 | 37.7748313206063 | -122.505988851899 | (37.7748313206063, -122.505988851899) | 11 | 6 | 2 | 55 | 26 | ||
| 18390 | 78903 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2078 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5989460.8159 | 2101226.1598 | 37.7489594901873 | -122.479258062134 | (37.7489594901873, -122.479258062134) | 1 | 8 | 3 | 29491 | 35 | |||
| 18586 | 1979 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 96 Bertha Ln | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/17/1995 12:00:00 AM | 6 | 3X4 | 6017818.3743209 | 2094812.8777717 | 37.7329560922326 | -122.380750713036 | (37.7329560922326, -122.380750713036) | 10 | 3 | 8 | 58 | 1 | ||
| 18688 | 70201 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1811 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 5987499.4352 | 2102910.1581 | 37.7534691863201 | -122.486164042507 | (37.7534691863201, -122.486164042507) | 1 | 8 | 3 | 56 | 35 | |||
| 18691 | 78242 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 767 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6001367.70534 | 2092560.86013 | 37.725850945661 | -122.437463630336 | (37.725850945661, -122.437463630336) | 9 | 7 | 6 | 28861 | 25 | |||
| 18708 | 74162 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1450 Santiago St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5988352.2909 | 2099691.0788 | 37.7446801201935 | -122.482978806105 | (37.7446801201935, -122.482978806105) | 1 | 8 | 3 | 29491 | 35 | |||
| 18912 | 85921 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1758 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/19/2006 12:00:00 AM | 3 | 3x3 | 5988172 | 2103340 | 37.7546885917873 | -122.483869713816 | (37.7546885917873, -122.483869713816) | 1 | 8 | 3 | 56 | 35 | ||
| 19473 | 261023 | Undocumented 4 | Melaleuca quinquenervia :: Cajeput 10 | 631 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2019 12:00:00 AM | 3x3 | 5985931 | 2111585 | 37.7771963436428 | -122.492226661995 | (37.7771963436428, -122.492226661995) | 11 | 6 | 2 | 55 | 26 | |||
| 19508 | 262456 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 784 Cayuga Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 02/09/2019 12:00:00 AM | 3 | 6001253 | 2092432 | 37.7254906030662 | -122.437850932396 | (37.7254906030662, -122.437850932396) | 9 | 7 | 6 | 28861 | 25 | ||
| 19648 | 114286 | Undocumented 4 | Melaleuca quinquenervia :: Cajeput 10 | 1801X 16TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x4 | 5991146 | 2103109 | 37.7542270070727 | -122.473568070103 | (37.7542270070727, -122.473568070103) | 1 | 8 | 4 | 56 | 12 | ||||
| 19954 | 86412 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1837X 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/19/2006 12:00:00 AM | 3 | 3x3 | 5988124.549971 | 2102801.454812 | 37.7532071291716 | -122.483994317971 | (37.7532071291716, -122.483994317971) | 1 | 8 | 3 | 56 | 35 | ||
| 19965 | 42912 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 2624 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | Permit Number 42823 | 6010365.23344045 | 2103432.32493154 | 37.756209071018 | -122.40712563844 | (37.756209071018, -122.40712563844) | 10 | 4 | 7 | 28859 | 19 |
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) );