trees
713 rows where qSpecies_id = 102 sorted by qAddress
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
123908 | 36016 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1 Aztec St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39162 | 6007570.41549465 | 2099594.16926829 | 37.7455135625182 | -122.416519230897 | (37.7455135625182, -122.416519230897) | 2 | 7 | 7 | 28859 | 2 | ||
80696 | 35933 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1 Bache St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/1998 12:00:00 AM | Permit Number 39099 | 6007238.86373216 | 2095730.63225463 | 37.7348864958229 | -122.417391936393 | (37.7348864958229, -122.417391936393) | 2 | 7 | 7 | 28859 | 2 | ||
24775 | 223151 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1 Mizpah St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6001079.42041 | 2096656.30297 | 37.7370796927675 | -122.438753546857 | (37.7370796927675, -122.438753546857) | 2 | 7 | 5 | 63 | 7 | |||
122843 | 223150 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1 Mizpah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6001059.20928 | 2096606.02986 | 37.7369405046912 | -122.438819824198 | (37.7369405046912, -122.438819824198) | 2 | 7 | 5 | 63 | 7 | |||
117294 | 206752 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 10 Beachmont Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5990858.79883 | 2095874.41908 | 37.7343460811043 | -122.474033463291 | (37.7343460811043, -122.474033463291) | 1 | 8 | 4 | 64 | 40 | |||
20720 | 223188 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 100 Jarboe Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007765.60912 | 2096998.87207 | 37.7383984271532 | -122.415660555692 | (37.7383984271532, -122.415660555692) | 2 | 7 | 7 | 28859 | 2 | |||
92083 | 223189 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 100 Jarboe Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007749.84894 | 2096999.90906 | 37.7384003885566 | -122.415715120276 | (37.7384003885566, -122.415715120276) | 2 | 7 | 7 | 28859 | 2 | |||
151695 | 40700 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 100 Oxford St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/10/1999 12:00:00 AM | Permit Number 41678 | 6006308.40202986 | 2093422.77537775 | 37.7284972327963 | -122.420445112942 | (37.7284972327963, -122.420445112942) | 9 | 7 | 7 | 309 | 5 | ||
130211 | 37005 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1020 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | Permit Number 39619 | 6009145.39950395 | 2103208.82638873 | 37.7555270538097 | -122.411328468714 | (37.7555270538097, -122.411328468714) | 2 | 4 | 7 | 28859 | 19 | ||
113029 | 223227 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1020 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003760.93763 | 2102337.6882 | 37.7528316502607 | -122.429887466251 | (37.7528316502607, -122.429887466251) | 2 | 4 | 5 | 28862 | 22 | |||
7281 | 258376 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1030 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3x3 | 6007799.31029 | 2093439.67558 | 37.7286275425489 | -122.415292145905 | (37.7286275425489, -122.415292145905) | 9 | 3 | 7 | 309 | 5 | |||
5746 | 258377 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1036 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3x3 | 6007782.72545 | 2093434.59134 | 37.7286126501976 | -122.415349121053 | (37.7286126501976, -122.415349121053) | 9 | 3 | 7 | 309 | 5 | |||
57377 | 82603 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 105 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | Permit Number 52217 | 6006478.75414254 | 2105491.02124356 | 37.7616435085797 | -122.420712577969 | (37.7616435085797, -122.420712577969) | 2 | 4 | 7 | 28859 | 19 | |||
69861 | 82602 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 105 Lexington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | Permit Number 52217 | 6006478.75414254 | 2105491.02124356 | 37.7616435085797 | -122.420712577969 | (37.7616435085797, -122.420712577969) | 2 | 4 | 7 | 28859 | 19 | |||
111257 | 80941 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 105 Lexington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | Permit Number 52217 | 6006478.75414254 | 2105491.02124356 | 37.7616435085797 | -122.420712577969 | (37.7616435085797, -122.420712577969) | 2 | 4 | 7 | 28859 | 19 | |||
6544 | 223185 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 105x Bennington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007139 | 2097159 | 37.7388028593756 | -122.417838417363 | (37.7388028593756, -122.417838417363) | 2 | 7 | 7 | 28859 | 2 | |||
7017 | 223186 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 105x Bennington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007192 | 2097251 | 37.7390584535481 | -122.417661686747 | (37.7390584535481, -122.417661686747) | 2 | 7 | 7 | 28859 | 2 | |||
14459 | 223187 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 105x Bennington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007139 | 2097159 | 37.7388028593756 | -122.417838417363 | (37.7388028593756, -122.417838417363) | 2 | 7 | 7 | 28859 | 2 | |||
95073 | 223164 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 108 Bronte St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009300.4941 | 2096807.16839 | 37.7379582117093 | -122.410340117908 | (37.7379582117093, -122.410340117908) | 10 | 7 | 7 | 28859 | 2 | |||
129269 | 206770 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 110 El Verano Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5994495.29595 | 2094647.99704 | 37.7311886036557 | -122.461372126729 | (37.7311886036557, -122.461372126729) | 9 | 8 | 4 | 59 | 40 | |||
415 | 190934 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1101 25th St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 9ft | 6015168.60212 | 2102024.17667 | 37.7526102335912 | -122.390415424833 | (37.7526102335912, -122.390415424833) | 10 | 3 | 8 | 28856 | 1 | |||
4597 | 190929 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1101 25th St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 9ft | 6015301.73602 | 2102030.54675 | 37.752635108841 | -122.389955465678 | (37.752635108841, -122.389955465678) | 10 | 3 | 8 | 28856 | 1 | |||
108831 | 190930 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1101 25th St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 9ft | 6015277.62058 | 2102029.1535 | 37.7526299458258 | -122.390038764478 | (37.7526299458258, -122.390038764478) | 10 | 3 | 8 | 28856 | 1 | |||
114299 | 190932 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1101 25th St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 9ft | 6015229.59957 | 2102026.97334 | 37.7526212961411 | -122.390204678629 | (37.7526212961411, -122.390204678629) | 10 | 3 | 8 | 28856 | 1 | |||
166719 | 190933 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1101 25th St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 9ft | 6015201.2247 | 2102025.49065 | 37.7526156511008 | -122.390302701123 | (37.7526156511008, -122.390302701123) | 10 | 3 | 8 | 28856 | 1 | |||
180455 | 190931 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1101 25th St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 9ft | 6015254.41614 | 2102028.26395 | 37.752626216333 | -122.390118948029 | (37.752626216333, -122.390118948029) | 10 | 3 | 8 | 28856 | 1 | |||
1780 | 223125 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1105 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6009223.64941 | 2102625.89478 | 37.7539308430518 | -122.411016683293 | (37.7539308430518, -122.411016683293) | 2 | 4 | 7 | 28859 | 19 | |||
87136 | 52166 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1105 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/2005 12:00:00 AM | Permit Number 48359 | 6009224.65116048 | 2102717.63459766 | 37.7541827961751 | -122.411019698364 | (37.7541827961751, -122.411019698364) | 2 | 4 | 7 | 28859 | 19 | ||
10416 | 42198 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1108 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42472 | 6010019.96061049 | 2108918.62513791 | 37.7712538746338 | -122.408706742901 | (37.7712538746338, -122.408706742901) | 8 | 2 | 9 | 28853 | 34 | ||
120424 | 47060 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 114 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2002 12:00:00 AM | Permit Number 45048 | 6004275.94265243 | 2109216.94695979 | 37.7717496035942 | -122.428596811267 | (37.7717496035942, -122.428596811267) | 7 | 9 | 11 | 28852 | 10 | |||
107633 | 87907 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 115 Highland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50927 | 6005502.7 | 2096707.7 | 37.7374714688831 | -122.42346390758 | (37.7374714688831, -122.42346390758) | 2 | 7 | 7 | 28859 | 2 | ||
142981 | 223137 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 115 Highland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6005502.70721 | 2096694.07923 | 37.7374340697101 | -122.423462914599 | (37.7374340697101, -122.423462914599) | 2 | 7 | 7 | 28859 | 2 | |||
99071 | 206730 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 115 Lawton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5993913.80681 | 2104584.90061 | 37.7584393504094 | -122.46410351439 | (37.7584393504094, -122.46410351439) | 1 | 8 | 4 | 56 | 12 | |||
143081 | 48953 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1155 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/2002 12:00:00 AM | Permit Number 46139 | 6009500.74518539 | 2102451.82232494 | 37.7534684137838 | -122.410046128834 | (37.7534684137838, -122.410046128834) | 2 | 4 | 7 | 28859 | 19 | |||
104240 | 38918 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 116 De Soto St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40728 | 5993276.12701887 | 2091907.60614304 | 37.7235939185401 | -122.465387983379 | (37.7235939185401, -122.465387983379) | 9 | 8 | 4 | 59 | 40 | ||
160194 | 38917 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 116 De Soto St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40728 | 5993276.12701887 | 2091907.60614304 | 37.7235939185401 | -122.465387983379 | (37.7235939185401, -122.465387983379) | 9 | 8 | 4 | 59 | 40 | ||
183727 | 32762 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 118 Thrift St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | 4 | Permit Number 37137 | 5995714.52093 | 2089647.57349 | 37.7175287309449 | -122.456795559591 | (37.7175287309449, -122.456795559591) | 9 | 8 | 6 | 28861 | 24 | |
166053 | 176079 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1183 Munich St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 6001144.67239 | 2087111.03395 | 37.7108742640178 | -122.437844474361 | (37.7108742640178, -122.437844474361) | 9 | 7 | 6 | 28861 | 5 | |||
3902 | 223217 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1191 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6003256 | 2101366 | 37.75013501563 | -122.431564267794 | (37.75013501563, -122.431564267794) | 2 | 4 | 5 | 28862 | 22 | |||
6305 | 223216 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1199 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6003236.71936 | 2101328.34532 | 37.7500305318879 | -122.431628253337 | (37.7500305318879, -122.431628253337) | 2 | 4 | 5 | 28862 | 22 | |||
186434 | 223215 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1199 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6003236.12918 | 2101299.7559 | 37.7499519986058 | -122.43162825334 | (37.7499519986058, -122.43162825334) | 2 | 4 | 5 | 28862 | 22 | |||
5030 | 171365 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 12 Avalon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2019 12:00:00 AM | 3 | Width 3ft | 6002871.58236 | 2093130.52409 | 37.7275005001327 | -122.432305504906 | (37.7275005001327, -122.432305504906) | 9 | 7 | 6 | 28861 | 5 | ||
35776 | 223254 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 12 Buena Vista Ter | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6001416.18598 | 2108119.15554 | 37.7685730857195 | -122.438410209957 | (37.7685730857195, -122.438410209957) | 15 | 5 | 5 | 29492 | 3 | |||
142016 | 223253 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 12 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6001414.63525 | 2108139.27095 | 37.7686282294424 | -122.438417015146 | (37.7686282294424, -122.438417015146) | 15 | 5 | 5 | 29492 | 3 | |||
48847 | 40753 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 120 Corona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/13/1999 12:00:00 AM | Permit Number 41723 | 5992987.31701285 | 2091988.45595539 | 37.7237992517995 | -122.466392213704 | (37.7237992517995, -122.466392213704) | 9 | 8 | 4 | 59 | 40 | ||
11641 | 223098 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 120 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6004264.58531 | 2109293.13989 | 37.7719581680779 | -122.428641529305 | (37.7719581680779, -122.428641529305) | 7 | 9 | 11 | 28852 | 10 | |||
55577 | 47062 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 120 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/02/2002 12:00:00 AM | Permit Number 45049 | 6004269.57542485 | 2109262.75093616 | 37.7718750098204 | -122.42862210153 | (37.7718750098204, -122.42862210153) | 7 | 9 | 11 | 28852 | 10 | ||
75618 | 47063 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 120 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2002 12:00:00 AM | Permit Number 45049 | 6004269.57542485 | 2109262.75093616 | 37.7718750098204 | -122.42862210153 | (37.7718750098204, -122.42862210153) | 7 | 9 | 11 | 28852 | 10 | |||
179869 | 223235 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 121 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6000463.2173 | 2104877.87281 | 37.7596190747751 | -122.441473822477 | (37.7596190747751, -122.441473822477) | 2 | 4 | 5 | 28862 | 3 | |||
124761 | 206728 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 121 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5993876.34057 | 2104584.05137 | 37.7584348592037 | -122.464233026658 | (37.7584348592037, -122.464233026658) | 1 | 8 | 4 | 56 | 12 | |||
137567 | 206729 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 121 Lawton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5993888.8383 | 2104584.77031 | 37.7584375535646 | -122.464189856478 | (37.7584375535646, -122.464189856478) | 1 | 8 | 4 | 56 | 12 | |||
102589 | 39198 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1213 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/26/2002 12:00:00 AM | Permit Number 46144 | 6010063.59711896 | 2102133.62856163 | 37.7526262552662 | -122.408077219023 | (37.7526262552662, -122.408077219023) | 2 | 4 | 7 | 28859 | 19 | ||
104127 | 223088 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1213 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6010058.98146 | 2102047.36432 | 37.7523891343723 | -122.408087097659 | (37.7523891343723, -122.408087097659) | 2 | 4 | 7 | 28859 | 19 | |||
20965 | 37421 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1215 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39901 | 6003240.50544879 | 2101168.34074207 | 37.7495914114978 | -122.431603738981 | (37.7495914114978, -122.431603738981) | 2 | 4 | 5 | 28862 | 22 | ||
127148 | 47319 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1215 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/10/2002 12:00:00 AM | Permit Number 45247 | 6010064.213398 | 2102122.46814507 | 37.7525956457459 | -122.408074300806 | (37.7525956457459, -122.408074300806) | 2 | 4 | 7 | 28859 | 19 | ||
185118 | 223087 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1215 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010059.28582 | 2102034.7941 | 37.752354636379 | -122.408085158703 | (37.752354636379, -122.408085158703) | 2 | 4 | 7 | 28859 | 19 | |||
132486 | 223214 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1217 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003242.81393 | 2101159.78888 | 37.7495680609386 | -122.431595145715 | (37.7495680609386, -122.431595145715) | 2 | 4 | 5 | 28862 | 22 | |||
17649 | 223213 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1229 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003245.25071 | 2101106.06647 | 37.7494206899277 | -122.431582884368 | (37.7494206899277, -122.431582884368) | 2 | 4 | 5 | 28862 | 22 | |||
118380 | 223212 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1229 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003247.78761 | 2101091.53692 | 37.7493809389847 | -122.431573074546 | (37.7493809389847, -122.431573074546) | 2 | 4 | 5 | 28862 | 22 | |||
161068 | 37429 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1229 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39904 | 6003244.98413008 | 2101088.21150407 | 37.7493716492712 | -122.431582531662 | (37.7493716492712, -122.431582531662) | 2 | 4 | 5 | 28862 | 22 | ||
163177 | 37430 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1229 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39904 | 6003244.98413008 | 2101088.21150407 | 37.7493716492712 | -122.431582531662 | (37.7493716492712, -122.431582531662) | 2 | 4 | 5 | 28862 | 22 | ||
70310 | 223106 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 124 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007933.80449 | 2098026.23649 | 37.7412287968815 | -122.415151718399 | (37.7412287968815, -122.415151718399) | 2 | 7 | 7 | 28859 | 2 | |||
139525 | 47105 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 124 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2002 12:00:00 AM | Permit Number 45089 | 6007923.53662616 | 2098042.04046144 | 37.7412716140529 | -122.415188339569 | (37.7412716140529, -122.415188339569) | 2 | 7 | 7 | 28859 | 2 | ||
176535 | 223097 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 124 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6004260.2997 | 2109306.43724 | 37.7719944368218 | -122.428657301609 | (37.7719944368218, -122.428657301609) | 7 | 9 | 11 | 28852 | 10 | |||
122367 | 94984 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 125 Chilton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2010 12:00:00 AM | 3x3 | Permit Number 54009 | 6001652.7 | 2095380.5 | 37.733609230584 | -122.436680167887 | (37.733609230584, -122.436680167887) | 9 | 7 | 5 | 63 | 40 | ||
79532 | 40759 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 125 De Soto St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/09/2003 12:00:00 AM | Permit Number 46577 | 5993244.02089224 | 2091981.15429222 | 37.723794012147 | -122.465504308143 | (37.723794012147, -122.465504308143) | 9 | 8 | 4 | 59 | 40 | ||
155745 | 206757 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 125 Montalvo Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5993771.47174 | 2099572.51825 | 37.7446684258232 | -122.464231877296 | (37.7446684258232, -122.464231877296) | 1 | 8 | 4 | 29491 | 40 | |||
149758 | 223091 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1257 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6010331.58374 | 2101901.50724 | 37.7520039025724 | -122.407134109472 | (37.7520039025724, -122.407134109472) | 10 | 4 | 7 | 28859 | 19 | |||
146083 | 46649 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 126 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/19/2002 12:00:00 AM | 2 | Permit Number 44781 | 5990552.50864 | 2114536.58834 | 37.7855696722643 | -122.476455229383 | (37.7855696722643, -122.476455229383) | 11 | 6 | 2 | 54 | 26 | |
111205 | 223165 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 126 Bronte St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009293.75232 | 2096732.49395 | 37.7377527939414 | -122.410358156527 | (37.7377527939414, -122.410358156527) | 10 | 7 | 7 | 28859 | 2 | |||
134039 | 223090 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1261 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6010331.77576 | 2101864.81517 | 37.7519031650082 | -122.407130859298 | (37.7519031650082, -122.407130859298) | 10 | 4 | 7 | 28859 | 19 | |||
185783 | 206726 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 127 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5993852.03575 | 2104584.23438 | 37.7584339607877 | -122.464317096167 | (37.7584339607877, -122.464317096167) | 1 | 8 | 4 | 56 | 12 | |||
193674 | 206727 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 127 Lawton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5993862.54978 | 2104584.34087 | 37.7584348592109 | -122.46428074199 | (37.7584348592109, -122.46428074199) | 1 | 8 | 4 | 56 | 12 | |||
36063 | 223116 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 13 Stoneman St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008405.91567 | 2099418.14842 | 37.7450772000642 | -122.413617744757 | (37.7450772000642, -122.413617744757) | 2 | 7 | 7 | 28859 | 2 | |||
68000 | 223115 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 13 Stoneman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008380.04345 | 2099417.01696 | 37.7450726404839 | -122.413707126608 | (37.7450726404839, -122.413707126608) | 2 | 7 | 7 | 28859 | 2 | |||
118603 | 223191 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 13 Stoneman St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6008424.41271 | 2099410.32607 | 37.7450567602768 | -122.413553231903 | (37.7450567602768, -122.413553231903) | 2 | 7 | 7 | 28859 | 2 | |||
156002 | 223192 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 13 Stoneman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6008381.69847 | 2099413.06751 | 37.7450618891094 | -122.413701124524 | (37.7450618891094, -122.413701124524) | 2 | 7 | 7 | 28859 | 2 | |||
116717 | 12682 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1301 Lake St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3X3 | 5991420.04587 | 2114750.06606 | 37.7862060986351 | -122.473469409938 | (37.7862060986351, -122.473469409938) | 11 | 6 | 2 | 54 | 26 | |||
121602 | 12681 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1301 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3X3 | 5991402.68343 | 2114747.84559 | 37.7861989963881 | -122.473529316812 | (37.7861989963881, -122.473529316812) | 11 | 6 | 2 | 54 | 26 | |||
143673 | 199806 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1305 Carroll Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6015615.5318 | 2090822.5842 | 37.7218777199193 | -122.388088213537 | (37.7218777199193, -122.388088213537) | 10 | 3 | 8 | 58 | 1 | |||
104356 | 199804 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1315 Carroll Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6015572.2876 | 2090853.6469 | 37.7219606159851 | -122.388239865807 | (37.7219606159851, -122.388239865807) | 10 | 3 | 8 | 58 | 1 | |||
70199 | 223057 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1322 Florida St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6009511.44921 | 2101438.75289 | 37.7506873508626 | -122.40993760204 | (37.7506873508626, -122.40993760204) | 2 | 4 | 7 | 28859 | 19 | |||
122824 | 223086 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1325 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 6ft | 6010089.04451 | 2101486.66986 | 37.7508512747783 | -122.407943598216 | (37.7508512747783, -122.407943598216) | 2 | 4 | 7 | 28859 | 19 | |||
156213 | 38599 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1334 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 1 | Permit Number 40550 | 6016508.9427 | 2093376.549 | 37.7289398652867 | -122.385177756249 | (37.7289398652867, -122.385177756249) | 10 | 3 | 8 | 58 | 1 | |
74563 | 223058 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1340 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009516.43937 | 2101356.13041 | 37.7504607675611 | -122.409914513765 | (37.7504607675611, -122.409914513765) | 2 | 4 | 7 | 28859 | 19 | |||
50051 | 32387 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 135 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/03/1996 12:00:00 AM | 7 | Permit Number 36930 | 6005715.56726 | 2096415.13611 | 37.736680166259 | -122.422707139641 | (37.736680166259, -122.422707139641) | 2 | 7 | 7 | 28859 | 2 | |
177620 | 223119 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 136 Newman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6007270.88561 | 2096752.20058 | 37.7376932993062 | -122.417353596897 | (37.7376932993062, -122.417353596897) | 2 | 7 | 7 | 28859 | 2 | |||
25089 | 206711 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1366 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5991481.24454 | 2106127.13421 | 37.7625334160042 | -122.472628758222 | (37.7625334160042, -122.472628758222) | 1 | 8 | 11 | 56 | 12 | |||
23893 | 206710 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1370 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5991484.15293 | 2106105.9073 | 37.7624753009047 | -122.472617151554 | (37.7624753009047, -122.472617151554) | 1 | 8 | 11 | 56 | 12 | |||
105472 | 41834 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1370 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42219 | 5991486.44352722 | 2106096.79372587 | 37.7624504100425 | -122.472608564807 | (37.7624504100425, -122.472608564807) | 1 | 8 | 11 | 56 | 12 | ||
44807 | 121103 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1374 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 5991487.33915366 | 2106070.76020768 | 37.7623789807661 | -122.472603569045 | (37.7623789807661, -122.472603569045) | 1 | 8 | 11 | 56 | 12 | |||
186629 | 206709 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1374 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5991483.07743 | 2106081.42222 | 37.7624080091318 | -122.472619086012 | (37.7624080091318, -122.472619086012) | 1 | 8 | 11 | 56 | 12 | |||
28412 | 223085 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1383 York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6010105.40683 | 2101175.29906 | 37.7499972353919 | -122.407865061343 | (37.7499972353919, -122.407865061343) | 2 | 4 | 7 | 28859 | 19 | |||
136121 | 223084 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1383 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6010107.30184 | 2101158.22859 | 37.7499504697387 | -122.407857304679 | (37.7499504697387, -122.407857304679) | 2 | 4 | 7 | 28859 | 19 | |||
190643 | 34345 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1383 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1998 12:00:00 AM | Permit Number 39472 | 6010117.3573919 | 2101160.06487497 | 37.7499560747185 | -122.407822661385 | (37.7499560747185, -122.407822661385) | 2 | 4 | 7 | 28859 | 19 | ||
77212 | 223080 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1384 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010069.44691 | 2101171.84384 | 37.749985734861 | -122.407989169564 | (37.749985734861, -122.407989169564) | 2 | 4 | 7 | 28859 | 19 | |||
81450 | 223081 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1384 York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010072.14302 | 2101152.80267 | 37.7499336029604 | -122.40797850361 | (37.7499336029604, -122.40797850361) | 2 | 4 | 7 | 28859 | 19 | |||
135307 | 40184 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1402 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/1999 12:00:00 AM | 3 | 9x6 | Permit Number 41371 | 6013366.18337 | 2105703.90093 | 37.7626138064095 | -122.396906512841 | (37.7626138064095, -122.396906512841) | 14 | 3 | 8 | 28856 | 29 | |
120465 | 47321 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1417 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/10/2002 12:00:00 AM | Permit Number 45249 | 6010127.95501963 | 2100968.14879638 | 37.7494297087612 | -122.407772483241 | (37.7494297087612, -122.407772483241) | 2 | 4 | 7 | 28859 | 19 | ||
114238 | 206716 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1418 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5991169.70618 | 2105739.42575 | 37.7614508337096 | -122.473677961264 | (37.7614508337096, -122.473677961264) | 1 | 8 | 4 | 56 | 12 |
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) );