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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 131048 | 131048 | 50248 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1370 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52899 | 5985267.5978 | 2105900.7074 | 37.7615500789995 | -122.49410249664 | (37.7615500789995, -122.49410249664) | |
| 173987 | 173987 | 185605 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2618 Quintara St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5985302.1571 | 2100947.2721 | 37.7479513323017 | -122.493617965632 | (37.7479513323017, -122.493617965632) | |||
| 185375 | 185375 | 185604 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2616 Quintara St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5985326.7624 | 2100947.2721 | 37.74795277169 | -122.493532882791 | (37.74795277169, -122.493532882791) | |||
| 64991 | 64991 | 106213 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1646 35th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 5985329.6566 | 2104002.0012 | 37.7563403897038 | -122.493747943766 | (37.7563403897038, -122.493747943766) | ||||
| 148034 | 148034 | 185603 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2614 Quintara St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5985349.3993 | 2100948.7484 | 37.7479581493924 | -122.493454715247 | (37.7479581493924, -122.493454715247) | |||
| 80164 | 80164 | 65644 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 534 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/1990 12:00:00 AM | 10 | 3x3 | Permit Number 28557 | 5985361.440330001 | 2112229.86014 | 37.778933632088496 | -122.49424446456499 | (37.7789336320885, -122.494244464565) | |
| 27327 | 27327 | 185602 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2612 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5985366.1309 | 2100949.2405 | 37.7479604792755 | -122.49339689517299 | (37.7479604792755, -122.493396895173) | |||
| 45611 | 45611 | 43621 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2095 35th Ave | 1 | 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) | ||
| 82009 | 82009 | 43620 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2095 35th Ave | 3 | 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) | ||
| 89190 | 89190 | 43622 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2095 35th Ave | 4 | 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) | ||
| 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) | ||
| 29113 | 29113 | 118190 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 830 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5985433.46743 | 2110210.14946 | 37.7733922984241 | -122.49384641835199 | (37.7733922984241, -122.493846418352) | |||
| 29374 | 29374 | 182404 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1543 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5985573.5929 | 2104717.8217 | 37.7583201033903 | -122.492957065208 | (37.7583201033903, -122.492957065208) | |||
| 158260 | 158260 | 37229 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1866 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | 3 | Permit Number 39793 | 5985694.0439 | 2102524.3888 | 37.7523045829279 | -122.49237897746599 | (37.7523045829279, -122.492378977466) | |
| 67085 | 67085 | 181889 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2335 34th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5985755.9263 | 2099311.3427 | 37.7434860472782 | -122.491928449962 | (37.7434860472782, -122.491928449962) | |||
| 179402 | 179402 | 181888 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2335 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5985755.9263 | 2099317.7727 | 37.743503702328205 | -122.491928923256 | (37.7435037023282, -122.491928923256) | |||
| 34759 | 34759 | 181887 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2335 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5985756.2647 | 2099329.9559 | 37.7435371738972 | -122.491928649941 | (37.7435371738972, -122.491928649941) | |||
| 42079 | 42079 | 184965 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2717 34th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 0ft | 5985820.5401 | 2096898.0233 | 37.7368634938723 | -122.49152743291201 | (37.7368634938723, -122.491527432912) | |||
| 171421 | 171421 | 37247 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2650 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | 5 | Permit Number 39800 | 5985829.25086984 | 2102322.057743 | 37.7517569408892 | -122.49189652221901 | (37.7517569408892, -122.491896522219) | |
| 42310 | 42310 | 42884 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2514 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 4 | Permit Number 42805 | 5985844.8171 | 2098079.769 | 37.7401096713575 | -122.49153045761899 | (37.7401096713575, -122.491530457619) | |
| 135689 | 135689 | 185232 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2526 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5985847.205 | 2098002.2949 | 37.7398970877256 | -122.49151650013901 | (37.7398970877256, -122.491516500139) | |||
| 48756 | 48756 | 185233 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2526 34th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 0ft | 5985848.001 | 2098017.6836 | 37.739939387502 | -122.49151488036999 | (37.739939387502, -122.49151488037) | |||
| 54593 | 54593 | 42885 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2546 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 4 | Permit Number 42806 | 5985850.2562 | 2097897.6252 | 37.7396098709906 | -122.491498248106 | (37.7396098709906, -122.491498248106) | |
| 116994 | 116994 | 114980 | Planning Code 138.1 required 4 | Callistemon citrinus :: Lemon Bottlebrush 28 | 281 32ND AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x2 | 5985853.0 | 2114037.0 | 37.7839242715215 | -122.492677119536 | (37.7839242715215, -122.492677119536) | ||||
| 45724 | 45724 | 250780 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 267 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5985869.60841 | 2114147.39692 | 37.7842283606933 | -122.49262779465401 | (37.7842283606933, -122.492627794654) | |||
| 49844 | 49844 | 250781 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 267 32nd Ave | 2 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 5985871.01478 | 2114139.87947 | 37.784207802179296 | -122.49262237534599 | (37.7842078021793, -122.492622375346) | |||
| 161089 | 161089 | 250788 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 281 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 5985872.14911 | 2114023.45685 | 37.7838882056181 | -122.492609873852 | (37.7838882056181, -122.492609873852) | |||
| 150150 | 150150 | 250783 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 273 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5985872.78396 | 2114090.54911 | 37.7840724587071 | -122.492612620392 | (37.7840724587071, -122.492612620392) | |||
| 158740 | 158740 | 250775 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 254 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5985910.66114 | 2114192.0713299997 | 37.7843534240234 | -122.49248905984699 | (37.7843534240234, -122.492489059847) | |||
| 48618 | 48618 | 250784 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 266 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5985911.86598 | 2114116.23526 | 37.784145270524604 | -122.49247930488501 | (37.7841452705246, -122.492479304885) | |||
| 54070 | 54070 | 250786 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 276 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5985914.65421 | 2114070.62696 | 37.7840202063211 | -122.49246629890101 | (37.7840202063211, -122.492466298901) | |||
| 24071 | 24071 | 250790 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 284 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5985915.81821 | 2114007.58209 | 37.7838471713633 | -122.49245762762101 | (37.7838471713633, -122.492457627621) | |||
| 64821 | 64821 | 250792 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 290 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5985918.61873 | 2113977.26033 | 37.7837640802965 | -122.492445705309 | (37.7837640802965, -122.492445705309) | |||
| 174985 | 174985 | 182016 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3216 Ulloa St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5986017.9494 | 2098249.2905 | 37.7405852483284 | -122.490944316297 | (37.7405852483284, -122.490944316297) | |||
| 133495 | 133495 | 182014 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3210 Ulloa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986047.0537 | 2098249.2905 | 37.7405869486166 | -122.490843686246 | (37.7405869486166, -122.490843686246) | |||
| 167085 | 167085 | 182013 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3206 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986069.3895 | 2098249.2905 | 37.740588253427205 | -122.49076645873001 | (37.7405882534272, -122.49076645873) | |||
| 49157 | 49157 | 182012 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3200 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986086.649 | 2098251.6594 | 37.7405957660234 | -122.49070695711201 | (37.7405957660234, -122.490706957112) | |||
| 35753 | 35753 | 42874 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2366 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 5 | Permit Number 42798 | 5986118.9683 | 2099141.5396 | 37.7430410269224 | -122.49066066829901 | (37.7430410269224, -122.490660668299) | |
| 153118 | 153118 | 43816 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2633 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 4 | Permit Number 43447 | 5986134.8144 | 2097343.6322 | 37.738105378566 | -122.490473636095 | (37.738105378566, -122.490473636095) | |
| 132033 | 132033 | 43815 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2633 33rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 4 | Permit Number 43447 | 5986135.8757 | 2097320.2838 | 37.738041332050706 | -122.490468249476 | (37.7380413320507, -122.490468249476) | |
| 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) | ||
| 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) | ||
| 108549 | 108549 | 42901 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2200 Wawona St | 1 | 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) | ||
| 45755 | 45755 | 34141 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2466 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/12/1997 12:00:00 AM | 7 | Permit Number 37989 | 5986144.1807 | 2098458.7736 | 37.7411678068726 | -122.490523271138 | (37.7411678068726, -122.490523271138) | ||
| 153856 | 153856 | 43629 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2819 Pacheco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2000 12:00:00 AM | 4 | Permit Number 43278 | 5986182.935 | 2101604.9629 | 37.7498086596621 | -122.490620697371 | (37.7498086596621, -122.490620697371) | |
| 35285 | 35285 | 119380 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 318 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5986236.40881 | 2113747.95294 | 37.783153042852504 | -122.49132940360201 | (37.7831530428525, -122.491329403602) | |||
| 10158 | 10158 | 44811 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2700x Kirkham St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2001 12:00:00 AM | Permit Number 43905 | 5986360.0 | 2105036.0 | 37.7592396918496 | -122.490260766294 | (37.7592396918496, -122.490260766294) | ||
| 39065 | 39065 | 181927 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2431 32nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5986398.5047 | 2098678.2401 | 37.7417852550403 | -122.48966005728902 | (37.7417852550403, -122.489660057289) | |||
| 152756 | 152756 | 181937 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2435 32nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 0ft | 5986400.8737 | 2098652.5201 | 37.741714773095104 | -122.489649975211 | (37.7417147730951, -122.489649975211) | |||
| 161822 | 161822 | 183449 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2505 32nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5986419.2263 | 2098176.9478 | 37.740410049759 | -122.48955155596 | (37.740410049759, -122.48955155596) | |||
| 162132 | 162132 | 250852 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 237 30th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5986481.270409999 | 2114308.8820599997 | 37.7847074978842 | -122.490523574402 | (37.7847074978842, -122.490523574402) | |||
| 43938 | 43938 | 119944 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 378 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 1ft | 5986559.93935 | 2113398.94352 | 37.7822136625365 | -122.49018445318 | (37.7822136625365, -122.49018445318) | |||
| 62120 | 62120 | 78400 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 735 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2000 12:00:00 AM | 4 | 5986604.8504 | 2110908.2290000003 | 37.7753774919681 | -122.48984584488701 | (37.7753774919681, -122.489845844887) | ||
| 31866 | 31866 | 183578 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2022 Vicente St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986649.2079 | 2097591.1539 | 37.7388150390078 | -122.488713333521 | (37.7388150390078, -122.488713333521) | |||
| 174094 | 174094 | 183576 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2018 Vicente St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986679.6039 | 2097593.1654 | 37.738822335813 | -122.48860838758499 | (37.738822335813, -122.488608387585) | |||
| 157697 | 157697 | 181867 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2327 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986686.5017 | 2099414.3076 | 37.743823110373704 | -122.488718363271 | (37.7438231103737, -122.488718363271) | |||
| 171228 | 171228 | 250733 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2801 Lake St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5986711.11836 | 2114419.3556 | 37.7850242490222 | -122.489736514746 | (37.7850242490222, -122.489736514746) | |||
| 57656 | 57656 | 250734 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2801 Lake St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5986725.81276 | 2114419.04313 | 37.7850242490072 | -122.489685654482 | (37.7850242490072, -122.489685654482) | |||
| 153568 | 153568 | 183574 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2010 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5986727.2095 | 2097593.8359 | 37.738826954665605 | -122.48844384113801 | (37.7388269546656, -122.488443841138) | |||
| 66504 | 66504 | 250735 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2801 Lake St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5986736.846390001 | 2114419.4183900002 | 37.785025923551295 | -122.48964750974301 | (37.7850259235513, -122.489647509743) | |||
| 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) | |||
| 118899 | 118899 | 42862 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2599 31st Ave | 2 | 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) | |||
| 143904 | 143904 | 42863 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2599 31st Ave | 1 | 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) | |||
| 69657 | 69657 | 250736 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2801 Lake St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5986749.69109 | 2114418.5354 | 37.7850242490246 | -122.48960300679899 | (37.7850242490246, -122.489603006799) | |||
| 167305 | 167305 | 183375 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2654 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5986751.7945 | 2097277.3597 | 37.737959429190205 | -122.488335587381 | (37.7379594291902, -122.488335587381) | |||
| 165677 | 165677 | 250737 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2801 Lake St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5986760.11257 | 2114418.92368 | 37.785025923553206 | -122.48956698083201 | (37.7850259235532, -122.489566980832) | |||
| 133451 | 133451 | 183593 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2630 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5986766.5455 | 2097375.2528 | 37.7382290784129 | -122.488291778536 | (37.7382290784129, -122.488291778536) | |||
| 51145 | 51145 | 250738 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2801 Lake St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5986770.52108 | 2114418.70237 | 37.7850259235546 | -122.489530954893 | (37.7850259235546, -122.489530954893) | |||
| 165914 | 165914 | 183591 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2624 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5986774.5915 | 2097415.0358 | 37.7383387814475 | -122.488266882547 | (37.7383387814475, -122.488266882547) | |||
| 188587 | 188587 | 182822 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2309 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5986791.0294 | 2102976.7255 | 37.753610649826996 | -122.48861872093201 | (37.753610649827, -122.488618720932) | |||
| 53301 | 53301 | 182824 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2309 Noriega St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5986840.4933 | 2102978.0036 | 37.7536170454165 | -122.48844776006399 | (37.7536170454165, -122.488447760064) | |||
| 135869 | 135869 | 102364 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 567 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5986874.211680001 | 2112080.47621 | 37.7786118751095 | -122.489000269726 | (37.7786118751095, -122.489000269726) | |||
| 169585 | 169585 | 182818 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1801 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5986875.267000001 | 2102940.8737 | 37.7535171257271 | -122.488324778074 | (37.7535171257271, -122.488324778074) | |||
| 171844 | 171844 | 182820 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1805 30th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5986876.4726 | 2102898.6794 | 37.7534013419725 | -122.488317508312 | (37.7534013419725, -122.488317508312) | |||
| 173029 | 173029 | 182819 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1803 30th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5986876.4726 | 2102917.9682 | 37.7534543037822 | -122.488318925723 | (37.7534543037822, -122.488318925723) | |||
| 158540 | 158540 | 182821 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1807 30th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5986876.8744 | 2102880.1943 | 37.7533506103474 | -122.488314760472 | (37.7533506103474, -122.488314760472) | |||
| 144387 | 144387 | 66700 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2301 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/1991 12:00:00 AM | Permit Number 29932 | 5986886.07739919 | 2102988.37861449 | 37.753648192053205 | -122.48829088466299 | (37.7536481920532, -122.488290884663) | |||
| 97874 | 97874 | 9246 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6500 Geary Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5986886.6516554 | 2112572.1737573002 | 37.7799626628655 | -122.48899339188101 | (37.7799626628655, -122.488993391881) | |||
| 145466 | 145466 | 9245 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6500 Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5986886.6516554 | 2112572.1737573002 | 37.7799626628655 | -122.48899339188101 | (37.7799626628655, -122.488993391881) | |||
| 78021 | 78021 | 103055 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2301 Noriega St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 29932 | 5986892.0 | 2102979.0 | 37.7536227864704 | -122.488269714105 | (37.7536227864704, -122.488269714105) | ||||
| 158828 | 158828 | 45087 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2237 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2001 12:00:00 AM | 4 | Permit Number 43968 | 5987019.1297 | 2102979.8533 | 37.7536325457586 | -122.487830139981 | (37.7536325457586, -122.487830139981) | |
| 134442 | 134442 | 183744 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2270 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5987026.201 | 2099814.6195 | 37.7449420779346 | -122.48757317986299 | (37.7449420779346, -122.487573179863) | |||
| 169850 | 169850 | 183733 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2266 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5987029.1882 | 2099838.5169 | 37.745007868036396 | -122.487564606009 | (37.7450078680364, -122.487564606009) | |||
| 175966 | 175966 | 181881 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2340 30th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5987046.5825 | 2099334.7784 | 37.743625750907704 | -122.487467463938 | (37.7436257509077, -122.487467463938) | |||
| 178162 | 178162 | 181880 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2340 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5987047.2593 | 2099322.2568 | 37.7435914093996 | -122.487464204144 | (37.7435914093996, -122.487464204144) | |||
| 22441 | 22441 | 9219 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6300 Geary Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5987356.9662 | 2112573.6226 | 37.779994079355895 | -122.487366491184 | (37.7799940793559, -122.487366491184) | |||
| 22497 | 22497 | 9218 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6300 Geary Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5987387.1497 | 2112575.6349 | 37.78000136471471 | -122.48726222211799 | (37.7800013647147, -122.487262222118) | |||
| 22544 | 22544 | 9217 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6300 Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5987387.8205 | 2112562.8907 | 37.77996641187121 | -122.487258965224 | (37.7799664118712, -122.487258965224) | |||
| 22762 | 22762 | 9216 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6300 Geary Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5987396.5402 | 2112575.6349 | 37.7800019123037 | -122.487229736584 | (37.7800019123037, -122.487229736584) | |||
| 180041 | 180041 | 183509 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2554 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5987406.0303 | 2097897.7701 | 37.7397010627992 | -122.48611913122299 | (37.7397010627992, -122.486119131223) | |||
| 22548 | 22548 | 9215 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6300 Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5987407.9428 | 2112568.2567 | 37.779982318766706 | -122.48718974831999 | (37.7799823187667, -122.48718974832) | |||
| 167147 | 167147 | 183535 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2570 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5987409.4254 | 2097800.8542 | 37.7394351551531 | -122.486100280093 | (37.7394351551531, -122.486100280093) | |||
| 150206 | 150206 | 53793 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 258 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/1972 12:00:00 AM | 5 | Permit Number 9485 | 5987461.74395 | 2114234.65378 | 37.784560908121 | -122.487126051666 | (37.784560908121, -122.487126051666) | ||
| 170620 | 170620 | 71222 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2207 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 5 | 5987585.8685 | 2100255.6538 | 37.746185666387 | -122.485670338512 | (37.746185666387, -122.485670338512) | ||
| 183738 | 183738 | 183807 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2207 28th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5987587.5755 | 2100244.1318 | 37.7461541295061 | -122.48566359052799 | (37.7461541295061, -122.485663590528) | |||
| 133367 | 133367 | 182111 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2455 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5987647.6873 | 2098570.6897 | 37.7415628035476 | -122.48533296019501 | (37.7415628035476, -122.485332960195) | |||
| 52293 | 52293 | 183524 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2563 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 0ft | 5987671.006 | 2097842.0589 | 37.739563533837206 | -122.48519888317301 | (37.7395635338372, -122.485198883173) | |||
| 35948 | 35948 | 65961 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2567 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/1990 12:00:00 AM | 8 | Permit Number 28983 | 5987671.3147 | 2097818.6015 | 37.7394991439696 | -122.485196095129 | (37.7394991439696, -122.485196095129) | ||
| 38307 | 38307 | 183532 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2571 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 0ft | 5987672.2406 | 2097791.749 | 37.7394254680034 | -122.485190924064 | (37.7394254680034, -122.485190924064) | |||
| 179571 | 179571 | 120079 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 221 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 1ft | 5987715.20741 | 2114498.36264 | 37.7852997534807 | -122.486268531544 | (37.7852997534807, -122.486268531544) |
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");