trees

5,599 rows where qSpecies_id = 38

✎ 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)
5571 127724 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 6 Leroy Pl 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 1ft   6008350.29303 2116463.97857 37.7918779472632 -122.415016360531 (37.7918779472632, -122.415016360531) 5 1 10 28858 21
5605 72081 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 195 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   15     5993024.92764 2114284.47413 37.7850205170043 -122.467883110599 (37.7850205170043, -122.467883110599) 11 6 2 54 11
5735 123023 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 320 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   5994043.99217 2113246.58876 37.7822295582626 -122.464282120352 (37.7822295582626, -122.464282120352) 11 6 2 54 11
5769 127718 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1377 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6008134.11977 2116552.38078 37.7921085280447 -122.415770585055 (37.7921085280447, -122.415770585055) 5 1 10 28858 21
5834 126875 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 401 Walnut St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   5998625 2115075 37.7875128775034 -122.448565673536 (37.7875128775034, -122.448565673536) 13 6 1 54 31
5848 189784 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 230 Texas St 1 : Tree Private 2     20 Width 4ft   6013708.09947 2105987.51004 37.7634115608072 -122.39574381262 (37.7634115608072, -122.39574381262) 14 3 8 28856 29
5855 189614 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1022 Harrison St 5 Sidewalk: Curb side : Yard Tree Private 2     24 Width 0ft   6011103.60933 2110745.72652 37.7763313085817 -122.405087010566 (37.7763313085817, -122.405087010566) 14 2 9 28853 34
5867 176470 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 130 Sweeny St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6009916.73377 2094983.66925 37.7329857989392 -122.408080900424 (37.7329857989392, -122.408080900424) 10 3 7 309 28
5930 128735 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 545 Pacific Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6011426.2676 2118320.12222 37.7971468422023 -122.404504139281 (37.7971468422023, -122.404504139281) 3 1 10 308 4
5946 127771 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1460 Pine St 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6006950.85449 2115730.19168 37.7897844109646 -122.419806340388 (37.7897844109646, -122.419806340388) 13 9 10 28858 21
5961 128358 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1335 Battery St 7 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   6012159.58757 2120622.92627 37.803510739994 -122.402128634953 (37.803510739994, -122.402128634953) 3 1 10 28860 6
6000 73609 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 583 39th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     5983776.7045 2111867.80576 37.7778466722362 -122.499699845252 (37.7778466722362, -122.499699845252) 11 6 2 55 26
6024 128476 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 109 Front St 2 Sidewalk: Curb side : Pot Tree Private 2     2 Width 5ft   6013054.34541 2116659.14888 37.7926770542453 -122.398753923573 (37.7926770542453, -122.398753923573) 4 1 10 28860 6
6026 128070 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 245 North Point St 3 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6009396.36006 2121851.96105 37.8067307436876 -122.41177783889 (37.8067307436876, -122.41177783889) 3 1 10 308 23
6064 128753 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 145 Geary St 5 Sidewalk: Curb side : Pot Tree Private 2     5 Width 4ft   6010888.72367 2114838.04786 37.7875558468704 -122.406118740704 (37.7875558468704, -122.406118740704) 5 1 10 28857 6
6102 55726 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2150 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/05/1973 12:00:00 AM 30 4x4 Permit Number 11752 6003240.02272888 2107147.06325899 37.7660075287211 -122.43203228921 (37.7660075287211, -122.43203228921) 15 5 5 28862 3
6163 225557 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 56 Deming St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   5999325.48062 2105227.47982 37.7605141259519 -122.445433809042 (37.7605141259519, -122.445433809042) 15 5 5 28862 3
6165 128151 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 580 North Point St 9 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007611.87437 2121662.99743 37.806111628806 -122.417940009725 (37.806111628806, -122.417940009725) 5 1 10 308 23
6210 92707 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2600 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/16/2009 12:00:00 AM 13 3x3 Permit Number 52950 6000514.42126 2118236.58998 37.7963016287713 -122.442255722737 (37.7963016287713, -122.442255722737) 13 9 1 57 17
6261 128069 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 245 North Point St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 4ft   6009374.1078 2121849.01591 37.8067214087259 -122.411854639205 (37.8067214087259, -122.411854639205) 3 1 10 308 23
6281 128011 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 590 Bay St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6008173.68388 2121395.11526 37.8054076943845 -122.415976787008 (37.8054076943845, -122.415976787008) 5 1 10 308 23
6294 5744 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1759 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1     80 6x6   6005374.75018 2098167.61874 37.7414728539803 -122.424010079215 (37.7414728539803, -122.424010079215) 2 7 5 28859 7
6442 224868 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 175 Grand View Ave 2 Sidewalk: Property side : Yard Tree Private 2     11 Width 3ft   6000828.74292 2103376.29787 37.7555169332749 -122.440101980424 (37.7555169332749, -122.440101980424) 2 4 5 28862 38
6462 48434 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1190 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/26/2002 12:00:00 AM 10 3x3 Permit Number 45810 6009120.00947 2116723.6961 37.7926342914851 -122.412371495743 (37.7926342914851, -122.412371495743) 3 1 10 28857 21
6504 64373 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 376 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/21/1988 12:00:00 AM 9   Permit Number 25212 6011164.54643 2119369.06968 37.8000123673464 -122.405483677229 (37.8000123673464, -122.405483677229) 3 1 10 308 23
6513 224799 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 159 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 4ft   6004849.19122 2099568.27784 37.7452890578355 -122.425926962559 (37.7452890578355, -122.425926962559) 2 7 5 63 22
6582 122916 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 206 12th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5992152.69759 2114024.49172 37.7842562714811 -122.470881776845 (37.7842562714811, -122.470881776845) 11 6 2 54 11
6661 128698 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 300 Washington St 10 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6012762.04961 2117890.12021 37.7960407192648 -122.399851762841 (37.7960407192648, -122.399851762841) 3 1 10 28860 6
6741 120401 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 173 23rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   5988655.68624 2114206.04007 37.7845518888292 -122.482993367442 (37.7845518888292, -122.482993367442) 11 6 2 55 26
6796 61320 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1477 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/09/1984 12:00:00 AM 16   Permit Number 21223 6011774.39181 2101489.85478 37.7509542327749 -122.402115701805 (37.7509542327749, -122.402115701805) 10 3 8 28856 29
6941 7350 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2239 Fillmore St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6002792.88059 2116041.24067 37.7904033576739 -122.434214763813 (37.7904033576739, -122.434214763813) 13 9 1 29490 27
7059 192064 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 400 15th St 4 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6011310.89762 2107471.79469 37.7673534269378 -122.404139471354 (37.7673534269378, -122.404139471354) 8 2 8 28853 20
7084 119456 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 766 33rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5985728.91492 2110666.6398 37.7746629724789 -122.492858068519 (37.7746629724789, -122.492858068519) 11 6 2 55 26
7161 127048 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3701 Fillmore St 3 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 5ft   6002027.78119 2121185.63165 37.8044850565104 -122.437230452331 (37.8044850565104, -122.437230452331) 13 9 1 57 17
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
7454 218862 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 40 Hugo St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 4ft   5995574.38751 2107076.62885 37.7653765624148 -122.458540896361 (37.7653765624148, -122.458540896361) 15 5 11 56 12
7640 127293 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2753 Fillmore St 4 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6002583.07588 2117538.07089 37.7945013578125 -122.435047772547 (37.7945013578125, -122.435047772547) 13 9 1 29490 27
7735 72939 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1941 Lyon St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     5999440.2574 2115574.76841 37.7889316917948 -122.445781013002 (37.7889316917948, -122.445781013002) 13 6 1 29490 31
7751 127203 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 46 Presidio Ave 2 Sidewalk: Property side : Yard Tree Private 2     10 Width 4ft   5998966.77804 2116409.36285 37.7911962224881 -122.447479279259 (37.7911962224881, -122.447479279259) 13 6 1 29490 31
7804 225515 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1930 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2     21 5x7   6004641.55449 2107219.04447 37.7662845296296 -122.427189800463 (37.7662845296296, -122.427189800463) 8 4 5 28862 3
7810 192162 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1500 Mission St 5 Sidewalk: Curb side : Cutout Tree DPW 1     29 Width 5ft Permit Number 779453 6007414.0762 2109937.75552 37.7739058675964 -122.417792878858 (37.7739058675964, -122.417792878858) 8 2 9 28853 19
7839 126779 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2055 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6003068.79068 2119239.76733 37.7992013434186 -122.43348880679 (37.7992013434186, -122.43348880679) 13 9 1 57 17
7841 224759 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 231 Mullen Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6010166.15347 2099991.74226 37.7467508491909 -122.407571558604 (37.7467508491909, -122.407571558604) 2 7 7 28859 2
7954 127208 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2332 Baker St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5999786.9812 2116918.58029 37.7926412369447 -122.444678026877 (37.7926412369447, -122.444678026877) 13 6 1 29490 27
7963 56974 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 143 02nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/27/1974 12:00:00 AM 6 3x3 Permit Number 14227 5995185.81125 2114601.91547 37.7860166684359 -122.46043020011 (37.7860166684359, -122.46043020011) 11 6 1 54 11
8017 249355 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 625 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6008323.0201 2114666.64303 37.7869413697974 -122.414983455249 (37.7869413697974, -122.414983455249) 13 1 9 28858 36
8051 127739 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1301 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6008381.5529 2116915.61445 37.7931197850904 -122.41494018075 (37.7931197850904, -122.41494018075) 5 1 10 28858 21
8121 60537 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 543 34th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/09/1982 12:00:00 AM 11   Permit Number 20147 5985322.70304 2112176.441 37.7787846915609 -122.494374531621 (37.7787846915609, -122.494374531621) 11 6 2 55 26
8181 192121 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 807 Mission St 3 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     27 Width 4ft   6010922.27002 2113199.63335 37.783059024392 -122.405887217429 (37.783059024392, -122.405887217429) 12 2 9 28853 34
8227 120322 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 650 23rd Ave 2 Sidewalk: Property side : Yard Tree Private 2     9 Width 3ft   5988821.62524 2110892.0885 37.7754623614562 -122.482176410805 (37.7754623614562, -122.482176410805) 11 6 2 55 26
8253 11057 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1630 Hyde St 1 Sidewalk: Curb side : Cutout Tree DPW 1     70 3X3   6007426.31744 2117960.00612 37.7959337026338 -122.418319444503 (37.7959337026338, -122.418319444503) 5 1 10 28858 32
8284 115669 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2600X Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/12/2016 12:00:00 AM 3 3x3 Permit Number 777079 6001202.18162 2117312.37284 37.7938031439473 -122.439809637804 (37.7938031439473, -122.439809637804) 13 9 1 57 27
8311 224981 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 20 Prosper St 3 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6003320.11434 2106449.16062 37.7640957973979 -122.431705435862 (37.7640957973979, -122.431705435862) 15 4 5 28862 3
8337 126910 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 75 Spruce St 5 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   5997010.72159 2116048.10236 37.7900923226531 -122.454221034373 (37.7900923226531, -122.454221034373) 11 6 1 54 31
8393 127867 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2044 Hyde St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6007226.91182 2119423.24121 37.7999401526838 -122.419113268885 (37.7999401526838, -122.419113268885) 5 1 1 28858 32
8438 189632 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 45 11th St 9 : Tree Private 2     7 Width 3ft   6007298.00895 2110457.3775 37.7753260931545 -122.4182312237 (37.7753260931545, -122.4182312237) 8 2 9 28853 34
8460 12704 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1424 Lake St 1 Sidewalk: Curb side : Cutout Tree Private 2     30 3x3   5991031.65731 2114791.36704 37.7862970008275 -122.47481613459 (37.7862970008275, -122.47481613459) 11 6 1 54 33
8519 126819 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1861 Jefferson St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6000341.48277 2121286.03183 37.8046647257642 -122.443073236154 (37.8046647257642, -122.443073236154) 13 9 1 57 17
8608 218881 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1374 07th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 2ft   5993982.19031 2106154.46944 37.7627529198293 -122.463980949379 (37.7627529198293, -122.463980949379) 1 5 11 56 12
8631 128082 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 245 North Point St 15 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6009683.35171 2121893.27188 37.8068602685411 -122.41078756392 (37.8068602685411, -122.41078756392) 3 1 10 308 23
8684 189714 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 550 Wisconsin St 3 Sidewalk: Curb side : Yard Tree Private 2     14 Width 4ft   6012647.13321 2104908.73509 37.7603904062104 -122.39933764023 (37.7603904062104, -122.39933764023) 10 3 8 28856 29
8779 75939 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2100 Pacific Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6004008.54398 2117326.08278 37.7940001296632 -122.430100346576 (37.7940001296632, -122.430100346576) 13 9 1 29490 27
8793 128179 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 211 Beach St 13 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6009178.96771 2122171.51863 37.8075959706319 -122.412552773896 (37.8075959706319, -122.412552773896) 3 1 10 308 23
8837 251690 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 98 11th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 779453 6007396 2110315 37.7749406737789 -122.417882154347 (37.7749406737789, -122.417882154347) 8 2 9 28853 19
8948 128780 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 116 Maiden Ln 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6011134.63349 2115083.13634 37.7882425530045 -122.405285203167 (37.7882425530045, -122.405285203167) 5 1 10 28857 6
8971 224736 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3751 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 6x9   6005316.30441 2104275.01271 37.7582390497985 -122.424646518647 (37.7582390497985, -122.424646518647) 2 4 5 28859 19
8976 128727 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 150 Columbus Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6011307.13002 2118182.76086 37.7967630223487 -122.404906710889 (37.7967630223487, -122.404906710889) 3 1 10 308 4
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
9057 64002 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1022 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/06/1987 12:00:00 AM 19   Permit Number 24749 6007961.58195 2119970.38672 37.8014838218701 -122.416609806295 (37.8014838218701, -122.416609806295) 5 1 10 308 32
9065 128399 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 316 Sutter St 7 Sidewalk: Curb side : Pot Tree Private 2     18 Width 2ft   6010737.08277 2115568.6338 37.7895533787223 -122.406694896775 (37.7895533787223, -122.406694896775) 5 1 10 28857 6
9090 127065 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3252 Pierce St 4 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 4ft   6001375.07484 2119548.95116 37.7999540409146 -122.43937180647 (37.7999540409146, -122.43937180647) 13 9 1 57 17
9234 224994 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3787 17th St 6 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6003747.34192 2105939.8631 37.76272159645 -122.430191444288 (37.76272159645, -122.430191444288) 8 4 5 28862 3
9293 61314 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1367 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/09/1984 12:00:00 AM 14   Permit Number 21216 6011746.30755 2101998.58659 37.752349531804 -122.40224858471 (37.752349531804, -122.40224858471) 10 3 8 28856 29
9310 5671 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1421 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1     25 3X3   6005267.30914 2100058.51794 37.7466587657846 -122.424516044105 (37.7466587657846, -122.424516044105) 2 7 5 28859 22
9327 190177 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 20 Spear St 5 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6014053.70792 2116907.88857 37.7934156656489 -122.395313496947 (37.7934156656489, -122.395313496947) 12 2 9 28855 6
9353 218922 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1225 02nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   5995446.34406 2107212.89211 37.7657433464104 -122.45899363306 (37.7657433464104, -122.45899363306) 15 5 11 56 12
9480 128144 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 580 North Point St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007778.14218 2121686.09097 37.8061843938561 -122.417366248573 (37.8061843938561, -122.417366248573) 5 1 10 308 23
9530 225492 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 25 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6001938.93672 2107786.0573 37.7676882004846 -122.436578216329 (37.7676882004846, -122.436578216329) 15 5 5 29492 3
9566 224977 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 51 Prosper St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 2x2   6003350.18904 2106235.72692 37.7635114646938 -122.431586177673 (37.7635114646938, -122.431586177673) 15 4 5 28862 3
9582 127979 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 160 Bay St 6 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   6009886.24296 2121622.25615 37.8061275009418 -122.410066269842 (37.8061275009418, -122.410066269842) 3 1 10 308 23
9733 5598 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1114 Dolores St 1 Sidewalk: Curb side : Cutout Tree Private 2     60 3X3   6005085.74952 2101846.15416 37.7515569476132 -122.425271044719 (37.7515569476132, -122.425271044719) 2 4 5 28862 22
9781 113450 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 21X Leroy Pl 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6008324.74095 2116562.67984 37.7921475208351 -122.415111760598 (37.7921475208351, -122.415111760598) 5 1 10 28858 21
9788 128384 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 109 Trenton St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6010084.71998 2117858.53397 37.7958043693257 -122.40911365939 (37.7958043693257, -122.40911365939) 3 1 10 308 4
9901 225315 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 107 Germania St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6003691.1062 2108820.63843 37.7706283225572 -122.430591513988 (37.7706283225572, -122.430591513988) 15 9 11 29492 10
9932 59703 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3151 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/24/2020 12:00:00 AM 3   Permit Number 19133 5999623.74954 2116015.3785 37.7901519665752 -122.445177847597 (37.7901519665752, -122.445177847597) 13 6 1 29490 27
10035 55896 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3305 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/08/1973 12:00:00 AM 22   Permit Number 11953 5999805.23357 2119943.78324 37.8009486821054 -122.444832429667 (37.8009486821054, -122.444832429667) 13 9 1 57 17
10063 25510 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1845 Gough St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   6005220.00534 2116049.4982 37.7905634882709 -122.425817655354 (37.7905634882709, -122.425817655354) 13 9 1 28858 27
10171 128630 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 400 Pacific Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6012042.35717 2118440.81507 37.7975126468404 -122.402380794936 (37.7975126468404, -122.402380794936) 3 1 10 308 23
10177 225604 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 260 Laussat St 2 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   6003453.71894 2109156.79704 37.7715378807118 -122.431436640207 (37.7715378807118, -122.431436640207) 15 9 11 29492 10
10190 128389 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 295 Bush St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6012038.5922 2116040.80306 37.79092257676 -122.402224996381 (37.79092257676, -122.402224996381) 4 1 10 28854 6
10227 189669 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2475 03rd St 1 Sidewalk: Curb side : Cutout Tree DPW 1     17 Width 5ft   6015848.0451 2104085.46802 37.7583077705949 -122.388209616279 (37.7583077705949, -122.388209616279) 10 3 8 28856 29
10355 128113 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2300 Stockton St 4 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6009769.6912 2122058.41551 37.8073185522658 -122.410500436454 (37.8073185522658, -122.410500436454) 3 1 10 308 23
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
10414 41425 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1568 Indiana St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/17/2000 12:00:00 AM 14   Permit Number 42032 6015102.0577 2101304.61846 37.7506307870794 -122.390595272152 (37.7506307870794, -122.390595272152) 10 3 8 28856 1
10437 190310 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 235 01st St 4 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6013968.89139 2115020.62738 37.7882289687394 -122.395474691421 (37.7882289687394, -122.395474691421) 6 2 9 28855 6
10515 7366 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2360 Fillmore St 3 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6002774.54957 2116438.38146 37.7914927640347 -122.434306592692 (37.7914927640347, -122.434306592692) 13 9 1 29490 27
10541 127381 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2199x Gough St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6005034 2117073 37.7933632530766 -122.42653413355 (37.7933632530766, -122.42653413355) 13 9 1 28858 27
10570 224802 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1450 Sanchez St 1 Sidewalk: Curb side : Pot Tree Private 2     11 Width 2ft   6003910.21401 2099792.41233 37.7458513688561 -122.42918976771 (37.7458513688561, -122.42918976771) 2 7 5 63 22
10654 128380 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 15 Waverly Pl 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6010746 2116993 37.7934648453026 -122.406764467868 (37.7934648453026, -122.406764467868) 3 1 10 28857 4

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