5,599 rows where qSpecies_id = 38 sorted by Police Districts

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)
16148 255011 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 245 North Point St 17 Sidewalk: Curb side : Cutout Tree Private 2       Width 4ft   6009525.60238 2121869.50761 37.806786171612 -122.411331809333 (37.806786171612, -122.411331809333) 3 1 10 308 23
16457 128095 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2201 Grant Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6010183.25462 2122212.57297 37.8077650063215 -122.4090800868 (37.8077650063215, -122.4090800868) 3 1 10 308 23
16586 128376 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 737 Pine St 4 Sidewalk: Curb side : Pot Tree Private 2     2 Width 3ft   6010409.07251 2116157.67498 37.7911523868246 -122.407871336803 (37.7911523868246, -122.407871336803) 5 1 10 28857 21
16938 128083 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 245 North Point St 16 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6009715.0017 2121896.66309 37.8068713545053 -122.410678271985 (37.8068713545053, -122.410678271985) 3 1 10 308 23
17015 128215 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1073 Front St 3 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6012642.5381 2119643.26949 37.800847783557 -122.400388500743 (37.800847783557, -122.400388500743) 3 1 10 28860 6
17027 128284 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1701 Montgomery St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 5ft   6011235.87378 2121347.94939 37.8054498743769 -122.405376293687 (37.8054498743769, -122.405376293687) 3 1 10 308 23
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
17607 128073 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 245 North Point St 6 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   6009455.6728 2121862.0115 37.8067616668876 -122.411573285385 (37.8067616668876, -122.411573285385) 3 1 10 308 23
17895 128132 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2600 Jones St 6 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6007860.12277 2121829.76573 37.8065835003791 -122.417092726973 (37.8065835003791, -122.417092726973) 5 1 10 308 23
17937 66603 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1225 Pine St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/22/1991 12:00:00 AM 7   Permit Number 29798 6008039.621 2115833.32115 37.790128854013 -122.416046607673 (37.790128854013, -122.416046607673) 13 1 10 28858 21
18083 128072 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 245 North Point St 5 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6009436.58528 2121857.30143 37.806747663529 -122.411639008733 (37.806747663529, -122.411639008733) 3 1 10 308 23
18264 128172 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 211 Beach St 6 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6008992.41136 2122145.2973 37.80751350191 -122.413196542783 (37.80751350191, -122.413196542783) 3 1 10 308 23
18520 127917 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2357 Jones St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 6ft   6007984.65596 2120608.29341 37.8032366509171 -122.416575173411 (37.8032366509171, -122.416575173411) 5 1 1 308 32
18548 128058 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2615 Taylor St 4 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 4ft   6008303.85065 2121803.98955 37.8065376772268 -122.415555292742 (37.8065376772268, -122.415555292742) 5 1 10 308 23
18561 128739 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 501 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 2ft   6011591.37219 2118340.96654 37.7972133012131 -122.403934300929 (37.7972133012131, -122.403934300929) 3 1 10 308 4
18678 128079 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 245 North Point St 12 Sidewalk: Curb side : Cutout Tree Private 2   05/26/2015 12:00:00 AM 13 Width 4ft   6009619.79049 2121884.15798 37.8068316799992 -122.411006886985 (37.8068316799992, -122.411006886985) 3 1 10 308 23
18998 128251 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 40 Broadway 3 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 4ft   6013196.09483 2118964.28561 37.7990143096206 -122.398425279818 (37.7990143096206, -122.398425279818) 3 1 10 28860 6
19726 128500 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 233 Pine St 2 Sidewalk: Curb side : Pot Tree Private 2     3 Width 3ft   6012641.59188 2116463.62131 37.7921171759089 -122.400168337697 (37.7921171759089, -122.400168337697) 4 1 10 28854 6
20203 128149 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 580 North Point St 7 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007659.25914 2121669.67904 37.8061326414825 -122.417776500385 (37.8061326414825, -122.417776500385) 5 1 10 308 23
20267 128613 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 50 Washington St 6 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6013782.36429 2118074.90802 37.7966049314193 -122.396334206783 (37.7966049314193, -122.396334206783) 3 1 10 28860 6
20287 128494 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 369 Pine St 1 Sidewalk: Curb side : Pot Tree Private 2     5 Width 3ft   6012086.37369 2116397.02316 37.7919033396242 -122.40208472734 (37.7919033396242, -122.40208472734) 4 1 10 28854 6
20530 93479 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 113X Leroy Pl 4 Sidewalk: Curb side : Cutout Tree Private 2     9 1.5x3 Tree 4 on Leroy 6008317.25099 2116630.80353 37.792334150853 -122.415142500331 (37.792334150853, -122.415142500331) 5 1 10 28858 21
20603 127714 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1255 Taylor St 2 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   6008937.90701 2117277.04325 37.7941434267417 -122.413040722668 (37.7941434267417, -122.413040722668) 5 1 10 28857 21
20893 128240 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1050 Battery St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6012332.77903 2119745.98947 37.8011125493603 -122.40146762695 (37.8011125493603, -122.40146762695) 3 1 10 28860 6
21106 128163 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2802 Jones St 3 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6007818.97512 2122158.67 37.8074842730556 -122.417258448614 (37.8074842730556, -122.417258448614) 5 1 10 308 23
21159 48871 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 535 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/15/2002 12:00:00 AM 12 3x3 Permit Number 46080 6011476.38501 2118326.98884 37.797168496982 -122.404331203243 (37.797168496982, -122.404331203243) 3 1 10 308 4
21170 11037 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1523 Hyde St 1 Sidewalk: Curb side : Cutout Tree DPW 1     70 3x3   6007436.11305 2117588.78298 37.7949149677025 -122.418259216898 (37.7949149677025, -122.418259216898) 5 1 10 28858 32
21227 128297 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1445 Sansome St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6011798.72736 2120726.21758 37.8037742044892 -122.403384685668 (37.8037742044892, -122.403384685668) 3 1 10 28860 6
21236 128249 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 40 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 5ft   6013230.32013 2118971.72942 37.7990366550722 -122.398307370585 (37.7990366550722, -122.398307370585) 3 1 10 28860 6
21674 112696 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 100 North Point St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   6010197.93258 2122016.89458 37.8072285445333 -122.409015474098 (37.8072285445333, -122.409015474098) 3 1 10 308 23
21888 127758 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1005 Jones St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6008623.20133 2116011.5553 37.7906510354728 -122.4140400736 (37.7906510354728, -122.4140400736) 5 1 10 28858 21
21939 128415 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 555 California St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 4ft   6011478.27052 2116657.13994 37.7925835984915 -122.404207093202 (37.7925835984915, -122.404207093202) 4 1 10 28854 6
22072 128239 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1000 Battery St 4 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6012346.02917 2119632.64296 37.8008020665329 -122.401413805224 (37.8008020665329, -122.401413805224) 3 1 10 28860 6
22200 128551 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 580 California St 4 Sidewalk: Curb side : Pot Tree Private 2     7 Width 4ft   6011511.00883 2116724.70141 37.7927709353884 -122.404098573787 (37.7927709353884, -122.404098573787) 4 1 10 28854 6
22248 127998 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2445 Mason St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6008801.60078 2121712.94158 37.8063156481148 -122.413826285851 (37.8063156481148, -122.413826285851) 3 1 10 308 23
22659 53616 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 580 California St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/06/1986 12:00:00 AM 8   Permit Number 23021 6011569.0599 2116730.65971 37.7927905387988 -122.403898132903 (37.7927905387988, -122.403898132903) 4 1 10 28854 6
22750 113458 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 14 Leroy Pl 1 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6008346.99172 2116484.00265 37.7919327429628 -122.415029201053 (37.7919327429628, -122.415029201053) 5 1 10 28858 21
22755 128713 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 555 Jackson St 1 Sidewalk: Curb side : Pot Tree Private 2     4 Width 4ft   6011289.01038 2117973.50016 37.7961874301503 -122.404954668136 (37.7961874301503, -122.404954668136) 3 1 10 28857 4
23010 127943 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 101 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/12/2017 12:00:00 AM 3 Width 3ft   6012601.19681 2119174.02118 37.7995570351977 -122.400498579547 (37.7995570351977, -122.400498579547) 3 1 10 28860 6
23083 113950 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1416 Powell St 3 Sidewalk: Curb side : Cutout Tree Private 2     13 3x3   6009767.57864 2118598.02538 37.7978170601548 -122.410263269057 (37.7978170601548, -122.410263269057) 3 1 10 308 4
23136 112697 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 100 North Point St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6010180.49666 2122013.17318 37.807217349764 -122.409075552403 (37.807217349764, -122.409075552403) 3 1 10 308 23
23167 11044 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1550 Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2     70 3x3   6007464.94523 2117711.8455 37.795254489665 -122.418168182118 (37.795254489665, -122.418168182118) 5 1 10 28858 32
23227 128622 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 218 Jackson St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6012788.30553 2118217.83281 37.7969420036353 -122.399783934202 (37.7969420036353, -122.399783934202) 3 1 10 28860 6
23249 128737 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 535 Pacific Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 2ft   6011489.30967 2118331.34924 37.7971811918121 -122.40428678752 (37.7971811918121, -122.40428678752) 3 1 10 308 4
23290 11021 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1407 Hyde St 1 Sidewalk: Curb side : Cutout Tree DPW 1     70 3x3   6007490.12051 2117192.20597 37.7938291055709 -122.41804421508 (37.7938291055709, -122.41804421508) 5 1 10 28858 32
23400 127728 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 50 Leroy Pl 4 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 1ft   6008337.80395 2116548.86512 37.7921103230909 -122.415065584015 (37.7921103230909, -122.415065584015) 5 1 10 28858 21
23545 58731 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1050 Battery St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/08/1981 12:00:00 AM 15   Permit Number 19424 6012335.49363 2119717.01394 37.8010331410233 -122.401456195674 (37.8010331410233, -122.401456195674) 3 1 10 28860 6
24107 128314 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1150 Sansome St 7 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6011984.40166 2119726.28847 37.8010390109056 -122.402671784073 (37.8010390109056, -122.402671784073) 3 1 10 28860 6
24549 128574 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 201 Washington St 5 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6012708.35093 2117826.92537 37.7958642075089 -122.400033131824 (37.7958642075089, -122.400033131824) 3 1 10 28860 6
24651 128467 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 339 California St 3 Sidewalk: Curb side : Pot Tree Private 2     2 Width 3ft   6012650.63962 2116819.58835 37.7930950816316 -122.40016204337 (37.7930950816316, -122.40016204337) 4 1 10 28854 6
25155 128263 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2 Lombard St 1 Sidewalk: Curb side : Pot Tree Private 2     7 Width 4ft   6012051.14949 2120876.60895 37.8042012376618 -122.402521741194 (37.8042012376618, -122.402521741194) 3 1 10 28860 6
25275 128324 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 149 Union St 4 Sidewalk: Property side : Yard Tree Private 2     6     6012167.10136 2119825.45961 37.8013215095468 -122.402046536739 (37.8013215095468, -122.402046536739) 3 1 10 28860 6
25397 128625 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 218 Jackson St 5 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6012718.96955 2118206.80786 37.7969078662509 -122.400023080099 (37.7969078662509, -122.400023080099) 3 1 10 28860 6
25605 127983 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 240 Bay St 3 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 4ft   6009710.13286 2121599.23274 37.806054412145 -122.410674103647 (37.806054412145, -122.410674103647) 3 1 10 308 23
25661 128775 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 34 Maiden Ln 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 1ft   6011432.60647 2115120.86654 37.7883628058523 -122.404256917436 (37.7883628058523, -122.404256917436) 5 1 10 28857 6
25841 128774 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 25 Maiden Ln 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 1ft   6011584.77672 2115124.15017 37.7883803237385 -122.403730661161 (37.7883803237385, -122.403730661161) 5 1 10 28857 6
25922 128482 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 330 Pine St 3 Sidewalk: Curb side : Pot Tree Private 2     3 Width 3ft   6012259.81227 2116468.66713 37.7921097358123 -122.401489663026 (37.7921097358123, -122.401489663026) 4 1 10 28854 6
25937 127703 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1520 Taylor St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6008863.24129 2118118.5693 37.7964498586313 -122.413358615027 (37.7964498586313, -122.413358615027) 3 1 10 308 21
25957 93476 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 113X Leroy Pl 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3 Tree 1 on Leroy. 6008309.35619 2116677.55783 37.7924620830088 -122.415173127645 (37.7924620830088, -122.415173127645) 5 1 10 28858 21
26042 128656 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 99 Broadway 10 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6013029.0227 2118872.45132 37.7987528461303 -122.398996959964 (37.7987528461303, -122.398996959964) 3 1 10 28860 6
26150 128611 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 50 Washington St 4 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   6013816.82419 2118081.68623 37.7966254602636 -122.3962154423 (37.7966254602636, -122.3962154423) 3 1 10 28860 6
26173 127483 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 952 Sutter St 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6007980.9662 2115174.73021 37.7883172264026 -122.416202885554 (37.7883172264026, -122.416202885554) 13 1 10 28858 21
26432 128672 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 100 Washington St 8 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   6013392.30755 2117975.00239 37.796308901584 -122.397676888287 (37.796308901584, -122.397676888287) 3 1 10 28860 6
26588 127872 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1089 Chestnut St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6006645.59841 2120434.4244 37.8026838520455 -122.421196678795 (37.8026838520455, -122.421196678795) 5 1 1 28858 32
26784 128407 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 251 Sutter St 3 Sidewalk: Curb side : Pot Tree Private 2     6 Width 3ft   6011232.13001 2115582.12886 37.7896181182298 -122.404983027342 (37.7896181182298, -122.404983027342) 5 1 10 28857 6
26833 115986 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 499 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   6011754.92826 2118036.38994 37.7963861434716 -122.403346915027 (37.7963861434716, -122.403346915027) 3 1 10 28860 4
26930 112710 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 100 North Point St 14 Sidewalk: Curb side : Cutout Tree Private 2     19 3x3   6009944.98971 2121981.12086 37.8071161463469 -122.40988831469 (37.8071161463469, -122.40988831469) 3 1 10 308 23
27025 128036 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 685 North Point St 6 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6007800.18546 2121634.45508 37.8060438549941 -122.417286302424 (37.8060438549941, -122.417286302424) 5 1 10 308 23
27078 128717 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 533 Jackson St 1 Sidewalk: Curb side : Pot Tree Private 2     5 Width 4ft   6011384.22669 2117985.27597 37.7962250856765 -122.404626027992 (37.7962250856765, -122.404626027992) 3 1 10 28857 4
27198 127743 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1330 Leavenworth St 4 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   6008038.01816 2117067.68966 37.7935180363805 -122.416139610169 (37.7935180363805, -122.416139610169) 5 1 10 28858 21
27230 61903 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1005 Jones St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/21/1985 12:00:00 AM 13   Permit Number 21947 6008617.2267 2116046.34412 37.7907462215147 -122.414063207745 (37.7907462215147, -122.414063207745) 5 1 10 28858 21
27264 128357 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1335 Battery St 6 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6012155.65738 2120650.71533 37.8035868226221 -122.402144190498 (37.8035868226221, -122.402144190498) 3 1 10 28860 6
27274 11089 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1900 Hyde St 1 Sidewalk: Curb side : Cutout Tree DPW 1   09/10/2007 12:00:00 AM 70 3X3   6007306.35542 2118856.39008 37.7983881953143 -122.418798140138 (37.7983881953143, -122.418798140138) 5 1 10 28858 32
27430 127682 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 623 Powell St 3 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 4ft   6010107.38825 2115849.13375 37.7902883127935 -122.40889338122 (37.7902883127935, -122.40889338122) 5 1 10 28857 21
27546 128471 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 111 Front St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6013035.57318 2116816.15959 37.7931071226516 -122.398829900993 (37.7931071226516, -122.398829900993) 4 1 10 28860 6
27788 128189 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 151 Beach St 9 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6009528.34804 2122220.78416 37.8077508429053 -122.411347139176 (37.8077508429053, -122.411347139176) 3 1 10 308 23
27800 100681 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 400 California St 1 Sidewalk: Curb side : Pot Tree Private 2     3     6012316.03692 2116830.75541 37.793107081281 -122.401320580594 (37.793107081281, -122.401320580594) 4 1 10 28854 6
27862 127692 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 751 Powell St 3 Sidewalk: Property side : Yard Tree Private 2     12 Width 5ft   6010024.77623 2116366.99581 37.7917056092738 -122.40921577291 (37.7917056092738, -122.40921577291) 5 1 10 28857 21
27881 107424 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1632 Taylor St 2 Sidewalk: Curb side : Cutout Tree Private 2     16 6x9   6008808.04116 2118494.63119 37.7974793323623 -122.413576231161 (37.7974793323623, -122.413576231161) 3 1 10 308 21
27883 249337 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 851 Post St 3 : Tree Private 2     12 Width 3ft   6008084.28411 2114798.49621 37.787289988396 -122.415818769842 (37.787289988396, -122.415818769842) 13 1 9 28858 36
27898 128493 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 201 Montgomery St 8 Sidewalk: Curb side : Pot Tree Private 2     3 Width 3ft   6011961.6023 2116106.47919 37.791098610068 -122.402495999902 (37.791098610068, -122.402495999902) 4 1 10 28854 6
28065 53260 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 440 Merchant St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/28/1969 12:00:00 AM 5   Permit Number 6150 6012416.7635 2117668.92538 37.7954141157334 -122.401030978214 (37.7954141157334, -122.401030978214) 3 1 10 28860 4
28081 128439 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 465 California St 2 Sidewalk: Curb side : Pot Tree Private 2     4 Width 4ft   6012038.72301 2116739.36453 37.7928406679022 -122.402273680281 (37.7928406679022, -122.402273680281) 4 1 10 28854 6
28086 128045 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 681 North Point St 6 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6008278.49061 2121698.88203 37.8062476530568 -122.415635609416 (37.8062476530568, -122.415635609416) 5 1 10 308 23
28144 127841 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2728 Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6006912.36807 2121678.45588 37.8061146811113 -122.420361869618 (37.8061146811113, -122.420361869618) 5 1 1 28858 32
28503 127474 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 828 Jones St 1 Sidewalk: Curb side : Cutout Tree Private 2     28 Width 4ft   6008755.95902 2115393.20151 37.7889606418706 -122.41353698565 (37.7889606418706, -122.41353698565) 5 1 10 28858 21
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
28768 57196 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 55 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/11/1974 12:00:00 AM 15   Permit Number 14477 6012440.56108 2119841.07989 37.8013796579148 -122.401101337565 (37.8013796579148, -122.401101337565) 3 1 10 28860 6
28875 128742 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 415 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6011959.52444 2118067.18774 37.7964821316861 -122.402641131589 (37.7964821316861, -122.402641131589) 3 1 10 28860 4
28976 128334 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 190 Greenwich St 4 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6012094.33594 2120534.29884 37.8032637483763 -122.402348207117 (37.8032637483763, -122.402348207117) 3 1 10 28860 6
29232 249347 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 825 Post St 7 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6008271.46114 2114824.52265 37.7873719714978 -122.415173017931 (37.7873719714978, -122.415173017931) 13 1 9 28858 36
29276 112698 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 100 North Point St 3 Sidewalk: Curb side : Cutout Tree Private 2     17 3x3   6010162.10827 2122010.9389 37.8072101848662 -122.409139031937 (37.8072101848662, -122.409139031937) 3 1 10 308 23
29329 127835 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1287 Green St 4 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6006899.96767 2118737.41598 37.7980386324459 -122.42019592043 (37.7980386324459, -122.42019592043) 5 1 10 28858 32
29436 128417 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 555 California St 3 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 5ft   6011520.89022 2116664.10295 37.792605098606 -122.40406011698 (37.792605098606, -122.40406011698) 4 1 10 28854 6
29513 67875 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1075 Front St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/09/1993 12:00:00 AM 15   Permit Number 31562 6012616.87453 2119838.22314 37.8013816481112 -122.400491009969 (37.8013816481112, -122.400491009969) 3 1 10 28860 6
29527 128624 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 218 Jackson St 4 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6012748.53011 2118213.31212 37.7969273734664 -122.399921249892 (37.7969273734664, -122.399921249892) 3 1 10 28860 6
29633 84823 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 843 Montgomery St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/18/2007 12:00:00 AM 9   Permit No. 49293 6011667.05773 2118221.94084 37.7968907134816 -122.403664029475 (37.7968907134816, -122.403664029475) 3 1 10 308 4
29729 128158 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 328 Beach St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6008698.81378 2122153.20188 37.8075187188778 -122.414213167929 (37.8075187188778, -122.414213167929) 3 1 10 308 23
29858 127816 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1009 Green St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   6008187.06074 2118913.96163 37.7985958209075 -122.415754700319 (37.7985958209075, -122.415754700319) 5 1 10 28858 21
30112 128282 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 55 Francisco St 14 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 5ft   6011187.65635 2121403.39656 37.8055994226472 -122.405547065062 (37.8055994226472, -122.405547065062) 3 1 10 308 23

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