2,694 rows where qSpecies_id = 84 sorted by Zip Codes

View and edit SQL

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)
884 261406 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 779 Broadway 2 Sidewalk: Curb side : Cutout Tree Private 2                              
3071 31851 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 1117 Houston St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/1995 12:00:00 AM     Permit Number 35299                    
4023 31850 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84   2 Sidewalk: Curb side : Cutout Tree Private 2   06/19/1995 12:00:00 AM     Permit Number 35298                    
4740 119761 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 101X Octavia St Frontage West 3 Sidewalk: Curb side : Cutout Tree DPW 1       4x4                      
4940 39332 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 0 21st St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/21/1998 12:00:00 AM     Permit Number 40897                    
5244 261407 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 779 Broadway 3 Sidewalk: Curb side : Cutout Tree Private 2                              
6169 39333 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 0 21st St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/21/1998 12:00:00 AM     Permit Number 40897                    
7788 39331 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 0 21st St 5 Sidewalk: Curb side : Cutout Tree Private 2   12/21/1998 12:00:00 AM     Permit Number 40897                    
8270 261411 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 779 Broadway 7 Sidewalk: Curb side : Cutout Tree Private 2                              
8717 119762 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 101X Octavia St Frontage West 4 Sidewalk: Curb side : Cutout Tree DPW 1       4x4                      
8992 261405 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 779 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2                              
10081 119760 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 101X Octavia St Frontage West 2 Sidewalk: Curb side : Cutout Tree DPW 1       4x4                      
11366 53918 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 3 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/21/1998 12:00:00 AM     Permit Number 40897                    
12262 261408 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 779 Broadway 4 Sidewalk: Curb side : Cutout Tree Private 2                              
14089 261410 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 779 Broadway 6 Sidewalk: Curb side : Cutout Tree Private 2                              
14566 31845 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84   3 Sidewalk: Curb side : Cutout Tree Private 2   06/19/1995 12:00:00 AM     Permit Number 35298                    
15267 119759 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 101X Octavia St Frontage West 1 Sidewalk: Curb side : Cutout Tree DPW 1       4x4                      
15516 39334 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 0 21st St 4 Sidewalk: Curb side : Cutout Tree Private 2   12/21/1998 12:00:00 AM     Permit Number 40897                    
16965 31849 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84   1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/1995 12:00:00 AM     Permit Number 35298                    
17187 261409 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 779 Broadway 5 Sidewalk: Curb side : Cutout Tree Private 2                              
18369 261412 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 779 Broadway 8 Sidewalk: Curb side : Cutout Tree Private 2                              
19387 31852 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 1117 Houston St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/19/1995 12:00:00 AM     Permit Number 35299                    
282 119806 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 251X Octavia St Frontage West 3 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6005545 2110174 37.7744491774234 -122.424275134654 (37.7744491774234, -122.424275134654) 7 9 11 28852 10
340 42995 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 436 Lily St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/2000 12:00:00 AM     Permit Number 42871 6004515.16540478 2110012.02065503 37.7739462176361 -122.42782598565 (37.7739462176361, -122.42782598565) 7 9 11 28852 10
4437 244983 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 299 Rose St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/06/2018 12:00:00 AM 3 Width 0ft Permit Number 781995 6005200.9141 2109719.1317 37.7731807843789 -122.425433016756 (37.7731807843789, -122.425433016756) 7 9 11 28852 10
6160 42787 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 413 Lily St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2000 12:00:00 AM   3x3 Permit Number 42754 6004586.33786017 2109969.42501453 37.7738332863504 -122.427576752843 (37.7738332863504, -122.427576752843) 7 9 11 28852 10
9471 119842 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 350 Octavia St Frontage East 2 Sidewalk: Curb side : Cutout Tree DPW 1       4x4   6005602 2110303 37.774806598562 -122.424087136382 (37.774806598562, -122.424087136382) 7 9 11 28852 10
9852 31300 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 519 Birch St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/12/1995 12:00:00 AM 10   Permit Number 34943 6005263.3007 2111469.3023 37.7779898515936 -122.425341782234 (37.7779898515936, -122.425341782234) 7 9 11 28852 10
11452 110549 Undocumented 4 Prunus serrulata :: Ornamental Cherry 84 2x LILY ST 7 Sidewalk: Curb side : Cutout Tree Private 2       2.5x4   6006369 2110405 37.7751299410446 -122.421441165405 (37.7751299410446, -122.421441165405) 7 9 11 28852 10
13210 244980 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 289 Rose St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6005226.4402 2109722.7783 37.7731922392405 -122.425344978098 (37.7731922392405, -122.425344978098) 7 9 11 28852 10
20713 107753 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 400X Lily St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004484.08045 2109981.44374 37.773860502373 -122.427931334456 (37.773860502373, -122.427931334456) 7 9 11 28852 10
21018 110553 Undocumented 4 Prunus serrulata :: Ornamental Cherry 84 2x LILY ST 11 Sidewalk: Curb side : Cutout Tree Private 2       2.5x4   6006369 2110405 37.7751299410446 -122.421441165405 (37.7751299410446, -122.421441165405) 7 9 11 28852 10
23723 30734 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 281 Rose St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/31/1995 12:00:00 AM     Permit Number 34629 6005251.19976575 2109714.98569866 37.7731722414546 -122.425258776803 (37.7731722414546, -122.425258776803) 7 9 11 28852 10
23975 142257 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 541 LINDEN ST 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6004803.1693 2110709.0411 37.7758763538472 -122.426879382419 (37.7758763538472, -122.426879382419) 7 9 11 28852 10
27494 109159 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 200 Octavia St Frontage East 5 Sidewalk: Curb side : Cutout Tree DPW 1       4x4   6005726 2110076 37.7741903117261 -122.423642051276 (37.7741903117261, -122.423642051276) 7 9 11 28852 10
27984 138926 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 431 OCTAVIA ST 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   6005464.9166 2110768.0336 37.7760757272062 -122.424594423557 (37.7760757272062, -122.424594423557) 7 9 11 28852 10
28153 244988 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 260 Rose St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/16/2018 12:00:00 AM 3 Width 0ft   6005214.8927 2109749.52 37.7732650130646 -122.425386825853 (37.7732650130646, -122.425386825853) 7 9 11 28852 10
28839 119865 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 451X Octavia St Frontage West 6 Sidewalk: Curb side : Cutout Tree DPW 1       4x4   6005602 2110303 37.774806598562 -122.424087136382 (37.774806598562, -122.424087136382) 7 9 11 28852 10
28979 110554 Undocumented 4 Prunus serrulata :: Ornamental Cherry 84 2x LILY ST 12 Sidewalk: Curb side : Cutout Tree Private 2       2.5x4   6006369 2110405 37.7751299410446 -122.421441165405 (37.7751299410446, -122.421441165405) 7 9 11 28852 10
29442 42763 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 415 Buchanan St 9 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2000 12:00:00 AM     Permit Number 42742 6004604.76721884 2109944.08482631 37.7737647507648 -122.427511197042 (37.7737647507648, -122.427511197042) 7 9 11 28852 10
29717 107752 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 400X Lily St 1 Sidewalk: Curb side : Cutout Tree Private 2       4x3 Permit Number 772924 6004484.08045 2109981.44374 37.773860502373 -122.427931334456 (37.773860502373, -122.427931334456) 7 9 11 28852 10
30425 142001 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 762 FULTON ST 4 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6004249.2696 2111539.4607 37.7781251474871 -122.428854679323 (37.7781251474871, -122.428854679323) 7 9 11 28852 41
31012 42789 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 426 -28 -30 Lily St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2000 12:00:00 AM   3x3 Permit Number 42755 6004546 2110000 37.7739149561089 -122.427718466962 (37.7739149561089, -122.427718466962) 7 9 11 28852 10
31843 119859 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 431 Octavia St Frontage West 3 Sidewalk: Curb side : Cutout Tree DPW 1       4x4   6005602 2110303 37.774806598562 -122.424087136382 (37.774806598562, -122.424087136382) 7 9 11 28852 10
33066 42783 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 202 Laguna St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2000 12:00:00 AM     Permit Number 42751 6005176.07009417 2109735.98338901 37.7732256513259 -122.425520155041 (37.7732256513259, -122.425520155041) 7 9 11 28852 10
33346 245221 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 341 Laguna St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6005088.7556 2110037.9678 37.7740498933785 -122.425843687227 (37.7740498933785, -122.425843687227) 7 9 11 28852 10
36097 115453 Undocumented 4 Prunus serrulata :: Ornamental Cherry 84 300 Octavia St Frontage East 4 Sidewalk: Curb side : Cutout Tree DPW 1       4x4   6005602 2110303 37.774806598562 -122.424087136382 (37.774806598562, -122.424087136382) 7 9 11 28852 10
38409 110550 Undocumented 4 Prunus serrulata :: Ornamental Cherry 84 2x LILY ST 8 Sidewalk: Curb side : Cutout Tree Private 2       2.5x4   6006369 2110405 37.7751299410446 -122.421441165405 (37.7751299410446, -122.421441165405) 7 9 11 28852 10
38617 119866 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 451X Octavia St Frontage West 7 Sidewalk: Curb side : Cutout Tree DPW 1       4x4   6005602 2110303 37.774806598562 -122.424087136382 (37.774806598562, -122.424087136382) 7 9 11 28852 10
39487 244972 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 209 Rose St 4 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6005534.5777 2109768.9686 37.7733364706745 -122.424282374507 (37.7733364706745, -122.424282374507) 7 9 11 28852 10
40216 244239 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 253 Octavia St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6005546.7389 2110177.0116 37.7744575447356 -122.424269333697 (37.7744575447356, -122.424269333697) 7 9 11 28852 10
42803 115684 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 100x Octavia St Frontage East 4 Sidewalk: Curb side : Cutout Tree DPW 1       4x4   6005589 2109665 37.7730540708525 -122.424086724818 (37.7730540708525, -122.424086724818) 7 9 11 28852 10
43629 119810 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 250 Octavia St Frontage East 2 Sidewalk: Curb side : Cutout Tree DPW 1       4x4   6005726 2110076 37.7741903117261 -122.423642051276 (37.7741903117261, -122.423642051276) 7 9 11 28852 10
44073 142255 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 521 LINDEN ST 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   6004876.8784 2110720.6117 37.7759122912727 -122.426625227687 (37.7759122912727, -122.426625227687) 7 9 11 28852 10
44178 103651 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 307X Octavia St 3 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2016 12:00:00 AM 3 4x4 Permit Number 770306 6005538.74006 2110314.20336 37.7748337884081 -122.424306762839 (37.7748337884081, -122.424306762839) 7 9 11 28852 10
45122 87992 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 230 Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/20/2008 12:00:00 AM   3x3 Permit Number 51030 6008092 2113193 37.7828821185058 -122.41567835443 (37.7828821185058, -122.41567835443) 7 10 9 28852 36
46174 244365 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 301 Octavia St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   6005511.8056 2110439.7613 37.7751770191286 -122.424408867351 (37.7751770191286, -122.424408867351) 7 9 11 28852 10
48105 142263 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 585 Linden St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6004612.4683 2110683.7571 37.7757961457109 -122.427537264685 (37.7757961457109, -122.427537264685) 7 9 11 28852 10
48774 119805 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 251X Octavia St Frontage West 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6005545 2110174 37.7744491774234 -122.424275134654 (37.7744491774234, -122.424275134654) 7 9 11 28852 10
49694 119841 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 350 Octavia St Frontage East 1 Sidewalk: Curb side : Cutout Tree DPW 1       4x4   6005602 2110303 37.774806598562 -122.424087136382 (37.774806598562, -122.424087136382) 7 9 11 28852 10
51800 91186 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 291 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2009 12:00:00 AM 2 6x9 Permit Number 52039 6005173 2109884 37.7736318955877 -122.425541311156 (37.7736318955877, -122.425541311156) 7 9 11 28852 10
52301 107755 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 400X Lily St 4 Sidewalk: Curb side : Cutout Tree Private 2           6004484.08045 2109981.44374 37.773860502373 -122.427931334456 (37.773860502373, -122.427931334456) 7 9 11 28852 10
52758 47013 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 445 Hickory St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/26/2004 12:00:00 AM     Permit Number 47268 6004844.28922352 2110353.57072253 37.7749026438811 -122.426711818296 (37.7749026438811, -122.426711818296) 7 9 11 28852 10
54224 119853 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 401 Octavia St Frontage West 1 Sidewalk: Curb side : Cutout Tree DPW 1       4x4   6005602 2110303 37.774806598562 -122.424087136382 (37.774806598562, -122.424087136382) 7 9 11 28852 10
54663 110552 Undocumented 4 Prunus serrulata :: Ornamental Cherry 84 2x LILY ST 10 Sidewalk: Curb side : Cutout Tree Private 2       2.5x4   6006369 2110405 37.7751299410446 -122.421441165405 (37.7751299410446, -122.421441165405) 7 9 11 28852 10
55324 138925 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 431 OCTAVIA ST 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   6005461.4768 2110789.2454 37.7761337753876 -122.424607831994 (37.7761337753876, -122.424607831994) 7 9 11 28852 10
55977 119812 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 250 Octavia St Frontage East 4 Sidewalk: Curb side : Cutout Tree DPW 1       4x4   6005726 2110076 37.7741903117261 -122.423642051276 (37.7741903117261, -122.423642051276) 7 9 11 28852 10
56426 244956 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 298 Laguna St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6005155.9394 2109820.0209 37.77345526051 -122.42559577205 (37.77345526051, -122.42559577205) 7 9 11 28852 10
58002 119858 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 431 Octavia St Frontage West 2 Sidewalk: Curb side : Cutout Tree DPW 1       4x4   6005602 2110303 37.774806598562 -122.424087136382 (37.774806598562, -122.424087136382) 7 9 11 28852 10
58451 110547 Undocumented 4 Prunus serrulata :: Ornamental Cherry 84 2x LILY ST 5 Sidewalk: Curb side : Cutout Tree Private 2       2.5x4   6006369 2110405 37.7751299410446 -122.421441165405 (37.7751299410446, -122.421441165405) 7 9 11 28852 10
58652 31299 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 519 Birch St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/12/1995 12:00:00 AM 8   Permit Number 34943 6005251.2106 2111468.7266 37.777987587802 -122.425383565241 (37.777987587802, -122.425383565241) 7 9 11 28852 10
60687 42765 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 415 Buchanan St 5 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2000 12:00:00 AM     Permit Number 42742 6004604.76721884 2109944.08482631 37.7737647507648 -122.427511197042 (37.7737647507648, -122.427511197042) 7 9 11 28852 10
61525 46331 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 201 Lily St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/12/2002 12:00:00 AM     Permit Number 44582 6005568.06039934 2110039.04677053 37.7740799306106 -122.424185764506 (37.7740799306106, -122.424185764506) 7 9 11 28852 10
61618 244350 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 300 Octavia St 5 Sidewalk: Curb side : Cutout Tree DPW 1   04/20/2017 07:22:00 AM 3 Width 0ft   6005619.219 2110418.7508 37.7751253943864 -122.424035805431 (37.7751253943864, -122.424035805431) 7 9 11 28852 10
61621 8104 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 780 Fulton St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/04/2010 12:00:00 AM 3 3X3   6004088.9733 2111516.0342 37.7780517500412 -122.429407531137 (37.7780517500412, -122.429407531137) 7 9 11 28852 41
64335 138975 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 461 Octavia St 5 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6005450.5842 2110864.9202 37.7763409448097 -122.42465089693 (37.7763409448097, -122.42465089693) 7 9 11 28852 10
65404 46332 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 201 Lily St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/12/2002 12:00:00 AM     Permit Number 44582 6005568.06039934 2110039.04677053 37.7740799306106 -122.424185764506 (37.7740799306106, -122.424185764506) 7 9 11 28852 10
68060 31301 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 529 Birch St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/12/1995 12:00:00 AM 8   Permit Number 34944 6005236.8177 2111465.8481 37.7779788709631 -122.425433150534 (37.7779788709631, -122.425433150534) 7 9 11 28852 10
68068 44186 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 792 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/21/2002 12:00:00 AM 5 3x3 Permit Number 45643 6004083.1428 2110821.1912 37.7761435523821 -122.429378138275 (37.7761435523821, -122.429378138275) 7 9 11 28852 10
69433 107757 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 400X Lily St 6 Sidewalk: Curb side : Cutout Tree Private 2           6004484.08045 2109981.44374 37.773860502373 -122.427931334456 (37.773860502373, -122.427931334456) 7 9 11 28852 10
70233 139392 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 466 Ivy St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   6005058.4753 2111113.4947 37.7770013168736 -122.426025011181 (37.7770013168736, -122.426025011181) 7 9 11 28852 10
70239 142454 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 537 LINDEN ST 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6004825.882 2110712.4694 37.7758870513166 -122.426801057519 (37.7758870513166, -122.426801057519) 7 9 11 28852 10
70643 244389 Undocumented 4 Prunus serrulata :: Ornamental Cherry 84 250 Octavia St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6005653.9696 2110171.6272 37.7744488147211 -122.42389801886 (37.7744488147211, -122.42389801886) 7 9 11 28852 10
70667 115688 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 150X Octavia St Frontage East 2 Sidewalk: Curb side : Cutout Tree DPW 1       4x4   6005692.21728 2109889.45005 37.7736761836422 -122.423745644927 (37.7736761836422, -122.423745644927) 7 9 11 28852 10
71027 43003 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 205X Rose St 8 Sidewalk: Curb side : Cutout Tree Private 2   07/05/2000 12:00:00 AM     Permit Number 42873 6005609.30796774 2109736.9244771 37.7732527046739 -122.424021592666 (37.7732527046739, -122.424021592666) 7 9 11 28852 10
71162 256523 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 260 Rose St 3 Sidewalk: Curb side : Cutout Tree Private 2       Width 0ft   6005231.3024 2109750.7356 37.7732692779132 -122.425330148953 (37.7732692779132, -122.425330148953) 7 9 11 28852 10
71737 138874 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 400 OCTAVIA ST 7 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   6005562.0898 2110802.7178 37.7761764489655 -122.424260742604 (37.7761764489655, -122.424260742604) 7 9 11 28852 10
71882 244992 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 249 Rose St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6005441.5895 2109754.3822 37.7732911688522 -122.424602996105 (37.7732911688522, -122.424602996105) 7 9 11 28852 10
72864 244352 Undocumented 4 Prunus serrulata :: Ornamental Cherry 84 300 Octavia St 7 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6005613.5532 2110456.5225 37.7752287864343 -122.424058091407 (37.7752287864343, -122.424058091407) 7 9 11 28852 10
72883 30735 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 281 Rose St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/31/1995 12:00:00 AM 6   Permit Number 34629 6005260 2109713 37.7731672863676 -122.42522819429 (37.7731672863676, -122.42522819429) 7 9 11 28852 10
73713 244366 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 301 Octavia St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6005514.1663 2110403.406 37.7750773296011 -122.424398114747 (37.7750773296011, -122.424398114747) 7 9 11 28852 10
74267 31302 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 529 Birch St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/12/1995 12:00:00 AM 9   Permit Number 34944 6005223.0006 2111465.2723 37.7779765092875 -122.425480907835 (37.7779765092875, -122.425480907835) 7 9 11 28852 10
74848 139395 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 486 Ivy St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6005025.4278 2111110.8954 37.7769923120329 -122.426139147688 (37.7769923120329, -122.426139147688) 7 9 11 28852 10
74948 42761 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 415 Buchanan St 8 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2000 12:00:00 AM     Permit Number 42742 6004604.76721884 2109944.08482631 37.7737647507648 -122.427511197042 (37.7737647507648, -122.427511197042) 7 9 11 28852 10
75128 244991 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 213 Lily St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6005531.8427 2110116.9147 37.7742916920696 -122.424316587333 (37.7742916920696, -122.424316587333) 7 9 11 28852 10
75976 119596 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 431 Octavia St 2 Sidewalk: Curb side : Cutout Tree DPW 1       4x4   6005470 2110737 37.7759908035691 -122.42457463067 (37.7759908035691, -122.42457463067) 7 9 11 28852 10
76471 244994 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 231 Lily St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/02/2002 12:00:00 AM 4 Width 0ft Permit Number 45013 6005396.3109 2110099.8972 37.7742373121563 -122.4247842062 (37.7742373121563, -122.4247842062) 7 9 11 28852 10
77446 119877 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 450X Octavia St Frontage East 4 Sidewalk: Curb side : Cutout Tree DPW 1       4x4   6005602 2110303 37.774806598562 -122.424087136382 (37.774806598562, -122.424087136382) 7 9 11 28852 10
77588 42997 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 438 Lily St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/2000 12:00:00 AM     Permit Number 42872 6004509.83171755 2110011.27832833 37.7739438776611 -122.427844382866 (37.7739438776611, -122.427844382866) 7 9 11 28852 10
78073 33620 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 426 Lily St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/20/1999 12:00:00 AM     Permit Number 37725 6004541.83388077 2110015.73229407 37.7739579174854 -122.427733999418 (37.7739579174854, -122.427733999418) 7 9 11 28852 10

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);