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)
188 112351 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 150 WEST PORTAL AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5992711 2097652 37.7393339885882 -122.467759098278 (37.7393339885882, -122.467759098278) 1 8 4 59 40
1234 74480 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 4045 Kirkham St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     5982259.5223 2104870.2558 37.7585442772343 -122.504429677037 (37.7585442772343, -122.504429677037) 1 8 3 56 35
1528 70442 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 200 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/26/2017 12:00:00 AM 3   Permit Number 780711 5983049.5384 2098315.9426 37.7405943893559 -122.501212699104 (37.7405943893559, -122.501212699104) 1 8 3 29491 35
2877 79593 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2407 Lincoln Way 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3     5988231.6107 2107115.9609 37.7650598247176 -122.483940431534 (37.7650598247176, -122.483940431534) 1 8 3 56 35
3122 74788 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 4045 Kirkham St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     5982233.8553 2104870.2558 37.758542767533 -122.504518443568 (37.758542767533, -122.504518443568) 1 8 3 56 35
3452 74635 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 4045 Kirkham St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     5982248.2166 2104869.6447 37.7585419343481 -122.504468731299 (37.7585419343481, -122.504468731299) 1 8 3 56 35
4132 78489 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 3345 Ocean Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     5988664.39778 2095197.91873 37.7323612287764 -122.481570599508 (37.7323612287764, -122.481570599508) 1 8 4 64 35
4569 104897 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 303 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
4981 205652 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1775 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   5990895.94718 2103333.51095 37.7548289707846 -122.474449189277 (37.7548289707846, -122.474449189277) 1 8 4 56 12
5826 78490 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 3345 Ocean Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     5988631.47552 2095196.82107 37.7323563004975 -122.481684337683 (37.7323563004975, -122.481684337683) 1 8 4 64 35
6938 182118 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2469 27th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   5987956.2603 2098511.3982 37.7414179765176 -122.484261685541 (37.7414179765176, -122.484261685541) 1 8 3 29491 35
6980 43621 Permitted Site 7 Callistemon citrinus :: Lemon Bottlebrush 67 2095 35th Ave 1 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
7254 204421 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1890 10th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5993170.3661 2102643.88053 37.7530669363127 -122.466533561676 (37.7530669363127, -122.466533561676) 1 8 4 56 12
7445 205695 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2236 18th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5990740.52284 2100154.10993 37.7460901613437 -122.47475463951 (37.7460901613437, -122.47475463951) 1 8 4 29491 40
8239 259577 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 300 Public Park 3 Unaccepted Street : Cutout Tree Private 2       4x4   5994278 2098760 37.7424666368704 -122.462421492412 (37.7424666368704, -122.462421492412) 1 8 4 59 40
8568 181638 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2520 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   5987970.1096 2106478.8633 37.7632953023912 -122.484798147384 (37.7632953023912, -122.484798147384) 1 8 3 56 35
8725 60817 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1150 Quintara St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/28/1983 12:00:00 AM 3   Permit Number 20495 5989806.3915 2101102.4889 37.7486399870467 -122.478054033081 (37.7486399870467, -122.478054033081) 1 8 3 29491 35
9709 31362 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2295 17th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/21/1995 12:00:00 AM 4   Permit Number 34969 5991015.94012 2099809.33155 37.7451594448661 -122.47377714392 (37.7451594448661, -122.47377714392) 1 8 4 29491 40
9815 204454 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 250 Wawona St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   5992342.47482 2097596.2365 37.7391595899374 -122.469029226223 (37.7391595899374, -122.469029226223) 1 8 4 59 40
10882 32604 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1327 35th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/23/1996 12:00:00 AM 6   Permit Number 37070 5985214.1986 2106157.4162 37.7622518049359 -122.494306102635 (37.7622518049359, -122.494306102635) 1 8 3 56 35
12081 69044 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1426 39th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/1994 12:00:00 AM 2   Permit Number 33051 5984041.3218 2105444.0326 37.7602243472537 -122.498309886187 (37.7602243472537, -122.498309886187) 1 8 3 56 35
12167 259578 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 350 Public Park 1 Unaccepted Street : Cutout Tree Private 2       3x3   5994424 2098888 37.7428264992104 -122.461925951337 (37.7428264992104, -122.461925951337) 1 8 4 59 40
12234 112475 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1799X Lawton St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   5988753.5421 2104412.2034 37.7576664111078 -122.481937145542 (37.7576664111078, -122.481937145542) 1 8 3 56 35
12868 111864 Significant Tree 6 Callistemon citrinus :: Lemon Bottlebrush 67 45 Allston Way 1 Front Yard : Yard Tree Private 2   06/26/2015 12:00:00 AM 3   Permit Number 775591 5994228.4 2098418 37.7415247340782 -122.462568190827 (37.7415247340782, -122.462568190827) 1 8 4 59 40
13824 101104 Permitted Site 7 Callistemon citrinus :: Lemon Bottlebrush 67 1580 Noriega St 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 25190 5989126.9 2103185.1 37.754318820325 -122.480556110859 (37.754318820325, -122.480556110859) 1 8 3 56 35
14482 175650 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 0 Cardenas Ave 3 Sidewalk: Property side : Yard Tree Private 2     7 Width 6ft   5990453.87404 2090277.74723 37.7189555611377 -122.475024995517 (37.7189555611377, -122.475024995517) 1 8 4 64 14
14928 120545 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 2195 18th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5990654 2100514 37.7470733117967 -122.475080088588 (37.7470733117967, -122.475080088588) 1 8 4 29491 40
15197 205713 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 141 Taraval St 12 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5993198.15008 2099148.55003 37.7434712545842 -122.466183490689 (37.7434712545842, -122.466183490689) 1 8 4 59 40
15293 78417 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 3345 Ocean Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     5988680.63361 2095198.47268 37.7323636938327 -122.481514509695 (37.7323636938327, -122.481514509695) 1 8 4 64 35
15396 71222 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2207 28th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     5987585.8685 2100255.6538 37.746185666387 -122.485670338512 (37.746185666387, -122.485670338512) 1 8 3 29491 35
17307 74930 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 4045 Kirkham St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     5982222.2441 2104869.0336 37.7585387287405 -122.50455850909 (37.7585387287405, -122.50455850909) 1 8 3 56 35
17592 205706 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 141 Taraval St 5 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5993174.64326 2099144.25251 37.7434580984164 -122.466264458435 (37.7434580984164, -122.466264458435) 1 8 4 59 40
18175 259579 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 398 Public Park 1 Unaccepted Street : Cutout Tree Private 2       3x3   5994369 2098919 37.7429084509163 -122.462118372119 (37.7429084509163, -122.462118372119) 1 8 4 59 40
18263 182776 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1588 Noriega St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   5989115.047 2103129.9656 37.754166747114 -122.480593065279 (37.754166747114, -122.480593065279) 1 8 3 56 35
19318 217698 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 170 West Portal Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   5992683.9237 2097587.0358 37.7391540498051 -122.467847991527 (37.7391540498051, -122.467847991527) 1 8 4 59 40
19661 175653 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 0 Gonzalez Dr 2 Sidewalk: Curb side : Yard Tree Private 2     5     5988966.88544 2089648.46014 37.7171414055178 -122.480118843736 (37.7171414055178, -122.480118843736) 1 8 4 64 14
20172 204460 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 376 Magellan Ave 2 Sidewalk: Curb side : Yard Tree Private 2     12 Width 3ft   5993909.76368 2099645.45971 37.7448766746103 -122.463758987709 (37.7448766746103, -122.463758987709) 1 8 4 29491 40
20370 205716 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 141 Taraval St 15 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5993207.78236 2099148.98665 37.7434730091666 -122.466150216684 (37.7434730091666, -122.466150216684) 1 8 4 59 40
20601 205709 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 141 Taraval St 8 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5993183.34743 2099146.30567 37.7434642380824 -122.466234511037 (37.7434642380824, -122.466234511037) 1 8 4 59 40
20790 182821 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1807 30th Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   5986876.8744 2102880.1943 37.7533506103474 -122.488314760472 (37.7533506103474, -122.488314760472) 1 8 3 56 35
21089 184538 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1939 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   5982255.8834 2101901.5386 37.7503928027278 -122.504222349881 (37.7503928027278, -122.504222349881) 1 8 3 29491 35
21650 218260 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1400x Portola Dr 18 Median : Yard Tree DPW 1     12     5992795.95946 2097207.23373 37.738117677685 -122.46743301504 (37.738117677685, -122.46743301504) 1 8 4 59 40
21707 204401 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1426 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   5994301.11248 2105797.04761 37.7617899068936 -122.462851987244 (37.7617899068936, -122.462851987244) 1 5 11 56 12
21777 66859 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1116 Taraval St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/18/1991 12:00:00 AM 4   Permit Number 30166 5989755.3106 2099063.2795 37.7430378863443 -122.478081600833 (37.7430378863443, -122.478081600833) 1 8 3 29491 35
21896 184581 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1747 38th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     8 Width 0ft   5984379.9879 2103282.638 37.7543096128776 -122.496979084355 (37.7543096128776, -122.496979084355) 1 8 3 56 35
22444 204402 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1426 06th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   5994299.73168 2105778.36459 37.7617385286395 -122.462855407375 (37.7617385286395, -122.462855407375) 1 5 11 56 12
22981 109263 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 3338X Ortega St 2 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
23196 37229 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1866 34th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/12/1998 12:00:00 AM 3   Permit Number 39793 5985694.0439 2102524.3888 37.7523045829279 -122.492378977466 (37.7523045829279, -122.492378977466) 1 8 3 56 35
23306 92939 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 363 West Portal Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     11     5992054.1 2096847.4 37.7370868080983 -122.469971777828 (37.7370868080983, -122.469971777828) 1 8 4 59 40
23868 205774 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 367 Kensington Way 2 Sidewalk: Curb side : Yard Tree Private 2     9 Width 5ft   5994104.03782 2099097.57437 37.7433835122355 -122.463047484554 (37.7433835122355, -122.463047484554) 1 8 4 59 40
24252 112667 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 2550 IRVING ST 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5988170 2106474 37.7632935889767 -122.48410644406 (37.7632935889767, -122.48410644406) 1 8 3 56 35
24325 69162 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1201 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/26/1994 12:00:00 AM 6   Permit Number 33199 5982705.2838 2106882.9636 37.7640968091015 -122.503037064776 (37.7640968091015, -122.503037064776) 1 8 3 56 35
24875 205662 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1598 10th Ave 12 : Tree Private 2     13 Width 2ft   5993106.37013 2104709.96458 37.7587361743455 -122.466905058137 (37.7587361743455, -122.466905058137) 1 8 4 56 12
26162 205755 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 200x Terrace Dr 36 Median : Yard Tree DPW 1     5     5993878.86602 2096471.77214 37.7361607421118 -122.463635532375 (37.7361607421118, -122.463635532375) 1 8 4 59 40
26597 205699 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 521 Magellan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5993054.98439 2099411.54148 37.7441851013744 -122.46669763039 (37.7441851013744, -122.46669763039) 1 8 4 29491 40
27096 204488 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 10 Linares Ave 2 Sidewalk: Curb side : Yard Tree Private 2     2 Width 3ft   5993862.27446 2102337.63255 37.7522659605301 -122.464118595998 (37.7522659605301, -122.464118595998) 1 8 4 29491 40
27200 103055 Permitted Site 7 Callistemon citrinus :: Lemon Bottlebrush 67 2301 Noriega St 3 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 29932 5986892 2102979 37.7536227864704 -122.488269714105 (37.7536227864704, -122.488269714105) 1 8 3 56 35
27339 205714 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 141 Taraval St 13 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5993201.34966 2099148.16346 37.7434703777616 -122.46617239935 (37.7434703777616, -122.46617239935) 1 8 4 59 40
27640 217700 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 145 West Portal Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   5992839.5915 2097634.0192 37.7392920421006 -122.467313182652 (37.7392920421006, -122.467313182652) 1 8 4 59 40
28404 184586 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1750 39th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     2 Width 0ft   5984116.0189 2103254.2105 37.7542160870284 -122.497889842793 (37.7542160870284, -122.497889842793) 1 8 3 56 35
28501 205671 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1484 08th Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   5993692.069 2105423.43995 37.7607289793843 -122.464931274665 (37.7607289793843, -122.464931274665) 1 8 11 56 12
28516 217673 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 250 West Portal Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5992428.3453 2097326.3629 37.7384235463081 -122.468712695538 (37.7384235463081, -122.468712695538) 1 8 4 59 40
30362 217834 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2 Cranleigh Dr 25 Front Yard : Yard Tree Private 2     15     5991396.17639 2095791.92324 37.7341506817918 -122.472169581465 (37.7341506817918, -122.472169581465) 1 8 4 64 40
30374 112344 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 40 WEST PORTAL AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5993136 2098044 37.7404348530896 -122.466318130629 (37.7404348530896, -122.466318130629) 1 8 4 59 40
32849 217651 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 24 West Portal Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5993164.2846 2098108.4527 37.7406134559451 -122.466225017178 (37.7406134559451, -122.466225017178) 1 8 4 59 40
32885 205746 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 33 Sotelo Ave 2 Sidewalk: Curb side : Yard Tree Private 2     5 Width 4ft   5993900.499 2101145.11653 37.7489938186198 -122.46389985752 (37.7489938186198, -122.46389985752) 1 8 4 29491 40
33832 62064 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1259 41st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/15/1985 12:00:00 AM 8   Permit Number 22145 5983337.283 2106566.0084 37.7632636666362 -122.500827758091 (37.7632636666362, -122.500827758091) 1 8 3 56 35
34351 183203 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2495 46th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   5982070.7667 2098188.3746 37.7401865975237 -122.504587407891 (37.7401865975237, -122.504587407891) 1 8 3 29491 35
35234 205688 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 452 Santiago St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   5991389.21566 2099787.38325 37.7451207928966 -122.472484834309 (37.7451207928966, -122.472484834309) 1 8 4 29491 40
35507 204487 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 10 Linares Ave 1 Sidewalk: Curb side : Yard Tree Private 2     8 Width 3ft   5993872.61201 2102327.49327 37.7522387164587 -122.464082111418 (37.7522387164587, -122.464082111418) 1 8 4 29491 40
35966 47272 Permitted Site 7 Callistemon citrinus :: Lemon Bottlebrush 67 2407 Lincoln Wy 1 Sidewalk: Curb side : Cutout Tree Private 2   05/09/2002 12:00:00 AM     Permit Number 45213 5988289.74121062 2107116.743846 37.7650653584421 -122.483739432305 (37.7650653584421, -122.483739432305) 1 8 3 56 35
36580 42885 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2546 34th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/03/2000 12:00:00 AM 4   Permit Number 42806 5985850.2562 2097897.6252 37.7396098709906 -122.491498248106 (37.7396098709906, -122.491498248106) 1 8 3 29491 35
36836 182014 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 3210 Ulloa St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   5986047.0537 2098249.2905 37.7405869486166 -122.490843686246 (37.7405869486166, -122.490843686246) 1 8 3 29491 35
36857 101374 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 3136 Noriega St 5 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   5984176.5964 2102959.4451 37.7534102942266 -122.497658591569 (37.7534102942266, -122.497658591569) 1 8 3 56 35
36905 101372 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 3136 Noriega St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   5984213.4843 2102962.4909 37.7534208194067 -122.497531252237 (37.7534208194067, -122.497531252237) 1 8 3 56 35
37414 205669 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1484 08th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   5993692.94816 2105378.30406 37.7606050986717 -122.464924956015 (37.7606050986717, -122.464924956015) 1 8 11 56 12
38082 115170 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2483 41st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/14/2016 12:00:00 AM     Permit Number 775167 5983603.3 2098266.1 37.7404900382804 -122.499294352828 (37.7404900382804, -122.499294352828) 1 8 3 29491 35
39133 49207 Permitted Site 7 Callistemon citrinus :: Lemon Bottlebrush 67 2550 Irving St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2003 12:00:00 AM     Permit Number 46296 5987860.19003089 2106475.09481786 37.7632785526853 -122.485178041739 (37.7632785526853, -122.485178041739) 1 8 3 56 35
40436 69156 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1255 41st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/26/1994 12:00:00 AM 7   Permit Number 33192 5983336.7375 2106596.5609 37.7633475230998 -122.5008319043 (37.7633475230998, -122.5008319043) 1 8 3 56 35
40779 217647 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 369 West Portal Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   5992040.3078 2096816.9044 37.7370022775891 -122.470017243441 (37.7370022775891, -122.470017243441) 1 8 4 59 40
40945 205664 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1598 10th Ave 15 : Tree Private 2     10 Width 2ft   5993105.62585 2104716.92689 37.7587552480768 -122.466908138321 (37.7587552480768, -122.466908138321) 1 8 4 56 12
41239 205748 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 80 Sotelo Ave 1 Sidewalk: Curb side : Yard Tree Private 2     4 Width 4ft   5993792.60369 2101417.15346 37.7497345443361 -122.46429270474 (37.7497345443361, -122.46429270474) 1 8 4 29491 40
41819 204420 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1890 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5993170.71029 2102620.68557 37.753003268792 -122.466530685642 (37.753003268792, -122.466530685642) 1 8 4 56 12
42177 101371 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 3136 Noriega St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   5984231.0823 2102962.1525 37.7534209217472 -122.497470370582 (37.7534209217472, -122.497470370582) 1 8 3 56 35
42240 42884 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2514 34th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/03/2000 12:00:00 AM 4   Permit Number 42805 5985844.8171 2098079.769 37.7401096713575 -122.491530457619 (37.7401096713575, -122.491530457619) 1 8 3 29491 35
42299 222229 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 8 Aquavista Way 1 : Tree Private 2     5 Width 3ft   5998081.93369 2101924.01441 37.7513725632107 -122.44949661419 (37.7513725632107, -122.44949661419) 1 5 4 63 38
42426 218261 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1400x Portola Dr 19 Median : Yard Tree DPW 1     8     5992797.06764 2097201.38756 37.7381016895493 -122.467428758544 (37.7381016895493, -122.467428758544) 1 8 4 59 40
42870 183159 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2343 37th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5984829.5681 2099229.5136 37.7432071768033 -122.495125484028 (37.7432071768033, -122.495125484028) 1 8 3 29491 35
43442 205675 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1118 Ortega St 3 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 2ft   5990487.22136 2102483.87825 37.7524724142928 -122.47580061943 (37.7524724142928, -122.47580061943) 1 8 4 56 12
44502 101373 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 3136 Noriega St 4 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   5984197.9169 2102961.1373 37.7534161902989 -122.497584986841 (37.7534161902989, -122.497584986841) 1 8 3 56 35
44576 185603 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2614 Quintara St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   5985349.3993 2100948.7484 37.7479581493924 -122.493454715247 (37.7479581493924, -122.493454715247) 1 8 3 29491 35
45082 205673 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1118 Ortega St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   5990453.79637 2102486.41595 37.7524774441927 -122.475916392748 (37.7524774441927, -122.475916392748) 1 8 4 56 12
45100 96476 Permitted Site 7 Callistemon citrinus :: Lemon Bottlebrush 67 1306 Noriega St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   5989913.8 2103183.8 37.7543609517796 -122.477834745891 (37.7543609517796, -122.477834745891) 1 8 3 56 35
45273 181937 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2435 32nd Ave 1 Sidewalk: Curb side : Yard Tree Private 2     7 Width 0ft   5986400.8737 2098652.5201 37.7417147730951 -122.489649975211 (37.7417147730951, -122.489649975211) 1 8 3 29491 35
45413 205701 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 76 Taraval St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5993400.01519 2099221.05456 37.7436819783428 -122.465490763583 (37.7436819783428, -122.465490763583) 1 8 4 29491 40
45977 33246 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2455 27th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/13/1996 12:00:00 AM 3   Permit Number 37427 5987953.5529 2098598.711 37.7416575568292 -122.484277448664 (37.7416575568292, -122.484277448664) 1 8 3 29491 35
46012 205690 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 454 Santiago St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5991340.80393 2099785.21659 37.7451120415999 -122.472652074046 (37.7451120415999, -122.472652074046) 1 8 4 29491 40
46292 104895 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 300 Gonzalez Dr   Sidewalk: Curb side : Yard Tree Private 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
46398 65961 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2567 28th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/21/1990 12:00:00 AM 8   Permit Number 28983 5987671.3147 2097818.6015 37.7394991439696 -122.485196095129 (37.7394991439696, -122.485196095129) 1 8 3 29491 35
46492 204451 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 55 Montalvo Ave 1 Sidewalk: Curb side : Yard Tree Private 2     4 Width 3ft   5993550.31491 2099779.96303 37.7452252671363 -122.465011651568 (37.7452252671363, -122.465011651568) 1 8 4 29491 40

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