trees
1,408 rows where qSpecies_id = 113 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
68156 | 120329 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1 22nd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 5988944.22714 | 2115048.40717 | 37.7868815758996 | -122.48205685669 | (37.7868815758996, -122.48205685669) | 11 | 6 | 1 | 55 | 33 | |||
12750 | 201353 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1 Bitting Ave | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 6012904.00238 | 2092563.8073 | 37.7265081621175 | -122.397583402851 | (37.7265081621175, -122.397583402851) | 10 | 3 | 8 | 58 | 1 | |||
20879 | 201345 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1 Bitting Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 8ft | 6012754.45078 | 2092609.05906 | 37.7266240856064 | -122.398103573427 | (37.7266240856064, -122.398103573427) | 10 | 3 | 8 | 58 | 1 | |||
23166 | 201343 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1 Bitting Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6012739.9825 | 2092614.25301 | 37.7266375412648 | -122.398153954334 | (37.7266375412648, -122.398153954334) | 10 | 3 | 8 | 58 | 1 | ||||
69717 | 201351 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1 Bitting Ave | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 8ft | 6012866.15074 | 2092573.24489 | 37.7265319680523 | -122.397714917004 | (37.7265319680523, -122.397714917004) | 10 | 3 | 8 | 58 | 1 | |||
117012 | 201354 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1 Bitting Ave | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 6012921.13477 | 2092559.31371 | 37.7264967776018 | -122.397523861451 | (37.7264967776018, -122.397523861451) | 10 | 3 | 8 | 58 | 1 | |||
119137 | 201350 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1 Bitting Ave | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 6012847.3383 | 2092578.90387 | 37.7265464588349 | -122.397780348078 | (37.7265464588349, -122.397780348078) | 10 | 3 | 8 | 58 | 1 | |||
153568 | 201348 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1 Bitting Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 6012808.60563 | 2092591.56329 | 37.7265790619707 | -122.397915133977 | (37.7265790619707, -122.397915133977) | 10 | 3 | 8 | 58 | 1 | |||
160827 | 201352 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1 Bitting Ave | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 6012884.58431 | 2092567.59361 | 37.7265174772786 | -122.397650796243 | (37.7265174772786, -122.397650796243) | 10 | 3 | 8 | 58 | 1 | |||
170212 | 201347 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1 Bitting Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 6012791.8631 | 2092596.61468 | 37.7265919996064 | -122.397973366875 | (37.7265919996064, -122.397973366875) | 10 | 3 | 8 | 58 | 1 | |||
190197 | 201349 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1 Bitting Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 6012827.9931 | 2092586.2696 | 37.7265656062986 | -122.39784774059 | (37.7265656062986, -122.39784774059) | 10 | 3 | 8 | 58 | 1 | |||
194059 | 201346 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1 Bitting Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 6012773.9855 | 2092601.68911 | 37.7266049372574 | -122.398035525332 | (37.7266049372574, -122.398035525332) | 10 | 3 | 8 | 58 | 1 | |||
181809 | 129323 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1 Florence St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6008475.1891 | 2118345.56468 | 37.7970513368976 | -122.414717435764 | (37.7970513368976, -122.414717435764) | 5 | 1 | 10 | 308 | 21 | ||||
3998 | 176849 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1 Gambier St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6005708.05423 | 2093517.46622 | 37.7287233829612 | -122.422527275231 | (37.7287233829612, -122.422527275231) | 9 | 7 | 7 | 309 | 5 | |||
49104 | 176848 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1 Gambier St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6005711.54233 | 2093506.49571 | 37.728693457131 | -122.422514437416 | (37.728693457131, -122.422514437416) | 9 | 7 | 7 | 309 | 5 | |||
172678 | 43140 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1 Gambier St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2000 12:00:00 AM | 3 | Permit Number 42953 | 6005716.63204 | 2093488.39278 | 37.7286440375939 | -122.422495556143 | (37.7286440375939, -122.422495556143) | 9 | 7 | 7 | 309 | 5 | ||
193087 | 176847 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1 Gambier St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6005714.45632 | 2093496.12065 | 37.7286651338862 | -122.422503626641 | (37.7286651338862, -122.422503626641) | 9 | 7 | 7 | 309 | 5 | |||
146958 | 226884 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1 Hidalgo Ter | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 2ft | 6005071.43074 | 2107486.30066 | 37.7670426518224 | -122.425721963013 | (37.7670426518224, -122.425721963013) | 8 | 4 | 5 | 28853 | 19 | |||
130389 | 124569 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1 Jordan Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 5996154.91779 | 2114511.96286 | 37.7858253840714 | -122.457070865676 | (37.7858253840714, -122.457070865676) | 11 | 6 | 1 | 54 | 31 | |||
23191 | 226926 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1 Newburg St | 3 | Sidewalk: Property side : Pot | Tree | Private 2 | 15 | Width 4ft | 6002574.76935 | 2099983.89995 | 37.7463014588644 | -122.433821226777 | (37.7463014588644, -122.433821226777) | 2 | 7 | 5 | 63 | 22 | |||
116117 | 226925 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1 Newburg St | 2 | Sidewalk: Property side : Pot | Tree | Private 2 | 19 | Width 4ft | 6002565.84168 | 2099976.66752 | 37.746281093695 | -122.433851580699 | (37.746281093695, -122.433851580699) | 2 | 7 | 5 | 63 | 22 | |||
127982 | 226924 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1 Newburg St | 1 | Sidewalk: Property side : Pot | Tree | Private 2 | 11 | Width 4ft | 6002558.65829 | 2099967.65757 | 37.7462559468486 | -122.433875776072 | (37.7462559468486, -122.433875776072) | 2 | 7 | 5 | 63 | 22 | |||
24087 | 129112 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 10 Hastings Ter | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6007339.93679 | 2119283.26863 | 37.7995621873977 | -122.418712226998 | (37.7995621873977, -122.418712226998) | 5 | 1 | 1 | 28858 | 32 | ||||
68253 | 129113 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 10 Hastings Ter | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6007329.70066 | 2119282.266 | 37.7995588581063 | -122.418747576633 | (37.7995588581063, -122.418747576633) | 5 | 1 | 1 | 28858 | 32 | ||||
25597 | 218227 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 100 Claremont Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 8ft | 5993831.45355 | 2098825.44748 | 37.742620614658 | -122.463970254628 | (37.742620614658, -122.463970254628) | 1 | 8 | 4 | 59 | 40 | |||
45276 | 218226 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 100 Claremont Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 25 | Width 8ft | 5993838.37632 | 2098869.25868 | 37.7427413081634 | -122.463949497382 | (37.7427413081634, -122.463949497382) | 1 | 8 | 4 | 59 | 40 | |||
62768 | 218229 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 100 Claremont Blvd | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 8ft | 5993803.00449 | 2098718.65979 | 37.7423257629199 | -122.464060872135 | (37.7423257629199, -122.464060872135) | 1 | 8 | 4 | 59 | 40 | |||
86471 | 218228 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 100 Claremont Blvd | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 33 | Width 8ft | 5993822.95601 | 2098779.12669 | 37.742492939687 | -122.463996274721 | (37.742492939687, -122.463996274721) | 1 | 8 | 4 | 59 | 40 | |||
163001 | 218231 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 100 Claremont Blvd | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 8ft | 5993773.53157 | 2098636.12449 | 37.7420974430581 | -122.464156789307 | (37.7420974430581, -122.464156789307) | 1 | 8 | 4 | 59 | 40 | |||
177848 | 218230 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 100 Claremont Blvd | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 8ft | 5993788.79546 | 2098675.54917 | 37.7422065730654 | -122.46410687336 | (37.7422065730654, -122.46410687336) | 1 | 8 | 4 | 59 | 40 | |||
109864 | 219373 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 100 Joost Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 6001373.71026 | 2094967.00776 | 37.7324580174085 | -122.437615112141 | (37.7324580174085, -122.437615112141) | 9 | 7 | 5 | 63 | 40 | |||
148053 | 30812 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 100 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1995 12:00:00 AM | 5 | Permit Number 34674 | 6001381.93618 | 2094967.05294 | 37.7324586091634 | -122.43758667648 | (37.7324586091634, -122.43758667648) | 9 | 7 | 5 | 63 | 40 | |
142349 | 219329 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 100 Miramar Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 5995365.77553 | 2090599.77101 | 37.7201232084876 | -122.458069878247 | (37.7201232084876, -122.458069878247) | 9 | 8 | 6 | 28861 | 24 | |||
5147 | 19819 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 100 STAIRWAY25 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 100ST | |||||||||||||
5627 | 19964 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 100 STAIRWAY41 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 25ST | |||||||||||||
9556 | 19963 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 100 STAIRWAY41 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 25ST | |||||||||||||
11839 | 19962 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 100 STAIRWAY41 | -2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 25ST | |||||||||||||
3905 | 19979 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 100 STAIRWAY45 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 30ST | |||||||||||||
130833 | 106685 | Undocumented 4 | Juniperus chinensis :: Juniper 113 | 100 Yukon St | Front Yard : Cutout | Tree | Private 2 | Permit Number 772768 | 6000197.4 | 2104288 | 37.757984281634 | -122.442350801363 | (37.757984281634, -122.442350801363) | 2 | 4 | 5 | 28862 | 3 | |||||
20320 | 129280 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1009 Green St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 2ft | 6008177.93776 | 2118903.66017 | 37.7985670228078 | -122.415785538977 | (37.7985670228078, -122.415785538977) | 5 | 1 | 10 | 28858 | 21 | |||
150347 | 129282 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1009 Green St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 6008205.81975 | 2118906.85431 | 37.7985773605034 | -122.415689284536 | (37.7985773605034, -122.415689284536) | 5 | 1 | 10 | 28858 | 21 | |||
182686 | 129281 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1009 Green St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 2ft | 6008192.28376 | 2118905.24878 | 37.7985721912037 | -122.415736009712 | (37.7985721912037, -122.415736009712) | 5 | 1 | 10 | 28858 | 21 | |||
85213 | 88347 | Permitted Site 7 | Juniperus chinensis :: Juniper 113 | 100x Vienna St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51332 | 6004738 | 2092796 | 37.7266876232591 | -122.425829482771 | (37.7266876232591, -122.425829482771) | 9 | 7 | 6 | 28861 | 5 | |||
147421 | 120070 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 101 26th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 2ft | 5987678.12293 | 2115272.13774 | 37.7874221569894 | -122.486453661774 | (37.7874221569894, -122.486453661774) | 11 | 6 | 1 | 55 | 33 | |||
179368 | 176778 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 101 Colby St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 3ft | 6008224.08958 | 2093491.78646 | 37.7287944923504 | -122.413827338965 | (37.7287944923504, -122.413827338965) | 9 | 3 | 7 | 309 | 28 | |||
6362 | 176782 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 101 Dartmouth St | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 5ft | 6008503.6919 | 2093600.78461 | 37.7291094763057 | -122.412868435047 | (37.7291094763057, -122.412868435047) | 9 | 3 | 7 | 309 | 28 | |||
62977 | 176780 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 101 Dartmouth St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 6008510.60068 | 2093581.4689 | 37.729056827298 | -122.412843185683 | (37.729056827298, -122.412843185683) | 9 | 3 | 7 | 309 | 28 | |||
145427 | 176779 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 101 Dartmouth St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 6008512.5516 | 2093571.34607 | 37.7290291416799 | -122.412835725785 | (37.7290291416799, -122.412835725785) | 9 | 3 | 7 | 309 | 28 | |||
153896 | 176781 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 101 Dartmouth St | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 6008506.49282 | 2093591.63583 | 37.7290845129336 | -122.412858105444 | (37.7290845129336, -122.412858105444) | 9 | 3 | 7 | 309 | 28 | |||
57437 | 108624 | Property Tree 8 | Juniperus chinensis :: Juniper 113 | 101 GENEBERN WAY | 1 | Front Yard : Yard | Tree | Private 2 | 6005050.2 | 2095237.8 | 37.733409902631 | -122.424923866144 | (37.733409902631, -122.424923866144) | 2 | 7 | 7 | 28861 | 2 | |||||
77461 | 219327 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 101 Miramar Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 5995301.64396 | 2090617.79032 | 37.7201690001713 | -122.458292861552 | (37.7201690001713, -122.458292861552) | 9 | 8 | 6 | 28861 | 24 | |||
147032 | 219328 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 101 Miramar Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 4ft | 5995301.79244 | 2090610.06633 | 37.720147800463 | -122.458291789543 | (37.720147800463, -122.458291789543) | 9 | 8 | 6 | 28861 | 24 | |||
168703 | 219326 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 101 Miramar Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 5995302.40607 | 2090624.56867 | 37.7201876557032 | -122.458290717567 | (37.7201876557032, -122.458290717567) | 9 | 8 | 6 | 28861 | 24 | |||
75219 | 129163 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 101 Parker Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 2ft | 5996819.74722 | 2113790.05212 | 37.7838813662737 | -122.454718579817 | (37.7838813662737, -122.454718579817) | 11 | 6 | 1 | 54 | 31 | |||
2123 | 176806 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 102 Bowdoin St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 6008418.41029 | 2094548.16492 | 37.7317059917167 | -122.413230227789 | (37.7317059917167, -122.413230227789) | 9 | 3 | 7 | 309 | 28 | |||
63819 | 176823 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 102 Bowdoin St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 6008429.95223 | 2094500.17564 | 37.7315748714728 | -122.413186932639 | (37.7315748714728, -122.413186932639) | 9 | 3 | 7 | 309 | 28 | |||
127444 | 176824 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 102 Bowdoin St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 6008431.82226 | 2094483.21435 | 37.7315284044084 | -122.413179268628 | (37.7315284044084, -122.413179268628) | 9 | 3 | 7 | 309 | 28 | |||
170097 | 176822 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 102 Bowdoin St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6008425.8217 | 2094514.97561 | 37.7316152771105 | -122.413202258904 | (37.7316152771105, -122.413202258904) | 9 | 3 | 7 | 309 | 28 | |||
74938 | 219330 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1025 Junipero Serra Blvd | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5991259.76279 | 2090425.50198 | 37.7194079318084 | -122.472250145444 | (37.7194079318084, -122.472250145444) | 9 | 8 | 6 | 64 | 24 | |||
123572 | 219331 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1025 Junipero Serra Blvd | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5991262.34027 | 2090458.54246 | 37.7194988020073 | -122.472243643342 | (37.7194988020073, -122.472243643342) | 9 | 8 | 6 | 64 | 24 | |||
146760 | 219332 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1025 Junipero Serra Blvd | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 5991262.77441 | 2090479.13965 | 37.7195553819492 | -122.47224364333 | (37.7195553819492, -122.47224364333) | 9 | 8 | 6 | 64 | 24 | |||
113738 | 5821 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1027 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 75 | 3X3 | 5999811.0829915 | 2099731.7400522 | 37.745451872839 | -122.443359584044 | (37.745451872839, -122.443359584044) | 2 | 7 | 5 | 63 | 22 | |||
14149 | 176803 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 103 Bowdoin St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 6008471.38448 | 2094562.18285 | 37.731747455866 | -122.413048075521 | (37.731747455866, -122.413048075521) | 9 | 3 | 7 | 309 | 28 | |||
75384 | 176796 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 103 Bowdoin St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 6008486.43054 | 2094496.74036 | 37.7315686095034 | -122.41299143261 | (37.7315686095034, -122.41299143261) | 9 | 3 | 7 | 309 | 28 | |||
86910 | 176801 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 103 Bowdoin St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 6008476.7673 | 2094533.48941 | 37.7316689720313 | -122.413027437877 | (37.7316689720313, -122.413027437877) | 9 | 3 | 7 | 309 | 28 | |||
88595 | 176798 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 103 Bowdoin St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 6008483.53327 | 2094510.3324 | 37.7316057676803 | -122.413002409754 | (37.7316057676803, -122.413002409754) | 9 | 3 | 7 | 309 | 28 | |||
104864 | 176799 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 103 Bowdoin St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 6008480.51195 | 2094517.85625 | 37.7316262569493 | -122.413013386875 | (37.7316262569493, -122.413013386875) | 9 | 3 | 7 | 309 | 28 | |||
165342 | 176797 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 103 Bowdoin St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 6008485.14768 | 2094502.33129 | 37.7315838889801 | -122.412996262887 | (37.7315838889801, -122.412996262887) | 9 | 3 | 7 | 309 | 28 | |||
173400 | 176802 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 103 Bowdoin St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 6008473.4395 | 2094550.88435 | 37.7317165479802 | -122.413040172282 | (37.7317165479802, -122.413040172282) | 9 | 3 | 7 | 309 | 28 | |||
188621 | 176800 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 103 Bowdoin St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 6ft | 6008479.14615 | 2094525.5991 | 37.731647440478 | -122.413018655999 | (37.731647440478, -122.413018655999) | 9 | 3 | 7 | 309 | 28 | |||
83703 | 226897 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1035 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 5999804.0569 | 2099745.02655 | 37.745487953702 | -122.443384833249 | (37.745487953702, -122.443384833249) | 2 | 7 | 5 | 63 | 22 | |||
36388 | 206933 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 105 Flood Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 8ft | 6000003.13616 | 2094038.30798 | 37.7298300014536 | -122.442286850953 | (37.7298300014536, -122.442286850953) | 9 | 7 | 4 | 63 | 40 | |||
68632 | 206936 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 105 Flood Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 8ft | 6000038.50963 | 2094035.1117 | 37.7298232412405 | -122.44216433184 | (37.7298232412405, -122.44216433184) | 9 | 7 | 4 | 63 | 40 | |||
71272 | 206934 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 105 Flood Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | Width 8ft | 6000030.26557 | 2094035.00933 | 37.7298224903164 | -122.442192825064 | (37.7298224903164, -122.442192825064) | 9 | 7 | 4 | 63 | 40 | |||
185342 | 206935 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 105 Flood Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 8ft | 6000034.8522 | 2094044.21533 | 37.7298480292542 | -122.442177629193 | (37.7298480292542, -122.442177629193) | 9 | 7 | 4 | 63 | 40 | |||
178383 | 254277 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 105 Gladeview Way | 1 | Front Yard : Cutout | Tree | Private 2 | 3x6 | Permit Number 781296 | 5997754 | 2101950 | 37.7514251480437 | -122.450632514859 | (37.7514251480437, -122.450632514859) | 1 | 5 | 4 | 63 | 38 | |||
133669 | 190765 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1050 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6015259.20985 | 2101616.65669 | 37.7514962955391 | -122.390073618616 | (37.7514962955391, -122.390073618616) | 10 | 3 | 8 | 28856 | 1 | |||
59374 | 97299 | Permitted Site 7 | Juniperus chinensis :: Juniper 113 | 1051 Portola Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5995688.7 | 2098126.6 | 37.7408086112536 | -122.457497926865 | (37.7408086112536, -122.457497926865) | 9 | 7 | 4 | 59 | 40 | |||||
15832 | 71937 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1053 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6011562.24883 | 2118965.23166 | 37.7989257551836 | -122.404079031531 | (37.7989257551836, -122.404079031531) | 3 | 1 | 10 | 308 | 23 | |||
19573 | 254456 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 1055X Duncan St | 1 | Side Yard : Yard | Tree | Private 2 | |||||||||||||||
17200 | 176807 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 106 Gaven St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 2ft | 6009983.09592 | 2095237.75517 | 37.7336871802039 | -122.407869378985 | (37.7336871802039, -122.407869378985) | 10 | 3 | 7 | 309 | 28 | |||
25844 | 53948 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 106 Gaven St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/2012 12:00:00 AM | 10 | Permit Number 769123 | 6009998.5111 | 2095243.6282 | 37.733704169294 | -122.407816497929 | (37.733704169294, -122.407816497929) | 10 | 3 | 7 | 309 | 28 | ||
2355 | 176777 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 107 Colby St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6008230.80526 | 2093471.1524 | 37.7287382127949 | -122.413802663375 | (37.7287382127949, -122.413802663375) | 9 | 3 | 7 | 309 | 28 | |||
155039 | 129334 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1074 Union St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 2ft | 6007844.96731 | 2119270.12506 | 37.7995545197956 | -122.416963703016 | (37.7995545197956, -122.416963703016) | 5 | 1 | 1 | 308 | 32 | |||
175187 | 129335 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1074 Union St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 2ft | 6007834.34596 | 2119269.05545 | 37.7995509854486 | -122.417000380981 | (37.7995509854486, -122.417000380981) | 5 | 1 | 1 | 308 | 32 | |||
59673 | 96034 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1075 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767673 | 6008986.73093 | 2117980.65751 | 37.7960781193685 | -122.4129215571 | (37.7960781193685, -122.4129215571) | 3 | 1 | 10 | 308 | 21 |
150399 | 129263 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1075 Pacific Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 1ft | 6009008.56152 | 2117982.34641 | 37.796083982049 | -122.412846138133 | (37.796083982049, -122.412846138133) | 3 | 1 | 10 | 308 | 21 | |||
78823 | 129305 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1081 Francisco St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 6006148.36265 | 2120696.43143 | 37.8033752121629 | -122.422936000907 | (37.8033752121629, -122.422936000907) | 5 | 9 | 1 | 28858 | 32 | |||
116337 | 129306 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1081 Francisco St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 6006156.05151 | 2120698.06699 | 37.8033801368411 | -122.422909509591 | (37.8033801368411, -122.422909509591) | 5 | 9 | 1 | 28858 | 32 | |||
130357 | 113985 | Undocumented 4 | Juniperus chinensis :: Juniper 113 | 109 MADRONE AVE | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x10 | 5992778 | 2098364 | 37.7412928293111 | -122.467579208879 | (37.7412928293111, -122.467579208879) | 1 | 8 | 4 | 59 | 40 | ||||
60444 | 219325 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1090 Capitol Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 1ft | 5995080.68108 | 2091195.92209 | 37.7217437121824 | -122.459098491296 | (37.7217437121824, -122.459098491296) | 9 | 8 | 6 | 28861 | 24 | |||
61404 | 219320 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1090 Capitol Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 1ft | 5995079.65544 | 2091128.71847 | 37.7215591281313 | -122.459097172915 | (37.7215591281313, -122.459097172915) | 9 | 8 | 6 | 28861 | 24 | |||
68712 | 219322 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1090 Capitol Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 1ft | 5995079.87033 | 2091157.19902 | 37.7216373412734 | -122.459098491322 | (37.7216373412734, -122.459098491322) | 9 | 8 | 6 | 28861 | 24 | |||
116436 | 219324 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1090 Capitol Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 1ft | 5995080.31545 | 2091178.45891 | 37.7216957414424 | -122.459098491311 | (37.7216957414424, -122.459098491311) | 9 | 8 | 6 | 28861 | 24 | |||
129420 | 219321 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1090 Capitol Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 1ft | 5995079.2109 | 2091143.91965 | 37.7216008413857 | -122.459099809712 | (37.7216008413857, -122.459099809712) | 9 | 8 | 6 | 28861 | 24 | |||
142996 | 219323 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1090 Capitol Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 1ft | 5995079.72755 | 2091168.59616 | 37.7216686268896 | -122.459099809715 | (37.7216686268896, -122.459099809715) | 9 | 8 | 6 | 28861 | 24 | |||
111742 | 190772 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1099 Tennessee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 1ft | 6015576.75199 | 2103999.13742 | 37.7580556897494 | -122.389141847222 | (37.7580556897494, -122.389141847222) | 10 | 3 | 8 | 28856 | 29 | |||
96357 | 129209 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 11 Normandie Ter | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6000909.22566 | 2117310.8698 | 37.793782337235 | -122.440823181871 | (37.793782337235, -122.440823181871) | 13 | 9 | 1 | 57 | 27 | |||
96435 | 129208 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 11 Normandie Ter | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6000907.37707 | 2117323.47168 | 37.7938168334195 | -122.440830482554 | (37.7938168334195, -122.440830482554) | 13 | 9 | 1 | 57 | 27 | |||
104285 | 129213 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 11 Normandie Ter | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6000915.05928 | 2117274.38469 | 37.7936824909003 | -122.440800378652 | (37.7936824909003, -122.440800378652) | 13 | 9 | 1 | 57 | 27 |
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) );