3,267 rows where qSpecies_id = 67 sorted by Fire Prevention Districts

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)
46569 92915 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 340 West Portal Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8     5992211 2096907 37.737259523291 -122.46943364564 (37.737259523291, -122.46943364564) 1 8 4 59 40
46940 44811 Permitted Site 7 Callistemon citrinus :: Lemon Bottlebrush 67 2700x Kirkham St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/12/2001 12:00:00 AM     Permit Number 43905 5986360 2105036 37.7592396918496 -122.490260766294 (37.7592396918496, -122.490260766294) 1 8 3 56 35
47693 217680 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 262 West Portal Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   5992385.3244 2097283.625 37.73830371342 -122.468858330396 (37.73830371342, -122.468858330396) 1 8 4 59 40
47761 183269 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1249 41st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5983336.1919 2106636.3882 37.763456845523 -122.500836736792 (37.763456845523, -122.500836736792) 1 8 3 56 35
48078 112664 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 2550 IRVING ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5988170 2106474 37.7632935889767 -122.48410644406 (37.7632935889767, -122.48410644406) 1 8 3 56 35
48137 204468 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 180 Merced Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   5994276.47552 2099234.04461 37.7437681567899 -122.462461140072 (37.7437681567899, -122.462461140072) 1 8 4 59 40
48772 184903 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1798 39th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   5984124.141 2103020.0227 37.7535735484973 -122.497844463399 (37.7535735484973, -122.497844463399) 1 8 3 56 35
48867 217682 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 106 West Portal Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   5992831.9496 2097739.0243 37.7395799184924 -122.467347238041 (37.7395799184924, -122.467347238041) 1 8 4 59 40
49606 205740 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 32 Mesa Ave 1 Sidewalk: Curb side : Yard Tree Private 2     8 Width 4ft   5993640.80754 2100768.42511 37.7479445508167 -122.464770513651 (37.7479445508167, -122.464770513651) 1 8 4 29491 40
49792 182818 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1801 30th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   5986875.267 2102940.8737 37.7535171257271 -122.488324778074 (37.7535171257271, -122.488324778074) 1 8 3 56 35
49840 112662 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 2550 IRVING ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5988170 2106474 37.7632935889767 -122.48410644406 (37.7632935889767, -122.48410644406) 1 8 3 56 35
49942 205754 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 200x Terrace Dr 35 Median : Yard Tree DPW 1     5     5993872.8693 2096472.52816 37.7361624724174 -122.46365632018 (37.7361624724174, -122.46365632018) 1 8 4 59 40
50000 204494 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2200 Mesa Ave 4 Sidewalk: Curb side : Yard Tree Private 2     7 Width 3ft   5993641.99222 2100733.77083 37.7478494672755 -122.464763900938 (37.7478494672755, -122.464763900938) 1 8 4 29491 40
50171 182177 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1799X Lawton St 4 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5988865 2104441 37.7577519603078 -122.48155379204 (37.7577519603078, -122.48155379204) 1 8 3 56 35
50216 92917 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 346 West Portal Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8     5992028 2097000 37.7375043003581 -122.470073124763 (37.7375043003581, -122.470073124763) 1 8 4 59 40
50464 185605 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2618 Quintara St 4 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   5985302.1571 2100947.2721 37.7479513323017 -122.493617965632 (37.7479513323017, -122.493617965632) 1 8 3 29491 35
50978 218223 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 399 Claremont Blvd 2 Side Yard : Yard Tree Private 2     12     5993474.17256 2097846.02445 37.73991076848 -122.465134496264 (37.73991076848, -122.465134496264) 1 8 4 59 40
51542 217665 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 80 West Portal Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   5992999.2698 2097917.3829 37.740079304226 -122.466781684087 (37.740079304226, -122.466781684087) 1 8 4 59 40
52426 183682 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1323 39th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5983973.4902 2106147.0568 37.7621506760822 -122.498596412549 (37.7621506760822, -122.498596412549) 1 8 3 56 35
53062 43620 Permitted Site 7 Callistemon citrinus :: Lemon Bottlebrush 67 2095 35th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/20/2000 12:00:00 AM     Permit Number 43271 5985386.76911027 2100967.4929928 37.7480118028434 -122.493326874686 (37.7480118028434, -122.493326874686) 1 8 3 29491 35
53538 218209 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 51 Taraval St 1 Sidewalk: Curb side : Yard Tree Private 2     6 Width 3ft   5993480.34534 2099171.49285 37.7435505271302 -122.465209404389 (37.7435505271302, -122.465209404389) 1 8 4 59 40
53863 205692 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 454 Santiago St 4 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5991321.23075 2099784.56704 37.745109125085 -122.472719706665 (37.745109125085, -122.472719706665) 1 8 4 29491 40
54046 183288 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1285 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   5982099.3385 2106416.2727 37.762779775667 -122.505098228653 (37.762779775667, -122.505098228653) 1 8 3 56 35
54253 204472 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 293 Magellan Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   5994575.1706 2100200.25095 37.746438313181 -122.461498364577 (37.746438313181, -122.461498364577) 1 8 4 29491 40
55188 175656 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 0 Gonzalez Dr 3 Sidewalk: Curb side : Yard Tree Private 2     9     5990014.12726 2089314.59531 37.716285489253 -122.476474690052 (37.716285489253, -122.476474690052) 1 8 4 64 14
55594 204408 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 318 Lawton St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5993250.86582 2104625.10677 37.7585115156134 -122.466399162508 (37.7585115156134, -122.466399162508) 1 8 4 56 12
55901 182111 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2455 28th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   5987647.6873 2098570.6897 37.7415628035476 -122.485332960195 (37.7415628035476, -122.485332960195) 1 8 3 29491 35
56049 204444 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2300 Santiago St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5991515.68796 2099751.50596 37.745029602544 -122.472044904852 (37.745029602544, -122.472044904852) 1 8 4 29491 40
56078 38346 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1862 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/29/1998 12:00:00 AM 3   Permit Number 40413 5982280.7574 2102429.3074 37.7518433707941 -122.504175425295 (37.7518433707941, -122.504175425295) 1 8 3 56 35
56665 92931 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 323 West Portal Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7     5992282 2096978 37.7374585742898 -122.469193334242 (37.7374585742898, -122.469193334242) 1 8 4 59 40
57324 104918 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 719 Gonzalez Dr 1 Sidewalk: Curb side : Yard Tree Private 2           5990421 2090607 37.719857702396 -122.475162650507 (37.719857702396, -122.475162650507) 1 8 4 64 40
58174 112478 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 1799X LAWTON ST 4 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   5988671 2104385 37.7575869171128 -122.482220613518 (37.7575869171128, -122.482220613518) 1 8 3 56 35
58843 204404 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1440 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   5994305.88631 2105718.15994 37.7615735767848 -122.4628297533 (37.7615735767848, -122.4628297533) 1 5 11 56 12
59639 114414 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 786 SANTIAGO ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5990542 2099782 37.7450569383371 -122.475413934806 (37.7450569383371, -122.475413934806) 1 8 4 29491 40
59710 182114 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2461 27th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   5987955.9219 2098548.963 37.7415210998625 -122.484265609923 (37.7415210998625, -122.484265609923) 1 8 3 29491 35
61883 204426 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2046 18th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5990696.70707 2101451.06595 37.7496487256149 -122.475000804639 (37.7496487256149, -122.475000804639) 1 8 4 29491 12
62959 217659 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 60 West Portal Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   5993054.3652 2097973.5639 37.7402367426771 -122.466595270886 (37.7402367426771, -122.466595270886) 1 8 4 59 40
63445 205747 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 80 Sotelo Ave 2 Sidewalk: Curb side : Yard Tree Private 2     4 Width 4ft   5993775.94958 2101415.71343 37.7497296304244 -122.464350190328 (37.7497296304244, -122.464350190328) 1 8 4 29491 40
63532 205704 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 141 Taraval St 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5993168.55795 2099144.70006 37.7434589761641 -122.466285532248 (37.7434589761641, -122.466285532248) 1 8 4 59 40
63650 43622 Permitted Site 7 Callistemon citrinus :: Lemon Bottlebrush 67 2095 35th Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/20/2000 12:00:00 AM     Permit Number 43271 5985386.76911027 2100967.4929928 37.7480118028434 -122.493326874686 (37.7480118028434, -122.493326874686) 1 8 3 29491 35
63736 204443 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2346 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5991073.40938 2099451.63533 37.7441806317458 -122.473552340388 (37.7441806317458, -122.473552340388) 1 8 4 29491 40
63812 204447 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2391 Taraval St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5991311.9107 2099114.01437 37.7432674205575 -122.472703051209 (37.7432674205575, -122.472703051209) 1 8 4 29491 40
64262 204461 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 376 Magellan Ave 1 Sidewalk: Curb side : Yard Tree Private 2     13 Width 3ft   5993925.03451 2099657.87207 37.7449116357803 -122.46370708514 (37.7449116357803, -122.46370708514) 1 8 4 29491 40
64538 217637 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 323 West Portal Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5992238.289 2097019.9802 37.7375713154411 -122.469347517077 (37.7375713154411, -122.469347517077) 1 8 4 59 40
65416 204452 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 80 Wawona St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5993066.12283 2098585.83343 37.741918558889 -122.466599110557 (37.741918558889, -122.466599110557) 1 8 4 59 40
65749 104923 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 767 Gonzalez Dr 1 Sidewalk: Curb side : Yard Tree Private 2           5990385 2090588 37.7198034465129 -122.47528570222 (37.7198034465129, -122.47528570222) 1 8 4 64 14
65850 69027 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 3830 Quintara St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/05/1994 12:00:00 AM 0   Permit Number 33031 5981593.45716069 2100816.99566217 37.7473759716808 -122.506432607968 (37.7473759716808, -122.506432607968) 1 8 3 29491 35
66445 204458 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 390 Magellan Ave 1 Sidewalk: Curb side : Yard Tree Private 2     12 Width 3ft   5993883.60942 2099617.77465 37.7447991512623 -122.463847414442 (37.7447991512623, -122.463847414442) 1 8 4 29491 40
66884 112665 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 2550 IRVING ST 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5988170 2106474 37.7632935889767 -122.48410644406 (37.7632935889767, -122.48410644406) 1 8 3 56 35
67897 109264 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 3338X Ortega St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/05/2015 12:00:00 AM 3 3x3   5983663.54917 2102222.75157 37.7513574508855 -122.499378353213 (37.7513574508855, -122.499378353213) 1 8 3 29491 35
67901 205753 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 200x Terrace Dr 34 Median : Yard Tree DPW 1     4     5993866.87232 2096473.28451 37.7361642036105 -122.463677108908 (37.7361642036105, -122.463677108908) 1 8 4 59 40
68086 104901 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 314 Gonzalez Dr 1 Sidewalk: Curb side : Yard Tree Private 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
68279 175655 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 0 Gonzalez Dr 4 Sidewalk: Curb side : Yard Tree Private 2     5     5989994.06268 2089291.62254 37.7162212479866 -122.476542364932 (37.7162212479866, -122.476542364932) 1 8 4 64 14
68322 204457 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 396 Magellan Ave 2 Sidewalk: Curb side : Yard Tree Private 2     10 Width 3ft   5993837.1599 2099576.6757 37.7446836270619 -122.464005043996 (37.7446836270619, -122.464005043996) 1 8 4 29491 40
68518 92933 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 333 West Portal Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7     5992246.1 2096943.8 37.7373625952097 -122.469314967671 (37.7373625952097, -122.469314967671) 1 8 4 59 40
68604 112663 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 2550 IRVING ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5988170 2106474 37.7632935889767 -122.48410644406 (37.7632935889767, -122.48410644406) 1 8 3 56 35
69246 45091 Permitted Site 7 Callistemon citrinus :: Lemon Bottlebrush 67 1900 Ortega St 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/08/2001 12:00:00 AM     Permit Number 43969 5988148.79891202 2102403.3041825 37.7521153260597 -122.48388126909 (37.7521153260597, -122.48388126909) 1 8 3 56 35
69282 204442 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2395 16th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     5 Width 3ft   5991351.20232 2099149.48654 37.7433670924093 -122.472569777984 (37.7433670924093, -122.472569777984) 1 8 4 29491 40
69457 38344 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1858 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/29/1998 12:00:00 AM 2   Permit Number 40411 5982279.7422 2102452.6585 37.7519074266581 -122.504180665511 (37.7519074266581, -122.504180665511) 1 8 3 56 35
69510 204431 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2193 18th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5990684.30614 2100474.69239 37.7469671397153 -122.474972424734 (37.7469671397153, -122.474972424734) 1 8 4 29491 40
70535 185602 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2612 Quintara St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   5985366.1309 2100949.2405 37.7479604792755 -122.493396895173 (37.7479604792755, -122.493396895173) 1 8 3 29491 35
71283 69110 Permitted Site 7 Callistemon citrinus :: Lemon Bottlebrush 67 318 Lawton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/10/1994 12:00:00 AM     Permit Number 33125 5993325.06338494 2104621.67061738 37.7585063618762 -122.466142306467 (37.7585063618762, -122.466142306467) 1 8 4 56 12
71885 205719 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 141 Taraval St 18 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5993232.44961 2099151.41057 37.7434810877719 -122.466065100337 (37.7434810877719, -122.466065100337) 1 8 4 59 40
71956 204432 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2193 18th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5990684.91939 2100489.86031 37.7470088224181 -122.474971411208 (37.7470088224181, -122.474971411208) 1 8 4 29491 40
72083 183576 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2000X Vicente St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   5986617 2097562 37.7387331105279 -122.488822549418 (37.7387331105279, -122.488822549418) 1 8 3 29491 35
72152 182820 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1805 30th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   5986876.4726 2102898.6794 37.7534013419725 -122.488317508312 (37.7534013419725, -122.488317508312) 1 8 3 56 35
72818 92935 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 345 West Portal Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     7     5992182.7 2096880.8 37.7371859491769 -122.469529584198 (37.7371859491769, -122.469529584198) 1 8 4 59 40
74335 52816 Permitted Site 7 Callistemon citrinus :: Lemon Bottlebrush 67 201CLAREMONT Granville Way 1 Sidewalk: Curb side : Cutout Tree Private 2   05/30/2006 12:00:00 AM     Permit Number 48842 5994261.61912336 2098704.96828598 37.7423145902485 -122.462474141393 (37.7423145902485, -122.462474141393) 1 8 4 59 40
74914 184965 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2717 34th Ave 1 Sidewalk: Property side : Yard Tree Private 2     9 Width 0ft   5985820.5401 2096898.0233 37.7368634938723 -122.491527432912 (37.7368634938723, -122.491527432912) 1 8 3 29491 35
75076 204406 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1449 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   5994256.18988 2105657.21543 37.761403376491 -122.462997209747 (37.761403376491, -122.462997209747) 1 5 11 56 12
75316 175649 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 0 Cardenas Ave 2 Sidewalk: Property side : Yard Tree Private 2     8 Width 6ft   5990437.61377 2090276.93523 37.7189523892072 -122.47508114108 (37.7189523892072, -122.47508114108) 1 8 4 64 14
76097 64932 Permitted Site 7 Callistemon citrinus :: Lemon Bottlebrush 67 2300 Cecilia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/1989 12:00:00 AM     Permit Number 25960 5991529 2099733 37.7449795602653 -122.471997526068 (37.7449795602653, -122.471997526068) 1 8 4 29491 40
76760 81369 Permitted Site 7 Callistemon citrinus :: Lemon Bottlebrush 67 14 Forest Side Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/22/2011 12:00:00 AM     Permit Number 58731 5992684.22042124 2099043.76352214 37.7431538726351 -122.467952894625 (37.7431538726351, -122.467952894625) 1 8 4 29491 40
76981 182175 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1799X Lawton St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   5988757 2104389 37.7576029019251 -122.481923487166 (37.7576029019251, -122.481923487166) 1 8 3 56 35
77543 217670 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 226 West Portal Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   5992511.2738 2097412.1217 37.7386638087554 -122.468432209214 (37.7386638087554, -122.468432209214) 1 8 4 59 40
77612 183527 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2554 28th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5987715.4408 2097895.579 37.7397130743363 -122.485049174462 (37.7397130743363, -122.485049174462) 1 8 3 29491 35
77917 204413 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1514 Funston Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5992153.58389 2105133.64083 37.7598444403763 -122.47023105232 (37.7598444403763, -122.47023105232) 1 8 4 56 12
78218 42900 Permitted Site 7 Callistemon citrinus :: Lemon Bottlebrush 67 2200 Wawona St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/03/2000 12:00:00 AM     Permit Number 42815 5986138.5427207 2097288.78551671 37.737955001906 -122.490456711772 (37.737955001906, -122.490456711772) 1 8 3 29491 35
78233 204489 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 40 Linares Ave 1 Sidewalk: Curb side : Yard Tree Private 2     12 Width 3ft   5993983.90794 2102212.50861 37.7519294117375 -122.463688890928 (37.7519294117375, -122.463688890928) 1 8 4 29491 40
78537 204463 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 370 Magellan Ave 1 Sidewalk: Curb side : Yard Tree Private 2     11 Width 3ft   5993952.25362 2099683.32037 37.7449830787995 -122.463614813792 (37.7449830787995, -122.463614813792) 1 8 4 29491 40
79648 205752 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 200x Terrace Dr 33 Median : Yard Tree DPW 1     5     5993857.73884 2096475.3667 37.7361693944936 -122.463708837915 (37.7361693944936, -122.463708837915) 1 8 4 59 40
80478 43619 Permitted Site 7 Callistemon citrinus :: Lemon Bottlebrush 67 2095 35th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/20/2000 12:00:00 AM     Permit Number 43271 5985386.76911027 2100967.4929928 37.7480118028434 -122.493326874686 (37.7480118028434, -122.493326874686) 1 8 3 29491 35
81000 204439 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2470 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5991101.64507 2098607.15168 37.7418635320852 -122.473393126203 (37.7418635320852, -122.473393126203) 1 8 4 29491 40
81070 256613 Planning Code 138.1 required 2 Callistemon citrinus :: Lemon Bottlebrush 67 2214 36th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/13/2018 12:00:00 AM 3 3x3 Permit Number 781468 5985177 2100108 37.745639596763 -122.493988903155 (37.745639596763, -122.493988903155) 1 8 3 29491 35
81610 217706 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 159 West Portal Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   5992788.0796 2097577.4127 37.7391336410629 -122.467487171016 (37.7391336410629, -122.467487171016) 1 8 4 59 40
81863 42874 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2366 33rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/03/2000 12:00:00 AM 5   Permit Number 42798 5986118.9683 2099141.5396 37.7430410269224 -122.490660668299 (37.7430410269224, -122.490660668299) 1 8 3 29491 35
82160 204445 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2300 Santiago St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5991529.26816 2099752.44735 37.7450329732008 -122.471998016001 (37.7450329732008, -122.471998016001) 1 8 4 29491 40
82190 184899 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 3136 Noriega St 6 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5984158.9984 2102960.4604 37.7534120503685 -122.497719523191 (37.7534120503685, -122.497719523191) 1 8 3 56 35
82574 204466 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 350 Magellan Ave 1 Sidewalk: Curb side : Yard Tree Private 2     5 Width 3ft   5994033.29677 2099756.91004 37.7451898068672 -122.463339922497 (37.7451898068672, -122.463339922497) 1 8 4 29491 40
82681 184456 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2150 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5982348.1034 2100464.5996 37.7464527920087 -122.503797042944 (37.7464527920087, -122.503797042944) 1 8 3 29491 35
83428 104905 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 419 Gonzalez Dr 1 Sidewalk: Curb side : Yard Tree Private 2           5990435 2090585 37.7197981072685 -122.475112652722 (37.7197981072685, -122.475112652722) 1 8 4 64 40
83794 181889 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2335 34th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   5985755.9263 2099311.3427 37.7434860472782 -122.491928449962 (37.7434860472782, -122.491928449962) 1 8 3 29491 35
84118 217639 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 333 West Portal Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5992202.9099 2096982.0539 37.7374651348279 -122.469467078344 (37.7374651348279, -122.469467078344) 1 8 4 59 40
84236 205694 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 788 Santiago St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   5990530.51036 2099765.70343 37.7450115261664 -122.47545247388 (37.7450115261664, -122.47545247388) 1 8 4 29491 40
85023 205680 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 125 Lomita Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5991377.35775 2104442.29027 37.7579012671485 -122.472865199883 (37.7579012671485, -122.472865199883) 1 8 4 56 12
85157 120543 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 2195 18th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   5990654 2100514 37.7470733117967 -122.475080088588 (37.7470733117967, -122.475080088588) 1 8 4 29491 40
85739 222230 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 8 Aquavista Way 2 : Tree Private 2     5 Width 3ft   5998088.24008 2101938.03895 37.7514114319011 -122.449475816475 (37.7514114319011, -122.449475816475) 1 5 4 63 38
86371 39816 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2135 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/1999 12:00:00 AM 3   Permit Number 41147 5982300.3859 2100562.0651 37.746717599317 -122.503969259712 (37.746717599317, -122.503969259712) 1 8 3 29491 35
86867 104902 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 332 Gonzalez Dr 1 Sidewalk: Curb side : Yard Tree Private 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
86953 183449 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2505 32nd Ave 1 Sidewalk: Curb side : Yard Tree Private 2     3 Width 0ft   5986419.2263 2098176.9478 37.740410049759 -122.48955155596 (37.740410049759, -122.48955155596) 1 8 3 29491 35

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