trees
3,267 rows where qSpecies_id = 67
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17982 | 222370 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 474 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6003587.51416 | 2105510.95685 | 37.7615348690537 | -122.430713623055 | (37.7615348690537, -122.430713623055) | 15 | 4 | 5 | 28862 | 3 | |||
| 18096 | 222289 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 414 Jarboe Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008310.20149 | 2096947.01161 | 37.7382866279206 | -122.413773947135 | (37.7382866279206, -122.413773947135) | 2 | 7 | 7 | 28859 | 2 | |||
| 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 | ||||
| 18204 | 125749 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2672 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6000224.25426 | 2118193.8188 | 37.7961676486817 | -122.443256684343 | (37.7961676486817, -122.443256684343) | 13 | 9 | 1 | 57 | 17 | |||
| 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 | |||
| 18312 | 220994 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 610 Clipper St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6001267.97032 | 2100902.17536 | 37.7487485824887 | -122.438405750225 | (37.7487485824887, -122.438405750225) | 2 | 4 | 5 | 28862 | 22 | |||
| 18314 | 204568 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 61 Burnside Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6001187.03477 | 2095752.39336 | 37.7346038888419 | -122.438316738047 | (37.7346038888419, -122.438316738047) | 2 | 7 | 5 | 63 | 7 | ||||
| 18481 | 37776 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 449 Felton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/06/1998 12:00:00 AM | Permit Number 40114 | 6009618.93348363 | 2093468.47161568 | 37.7288087098037 | -122.409003606238 | (37.7288087098037, -122.409003606238) | 10 | 3 | 7 | 309 | 28 | ||
| 18488 | 9093 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5700 Geary Blvd | 6 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5989210.8329 | 2112629.8539 | 37.7802564116082 | -122.48095732695 | (37.7802564116082, -122.48095732695) | 11 | 6 | 2 | 55 | 26 | |||
| 18532 | 205861 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 78 Montana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 1ft | 5996047.17386 | 2089324.02533 | 37.7166594390586 | -122.455622364282 | (37.7166594390586, -122.455622364282) | 9 | 8 | 6 | 28861 | 24 | |||
| 18558 | 220932 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 56 Mirabel Ave | 1 | Front Yard : Cutout | Tree | DPW 1 | 3 | 3x3 | Permit Number 785183 | 6007687.03242 | 2099968.45973 | 37.7465478380206 | -122.416142489803 | (37.7465478380206, -122.416142489803) | 2 | 7 | 7 | 28859 | 2 | ||
| 18810 | 222355 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3723 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6003572.59677 | 2103006.45022 | 37.7546572452572 | -122.430586499386 | (37.7546572452572, -122.430586499386) | 2 | 4 | 5 | 28862 | 22 | |||
| 18815 | 199909 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1335 Shafter Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 11 | Width 0ft | 6016305.1286 | 2093102.5016 | 37.7281761084423 | -122.385863268846 | (37.7281761084423, -122.385863268846) | 10 | 3 | 8 | 58 | 1 | |||
| 18867 | 53701 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2656 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/18/1970 12:00:00 AM | 12 | Permit Number 6647 | 5999210.43552 | 2117936.02801 | 37.7954019613927 | -122.446746130351 | (37.7954019613927, -122.446746130351) | 13 | 9 | 1 | 57 | 17 | ||
| 18975 | 220935 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 155 Appleton Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006002.55434 | 2096896.9185 | 37.7380192208112 | -122.421749109831 | (37.7380192208112, -122.421749109831) | 2 | 7 | 7 | 28859 | 2 | |||
| 19003 | 188986 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 98 Maddux Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6012667.64033 | 2095215.60548 | 37.7337762895405 | -122.398586505788 | (37.7337762895405, -122.398586505788) | 10 | 3 | 8 | 58 | 1 | |||
| 19025 | 222376 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 468 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6002942.3584 | 2105536.15659 | 37.7615674892747 | -122.4329467503 | (37.7615674892747, -122.4329467503) | 15 | 4 | 5 | 28862 | 3 | |||
| 19054 | 261690 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 181 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004415 | 2097502 | 37.7395909842107 | -122.427281162901 | (37.7395909842107, -122.427281162901) | 2 | 7 | 5 | 63 | 7 | ||||
| 19238 | 220864 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3902 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6004445.39995 | 2100759.97843 | 37.7485383641568 | -122.427408084817 | (37.7485383641568, -122.427408084817) | 2 | 4 | 5 | 28862 | 22 | |||
| 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 | |||
| 19471 | 188996 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1770 La Salle Ave | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6014669.28207 | 2096840.44612 | 37.7383490822538 | -122.391779751256 | (37.7383490822538, -122.391779751256) | 10 | 3 | 8 | 58 | 1 | |||
| 19591 | 264707 | Private 9 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4345 Clement St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 09/17/2020 12:00:00 AM | 3 | 5982064.28374 | 2113052.50483 | 37.7809988756405 | -122.505711450059 | (37.7809988756405, -122.505711450059) | 11 | 6 | 2 | 55 | 26 | |||
| 19634 | 53513 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1370 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1973 12:00:00 AM | 11 | Permit Number 12550 | 6015991.6954 | 2093066.1456 | 37.7280589319949 | -122.386944294451 | (37.7280589319949, -122.386944294451) | 10 | 3 | 8 | 58 | 1 | ||
| 19656 | 125824 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2210 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6004068.4927 | 2116354.72552 | 37.7913364249795 | -122.429823600886 | (37.7913364249795, -122.429823600886) | 13 | 9 | 1 | 29490 | 27 | |||
| 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 | ||||
| 19708 | 2726 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2211 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002817.4873 | 2114756.5606 | 37.7868773504916 | -122.434037754471 | (37.7868773504916, -122.434037754471) | 13 | 9 | 11 | 29490 | 27 | |||
| 19761 | 222251 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 579 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008186.23233 | 2096156.66605 | 37.7361095491164 | -122.414146672953 | (37.7361095491164, -122.414146672953) | 2 | 7 | 7 | 28859 | 2 | |||
| 19762 | 123002 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 22 07th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5993654.52362 | 2115347.42219 | 37.7879754176374 | -122.465782182912 | (37.7879754176374, -122.465782182912) | 11 | 6 | 1 | 54 | 11 | |||
| 19793 | 204525 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 400x Marietta Dr | 35 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 5999144.59173 | 2097002.17091 | 37.7379191001944 | -122.44546796079 | (37.7379191001944, -122.44546796079) | 9 | 7 | 4 | 59 | 40 | |||
| 19821 | 4865 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 32 Crags Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/14/1992 12:00:00 AM | 35 | 3X3 | 6000909.0364823 | 2098039.6345395 | 37.7408683019977 | -122.439441771578 | (37.7408683019977, -122.439441771578) | 2 | 7 | 5 | 63 | 7 | ||
| 19837 | 200793 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1574 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6015536.4716 | 2095847.5097 | 37.7356707824742 | -122.388712112413 | (37.7356707824742, -122.388712112413) | 10 | 3 | 8 | 58 | 1 | |||
| 19859 | 204521 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 400x Marietta Dr | 41 | Median : Cutout | Tree | DPW 1 | 15 | Width 3ft | 5999107.98616 | 2096985.95215 | 37.7378724775396 | -122.445593357764 | (37.7378724775396, -122.445593357764) | 9 | 7 | 4 | 59 | 40 | |||
| 19862 | 32496 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 631 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/15/1996 12:00:00 AM | 9 | Permit Number 37001 | 6007448.1287 | 2095989.14143 | 37.7356080772339 | -122.416686739725 | (37.7356080772339, -122.416686739725) | 2 | 7 | 7 | 28859 | 2 | |
| 19893 | 115197 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4400 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/2016 12:00:00 AM | Permit Number 774514 | 6001219.3 | 2101182.5 | 37.7495155185031 | -122.438594134479 | (37.7495155185031, -122.438594134479) | 2 | 4 | 5 | 28862 | 22 | |||
| 20025 | 200070 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1531 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6015257.2685 | 2093882.9208 | 37.7302609400431 | -122.389540272139 | (37.7302609400431, -122.389540272139) | 10 | 3 | 8 | 58 | 1 | |||
| 20102 | 123930 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 211 09th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5993036.60641 | 2114007.84585 | 37.7842616458582 | -122.467822579411 | (37.7842616458582, -122.467822579411) | 11 | 6 | 2 | 54 | 11 | |||
| 20134 | 121874 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 198 18th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 5990255.88241 | 2114155.38481 | 37.7845057863421 | -122.477453587346 | (37.7845057863421, -122.477453587346) | 11 | 6 | 2 | 55 | 26 | |||
| 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 | |||
| 20306 | 121801 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1235 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3x3 | 6008572.2717 | 2110960.39862 | 37.7767789137416 | -122.413858829626 | (37.7767789137416, -122.413858829626) | 8 | 2 | 9 | 28853 | 34 | |||
| 20326 | 125762 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2399 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6001485.39053 | 2119019.34574 | 37.7985061611824 | -122.438952098255 | (37.7985061611824, -122.438952098255) | 13 | 9 | 1 | 57 | 17 | |||
| 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 | |||
| 20386 | 49124 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 235 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/14/2003 12:00:00 AM | Permit Number 46255 | 5992667.25802575 | 2095222.38841823 | 37.7326603583325 | -122.467733682241 | (37.7326603583325, -122.467733682241) | 9 | 8 | 4 | 59 | 40 | ||
| 20480 | 222416 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 35 Diamond St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6001716.41483 | 2105639.1941 | 37.7617807931825 | -122.437194157484 | (37.7617807931825, -122.437194157484) | 15 | 4 | 5 | 28862 | 3 | |||
| 20497 | 2478 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2303X Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6003659.52132 | 2115878.15996 | 37.7900047293604 | -122.431204600475 | (37.7900047293604, -122.431204600475) | 13 | 9 | 1 | 29490 | 27 | |||
| 20542 | 247885 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 387 Mayflower St | 6 | Side Yard : Yard | Tree | Private 2 | 11 | 6009895.87707 | 2098407.02536 | 37.7423844301873 | -122.408394391499 | (37.7423844301873, -122.408394391499) | 10 | 7 | 7 | 28859 | 2 | ||||
| 20579 | 175642 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 275 De Long St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 10ft | 5993719.3869 | 2086798.38844 | 37.709590783961 | -122.463485117168 | (37.709590783961, -122.463485117168) | 9 | 8 | 6 | 28861 | 25 | |||
| 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 | |||
| 20625 | 188952 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1727 La Salle Ave | 1 | : | Tree | Private 2 | 12 | Width 3ft | 6014856.84284 | 2096629.67768 | 37.7377807655571 | -122.391116524617 | (37.7377807655571, -122.391116524617) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 20794 | 60190 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1235 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/18/1982 12:00:00 AM | 10 | Permit Number 19735 | 6008544.7327 | 2110936.08659 | 37.776710612043 | -122.413952375309 | (37.776710612043, -122.413952375309) | 8 | 2 | 9 | 28853 | 34 | ||
| 20911 | 188282 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 11 Rosie Lee Ln | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6018083.14168 | 2094370.92156 | 37.731757175754 | -122.379804637898 | (37.731757175754, -122.379804637898) | 10 | 3 | 8 | 58 | 1 | |||
| 20971 | 9178 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 6100 Geary Blvd | 6 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5987973.0454 | 2112592.9065 | 37.7800829358976 | -122.485236638901 | (37.7800829358976, -122.485236638901) | 11 | 6 | 2 | 55 | 26 | |||
| 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 | |||
| 21122 | 125778 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 20 Heather Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 5997378.69619 | 2114327.82413 | 37.7853899906986 | -122.452823661499 | (37.7853899906986, -122.452823661499) | 15 | 6 | 1 | 54 | 31 | |||
| 21131 | 220820 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 101 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6005416.76341 | 2103047.49805 | 37.7548742543519 | -122.42421178725 | (37.7548742543519, -122.42421178725) | 2 | 4 | 5 | 28859 | 19 | |||
| 21332 | 16375 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1400X Montgomery St | 8 | Median : Cutout | Tree | DPW 1 | 12 | 8 | 6011455.2971485 | 2120087.0441833 | 37.8020000032358 | -122.404528131508 | (37.8020000032358, -122.404528131508) | 3 | 1 | 10 | 308 | 23 | |||
| 21349 | 200220 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1151 Hollister Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6014047.4712 | 2090254.411 | 37.7202306272165 | -122.393468896776 | (37.7202306272165, -122.393468896776) | 10 | 3 | 8 | 58 | 1 | |||
| 21381 | 8899 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4400 Geary Blvd | 3 | Median : Cutout | Tree | DPW 1 | 3 | M6 | 5993420.4630402 | 2112810.6467907 | 37.7809966203952 | -122.466407540491 | (37.7809966203952, -122.466407540491) | 11 | 6 | 2 | 54 | 11 | |||
| 21490 | 222211 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 998 Chenery St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001126.04303 | 2096135.59352 | 37.7356525981802 | -122.43855505387 | (37.7356525981802, -122.43855505387) | 2 | 7 | 5 | 63 | 7 | |||
| 21567 | 25601 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1425 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6009396.61831 | 2097480.31655 | 37.7398119185732 | -122.410055276551 | (37.7398119185732, -122.410055276551) | 10 | 7 | 7 | 28859 | 2 | |||
| 21606 | 31808 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 90 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 8 | Permit Number 35278 | 6001963.06642 | 2108140.07721 | 37.7686616230583 | -122.436520096744 | (37.7686616230583, -122.436520096744) | 15 | 5 | 5 | 29492 | 3 | |
| 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 | ||||
| 21676 | 9094 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5700 Geary Blvd | 7 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5989203.8431 | 2112625.0148 | 37.7802427184836 | -122.480981153199 | (37.7802427184836, -122.480981153199) | 11 | 6 | 2 | 55 | 26 | |||
| 21698 | 222228 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5735 Diamond Heights Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 8ft | 6000718.4413 | 2097027.59574 | 37.7380786327218 | -122.440028227017 | (37.7380786327218, -122.440028227017) | 2 | 7 | 5 | 63 | 7 | |||
| 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 | |||
| 21768 | 43501 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 401 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2000 12:00:00 AM | Permit Number 43180 | 6008272.42807324 | 2096955.00828501 | 37.7383064636933 | -122.413905114955 | (37.7383064636933, -122.413905114955) | 2 | 7 | 7 | 28859 | 2 | ||
| 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 | ||
| 21786 | 35811 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 51 Sycamore St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/1998 12:00:00 AM | Permit Number 39051 | 6006563.61712831 | 2105830.66384173 | 37.7625808703221 | -122.420443179735 | (37.7625808703221, -122.420443179735) | 8 | 4 | 7 | 28859 | 19 | ||
| 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 | |||
| 22003 | 125776 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 25 Heather Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 5997332.30363 | 2114303.61712 | 37.7853208661167 | -122.452982417028 | (37.7853208661167, -122.452982417028) | 15 | 6 | 1 | 54 | 31 | |||
| 22032 | 35268 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 27 Dawnview Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | Permit Number 38752 | 5998816.18300655 | 2100713.49368513 | 37.7480907448375 | -122.446870407724 | (37.7480907448375, -122.446870407724) | 2 | 5 | 5 | 63 | 38 | ||
| 22061 | 119944 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 378 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 1ft | 5986559.93935 | 2113398.94352 | 37.7822136625365 | -122.49018445318 | (37.7822136625365, -122.49018445318) | 11 | 6 | 2 | 55 | 26 | |||
| 22105 | 175678 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 147 Trumbull St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6004344.1962 | 2094346.31946 | 37.7309221929871 | -122.42730123817 | (37.7309221929871, -122.42730123817) | 9 | 7 | 6 | 28861 | 5 | |||
| 22168 | 188924 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2001 25th St | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 8ft | 6012576.69697 | 2101839.95145 | 37.7519602710713 | -122.399365809709 | (37.7519602710713, -122.399365809709) | 10 | 3 | 8 | 28856 | 29 | |||
| 22190 | 222467 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 222 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6004131.97597 | 2097627.84522 | 37.7399205162221 | -122.428268704549 | (37.7399205162221, -122.428268704549) | 2 | 7 | 5 | 63 | 7 | |||
| 22346 | 93056 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 145 Woodland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 2.5x8 | 5996969.6 | 2105856.9 | 37.7621075834522 | -122.453627125583 | (37.7621075834522, -122.453627125583) | 15 | 5 | 11 | 29492 | 12 | |||
| 22395 | 142555 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 680 Francisco St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6008015.0924 | 2121019.6955 | 37.8043679690114 | -122.4164990059 | (37.8043679690114, -122.4164990059) | 5 | 1 | 10 | 308 | 32 | |||
| 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 | |||
| 22495 | 204586 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 231 Edna St | 2 | Side Yard : Yard | Tree | Private 2 | 14 | 5998760.41171 | 2095319.00684 | 37.7332755919857 | -122.446675184631 | (37.7332755919857, -122.446675184631) | 9 | 7 | 4 | 59 | 40 | ||||
| 22678 | 199908 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1216 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6017309.9205 | 2093127.3901 | 37.7283000004206 | -122.382391361643 | (37.7283000004206, -122.382391361643) | 10 | 3 | 8 | 58 | 1 | |||
| 22729 | 125756 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2495 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001066.19876 | 2118613.86954 | 37.7973689711697 | -122.440373533438 | (37.7973689711697, -122.440373533438) | 13 | 9 | 1 | 57 | 17 | |||
| 22792 | 175701 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 150 Yale St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | Width 3ft | 6007087.6481 | 2092939.47489 | 37.7272140768676 | -122.417716969765 | (37.7272140768676, -122.417716969765) | 9 | 3 | 7 | 309 | 5 | |||
| 22795 | 55186 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 352 Thornton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/31/1972 12:00:00 AM | 13 | Permit Number 11096 | 6013396.91313 | 2094278.12637 | 37.7312427671323 | -122.395999500683 | (37.7312427671323, -122.395999500683) | 10 | 3 | 8 | 58 | 1 | ||
| 22832 | 4862 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 22 Crags Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3x3 | 6000700.354 | 2098195.46944 | 37.7412843093321 | -122.440174488273 | (37.7412843093321, -122.440174488273) | 2 | 7 | 5 | 63 | 7 | |||
| 22850 | 4230 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3987 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004020.01969 | 2100398.84161 | 37.7475226986238 | -122.428853300761 | (37.7475226986238, -122.428853300761) | 2 | 4 | 5 | 63 | 22 | |||
| 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 | |
| 23198 | 21529 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1300 Sutter St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 6006199.49469 | 2114932.42153 | 37.7875515759816 | -122.422349271528 | (37.7875515759816, -122.422349271528) | 13 | 9 | 1 | 28858 | 41 | |||
| 23213 | 188987 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 305 Bridgeview Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 6012918.63111 | 2094968.59879 | 37.7331120403799 | -122.397701430785 | (37.7331120403799, -122.397701430785) | 10 | 3 | 8 | 58 | 1 | |||
| 23237 | 114665 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 480 Myra Way | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5997245.35324946 | 2096954.8836892 | 37.737680654694 | -122.452031115145 | (37.737680654694, -122.452031115145) | 9 | 7 | 4 | 59 | 40 | ||||
| 23298 | 4375 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1035 Chenery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6000885.93841 | 2096177.1796 | 37.7357531225975 | -122.43938816603 | (37.7357531225975, -122.43938816603) | 2 | 7 | 5 | 63 | 7 | |||
| 23301 | 121802 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1235 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 6008587.55783 | 2110975.09573 | 37.776820126979 | -122.413806990012 | (37.776820126979, -122.413806990012) | 8 | 2 | 9 | 28853 | 34 | ||||
| 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 | ||||
| 23330 | 188972 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 55 Vesta St | 1 | : | Tree | Private 2 | 15 | Width 3ft | 6012266.05718 | 2094101.57422 | 37.7306950098702 | -122.399896704685 | (37.7306950098702, -122.399896704685) | 10 | 3 | 8 | 58 | 1 | |||
| 23377 | 100670 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 680X Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6008043.6 | 2121019.4 | 37.804368760788 | -122.41640033173 | (37.804368760788, -122.41640033173) | 5 | 1 | 10 | 308 | 32 | |||
| 23402 | 105461 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1118 WALLER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6000021.8 | 2108530.5 | 37.7696231224597 | -122.443262808274 | (37.7696231224597, -122.443262808274) | 15 | 5 | 11 | 29492 | 9 | |||
| 23405 | 30475 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 424 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/1956 12:00:00 AM | 8 | Permit Number 123 | 6010870.8148 | 2119673.484 | 37.8008317865696 | -122.406521568491 | (37.8008317865696, -122.406521568491) | 3 | 1 | 10 | 308 | 23 | ||
| 23424 | 188870 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1300x De Haro St | 30 | Median : Yard | Tree | DPW 1 | 15 | 6012283.09076 | 2102020.40062 | 37.7524393767806 | -122.400393822023 | (37.7524393767806, -122.400393822023) | 10 | 3 | 8 | 28856 | 29 | ||||
| 23425 | 222331 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4335 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001694.76804 | 2101151.85746 | 37.749458417373 | -122.436947761251 | (37.749458417373, -122.436947761251) | 2 | 4 | 5 | 28862 | 22 | |||
| 23457 | 8744 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3300 Geary Blvd | 9 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5996964.8998051 | 2112982.2523578 | 37.7816716864396 | -122.454158044121 | (37.7816716864396, -122.454158044121) | 11 | 6 | 1 | 54 | 31 |
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) );