trees
1,746 rows where qSpecies_id = 10 sorted by Fire Prevention Districts 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | |||
997 | 42493 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 50 Phelan Ave | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997102.28501 | 2092861.95301 | 37.7264342507672 | -122.452230525303 | (37.7264342507672, -122.452230525303) | 9 | 7 | 4 | 28861 | 40 | ||
1214 | 44389 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 15 Cordova St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/2001 12:00:00 AM | Permit Number 43749 | 6001647.0719332 | 2087964.37014378 | 37.7132458927569 | -122.436169094311 | (37.7132458927569, -122.436169094311) | 9 | 7 | 6 | 28861 | 5 | ||
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 | |||
1309 | 73822 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 118X Lowell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 3x3 | 5998761.76944 | 2087100.1867 | 37.7107086898252 | -122.44607953034 | (37.7107086898252, -122.44607953034) | 9 | 7 | 6 | 28861 | 5 | ||
1539 | 39700 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 360 Colon Ave | 2 | 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 | ||
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 | ||
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 | ||
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 | ||
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 | |||
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 | |||
3228 | 41394 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1250 Sunnydale Ave | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.7112689138709 | -122.413443728962 | (37.7112689138709, -122.413443728962) | 9 | 7 | 8 | 309 | 39 | ||
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 | |||
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 | ||
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 | |||
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 | |||
5662 | 76427 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 118X Lowell St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | 5998792.69271 | 2087037.26679 | 37.7105376918253 | -122.445968130449 | (37.7105376918253, -122.445968130449) | 9 | 7 | 6 | 28861 | 5 | ||
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 | |||
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 | ||
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 | ||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||
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 | ||||
14252 | 76445 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 118X Lowell St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 3x3 | 5998808.02641 | 2086988.08444 | 37.710403523785 | -122.445911599067 | (37.710403523785, -122.445911599067) | 9 | 7 | 6 | 28861 | 5 | ||
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 | |||
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 | |||
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 | ||
17408 | 72787 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 125 Morse St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6000842.13872 | 2087917.52073 | 37.7130714894434 | -122.438947857962 | (37.7130714894434, -122.438947857962) | 9 | 7 | 6 | 28861 | 5 | |||
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 | |||
19462 | 41404 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1252 Sunnydale Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/17/2000 12:00:00 AM | 7 | Permit Number 42021 | 6008157.91792 | 2087132.40574 | 37.7113292562177 | -122.413606495143 | (37.7113292562177, -122.413606495143) | 9 | 7 | 8 | 309 | 39 | |
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 | ||
20103 | 210188 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 511 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5998607.30137 | 2094965.41627 | 37.7322959685703 | -122.447179088249 | (37.7322959685703, -122.447179088249) | 9 | 7 | 4 | 59 | 40 | |||
20237 | 42318 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 301 Edna St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42532 | 5998734.92164885 | 2093801.38025355 | 37.7291070907004 | -122.446654155848 | (37.7291070907004, -122.446654155848) | 9 | 7 | 4 | 28861 | 40 | ||
21738 | 33348 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 120 Kenwood Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | Permit Number 37485 | 5994502.21171905 | 2093669.50135187 | 37.7285022911433 | -122.461277313418 | (37.7285022911433, -122.461277313418) | 9 | 8 | 4 | 59 | 40 | ||
22050 | 57958 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 332 Hanover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/1977 12:00:00 AM | 13 | Permit Number 16918 | 5999508.52729 | 2086501.12484 | 37.7091064162873 | -122.443455572131 | (37.7091064162873, -122.443455572131) | 9 | 7 | 6 | 28861 | 5 | ||
22265 | 34205 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 615 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767518 | 6002522.9923571 | 2090183.36055345 | 37.719388477306 | -122.433300078328 | (37.719388477306, -122.433300078328) | 9 | 7 | 6 | 28861 | 5 | |
22947 | 177552 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1252 Sunnydale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 6008179.27118 | 2087123.9525 | 37.7113072443981 | -122.413532095133 | (37.7113072443981, -122.413532095133) | 9 | 7 | 8 | 309 | 39 | |||
24788 | 210199 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 124 Judson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5999216.76029 | 2093513.04693 | 37.728342906802 | -122.444967687707 | (37.728342906802, -122.444967687707) | 9 | 7 | 4 | 28861 | 40 | |||
24917 | 33417 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 80 Westgate Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1996 12:00:00 AM | Permit Number 37527 | 5993258.22068719 | 2093571.67048868 | 37.7281619993725 | -122.465570716095 | (37.7281619993725, -122.465570716095) | 9 | 8 | 4 | 59 | 40 | ||
26495 | 42983 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2X Yale St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/16/2000 12:00:00 AM | 4 | 4x4 | Permit Number 42867 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 |
28008 | 37382 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 755 Morse St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | 5 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) | 9 | 7 | 6 | 28861 | 5 |
28107 | 254206 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 19 Foerster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778893 | 5998078.03119 | 2093679.45345 | 37.7287347632495 | -122.448916289727 | (37.7287347632495, -122.448916289727) | 9 | 7 | 4 | 28861 | 40 |
28882 | 15819 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 5050 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/11/2001 12:00:00 AM | 12 | 3X3 | 6000495.0068 | 2089582.3782 | 37.7176230574939 | -122.440266977896 | (37.7176230574939, -122.440266977896) | 9 | 7 | 6 | 28861 | 25 | ||
28892 | 187449 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 5010 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6000654.7168 | 2089835.9634 | 37.7183284371505 | -122.43973310452 | (37.7183284371505, -122.43973310452) | 9 | 7 | 6 | 28861 | 25 | |||
28913 | 42414 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 462 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42565 | 5998357.60439451 | 2094413.03350519 | 37.7307649857681 | -122.448002587308 | (37.7307649857681, -122.448002587308) | 9 | 7 | 4 | 59 | 40 | ||
30079 | 210145 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 351 Judson Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 1ft | 5997423.21033 | 2093523.1062 | 37.728268000452 | -122.451168765029 | (37.728268000452, -122.451168765029) | 9 | 7 | 4 | 28861 | 40 | |||
30110 | 210176 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 77 Mangels Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6000817.03746 | 2095186.42214 | 37.7330288117357 | -122.439555380593 | (37.7330288117357, -122.439555380593) | 9 | 7 | 5 | 63 | 40 | ||||
30783 | 42001 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 130 Manor Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/2000 12:00:00 AM | Permit Number 42336 | 5993772.38783122 | 2093685.79470402 | 37.7285049990899 | -122.463801515353 | (37.7285049990899, -122.463801515353) | 9 | 8 | 4 | 59 | 40 | |||
31961 | 187456 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 4727 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/1995 12:00:00 AM | 1 | Width 0ft | 6001715.1447 | 2091405.3885 | 37.722698028608 | -122.436179907671 | (37.722698028608, -122.436179907671) | 9 | 7 | 6 | 28861 | 5 | ||
31992 | 177558 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1272 Sunnydale Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 6ft | 6007990.6783 | 2087195.6021 | 37.7114933878791 | -122.414188987837 | (37.7114933878791, -122.414188987837) | 9 | 7 | 8 | 309 | 39 | |||
32027 | 210167 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 130 Manor Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5993786.99153 | 2093729.78154 | 37.7286266177123 | -122.463754221306 | (37.7286266177123, -122.463754221306) | 9 | 8 | 4 | 59 | 40 | |||
32520 | 210127 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 163 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6000325.54259 | 2094338.66574 | 37.7306730843824 | -122.441193799674 | (37.7306730843824, -122.441193799674) | 9 | 7 | 4 | 63 | 40 | |||
32627 | 210151 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 351 Judson Ave | 28 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 1ft | 5997831.33005 | 2093517.43224 | 37.7282757795895 | -122.449757476045 | (37.7282757795895, -122.449757476045) | 9 | 7 | 4 | 28861 | 40 | |||
32915 | 15817 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 5017 Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/27/1995 12:00:00 AM | 12 | 3X3 | 6000711.60071 | 2089768.80667 | 37.7181472775558 | -122.439531669663 | (37.7181472775558, -122.439531669663) | 9 | 7 | 6 | 28861 | 5 | ||
33244 | 30872 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 587 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/1995 12:00:00 AM | Permit Number 34706 | 5996404.87834636 | 2095840.32607721 | 37.7345721715471 | -122.45485651644 | (37.7345721715471, -122.45485651644) | 9 | 7 | 4 | 59 | 40 | |||
33637 | 42425 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 571 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42576 | 5998313.53523714 | 2094957.68654916 | 37.7322579549975 | -122.448194144251 | (37.7322579549975, -122.448194144251) | 9 | 7 | 4 | 59 | 40 | ||
33785 | 42488 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 50 Phelan Ave | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997100.11501 | 2092805.52901 | 37.7262791995089 | -122.452233957334 | (37.7262791995089, -122.452233957334) | 9 | 7 | 4 | 28861 | 40 | ||
34510 | 15760 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 4726 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1995 12:00:00 AM | 6 | 3X3 | 6001637.4054 | 2091396.9197 | 37.7226703580975 | -122.436448029232 | (37.7226703580975, -122.436448029232) | 9 | 7 | 6 | 28861 | 25 | ||
34630 | 15773 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 4787 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/1995 12:00:00 AM | 6 | 3X3 | 6001512.82985 | 2091082.39205 | 37.7217996565285 | -122.436856153691 | (37.7217996565285, -122.436856153691) | 9 | 7 | 6 | 28861 | 5 | ||
35147 | 210186 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 563 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 5998356.76458 | 2094969.04279 | 37.732291607777 | -122.448045508597 | (37.732291607777, -122.448045508597) | 9 | 7 | 4 | 59 | 40 | |||
35878 | 177541 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 763 Morse St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5998622.73143 | 2087153.99485 | 37.7108484939443 | -122.446563943873 | (37.7108484939443, -122.446563943873) | 9 | 7 | 6 | 28861 | 5 | |||
35951 | 39709 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 777 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41094 | 5996960.75086515 | 2094978.12726071 | 37.7322366517745 | -122.452872476937 | (37.7322366517745, -122.452872476937) | 9 | 7 | 4 | 59 | 40 | ||
40184 | 52932 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 189 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | Permit Number 48918 | 6000194.36437989 | 2092360.19829328 | 37.7252331965683 | -122.441505382551 | (37.7252331965683, -122.441505382551) | 9 | 7 | 6 | 28861 | 25 | ||
41159 | 210189 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 511 Joost Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5998633.47604 | 2094965.10218 | 37.7322966016873 | -122.447088574196 | (37.7322966016873, -122.447088574196) | 9 | 7 | 4 | 59 | 40 | |||
41220 | 33354 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 168 Kenwood Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42328 | 5994249.16422919 | 2093532.93310922 | 37.7281127414701 | -122.462142205261 | (37.7281127414701, -122.462142205261) | 9 | 8 | 4 | 59 | 40 | ||
41643 | 31101 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 25 Congo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34831 | 6000068 | 2094066 | 37.7299097339823 | -122.442064596859 | (37.7299097339823, -122.442064596859) | 9 | 7 | 4 | 63 | 40 | ||
41843 | 15806 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 4951 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/27/1995 12:00:00 AM | 5 | 3X3 | 6000923.94149 | 2090106.32995 | 37.719086123331 | -122.438821873955 | (37.719086123331, -122.438821873955) | 9 | 7 | 6 | 28861 | 5 | ||
41935 | 15821 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 5051 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/27/1995 12:00:00 AM | 6 | 3X3 | 6000582.469 | 2089604.8822 | 37.7176898277089 | -122.439966274171 | (37.7176898277089, -122.439966274171) | 9 | 7 | 6 | 28861 | 5 | ||
42657 | 210126 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 331 Hearst Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 4ft | 5999202.63629 | 2094344.01733 | 37.7306237511816 | -122.445076229583 | (37.7306237511816, -122.445076229583) | 9 | 7 | 4 | 28861 | 40 | |||
42764 | 210117 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 160 Aptos Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5992815.92079 | 2093857.20717 | 37.7289204918737 | -122.467120501534 | (37.7289204918737, -122.467120501534) | 9 | 8 | 4 | 59 | 40 | |||
44057 | 210124 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1385 Monterey Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 2ft | 5993817.1822 | 2094684.91892 | 37.7312509302751 | -122.46371914682 | (37.7312509302751, -122.46371914682) | 9 | 8 | 4 | 59 | 40 | |||
44129 | 177579 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 518 Rolph St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6002528.75121 | 2087456.67798 | 37.7119019345989 | -122.433085459944 | (37.7119019345989, -122.433085459944) | 9 | 7 | 6 | 28861 | 5 | |||
44393 | 42485 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 50 Phelan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/2002 12:00:00 AM | Permit Number 44826 | 5997092.52001 | 2092229.35701 | 37.7246967322782 | -122.452218657298 | (37.7246967322782, -122.452218657298) | 9 | 7 | 4 | 28861 | 40 | ||
44403 | 15766 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 4760 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/26/1995 12:00:00 AM | 12 | 3X3 | 6001476.2489 | 2091134.8369 | 37.7219415791088 | -122.436986357081 | (37.7219415791088, -122.436986357081) | 9 | 7 | 6 | 28861 | 25 | ||
45562 | 42478 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 50 Phelan Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997094.69001 | 2092450.71201 | 37.7253046451535 | -122.4522271205 | (37.7253046451535, -122.4522271205) | 9 | 7 | 4 | 28861 | 40 | ||
45566 | 40695 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 239 Ney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/10/1999 12:00:00 AM | 9 | Permit Number 41675 | 6004959.82025 | 2094081.11499 | 37.7302287977163 | -122.425154059106 | (37.7302287977163, -122.425154059106) | 9 | 7 | 6 | 28861 | 5 | |
46046 | 95664 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 298 Cambridge St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767424 | 6006728 | 2093095 | 37.7276208697995 | -122.41897129935 | (37.7276208697995, -122.41897129935) | 9 | 7 | 7 | 309 | 5 | |
46147 | 210121 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 171 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/2000 12:00:00 AM | 6 | Width 2ft | Permit Number 42348 | 5993661.71246 | 2093994.82624 | 37.7293471455347 | -122.464206548805 | (37.7293471455347, -122.464206548805) | 9 | 8 | 4 | 59 | 40 | |
46537 | 210177 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 77 Mangels Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 8ft | 6000839.93148 | 2095188.18201 | 37.7330349469017 | -122.439476356244 | (37.7330349469017, -122.439476356244) | 9 | 7 | 5 | 63 | 40 | |||
47045 | 44415 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 715 Prague St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 10 | Permit Number 43765 | 6002616.35291 | 2087303.28452 | 37.7114857184532 | -122.432771733227 | (37.7114857184532, -122.432771733227) | 9 | 7 | 6 | 28861 | 5 | |
47059 | 210159 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 201 Judson Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 5998628.98147 | 2093469.72589 | 37.7281903934576 | -122.446996541164 | (37.7281903934576, -122.446996541164) | 9 | 7 | 4 | 28861 | 40 | |||
47887 | 251342 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2275 Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/14/1996 12:00:00 AM | 3x3 | Permit Number 37503 | 5992527 | 2093770 | 37.7286643609316 | -122.468112971633 | (37.7286643609316, -122.468112971633) | 9 | 8 | 4 | 59 | 40 | ||
48872 | 163376 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 204 Sadowa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 08:04:00 AM | 3 | Width 0ft | 5994976.69201 | 2087776.57882 | 37.7123490271688 | -122.459210469509 | (37.7123490271688, -122.459210469509) | 9 | 8 | 6 | 28861 | 24 | ||
49144 | 15814 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 5017 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/27/1995 12:00:00 AM | 12 | 3X3 | 6000703.7551 | 2089800.5417 | 37.7182339682695 | -122.439561062254 | (37.7182339682695, -122.439561062254) | 9 | 7 | 6 | 28861 | 5 | ||
50255 | 177546 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1200 Sunnydale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 6008407.55412 | 2087041.90814 | 37.711094783172 | -122.4127372923 | (37.711094783172, -122.4127372923) | 9 | 7 | 8 | 309 | 39 | |||
50403 | 41405 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1250 Sunnydale Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.7112689138709 | -122.413443728962 | (37.7112689138709, -122.413443728962) | 9 | 7 | 8 | 309 | 39 |
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) );