3,267 rows where qSpecies_id = 67 sorted by Supervisor 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)
439 8729 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 3200 Geary Blvd 9 Median : Cutout Tree DPW 1     6 M6   5997259.3218258 2113018.202003 37.7817872731337 -122.453142084637 (37.7817872731337, -122.453142084637) 15 6 1 54 31
1094 124411 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 3906 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   5996074.1747 2115241.80305 37.7878246921221 -122.457403032995 (37.7878246921221, -122.457403032995) 11 6 1 54 31
1434 125812 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2211 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6000306.85222 2116323.62174 37.7910372888869 -122.442836516603 (37.7910372888869, -122.442836516603) 13 6 1 29490 27
1799 125860 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2130 Leavenworth St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6007669.37183 2119725.10958 37.8007939141569 -122.417603593144 (37.8007939141569, -122.417603593144) 5 1 1 308 32
2579 125775 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 3464 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   5998240.44426 2115543.88697 37.7887783214189 -122.449929958814 (37.7887783214189, -122.449929958814) 13 6 1 54 31
3051 8716 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 3140 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   5997420.69043 2113059.93694 37.7819111134077 -122.452586840538 (37.7819111134077, -122.452586840538) 15 6 1 54 31
5075 125815 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2081 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6003051.46393 2118195.99672 37.7963344369473 -122.433474132552 (37.7963344369473, -122.433474132552) 13 9 1 57 17
5346 125748 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1830 Green St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6004242.00992 2118405.50242 37.7969771599227 -122.429369541272 (37.7969771599227, -122.429369541272) 13 9 1 57 17
7365 125750 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2870 Filbert St 3 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   5999187.17827 2118395.44877 37.7966620797435 -122.446859678745 (37.7966620797435, -122.446859678745) 13 9 1 57 17
8871 72911 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1970 Scott St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     6001491.2891 2115220.1537 37.7880749043224 -122.438659315373 (37.7880749043224, -122.438659315373) 13 6 1 29490 27
9270 97907 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2000 Chestnut St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/18/1994 12:00:00 AM 8   Permit Number 33440 6002166.03814 2119855.12291 37.8008396887472 -122.436656706436 (37.8008396887472, -122.436656706436) 13 9 1 57 17
10174 73299 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1970 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     6001495.5714 2115163.912 37.7879207227072 -122.438640467915 (37.7879207227072, -122.438640467915) 13 6 1 29490 27
10804 125788 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2812 Lyon St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 6ft   5999154.81918 2118474.67758 37.7968777722368 -122.446977352345 (37.7968777722368, -122.446977352345) 13 9 1 57 17
11008 125832 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1700 Vallejo St 5 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   6005294.88878 2118203.51089 37.7964820948146 -122.425711940964 (37.7964820948146, -122.425711940964) 13 9 1 28858 17
11399 73153 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1970 Scott St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     6001494.4295 2115195.887 37.7880084528635 -122.438646710686 (37.7880084528635, -122.438646710686) 13 6 1 29490 27
13380 55308 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1595 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/06/1972 12:00:00 AM 10   Permit Number 11237 6005282.80537 2119544.50402 37.8001634372533 -122.425849253052 (37.8001634372533, -122.425849253052) 13 9 1 57 17
14118 125818 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2081 Green St 4 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   6003105.57534 2118201.45062 37.7963524818244 -122.433287285795 (37.7963524818244, -122.433287285795) 13 9 1 57 17
15023 125822 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2301 Sacramento St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6003751.95692 2115935.88569 37.7901684673368 -122.430888902704 (37.7901684673368, -122.430888902704) 13 9 1 29490 27
16774 8683 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2900 Geary Blvd 10 Median : Cutout Tree DPW 1     6 M6   5998150.0688375 2113145.5858248 37.7821880464461 -122.450069715057 (37.7821880464461, -122.450069715057) 15 6 1 54 31
16874 55307 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2770 Franklin St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/30/2012 12:00:00 AM 2   Permit Number 769514 6005272.5834 2119510.27332 37.8000688708465 -122.42588218711 (37.8000688708465, -122.42588218711) 13 9 1 57 17
18204 125749 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2672 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6000224.25426 2118193.8188 37.7961676486817 -122.443256684343 (37.7961676486817, -122.443256684343) 13 9 1 57 17
18867 53701 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2656 Lyon St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/18/1970 12:00:00 AM 12   Permit Number 6647 5999210.43552 2117936.02801 37.7954019613927 -122.446746130351 (37.7954019613927, -122.446746130351) 13 9 1 57 17
19656 125824 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2210 Clay St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6004068.4927 2116354.72552 37.7913364249795 -122.429823600886 (37.7913364249795, -122.429823600886) 13 9 1 29490 27
19762 123002 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 22 07th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5993654.52362 2115347.42219 37.7879754176374 -122.465782182912 (37.7879754176374, -122.465782182912) 11 6 1 54 11
20326 125762 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2399 Greenwich St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6001485.39053 2119019.34574 37.7985061611824 -122.438952098255 (37.7985061611824, -122.438952098255) 13 9 1 57 17
20497 2478 Permitted Site 7 Callistemon citrinus :: Lemon Bottlebrush 67 2303X Sacramento St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 3X3   6003659.52132 2115878.15996 37.7900047293604 -122.431204600475 (37.7900047293604, -122.431204600475) 13 9 1 29490 27
21122 125778 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 20 Heather Ave 1 Sidewalk: Property side : Yard Tree Private 2     11 Width 3ft   5997378.69619 2114327.82413 37.7853899906986 -122.452823661499 (37.7853899906986, -122.452823661499) 15 6 1 54 31
22003 125776 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 25 Heather Ave 1 Sidewalk: Property side : Yard Tree Private 2     10 Width 4ft   5997332.30363 2114303.61712 37.7853208661167 -122.452982417028 (37.7853208661167, -122.452982417028) 15 6 1 54 31
22729 125756 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2495 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6001066.19876 2118613.86954 37.7973689711697 -122.440373533438 (37.7973689711697, -122.440373533438) 13 9 1 57 17
23198 21529 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1300 Sutter St 5 Sidewalk: Curb side : Cutout Tree DPW 1     6 4X4   6006199.49469 2114932.42153 37.7875515759816 -122.422349271528 (37.7875515759816, -122.422349271528) 13 9 1 28858 41
23457 8744 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 3300 Geary Blvd 9 Median : Cutout Tree DPW 1     6 M6   5996964.8998051 2112982.2523578 37.7816716864396 -122.454158044121 (37.7816716864396, -122.454158044121) 11 6 1 54 31
24265 143366 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1745 UNION ST 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6004644.9873 2118760.3647 37.7979743272134 -122.428000442989 (37.7979743272134, -122.428000442989) 13 9 1 57 17
25501 8742 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 3300 Geary Blvd 7 Median : Cutout Tree DPW 1     6 M6   5996964.8998051 2112982.2523578 37.7816716864396 -122.454158044121 (37.7816716864396, -122.454158044121) 11 6 1 54 31
25945 62056 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1700 Beach St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/12/1985 12:00:00 AM 8   Permit Number 22136 6002013.39133 2121163.89045 37.8044245429292 -122.437278691955 (37.8044245429292, -122.437278691955) 13 9 1 57 17
26473 21538 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1350 Sutter St 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6006090.48396 2114915.15347 37.787498012379 -122.42272519983 (37.787498012379, -122.42272519983) 13 9 1 28858 41
28154 8723 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 3200 Geary Blvd 3 Median : Cutout Tree DPW 1     6 M6   5997259.3218258 2113018.202003 37.7817872731337 -122.453142084637 (37.7817872731337, -122.453142084637) 15 6 1 54 31
28170 140788 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 71 PARKER AVE 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   5996815.297 2114056.2961 37.784612146293 -122.454753218076 (37.784612146293, -122.454753218076) 11 6 1 54 31
28281 250792 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 290 32nd Ave 1 : Tree Private 2     6 Width 3ft   5985918.61873 2113977.26033 37.7837640802965 -122.492445705309 (37.7837640802965, -122.492445705309) 11 6 1 55 33
28481 125745 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1750 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6004621.79826 2118809.27225 37.7981073028768 -122.428084170861 (37.7981073028768, -122.428084170861) 13 9 1 57 17
29199 125834 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1880 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6005178.96144 2117491.50362 37.7945205520321 -122.426062362682 (37.7945205520321, -122.426062362682) 13 9 1 28858 27
29409 123001 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 22 07th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5993655.50891 2115329.41193 37.7879260232353 -122.465777464947 (37.7879260232353, -122.465777464947) 11 6 1 54 11
29574 125800 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 3701 Fillmore St 5 Sidewalk: Property side : Yard Tree Private 2     7 Width 3ft   6002016.97166 2121171.67387 37.8044461176676 -122.437266859587 (37.8044461176676, -122.437266859587) 13 9 1 57 17
29726 125761 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2399 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6001466.33506 2119016.13086 37.7984962497695 -122.439017805441 (37.7984962497695, -122.439017805441) 13 9 1 57 17
30501 125806 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2791 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6001438.2815 2115941.57277 37.7900527191983 -122.438894431052 (37.7900527191983, -122.438894431052) 13 6 1 29490 27
30828 143331 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1746 UNION ST 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6004622.2604 2118810.3639 37.7981103264146 -122.428082649557 (37.7981103264146, -122.428082649557) 13 9 1 57 17
31210 8746 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 3300 Geary Blvd 11 Median : Cutout Tree DPW 1     6 M6   5996964.8998051 2112982.2523578 37.7816716864396 -122.454158044121 (37.7816716864396, -122.454158044121) 11 6 1 54 31
31255 143332 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1746 UNION ST 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6004607.3256 2118807.7665 37.7981023496411 -122.428134143145 (37.7981023496411, -122.428134143145) 13 9 1 57 17
31272 69362 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 3521 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/18/1994 12:00:00 AM 7   Permit Number 33456 6002627.22111 2120704.30709 37.8031975232214 -122.435121592481 (37.8031975232214, -122.435121592481) 13 9 1 57 17
33308 7322 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2020 Fillmore St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 2X2   6002943.5503 2115286.7425 37.7883402486731 -122.43363951152 (37.7883402486731, -122.43363951152) 13 9 1 29490 27
33351 9883 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1530 Gough St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 4X4   6005400.00219 2115093.82301 37.787949613228 -122.425126847427 (37.787949613228, -122.425126847427) 13 9 1 28858 41
33845 125798 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 3701 Fillmore St 3 Sidewalk: Property side : Yard Tree Private 2     3 Width 3ft   6002015.8097 2121180.08116 37.8044691358044 -122.437271482998 (37.8044691358044, -122.437271482998) 13 9 1 57 17
33928 125743 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1782 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6004488.21286 2118788.49943 37.7980427072573 -122.428544934007 (37.7980427072573, -122.428544934007) 13 9 1 57 17
34165 125799 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 3701 Fillmore St 4 Sidewalk: Property side : Yard Tree Private 2     5 Width 3ft   6002016.65647 2121175.80568 37.8044574446054 -122.437268246357 (37.8044574446054, -122.437268246357) 13 9 1 57 17
34802 123986 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 7 07th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   5993605.6147 2115370.6558 37.7880363894105 -122.465953086481 (37.7880363894105, -122.465953086481) 11 6 1 54 11
34809 125791 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 3535 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5999695.76662 2120720.83293 37.8030760041033 -122.445267130484 (37.8030760041033, -122.445267130484) 13 9 1 57 17
34815 125833 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1870 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6005225.66086 2117499.28655 37.7945445612278 -122.425901330993 (37.7945445612278, -122.425901330993) 13 9 1 28858 27
36418 143337 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1782 UNION ST 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   6004486.5484 2118787.637 37.7980402450526 -122.428550632014 (37.7980402450526, -122.428550632014) 13 9 1 57 17
38256 125805 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 349 Marina Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     11     6001675.8593 2121806.39816 37.8061695046764 -122.438492810894 (37.8061695046764, -122.438492810894) 13 9 1 57 17
39297 69323 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2130 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/23/1994 12:00:00 AM 8   Permit Number 33406 6007673.53376 2119706.35756 37.8007426600105 -122.417587861288 (37.8007426600105, -122.417587861288) 5 1 1 308 32
41013 13288 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2639 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   5999748.1213 2119120.526 37.7986849783519 -122.444970846589 (37.7986849783519, -122.444970846589) 13 9 1 57 17
41567 120079 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 221 26th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 1ft   5987715.20741 2114498.36264 37.7852997534807 -122.486268531544 (37.7852997534807, -122.486268531544) 11 6 1 55 26
42595 59553 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1700 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/30/1981 12:00:00 AM 9   Permit Number 18938 6005363.02873 2118214.93321 37.7965173077913 -122.425476975078 (37.7965173077913, -122.425476975078) 13 9 1 28858 17
44792 58679 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2823 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/11/1979 12:00:00 AM 11   Permit Number 17907 5999510.1538 2118572.9915 37.7971680104441 -122.445754889478 (37.7971680104441, -122.445754889478) 13 9 1 57 17
45211 123902 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1 10th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     6 Width 4ft   5992691.42698 2114893.08742 37.7866723380473 -122.469081216144 (37.7866723380473, -122.469081216144) 11 6 1 54 11
45242 53793 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 258 27th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/08/1972 12:00:00 AM 5   Permit Number 9485 5987461.74395 2114234.65378 37.784560908121 -122.487126051666 (37.784560908121, -122.487126051666) 11 6 1 55 26
45623 45667 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 3201 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/18/2001 12:00:00 AM 5   Permit Number 44363 5999332.42339 2119845.91977 37.8006529814106 -122.446461503008 (37.8006529814106, -122.446461503008) 13 9 1 57 17
46737 125740 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 3000 Scott St 3 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6001004.89591 2118712.65785 37.7976367272048 -122.440592745877 (37.7976367272048, -122.440592745877) 13 9 1 57 17
47672 13130 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1727 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2     35 3X3   6004021.47106 2119661.74787 37.8004139978499 -122.430222327563 (37.8004139978499, -122.430222327563) 13 9 1 57 17
48295 54813 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 330 Locust St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/10/1972 12:00:00 AM 10   Permit Number 10667 5997647.89997 2115270.37281 37.7879934021327 -122.451960326717 (37.7879934021327, -122.451960326717) 11 6 1 54 31
49142 125739 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 3000 Scott St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6001008.7865 2118693.15243 37.7975833920075 -122.440577883666 (37.7975833920075, -122.440577883666) 13 9 1 57 17
50074 125763 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1595 Greenwich St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6005365.83059 2119555.39753 37.8001980395782 -122.425562729047 (37.8001980395782, -122.425562729047) 13 9 1 57 17
50156 125809 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2152 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6000391.06255 2116068.2231 37.7903408314189 -122.442526808093 (37.7903408314189, -122.442526808093) 13 6 1 29490 27
50289 97454 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 758 North Point St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/11/2011 12:00:00 AM 3 3x3   6007159.12761 2121599.09194 37.8059106699013 -122.419502281419 (37.8059106699013, -122.419502281419) 5 1 1 28858 32
50571 8675 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2900 Geary Blvd 2 Median : Cutout Tree DPW 1     6 M6   5998150.0688375 2113145.5858248 37.7821880464461 -122.450069715057 (37.7821880464461, -122.450069715057) 15 6 1 54 31
50649 250734 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2801 Lake St 2 Sidewalk: Curb side : Yard Tree Private 2     3 Width 4ft   5986725.81276 2114419.04313 37.7850242490072 -122.489685654482 (37.7850242490072, -122.489685654482) 11 6 1 55 33
51740 8745 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 3300 Geary Blvd 10 Median : Cutout Tree DPW 1     6 M6   5996964.8998051 2112982.2523578 37.7816716864396 -122.454158044121 (37.7816716864396, -122.454158044121) 11 6 1 54 31
53380 39921 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1938 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/25/1999 12:00:00 AM 4   Permit Number 41195 6001498.9973 2115128.5111 37.7878237158389 -122.43862607739 (37.7878237158389, -122.43862607739) 13 6 1 29490 27
53993 125773 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 3609 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   5997571.86812 2115077.96994 37.7874607597442 -122.452209493788 (37.7874607597442, -122.452209493788) 11 6 1 54 31
54291 250780 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 267 32nd Ave 1 : Tree Private 2     9 Width 3ft   5985869.60841 2114147.39692 37.7842283606933 -122.492627794654 (37.7842283606933, -122.492627794654) 11 6 1 55 33
55296 98116 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 3060 Pierce St 2 Sidewalk: Curb side : Cutout Tree Private 2     11   Permit Number 23584 6001457.2753 2118966.43976 37.7983592955935 -122.439045591788 (37.7983592955935, -122.439045591788) 13 9 1 57 17
55955 8676 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2900 Geary Blvd 3 Median : Cutout Tree DPW 1     6 M6   5998150.0688375 2113145.5858248 37.7821880464461 -122.450069715057 (37.7821880464461, -122.450069715057) 15 6 1 54 31
56123 125753 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2800 Filbert St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   5999461.74411 2118432.96288 37.7967807650693 -122.445912322107 (37.7967807650693, -122.445912322107) 13 9 1 57 17
56288 125817 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2081 Green St 3 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6003091.73227 2118199.34696 37.7963459203936 -122.433335035292 (37.7963459203936, -122.433335035292) 13 9 1 57 17
58704 140861 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 102 Jordan Ave 2 Sidewalk: Curb side : Yard Tree Private 2     8 Width 0ft   5996245.7331 2113752.0549 37.7837440946001 -122.456701695076 (37.7837440946001, -122.456701695076) 11 6 1 54 31
58914 13272 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2499X Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6000478.6195 2119188.7816 37.7989140544396 -122.442447999892 (37.7989140544396, -122.442447999892) 13 9 1 57 17
59533 123901 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1 10th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     8 Width 4ft   5992691.28495 2114901.15699 37.7866944866565 -122.469082295037 (37.7866944866565, -122.469082295037) 11 6 1 54 11
59748 250738 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2801 Lake St 6 Sidewalk: Curb side : Yard Tree Private 2     5 Width 4ft   5986770.52108 2114418.70237 37.7850259235546 -122.489530954893 (37.7850259235546, -122.489530954893) 11 6 1 55 33
60084 108595 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 1599x GREENWICH ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005333 2119502 37.8000495685335 -122.42567253315 (37.8000495685335, -122.42567253315) 13 9 1 57 17
60932 98117 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 3060 Pierce St 3 Sidewalk: Curb side : Cutout Tree Private 2     11   Permit Number 23584 6001455.49775 2118981.69776 37.798401088908 -122.439052836736 (37.798401088908, -122.439052836736) 13 9 1 57 17
61158 125808 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2585 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6002486.17534 2116087.08804 37.7905118303149 -122.435279222963 (37.7905118303149, -122.435279222963) 13 9 1 29490 27
61181 125737 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2964 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6001026.02043 2118577.60099 37.7972670995394 -122.440509957869 (37.7972670995394, -122.440509957869) 13 9 1 57 17
62087 125747 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1830 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6004263.23956 2118407.72557 37.7969844660126 -122.429296240239 (37.7969844660126, -122.429296240239) 13 9 1 57 17
62837 125814 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2400 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6002028.8758 2117750.14346 37.7950521700829 -122.436980560426 (37.7950521700829, -122.436980560426) 13 9 1 57 27
62907 7321 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2020 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 2X2   6002947.4804 2115269.8991 37.7882942239799 -122.433624709788 (37.7882942239799, -122.433624709788) 13 9 1 29490 27
63668 125744 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1750 Union St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6004605.15348 2118806.89342 37.7980998294914 -122.428141597064 (37.7980998294914, -122.428141597064) 13 9 1 57 17
66411 250736 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2801 Lake St 4 Sidewalk: Curb side : Yard Tree Private 2     4 Width 4ft   5986749.69109 2114418.5354 37.7850242490246 -122.489603006799 (37.7850242490246, -122.489603006799) 11 6 1 55 33
67431 125759 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2490 Filbert St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 4ft   6001059.99138 2118655.75982 37.7974836374112 -122.44039801837 (37.7974836374112, -122.44039801837) 13 9 1 57 17
67757 98119 Permitted Site 7 Callistemon citrinus :: Lemon Bottlebrush 67 3060@Greenwich Pierce St 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 23584 6001464 2118900 37.7981772521061 -122.439017558255 (37.7981772521061, -122.439017558255) 13 9 1 57 17
68437 250783 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 273 32nd Ave 1 : Tree Private 2     8 Width 3ft   5985872.78396 2114090.54911 37.7840724587071 -122.492612620392 (37.7840724587071, -122.492612620392) 11 6 1 55 33
68671 125804 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 3711 Fillmore St 6 : Tree Private 2     5 Width 3ft   6002009.77145 2121217.59748 37.804571802419 -122.437295066808 (37.804571802419, -122.437295066808) 13 9 1 57 17

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