trees

5,599 rows where qSpecies_id = 38 sorted by Supervisor Districts descending

✎ 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)
648 189633 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 45 11th St 10 : Tree Private 2     10 Width 3ft   6007281.55408 2110475.16176 37.775373998252 -122.418289406239 (37.775373998252, -122.418289406239) 8 2 9 28853 34
649 189627 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 45 11th St 4 : Tree Private 2     16 Width 3ft   6007528.52851 2110215.72509 37.7746755460784 -122.417416671761 (37.7746755460784, -122.417416671761) 8 2 9 28853 34
992 192119 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 807 Mission St 1 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     22 Width 4ft   6010836.94593 2113119.25584 37.782833554469 -122.406176740686 (37.782833554469, -122.406176740686) 12 2 9 28853 34
1042 189625 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 45 11th St 2 : Tree Private 2     18 Width 3ft   6007555.58457 2110185.16197 37.7745931492825 -122.417320912844 (37.7745931492825, -122.417320912844) 8 2 9 28853 34
1068 189619 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1022 Harrison St 10 Sidewalk: Curb side : Yard Tree Private 2     25 Width 0ft   6010873.70675 2110523.15136 37.7757073139658 -122.405866629254 (37.7757073139658, -122.405866629254) 14 2 9 28853 34
1163 127620 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 888 O'Farrell St 9 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6007042.74082 2114007.27438 37.7850588791954 -122.419366145639 (37.7850588791954, -122.419366145639) 13 9 9 28858 36
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
2628 190261 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 133 Stevenson St 5 Sidewalk: Curb side : Pot Tree Private 2     5 Width 2ft   6011936.19797 2114760.72734 37.7874020753891 -122.402489228003 (37.7874020753891, -122.402489228003) 12 2 9 28855 6
2882 100182 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 230 Ritch St 3 Sidewalk: Curb side : Cutout Tree Private 2     20     6013808.29227 2112170.33848 37.7803937971776 -122.39583053966 (37.7803937971776, -122.39583053966) 6 2 9 28856 34
2900 34181 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 111 Gilbert St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/05/1997 12:00:00 AM 12   Permit Number 38007 6011922.99653 2109561.23009 37.7731247245485 -122.402169209655 (37.7731247245485, -122.402169209655) 14 2 9 28853 34
2982 100269 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1 Federal St 4 Sidewalk: Curb side : Cutout Tree Private 2     12 1x1   6015149.19988 2113471.58342 37.7840412261692 -122.391282662663 (37.7840412261692, -122.391282662663) 6 2 9 28856 6
3935 190231 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 536 Mission St 2 Sidewalk: Curb side : Pot Tree Private 2     6 Width 4ft   6013108.00219 2115380.57428 37.7891693781208 -122.398478510672 (37.7891693781208, -122.398478510672) 12 2 9 28855 6
4189 192124 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 807 Mission St 6 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     25 Width 4ft   6011038.85416 2113311.43716 37.783372530757 -122.405491758548 (37.783372530757, -122.405491758548) 12 2 9 28853 34
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
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
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
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
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
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
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
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
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
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
10802 190210 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 55 Main St 7 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6013925.01532 2116617.87783 37.7926122059272 -122.395738456263 (37.7926122059272, -122.395738456263) 12 2 9 28855 6
10869 114473 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 145 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     15     6007374.36978 2108955.06944 37.7712054103423 -122.417860558238 (37.7712054103423, -122.417860558238) 8 2 9 28853 19
10886 192122 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 807 Mission St 4 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     23 Width 4ft   6010961.41826 2113239.46389 37.7831705790105 -122.405754586311 (37.7831705790105, -122.405754586311) 12 2 9 28853 34
11011 249339 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 839 Post St 1 : Tree Private 2     13 Width 3ft   6008120.77004 2114802.70738 37.7873036023197 -122.415692834155 (37.7873036023197, -122.415692834155) 13 1 9 28858 36
11110 192149 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 63 10th St 1 Sidewalk: Curb side : Cutout Tree Private 2     24 Width 5ft   6007788.06434 2110652.2421 37.7758887171372 -122.416549810724 (37.7758887171372, -122.416549810724) 8 2 9 28853 34
11305 189630 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 45 11th St 7 : Tree Private 2     14 Width 3ft   6007441.71426 2110305.43642 37.7749169870715 -122.417723340559 (37.7749169870715, -122.417723340559) 8 2 9 28853 34
11597 189629 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 45 11th St 6 : Tree Private 2     16 Width 3ft   6007461.61467 2110284.7901 37.774861417042 -122.417653036967 (37.774861417042, -122.417653036967) 8 2 9 28853 34
11615 189628 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 45 11th St 5 : Tree Private 2     11 Width 3ft   6007505.86156 2110238.1728 37.7747359067747 -122.417496672745 (37.7747359067747, -122.417496672745) 8 2 9 28853 34
11969 225360 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 127 Otis St 3 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 3ft   6006951.60276 2109409.2477 37.7724286744738 -122.41935515412 (37.7724286744738, -122.41935515412) 8 2 9 28853 19
12034 189635 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 45 11th St 12 : Tree Private 2     13 Width 3ft   6007252.77598 2110507.15575 37.7754602261381 -122.418391225675 (37.7754602261381, -122.418391225675) 8 2 9 28853 34
12134 192099 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 999 Brannan St 9 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 3ft   6010725.77317 2108634.41691 37.7705130105866 -122.406245268117 (37.7705130105866, -122.406245268117) 14 2 9 28853 34
12427 189631 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 45 11th St 8 : Tree Private 2     9 Width 3ft   6007308.18753 2110441.11785 37.7752820209699 -122.418194860528 (37.7752820209699, -122.418194860528) 8 2 9 28853 34
12460 106116 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 615 Leavenworth St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6008342 2114560 37.7866496204263 -122.414910238271 (37.7866496204263, -122.414910238271) 13 1 9 28858 36
12465 192125 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 807 Mission St 7 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     23 Width 4ft   6011096.71819 2113372.25093 37.7835427463303 -122.405295854729 (37.7835427463303, -122.405295854729) 12 2 9 28853 34
12810 189626 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 45 11th St 3 : Tree Private 2     14 Width 3ft   6007544.58338 2110195.50679 37.7746209347449 -122.417359701486 (37.7746209347449, -122.417359701486) 8 2 9 28853 34
13193 47563 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 920 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/14/2002 12:00:00 AM 13   Permit Number 45425 6011893.37334 2111591.15852 37.778696788166 -122.402414441286 (37.778696788166, -122.402414441286) 14 2 9 28856 34
13257 190280 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 165 02nd St 1 Sidewalk: Curb side : Pot Tree Private 2     4 Width 3ft   6013037.87602 2114674.12201 37.7872257183411 -122.398671543862 (37.7872257183411, -122.398671543862) 12 2 9 28855 6
13688 189611 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1001x Harrison St 4 Sidewalk: Curb side : Cutout Tree Private 2     26 Width 8ft   6011323 2110932 37.776855034552 -122.404341187165 (37.776855034552, -122.404341187165) 14 2 9 28853 34
14908 127573 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 515 Ellis St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   6008275.3046 2113776.68195 37.7844950708296 -122.415085522888 (37.7844950708296, -122.415085522888) 7 10 9 28858 36
15146 92502 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 645 05th St 3 : Tree Private 2     23     6013059.80814 2110709.87576 37.7763420329883 -122.398317413322 (37.7763420329883, -122.398317413322) 6 2 9 28856 34
15330 192018 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 477 Brannan St 2 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   6013668.60468 2111446.81153 37.7783993850599 -122.396263063192 (37.7783993850599, -122.396263063192) 6 2 9 28856 34
15602 192120 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 807 Mission St 2 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     17 Width 4ft   6010853.09093 2113135.89795 37.7828801528353 -122.406122058309 (37.7828801528353, -122.406122058309) 12 2 9 28853 34
16350 118320 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 161 Gilbert St 2 Sidewalk: Curb side : Cutout Tree Private 2     22 3x3   6011971.18574 2109505.20587 37.7729735844824 -122.401998576778 (37.7729735844824, -122.401998576778) 14 2 9 28853 34
17091 189634 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 45 11th St 11 : Tree Private 2     7 Width 3ft   6007263.01198 2110493.68646 37.7754238188976 -122.418354861603 (37.7754238188976, -122.418354861603) 8 2 9 28853 34
17179 30661 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 80x Lafayette St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/30/1995 12:00:00 AM 8 3x3 Permit Number 34594 6007679 2109478 37.7726583931046 -122.416843882018 (37.7726583931046, -122.416843882018) 8 2 9 28853 19
18035 189589 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 15 Stillman St 4 : Tree Private 2     15 Width 3ft   6014277.53935 2113227.76018 37.7833233297614 -122.394281237993 (37.7833233297614, -122.394281237993) 6 2 9 28856 6
18596 190206 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 55 Main St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6013962.81432 2116573.15584 37.792491512422 -122.395604534619 (37.792491512422, -122.395604534619) 12 2 9 28855 6
18602 190213 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 55 Main St 10 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6013892.82186 2116649.49416 37.7926972260507 -122.39585206404 (37.7926972260507, -122.39585206404) 12 2 9 28855 6
19142 189624 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 45 11th St 1 : Tree Private 2     18 Width 3ft   6007595.48584 2110148.75293 37.7744954235495 -122.417180305629 (37.7744954235495, -122.417180305629) 8 2 9 28853 34
19192 173595 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 75 Howard St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 779216 6015060 2116254 37.7916761533754 -122.391785881413 (37.7916761533754, -122.391785881413) 6 2 9 28855 6
19719 192102 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 407 Bryant St 3 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6014448.13744 2113072.01986 37.7829051836732 -122.39368012753 (37.7829051836732, -122.39368012753) 6 2 9 28856 6
19839 190272 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 215 01st St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6013723.35193 2115275.54987 37.7889152665749 -122.396342097427 (37.7889152665749, -122.396342097427) 12 2 9 28855 6
20545 192143 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 654 Natoma St 1 Sidewalk: Curb side : Cutout Tree Private 2     24 Width 2ft   6009336.10614 2111189.43583 37.7774506632664 -122.411232670746 (37.7774506632664, -122.411232670746) 8 2 9 28853 34
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
20910 127578 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 560 Ellis St 5 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 4ft   6008119.17375 2113811.16397 37.7845809749657 -122.415628126146 (37.7845809749657, -122.415628126146) 7 10 9 28858 36
21212 190172 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 91 Spear St 5 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   6014300.68302 2116737.73981 37.7929622094935 -122.39444701903 (37.7929622094935, -122.39444701903) 12 2 9 28855 6
21216 15268 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1535 Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 3X3   6007464.35841 2109890.19138 37.7737780973065 -122.417615572103 (37.7737780973065, -122.417615572103) 8 2 9 28853 19
21719 190328 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 103 Howard St 1 Sidewalk: Curb side : Pot Tree Private 2     4 Width 3ft   6014652.96886 2115892.30233 37.7906604118109 -122.393168897143 (37.7906604118109, -122.393168897143) 6 2 9 28855 6
22079 192105 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 367 Tehama St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6011383.10975 2112495.76638 37.7811521324975 -122.404243335871 (37.7811521324975, -122.404243335871) 6 2 9 28853 34
22084 251694 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 98 11th St 5 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
22097 190207 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 55 Main St 4 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6013953.44807 2116583.08962 37.7925182672629 -122.395637638685 (37.7925182672629, -122.395637638685) 12 2 9 28855 6
22197 190326 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 657 Howard St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6012802.6319 2114123.85519 37.7857017047117 -122.399446797256 (37.7857017047117, -122.399446797256) 6 2 9 28853 6
22347 189612 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1022 Harrison St 3 Sidewalk: Curb side : Yard Tree Private 2     27 Width 0ft   6011181.84316 2110817.05383 37.7765315300309 -122.404821399415 (37.7765315300309, -122.404821399415) 14 2 9 28853 34
22354 38759 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 325 05th St 1 Sidewalk: Curb side : Cutout Tree Private 2     36   Permit Number 40631 6011796.14841 2112034.18458 37.7799078071241 -122.402781947454 (37.7799078071241, -122.402781947454) 6 2 9 28856 34
22891 192145 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 50 08th St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6008547.63176 2111392.15531 37.777963031309 -122.413974617358 (37.777963031309, -122.413974617358) 8 2 9 28853 34
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
24341 190188 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 20 Spear St 16 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6014167.07042 2116786.79243 37.7930894680536 -122.394912766214 (37.7930894680536, -122.394912766214) 12 2 9 28855 6
24958 99241 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 560X Ellis St 2 Sidewalk: Curb side : Cutout Tree Rec/Park 5     10 4x4   6008235.1228 2113825.75072 37.7846275436788 -122.415228013286 (37.7846275436788, -122.415228013286) 7 10 9 28858 36
25344 103031 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 300X Fremont St 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 769938 6014508.3 2114897.4 37.787920602156 -122.393599785715 (37.787920602156, -122.393599785715) 6 2 9 28855 6
25727 190321 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 95 Hawthorne St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 2ft   6013226.39617 2113799.41871 37.7848344875705 -122.397957916523 (37.7848344875705, -122.397957916523) 6 2 9 28855 6
25940 192137 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 259 07th St 4 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6010151.65462 2111130.5114 37.7773345751599 -122.408407249108 (37.7773345751599, -122.408407249108) 14 2 9 28853 34
26206 190356 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 20 Federal St 5 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6014957.44747 2113321.82053 37.7836193676832 -122.391935585771 (37.7836193676832, -122.391935585771) 6 2 9 28856 6
26387 192038 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 650 06th St 4 Sidewalk: Property side : Yard Tree Private 2     29 Width 4ft   6012638.65405 2109775.29171 37.7737524090692 -122.399708675313 (37.7737524090692, -122.399708675313) 14 2 9 28853 34
26393 69442 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 601 04th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/06/2016 12:00:00 AM 3   Permit Number 778712 6013823.57483 2111230.54106 37.777814177306 -122.395711802165 (37.777814177306, -122.395711802165) 6 2 9 28856 34
26533 190101 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 333 Bryant St 7 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6014861.30097 2113474.72673 37.7840338750996 -122.392278916361 (37.7840338750996, -122.392278916361) 6 2 9 28856 6
26730 127602 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 7 Ada Ct 10 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6008099.06699 2114176.10404 37.7855818817383 -122.415723537934 (37.7855818817383, -122.415723537934) 13 10 9 28858 36
27180 190221 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 55 Main St 18 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6013811.25503 2116734.0786 37.792924937074 -122.396140221195 (37.792924937074, -122.396140221195) 12 2 9 28855 6
27203 127584 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 656 O'Farrell St 3 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6008144.38388 2114161.17727 37.7855434438125 -122.415565697016 (37.7855434438125, -122.415565697016) 13 10 9 28858 36
27280 192042 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 125 Gilbert St 2 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   6011943.2024 2109541.7486 37.7730723606341 -122.402097944671 (37.7730723606341, -122.402097944671) 14 2 9 28853 34
27303 100273 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1 Federal St 8 Sidewalk: Curb side : Cutout Tree Private 2     12 1x1   6015216.1617 2113535.8467 37.7842213945326 -122.391055490318 (37.7842213945326, -122.391055490318) 6 2 9 28856 6
27685 66675 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1000 Brannan St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/25/1991 12:00:00 AM 10 3x3 Permit Number 29899 6010436.29506 2108454.16337 37.7700018791163 -122.407233871257 (37.7700018791163, -122.407233871257) 8 2 9 28853 34
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
27958 189608 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 55 Sherman St 21 : Tree Private 2     27 Width 10ft   6010698.53691 2111009.64615 37.7770333175687 -122.406506877295 (37.7770333175687, -122.406506877295) 14 2 9 28853 34
28010 192133 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 56 Moss St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6010257.00188 2111270.13625 37.7777238512219 -122.408052666214 (37.7777238512219, -122.408052666214) 14 2 9 28853 34
28044 190317 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 236 01st St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6013891.36862 2114999.65853 37.7881670809807 -122.395741439334 (37.7881670809807, -122.395741439334) 6 2 9 28855 6
28208 102737 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 665 Minna St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   6009147.89785 2111222.04181 37.7775296345182 -122.411886052493 (37.7775296345182, -122.411886052493) 8 2 9 28853 34
28732 190212 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 55 Main St 9 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6013901.3012 2116638.71234 37.7926680934122 -122.395821969133 (37.7926680934122, -122.395821969133) 12 2 9 28855 6
29073 190164 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 70 Steuart St 12 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6014473.22219 2116984.10438 37.7936482591167 -122.393867272881 (37.7936482591167, -122.393867272881) 12 2 9 28855 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
29466 190286 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 200 Steuart St 3 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft Permit Number 779216 6015153.32574 2116277.33628 37.791745409684 -122.391464604522 (37.791745409684, -122.391464604522) 6 2 9 28855 6
29575 190268 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 192 Fremont St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 5ft   6013923.67657 2115489.78975 37.7895146647263 -122.395664013084 (37.7895146647263, -122.395664013084) 12 2 9 28855 6
29804 190305 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 250 Fremont St 6 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   6014179.48017 2115219.92824 37.7887879135751 -122.394760046963 (37.7887879135751, -122.394760046963) 6 2 9 28855 6
30051 190184 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 20 Spear St 12 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6014124.78467 2116830.09673 37.7932060201865 -122.395062113026 (37.7932060201865, -122.395062113026) 12 2 9 28855 6
30413 190260 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 133 Stevenson St 4 Sidewalk: Curb side : Pot Tree Private 2     3 Width 2ft   6011906.25914 2114729.61472 37.7873149760428 -122.402590622073 (37.7873149760428, -122.402590622073) 12 2 9 28855 6
31115 100861 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 665 03rd St 4 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6014522.73449 2111811.16047 37.7794472948859 -122.393333788721 (37.7794472948859, -122.393333788721) 6 2 9 28856 6
31179 189599 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 420 Bryant St 1 : Tree Private 2     16 Width 3ft   6014295.66507 2113017.59337 37.7827472672103 -122.394203810878 (37.7827472672103, -122.394203810878) 6 2 9 28856 6
31629 189591 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 480 02nd St 3 : Tree Private 2     13 Width 3ft   6014351.962 2113206.27271 37.7832684666162 -122.394022258432 (37.7832684666162, -122.394022258432) 6 2 9 28856 6

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