trees
1,746 rows where qSpecies_id = 10 sorted by qCareAssistant
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||||||||||||
| 16 | 264823 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2 Harkness Ave | 2 | 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 | |
| 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 | |||
| 635 | 193701 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1455 Owen St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6013732.82197 | 2108340.14659 | 37.7698727553585 | -122.395823166124 | (37.7698727553585, -122.395823166124) | 14 | 3 | 9 | 310 | 20 | |||
| 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 | ||
| 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 | ||
| 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 | |||
| 1981 | 40499 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 44 Aptos Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/1999 12:00:00 AM | 3x3 | Permit Number 50329 | 5993102.74682774 | 2094714.88282209 | 37.7312920097199 | -122.466191234844 | (37.7312920097199, -122.466191234844) | 9 | 8 | 4 | 59 | 40 | ||
| 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 | |||
| 2058 | 193742 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 65 Whitney Young Cir | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6017172.83874 | 2094938.08011 | 37.7332642254487 | -122.382991229966 | (37.7332642254487, -122.382991229966) | 10 | 3 | 8 | 58 | 1 | |||
| 2240 | 131217 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 501 Jones St | 10 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 4ft | 6008903.544 | 2114366.06941 | 37.786148671371 | -122.412953707875 | (37.786148671371, -122.412953707875) | 5 | 10 | 9 | 28852 | 36 | |||
| 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 | |||
| 2493 | 232111 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 245 Ellsworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008091.47113 | 2097437.07299 | 37.7396199430135 | -122.414564880185 | (37.7396199430135, -122.414564880185) | 2 | 7 | 7 | 28859 | 2 | |||
| 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 | ||
| 2792 | 177566 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 601 Edinburgh St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6002531.79574 | 2090204.60346 | 37.7194473050295 | -122.433271165433 | (37.7194473050295, -122.433271165433) | 9 | 7 | 6 | 28861 | 5 | |||
| 4014 | 201331 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 95 Bitting Ave | 2 | : | Tree | Private 2 | 6 | Width 2ft | 6012535.62971 | 2092785.01018 | 37.7270950209928 | -122.398872378676 | (37.7270950209928, -122.398872378676) | 10 | 3 | 8 | 58 | 1 | |||
| 4057 | 201274 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 210 Kalmanovitz St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 2ft | 6013027.04362 | 2092751.29466 | 37.7270298147504 | -122.397171192319 | (37.7270298147504, -122.397171192319) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | ||
| 4311 | 39593 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 45 Southern Heights Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1998 12:00:00 AM | 4 | Permit Number 41001 | 6012273.08907 | 2104003.23751 | 37.7578832555154 | -122.400567684363 | (37.7578832555154, -122.400567684363) | 10 | 3 | 8 | 28856 | 29 | ||
| 4340 | 202223 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1 Kalmanovitz St | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6013174.84825 | 2093025.0903 | 37.7277898291129 | -122.396679416033 | (37.7277898291129, -122.396679416033) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 4677 | 104420 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 622 44th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 770538 | 5982306.9 | 2111497.7 | 37.7767441147601 | -122.504756894571 | (37.7767441147601, -122.504756894571) | 11 | 6 | 2 | 55 | 26 | ||||
| 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 | ||
| 4973 | 33381 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 2275 Ocean Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/14/1996 12:00:00 AM | Permit Number 37503 | 5992540.8715622 | 2093773.0831922 | 37.7286736277184 | -122.468065241412 | (37.7286736277184, -122.468065241412) | 9 | 8 | 4 | 59 | 40 | |||
| 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 | |||
| 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 | |
| 5561 | 232088 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 799X Jarboe Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6008920.8367 | 2096927.3321 | 37.7382668653192 | -122.411661273272 | (37.7382668653192, -122.411661273272) | 10 | 7 | 7 | 28859 | 2 | |||
| 5821 | 232036 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 50 Scott St | 6 | : | Tree | Private 2 | 7 | Width 3ft | 6002425.62423 | 2108559.69988 | 37.7698400775965 | -122.434950161914 | (37.7698400775965, -122.434950161914) | 15 | 5 | 5 | 29492 | 9 | |||
| 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 | |||||||||||||
| 6143 | 41891 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 401 Duboce Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2000 12:00:00 AM | Permit Number 42259 | 6004099.97108515 | 2108358.83625404 | 37.7693834800973 | -122.429144312501 | (37.7693834800973, -122.429144312501) | 7 | 9 | 5 | 28862 | 3 | |||
| 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 | ||||
| 6560 | 118741 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 616 44th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 4ft | 5982283.91795 | 2111534.27882 | 37.7768431974954 | -122.504839106088 | (37.7768431974954, -122.504839106088) | 11 | 6 | 2 | 55 | 26 | |||
| 6856 | 232051 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1901 Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 6009550.86588 | 2105758.75821 | 37.7625513224022 | -122.410106248314 | (37.7625513224022, -122.410106248314) | 8 | 4 | 8 | 28859 | 19 | |||
| 6912 | 193566 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1201 Illinois St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6016159.58282 | 2103474.73981 | 37.7566480969374 | -122.387089575435 | (37.7566480969374, -122.387089575435) | 10 | 3 | 8 | 28856 | 29 | |||
| 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 | |||
| 7032 | 202185 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1900 Armstrong Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6013201.16953 | 2093404.02127 | 37.7288317611548 | -122.396614974207 | (37.7288317611548, -122.396614974207) | 10 | 3 | 8 | 58 | 1 | ||||
| 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 | ||||
| 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 | ||
| 7386 | 200783 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1600 McKinnon Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6015393 | 2095982 | 37.7360321129218 | -122.389217541455 | (37.7360321129218, -122.389217541455) | 10 | 3 | 8 | 58 | 1 | |||
| 7532 | 9542 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1100X Golden Gate Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 03/31/2000 12:00:00 AM | 3 | 3X3 | 6003977.1107 | 2112193.8912 | 37.7799066435706 | -122.429842866574 | (37.7799066435706, -122.429842866574) | 7 | 9 | 11 | 29490 | 41 | ||
| 7608 | 232050 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1901 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | Permit Number 784558 | 6009552.80664 | 2105742.05683 | 37.7625055729985 | -122.410098356754 | (37.7625055729985, -122.410098356754) | 8 | 4 | 8 | 28859 | 19 | ||
| 8028 | 193730 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 210 Channel | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6014864.24714 | 2109891.31504 | 37.7741947972765 | -122.392018049996 | (37.7741947972765, -122.392018049996) | 14 | 3 | 9 | 310 | 20 | |||
| 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 | |||
| 8252 | 31364 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2295 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779235 | 5991014.76631 | 2099859.25307 | 37.745296448467 | -122.47378484391 | (37.745296448467, -122.47378484391) | 1 | 8 | 4 | 29491 | 40 | |
| 8733 | 193669 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 255 Terry A Francois Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6016408.23667 | 2108979.54137 | 37.7717768665387 | -122.386613473459 | (37.7717768665387, -122.386613473459) | 3 | 9 | 310 | 20 | ||||
| 8875 | 193652 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2141 Oakdale Ave | 2 | : | Tree | Private 2 | 8 | Width 3ft | 6012072.86393 | 2097652.92355 | 37.7404354977101 | -122.400814014067 | (37.7404354977101, -122.400814014067) | 10 | 3 | 8 | 58 | 1 | |||
| 9514 | 210132 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 360 Flood Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 4ft | 5998258.46267 | 2094123.67501 | 37.7299648080121 | -122.448324505273 | (37.7299648080121, -122.448324505273) | 9 | 7 | 4 | 28861 | 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 | |||
| 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 | ||||
| 10606 | 46465 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 2098 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2002 12:00:00 AM | Permit Number 44668 | 6002328.64862435 | 2119517.88465055 | 37.7999229605029 | -122.436069860968 | (37.7999229605029, -122.436069860968) | 13 | 9 | 1 | 57 | 17 | |||
| 10641 | 232039 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 50 Scott St | 12 | : | Tree | Private 2 | 9 | Width 3ft | 6002403.60195 | 2108716.39098 | 37.7702690623006 | -122.435037544552 | (37.7702690623006, -122.435037544552) | 15 | 5 | 5 | 29492 | 9 | |||
| 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 | |||
| 11091 | 210155 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 351 Judson Ave | 32 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 1ft | 5997888.33072 | 2093517.91432 | 37.728280364322 | -122.449560457971 | (37.728280364322, -122.449560457971) | 9 | 7 | 4 | 28861 | 40 | |||
| 11421 | 255616 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 334 San Carlos St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006694 | 2104159 | 37.7579982171346 | -122.419873605129 | (37.7579982171346, -122.419873605129) | 2 | 4 | 7 | 28859 | 19 | ||||
| 12130 | 210150 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 351 Judson Ave | 27 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 1ft | 5997817.44041 | 2093518.24047 | 37.7282772041107 | -122.44980555111 | (37.7282772041107, -122.44980555111) | 9 | 7 | 4 | 28861 | 40 | |||
| 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 | |||
| 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 | |||
| 12525 | 119938 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2500 Balboa St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5987749.91083 | 2111234.09886 | 37.7763390320182 | -122.485908787714 | (37.7763390320182, -122.485908787714) | 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 | ||
| 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 | |||
| 13092 | 261764 | Significant Tree 6 | Melaleuca quinquenervia :: Cajeput 10 | 130 Bartlett St | 2 | Front Yard : Cutout | Tree | Private 2 | 4x4 | 6006663 | 2102839 | 37.7543720553146 | -122.419887150249 | (37.7543720553146, -122.419887150249) | 2 | 4 | 7 | 28859 | 19 | ||||
| 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 | ||||||||||||||
| 13127 | 32202 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1600 Alabama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/1995 12:00:00 AM | 9 | 3x3 | Permit Number 35526 | 6009258.02214 | 2100018.34894 | 37.7467730300449 | -122.410713678287 | (37.7467730300449, -122.410713678287) | 2 | 7 | 7 | 28859 | 2 | |
| 13173 | 25969 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 2121 Oakdale Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/22/1997 12:00:00 AM | 3 | 2x3 | 6012170.05975 | 2097512.80398 | 37.7400561799102 | -122.400468107084 | (37.7400561799102, -122.400468107084) | 10 | 3 | 8 | 58 | 1 | ||
| 13681 | 27548 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1301X Illinois St | 6 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/05/2001 12:00:00 AM | 8 | 3X3 | 6016173.411126 | 2103023.95301 | 37.7554110972717 | -122.387010312465 | (37.7554110972717, -122.387010312465) | 10 | 3 | 8 | 28856 | 29 | ||
| 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 | |||||||||||||
| 14035 | 159355 | Planning Code 138.1 required 2 | Melaleuca quinquenervia :: Cajeput 10 | 417 Ellington Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776198 | 5998509.88268 | 2087558.19074 | 37.7119518775514 | -122.44698304145 | (37.7119518775514, -122.44698304145) | 9 | 7 | 6 | 28861 | 25 | |
| 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 | ||
| 14989 | 37365 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 125 Street | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1998 12:00:00 AM | Permit Number 39871 | |||||||||||||
| 15471 | 27568 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1299X Illinois St | 19 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/10/1999 12:00:00 AM | 12 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | 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 | |||
| 15829 | 182637 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1634 Ortega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5988859.5989 | 2102431.4519 | 37.7522339655322 | -122.481425305484 | (37.7522339655322, -122.481425305484) | 1 | 8 | 3 | 56 | 35 | |||
| 16035 | 184914 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1990 41st Ave | 33 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5983535.9639 | 2102008.3107 | 37.7507611695923 | -122.499803702352 | (37.7507611695923, -122.499803702352) | 1 | 8 | 3 | 29491 | 35 | |||
| 16036 | 247980 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 501 Peralta Ave | 4 | Side Yard : Yard | Tree | Private 2 | 5 | 6009795.98268 | 2099453.55621 | 37.7452523808083 | -122.408813614968 | (37.7452523808083, -122.408813614968) | 2 | 7 | 7 | 28859 | 2 | ||||
| 16089 | 35760 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1312 Natoma St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/20/1998 12:00:00 AM | 11 | 3x3 | Permit Number 39024 | 6007125.06235959 | 2107895.69286433 | 37.7682825792913 | -122.418647786971 | (37.7682825792913, -122.418647786971) | 8 | 4 | 7 | 28853 | 19 | |
| 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 | |||
| 16479 | 193722 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1500 Owen St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6013875.94265 | 2107923.76341 | 37.7687374206141 | -122.395298938712 | (37.7687374206141, -122.395298938712) | 14 | 3 | 9 | 310 | 20 | |||
| 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 | ||
| 17100 | 156687 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 699x Shotwell St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007926.21888 | 2103995.6336 | 37.7576189924373 | -122.415600489977 | (37.7576189924373, -122.415600489977) | 2 | 4 | 7 | 28859 | 19 | |||
| 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 | |||
| 18135 | 193744 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 106 Whitney Young Cir | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6016631.20601 | 2095628.77258 | 37.7351307863641 | -122.384911922862 | (37.7351307863641, -122.384911922862) | 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 | ||
| 18335 | 44721 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1996 21st Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/2001 12:00:00 AM | Permit Number 43840 | 5989758.20628326 | 2101785.10530384 | 37.7505114749608 | -122.478270559665 | (37.7505114749608, -122.478270559665) | 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 | ||
| 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 | |||
| 19627 | 217751 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 441 West Portal Ave | 2 | : | Tree | Private 2 | 2 | Width 3ft | 5991805.88488 | 2096457.39841 | 37.7360016106807 | -122.470801561553 | (37.7360016106807, -122.470801561553) | 1 | 8 | 4 | 59 | 40 |
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) );