trees
239 rows where qSiteInfo = "Sidewalk: Curb side : Cutout" and qSpecies_id = 47 sorted by qSpecies_id
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id ▼ | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
83616 | 68575 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 7633 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | Permit Number 32467 | 5983299.26193695 | 2112364.72668983 | 37.7791830450299 | -122.501388226383 | (37.7791830450299, -122.501388226383) | 11 | 6 | 2 | 55 | 26 | ||
84280 | 50293 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 300 Valley St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2003 12:00:00 AM | 3x3 | 6003944.88624926 | 2099274.1797934 | 37.7444303848395 | -122.42903293346 | (37.7444303848395, -122.42903293346) | 2 | 7 | 5 | 63 | 22 | ||
84877 | 31600 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1631 Ortega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/10/1995 12:00:00 AM | Permit Number 35126 | 5988991.64827869 | 2102380.23074862 | 37.7521010026968 | -122.480964913447 | (37.7521010026968, -122.480964913447) | 1 | 8 | 3 | 29491 | 35 | ||
86130 | 52103 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 641 Rockdale Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/2005 12:00:00 AM | Permit Number 48295 | 5997742.5728031 | 2098061.02519693 | 37.7407463206184 | -122.450391713191 | (37.7407463206184, -122.450391713191) | 9 | 7 | 4 | 59 | 40 | ||
87369 | 81868 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 3012-3014 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52207 | 6009486.0303434 | 2101043.89087343 | 37.749601722793 | -122.409997630916 | (37.749601722793, -122.409997630916) | 2 | 4 | 7 | 28859 | 19 | ||
89012 | 227683 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 923 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007409.88053 | 2101914.88747 | 37.7518767015549 | -122.417238758882 | (37.7518767015549, -122.417238758882) | 2 | 4 | 7 | 28859 | 19 | |||
89095 | 46395 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2091 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/05/2002 12:00:00 AM | 9 | Permit Number 44627 | 5981974.76389525 | 2100876.77542895 | 37.7475625528023 | -122.505118527994 | (37.7475625528023, -122.505118527994) | 1 | 8 | 3 | 29491 | 35 | |
89527 | 50288 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 300 Valley St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2003 12:00:00 AM | 3x3 | 6003944.88624926 | 2099274.1797934 | 37.7444303848395 | -122.42903293346 | (37.7444303848395, -122.42903293346) | 2 | 7 | 5 | 63 | 22 | ||
89540 | 33402 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 377 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1996 12:00:00 AM | Permit Number 37520 | 5992522.58969687 | 2094276.01733921 | 37.730053504422 | -122.468165013068 | (37.730053504422, -122.468165013068) | 9 | 8 | 4 | 59 | 40 | ||
90219 | 41465 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 3445 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2000 12:00:00 AM | 24 | Permit Number 42050 | 5983633.32729372 | 2103553.20607522 | 37.755008735539 | -122.499581179885 | (37.755008735539, -122.499581179885) | 1 | 8 | 3 | 56 | 35 | ||
90861 | 31375 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 630 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1995 12:00:00 AM | Permit Number 34977 | 5991276.37232485 | 2099107.33925567 | 37.7432470351435 | -122.472825445815 | (37.7432470351435, -122.472825445815) | 1 | 8 | 4 | 29491 | 40 | ||
92382 | 47550 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1681 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45414 | 6003392.60348895 | 2098449.5926945 | 37.7421349817765 | -122.430883775787 | (37.7421349817765, -122.430883775787) | 2 | 7 | 5 | 63 | 22 | ||
93754 | 227689 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 84 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008214.29979 | 2099586.39862 | 37.7455284159971 | -122.41429222281 | (37.7455284159971, -122.41429222281) | 2 | 7 | 7 | 28859 | 2 | |||
94127 | 119281 | Undocumented 4 | Leptospermum laevigatum :: Australian Tea Tree 47 | 59x Ralston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992077 | 2088275 | 37.7135504383964 | -122.469268843393 | (37.7135504383964, -122.469268843393) | 9 | 8 | 6 | 64 | 24 | ||||
94578 | 207099 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1325 18th Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5990478.55232 | 2106260.78747 | 37.7628423007597 | -122.476106431162 | (37.7628423007597, -122.476106431162) | 1 | 8 | 3 | 56 | 12 | |||
95742 | 176981 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2315 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 1ft | 5999571.4621 | 2089300.92693 | 37.7167976306892 | -122.443439037193 | (37.7167976306892, -122.443439037193) | 9 | 7 | 6 | 28861 | 25 | |||
97332 | 83208 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 3634 Rivera St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 7 | 3x3 | Permit Number 50746 | 5981914.57527844 | 2100148.1004138 | 37.7455582728462 | -122.505272655065 | (37.7455582728462, -122.505272655065) | 1 | 8 | 3 | 29491 | 35 | |
99445 | 9277 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2161X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6000049.09202 | 2089751.67924 | 37.7180625213905 | -122.441820442737 | (37.7180625213905, -122.441820442737) | 9 | 7 | 6 | 28861 | 25 | |||
99585 | 59481 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 701 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2019 12:00:00 AM | 3 | Permit Number 768498 | 5994707.05513 | 2110730.54303 | 37.7753593652253 | -122.461805741777 | (37.7753593652253, -122.461805741777) | 11 | 6 | 2 | 54 | 11 | ||
99619 | 67131 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1439 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/1992 12:00:00 AM | Permit Number 30551 | 5994253.6761319 | 2105720.38065143 | 37.7615766669983 | -122.463010486718 | (37.7615766669983, -122.463010486718) | 1 | 5 | 11 | 56 | 12 | ||
100650 | 78557 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2234 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2016 12:00:00 AM | 3 | Permit Number 771299 | 5981748.2661 | 2099861.5988 | 37.7447618317919 | -122.505826480334 | (37.7447618317919, -122.505826480334) | 1 | 8 | 3 | 29491 | 35 | |
100968 | 1262 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 3900 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X5 | 5992602.03225 | 2087509.49597 | 37.7114788737215 | -122.467398529617 | (37.7114788737215, -122.467398529617) | 9 | 8 | 4 | 64 | 24 | |||
101273 | 12918 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2935X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3x3 | 5996989.32715 | 2087489.72289 | 37.7116768903089 | -122.452233546915 | (37.7116768903089, -122.452233546915) | 9 | 7 | 6 | 28861 | 25 | |||
102436 | 184168 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 3732 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 5982616.4158 | 2104253.9424 | 37.7568730399942 | -122.503149769389 | (37.7568730399942, -122.503149769389) | 1 | 8 | 3 | 56 | 35 | |||
102767 | 109138 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 759 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/29/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773583 | 5985365.40132 | 2110729.9835 | 37.7748156320332 | -122.494120186241 | (37.7748156320332, -122.494120186241) | 11 | 6 | 2 | 55 | 26 |
102941 | 227682 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 500 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008186.7931 | 2096476.12564 | 37.7369867469298 | -122.41416732858 | (37.7369867469298, -122.41416732858) | 2 | 7 | 7 | 28859 | 2 | |||
103423 | 82598 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 3503 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52081 | 6006166.2666896 | 2102562.46439955 | 37.7535847553547 | -122.421585344765 | (37.7535847553547, -122.421585344765) | 2 | 4 | 5 | 28859 | 19 | ||
103582 | 83279 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2147 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50736 | 5982298.4490102 | 2100494.71161235 | 37.7465325514695 | -122.503970969286 | (37.7465325514695, -122.503970969286) | 1 | 8 | 3 | 29491 | 35 | |
104265 | 129463 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2451 Steiner St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 6002236.13059 | 2116512.00902 | 37.7916643510872 | -122.436174782264 | (37.7916643510872, -122.436174782264) | 13 | 9 | 1 | 29490 | 27 | |||
104777 | 47604 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 645 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/2002 12:00:00 AM | Permit Number 45440 | 6008713.69382569 | 2095849.48701302 | 37.7352957148385 | -122.412301312985 | (37.7352957148385, -122.412301312985) | 10 | 7 | 7 | 28859 | 2 | ||
105029 | 43632 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1001 Portola Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50556 | 5996213.47474732 | 2098545.79305022 | 37.7419897418411 | -122.455713757113 | (37.7419897418411, -122.455713757113) | 9 | 7 | 4 | 59 | 40 | ||
105151 | 129466 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1974 Clay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6005243.67184 | 2116520.57545 | 37.7918582853821 | -122.425769315008 | (37.7918582853821, -122.425769315008) | 13 | 9 | 1 | 28858 | 27 | |||
105324 | 32605 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1370 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | Permit Number 37071 | 5984960.54583105 | 2105873.44387063 | 37.7614572492102 | -122.49516243722 | (37.7614572492102, -122.49516243722) | 1 | 8 | 3 | 56 | 35 | ||
105561 | 973 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1599 Alemany Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 0 | 6001917.27172 | 2093023.46154 | 37.72715237348 | -122.435596901293 | (37.72715237348, -122.435596901293) | 9 | 7 | 6 | 28861 | 25 | |||
107125 | 84447 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2266 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50738 | 5982378.18226568 | 2099687.61773546 | 37.7443211838051 | -122.503635505549 | (37.7443211838051, -122.503635505549) | 1 | 8 | 3 | 29491 | 35 | |
107383 | 54526 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 4530 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/01/2016 12:00:00 AM | 3 | Permit Number 777496 | 5981479.33824 | 2110998.92324 | 37.7753259029383 | -122.507582607669 | (37.7753259029383, -122.507582607669) | 11 | 6 | 2 | 55 | 26 | ||
107523 | 123588 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 50 05th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 5994278.22027 | 2115268.89087 | 37.7877957491728 | -122.463618619297 | (37.7877957491728, -122.463618619297) | 11 | 6 | 1 | 54 | 11 | |||
108126 | 50490 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 242 Miramar Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/2003 12:00:00 AM | Permit Number 47126 | 5995378.87438655 | 2091597.86421043 | 37.722864487352 | -122.458096796728 | (37.722864487352, -122.458096796728) | 9 | 8 | 4 | 28861 | 24 | ||
108342 | 35388 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 753 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 7 | Permit Number 38842 | 6011306.15832 | 2104840.46729 | 37.7601281288176 | -122.403970671318 | (37.7601281288176, -122.403970671318) | 10 | 3 | 8 | 28856 | 29 | |
109823 | 52980 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 531 Arch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/2006 12:00:00 AM | Permit Number 49067 | 5992711.66457877 | 2090721.03501475 | 37.7203033137371 | -122.467252978798 | (37.7203033137371, -122.467252978798) | 9 | 8 | 6 | 64 | 24 | ||
111648 | 46761 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 343 Gambier St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2002 12:00:00 AM | Permit Number 44859 | 6006106.65621717 | 2092210.20384218 | 37.7251564045519 | -122.421056498489 | (37.7251564045519, -122.421056498489) | 9 | 7 | 7 | 309 | 5 | |||
112832 | 50290 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 300 Valley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2003 12:00:00 AM | 3x3 | Permit Number 47005 | 6003944.88624926 | 2099274.1797934 | 37.7444303848395 | -122.42903293346 | (37.7444303848395, -122.42903293346) | 2 | 7 | 5 | 63 | 22 | |
113634 | 47351 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 246 Monticello St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/2002 12:00:00 AM | Permit Number 45277 | 5991716.56988019 | 2090163.16086716 | 37.7187140338834 | -122.470652049529 | (37.7187140338834, -122.470652049529) | 9 | 8 | 6 | 64 | 24 | ||
113945 | 50219 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2726 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2004 12:00:00 AM | 8 | 3x3 | Permit Number 46926 | 5987073.25597 | 2111201.47184 | 37.776209992885 | -122.488247096133 | (37.776209992885, -122.488247096133) | 11 | 6 | 2 | 55 | 26 |
113972 | 50292 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 300 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2003 12:00:00 AM | 3x3 | Permit Number 47005 | 6003944.88624926 | 2099274.1797934 | 37.7444303848395 | -122.42903293346 | (37.7444303848395, -122.42903293346) | 2 | 7 | 5 | 63 | 22 | |
114789 | 207103 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 40 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5995614.83933 | 2092751.51074 | 37.7260456803487 | -122.457364540844 | (37.7260456803487, -122.457364540844) | 9 | 7 | 4 | 28861 | 40 | |||
115683 | 129467 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1331 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 4ft | 6006504.31748 | 2119710.78815 | 37.8006889650949 | -122.421634156713 | (37.8006889650949, -122.421634156713) | 13 | 9 | 1 | 28858 | 32 | |||
116625 | 45431 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 851 Head St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/2001 12:00:00 AM | Permit Number 44219 | 5993920.58856776 | 2091576.5612161 | 37.7227220958318 | -122.463136201451 | (37.7227220958318, -122.463136201451) | 9 | 8 | 4 | 59 | 40 | ||
118542 | 138270 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 218 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5998383.8821 | 2112677.2272 | 37.7809154323836 | -122.449227076582 | (37.7809154323836, -122.449227076582) | 15 | 6 | 2 | 54 | 16 | |||
118845 | 47453 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 5049 Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45359 | 5983034.2663237 | 2111680.83899779 | 37.7772897229163 | -122.502254315782 | (37.7772897229163, -122.502254315782) | 11 | 6 | 2 | 55 | 26 | ||
119732 | 47881 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1454 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50547 | 5982810.24276317 | 2105223.95269531 | 37.759547805419 | -122.502551248021 | (37.759547805419, -122.502551248021) | 1 | 8 | 3 | 56 | 35 | ||
120655 | 207100 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1325 18th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5990476.61635 | 2106239.99978 | 37.7627851110794 | -122.476111608564 | (37.7627851110794, -122.476111608564) | 1 | 8 | 3 | 56 | 12 | |||
121491 | 31546 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 220 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/10/1995 12:00:00 AM | 6 | Permit Number 35095 | 5998394.38199367 | 2112672.66987383 | 37.7809035197163 | -122.449190424029 | (37.7809035197163, -122.449190424029) | 15 | 6 | 2 | 54 | 16 | |
121895 | 50489 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 242 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/2003 12:00:00 AM | Permit Number 47126 | 5995378.87438655 | 2091597.86421043 | 37.722864487352 | -122.458096796728 | (37.722864487352, -122.458096796728) | 9 | 8 | 4 | 28861 | 24 | ||
122107 | 46973 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1783 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/2002 12:00:00 AM | 7 | Permit Number 44992 | 5982214.0178657 | 2102979.50871383 | 37.7533501437558 | -122.504446973742 | (37.7533501437558, -122.504446973742) | 1 | 8 | 3 | 56 | 35 | |
122863 | 129465 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1974 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6005261.30695 | 2116522.05783 | 37.791863352156 | -122.425708403014 | (37.791863352156, -122.425708403014) | 13 | 9 | 1 | 28858 | 27 | |||
123096 | 45360 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 458 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46747 | 5993277.37926203 | 2090218.01876098 | 37.7189547935486 | -122.46526098645 | (37.7189547935486, -122.46526098645) | 9 | 8 | 6 | 64 | 24 | ||
123108 | 227677 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 300 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6003907.02908 | 2099270.15617 | 37.7444171939021 | -122.429163548878 | (37.7444171939021, -122.429163548878) | 2 | 7 | 5 | 63 | 22 | |||
123946 | 83251 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2210 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50737 | 5982365.40001882 | 2100051.8832382 | 37.7453206044327 | -122.503706674483 | (37.7453206044327, -122.503706674483) | 1 | 8 | 3 | 29491 | 35 | |
126484 | 118250 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 759 34th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5985366.8002 | 2110712.822 | 37.7747685933044 | -122.494114082166 | (37.7747685933044, -122.494114082166) | 11 | 6 | 2 | 55 | 26 | |||
127819 | 227694 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 239 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999877.66163 | 2104769.07166 | 37.7592869569347 | -122.443491144794 | (37.7592869569347, -122.443491144794) | 2 | 4 | 5 | 28862 | 3 | |||
128532 | 52554 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1719 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/12/2006 12:00:00 AM | 8 | Permit Number 48649 | 5984370.92860727 | 2103469.2332855 | 37.754821420905 | -122.497024185091 | (37.754821420905, -122.497024185091) | 1 | 8 | 3 | 56 | 35 | |
128589 | 18878 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2305 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 26 | 3X3 | 6003659.52132 | 2115878.15996 | 37.7900047293604 | -122.431204600475 | (37.7900047293604, -122.431204600475) | 13 | 9 | 1 | 29490 | 27 | |||
128606 | 82810 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2730 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 3x3 | Permit Number 50728 | 5983104.2980141 | 2096628.76061893 | 37.7359650625832 | -122.500898621502 | (37.7359650625832, -122.500898621502) | 1 | 8 | 3 | 29491 | 35 | ||
129532 | 52497 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 371 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48606 | 6007135.79724675 | 2096038.97616324 | 37.7357273409345 | -122.417770123047 | (37.7357273409345, -122.417770123047) | 2 | 7 | 7 | 28859 | 2 | ||
129636 | 45429 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 851 Head St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/2001 12:00:00 AM | Permit Number 44219 | 5993920.58856776 | 2091576.5612161 | 37.7227220958318 | -122.463136201451 | (37.7227220958318, -122.463136201451) | 9 | 8 | 4 | 59 | 40 | ||
130752 | 1383 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2550X Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X2 | 6002248.65699 | 2096984.18535 | 37.7380464314256 | -122.434734413124 | (37.7380464314256, -122.434734413124) | 2 | 7 | 5 | 63 | 7 | |||
132662 | 176986 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 745 France Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6002864.08823 | 2089338.03726 | 37.7170867510327 | -122.432060704959 | (37.7170867510327, -122.432060704959) | 9 | 7 | 6 | 28861 | 5 | |||
133839 | 79951 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 4332 Pacheco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50745 | 5981564.36989544 | 2101497.47247657 | 37.7492426575827 | -122.50658364702 | (37.7492426575827, -122.50658364702) | 1 | 8 | 3 | 29491 | 35 | |
134083 | 24808 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 7117 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/22/1996 12:00:00 AM | 3 | 3X3 | 5984967.23631 | 2112432.54215 | 37.7794670623637 | -122.495623106999 | (37.7794670623637, -122.495623106999) | 11 | 6 | 2 | 55 | 26 | ||
134216 | 68097 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 49 Bessie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/1993 12:00:00 AM | Permit Number 31842 | 6008240.85722104 | 2100065.07433688 | 37.7468442446896 | -122.414234251858 | (37.7468442446896, -122.414234251858) | 2 | 7 | 7 | 28859 | 2 | ||
134621 | 227679 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 361 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6003556.92712 | 2099495.03666 | 37.7450148383554 | -122.430390170187 | (37.7450148383554, -122.430390170187) | 2 | 7 | 5 | 63 | 22 | |||
136204 | 35418 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 221 Crestmont Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/1998 12:00:00 AM | Permit Number 38870 | 5995170.62655697 | 2103759.11614599 | 37.7562443131302 | -122.459697089533 | (37.7562443131302, -122.459697089533) | 1 | 5 | 4 | 63 | 12 | |||
136897 | 102790 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 3445 Moraga St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Permit Number 42050 | 5983633 | 2103554 | 37.7550108962308 | -122.499582370415 | (37.7550108962308, -122.499582370415) | 1 | 8 | 3 | 56 | 35 | |||
137363 | 84886 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 3138 Santiago St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2007 12:00:00 AM | Permit No. 49329 | 5983290 | 2099514 | 37.7438980447125 | -122.500469849117 | (37.7438980447125, -122.500469849117) | 1 | 8 | 3 | 29491 | 35 | |||
137505 | 34621 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 370 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2016 12:00:00 AM | 3 | Permit Number 778228 | 6003497.10528776 | 2099542.95496323 | 37.7451430220882 | -122.430600441889 | (37.7451430220882, -122.430600441889) | 2 | 7 | 5 | 63 | 22 | |
137534 | 50423 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 75 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/2003 12:00:00 AM | Permit Number 47076 | 5995600.08487961 | 2090390.5729412 | 37.7195622602365 | -122.457244829317 | (37.7195622602365, -122.457244829317) | 9 | 8 | 6 | 28861 | 24 | ||
137873 | 227692 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 75 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006684.36987 | 2096973.81613 | 37.7382687898828 | -122.419397184857 | (37.7382687898828, -122.419397184857) | 2 | 7 | 7 | 28859 | 2 | |||
138561 | 36089 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1706 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/2002 12:00:00 AM | Permit Number 44997 | 5981032.08177403 | 2103436.82774177 | 37.7545362217712 | -122.508568229446 | (37.7545362217712, -122.508568229446) | 1 | 8 | 3 | 56 | 35 | ||
139775 | 51442 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 775 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2004 12:00:00 AM | Permit Number 47761 | 6007380.25742092 | 2095203.71769531 | 37.7334476580973 | -122.416865768693 | (37.7334476580973, -122.416865768693) | 2 | 7 | 7 | 28859 | 2 | ||
139898 | 105256 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 162 Prague St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2014 12:00:00 AM | 3x3 | Permit Number 771043 | 6004383.3 | 2090213.9 | 37.7195776934466 | -122.42687185684 | (37.7195776934466, -122.42687185684) | 9 | 7 | 6 | 28861 | 5 | ||
142493 | 227693 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 337 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6002979.94012 | 2100929.17253 | 37.7489199393117 | -122.432487701248 | (37.7489199393117, -122.432487701248) | 2 | 4 | 5 | 28862 | 22 | |||
145902 | 31168 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 570 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34869 | 5993027.58275469 | 2090995.29108117 | 37.7210745862886 | -122.466180882741 | (37.7210745862886, -122.466180882741) | 9 | 8 | 6 | 64 | 24 | ||
145982 | 227697 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 109 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003800.52049 | 2108768.8119 | 37.7704922173631 | -122.430209350707 | (37.7704922173631, -122.430209350707) | 15 | 9 | 11 | 29492 | 10 | |||
146162 | 207104 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 242 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5995372.52306 | 2091590.05793 | 37.7228426882306 | -122.458118187099 | (37.7228426882306, -122.458118187099) | 9 | 8 | 4 | 28861 | 24 | |||
147419 | 227696 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 50 Belcher St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6003774.74871 | 2108065.24722 | 37.7685589402651 | -122.43024829315 | (37.7685589402651, -122.43024829315) | 7 | 9 | 5 | 28862 | 3 | |||
148288 | 30756 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1547 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | 1 | Permit Number 34637 | 6015015.9888 | 2093715.5638 | 37.7297880302088 | -122.390362726863 | (37.7297880302088, -122.390362726863) | 10 | 3 | 8 | 58 | 1 | |
148893 | 42597 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1950 Clay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | 7 | Permit Number 42667 | 6005420.67346 | 2116544.61332 | 37.7919342879744 | -122.425158599805 | (37.7919342879744, -122.425158599805) | 13 | 9 | 1 | 28858 | 27 | ||
148994 | 47225 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1643 Felton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | Permit Number 45170 | 6006193.94874397 | 2092417.83045771 | 37.7257314225765 | -122.420769469994 | (37.7257314225765, -122.420769469994) | 9 | 7 | 7 | 309 | 5 | ||
149652 | 183373 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2728 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5985578.5174 | 2096788.4906 | 37.7365485996681 | -122.492356136884 | (37.7365485996681, -122.492356136884) | 1 | 8 | 3 | 29491 | 35 | |||
150862 | 234 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2994 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 2X3 | 5990616.60068 | 2095284.10448 | 37.7327111945568 | -122.474827739114 | (37.7327111945568, -122.474827739114) | 1 | 8 | 4 | 64 | 40 | |||
152407 | 36328 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 40 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/22/1998 12:00:00 AM | Permit Number 39300 | 5995640.5044713 | 2092769.77027097 | 37.7260972907371 | -122.457277138944 | (37.7260972907371, -122.457277138944) | 9 | 7 | 4 | 28861 | 40 | ||
154538 | 926 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1278 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | 6002807.70183 | 2094157.47604 | 37.7303166558715 | -122.432599664217 | (37.7303166558715, -122.432599664217) | 9 | 7 | 5 | 28861 | 25 | |||
154772 | 85386 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1239 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 49657 | 5981144.8 | 2106623.2 | 37.7632917298848 | -122.508414943002 | (37.7632917298848, -122.508414943002) | 1 | 8 | 3 | 56 | 35 | ||||
156877 | 184169 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 3734 Lawton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5982587.082 | 2104253.9424 | 37.7568713157118 | -122.503251214898 | (37.7568713157118, -122.503251214898) | 1 | 8 | 3 | 56 | 35 | |||
157287 | 115975 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 100 SAN JOSE AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6006168 | 2102576 | 37.7536220187283 | -122.421580311855 | (37.7536220187283, -122.421580311855) | 2 | 4 | 5 | 28859 | 19 | |||
157305 | 34725 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 114 Sutro Heights Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38379 | 5981286.97907127 | 2111325.91865707 | 37.776212402307 | -122.508272287748 | (37.776212402307, -122.508272287748) | 11 | 6 | 2 | 55 | 26 | ||
157838 | 46382 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2495 43rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/05/2002 12:00:00 AM | Permit Number 44618 | 5983000.42559938 | 2098163.19803029 | 37.7401721103617 | -122.501371213543 | (37.7401721103617, -122.501371213543) | 1 | 8 | 3 | 29491 | 35 | ||
158350 | 37082 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1268 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2002 12:00:00 AM | 6 | Permit Number 44549 | 5982146.28824129 | 2106471.58463776 | 37.7629344086854 | -122.504939947841 | (37.7629344086854, -122.504939947841) | 1 | 8 | 3 | 56 | 35 | |
158626 | 50817 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/18/2004 12:00:00 AM | Permit Number 47340 | 5995605.94135709 | 2094497.43585496 | 37.7308390591092 | -122.457521563876 | (37.7308390591092, -122.457521563876) | 9 | 7 | 4 | 28861 | 40 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );