trees
3,267 rows where qSpecies_id = 67 sorted by Supervisor Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );