3,247 rows where qSpecies_id = 22 sorted by qLegalStatus_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)
8776 264714 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1301 16th St 2 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
8835 225756 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 130 Jersey St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6004264.93448 2101628.47099 37.7509128342656 -122.428094014849 (37.7509128342656, -122.428094014849) 2 4 5 28862 22
8872 80804 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 991 Tennessee St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   2     6015534.52104 2104634.07686 37.759796756532 -122.389332239092 (37.759796756532, -122.389332239092) 10 3 8 28856 29
8933 6551 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1275 Evans Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   09/11/2006 12:00:00 AM 3 3x3   6017377.10796 2097187.95737 37.7394532248805 -122.382441492395 (37.7394532248805, -122.382441492395) 10 3 8 58 1
8934 226205 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 597 Jarboe Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6007988.11272 2097011.03319 37.7384443240492 -122.414892104787 (37.7384443240492, -122.414892104787) 2 7 7 28859 2
8956 5249 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1135 Divisadero St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/27/1990 12:00:00 AM 6 3X3   6001356.9176 2112269.0905 37.7799643946727 -122.438912650424 (37.7799643946727, -122.438912650424) 15 5 11 29490 41
9046 225629 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100X Powhattan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6007636.88846 2098165.70559 37.7415950574792 -122.416188226626 (37.7415950574792, -122.416188226626) 2 7 7 28859 2
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
9164 264712 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1315 Carolina St 4 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
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
9388 84237 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 382-384 25th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   2     5988116.70798 2113371.1409 37.7822281155783 -122.484796757861 (37.7822281155783, -122.484796757861) 11 6 2 55 26
9427 225683 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 90X Powhattan Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007564.88173 2098170.09854 37.74160307044 -122.416437513288 (37.74160307044, -122.416437513288) 2 7 7 28859 2
9489 219078 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 23 Bright St 1 : Tree Private 2     1 Width 3ft   5993714.36027 2087390.34861 37.7112158768855 -122.463545422096 (37.7112158768855, -122.463545422096) 9 8 4 64 24
9565 225681 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 90X Powhattan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007523.22988 2098173.25973 37.7416094079456 -122.416581755567 (37.7416094079456, -122.416581755567) 2 7 7 28859 2
9701 50525 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 278 Missouri St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/09/2020 12:00:00 AM 3   Permit Number 785437 6013437.34066 2105807.45901 37.7629021146671 -122.396667663687 (37.7629021146671, -122.396667663687) 14 3 8 28856 29
9774 264715 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1301 16th St 3 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
9806 81718 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 998 Indiana St 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3     6014951.7156 2104031.36678 37.7581095159642 -122.39130576085 (37.7581095159642, -122.39130576085) 10 3 8 28856 29
9938 200875 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1699 16th St 4 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6011598.7362 2106957.8779 37.7659584061817 -122.403107719273 (37.7659584061817, -122.403107719273) 8 3 8 28853 20
9979 6601 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1400 Evans Ave 8 Sidewalk: Curb side : Cutout Tree DPW 1   02/03/2000 12:00:00 AM 18 3X3   6016563.26404 2097911.91125 37.7413960662634 -122.385305868181 (37.7413960662634, -122.385305868181) 10 3 8 58 1
10270 58254 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 588 Pennsylvania Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/15/2014 12:00:00 AM 12   Permit Number 772841 6014358.43843 2104381.36252 37.7590375848275 -122.393382076919 (37.7590375848275, -122.393382076919) 10 3 8 28856 29
10304 71422 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 658 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     6009722.2927 2120212.6608 37.8022479122752 -122.410534048105 (37.8022479122752, -122.410534048105) 3 1 10 308 23
10315 264711 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1315 Carolina St 3 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
10467 47093 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2527 McAllister St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/03/2002 12:00:00 AM 3   Permit Number 45075 5996913.4055 2110751.4542 37.7755435471962 -122.454175015215 (37.7755435471962, -122.454175015215) 15 6 2 54 16
10470 128936 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2618 Buchanan St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6003606.06388 2117505.00365 37.7944685972958 -122.431505746802 (37.7944685972958, -122.431505746802) 13 9 1 29490 27
10664 260923 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 47 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/28/2019 12:00:00 AM 3     5990807.95481 2114868.4417 37.7864956605801 -122.475595709543 (37.7864956605801, -122.475595709543) 11 6 1 54 33
10689 120012 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 379 29th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   5986824.09694 2113410.67303 37.7822612914883 -122.489271461219 (37.7822612914883, -122.489271461219) 11 6 2 55 26
10696 225642 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 601 Eugenia Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6007246.85833 2097787.65271 37.7405350697311 -122.417510034876 (37.7405350697311, -122.417510034876) 2 7 7 28859 2
10889 228271 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 16 Henry St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6003334.18679 2107439.76679 37.7668165595729 -122.43172749535 (37.7668165595729, -122.43172749535) 15 5 5 28862 3
10917 73960 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 138 Wilson St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     5994666.9696 2086372.6899 37.7084764663958 -122.460179309136 (37.7084764663958, -122.460179309136) 9 8 6 28861 25
11023 6550 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1225X Evans Ave 7 Sidewalk: Curb side : Cutout Tree DPW 1   03/28/2013 12:00:00 AM 3 4x4   6017625.4418446 2096995.6120179 37.7389387975003 -122.381569480835 (37.7389387975003, -122.381569480835) 10 3 8 58 1
11133 261245 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 40 Porter St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006991 2095570 37.7344314860328 -122.418237504879 (37.7344314860328, -122.418237504879) 2 7 7 28859 2
11165 225764 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 592 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6003626.8723 2104846.99451 37.7597140171093 -122.430530121768 (37.7597140171093, -122.430530121768) 2 4 5 28862 3
11197 19797 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100 STAIRWAY21 2 Sidewalk: Curb side : Cutout Tree DPW 1     3 40ST                      
11262 258169 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 148 Felton St 4 Sidewalk: Curb side : Cutout Tree DPW 1 FUF   3 3x3   6010466.36455 2093776.54364 37.7297020458087 -122.406095661025 (37.7297020458087, -122.406095661025) 10 3 7 309 28
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
11687 95013 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 93 Leland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3     6010463.1246 2087285.1839 37.7118779294401 -122.405649829104 (37.7118779294401, -122.405649829104) 9 7 8 309 39
11840 190512 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 649 Delancey St 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   6015812.43568 2113078.6641 37.7829991439482 -122.38896064551 (37.7829991439482, -122.38896064551) 6 2 9 28856 6
11854 72418 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 3878 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   1     5996349.46796 2114952.54152 37.7870462658131 -122.456429650633 (37.7870462658131, -122.456429650633) 11 6 1 54 31
11856 107887 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 941 Washington St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/03/2014 12:00:00 AM 3 3x3 Permit Number 771772 6010165.08902 2117347.11602 37.7944046419585 -122.40879946772 (37.7944046419585, -122.40879946772) 3 1 10 28857 4
12006 17808 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1900X Laguna St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 4x4   6004382.775 2115429.5647 37.7888139592602 -122.4286702126 (37.7888139592602, -122.4286702126) 13 9 11 28858 27
12103 192453 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1301 Indiana St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6015095.71997 2102505.07691 37.7539266405026 -122.390701069299 (37.7539266405026, -122.390701069299) 10 3 8 28856 29
12146 80632 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 261-263 Texas St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     6013772.88089 2105882.21581 37.7631260494579 -122.395512375704 (37.7631260494579, -122.395512375704) 14 3 8 28856 29
12188 102373 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 870 39th Ave 1 Sidewalk: Curb side : Cutout Tree Rec/Park 5     1     5983890.73069 2109977.48147 37.7726630776505 -122.499165683617 (37.7726630776505, -122.499165683617) 11 6 2 55 26
12208 190492 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 541 Delancey St 6 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 6ft   6015312.24709 2113599.76666 37.7844022356283 -122.390727534552 (37.7844022356283, -122.390727534552) 6 2 9 28856 6
12292 74182 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 138 Wilson St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     5994679.00139 2086362.08429 37.7084480379267 -122.46013695827 (37.7084480379267, -122.46013695827) 9 8 6 28861 25
12414 225687 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 26 Samoset St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6009954.93782 2099199.55423 37.7445638490343 -122.408246060928 (37.7445638490343, -122.408246060928) 2 7 7 28859 2
12449 80636 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 261-263 Texas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     6013774.02904 2105871.68608 37.7630972009925 -122.395507666864 (37.7630972009925, -122.395507666864) 14 3 8 28856 29
12559 30713 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 111 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/31/1995 12:00:00 AM 3   Permit Number 34618 6005868.3438 2109981.6465 37.7739392736408 -122.42314294996 (37.7739392736408, -122.42314294996) 7 9 11 28852 10
12704 72671 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 203 04th Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF   2     5994585.61762 2114114.79768 37.7846446297113 -122.462471346717 (37.7846446297113, -122.462471346717) 11 6 2 54 11
12711 190451 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1498 Evans Ave 8 : Tree Private 2     3 Width 3ft   6016356.86171 2098066.94132 37.7418103263734 -122.386030346736 (37.7418103263734, -122.386030346736) 10 3 8 58 1
12736 219124 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 70 Joost Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6001597.50006 2094955.90851 37.7324402629898 -122.436840624998 (37.7324402629898, -122.436840624998) 9 7 5 63 40
12820 226199 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 701X Jarboe Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6008874.37746 2096929.55374 37.7382703591781 -122.411822063942 (37.7382703591781, -122.411822063942) 10 7 7 28859 2
12826 19801 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100 STAIRWAY21 6 Sidewalk: Curb side : Cutout Tree DPW 1     3 40ST                      
12858 128984 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 199 Linden St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6006377.26428 2110951.50272 37.7766309716791 -122.421451397362 (37.7766309716791, -122.421451397362) 7 9 11 28852 10
12872 225999 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 700 Duboce Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6002335.19401 2108315.06979 37.7691632487104 -122.435245457027 (37.7691632487104, -122.435245457027) 15 5 5 29492 9
12946 192425 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 187 Clara St 6 : Tree Private 2     1 Width 2ft   6011952.39777 2111919.37561 37.7796012912124 -122.402233334018 (37.7796012912124, -122.402233334018) 6 2 9 28856 34
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
12989 139211 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2031 Post St 17 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6002368.8281 2113997.6031 37.7847679739293 -122.435535694505 (37.7847679739293, -122.435535694505) 13 6 11 29490 13
13047 70677 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 110 Langton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     6010274.94764 2110617.18135 37.7759319943133 -122.407944528121 (37.7759319943133, -122.407944528121) 8 2 9 28853 34
13172 264709 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1315 Carolina St 1 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
13275 225677 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 600X Jarboe Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6008676.00847 2096910.24517 37.7382062114413 -122.412506564025 (37.7382062114413, -122.412506564025) 10 7 7 28859 2
13295 72207 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 528 Greenwich St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6010331.0847 2120296.9733 37.8025135249949 -122.40843327331 (37.8025135249949, -122.40843327331) 3 1 10 308 23
13302 231498 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2516 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/12/2020 02:05:00 PM 3 Width 3ft   6011317.42279 2101858.91316 37.7519420696849 -122.403721918837 (37.7519420696849, -122.403721918837) 10 4 8 28859 19
13365 225615 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 53 Wilder St 4 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6002593.03805 2095538.61045 37.73409676026 -122.43344044482 (37.73409676026, -122.43344044482) 2 7 5 63 7
13446 226197 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 801x Jarboe Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6009034.07414 2096916.87656 37.7382445081807 -122.411269014179 (37.7382445081807, -122.411269014179) 10 7 7 28859 2
13460 190428 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1300 Evans Ave 26 : Tree Private 2     1 Width 3ft   6017641.63274 2097108.43991 37.7392494942632 -122.381521343831 (37.7392494942632, -122.381521343831) 10 3 8 58 1
13502 225668 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 200X Ogden Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6007886.44005 2096099.07772 37.7359345806165 -122.415179104548 (37.7359345806165, -122.415179104548) 2 7 7 28859 2
13555 226201 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 701X Jarboe Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   6008833.56872 2096933.18629 37.7382780438907 -122.411963417589 (37.7382780438907, -122.411963417589) 10 7 7 28859 2
13578 253069 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 420 Innes Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   07/12/2017 12:00:00 AM 3   Permit Number 770367 6021281.00752 2092952.36789 37.7280379741387 -122.368650880757 (37.7280379741387, -122.368650880757) 10 3 8 58 1
13610 247805 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 488 30th St 2 : Tree Private 2     1 Width 3ft   6003450.91279 2098365.25645 37.7419067175277 -122.430676143802 (37.7419067175277, -122.430676143802) 2 7 5 63 22
13942 192464 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 797 22nd St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6015635.55835 2103917.93744 37.7578359916633 -122.388932798913 (37.7578359916633, -122.388932798913) 10 3 8 28856 29
13965 225680 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 901X Eugenia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6007829.14315 2097739.40397 37.7404353358322 -122.415493298878 (37.7404353358322, -122.415493298878) 2 7 7 28859 2
14001 49817 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1226 De Haro St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/11/2003 12:00:00 AM 3 3x3 Permit Number 46608 6012208.77564 2102677.65266 37.7542399031726 -122.400696986204 (37.7542399031726, -122.400696986204) 10 3 8 28856 29
14020 225632 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100X Powhattan Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6007685.38755 2098160.84073 37.7415844265716 -122.416020188286 (37.7415844265716, -122.416020188286) 2 7 7 28859 2
14023 226231 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2831 21st St 4 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6009237.08939 2103907.61142 37.7574509019423 -122.411060731168 (37.7574509019423, -122.411060731168) 2 4 7 28859 19
14048 19740 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100 STAIRWAY15 -50 Sidewalk: Curb side : Cutout Tree DPW 1     3 1OST                      
14185 75407 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 194X Russ St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 5x5   6010525.12192 2111307.03338 37.7778401704149 -122.407127744063 (37.7778401704149, -122.407127744063) 14 2 9 28853 34
14371 1412 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 87 Ardath Ct 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/11/2006 12:00:00 AM 3 3X4   6017443.0312922 2095232.0493547 37.7340863325513 -122.382077533105 (37.7340863325513, -122.382077533105) 10 3 8 58 1
14392 128960 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 270 McAllister St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6007843 2112396 37.7806797483911 -122.416483319824 (37.7806797483911, -122.416483319824) 7 10 9 28852 36
14461 62082 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 526 Connecticut St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/22/1985 12:00:00 AM 5   Permit Number 22166 6013236.0728 2104376.01067 37.7589604679833 -122.397263399784 (37.7589604679833, -122.397263399784) 10 3 8 28856 29
14531 84257 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 894 25th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   1     5988243.88098 2109914.2292 37.7727438112406 -122.484103215339 (37.7727438112406, -122.484103215339) 11 6 2 55 26
14644 128956 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 190 McAllister St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6008324.7013 2112452.543 37.7808620795531 -122.414820881171 (37.7808620795531, -122.414820881171) 7 10 9 28852 36
14739 226064 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 3400 22nd St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6005624.89593 2103166.13242 37.7552117465446 -122.423500439705 (37.7552117465446, -122.423500439705) 2 4 5 28859 19
14792 226083 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1681 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6009334.76318 2099698.46458 37.7458990005447 -122.410425730686 (37.7458990005447, -122.410425730686) 2 7 7 28859 2
14813 190494 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 541 Delancey St 13 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 6ft   6015224.29962 2113700.39003 37.7846736447102 -122.391038840285 (37.7846736447102, -122.391038840285) 6 2 9 28856 6
14821 226044 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 3548 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6005910.57761 2105523.0579 37.7616994342103 -122.422679949545 (37.7616994342103, -122.422679949545) 8 4 5 28859 19
14854 74616 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2350 Anza St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   1     5991316.62714 2112033.26872 37.7787405344574 -122.473628955238 (37.7787405344574, -122.473628955238) 11 6 2 54 26
15361 36968 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 118 06th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   05/29/1998 12:00:00 AM 5   Permit Number 39595 5993987.97624 2114726.89582 37.786290850626 -122.464583430573 (37.786290850626, -122.464583430573) 11 6 1 54 11
15486 81720 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 998 Indiana St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3     6014948.39032 2104075.36829 37.7582301501175 -122.39132033706 (37.7582301501175, -122.39132033706) 10 3 8 28856 29
15540 124027 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 201 Funston Ave 1 Sidewalk: Curb side : Yard Tree Private 2     13 Width 3ft   5991798.47727 2113998.77869 37.7841651786362 -122.47210536759 (37.7841651786362, -122.47210536759) 11 6 2 54 11
15552 149669 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1701 16th St 2 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 3ft   6011308.34689 2106942.89259 37.765901038939 -122.404111067171 (37.765901038939, -122.404111067171) 8 3 8 28853 20
15610 78628 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 695 Rhode Island St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   2     6011848.41815 2105223.54822 37.7612102650599 -122.402122174202 (37.7612102650599, -122.402122174202) 10 3 8 28856 29
15669 226292 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 537 Chenery St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/01/1991 12:00:00 AM 3 Width 2ft Permit Number 29820 6003335.67331 2095877.19361 37.7350685379825 -122.430897079359 (37.7350685379825, -122.430897079359) 2 7 5 63 7
15719 7346 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2225 Fillmore St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/28/1980 12:00:00 AM 1 3X3   6002798.59801 2115979.15257 37.7902332041481 -122.43419054146 (37.7902332041481, -122.43419054146) 13 9 1 29490 27
15826 83441 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 325 Mississippi St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3 3x3   6014074.06894 2105534.94834 37.7621892769404 -122.394446342739 (37.7621892769404, -122.394446342739) 10 3 8 28856 29
15859 228223 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 176 Caselli Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6000130.83227 2104896.01094 37.7596499359143 -122.442624675007 (37.7596499359143, -122.442624675007) 2 4 5 28862 3
15910 226183 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 330 Banks St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6008608.53672 2097126.22235 37.7387954508426 -122.412755113274 (37.7387954508426, -122.412755113274) 10 7 7 28859 2
15997 225696 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 3342 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 6x9   6006072.97895 2103191.31452 37.7553061717546 -122.421952622821 (37.7553061717546, -122.421952622821) 2 4 5 28859 19
16071 202049 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 55 Exeter St 3 : Tree Private 2     1 Width 3ft   6012555.81447 2090941.8893 37.7220353110641 -122.398673311925 (37.7220353110641, -122.398673311925) 10 3 8 58 1
16074 128922 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2101 Washington St 5 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6004454.93777 2116689.88617 37.7922785673477 -122.428510409935 (37.7922785673477, -122.428510409935) 13 9 1 28858 27

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