Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 90175 | 90175 | 108595 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1599x GREENWICH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005333.0 | 2119502.0 | 37.8000495685335 | -122.42567253315 | (37.8000495685335, -122.42567253315) | ||||
| 90258 | 90258 | 64314 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 158 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/25/1988 12:00:00 AM | Permit Number 25131 | 6004545.85418713 | 2097571.72864017 | 37.739789842685 | -122.42683368999201 | (37.739789842685, -122.426833689992) | ||
| 90450 | 90450 | 89040 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 272 Main St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51778 | 6014884.0 | 2115520.0 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | |||
| 91023 | 91023 | 42831 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1501 Broadway | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/2000 12:00:00 AM | Permit Number 42767 | 6006419.40791846 | 2117956.96761218 | 37.795868628594704 | -122.42180333365499 | (37.7958686285947, -122.421803333655) | ||
| 91096 | 91096 | 64569 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1429 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/1988 12:00:00 AM | Permit Number 25462 | 6000923.9519361 | 2111020.37522765 | 37.7765110963127 | -122.44032089124799 | (37.7765110963127, -122.440320891248) | ||
| 91232 | 91232 | 67857 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 596 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1993 12:00:00 AM | Permit Number 31532 | 6002067.00541727 | 2099182.85111765 | 37.7440731404676 | -122.435519715541 | (37.7440731404676, -122.435519715541) | ||
| 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) | ||
| 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) | |||
| 91465 | 91465 | 104905 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 419 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990435.0 | 2090585.0 | 37.7197981072685 | -122.47511265272199 | (37.7197981072685, -122.475112652722) | |||||
| 91600 | 91600 | 43556 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 338 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2000 12:00:00 AM | Permit Number 43219 | 6003694.36665872 | 2099553.79617946 | 37.745183962731 | -122.429919119626 | (37.745183962731, -122.429919119626) | ||
| 91653 | 91653 | 54999 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 538 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/1972 12:00:00 AM | Permit Number 773428 | 5990967.79402544 | 2111724.41194432 | 37.77787229032 | -122.47481314337799 | (37.77787229032, -122.474813143378) | |||
| 91754 | 91754 | 31356 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2399 16th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1995 12:00:00 AM | Permit Number 34966 | 5991349.80377986 | 2099091.89396406 | 37.74320887704079 | -122.472570415702 | (37.7432088770408, -122.472570415702) | ||
| 91965 | 91965 | 117121 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 83 CRAGS CT | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000924.0 | 2097953.0 | 37.7406312755223 | -122.43938382491301 | (37.7406312755223, -122.439383824913) | ||||
| 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) | ||
| 92524 | 92524 | 116688 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 45 SANTA ROSA AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002115.0 | 2092628.0 | 37.7260777542131 | -122.43488508848301 | (37.7260777542131, -122.434885088483) | ||||
| 92908 | 92908 | 111565 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1400x HAWES ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6017154.0 | 2092794.0 | 37.7273759626121 | -122.382907198656 | (37.7273759626121, -122.382907198656) | ||||
| 93075 | 93075 | 66534 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 701 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1992 12:00:00 AM | Permit Number 30772 | 6004086.63776587 | 2091699.6936924 | 37.723640577851896 | -122.428003132555 | (37.7236405778519, -122.428003132555) | ||
| 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) | ||
| 93383 | 93383 | 45341 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 667 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/27/2001 12:00:00 AM | Permit Number 44171 | 5994015.44130584 | 2090992.03620537 | 37.7211225948175 | -122.462765934958 | (37.7211225948175, -122.462765934958) | ||
| 93718 | 93718 | 116732 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3290 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 4x4 | 6007783.42095653 | 2101534.76819168 | 37.7508539880545 | -122.415920085137 | (37.7508539880545, -122.415920085137) | |||
| 93736 | 93736 | 89041 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 272 Main St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51778 | 6014884.0 | 2115520.0 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | |||
| 94047 | 94047 | 43619 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2095 35th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2000 12:00:00 AM | Permit Number 43271 | 5985386.76911027 | 2100967.4929928 | 37.7480118028434 | -122.49332687468599 | (37.7480118028434, -122.493326874686) | ||
| 94094 | 94094 | 83448 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1325 Howard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52441 | 6008634.678811 | 2110151.0598083 | 37.7745601652378 | -122.413585687931 | (37.7745601652378, -122.413585687931) | ||
| 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) | |||
| 94459 | 94459 | 104902 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 332 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 94815 | 94815 | 35812 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 51 Sycamore St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/1998 12:00:00 AM | Permit Number 39051 | 6006563.61712831 | 2105830.66384173 | 37.762580870322104 | -122.42044317973499 | (37.7625808703221, -122.420443179735) | ||
| 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) | |||
| 95029 | 95029 | 101191 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 328 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5994863.0 | 2106716.0 | 37.764345459457004 | -122.460975263176 | (37.764345459457, -122.460975263176) | ||||
| 95153 | 95153 | 104907 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 432 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 95248 | 95248 | 36095 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2500 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/1998 12:00:00 AM | Permit Number 39197 | 6009173.48990003 | 2106882.99462813 | 37.7656170584886 | -122.411490890744 | (37.7656170584886, -122.411490890744) | |||
| 95877 | 95877 | 96339 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1494@ 27th St Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2011 12:00:00 AM | 3x3 | Permit Number 767722 | 6005839.0 | 2100241.0 | 37.7471920883951 | -122.422552158036 | (37.7471920883951, -122.422552158036) | ||
| 96252 | 96252 | 35809 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 51 Sycamore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/1998 12:00:00 AM | Permit Number 39051 | 6006563.61712831 | 2105830.66384173 | 37.762580870322104 | -122.42044317973499 | (37.7625808703221, -122.420443179735) | ||
| 96331 | 96331 | 42900 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2200 Wawona St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | Permit Number 42815 | 5986138.5427207 | 2097288.78551671 | 37.737955001906 | -122.490456711772 | (37.737955001906, -122.490456711772) | ||
| 96536 | 96536 | 60175 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 54 Lapidge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1988 12:00:00 AM | Permit Number 25533 | 6005979.27726365 | 2105187.71035503 | 37.760782524281296 | -122.42241851621 | (37.7607825242813, -122.42241851621) | ||
| 96650 | 96650 | 35810 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 51 Sycamore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/1998 12:00:00 AM | Permit Number 39051 | 6006563.61712831 | 2105830.66384173 | 37.762580870322104 | -122.42044317973499 | (37.7625808703221, -122.420443179735) | ||
| 96837 | 96837 | 53981 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 320 San Leandro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/1994 12:00:00 AM | Permit Number 33298 | 5992331.54284805 | 2094776.52933726 | 37.7314167502679 | -122.46886188806299 | (37.7314167502679, -122.468861888063) | |||
| 97174 | 97174 | 41819 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 29 Fortuna Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42205 | 6000254.75248069 | 2112385.7950317003 | 37.780222066079 | -122.442733903375 | (37.780222066079, -122.442733903375) | ||
| 97401 | 97401 | 94495 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 739 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5x5 | 5997569.2 | 2107955.8 | 37.7679049841939 | -122.451704762646 | (37.7679049841939, -122.451704762646) | ||||
| 97546 | 97546 | 37777 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 449 Felton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/06/1998 12:00:00 AM | Permit Number 40114 | 6009618.93348363 | 2093468.47161568 | 37.72880870980371 | -122.409003606238 | (37.7288087098037, -122.409003606238) | ||
| 97588 | 97588 | 65802 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2229 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/1990 12:00:00 AM | Permit Number 28770 | 5990998.9640501 | 2100230.16806226 | 37.7463139697598 | -122.473866540085 | (37.7463139697598, -122.473866540085) | ||
| 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) | ||
| 98140 | 98140 | 116731 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3290 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 4x4 | 6007783.42095653 | 2101534.76819168 | 37.7508539880545 | -122.415920085137 | (37.7508539880545, -122.415920085137) | |||
| 98246 | 98246 | 69213 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1177 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1994 12:00:00 AM | Permit Number 33264 | 6008095.60945385 | 2101082.12715709 | 37.749628684109396 | -122.414808474137 | (37.7496286841094, -122.414808474137) | ||
| 98344 | 98344 | 99596 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3001@Filbert Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 17057 | 6002820.0 | 2118927.7 | 37.798330369321796 | -122.43432738402299 | (37.7983303693218, -122.434327384023) | ||||
| 98517 | 98517 | 97343 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2211 Bush St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002936.0 | 2114773.0 | 37.7869292140191 | -122.433628903612 | (37.7869292140191, -122.433628903612) | ||||
| 98612 | 98612 | 42132 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 171 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42428 | 5998957.22367334 | 2093763.17021168 | 37.729014870842 | -122.445882895755 | (37.729014870842, -122.445882895755) | ||
| 98917 | 98917 | 49862 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 75@ LAGUNA Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/17/2004 12:00:00 AM | Permit Number 46631 | 6005455.52049644 | 2109220.32111529 | 37.771825552787796 | -122.424516811052 | (37.7718255527878, -122.424516811052) | ||
| 99093 | 99093 | 34357 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1822 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38113 | 6004544.96387342 | 2098197.10530749 | 37.741506934238 | -122.426881295332 | (37.741506934238, -122.426881295332) | ||
| 99162 | 99162 | 31003 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 285 Chicago Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34778 | 6002766.74364375 | 2086692.10708835 | 37.7098160865806 | -122.432208324272 | (37.7098160865806, -122.432208324272) | ||
| 99768 | 99768 | 114750 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3808 21ST ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002991.0 | 2103620.0 | 37.756308941661295 | -122.432641640203 | (37.7563089416613, -122.432641640203) | ||||
| 99775 | 99775 | 61979 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4400 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2016 12:00:00 AM | Permit Number 774514 | 6001287.16223059 | 2101175.19968833 | 37.749499333765996 | -122.438358942397 | (37.749499333766, -122.438358942397) | |||
| 99835 | 99835 | 104913 | Significant Tree 6 | Callistemon citrinus :: Lemon Bottlebrush 28 | 608 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 99855 | 99855 | 31138 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 419 Hearst Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34852 | 5998635.87955939 | 2094356.6234018002 | 37.7306259997996 | -122.447036492148 | (37.7306259997996, -122.447036492148) | ||
| 99905 | 99905 | 42396 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 600 Gennessee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42555 | 5997487.92419847 | 2095274.73436784 | 37.7330812596511 | -122.451071309951 | (37.7330812596511, -122.451071309951) | ||
| 99942 | 99942 | 100187 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 217 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2012 12:00:00 AM | 3x3 | Permit Number 768935 | 6009833.3 | 2099565.6 | 37.7455621186719 | -122.40869248022899 | (37.7455621186719, -122.408692480229) | ||
| 100056 | 100056 | 121609 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 222 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004147.0 | 2097629.0 | 37.739924537079396 | -122.428216839981 | (37.7399245370794, -122.428216839981) | ||||
| 100487 | 100487 | 42861 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2599 31st Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/2000 12:00:00 AM | Permit Number 42787 | 5986745.41813509 | 2097587.07290157 | 37.7388094476944 | -122.488380388139 | (37.7388094476944, -122.488380388139) | |||
| 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) | ||
| 101201 | 101201 | 82741 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1325 Howard St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52441 | 6008634.678811 | 2110151.0598083 | 37.7745601652378 | -122.413585687931 | (37.7745601652378, -122.413585687931) | ||
| 101347 | 101347 | 56203 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 184 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/20/1973 12:00:00 AM | Permit Number 12322 | 6007622.41344299 | 2100258.98375641 | 37.7473419182586 | -122.416386510472 | (37.7473419182586, -122.416386510472) | |||
| 101546 | 101546 | 104068 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 596 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x7 | 5990015.48741 | 2111618.44137 | 37.777526093835604 | -122.47809971950399 | (37.7775260938356, -122.478099719504) | ||||
| 101584 | 101584 | 67517 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 331 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/22/1992 12:00:00 AM | Permit Number 31053 | 5997889.85712008 | 2093779.21238518 | 37.7289979144345 | -122.44957400182501 | (37.7289979144345, -122.449574001825) | ||
| 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) | ||
| 101928 | 101928 | 64933 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2299 Cecelia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1989 12:00:00 AM | Permit Number 25961 | 5991453.69210058 | 2099794.8219263 | 37.745144949294 | -122.47226243033501 | (37.745144949294, -122.472262430335) | ||
| 101955 | 101955 | 42674 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 581 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42700 | 6008532.69397696 | 2121039.56256614 | 37.804451613820206 | -122.41470920319901 | (37.8044516138202, -122.414709203199) | ||
| 102039 | 102039 | 83450 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1325 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52441 | 6008634.678811 | 2110151.0598083 | 37.7745601652378 | -122.413585687931 | (37.7745601652378, -122.413585687931) | ||
| 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) | ||
| 102564 | 102564 | 111564 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1400x HAWES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6017154.0 | 2092794.0 | 37.7273759626121 | -122.382907198656 | (37.7273759626121, -122.382907198656) | ||||
| 102786 | 102786 | 69410 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1033 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | Permit Number 33515 | 6001287.00169166 | 2086793.18756043 | 37.7100096203988 | -122.43732980748699 | (37.7100096203988, -122.437329807487) | ||
| 103028 | 103028 | 42899 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2200 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | Permit Number 42815 | 5986138.5427207 | 2097288.78551671 | 37.737955001906 | -122.490456711772 | (37.737955001906, -122.490456711772) | ||
| 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) | |||
| 103169 | 103169 | 101971 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4082 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6003063.0 | 2104088.0 | 37.7575980408955 | -122.43242606452401 | (37.7575980408955, -122.432426064524) | |||||
| 103371 | 103371 | 111566 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1400x HAWES ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6017154.0 | 2092794.0 | 37.7273759626121 | -122.382907198656 | (37.7273759626121, -122.382907198656) | ||||
| 103384 | 103384 | 118381 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 468 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002952.0 | 2105515.0 | 37.7615099452496 | -122.432911892467 | (37.7615099452496, -122.432911892467) | ||||
| 103680 | 103680 | 67889 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 217 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | Permit Number 31586 | 6005100.28778176 | 2100163.31762382 | 37.7469370880579 | -122.42510104280399 | (37.7469370880579, -122.425101042804) | ||
| 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) | |||
| 103867 | 103867 | 37778 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 449 Felton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/06/1998 12:00:00 AM | Permit Number 40114 | 6009618.93348363 | 2093468.47161568 | 37.72880870980371 | -122.409003606238 | (37.7288087098037, -122.409003606238) | ||
| 104141 | 104141 | 42400 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 600 Gennessee St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42555 | 5997487.92419847 | 2095274.73436784 | 37.7330812596511 | -122.451071309951 | (37.7330812596511, -122.451071309951) | ||
| 104179 | 104179 | 56684 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 221 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52127 | 6004114.02111143 | 2097584.45844202 | 37.7398003700762 | -122.428327693503 | (37.7398003700762, -122.428327693503) | |||
| 104191 | 104191 | 42265 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1730 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2000 12:00:00 AM | Permit Number 42506 | 5987835.88750869 | 2103511.72763123 | 37.7551405372057 | -122.48504466581001 | (37.7551405372057, -122.48504466581) | |||
| 104523 | 104523 | 97908 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2000 Chestnut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/1994 12:00:00 AM | Permit Number 33440 | 6002143.0 | 2119896.0 | 37.8009506172383 | -122.43673935569201 | (37.8009506172383, -122.436739355692) | |||
| 104678 | 104678 | 111259 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 90 MADDUX AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6012644.0 | 2095211.0 | 37.7337623267636 | -122.3986679149 | (37.7337623267636, -122.3986679149) | ||||
| 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) | |||
| 104715 | 104715 | 43562 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 406 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2000 12:00:00 AM | Permit Number 43223 | 6003924.16559982 | 2098981.19483718 | 37.7436247428067 | -122.429083695417 | (37.7436247428067, -122.429083695417) | ||
| 104803 | 104803 | 82892 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1325 Howard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52441 | 6008634.678811 | 2110151.0598083 | 37.7745601652378 | -122.413585687931 | (37.7745601652378, -122.413585687931) | ||
| 105056 | 105056 | 65680 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 223 Molimo Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1990 12:00:00 AM | Permit Number 28600 | 5997900.25631717 | 2096664.39788468 | 37.736920541741 | -122.449745884352 | (37.736920541741, -122.449745884352) | ||
| 105120 | 105120 | 117465 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 511x HAMPSHIRE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010223.0 | 2105808.0 | 37.7627241794067 | -122.407785042208 | (37.7627241794067, -122.407785042208) | ||||
| 105268 | 105268 | 114664 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 480 Myra Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5997245.35324946 | 2096954.8836891998 | 37.737680654693996 | -122.45203111514499 | (37.737680654694, -122.452031115145) | ||||
| 105514 | 105514 | 63801 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 89 Putnam St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1992 12:00:00 AM | Permit Number 30608 | 6009178.90944984 | 2096954.7470526001 | 37.738356614267296 | -122.41077091710301 | (37.7383566142673, -122.410770917103) | ||
| 105553 | 105553 | 66945 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 83 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/1992 12:00:00 AM | Permit Number 30272 | 5996389.61664911 | 2112438.61542597 | 37.7801459984775 | -122.45610892339899 | (37.7801459984775, -122.456108923399) | ||
| 105669 | 105669 | 46792 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 283 Brentwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | Permit Number 44883 | 5994892.79937141 | 2095160.94854023 | 37.7326199133932 | -122.460035042749 | (37.7326199133932, -122.460035042749) | ||
| 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) | |||
| 105829 | 105829 | 94064 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 98 Ney St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Tree 4 on Craut | 6004036.0 | 2094004.0 | 37.7299648256421 | -122.42834233456199 | (37.7299648256421, -122.428342334562) | ||||
| 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) | ||
| 106156 | 106156 | 50912 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2046 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2004 12:00:00 AM | Permit Number 47415 | 5990698.44477594 | 2101463.24729555 | 37.749682273112995 | -122.474995684738 | (37.749682273113, -122.474995684738) | ||
| 106340 | 106340 | 117463 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 511x HAMPSHIRE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010223.0 | 2105808.0 | 37.7627241794067 | -122.407785042208 | (37.7627241794067, -122.407785042208) | ||||
| 106429 | 106429 | 65659 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 67 Molimo Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1990 12:00:00 AM | Permit Number 28579 | 5998642.66061394 | 2096596.3405330002 | 37.7367761199068 | -122.447174176985 | (37.7367761199068, -122.447174176985) | ||
| 106465 | 106465 | 36093 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2500 16th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/1998 12:00:00 AM | Permit Number 39197 | 6009173.48990003 | 2106882.99462813 | 37.7656170584886 | -122.411490890744 | (37.7656170584886, -122.411490890744) | |||
| 106952 | 106952 | 95673 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3508 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x5 | 5998079.0 | 2115190.0 | 37.7877974026763 | -122.45046300835699 | (37.7877974026763, -122.450463008357) | ||||
| 107104 | 107104 | 89039 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 272 Main St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51778 | 6014884.0 | 2115520.0 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) |
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");