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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16735 | 16735 | 103149 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 255 09th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2013 12:00:00 AM | 11 | Permit Number 770156 | 6009026.54065 | 2110070.43459 | 37.774360783357395 | -122.41222445660401 | (37.7743607833574, -122.412224456604) | ||
| 16801 | 16801 | 22083 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3240 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/07/1995 12:00:00 AM | 3 | 6015972.44529 | 2100358.98918 | 37.7480825346922 | -122.38751940998999 | (37.7480825346922, -122.38751940999) | |||
| 16882 | 16882 | 46143 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2001 12:00:00 AM | Permit Number 44490 | |||||||||
| 16963 | 16963 | 38666 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 850 Brewster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/1998 12:00:00 AM | Permit Number 40586 | ||||||||
| 18077 | 18077 | 46101 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 250 Brannan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/2001 12:00:00 AM | Permit Number 44468 | 6015276.73031133 | 2112998.11508414 | 37.7827482661819 | -122.39080835017 | (37.7827482661819, -122.39080835017) | ||
| 18128 | 18128 | 22905 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 245 Valencia St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/08/1997 12:00:00 AM | 16 | 6006113.7460199995 | 2108170.95635 | 37.7689813977127 | -122.42216539613999 | (37.7689813977127, -122.42216539614) | |||
| 18371 | 18371 | 68355 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 627 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32175 | 5989388.74548019 | 2111065.82314724 | 37.7759723585503 | -122.48022734798799 | (37.7759723585503, -122.480227347988) | ||
| 18448 | 18448 | 62738 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 4521 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/07/1986 12:00:00 AM | Permit Number 23085 | 6000942.99197149 | 2105197.51217307 | 37.7605240475123 | -122.439837443247 | (37.7605240475123, -122.439837443247) | ||
| 18637 | 18637 | 60677 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1098 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/17/1988 12:00:00 AM | Permit Number 25704 | 6001311.54507479 | 2109393.91334387 | 37.7720673006946 | -122.438863516223 | (37.7720673006946, -122.438863516223) | ||
| 18897 | 18897 | 101747 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1000 Montgomery St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 25770 | 6011635.0 | 2118713.0 | 37.7982372525996 | -122.403809528937 | (37.7982372525996, -122.403809528937) | ||||
| 18920 | 18920 | 64985 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2 Kingston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/28/1989 12:00:00 AM | Permit Number 26023 | 6005554.31706226 | 2098219.5570786 | 37.741625601295 | -122.42339288942699 | (37.741625601295, -122.423392889427) | ||
| 19017 | 19017 | 39449 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 205 13th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1999 12:00:00 AM | Permit Number 40934 | 6007392.37160238 | 2108419.72859009 | 37.7697365039652 | -122.417760336994 | (37.7697365039652, -122.417760336994) | ||
| 19021 | 19021 | 67521 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 424 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/22/1992 12:00:00 AM | Permit Number 31057 | 5997342.043029 | 2093839.69948247 | 37.729132642900794 | -122.451472187982 | (37.7291326429008, -122.451472187982) | ||
| 19107 | 19107 | 64799 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 450 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1989 12:00:00 AM | Permit Number 25798 | 6003587.23896685 | 2100132.28558533 | 37.7467662928737 | -122.430330814023 | (37.7467662928737, -122.430330814023) | ||
| 19110 | 19110 | 62227 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 228 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1985 12:00:00 AM | Permit Number 22352 | 6001110.06412505 | 2093217.52334826 | 37.72763934179729 | -122.43840130114799 | (37.7276393417973, -122.438401301148) | ||
| 19130 | 19130 | 68743 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3929 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/16/1993 12:00:00 AM | Permit Number 32664 | 6003434.71793969 | 2105335.41306872 | 37.761044210169004 | -122.431229551523 | (37.761044210169, -122.431229551523) | ||
| 19175 | 19175 | 112287 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 50 Van Ness Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 5 | 6007006.5 | 2110627.3 | 37.7757762467653 | -122.419251679167 | (37.7757762467653, -122.419251679167) | ||||
| 19271 | 19271 | 66851 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 4314 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/15/1991 12:00:00 AM | Permit Number 30156 | 6001689.12791695 | 2104706.38300314 | 37.7592179697276 | -122.437221739283 | (37.7592179697276, -122.437221739283) | ||
| 19605 | 19605 | 41563 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 181 Shipley St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2000 12:00:00 AM | Permit Number 42081 | 6011929.63995711 | 2112113.99187797 | 37.7801343920604 | -122.40232575105699 | (37.7801343920604, -122.402325751057) | |||
| 19689 | 19689 | 99005 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2099X Beach St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | Permit Number 46510 | 6000381.4 | 2120794.3 | 37.803316837922104 | -122.442899765771 | (37.8033168379221, -122.442899765771) | ||||
| 19922 | 19922 | 22903 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 245 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/08/1997 12:00:00 AM | 20 | 6006117.36475 | 2108110.80038 | 37.7688164278576 | -122.422148604882 | (37.7688164278576, -122.422148604882) | |||
| 20265 | 20265 | 52930 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 36 Havelock St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | Permit Number 48915 | 5999971.05699015 | 2092944.44477133 | 37.7268246780096 | -122.442319255194 | (37.7268246780096, -122.442319255194) | ||
| 20612 | 20612 | 42802 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3700 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2000 12:00:00 AM | Permit Number 42757 | 6004214.17005009 | 2106015.94399708 | 37.7629569261619 | -122.42858227503 | (37.7629569261619, -122.42858227503) | |||
| 20615 | 20615 | 41499 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1475 Mission St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2002 12:00:00 AM | Permit Number 45525 | 6007725.96622091 | 2110155.42070503 | 37.774521071304605 | -122.4167294201 | (37.7745210713046, -122.4167294201) | |||
| 20620 | 20620 | 101474 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 541 Congo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/04/2016 12:00:00 AM | Permit Number 775316 | 6000089.0 | 2095440.1 | 37.7336838892166 | -122.44209059296301 | (37.7336838892166, -122.442090592963) | |||
| 20755 | 20755 | 22904 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 245 Valencia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/08/1997 12:00:00 AM | 20 | 6006115.95631 | 2108143.51756 | 37.7689061820004 | -122.422155801252 | (37.7689061820004, -122.422155801252) | |||
| 20861 | 20861 | 97775 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 639 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2014 12:00:00 AM | 3 | Permit Number 773141 | 5991602.6 | 2111067.7 | 37.7761059040631 | -122.47256925753099 | (37.7761059040631, -122.472569257531) | ||
| 20885 | 20885 | 32292 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 33 Ford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2017 12:00:00 AM | 3 | Permit Number 779433 | 6003387.91451 | 2105627.26072 | 37.761842901260295 | -122.431412258663 | (37.7618429012603, -122.431412258663) | ||
| 20910 | 20910 | 33744 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1198 Valencia St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/1996 12:00:00 AM | Permit Number 37802 | 6006363.7210059995 | 2102616.9286996 | 37.7537454336429 | -122.420906369809 | (37.7537454336429, -122.420906369809) | |||
| 21198 | 21198 | 42536 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 95 Brady St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42642 | 6006853.97359683 | 2109407.99798814 | 37.772419743979896 | -122.419692774816 | (37.7724197439799, -122.419692774816) | ||
| 21201 | 21201 | 63890 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 165 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1987 12:00:00 AM | Permit Number 24599 | 6005777.74997654 | 2109961.71011831 | 37.77387942030639 | -122.42345491188401 | (37.7738794203064, -122.423454911884) | ||
| 21496 | 21496 | 22902 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 245 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/08/1997 12:00:00 AM | 20 | 6006120.48056 | 2108082.42198 | 37.7687386832705 | -122.42213581113998 | (37.7687386832705, -122.42213581114) | |||
| 22944 | 22944 | 109848 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 5210 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/18/2015 03:05:00 PM | 3 | 6014438.5 | 2094011.9 | 37.7305696586271 | -122.39237990500901 | (37.7305696586271, -122.392379905009) | |||
| 23109 | 23109 | 24471 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3240 03rd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 6015972.49692 | 2100334.93813 | 37.7480164983628 | -122.38751755380301 | (37.7480164983628, -122.387517553803) | ||||
| 23137 | 23137 | 1254 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 3802X Alemany Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 5992777.102469999 | 2087583.7041 | 37.711692737 | -122.466798837414 | (37.711692737, -122.466798837414) | ||||
| 23196 | 23196 | 1823 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2111 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 6012045.082330001 | 2087761.7241200001 | 37.713274749700496 | -122.400215554797 | (37.7132747497005, -122.400215554797) | ||||
| 23212 | 23212 | 6876 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 225 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6006348.635919999 | 2110734.63205 | 37.7760338829938 | -122.42153502532699 | (37.7760338829938, -122.421535025327) | ||||
| 23216 | 23216 | 22678 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1345 Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2012 12:00:00 AM | 2 | Permit Number 768843 | 6003567.7164 | 2112435.7303 | 37.7805474814093 | -122.43127641041299 | (37.7805474814093, -122.431276410413) | ||
| 23273 | 23273 | 21970 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2565 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 6015887.079390001 | 2103633.90306 | 37.7570700318859 | -122.388043105904 | (37.7570700318859, -122.388043105904) | ||||
| 23495 | 23495 | 49666 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 3630 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 04/18/2011 12:00:00 AM | 6 | Permit Number 46510 | 6000245.17413 | 2120665.11682 | 37.8029543681198 | -122.443361894237 | (37.8029543681198, -122.443361894237) | ||
| 23649 | 23649 | 83478 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 729 Tennessee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2005 12:00:00 AM | 10 | 6015481.04355 | 2105634.6159 | 37.762541056634 | -122.38958707191001 | (37.762541056634, -122.38958707191) | ||
| 24115 | 24115 | 37515 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 334 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | 8 | Permit Number 39971 | 6008037.23261 | 2113608.31593 | 37.784019396929494 | -122.41589724646002 | (37.7840193969295, -122.41589724646) | |
| 24289 | 24289 | 65026 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 271 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2005 12:00:00 AM | 13 | Permit Number 26077 | 6013497.70585 | 2105830.92167 | 37.7629698974541 | -122.396460524653 | (37.7629698974541, -122.396460524653) | |
| 24364 | 24364 | 84793 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 308 Townsend St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/2007 12:00:00 AM | 11 | Permit No. 49239 | 6013949.14222 | 2110940.8955200003 | 37.777025860390296 | -122.39525712294301 | (37.7770258603903, -122.395257122943) | ||
| 24736 | 24736 | 34593 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3196 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 7 | Permit Number 38289 | 5999056.096030001 | 2116639.74571 | 37.7918338966676 | -122.447186830523 | (37.7918338966676, -122.447186830523) | |
| 24793 | 24793 | 35384 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 567 Vermont St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 8 | Permit Number 38840 | 6011258.3331699995 | 2105715.55317 | 37.7625282467018 | -122.40419766648998 | (37.7625282467018, -122.40419766649) | |
| 25747 | 25747 | 44351 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Beach St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/2001 12:00:00 AM | 6 | Permit Number 43731 | 6008003.5653099995 | 2122011.35371 | 37.8070901631447 | -122.41660918757601 | (37.8070901631447, -122.416609187576) | ||
| 26037 | 26037 | 59085 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 926 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 15 | Permit Number 18386 | 5992726.88514 | 2110724.5041799997 | 37.7752285932752 | -122.468655111063 | (37.7752285932752, -122.468655111063) | ||
| 26157 | 26157 | 52813 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2900BRODERICK Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2006 12:00:00 AM | 7 | Permit Number 48839 | 6000221.419969999 | 2116800.3387700003 | 37.7923413580253 | -122.443166360958 | (37.7923413580253, -122.443166360958) | ||
| 26375 | 26375 | 75838 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 101 Henry Adams St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1999 12:00:00 AM | 15 | 6011420.310769999 | 2107843.20731 | 37.768379354641105 | -122.40378716196699 | (37.7683793546411, -122.403787161967) | ||
| 26526 | 26526 | 228904 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 902 Duboce Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6 | 6002231.23378 | 2108246.83249 | 37.7689699817064 | -122.435600166732 | (37.7689699817064, -122.435600166732) | ||||
| 26916 | 26916 | 47467 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1903 Broderick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 11 | Permit Number 45369 | 6000459.82276 | 2115245.67943 | 37.7880862598074 | -122.44222983124901 | (37.7880862598074, -122.442229831249) | |
| 27453 | 27453 | 71972 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 776 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/02/1995 12:00:00 AM | 13 | 6009259.7893900005 | 2119456.28205 | 37.8001451441351 | -122.41208105430599 | (37.8001451441351, -122.412081054306) | ||
| 27549 | 27549 | 68296 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 86 Diana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/1993 12:00:00 AM | 10 | Permit Number 32105 | 6013269.5421400005 | 2093862.94549 | 37.730095678252795 | -122.396410757955 | (37.7300956782528, -122.396410757955) | ||
| 28967 | 28967 | 34594 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3196 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 7 | Permit Number 38289 | 5999039.4413 | 2116637.89487 | 37.7918278631246 | -122.447244322395 | (37.7918278631246, -122.447244322395) | |
| 29386 | 29386 | 177222 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 5989183.517969999 | 2089355.54971 | 37.7163497314364 | -122.479348640047 | (37.7163497314364, -122.479348640047) | ||||
| 29431 | 29431 | 49523 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 575@ DIVISION 10th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/2003 12:00:00 AM | 6 | Permit Number 46430 | 6010035.11091 | 2108310.12323 | 37.769583917386896 | -122.408611404187 | (37.7695839173869, -122.408611404187) | |
| 29560 | 29560 | 48826 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 435 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/2002 12:00:00 AM | 6 | Permit Number 46051 | 6011960.74713 | 2118391.5720900004 | 37.797372881410205 | -122.402659724179 | (37.7973728814102, -122.402659724179) | ||
| 29686 | 29686 | 46983 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1310 Minnesota St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2002 12:00:00 AM | 8 | Permit Number 44998 | 6015321.30101 | 2102379.94373 | 37.753595564110206 | -122.389912210104 | (37.7535955641102, -122.389912210104) | ||
| 30113 | 30113 | 70615 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 956 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/13/1994 12:00:00 AM | 13 | 6007552.40866 | 2114767.26768 | 37.7871743274878 | -122.417656736796 | (37.7871743274878, -122.417656736796) | ||
| 30240 | 30240 | 75882 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 539 Bryant St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/23/1994 12:00:00 AM | 12 | 6013498.81204 | 2112165.8305200003 | 37.7803641977969 | -122.39690086778201 | (37.7803641977969, -122.396900867782) | ||
| 30495 | 30495 | 37516 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 401 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | 11 | Permit Number 41076 | 6007956.902430001 | 2113828.4377200003 | 37.784619281597294 | -122.41619075552299 | (37.7846192815973, -122.416190755523) | |
| 30524 | 30524 | 41722 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 232 Dore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42170 | 6009584.56743913 | 2109048.70213008 | 37.771586640345795 | -122.41022197760701 | (37.7715866403458, -122.410221977607) | ||
| 31031 | 31031 | 66600 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 795 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/1991 12:00:00 AM | 11 | Permit Number 29793 | 6010138.53594 | 2116122.08721 | 37.7910395219106 | -122.40880487713801 | (37.7910395219106, -122.408804877138) | |
| 31539 | 31539 | 250610 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2201 Golden Gate Ave | 35 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 5998818.59622 | 2111415.77935 | 37.777476677952706 | -122.44763236005899 | (37.7774766779527, -122.447632360059) | ||||
| 31559 | 31559 | 35385 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 567 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 10 | Permit Number 38840 | 6011258.977630001 | 2105699.98405 | 37.7624855334018 | -122.404194341714 | (37.7624855334018, -122.404194341714) | |
| 31584 | 31584 | 37502 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 844 Jones St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | 7 | Permit Number 39966 | 6008740.03897 | 2115504.68539 | 37.7892658555875 | -122.413599955284 | (37.7892658555875, -122.413599955284) | |
| 31592 | 31592 | 67712 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 544 02nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/1992 12:00:00 AM | 14 | Permit Number 31324 | 6014602.96687 | 2112946.74618 | 37.782569812986296 | -122.393135709438 | (37.7825698129863, -122.393135709438) | ||
| 31797 | 31797 | 41450 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 291 Linden St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/31/2000 12:00:00 AM | 2 | Permit Number 42044 | 6006073.35922 | 2110884.23315 | 37.7764291260393 | -122.42249791416201 | (37.7764291260393, -122.422497914162) | ||
| 31799 | 31799 | 43417 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 246 02nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2000 12:00:00 AM | 10 | Permit Number 43159 | 6013405.28311 | 2114204.36675 | 37.7859563423666 | -122.39736742978998 | (37.7859563423666, -122.39736742979) | ||
| 32254 | 32254 | 41802 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Henry Adams St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/2003 12:00:00 AM | 5 | Permit Number 42199 | 6011432.49542 | 2107611.3986 | 37.7677435411696 | -122.403728703313 | (37.7677435411696, -122.403728703313) | |
| 32607 | 32607 | 79175 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 399 Grove St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/03/2001 12:00:00 AM | 5 | 6005975.99544 | 2111376.30995 | 37.777774756444 | -122.422869703793 | (37.777774756444, -122.422869703793) | ||
| 33511 | 33511 | 177230 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 65 Ocean Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6001004.645719999 | 2091720.9184 | 37.723524009216106 | -122.438658540667 | (37.7235240092161, -122.438658540667) | ||||
| 33578 | 33578 | 93881 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 638 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/2010 12:00:00 AM | 6 | Permit Number 53372 | 6015637.16451 | 2105365.28573 | 37.761810189302295 | -122.389028296132 | (37.7618101893023, -122.389028296132) | ||
| 34000 | 34000 | 113516 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 201 Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6008798.18916 | 2113155.2475 | 37.782818131100505 | -122.413232555264 | (37.7828181311005, -122.413232555264) | ||||
| 34213 | 34213 | 97449 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2700 03rd St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 6015860.67722 | 2102672.17908 | 37.7544278785458 | -122.38806730398001 | (37.7544278785458, -122.38806730398) | ||||
| 35308 | 35308 | 30782 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 454 Brannan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 5 | Permit Number 34656 | 6013813.25306 | 2111685.96726 | 37.7790641000695 | -122.39577942850201 | (37.7790641000695, -122.395779428502) | |
| 35556 | 35556 | 64007 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2160 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/1987 12:00:00 AM | 16 | Permit Number 24755 | 6007652.23543 | 2119845.6976400004 | 37.80112405438229 | -122.417671444289 | (37.8011240543823, -122.417671444289) | |
| 35846 | 35846 | 113522 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 201 Turk St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6008966.5911 | 2113177.86773 | 37.7828896937441 | -122.412651552741 | (37.7828896937441, -122.412651552741) | ||||
| 35973 | 35973 | 46560 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1136 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/2002 12:00:00 AM | 10 | Permit Number 44697 | 6009601.10267 | 2111157.4264 | 37.7773776311162 | -122.41031369582701 | (37.7773776311162, -122.410313695827) | ||
| 36120 | 36120 | 30524 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 161 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/1995 12:00:00 AM | 7 | Permit Number 34529 | 6008071.29151 | 2113023.94527 | 37.7824167708541 | -122.415738023293 | (37.7824167708541, -122.415738023293) | |
| 36303 | 36303 | 41801 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Henry Adams St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/2003 12:00:00 AM | 6 | Permit Number 42199 | 6011430.3722 | 2107669.42894 | 37.767902760721896 | -122.403740131013 | (37.7679027607219, -122.403740131013) | |
| 36537 | 36537 | 49659 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3630 Divisadero St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2011 12:00:00 AM | 8 | 6000216.68095 | 2120880.45401 | 37.8035440014225 | -122.443475972348 | (37.8035440014225, -122.443475972348) | |||
| 36652 | 36652 | 30906 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2 Henry Adams St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1995 12:00:00 AM | 17 | Permit Number 34728 | 6011365.28058 | 2107983.60538 | 37.7687617814598 | -122.403987388801 | (37.7687617814598, -122.403987388801) | ||
| 37272 | 37272 | 69267 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 151 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/1994 12:00:00 AM | 13 | Permit Number 33338 | 6012370.22733 | 2114062.89181 | 37.7855102030737 | -122.400938518023 | (37.7855102030737, -122.400938518023) | ||
| 37365 | 37365 | 44357 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/2001 12:00:00 AM | 2 | Permit Number 43731 | 6007993.12258 | 2122010.7684299997 | 37.807087968806 | -122.416645285459 | (37.807087968806, -122.416645285459) | ||
| 37708 | 37708 | 41797 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Henry Adams St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/2003 12:00:00 AM | 18 | Permit Number 42199 | 6011431.47132 | 2107642.26388 | 37.7678282330246 | -122.403734417609 | (37.7678282330246, -122.403734417609) | |
| 38601 | 38601 | 65456 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 895 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1989 12:00:00 AM | 15 | Permit Number 28332 | 6008339.818530001 | 2115177.38309 | 37.7883446818054 | -122.41496149919399 | (37.7883446818054, -122.414961499194) | |
| 39027 | 39027 | 37506 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 844 Jones St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | 6 | Permit Number 39966 | 6008737.124969999 | 2115540.18684 | 37.7893631703113 | -122.413612549392 | (37.7893631703113, -122.413612549392) | |
| 39198 | 39198 | 46978 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1310 Minnesota St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2002 12:00:00 AM | 9 | Permit Number 44998 | 6015319.0594 | 2102452.1247099997 | 37.7537936334853 | -122.389925003839 | (37.7537936334853, -122.389925003839) | ||
| 39346 | 39346 | 40813 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 920 Powell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/1999 12:00:00 AM | 11 | Permit Number 41758 | 6010003.02767 | 2116942.94179 | 37.79328579904411 | -122.40933168562701 | (37.7932857990441, -122.409331685627) | ||
| 39435 | 39435 | 30780 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 454 Brannan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 2 | Permit Number 34656 | 6013835.79296 | 2111706.6575599997 | 37.7791221647875 | -122.39570290337099 | (37.7791221647875, -122.395702903371) | |
| 39446 | 39446 | 31556 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 160 Ewing Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 1 | Permit Number 35101 | 5998589.70626628 | 2112540.1098933998 | 37.780550714408605 | -122.448505154861 | (37.7805507144086, -122.448505154861) | |
| 39559 | 39559 | 68740 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 535 Cordova St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/16/1993 12:00:00 AM | 1 | Permit Number 32660 | 6002126.65992 | 2086442.09338 | 37.7090932906808 | -122.43440270504601 | (37.7090932906808, -122.434402705046) | ||
| 39618 | 39618 | 96611 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3652 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2011 12:00:00 AM | 5 | Permit Number 767972 | 5997367.41166 | 2115420.25767 | 37.7883888763049 | -122.452941584197 | (37.7883888763049, -122.452941584197) | ||
| 39824 | 39824 | 43966 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 627 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 08/20/2005 12:00:00 AM | 9 | Permit Number 43534 | 6006884.39072 | 2112892.55093 | 37.781989200774206 | -122.41983486151199 | (37.7819892007742, -122.419834861512) | |
| 40146 | 40146 | 228911 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 902 Duboce Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6002477.93592 | 2108260.26707 | 37.7690208788446 | -122.434747801875 | (37.7690208788446, -122.434747801875) | ||||
| 40824 | 40824 | 67705 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 374 Brannan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1992 12:00:00 AM | 12 | Permit Number 31425 | 6014391.04027 | 2112236.06649 | 37.780606672994296 | -122.39381912855801 | (37.7806066729943, -122.393819128558) | |
| 41150 | 41150 | 35036 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 403 Main St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2005 12:00:00 AM | 14 | Permit Number 48046 | 6015677.54706 | 2114778.0252099996 | 37.787657726568604 | -122.389546028652 | (37.7876577265686, -122.389546028652) | ||
| 41341 | 41341 | 59105 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 755 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 18 | Permit Number 18407 | 5993484.081180001 | 2110348.68988 | 37.7742404202162 | -122.466008505371 | (37.7742404202162, -122.466008505371) |
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");