trees

5,599 rows where qSpecies_id = 38 sorted by Zip Codes

✎ View and edit SQL

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)
10998 100001 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 501X 01st St 2 Sidewalk: Curb side : Pot Tree Private 2         Address is 100 1st Street                    
2219 127642 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 30 Grove St 6 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6008019.48928 2111712.32042 37.7788124517715 -122.41582433125 (37.7788124517715, -122.41582433125) 7 10 9 28852 36
2395 224762 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 301 Lily St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6004982.47318 2110039.87008 37.7740491098102 -122.426211472077 (37.7740491098102, -122.426211472077) 7 9 11 28852 10
7290 103105 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 300 Post St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6010638.43235 2115205.50204 37.7885507857476 -122.407010612771 (37.7885507857476, -122.407010612771) 5 1 10 28852 6
7342 26844 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 100 Van Ness Ave 6 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3 Permit Number 775213 6006969.72882 2110998.7322 37.7767940394414 -122.419405236481 (37.7767940394414, -122.419405236481) 7 9 9 28852 36
8984 127637 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 30 Grove St 1 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 4ft   6008197.67751 2111734.21851 37.7788825944034 -122.415209456658 (37.7788825944034, -122.415209456658) 7 10 9 28852 36
10366 224768 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 310 Lily St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6004950.30827 2110058.97913 37.7740997605225 -122.4263240969 (37.7740997605225, -122.4263240969) 7 9 11 28852 10
14627 127654 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 290 Linden St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6006004.92126 2110899.69306 37.7764677141485 -122.422735759666 (37.7764677141485, -122.422735759666) 7 9 11 28852 10
16679 127560 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 181 Ellis St 5 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   6010074.68482 2114026.3447 37.7852815387496 -122.408877875115 (37.7852815387496, -122.408877875115) 14 10 10 28852 36
17597 255778 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 281 Geary St 7 Sidewalk: Curb side : Cutout Tree Private 2   08/17/2018 12:00:00 AM 3 Width 4ft   6010453.10569 2114773.50548 37.7873542539382 -122.407621346845 (37.7873542539382, -122.407621346845) 5 1 10 28852 6
20605 127641 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 30 Grove St 5 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 4ft   6008074.03849 2111721.54377 37.7788408433611 -122.415636276717 (37.7788408433611, -122.415636276717) 7 10 9 28852 36
21536 224767 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 308 Lily St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6004967.19895 2110061.42624 37.7741074344349 -122.426265843319 (37.7741074344349, -122.426265843319) 7 9 11 28852 10
22299 224766 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 308 Lily St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6004981.82238 2110062.80217 37.7741120389683 -122.426215356268 (37.7741120389683, -122.426215356268) 7 9 11 28852 10
23582 127646 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 30 Grove St 10 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 4ft   6007900.65961 2111695.89865 37.7787606804851 -122.416234247632 (37.7787606804851, -122.416234247632) 7 10 9 28852 36
25245 127531 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 120 O'Farrell St 2 Sidewalk: Curb side : Pot Tree Private 2     6 Width 3ft   6010719.61226 2114518.87728 37.7866700200467 -122.406681334082 (37.7866700200467, -122.406681334082) 5 10 10 28852 6
26117 127662 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 351 Hayes St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 5ft   6006189.5855 2111060.19286 37.7769188248697 -122.422108357508 (37.7769188248697, -122.422108357508) 7 9 11 28852 10
26340 117349 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 391 Hayes St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6006006.715 2111040.39025 37.7768541357419 -122.42273955569 (37.7768541357419, -122.42273955569) 7 9 11 28852 10
26578 117350 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 391 Hayes St 3 Sidewalk: Curb side : Cutout Tree Private 2     13 3x3   6006016.71594 2111041.8116 37.7768586026778 -122.422705060397 (37.7768586026778, -122.422705060397) 7 9 11 28852 10
27602 224769 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 310 Lily St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6004939.63554 2110058.63975 37.7740982253779 -122.426360991586 (37.7740982253779, -122.426360991586) 7 9 11 28852 10
28760 127525 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 535 Post St 4 Sidewalk: Curb side : Pot Tree Private 2     5 Width 4ft   6009652.45173 2115007.72817 37.7879525225236 -122.410407998744 (37.7879525225236, -122.410407998744) 5 1 10 28852 36
32353 127657 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 391 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 5ft   6005995.59993 2111037.89883 37.7768466677822 -122.422777829032 (37.7768466677822, -122.422777829032) 7 9 11 28852 10
33628 127649 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 301 Grove St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   6006252.41245 2111416.86805 37.7779017119256 -122.421916362171 (37.7779017119256, -122.421916362171) 7 9 11 28852 10
37617 127555 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 150 Mason St 2 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   6009930.01197 2113957.47412 37.7850843318304 -122.409373539176 (37.7850843318304, -122.409373539176) 14 10 10 28852 36
38479 127529 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 401 Post St 3 Sidewalk: Curb side : Pot Tree Private 2     3 Width 4ft   6010134.54183 2115080.18539 37.7881784862008 -122.408745160367 (37.7881784862008, -122.408745160367) 5 1 10 28852 36
40636 127635 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 11 Hyde St 8 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6008240.08971 2111777.143 37.7790028382582 -122.415065774669 (37.7790028382582, -122.415065774669) 7 10 9 28852 36
43503 225320 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 230 Gough St 5 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 4ft   6006014.77117 2110673.71473 37.7758477880836 -122.422685623354 (37.7758477880836, -122.422685623354) 7 9 11 28852 10
45760 127581 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 515 O'Farrell St 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6008796.63167 2114200.39549 37.7856877688247 -122.413311877238 (37.7856877688247, -122.413311877238) 7 10 9 28852 36
48528 127554 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 150 Mason St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6009937.99276 2113915.78132 37.7849703004876 -122.409342984713 (37.7849703004876, -122.409342984713) 14 10 10 28852 36
48852 127552 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 184 Ellis St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 4ft   6009992.13735 2114068.5814 37.7853928865178 -122.409166446877 (37.7853928865178, -122.409166446877) 14 10 9 28852 36
51091 127479 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 524 Post St 5 Sidewalk: Curb side : Pot Tree Private 2     3 Width 3ft   6009426.27871 2115024.67865 37.7879863829144 -122.411191717448 (37.7879863829144, -122.411191717448) 5 1 10 28852 21
51310 249392 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 318 Turk St 1 : Tree Private 2     17 Width 3ft   6008424.06306 2113156.66711 37.7828010178889 -122.414526979149 (37.7828010178889, -122.414526979149) 7 10 9 28852 36
52014 127626 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 530 Golden Gate Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   6007019.86333 2112618.03064 37.7812430656421 -122.419346706804 (37.7812430656421, -122.419346706804) 7 9 9 28852 36
52629 16917 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 497 Oak St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6004662.52755 2110151.9892 37.774338872272 -122.427326207862 (37.774338872272, -122.427326207862) 7 9 11 28852 10
54485 63551 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 222 Mason St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/20/1987 12:00:00 AM 11   Permit Number 24168 6009913.50587 2114086.30921 37.7854371574299 -122.409439740963 (37.7854371574299, -122.409439740963) 14 10 9 28852 36
54672 224771 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 312 Lily St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6004910.91549 2110054.20014 37.7740844117944 -122.426460023119 (37.7740844117944, -122.426460023119) 7 9 11 28852 10
55592 127535 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 170 O'Farrell St 1 Sidewalk: Curb side : Pot Tree Private 2     5 Width 3ft   6010565.52059 2114493.19159 37.7865908707281 -122.407212645474 (37.7865908707281, -122.407212645474) 5 10 10 28852 6
58639 127638 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 30 Grove St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 4ft   6008184.25829 2111735.1014 37.7788842644447 -122.415255941724 (37.7788842644447, -122.415255941724) 7 10 9 28852 36
58777 127506 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 281 Geary St 4 Sidewalk: Curb side : Cutout Tree Private 2   08/17/2018 12:00:00 AM 3 Width 4ft   6010453.10569 2114773.50548 37.7873542539382 -122.407621346845 (37.7873542539382, -122.407621346845) 5 1 10 28852 6
58997 127652 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 301 Grove St 5 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6006305.16992 2111423.23911 37.7779221805011 -122.421734307897 (37.7779221805011, -122.421734307897) 7 9 11 28852 10
59060 127559 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 181 Ellis St 4 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6010050.13315 2114025.37954 37.7852775133885 -122.408962748656 (37.7852775133885, -122.408962748656) 14 10 10 28852 36
59432 127660 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 379 Hayes St 3 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 5ft   6006064.73751 2111042.86771 37.7768642117369 -122.422539014075 (37.7768642117369, -122.422539014075) 7 9 11 28852 10
59989 127663 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 330 Gough St 3 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6005976.82467 2110951.854 37.7766093501885 -122.422836661808 (37.7766093501885, -122.422836661808) 7 9 11 28852 10
60808 225321 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 45 Franklin St 2 Sidewalk: Curb side : Cutout Tree Private 2     24 Width 4ft   6006505.92687 2110304.8359 37.7748626338316 -122.420960390908 (37.7748626338316, -122.420960390908) 7 9 11 28852 10
60889 127632 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 11 Hyde St 5 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6008231.41623 2111830.84433 37.7791498018675 -122.415099582002 (37.7791498018675, -122.415099582002) 7 10 9 28852 36
61265 26845 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 100 Van Ness Ave 7 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3 Permit Number 775213 6006964.16578 2111032.60038 37.7768867199943 -122.419426884038 (37.7768867199943, -122.419426884038) 7 9 9 28852 36
61386 224761 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 309 Lily St 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6004961.04745 2110035.28026 37.7740352962232 -122.426285260558 (37.7740352962232, -122.426285260558) 7 9 11 28852 10
62228 14661 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 683 McAllister St 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/14/2016 12:00:00 AM 35 3x3   6005906.95663 2112062.04188 37.7796537135926 -122.423157288085 (37.7796537135926, -122.423157288085) 7 9 11 28852 10
62532 103109 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 300 Post St 5 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6010585.29035 2115196.36518 37.7885227241995 -122.407193832533 (37.7885227241995, -122.407193832533) 5 1 10 28852 6
63671 127542 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 222 Mason St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 4ft   6009910.06076 2114109.83139 37.7855015506911 -122.409453320729 (37.7855015506911, -122.409453320729) 14 10 9 28852 36
63803 224763 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 301 Lily St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6005004.44845 2110043.88951 37.774061388259 -122.426135741998 (37.774061388259, -122.426135741998) 7 9 11 28852 10
63909 103106 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 300 Post St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6010625.62871 2115201.67506 37.788539561288 -122.407054641768 (37.788539561288, -122.407054641768) 5 1 10 28852 6
66914 127569 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 80 Eddy St 3 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   6010005.08101 2113717.02232 37.7844283141472 -122.409096850153 (37.7844283141472, -122.409096850153) 14 10 10 28852 36
67667 127651 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 301 Grove St 4 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6006289.23245 2111422.48558 37.7779192127471 -122.421789387771 (37.7779192127471, -122.421789387771) 7 9 11 28852 10
67911 127655 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 336 Hayes St 4 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 4ft   6006208.89673 2111115.2751 37.7770711565405 -122.422045467948 (37.7770711565405, -122.422045467948) 7 9 11 28852 10
68073 127508 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 233 Geary St 1 Sidewalk: Curb side : Pot Tree Private 2     6 Width 4ft   6010589.92409 2114799.33229 37.7874328259199 -122.407149802643 (37.7874328259199, -122.407149802643) 5 1 10 28852 6
69231 224773 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 110 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   6004274.51172 2109211.61574 37.7717348843826 -122.428601380869 (37.7717348843826, -122.428601380869) 7 9 11 28852 10
70655 127561 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 55 Cyril Magnin St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   6010145.41439 2113970.36276 37.7851317872437 -122.408629220681 (37.7851317872437, -122.408629220681) 14 10 10 28852 36
72280 127667 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 330 Gough St 7 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6005968.47708 2111002.24888 37.77674725131 -122.422869121026 (37.77674725131, -122.422869121026) 7 9 11 28852 10
73121 26842 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 100 Van Ness Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3 Permit Number 775213 6006970.058 2110963.93279 37.7766985071661 -122.419401628405 (37.7766985071661, -122.419401628405) 7 9 9 28852 36
73148 127538 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 170 O'Farrell St 4 Sidewalk: Curb side : Pot Tree Private 2     5 Width 3ft   6010539.53779 2114494.20954 37.7865922116181 -122.407302611837 (37.7865922116181, -122.407302611837) 5 10 10 28852 6
73438 127553 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 184 Ellis St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   6009950.33069 2114063.57129 37.7853767877604 -122.409310732326 (37.7853767877604, -122.409310732326) 14 10 9 28852 36
73996 6947 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 577 Fell St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 12x6   6004695.20098 2110505.36456 37.7753110025348 -122.427238361166 (37.7753110025348, -122.427238361166) 7 9 11 28852 10
74154 127536 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 170 O'Farrell St 2 Sidewalk: Curb side : Pot Tree Private 2     5 Width 3ft   6010547.33485 2114491.60788 37.7865855044578 -122.407275452313 (37.7865855044578, -122.407275452313) 5 10 10 28852 6
74467 127533 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 120 O'Farrell St 4 Sidewalk: Curb side : Pot Tree Private 2     6 Width 3ft   6010660.09113 2114511.29565 37.7866458723483 -122.406886729337 (37.7866458723483, -122.406886729337) 5 10 10 28852 6
76593 127643 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 30 Grove St 7 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6007955.25869 2111707.55332 37.7787957513555 -122.416046193094 (37.7787957513555, -122.416046193094) 7 10 9 28852 36
79704 127661 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 351 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 5ft   6006169.59466 2111057.68357 37.776910807423 -122.422177333721 (37.776910807423, -122.422177333721) 7 9 11 28852 10
80291 127546 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 222 Mason St 3 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6009885.12355 2114282.3216 37.7859737703268 -122.409551774903 (37.7859737703268, -122.409551774903) 14 10 9 28852 36
80470 117341 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 372 Hayes St 3 Sidewalk: Curb side : Cutout Tree Private 2     25 5x5   6006040.01019 2111087.20931 37.7769845680087 -122.422627705227 (37.7769845680087, -122.422627705227) 7 9 11 28852 10
82291 127627 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 667 McAllister St 2 Sidewalk: Curb side : Cutout Tree Private 2     25 Width 4ft   6006026.9443 2112079.91349 37.7797095551813 -122.422743468632 (37.7797095551813, -122.422743468632) 7 9 11 28852 10
83880 127634 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 11 Hyde St 7 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   6008239.21705 2111794.19116 37.7790495993938 -122.415070000593 (37.7790495993938, -122.415070000593) 7 10 9 28852 36
84510 127516 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 335 Powell St 10 Sidewalk: Curb side : Pot Tree Private 2     5 Width 4ft   6010248.07837 2114825.10668 37.7874844595824 -122.408334342849 (37.7874844595824, -122.408334342849) 5 1 10 28852 36
84523 127566 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 55 Cyril Magnin St 6 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 4ft   6010148.26915 2113833.31733 37.7847556529825 -122.408609672995 (37.7847556529825, -122.408609672995) 14 10 10 28852 36
85084 127522 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 441 Mason St 2 Sidewalk: Curb side : Pot Tree Private 2     6 Width 4ft   6009737.67951 2114979.8254 37.7878806856047 -122.410111154116 (37.7878806856047, -122.410111154116) 5 1 10 28852 36
86363 127513 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 335 Powell St 7 Sidewalk: Curb side : Pot Tree Private 2     4 Width 4ft   6010233.96645 2114918.19092 37.7877392564025 -122.408389735705 (37.7877392564025, -122.408389735705) 5 1 10 28852 36
87129 127556 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 181 Ellis St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6009964.12695 2114018.33975 37.7852533656844 -122.409259808196 (37.7852533656844, -122.409259808196) 14 10 10 28852 36
87276 127519 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 330 Geary St 3 Sidewalk: Curb side : Pot Tree Private 2     4 Width 4ft   6010062.81561 2114779.01245 37.7873475198142 -122.408972063815 (37.7873475198142, -122.408972063815) 5 1 10 28852 36
87803 127551 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 155 Cyril Magnin St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 4ft   6010057.09208 2114318.38765 37.7860824335929 -122.408959353688 (37.7860824335929, -122.408959353688) 14 10 9 28852 36
93045 127623 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 300 Elm St 1 Sidewalk: Curb side : Cutout Tree Private 2     23 Width 4ft   6006154.15344 2112646.1752 37.7812715480939 -122.422343640862 (37.7812715480939, -122.422343640862) 7 9 11 28852 41
94038 127507 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 251 Geary St 1 Sidewalk: Curb side : Pot Tree Private 2     5 Width 4ft   6010529.78022 2114789.11196 37.7874013973135 -122.407357168326 (37.7874013973135, -122.407357168326) 5 1 10 28852 6
96604 112298 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 336 Hayes St 2 Sidewalk: Curb side : Cutout Tree Private 2     17 3x3   6006237.68045 2111117.60382 37.7770791740065 -122.421946061371 (37.7770791740065, -122.421946061371) 7 9 11 28852 10
97570 127656 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 370 Hayes St 2 Sidewalk: Curb side : Cutout Tree Private 2     27 Width 5ft   6006085.91351 2111095.026 37.7770086203774 -122.422469466803 (37.7770086203774, -122.422469466803) 7 9 11 28852 10
97643 127658 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 381 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 5ft   6006048.24252 2111042.91578 37.7768634131526 -122.422596078741 (37.7768634131526, -122.422596078741) 7 9 11 28852 10
97649 127670 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 400 Gough St 4 Sidewalk: Curb side : Cutout Tree Private 2     23 Width 4ft   6005945.24095 2111155.73109 37.7771673651136 -122.422960412994 (37.7771673651136, -122.422960412994) 7 9 11 28852 10
98333 249412 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 640 Turk St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6006934.45085 2112950.09504 37.782150022933 -122.419665760187 (37.782150022933, -122.419665760187) 7 9 9 28852 36
99127 127548 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 222 Mason St 5 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 4ft   6009881.28786 2114310.73753 37.7860515787509 -122.409567051693 (37.7860515787509, -122.409567051693) 14 10 9 28852 36
99542 127631 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 11 Hyde St 4 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6008230.55603 2111848.50079 37.7791982339474 -122.41510380792 (37.7791982339474, -122.41510380792) 7 10 9 28852 36
100612 249413 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 640 Turk St 2 : Tree Private 2     14 Width 4ft   6006896.39396 2112943.46706 37.7821296802828 -122.419796949688 (37.7821296802828, -122.419796949688) 7 9 9 28852 36
101424 127545 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 222 Mason St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   6009887.29677 2114268.59693 37.7859362074357 -122.409543287111 (37.7859362074357, -122.409543287111) 14 10 9 28852 36
102107 127541 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 188 O'Farrell St 2 Sidewalk: Curb side : Pot Tree Private 2     5 Width 3ft   6010455.35555 2114480.29121 37.7865492833671 -122.407592881533 (37.7865492833671, -122.407592881533) 5 10 10 28852 6
102140 117351 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 391 Hayes St 4 Sidewalk: Curb side : Cutout Tree Private 2     16 3x3   6006031.86299 2111040.91638 37.7768569991983 -122.42265259846 (37.7768569991983, -122.42265259846) 7 9 11 28852 10
104152 224770 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 312 Lily St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6004921.06141 2110056.22732 37.7740905514782 -122.426425070969 (37.7740905514782, -122.426425070969) 7 9 11 28852 10
105645 127517 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 330 Geary St 1 Sidewalk: Curb side : Pot Tree Private 2     4 Width 4ft   6010076.35722 2114778.73619 37.7873475198145 -122.408925192965 (37.7873475198145, -122.408925192965) 5 1 10 28852 36
106773 127565 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 55 Cyril Magnin St 5 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6010151.67997 2113856.21128 37.7848187053498 -122.408599488199 (37.7848187053498, -122.408599488199) 14 10 10 28852 36
107156 103718 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 124 Turk St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/13/2013 12:00:00 AM 4 3x4.5 Permit Number 770328 6009347.34336 2113287.97166 37.7832133750335 -122.411342084087 (37.7832133750335, -122.411342084087) 14 10 9 28852 36
110257 127625 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 300 Elm St 3 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   6006082.36524 2112639.55877 37.7812493312418 -122.422591522778 (37.7812493312418, -122.422591522778) 7 9 11 28852 41
110459 112299 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 336 Hayes St 3 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6006218.21596 2111112.16374 37.7770631391008 -122.422013008687 (37.7770631391008, -122.422013008687) 7 9 11 28852 10
110643 127521 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 441 Mason St 1 Sidewalk: Curb side : Pot Tree Private 2     6 Width 4ft   6009736.66534 2114990.47481 37.7879098694816 -122.410115415104 (37.7879098694816, -122.410115415104) 5 1 10 28852 36
110860 127650 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 301 Grove St 3 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6006272.53479 2111419.94559 37.7779112969109 -122.421846970479 (37.7779112969109, -122.421846970479) 7 9 11 28852 10
112815 127524 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 535 Post St 2 Sidewalk: Curb side : Pot Tree Private 2     6 Width 4ft   6009616.24129 2115003.56172 37.7879390524805 -122.41053298651 (37.7879390524805, -122.41053298651) 5 1 10 28852 36
113272 127528 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 401 Post St 2 Sidewalk: Curb side : Pot Tree Private 2     3 Width 4ft   6010095.89215 2115072.26116 37.7881545633267 -122.408878322978 (37.7881545633267, -122.408878322978) 5 1 10 28852 36

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