3,247 rows where qSpecies_id = 22 sorted by qCaretaker_id

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)
153497 6454 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1199 Evans Ave 8 Sidewalk: Curb side : Cutout Tree DPW 1   05/03/2017 02:46:00 PM 3 3X3   6017932.4783 2096773.48366 37.7383458248849 -122.380492444782 (37.7383458248849, -122.380492444782) 10 3 8 58 1
154112 29924 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 288X Sagamore St 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 3x3   5994099.1729 2087478.19658 37.7114792514346 -122.462221790909 (37.7114792514346, -122.462221790909) 9 8 6 28861 24
154982 14487 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 281 Masonic Ave 8 Sidewalk: Curb side : Cutout Tree DPW 1     80 3X3   5998916.88383 2112015.94131 37.7791301845625 -122.447335559177 (37.7791301845625, -122.447335559177) 15 6 2 54 16
155282 24361 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 255 Duboce Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     0     6005147.8754497 2108419.4703747 37.7696092314038 -122.425523971887 (37.7696092314038, -122.425523971887) 8 4 5 28853 19
156151 17814 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1901X Pine St 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 3X3   6004836.9385372 2115383.3620002 37.7887127908909 -122.427095577683 (37.7887127908909, -122.427095577683) 13 9 11 28858 27
156718 5736 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1735 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1     50 3x3   6005366.76903 2098271.84228 37.74175857761 -122.424045085308 (37.74175857761, -122.424045085308) 2 7 5 28859 7
156970 10598 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 385X 07th St 2 Sidewalk: Curb side : Cutout Tree DPW 1     9 3X3   6010728.50062 2110559.72736 37.7757996213793 -122.406371513674 (37.7757996213793, -122.406371513674) 14 2 9 28853 34
157759 5296 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1600 Divisadero St 2 Sidewalk: Curb side : Cutout Tree DPW 1     4 3X3   6001166.5123 2114078.1108 37.7849206674566 -122.439701075731 (37.7849206674566, -122.439701075731) 15 6 11 29490 13
158324 129054 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 444 Washington St 2 Sidewalk: Curb side : Cutout Tree DPW 1   05/22/2012 12:00:00 AM 2 Width 4ft   6012321.89911 2117825.32237 37.7958382521842 -122.401370223173 (37.7958382521842, -122.401370223173) 3 1 10 28860 4
158482 6655 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1550 Evans Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1   02/15/2001 12:00:00 AM 6 3X3   6016144.11034 2098231.69923 37.7422509411428 -122.38677746482 (37.7422509411428, -122.38677746482) 10 3 8 58 1
158621 14415 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 10X Masonic Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1   11/30/2014 11:00:00 PM 3 3X3   5998974.44495 2113166.80204 37.7822934388942 -122.447219282802 (37.7822934388942, -122.447219282802) 15 5 1 54 16
158645 10601 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2749 Harrison St 2 Sidewalk: Curb side : Cutout Tree DPW 1   06/01/1992 12:00:00 AM 6 3x3   6008971.05874 2102435.54315 37.7533940125469 -122.411876754419 (37.7533940125469, -122.411876754419) 2 4 7 28859 19
158891 251370 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 390 06th St 2 Sidewalk: Curb side : Cutout Tree DPW 1 Private     3x3   6011351 2111108 37.7773398544385 -122.404256716486 (37.7773398544385, -122.404256716486) 14 2 9 28853 34
159633 6452 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1195 Evans Ave 6 Sidewalk: Curb side : Cutout Tree DPW 1   09/22/2012 12:00:00 AM 3 3X3   6017800.8785909 2096864.2340114 37.738587744527 -122.380953764206 (37.738587744527, -122.380953764206) 10 3 8 58 1
161969 6659 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1550 Evans Ave 7 Sidewalk: Curb side : Cutout Tree DPW 1   02/03/2000 12:00:00 AM 3 3X3   6016081.5878 2098278.96345 37.7423772572113 -122.386996946162 (37.7423772572113, -122.386996946162) 10 3 8 58 1
162411 27243 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1877 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 3X3   6013583.54144 2096526.75062 37.7374274075466 -122.395511766876 (37.7374274075466, -122.395511766876) 10 3 8 58 1
162522 3756 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1056 Carolina St 1 Median : Cutout Tree DPW 1     3 18   6012452.0863519 2103047.5184298 37.7552690413169 -122.399881522302 (37.7552690413169, -122.399881522302) 10 3 8 28856 29
162905 6430 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1100X Evans Ave 12 Sidewalk: Curb side : Cutout Tree DPW 1   05/03/2017 12:48:00 PM 3 3x3   6018115.58754 2096722.72512 37.7382165545353 -122.379855810196 (37.7382165545353, -122.379855810196) 10 3 8 58 1
164158 14568 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1035X Masonic Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   04/13/2005 12:00:00 AM 3 3X3   5999322.64051 2109314.43165 37.7717357073698 -122.445737553038 (37.7717357073698, -122.445737553038) 15 5 11 29492 9
165520 26179 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 456 Castro St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 2X2 Permit Number 772904 6002297.11401 2105570.20774 37.761624365983 -122.435180819163 (37.761624365983, -122.435180819163) 15 4 5 28862 3
166451 12709 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1448 Lake St 2 Sidewalk: Curb side : Cutout Tree DPW 1   01/24/1990 12:00:00 AM 20 3X3   5990924.23041 2114788.11678 37.7862818507248 -122.47518756279 (37.7862818507248, -122.47518756279) 11 6 1 54 33
167169 7376 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2907X 24th St 2 Sidewalk: Curb side : Cutout Tree DPW 1   02/21/2013 12:00:00 AM 3 3x3   6009449.8972236 2102159.1699056 37.7526620055733 -122.410201312287 (37.7526620055733, -122.410201312287) 2 4 7 28859 19
168198 6482 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1200X Evans Ave 23 Sidewalk: Curb side : Cutout Tree DPW 1   09/11/2006 12:00:00 AM 3 3X3   6017388.40501 2097301.08401 37.7397644719514 -122.382410300498 (37.7397644719514, -122.382410300498) 10 3 8 58 1
168466 6634 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1495 Evans Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   01/02/2016 08:44:00 AM 3 3X3   6016398.96858 2097918.11995 37.7414040234725 -122.385874382714 (37.7414040234725, -122.385874382714) 10 3 8 58 1
168799 7410 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1078 Folsom St 1 Sidewalk: Curb side : Cutout Tree DPW 1     45 3X3   6010457.46698 2111087.85062 37.7772345593675 -122.407346331585 (37.7772345593675, -122.407346331585) 14 2 9 28853 34
169982 6478 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1200X Evans Ave 20 Sidewalk: Curb side : Cutout Tree DPW 1   03/28/2013 12:00:00 AM 3 3x3   6017452.81601 2097250.98701 37.739630473342 -122.382184108102 (37.739630473342, -122.382184108102) 10 3 8 58 1
170372 1717 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 555 Battery St 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6012534.63593 2117926.51881 37.7961279804624 -122.400641221934 (37.7961279804624, -122.400641221934) 3 1 10 28860 4
170745 14466 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 201 Masonic Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     60 2X3   5998899.6369 2112323.9149 37.7799748148245 -122.447417396328 (37.7799748148245, -122.447417396328) 15 5 2 54 16
170833 16535 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1420X Evans Ave 9 Sidewalk: Curb side : Cutout Tree DPW 1   09/11/2006 12:00:00 AM 3 3X3   6016649.3386754 2097853.1412174 37.7412394571821 -122.385004155587 (37.7412394571821, -122.385004155587) 10 3 8 58 1
171183 26177 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 463 Castro St 1 Sidewalk: Curb side : Cutout Tree DPW 1     2 3x3   6002360.13498 2105536.28626 37.7615348043119 -122.434960429479 (37.7615348043119, -122.434960429479) 15 4 5 28862 3
172410 5676 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1442 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1   09/11/2003 12:00:00 AM 6 3X3   6005185.30629 2099958.9563 37.7463807610586 -122.424792519978 (37.7463807610586, -122.424792519978) 2 7 5 63 22
172461 4038 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2323 Cesar Chavez St 3 Sidewalk: Curb side : Cutout Tree DPW 1     6 2X3   6011915.6161 2100899.61614 37.7493414470685 -122.401585851825 (37.7493414470685, -122.401585851825) 10 3 8 58 1
175640 24374 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 214 Duboce Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/15/2001 12:00:00 AM 3 3X3   6005312.22082 2108489.88376 37.7698118541611 -122.424960516937 (37.7698118541611, -122.424960516937) 8 4 5 28853 19
176098 14416 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 10X Masonic Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1   10/12/2000 12:00:00 AM 8 3X3   5998974.44495 2113166.80204 37.7822934388942 -122.447219282802 (37.7822934388942, -122.447219282802) 15 5 1 54 16
178729 26816 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1701 Divisadero St 5 Sidewalk: Curb side : Cutout Tree DPW 1     3 3X3   6001075.1559 2114260.1397 37.7854152717832 -122.440030195581 (37.7854152717832, -122.440030195581) 15 6 1 29490 27
181536 22838 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 112 Turquoise Way 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/01/2000 12:00:00 AM 3 2X2   5999650.54183 2098943.83579 37.7432793203754 -122.443858110463 (37.7432793203754, -122.443858110463) 2 7 5 63 7
183115 26812 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1701 Divisadero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 3X3   6001060.3249 2114356.0469 37.7856777639804 -122.440088385928 (37.7856777639804, -122.440088385928) 15 6 1 29490 27
184314 6433 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1100X Evans Ave 15 Sidewalk: Curb side : Cutout Tree DPW 1   07/10/2014 12:00:00 AM 3 3x3   6018339.9760743 2096552.8140758 37.7377623877793 -122.379068180173 (37.7377623877793, -122.379068180173) 10 3 8 58 1
184473 6506 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1200X Evans Ave 48 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2004 12:00:00 AM 3 3x3   6016870.73401 2097688.74101 37.7408002912118 -122.384227195218 (37.7408002912118, -122.384227195218) 10 3 8 58 1
185008 4039 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2323 Cesar Chavez St 4 Sidewalk: Curb side : Cutout Tree DPW 1   03/07/2014 12:00:00 AM 5 2X3   6011942.20762 2100900.73993 37.7493460165275 -122.401493976188 (37.7493460165275, -122.401493976188) 10 3 8 58 1
185425 24352 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 183 Duboce Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/24/1995 12:00:00 AM 3 3X3   6005552.77434 2108427.90971 37.7696552731946 -122.424124039488 (37.7696552731946, -122.424124039488) 8 4 5 28853 19
186514 4043 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2323 Cesar Chavez St 8 Sidewalk: Curb side : Cutout Tree DPW 1   02/10/2005 12:00:00 AM 3 2X3   6012152.10777 2100910.47094 37.7493844454379 -122.400768815931 (37.7493844454379, -122.400768815931) 10 3 8 58 1
187796 27495 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 401X Masonic Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1   03/28/2005 12:00:00 AM 6 8   5999043.2471 2111289.3703 37.7771424276553 -122.446846123038 (37.7771424276553, -122.446846123038) 15 5 2 29492 16
188792 14574 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1125 Masonic Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   5999367.196 2108956.8623 37.7707564564018 -122.445557716473 (37.7707564564018, -122.445557716473) 15 5 11 29492 9
189175 6662 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1550 Evans Ave 10 Sidewalk: Curb side : Cutout Tree DPW 1   12/29/1992 12:00:00 AM 6 3X3   6016012.05161 2098330.17252 37.7425140162093 -122.387240954701 (37.7425140162093, -122.387240954701) 10 3 8 58 1
189556 24635 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 443 Divisadero St 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/27/1990 12:00:00 AM 6 3X3   6001671.03792 2110007.38594 37.7737721896694 -122.437663947137 (37.7737721896694, -122.437663947137) 15 5 11 29492 10
190572 17819 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1907 Pine St 2 Sidewalk: Curb side : Cutout Tree DPW 1   02/18/1992 12:00:00 AM 3 3X3   6004809.4741267 2115379.5459892 37.7887007599806 -122.427190328672 (37.7887007599806, -122.427190328672) 13 9 11 28858 27
191344 5220 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 998X Divisadero St 1 Sidewalk: Curb side : Cutout Tree DPW 1   10/26/1995 12:00:00 AM 3 3X4   6001495.4192 2111745.9646 37.7785359024219 -122.438396022881 (37.7785359024219, -122.438396022881) 15 5 11 29490 41
191973 6447 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1199 Evans Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/20/2015 07:28:00 AM 3 3X3   6017815.25315 2096866.67001 37.7385952266854 -122.380904232644 (37.7385952266854, -122.380904232644) 10 3 8 58 1
192488 1403 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 62 Ardath Ct 3 Sidewalk: Curb side : Cutout Tree DPW 1   03/11/2006 12:00:00 AM 3 3X4   6017428.9119183 2095344.9938609 37.7343956759938 -122.382134203041 (37.7343956759938, -122.382134203041) 10 3 8 58 1
192669 5735 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1731 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/28/2008 12:00:00 AM 50 3x3   6005365.9005 2098299.94514 37.7418356926592 -122.424050086446 (37.7418356926592, -122.424050086446) 2 7 5 28859 7
38 167409 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 4 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/20/2020 12:00:00 AM 3 3X3 Permit Number 781788 6001979.94285 2107686.90453 37.7674182815445 -122.436429284105 (37.7674182815445, -122.436429284105) 15 5 5 29492 3
56 124 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 1032 14th St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/20/2020 12:00:00 AM 3 3X3 Permit Number 781788 6002037.12702 2107659.05322 37.7673450578674 -122.436229498819 (37.7673450578674, -122.436229498819) 15 5 5 29492 3
62 264980 Significant Tree 6 Ginkgo biloba :: Maidenhair Tree 22 222 Winfield St 1 Front Yard : Yard Tree Private 2       3x3   6006740 2098205 37.7416524795013 -122.419292156581 (37.7416524795013, -122.419292156581) 2 7 7 28859 2
288 125298 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 822 Pacific Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6010056.95509 2118170.07703 37.7966582351325 -122.409231726859 (37.7966582351325, -122.409231726859) 3 1 10 308 4
321 219060 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 221 Congo St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6000072.85251 2094491.10418 37.731077247812 -122.442078323383 (37.731077247812, -122.442078323383) 9 7 4 63 40
480 225991 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 99 Laussat St 2 : Tree Private 2     1 Width 3ft   6004313.0789 2109253.93974 37.7718532783246 -122.428470991768 (37.7718532783246, -122.428470991768) 7 9 11 28852 10
692 61241 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 3970 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/14/1984 12:00:00 AM     Permit Number 21113 6003879.55901956 2104241.51200503 37.7580658175007 -122.429613020503 (37.7580658175007, -122.429613020503) 2 4 5 28862 3
757 226221 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 901 Alabama St 5 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6009154.30275 2103871.8716 37.7573481256189 -122.411344516752 (37.7573481256189, -122.411344516752) 2 4 7 28859 19
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                    
881 254388 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 990 Pacific Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   02/08/2018 12:00:00 AM 3 3x3   6009377.71563 2118076.93343 37.7963644085284 -122.411575473026 (37.7963644085284, -122.411575473026) 3 1 10 308 4
1069 49087 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 692 De Haro St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/10/2003 12:00:00 AM     Permit Number 46237 6012085.19773634 2105185.1896517 37.7611181541392 -122.401300553818 (37.7611181541392, -122.401300553818) 10 3 8 28856 29
1198 225665 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 300x Highland Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6006874 2096520 37.7370333899893 -122.418709361786 (37.7370333899893, -122.418709361786) 2 7 7 28859 2
1246 160377 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 824 Edinburgh St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2019 12:00:00 AM 3 Width 0ft   6001767.32645 2089068.63157 37.7162847814869 -122.435832414836 (37.7162847814869, -122.435832414836) 9 7 6 28861 5
1258 190419 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1300 Evans Ave 15 : Tree Private 2   05/01/2017 12:00:00 AM 3 Width 3ft   6017844.32202 2096957.74462 37.7388469037738 -122.380810054756 (37.7388469037738, -122.380810054756) 10 3 8 58 1
1277 220672 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 25 Cumberland St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6005444.88154 2104573.79472 37.759066695887 -122.424223091727 (37.759066695887, -122.424223091727) 2 4 5 28859 19
1506 70618 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1557 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   2     6007346.38924 2116443.24691 37.7917645589423 -122.418488407316 (37.7917645589423, -122.418488407316) 5 1 10 28858 21
1566 124023 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 301 Funston Ave 3 Sidewalk: Curb side : Yard Tree Private 2     16 Width 3ft   5991830.31416 2113050.03169 37.781562022994 -122.471926053077 (37.781562022994, -122.471926053077) 11 6 2 54 11
1594 264718 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1301 16th St 6 Sidewalk: Curb side : Cutout Tree Private 2   09/17/2020 12:00:00 AM 3     6012426 2106899 37.7658429041656 -122.400242229593 (37.7658429041656, -122.400242229593) 14 3 8 28856 20
1608 32205 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1697 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/22/1995 12:00:00 AM 8   Permit Number 35528 6009341.58261 2099615.8477 37.7456725350783 -122.410396317437 (37.7456725350783, -122.410396317437) 2 7 7 28859 2
1649 92526 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 275 10th St 4 Sidewalk: Curb side : Cutout Tree Private 2   08/07/2009 12:00:00 AM   3x3 Permit Number 52874 6008743 2109634 37.7731465224788 -122.413174412357 (37.7731465224788, -122.413174412357) 8 2 9 28853 34
1669 35520 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 90 Alvarado St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/13/1999 12:00:00 AM     Permit Number 41442 6005793.71652674 2102887.49607432 37.7544562030797 -122.422896805421 (37.7544562030797, -122.422896805421) 2 4 5 28859 19
1686 225676 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 700X Jarboe Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6008816.88964 2096900.69924 37.7381879057352 -122.412018790637 (37.7381879057352, -122.412018790637) 10 7 7 28859 2
1811 258532 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 1565 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/28/2019 12:00:00 AM 3 3x3 Permit Number 777683 6006695.00356 2117330.6469 37.7941644464503 -122.420805231935 (37.7941644464503, -122.420805231935) 13 9 10 28858 32
1918 262485 Undocumented 4 Ginkgo biloba :: Maidenhair Tree 22 500X Delta St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3   6009406 2087980 37.7137265813857 -122.409352565386 (37.7137265813857, -122.409352565386) 9 7 8 309 39
1952 129457 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 822 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6010137.05679 2118184.23209 37.7967015887668 -122.408955554965 (37.7967015887668, -122.408955554965) 3 1 10 308 4
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
2109 71599 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 130 Wilson St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     5994726.40181 2086320.41636 37.7083363538073 -122.459970121431 (37.7083363538073, -122.459970121431) 9 8 6 28861 25
2312 71328 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 228 Prague St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     6004151.95998 2089814.42795 37.7184677472758 -122.427643069565 (37.7184677472758, -122.427643069565) 9 7 6 28861 5
2367 226104 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 269 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6005509.798 2107472.48259 37.7670294722636 -122.424204733868 (37.7670294722636, -122.424204733868) 8 4 5 28853 19
2409 225663 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 79 Santa Marina St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6006114.92527 2097621.73369 37.7400157373359 -122.421412046638 (37.7400157373359, -122.421412046638) 2 7 7 28859 2
2416 192496 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 301 Kansas St 18 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6011473.84765 2106919.34293 37.765845622699 -122.403536974176 (37.765845622699, -122.403536974176) 8 3 8 28853 20
2577 31869 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 166 Caselli Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/1995 12:00:00 AM 1   Permit Number 35311 6000215.42905 2104900.21847 37.759666310759 -122.442332399837 (37.759666310759, -122.442332399837) 2 4 5 28862 3
2637 262319 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1616 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011556 2107033 37.7661622878471 -122.403260820888 (37.7661622878471, -122.403260820888) 8 2 8 28853 20
2645 137669 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1927 GOLDEN GATE AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6000327.0363 2111629.9151 37.7781507333481 -122.442429558556 (37.7781507333481, -122.442429558556) 15 5 11 29490 16
2803 39877 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 301 Bryant St 4 Sidewalk: Curb side : Cutout Tree Private 2   01/21/1999 12:00:00 AM     Permit Number 41173 6015620.67363669 2114221.43610992 37.786126305998 -122.389703911477 (37.786126305998, -122.389703911477) 6 2 9 28855 6
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
2843 243848 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2976 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/01/2017 12:00:00 AM 3 Width 3ft   6009037.26284 2102182.62574 37.7527032720445 -122.411629937289 (37.7527032720445, -122.411629937289) 2 4 7 28859 19
3016 190529 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 21 Clarence Pl 7 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6014722.79424 2111890.37318 37.7796759079438 -122.392647234607 (37.7796759079438, -122.392647234607) 6 2 9 28856 6
3076 228280 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 2036X 15th St 3 Sidewalk: Curb side : Yard Tree Private 2     3 Width 3ft   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
3134 190600 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 355 Campus Way 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 5ft   6015217.08572 2107526.40267 37.7677208521577 -122.390632216307 (37.7677208521577, -122.390632216307) 14 3 9 310 20
3143 46360 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 514 23rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/27/2002 12:00:00 AM 2   Permit Number 44598 5988790.17087 2111781.31969 37.7779021128043 -122.482350384801 (37.7779021128043, -122.482350384801) 11 6 2 55 26
3155 171861 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 600 Dartmouth St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6009150.18336 2091330.30171 37.722911477365 -122.410473193303 (37.722911477365, -122.410473193303) 9 3 7 309 28
3160 228282 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 2036X 15th St 5 Sidewalk: Curb side : Yard Tree Private 2     3 Width 3ft   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
3306 228286 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 2036X 15th St 9 Sidewalk: Curb side : Yard Tree Private 2     3 Width 3ft   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
3333 66070 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 517 Mississippi St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/06/1990 12:00:00 AM 7   Permit Number 29111 6014120.17951 2104674.3104 37.7598287157536 -122.39422660508 (37.7598287157536, -122.39422660508) 10 3 8 28856 29
3402 81722 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 998 Indiana St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     6014944.17963 2104119.9743 37.758352394954 -122.391338017739 (37.758352394954, -122.391338017739) 10 3 8 28856 29
3435 226185 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 160 Banks St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6008635.20088 2097780.05534 37.7405922297483 -122.412709130925 (37.7405922297483, -122.412709130925) 10 7 7 28859 2
3516 92206 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 443 Madrid St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/22/2015 12:00:00 AM 3 3x3 Permit Number 775730 6002885.09645 2091274.76844 37.7224057768794 -122.432126318576 (37.7224057768794, -122.432126318576) 9 7 6 28861 5
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

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