3,247 rows where qSpecies_id = 22 sorted by qAddress

View and edit SQL

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)
796 36869 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22   4 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
15898 36871 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22   1 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
16336 36872 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22   2 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
17433 36873 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22   3 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
123224 226146 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 0 Chattanooga St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6004672.1171 2103577.59935 37.7562877143308 -122.426824733282 (37.7562877143308, -122.426824733282) 2 4 5 28862 22
157135 201616 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 0 Innes Ct 1 Sidewalk: Curb side : Yard Tree Private 2     1 Width 3ft   6021349.55513 2092801.07471 37.7276263098888 -122.368403462858 (37.7276263098888, -122.368403462858) 10 3 8 58 1
141075 143068 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1 Child St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   6010607.1256 2120351.0165 37.8026773688895 -122.407481842223 (37.8026773688895, -122.407481842223) 3 1 10 308 23
3597 93954 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1 Hawthorne St 4 Sidewalk: Curb side : Cutout Tree Private 2   04/30/2010 12:00:00 AM 2 3x3 Permit Number 53397 6012934.64989 2114104.90951 37.7856570416874 -122.398988719454 (37.7856570416874, -122.398988719454) 6 2 9 28855 6
40744 93957 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1 Hawthorne St 7 Sidewalk: Curb side : Cutout Tree Private 2   04/30/2010 12:00:00 AM 2 3x3 Permit Number 53397 6012892.58363 2114155.98675 37.7857949437324 -122.399137844145 (37.7857949437324, -122.399137844145) 6 2 9 28855 6
49329 93956 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1 Hawthorne St 6 Sidewalk: Curb side : Cutout Tree Private 2   04/30/2010 12:00:00 AM 1 3x3 Permit Number 53397 6012912.43006 2114137.6628 37.7857457364097 -122.399067893988 (37.7857457364097, -122.399067893988) 6 2 9 28855 6
64206 93953 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1 Hawthorne St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/30/2010 12:00:00 AM 2 3x3 Permit Number 53397 6012948.58524 2114090.90941 37.7856193771856 -122.398939523867 (37.7856193771856, -122.398939523867) 6 2 9 28855 6
72195 93955 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1 Hawthorne St 5 Sidewalk: Curb side : Cutout Tree Private 2   04/30/2010 12:00:00 AM 2 3x3 Permit Number 53397 6012923.46043 2114122.83633 37.7857056410428 -122.399028690747 (37.7857056410428, -122.399028690747) 6 2 9 28855 6
115432 93951 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1 Hawthorne St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/30/2010 12:00:00 AM 2 3x3 Permit Number 53397 6012976.25628 2114064.01935 37.7855470851813 -122.398841901552 (37.7855470851813, -122.398841901552) 6 2 9 28855 6
188638 93952 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1 Hawthorne St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/30/2010 12:00:00 AM 3 3x3 Permit Number 53397 6012964.97703 2114077.52304 37.7855835346973 -122.398881872795 (37.7855835346973, -122.398881872795) 6 2 9 28855 6
6849 45748 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1 Locust St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/12/2001 12:00:00 AM 3   Permit Number 44395 5997461.24318 2116299.42267 37.7908082054694 -122.452680420191 (37.7908082054694, -122.452680420191) 11 6 1 54 31
73233 128889 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1 Locust St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5997463.35178 2116288.09249 37.790777216646 -122.452672306504 (37.790777216646, -122.452672306504) 11 6 1 54 31
86253 128892 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1 Locust St 5 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5997467.54437 2116264.26497 37.7907120328778 -122.452656080026 (37.7907120328778, -122.452656080026) 11 6 1 54 31
106750 128891 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1 Locust St 4 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5997465.76158 2116272.47482 37.7907344727794 -122.452662841125 (37.7907344727794, -122.452662841125) 11 6 1 54 31
160826 128893 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1 Locust St 6 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5997470.08406 2116254.87167 37.7906863869072 -122.452646614665 (37.7906863869072, -122.452646614665) 11 6 1 54 31
179197 128890 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1 Locust St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5997463.97068 2116280.29604 37.7907558451418 -122.452669602227 (37.7907558451418, -122.452669602227) 11 6 1 54 31
4169 56472 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 1 Massasoit St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/03/2014 12:00:00 AM 3   Permit Number 773427 6010126.92776078 2099291.06805198 37.7448247552135 -122.40765780266 (37.7448247552135, -122.40765780266) 2 7 7 28859 2
121742 1389 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 10 Ardath Ct 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/11/2006 12:00:00 AM 3 3X4   6017228.6912616 2095462.3520099 37.7347068580177 -122.382834602513 (37.7347068580177, -122.382834602513) 10 3 8 58 1
161927 92973 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 10 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2         Tree 1 on Market St. 6001664 2105786 37.7621809066996 -122.437385951828 (37.7621809066996, -122.437385951828) 15 5 5 28862 3
34825 129006 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 10 Fallon Pl 2 Sidewalk: Property side : Yard Tree Private 2     3     6008915.40705 2118578.41421 37.7977154080083 -122.413210643283 (37.7977154080083, -122.413210643283) 3 1 10 308 21
72483 225618 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 10 Lippard Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6002076.31903 2096053.65466 37.7354816235692 -122.435263729452 (37.7354816235692, -122.435263729452) 2 7 5 63 7
162801 192442 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 10 McLea Ct 6 : Tree Private 2     2 Width 3ft   6010037.84763 2109199.90386 37.7720272027263 -122.408664716903 (37.7720272027263, -122.408664716903) 14 2 9 28853 34
183852 192441 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 10 McLea Ct 5 : Tree Private 2     2 Width 3ft   6010051.80213 2109236.00979 37.7721271227961 -122.408618994484 (37.7721271227961, -122.408618994484) 14 2 9 28853 34
184629 192440 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 10 McLea Ct 3 : Tree Private 2     2 Width 3ft   6010071.61086 2109254.18785 37.7721781449322 -122.408551756678 (37.7721781449322, -122.408551756678) 14 2 9 28853 34
42091 219138 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 10 Monterey Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6002033.17044 2094872.15307 37.7322350413038 -122.435328423075 (37.7322350413038, -122.435328423075) 9 7 4 63 40
131751 219137 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 10 Monterey Blvd 5 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6001957.40334 2094833.90081 37.732125706236 -122.435587631073 (37.732125706236, -122.435587631073) 9 7 4 63 40
142956 219141 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 10 Monterey Blvd 4 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6001980.05699 2094846.15249 37.7321606331964 -122.435510188655 (37.7321606331964, -122.435510188655) 9 7 4 63 40
161234 219139 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 10 Monterey Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6002013.34207 2094862.23944 37.7322066946676 -122.435396265231 (37.7322066946676, -122.435396265231) 9 7 4 63 40
182150 219140 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 10 Monterey Blvd 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6002002.66106 2094856.00835 37.732188978917 -122.43543274625 (37.732188978917, -122.43543274625) 9 7 4 63 40
35703 228320 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 10 Rose St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6006273.61713 2109890.30806 37.7737113424482 -122.421734550735 (37.7737113424482, -122.421734550735) 7 9 11 28852 10
46635 228321 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 10 Rose St 4 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6006257.78716 2109887.18689 37.7737018797836 -122.421789087419 (37.7737018797836, -122.421789087419) 7 9 11 28852 10
86850 228326 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 10 Rose St 9 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6006167.99201 2109877.54342 37.7736703369359 -122.422099018072 (37.7736703369359, -122.422099018072) 7 9 11 28852 10
92805 228319 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 10 Rose St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6006324.21381 2109901.13969 37.773743936574 -122.421560298068 (37.773743936574, -122.421560298068) 7 9 11 28852 10
107203 228318 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 10 Rose St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6006345.06418 2109905.30645 37.7737565531424 -122.42148846921 (37.7737565531424, -122.42148846921) 7 9 11 28852 10
109499 228324 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 10 Rose St 7 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6006206.47677 2109879.05055 37.7736766456861 -122.421966000227 (37.7736766456861, -122.421966000227) 7 9 11 28852 10
118527 228327 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 10 Rose St 10 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6006141.43109 2109876.17462 37.7736650804216 -122.422190799263 (37.7736650804216, -122.422190799263) 7 9 11 28852 10
124366 228325 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 10 Rose St 8 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6006186.85777 2109878.68777 37.7736745430901 -122.422033839708 (37.7736745430901, -122.422033839708) 7 9 11 28852 10
148499 228322 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 10 Rose St 5 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6006240.81173 2109884.47213 37.7736934684005 -122.421847615292 (37.7736934684005, -122.421847615292) 7 9 11 28852 10
159640 228323 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 10 Rose St 6 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6006226.54275 2109882.46757 37.7736871596597 -122.421896831567 (37.7736871596597, -122.421896831567) 7 9 11 28852 10
68088 226177 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6007585.38429 2098145.93442 37.7415378740877 -122.41636491103 (37.7415378740877, -122.41636491103) 2 7 7 28859 2
2836 219119 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100 Brompton Ave 11 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6002030.49307 2095074.13161 37.7327894760326 -122.435352122012 (37.7327894760326, -122.435352122012) 9 7 5 63 40
3595 219121 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100 Brompton Ave 13 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6002025.50342 2095049.38545 37.7327212453836 -122.435367602937 (37.7327212453836, -122.435367602937) 9 7 5 63 40
36467 219120 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100 Brompton Ave 12 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6002027.68527 2095060.20973 37.7327510902846 -122.435360833759 (37.7327510902846, -122.435360833759) 9 7 5 63 40
46850 219122 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100 Brompton Ave 14 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6002020.04993 2095030.436 37.7326689048259 -122.435385101949 (37.7326689048259, -122.435385101949) 9 7 5 63 40
91484 219118 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100 Brompton Ave 10 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6002034.57495 2095088.74444 37.7328298313259 -122.435339054851 (37.7328298313259, -122.435339054851) 9 7 5 63 40
135097 219117 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100 Brompton Ave 9 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6002040.90491 2095107.61189 37.732881996497 -122.435318519728 (37.732881996497, -122.435318519728) 9 7 5 63 40
157851 219123 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100 Brompton Ave 15 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6002016.15512 2095016.17796 37.7326295343225 -122.435397547681 (37.7326295343225, -122.435397547681) 9 7 5 63 40
36124 49342 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 100 Clifford Ter 5 Sidewalk: Curb side : Cutout Tree Private 2   03/03/2003 12:00:00 AM     Permit Number 46332 5999646.98705896 2106515.41862964 37.7640688343052 -122.444414431135 (37.7640688343052, -122.444414431135) 15 5 5 29492 9
102236 49340 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 100 Clifford Ter 3 Sidewalk: Curb side : Cutout Tree Private 2   03/03/2003 12:00:00 AM     Permit Number 46332 5999646.98705896 2106515.41862964 37.7640688343052 -122.444414431135 (37.7640688343052, -122.444414431135) 15 5 5 29492 9
164557 33469 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 100 Coleridge St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/20/1996 12:00:00 AM     Permit Number 37568 6006683.58482984 2099106.89574168 37.7441257054073 -122.419551194294 (37.7441257054073, -122.419551194294) 2 7 7 28859 2
110851 32465 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100 Corbett Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/07/2013 12:00:00 AM 1 3x3 Permit Number 769711 6000816.86333 2105689.19673 37.7618669122537 -122.440308925238 (37.7618669122537, -122.440308925238) 15 5 5 28862 3
11309 44191 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 100 Harrison St 12 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2000 12:00:00 AM     Permit Number 43651 6015694.21185643 2115218.20458409 37.7888672826794 -122.389519124295 (37.7888672826794, -122.389519124295) 6 2 9 28855 6
37647 44195 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 100 Harrison St 6 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2000 12:00:00 AM     Permit Number 43651 6015694.21185643 2115218.20458409 37.7888672826794 -122.389519124295 (37.7888672826794, -122.389519124295) 6 2 9 28855 6
42164 44189 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 100 Harrison St 7 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2000 12:00:00 AM     Permit Number 43651 6015694.21185643 2115218.20458409 37.7888672826794 -122.389519124295 (37.7888672826794, -122.389519124295) 6 2 9 28855 6
51369 44194 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 100 Harrison St 8 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2000 12:00:00 AM     Permit Number 43651 6015694.21185643 2115218.20458409 37.7888672826794 -122.389519124295 (37.7888672826794, -122.389519124295) 6 2 9 28855 6
72872 44190 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 100 Harrison St 13 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2000 12:00:00 AM     Permit Number 43651 6015694.21185643 2115218.20458409 37.7888672826794 -122.389519124295 (37.7888672826794, -122.389519124295) 6 2 9 28855 6
95647 44199 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100 Harrison St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/20/2018 12:00:00 AM 3   Permit Number 43651 6015629.81658 2115174.24288 37.7887430032356 -122.389738853189 (37.7887430032356, -122.389738853189) 6 2 9 28855 6
103647 44198 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100 Harrison St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2000 12:00:00 AM 4   Permit Number 43651 6015613.21564 2115159.68111 37.7887020993715 -122.389795273027 (37.7887020993715, -122.389795273027) 6 2 9 28855 6
111099 44201 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 100 Harrison St 9 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2000 12:00:00 AM     Permit Number 43651 6015694.21185643 2115218.20458409 37.7888672826794 -122.389519124295 (37.7888672826794, -122.389519124295) 6 2 9 28855 6
121191 44192 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 100 Harrison St 11 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2000 12:00:00 AM     Permit Number 43651 6015694.21185643 2115218.20458409 37.7888672826794 -122.389519124295 (37.7888672826794, -122.389519124295) 6 2 9 28855 6
122315 44200 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/20/2018 12:00:00 AM 3   Permit Number 43651 6015644.9623 2115187.5878 37.7887804851876 -122.389687383164 (37.7887804851876, -122.389687383164) 6 2 9 28855 6
132960 44196 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100 Harrison St 5 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2000 12:00:00 AM 4   Permit Number 43651 6015590.27485 2115136.01269 37.7886358391193 -122.389872991572 (37.7886358391193, -122.389872991572) 6 2 9 28855 6
142441 44193 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 100 Harrison St 10 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2000 12:00:00 AM     Permit Number 43651 6015694.21185643 2115218.20458409 37.7888672826794 -122.389519124295 (37.7888672826794, -122.389519124295) 6 2 9 28855 6
184190 44197 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100 Harrison St 4 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2000 12:00:00 AM 4   Permit Number 43651 6015604.12637 2115150.5006 37.7886763877505 -122.389826079337 (37.7886763877505, -122.389826079337) 6 2 9 28855 6
10049 261052 Private 9 Ginkgo biloba :: Maidenhair Tree 22 100 Hooper St 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013012.2905 2108046.92839 37.769027533769 -122.398294909078 (37.769027533769, -122.398294909078) 14 3 8 28856 20
102898 128952 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100 McAllister St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6008545.08155 2112474.66764 37.7809352088189 -122.414060041244 (37.7809352088189, -122.414060041244) 7 10 9 28852 36
119524 128951 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100 McAllister St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6008567.44995 2112479.14828 37.7809487678993 -122.413982974738 (37.7809487678993, -122.413982974738) 7 10 9 28852 36
121914 128953 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100 McAllister St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6008513.20798 2112471.49147 37.7809246975586 -122.414170083205 (37.7809246975586, -122.414170083205) 7 10 9 28852 36
142732 128954 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100 McAllister St 4 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6008488.64785 2112470.36476 37.7809202243324 -122.414254969316 (37.7809202243324, -122.414254969316) 7 10 9 28852 36
9176 176544 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100 Panama St 7 : Tree Private 2     1 Width 3ft   5992259.97775 2086836.1982 37.7096104062721 -122.468531792305 (37.7096104062721, -122.468531792305) 9 8 4 64 24
84647 176542 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100 Panama St 5 : Tree Private 2     1 Width 3ft   5992312.69836 2086838.42699 37.7096195712459 -122.468349744347 (37.7096195712459, -122.468349744347) 9 8 4 64 24
93251 176543 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100 Panama St 6 : Tree Private 2     1 Width 3ft   5992283.95996 2086838.07777 37.7096169524177 -122.468449043003 (37.7096169524177, -122.468449043003) 9 8 4 64 24
116754 107580 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100 Panama St 2 Sidewalk: Curb side : Yard Tree Private 2   11/12/2014 12:00:00 AM 3   Permit Number 774090 5992406.39157 2086830.73395 37.7096038592127 -122.468025367885 (37.7096038592127, -122.468025367885) 9 8 4 64 24
153512 107579 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100 Panama St 1 Sidewalk: Curb side : Yard Tree Private 2   11/12/2014 12:00:00 AM 3   Permit Number 774090 5992416.91174 2086830.03613 37.7096025506984 -122.467988957943 (37.7096025506984, -122.467988957943) 9 8 4 64 24
175627 107582 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100 Panama St 4 Sidewalk: Curb side : Yard Tree Private 2   11/12/2014 12:00:00 AM 3   Permit Number 774090 5992337.55751 2086836.47342 37.7096156430274 -122.46826368552 (37.7096156430274, -122.46826368552) 9 8 4 64 24
182443 107581 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100 Panama St 3 Sidewalk: Curb side : Yard Tree Private 2   11/12/2014 12:00:00 AM 3   Permit Number 774090 5992393.94682 2086830.99569 37.7096038591978 -122.468068397753 (37.7096038591978, -122.468068397753) 9 8 4 64 24
20365 176527 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100 Prague St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6004589.78271 2090506.01263 37.7203914438823 -122.42617890585 (37.7203914438823, -122.42617890585) 9 7 6 28861 5
36293 176526 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100 Prague St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   6004597.29185 2090518.89763 37.720427247709 -122.426153866008 (37.720427247709, -122.426153866008) 9 7 6 28861 5
176812 176528 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100 Prague St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   6004578.32338 2090490.71188 37.7203487836515 -122.426217428296 (37.7203487836515, -122.426217428296) 9 7 6 28861 5
14048 19740 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100 STAIRWAY15 -50 Sidewalk: Curb side : Cutout Tree DPW 1     3 1OST                      
16572 19741 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100 STAIRWAY15 -14 Sidewalk: Curb side : Cutout Tree DPW 1     3 1OST                      
11197 19797 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100 STAIRWAY21 2 Sidewalk: Curb side : Cutout Tree DPW 1     3 40ST                      
12826 19801 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100 STAIRWAY21 6 Sidewalk: Curb side : Cutout Tree DPW 1     3 40ST                      
8250 19840 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100 STAIRWAY25 24 Sidewalk: Curb side : Cutout Tree DPW 1     6 60X                      
2060 150281 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100 Wisconsin St 5 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6012538.7082 2106843.10365 37.7656957093017 -122.399848467747 (37.7656957093017, -122.399848467747) 14 3 8 28856 20
9099 150279 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100 Wisconsin St 3 Sidewalk: Curb side : Cutout Tree Private 2   09/17/2020 12:00:00 AM 3 Width 4ft   6012534.4253 2106906.60715 37.7658698369607 -122.399867741107 (37.7658698369607, -122.399867741107) 14 3 8 28856 20
11683 150282 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100 Wisconsin St 6 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6012538.56716 2106816.55078 37.7656227931865 -122.399847090876 (37.7656227931865, -122.399847090876) 14 3 8 28856 20
12981 150277 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100 Wisconsin St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/17/2020 12:00:00 AM 3 Width 4ft   6012531.20718 2106963.7474 37.7660265519105 -122.399882884798 (37.7660265519105, -122.399882884798) 14 3 8 28856 20
17924 150280 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100 Wisconsin St 4 Sidewalk: Curb side : Cutout Tree Private 2   09/17/2020 12:00:00 AM 3 Width 4ft   6012537.6236 2106868.09585 37.7657642718362 -122.399853974275 (37.7657642718362, -122.399853974275) 14 3 8 28856 20
19512 150278 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100 Wisconsin St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/17/2020 12:00:00 AM 3 Width 4ft   6012533.22434 2106945.4742 37.7659764902431 -122.399874624526 (37.7659764902431, -122.399874624526) 14 3 8 28856 20
83438 192471 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1000 22nd St 7 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   6014799.35155 2103920.33928 37.7577962011557 -122.391824942193 (37.7577962011557, -122.391824942193) 10 3 8 28856 29
169745 192470 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1000 22nd St 5 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6014832.70201 2103922.31866 37.7578034874588 -122.39170973991 (37.7578034874588, -122.39170973991) 10 3 8 28856 29
178144 192469 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1000 22nd St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6014870.03943 2103923.77532 37.7578095596756 -122.39158071238 (37.7578095596756, -122.39158071238) 10 3 8 28856 29
187770 192468 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1000 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6014906.49786 2103925.69197 37.7578168459985 -122.391454756925 (37.7578168459985, -122.391454756925) 10 3 8 28856 29
118472 34987 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1000 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2     65   Permit Number 41601 6011225.35237 2111221.47074 37.7776443970062 -122.404699365001 (37.7776443970062, -122.404699365001) 14 2 9 28853 34
49590 7378 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1000X Folsom St 2 Sidewalk: Curb side : Cutout Tree Rec/Park 5     45 3X3   6010884.8623 2111505.4176 37.7784050126686 -122.40589724881 (37.7784050126686, -122.40589724881) 14 2 9 28853 34

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);