Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▲ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
77897 | 77897 | 105128 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1835 47TH AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774579 | 5981612.2 | 2102591.6 | 37.752249639902296 | -122.506499383522 | (37.7522496399023, -122.506499383522) | |
16806 | 16806 | 29053 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 340 11th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2005 12:00:00 AM | 3 | 3x3 | 6008751.0689900005 | 2108844.78645 | 37.770979979973 | -122.413090685387 | (37.770979979973, -122.413090685387) | ||
129530 | 129530 | 83758 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1640 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/25/2005 12:00:00 AM | 11 | 6013046.15855 | 2104759.52511 | 37.7600029395994 | -122.39794712017598 | (37.7600029395994, -122.397947120176) | ||
168415 | 168415 | 114958 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 66 Concord St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/2015 12:00:00 AM | 1 | Permit Number 775977 | 5999698.38088 | 2087820.43772 | 37.7127397789845 | -122.44289408849 | (37.7127397789845, -122.44289408849) | ||
16354 | 16354 | 43351 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 385 08th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1977 12:00:00 AM | 26 | 3x3 | Permit Number 43103 | 6010005.031690001 | 2109964.91982 | 37.7741259209126 | -122.408832212936 | (37.7741259209126, -122.408832212936) | |
101427 | 101427 | 63557 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2971 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/20/2011 12:00:00 AM | 4 | 3x3 | Permit Number 768581 | 6008414.60000343 | 2103856.53351654 | 37.75726449571211 | -122.413901624069 | (37.7572644957121, -122.413901624069) |
108073 | 108073 | 102062 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 26 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769724 | 6007185.0 | 2097679.0 | 37.740233252719705 | -122.41771621811701 | (37.7402332527197, -122.417716218117) |
97602 | 97602 | 46107 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 76 Oakwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/2001 12:00:00 AM | Permit Number 44471 | 6005231.58471967 | 2105020.01841489 | 37.7602798751206 | -122.424992522324 | (37.7602798751206, -122.424992522324) | ||
176699 | 176699 | 63185 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 422 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1986 12:00:00 AM | 10 | Permit Number 23724 | 5984714.39169 | 2112987.07257 | 37.7809748328781 | -122.49653872225099 | (37.7809748328781, -122.496538722251) | |
145715 | 145715 | 34952 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 315 Magellan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/1997 12:00:00 AM | Permit Number 38549 | 5994259.00226066 | 2099898.8670043997 | 37.745592585729206 | -122.462569772731 | (37.7455925857292, -122.462569772731) | |||
31708 | 31708 | 64202 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 712 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/1987 12:00:00 AM | 7 | Permit Number 24989 | 6007253.84118 | 2121612.31265 | 37.805952304912296 | -122.41917544799401 | (37.8059523049123, -122.419175447994) | ||
18393 | 18393 | 65663 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 35 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/1991 12:00:00 AM | Permit Number 28583 | 5998824.47448758 | 2095859.96140736 | 37.7347645844735 | -122.44649260756701 | (37.7347645844735, -122.446492607567) | ||
123349 | 123349 | 114804 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2427 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2015 12:00:00 AM | Permit Number 775689 | 5989172.0 | 2098830.2 | 37.742364035662796 | -122.480081453283 | (37.7423640356628, -122.480081453283) | |||
65966 | 65966 | 38554 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1791 La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/10/2005 12:00:00 AM | 6 | Permit Number 40521 | 6014548.21389 | 2096859.31136 | 37.738394160770795 | -122.392199668106 | (37.7383941607708, -122.392199668106) | |
79127 | 79127 | 38555 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1791 La Salle Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/10/2005 12:00:00 AM | 9 | Permit Number 40521 | 6014548.4967 | 2096859.8807700002 | 37.738395739956395 | -122.392198730091 | (37.7383957399564, -122.392198730091) | |
181105 | 181105 | 38556 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1791 La Salle Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/10/2005 12:00:00 AM | 10 | Permit Number 40521 | 6014562.13286 | 2096849.4448099998 | 37.738367842095606 | -122.39215085288001 | (37.7383678420956, -122.39215085288) | |
102050 | 102050 | 62443 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4486 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/1985 12:00:00 AM | Permit Number 22606 | 5999444.95917987 | 2105754.12577185 | 37.7619669848025 | -122.44505845051201 | (37.7619669848025, -122.445058450512) | ||
3012 | 3012 | 222459 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 103 Germania St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1996 12:00:00 AM | 12 | Width 3ft | Permit Number 37768 | 6003745.35961 | 2108826.05534 | 37.7706462694291 | -122.430404237367 | (37.7706462694291, -122.430404237367) | |
66674 | 66674 | 33678 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 447 Ivy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | 5 | Permit Number 37759 | 6005220.1458 | 2111114.8558 | 37.77701418991521 | -122.425465839355 | (37.7770141899152, -122.425465839355) | ||
55646 | 55646 | 63097 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3060 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1986 12:00:00 AM | 11 | Permit Number 23584 | 6001459.2061 | 2118948.46858 | 37.798310061319 | -122.439037622007 | (37.798310061319, -122.439037622007) | ||
13540 | 13540 | 27121 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2335 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/02/2002 12:00:00 AM | 12 | 2x2 | 6013101.69827 | 2096426.31583 | 37.7371248216631 | -122.39717069499599 | (37.7371248216631, -122.397170694996) | ||
103790 | 103790 | 33604 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300 Lily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/1996 12:00:00 AM | Permit Number 37717 | 6005085.63985065 | 2110091.4174031997 | 37.774196476925795 | -122.42585827051 | (37.7741964769258, -122.42585827051) | |||
121991 | 121991 | 33603 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300 Lily St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/1996 12:00:00 AM | Permit Number 37717 | 6005085.63985065 | 2110091.4174031997 | 37.774196476925795 | -122.42585827051 | (37.7741964769258, -122.42585827051) | |||
61475 | 61475 | 114702 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 237 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/01/2015 12:00:00 AM | 1 | Permit Number 774513 | 6006534.54774 | 2092840.44849 | 37.7269110313963 | -122.41962201445 | (37.7269110313963, -122.41962201445) | ||
42132 | 42132 | 55307 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2770 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2012 12:00:00 AM | 2 | Permit Number 769514 | 6005272.5834 | 2119510.27332 | 37.8000688708465 | -122.42588218711 | (37.8000688708465, -122.42588218711) | ||
156463 | 156463 | 68203 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 259 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/1993 12:00:00 AM | 7 | Permit Number 32750 | 5993355.858659999 | 2113766.0024200003 | 37.783616039219 | -122.466700502775 | (37.783616039219, -122.466700502775) | ||
101763 | 101763 | 65575 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 44 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/28/2007 12:00:00 AM | 3x3 | Permit Number 49937 | 6007552.07395288 | 2099897.22885684 | 37.7463446647462 | -122.41660411777 | (37.7463446647462, -122.41660411777) | ||
94198 | 94198 | 33570 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 152 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/1996 12:00:00 AM | Permit Number 37680 | 6007130.56275094 | 2098140.70005851 | 37.741497914840004 | -122.417937161506 | (37.74149791484, -122.417937161506) | |||
113478 | 113478 | 33571 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 152 Bonview St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/1996 12:00:00 AM | Permit Number 37680 | 6007130.56275094 | 2098140.70005851 | 37.741497914840004 | -122.417937161506 | (37.74149791484, -122.417937161506) | |||
123501 | 123501 | 33572 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 154 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/1996 12:00:00 AM | Permit Number 37681 | 6007125.01151204 | 2098130.43275156 | 37.7414694106773 | -122.417955628165 | (37.7414694106773, -122.417955628165) | |||
91328 | 91328 | 61661 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 246 Cambridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/26/1984 12:00:00 AM | Permit Number 21655 | 6006644.56233954 | 2093348.38333355 | 37.7283119065735 | -122.419277711746 | (37.7283119065735, -122.419277711746) | ||
78937 | 78937 | 33548 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 252 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1996 12:00:00 AM | Permit Number 37656 | 6007019.4634549 | 2097570.65263156 | 37.73992643822321 | -122.418280898297 | (37.7399264382232, -122.418280898297) | |||
85805 | 85805 | 33545 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 24 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1996 12:00:00 AM | Permit Number 37653 | 6007172.51039113 | 2097685.46488673 | 37.7402503010209 | -122.417759860395 | (37.7402503010209, -122.417759860395) | |||
104701 | 104701 | 33540 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 213 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1996 12:00:00 AM | Permit Number 37650 | 6007159.19506099 | 2097721.08233602 | 37.7403473492981 | -122.417808423627 | (37.7403473492981, -122.417808423627) | |||
109510 | 109510 | 33541 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 213 BOCANA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1996 12:00:00 AM | Permit Number 37650 | 6007164.0 | 2097722.0 | 37.7403501394021 | -122.417791875043 | (37.7403501394021, -122.417791875043) | |||
148445 | 148445 | 53514 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1382 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1969 12:00:00 AM | 3 | Permit Number 6426 | 6015935.5088 | 2093105.8067 | 37.7281647222543 | -122.38714130029 | (37.7281647222543, -122.38714130029) | ||
91384 | 91384 | 81369 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 14 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2011 12:00:00 AM | Permit Number 58731 | 5992684.22042124 | 2099043.76352214 | 37.743153872635105 | -122.467952894625 | (37.7431538726351, -122.467952894625) | |||
144421 | 144421 | 68791 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2354 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/22/1993 12:00:00 AM | Permit Number 32729 | 5992040.99368144 | 2099415.84247722 | 37.744138340677 | -122.47020406998301 | (37.744138340677, -122.470204069983) | ||
93106 | 93106 | 63069 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 152 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1986 12:00:00 AM | Permit Number 23543 | 6008631.63225831 | 2097862.90988188 | 37.7408195298569 | -122.41272732589199 | (37.7408195298569, -122.412727325892) | ||
67406 | 67406 | 69044 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1426 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1994 12:00:00 AM | 2 | Permit Number 33051 | 5984041.3218 | 2105444.0326 | 37.760224347253704 | -122.498309886187 | (37.7602243472537, -122.498309886187) | |
15178 | 15178 | 67715 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 472 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1992 12:00:00 AM | 8 | 3x3 | Permit Number 31328 | 6013692.95356 | 2112582.14451 | 37.781518105329795 | -122.39625842359399 | (37.7815181053298, -122.396258423594) |
52921 | 52921 | 66871 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 350 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1991 12:00:00 AM | Permit Number 30181 | 6001115.30809688 | 2104289.68730442 | 37.7580411890038 | -122.43917641405001 | (37.7580411890038, -122.43917641405) | ||
54738 | 54738 | 66859 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1116 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/1991 12:00:00 AM | 4 | Permit Number 30166 | 5989755.3106 | 2099063.2795 | 37.7430378863443 | -122.478081600833 | (37.7430378863443, -122.478081600833) | ||
66552 | 66552 | 58086 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3001 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/16/1977 12:00:00 AM | 7 | Permit Number 17057 | 6002870.87342 | 2118942.9328799997 | 37.7983750823084 | -122.434152436312 | (37.7983750823084, -122.434152436312) | ||
33421 | 33421 | 54453 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1305 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/15/1976 12:00:00 AM | 9 | Permit Number 16511 | 6013657.09709 | 2105679.3601599997 | 37.76256261160079 | -122.39589862014 | (37.7625626116008, -122.39589862014) | ||
44731 | 44731 | 57620 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1315 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/15/1976 12:00:00 AM | 7 | Permit Number 16513 | 6013619.85223 | 2105678.11132 | 37.7625571104404 | -122.396027350002 | (37.7625571104404, -122.396027350002) | ||
63356 | 63356 | 57621 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1319 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/15/1976 12:00:00 AM | 6 | Permit Number 16514 | 6013585.69477 | 2105673.1499900003 | 37.7625415872419 | -122.396145141378 | (37.7625415872419, -122.396145141378) | ||
63488 | 63488 | 33246 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2455 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | 3 | Permit Number 37427 | 5987953.5529 | 2098598.711 | 37.7416575568292 | -122.484277448664 | (37.7416575568292, -122.484277448664) | |
89789 | 89789 | 57605 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 250 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/12/1976 12:00:00 AM | 3x3 | Permit Number 26693 | 5999752.23932038 | 2094391.78344807 | 37.7307862598115 | -122.443179604218 | (37.7307862598115, -122.443179604218) | ||
186574 | 186574 | 59349 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 275 Chicago Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/11/1980 12:00:00 AM | 10 | Permit Number 18697 | 6002772.3177 | 2086703.6942599998 | 37.7098482184782 | -122.43218988627399 | (37.7098482184782, -122.432189886274) | ||
140290 | 140290 | 45780 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 646 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2001 12:00:00 AM | Permit Number 44420 | 5990064.86918672 | 2110959.72836088 | 37.775720315974105 | -122.47788072713999 | (37.7757203159741, -122.47788072714) | |||
133054 | 133054 | 55308 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1595 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/1972 12:00:00 AM | 10 | Permit Number 11237 | 6005282.805369999 | 2119544.50402 | 37.800163437253296 | -122.42584925305201 | (37.8001634372533, -122.425849253052) | ||
64490 | 64490 | 67678 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1566 Underwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1992 12:00:00 AM | 11 | Permit Number 31282 | 6014784.0524 | 2093614.4352 | 37.7294974829563 | -122.391157497644 | (37.7294974829563, -122.391157497644) | |
111996 | 111996 | 44097 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 690 De Haro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2000 12:00:00 AM | Permit Number 43610 | 6012084.69063396 | 2105194.13037963 | 37.7611426751013 | -122.401302935991 | (37.7611426751013, -122.401302935991) | |||
138439 | 138439 | 44096 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 690 De Haro St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2000 12:00:00 AM | Permit Number 43610 | 6012084.69063396 | 2105194.13037963 | 37.7611426751013 | -122.401302935991 | (37.7611426751013, -122.401302935991) | |||
78046 | 78046 | 38922 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 758 Lakeview Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/02/1998 12:00:00 AM | Permit Number 40732 | 5994446.73850644 | 2089956.09273845 | 37.7183029732854 | -122.461200022537 | (37.7183029732854, -122.461200022537) | |||
100594 | 100594 | 66255 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 47 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1991 12:00:00 AM | Permit Number 29357 | 5998777.54020022 | 2095889.92461041 | 37.7348441754269 | -122.446657030024 | (37.7348441754269, -122.446657030024) | ||
161907 | 161907 | 66267 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 948 Key Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/1990 12:00:00 AM | 4 | Permit Number 29374 | 6013650.54179 | 2089569.78312 | 37.718328712978895 | -122.394793038594 | (37.7183287129789, -122.394793038594) | ||
86690 | 86690 | 57192 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 896X DOUGLASS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/1974 12:00:00 AM | 3x3 | Permit Number 14472 | 6001277.0 | 2101164.0 | 37.74946800407329 | -122.43839328132299 | (37.7494680040733, -122.438393281323) | ||
8444 | 8444 | 13167 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1906 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1993 12:00:00 AM | 26 | 3X3 | 6003216.0169 | 2119655.6641 | 37.8003516396791 | -122.433009083838 | (37.8003516396791, -122.433009083838) | ||
50323 | 50323 | 55325 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1231 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1972 12:00:00 AM | 11 | Permit Number 11255 | 6011451.82111 | 2089071.0764400002 | 37.7168368689981 | -122.402358088854 | (37.7168368689981, -122.402358088854) | ||
74799 | 74799 | 61035 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 208 Harkness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1972 12:00:00 AM | 13 | Permit Number 20858 | 6011595.89338 | 2089312.04675 | 37.717506566247394 | -122.40187702801 | (37.7175065662474, -122.40187702801) | ||
77122 | 77122 | 55323 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1186 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1972 12:00:00 AM | 18 | Permit Number 11253 | 6011357.40386 | 2089280.46993 | 37.7174065499613 | -122.402699162137 | (37.7174065499613, -122.402699162137) | ||
112466 | 112466 | 55327 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 200 Harkness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1972 12:00:00 AM | Permit Number 11257 | 6011659.22686105 | 2089335.34929904 | 37.717574084708 | -122.401659748875 | (37.717574084708, -122.401659748875) | |||
133561 | 133561 | 55328 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 225 Harkness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1972 12:00:00 AM | 8 | Permit Number 11259 | 6011565.540630001 | 2089256.51546 | 37.717352394562 | -122.40197804257 | (37.717352394562, -122.40197804257) | ||
148983 | 148983 | 55329 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 241 Harkness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1972 12:00:00 AM | 10 | Permit Number 11260 | 6011497.74978 | 2089236.66648 | 37.7172941095093 | -122.402210970564 | (37.7172941095093, -122.402210970564) | ||
187953 | 187953 | 55331 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 245 Harkness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1972 12:00:00 AM | 12 | Permit Number 11262 | 6011470.05429 | 2089227.3008700002 | 37.7172668474735 | -122.402306043313 | (37.7172668474735, -122.402306043313) | ||
187670 | 187670 | 42671 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1115 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2007 12:00:00 AM | 3 | 3x3 | Permit Number 49824 | 6007552.9274699995 | 2119520.43861 | 37.8002253861525 | -122.417992022918 | (37.8002253861525, -122.417992022918) | |
60271 | 60271 | 81857 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 550 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/2007 12:00:00 AM | 2 | 3x3 | Permit Number 49819 | 6013442.188130001 | 2112205.75243 | 37.780470662241996 | -122.39709955769399 | (37.780470662242, -122.397099557694) | |
117782 | 117782 | 66252 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2145 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1990 12:00:00 AM | Permit Number 29353 | 6003919.79626515 | 2107385.50523164 | 37.7667007479345 | -122.42969809853099 | (37.7667007479345, -122.429698098531) | ||
34509 | 34509 | 32604 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1327 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 6 | Permit Number 37070 | 5985214.1986 | 2106157.4162 | 37.7622518049359 | -122.49430610263501 | (37.7622518049359, -122.494306102635) | |
120997 | 120997 | 61052 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 201-203 HEARST AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/1994 12:00:00 AM | 8 | 3x3 | Permit Number 20880 | 6000007.0 | 2094313.0 | 37.7305844621254 | -122.442293205182 | (37.7305844621254, -122.442293205182) |
142810 | 142810 | 68649 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1958 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32554 | 5990677.94928449 | 2102064.97890772 | 37.7513332827559 | -122.47511047971201 | (37.7513332827559, -122.475110479712) | ||
103158 | 103158 | 40956 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 39 Lakewood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/1999 12:00:00 AM | Permit Number 41810 | 5993626.53166315 | 2093066.42761178 | 37.7267959624654 | -122.464260796159 | (37.7267959624654, -122.464260796159) | |||
122530 | 122530 | 68498 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1830 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32374 | 5993468.12743357 | 2103022.1478049 | 37.7541227389181 | -122.46553133105301 | (37.7541227389181, -122.465531331053) | ||
129894 | 129894 | 53400 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2502 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/1969 12:00:00 AM | 10 | Permit Number 6299 | 5990880.06647 | 2112020.40978 | 37.7786799348836 | -122.475138234513 | (37.7786799348836, -122.475138234513) | ||
130937 | 130937 | 32496 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 631 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | 9 | Permit Number 37001 | 6007448.1287 | 2095989.1414299998 | 37.7356080772339 | -122.416686739725 | (37.7356080772339, -122.416686739725) | |
110239 | 110239 | 64699 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3290 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/13/1988 12:00:00 AM | 14 | 4x4 | Permit Number 25642 | 6007783.42095653 | 2101534.76819168 | 37.7508539880545 | -122.415920085137 | (37.7508539880545, -122.415920085137) |
103306 | 103306 | 118310 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 990 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/2016 12:00:00 AM | 3 | 3x3 | 6011874.0 | 2103773.0 | 37.7572288087602 | -122.40193172517901 | (37.7572288087602, -122.401931725179) | ||
117544 | 117544 | 45756 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1395 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/2001 12:00:00 AM | Permit Number 44403 | 6003940.26983915 | 2100157.37260664 | 37.746855166615894 | -122.429111856365 | (37.7468551666159, -122.429111856365) | |||
8730 | 8730 | 97454 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 758 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/2011 12:00:00 AM | 3 | 3x3 | 6007159.12761 | 2121599.09194 | 37.805910669901294 | -122.41950228141899 | (37.8059106699013, -122.419502281419) | |
145540 | 145540 | 62317 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 690 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/1985 12:00:00 AM | Permit Number 22459 | 5994442.13838342 | 2110831.40938135 | 37.7756210634318 | -122.46272946245001 | (37.7756210634318, -122.46272946245) | ||
63237 | 63237 | 41232 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3721 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51879 | 6002533.18198 | 2121382.3124 | 37.8050538066511 | -122.4354955486 | (37.8050538066511, -122.4354955486) | |
60167 | 60167 | 32490 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 26 Uranus Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | 5 | Permit Number 36996 | 5999294.82707 | 2105565.3001 | 37.76143994650629 | -122.44556411809799 | (37.7614399465063, -122.445564118098) | |
105861 | 105861 | 32489 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 26 Uranus Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | Permit Number 36996 | 5999299.5495957 | 2105598.47960948 | 37.7615313187924 | -122.44555017087299 | (37.7615313187924, -122.445550170873) | ||
94970 | 94970 | 32412 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 557 Congo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/1996 12:00:00 AM | Permit Number 36944 | 6000089.06506058 | 2095518.18439448 | 37.7338982944093 | -122.44209597109501 | (37.7338982944093, -122.442095971095) | |||
105775 | 105775 | 32411 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 557 Congo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/1996 12:00:00 AM | Permit Number 36944 | 6000089.06506058 | 2095518.18439448 | 37.7338982944093 | -122.44209597109501 | (37.7338982944093, -122.442095971095) | |||
112481 | 112481 | 32416 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1923 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/08/1996 12:00:00 AM | Permit Number 36946 | 6000134.72597959 | 2092799.5506529 | 37.7264361591854 | -122.441743063058 | (37.7264361591854, -122.441743063058) | ||
66408 | 66408 | 78070 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 818 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/2000 12:00:00 AM | 4 | 6011825.3920599995 | 2104537.71061 | 37.7593258220597 | -122.402153592937 | (37.7593258220597, -122.402153592937) | ||
131346 | 131346 | 60306 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1731 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/1982 12:00:00 AM | 6 | Permit Number 19876 | 5999539.5651 | 2110487.8324 | 37.7749699505091 | -122.445071570973 | (37.7749699505091, -122.445071570973) | ||
117796 | 117796 | 86756 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3630 18th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2007 12:00:00 AM | 3x3 | Permit Number 49737 | 6005363.0 | 2105488.0 | 37.7615722645382 | -122.42457130775101 | (37.7615722645382, -122.424571307751) | |||
140420 | 140420 | 83014 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 815 Grafton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2007 12:00:00 AM | 3x3 | Permit Number 49726 | 5994400.44945449 | 2090555.08730476 | 37.719945005103895 | -122.461403423134 | (37.7199450051039, -122.461403423134) | ||
28106 | 28106 | 32369 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 858 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/1996 12:00:00 AM | 6 | Permit Number 36919 | 6008860.83914 | 2119402.12264 | 37.799974043636205 | -122.413457749072 | (37.7999740436362, -122.413457749072) | ||
23971 | 23971 | 78224 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1214 Bowdoin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/2000 12:00:00 AM | 5 | 6009704.84764 | 2090538.9392099997 | 37.7207696402774 | -122.40850003035101 | (37.7207696402774, -122.408500030351) | ||
170302 | 170302 | 71651 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 177 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 7 | 5994505.19973 | 2086471.6739 | 37.7087389470079 | -122.46074556997101 | (37.7087389470079, -122.460745569971) | ||
142385 | 142385 | 48734 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 112 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/2002 12:00:00 AM | Permit Number 46014 | 6001443.50423179 | 2107544.90678437 | 37.7669978945619 | -122.438274574244 | (37.7669978945619, -122.438274574244) | |||
115078 | 115078 | 48569 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 150 Ramsell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/2002 12:00:00 AM | Permit Number 45988 | 5992993.59423207 | 2088277.32681995 | 37.7136097512741 | -122.46610096163299 | (37.7136097512741, -122.466100961633) | ||
92451 | 92451 | 65941 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 665 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/2000 12:00:00 AM | Permit Number 28962 | 6007255.62038472 | 2113291.4844342 | 37.7831054816789 | -122.41857887195499 | (37.7831054816789, -122.418578871955) | ||
111215 | 111215 | 65307 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3519 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/1989 12:00:00 AM | Permit Number 28126 | 6006135.4691914 | 2104900.791717 | 37.7600035225776 | -122.42185793590599 | (37.7600035225776, -122.421857935906) | ||
83293 | 83293 | 63011 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 199 Powhattan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/1986 12:00:00 AM | Permit Number 23425 | 6007777.05506636 | 2098194.1467313 | 37.741681030937706 | -122.415705589886 | (37.7416810309377, -122.415705589886) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");