trees
1,794 rows where qSpecies_id = 95 sorted by Police Districts descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1045 | 17359 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2221X Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6005488.40666 | 2117587.01663 | 37.7948002909451 | -122.424998441372 | (37.7948002909451, -122.424998441372) | 13 | 9 | 1 | 28858 | 27 | |||
1925 | 250092 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1698 Gough St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6005353.59952 | 2115427.24795 | 37.7888624934521 | -122.425311128409 | (37.7888624934521, -122.425311128409) | 13 | 9 | 1 | 28858 | 41 | |||
4011 | 62663 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 210 Laussat St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/2003 12:00:00 AM | Permit Number 30678 | 6003703.58181069 | 2109204.83752166 | 37.7716839461227 | -122.43057577962 | (37.7716839461227, -122.43057577962) | 15 | 9 | 11 | 29492 | 10 | ||
9570 | 132301 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2747 Larkin St | 2 | Front Yard : Yard | Tree | Private 2 | 9 | 6006508.97625 | 2120792.8563 | 37.8036603116463 | -122.421694934677 | (37.8036603116463, -122.421694934677) | 5 | 9 | 1 | 28858 | 32 | ||||
11806 | 233511 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 301 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 782005 | 6004633.78606 | 2109456.48744 | 37.7724275683009 | -122.427376074351 | (37.7724275683009, -122.427376074351) | 7 | 9 | 11 | 28852 | 10 | |
12584 | 9912 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1850 Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6005256.71716 | 2116118.9463 | 37.7907562498626 | -122.425695579589 | (37.7907562498626, -122.425695579589) | 13 | 9 | 1 | 28858 | 27 | |||
12729 | 132219 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 3000 Divisadero St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 6ft | 6000528.5903 | 2118632.53612 | 37.7973895998041 | -122.442235132763 | (37.7973895998041, -122.442235132763) | 13 | 9 | 1 | 57 | 17 | |||
15794 | 63736 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 585 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/1987 12:00:00 AM | Permit Number 24405 | 6003780.00958588 | 2109683.67127267 | 37.7730030357559 | -122.430345580362 | (37.7730030357559, -122.430345580362) | 7 | 9 | 11 | 29492 | 10 | ||
19207 | 17363 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2298X Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3X3 | 6005094.42253 | 2117295.11988 | 37.7939765536908 | -122.426340889125 | (37.7939765536908, -122.426340889125) | 13 | 9 | 1 | 28858 | 27 | |||
22030 | 66798 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2727 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/1991 12:00:00 AM | Permit Number 30077 | 6006105.82573514 | 2120126.22393826 | 37.8018071677784 | -122.423042648938 | (37.8018071677784, -122.423042648938) | 5 | 9 | 1 | 28858 | 32 | ||
23048 | 62265 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 213 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/07/1985 12:00:00 AM | Permit Number 22392 | 6003754.80258132 | 2109087.32118931 | 37.7713641765499 | -122.430390217832 | (37.7713641765499, -122.430390217832) | 15 | 9 | 11 | 29492 | 10 | ||
24186 | 62951 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1795 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1987 12:00:00 AM | Permit Number 23833 | 6002734.78397825 | 2113355.91233134 | 37.7830268313176 | -122.434223718554 | (37.7830268313176, -122.434223718554) | 15 | 9 | 11 | 29490 | 41 | ||
25409 | 9921 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1950 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005216.73932 | 2116427.47967 | 37.7916011458249 | -122.425855872064 | (37.7916011458249, -122.425855872064) | 13 | 9 | 1 | 28858 | 27 | |||
26315 | 132284 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2231 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6005033.56051 | 2117373.71494 | 37.7941889153446 | -122.426557077054 | (37.7941889153446, -122.426557077054) | 13 | 9 | 1 | 28858 | 27 | |||
27505 | 233596 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 44 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6006549.90248 | 2110330.35444 | 37.7749351803449 | -122.420810081832 | (37.7749351803449, -122.420810081832) | 7 | 9 | 11 | 28852 | 10 | |||
29218 | 63761 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 343 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1987 12:00:00 AM | Permit Number 24438 | 6003220.73981685 | 2109435.30524559 | 37.7722893887759 | -122.43226242096 | (37.7722893887759, -122.43226242096) | 15 | 9 | 11 | 29492 | 9 | ||
29243 | 9902 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1800 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3X3 | 6005282.34014 | 2115923.27251 | 37.7902204265742 | -122.425592993016 | (37.7902204265742, -122.425592993016) | 13 | 9 | 1 | 28858 | 27 | |||
30166 | 7981 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2040 Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 6005603.29363 | 2117103.29165 | 37.793478593006 | -122.424566490678 | (37.793478593006, -122.424566490678) | 13 | 9 | 1 | 28858 | 27 | |||
30170 | 7980 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2040 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005605.28232 | 2117078.33764 | 37.7934101878854 | -122.424557833777 | (37.7934101878854, -122.424557833777) | 13 | 9 | 1 | 28858 | 27 | |||
30484 | 132270 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2365 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6002266.18252 | 2117737.88949 | 37.7950320090838 | -122.436158567482 | (37.7950320090838, -122.436158567482) | 13 | 9 | 1 | 29490 | 27 | |||
35669 | 132300 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2747 Larkin St | 1 | Front Yard : Yard | Tree | Private 2 | 11 | 6006512.88528 | 2120797.48529 | 37.8036732420995 | -122.421681736235 | (37.8036732420995, -122.421681736235) | 5 | 9 | 1 | 28858 | 32 | ||||
36368 | 63741 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 430 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1987 12:00:00 AM | Permit Number 24413 | 6003230.48917651 | 2109743.18641692 | 37.7731353074733 | -122.432250688999 | (37.7731353074733, -122.432250688999) | 15 | 9 | 11 | 29492 | 10 | ||
37709 | 132222 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 235 Moulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6002168.34609 | 2119296.77795 | 37.7993067511504 | -122.43660873213 | (37.7993067511504, -122.43660873213) | 13 | 9 | 1 | 57 | 17 | |||
38587 | 18832 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2001 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6005164.85417 | 2116130.93612 | 37.7907839795542 | -122.426014275038 | (37.7907839795542, -122.426014275038) | 13 | 9 | 1 | 28858 | 27 | |||
39422 | 23695 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2010X Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6005631.74009 | 2116915.10044 | 37.7929634737292 | -122.424454671565 | (37.7929634737292, -122.424454671565) | 13 | 9 | 1 | 28858 | 27 | |||
39639 | 132275 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1801 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6005248.94988 | 2115878.05631 | 37.7900943874847 | -122.425705301272 | (37.7900943874847, -122.425705301272) | 13 | 9 | 1 | 28858 | 27 | |||
40120 | 66387 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 576 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1991 12:00:00 AM | Permit Number 29513 | 6003809.30522061 | 2109740.24975223 | 37.7731600457631 | -122.430248280428 | (37.7731600457631, -122.430248280428) | 7 | 9 | 11 | 29492 | 10 | ||
41339 | 132292 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1351 Lombard St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 5ft | 6005902.17996 | 2119970.81093 | 37.8013689496769 | -122.423736302209 | (37.8013689496769, -122.423736302209) | 13 | 9 | 1 | 28858 | 32 | |||
43358 | 7984 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2040 Franklin St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6005624.48524 | 2117113.11255 | 37.7935067554767 | -122.424493864894 | (37.7935067554767, -122.424493864894) | 13 | 9 | 1 | 28858 | 27 | |||
47550 | 63734 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 547 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1987 12:00:00 AM | Permit Number 24403 | 6003953.21225561 | 2109707.77705475 | 37.7730790336555 | -122.429748170749 | (37.7730790336555, -122.429748170749) | 7 | 9 | 11 | 29492 | 10 | ||
48151 | 98950 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 401 Grove St | 10 | Front Yard : Yard | Tree | Private 2 | 6005778.2 | 2111279 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | 7 | 9 | 11 | 28852 | 10 | |||||
48788 | 132223 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 51 Pixley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003128.76488 | 2119081.54753 | 37.7987703154491 | -122.433269963962 | (37.7987703154491, -122.433269963962) | 13 | 9 | 1 | 57 | 17 | |||
49431 | 67556 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 890 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/25/1995 12:00:00 AM | Permit Number 31105 | 6003602.07514471 | 2110752.33262694 | 37.7759272362097 | -122.43103736444 | (37.7759272362097, -122.43103736444) | 7 | 9 | 11 | 29492 | 10 | ||
50362 | 132277 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1765 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6005628.20454 | 2117179.17988 | 37.7936883697662 | -122.424485697377 | (37.7936883697662, -122.424485697377) | 13 | 9 | 1 | 28858 | 27 | |||
50956 | 63760 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 540 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1987 12:00:00 AM | Permit Number 24437 | 6003973.39193973 | 2109763.08680608 | 37.7732320433706 | -122.429682312236 | (37.7732320433706, -122.429682312236) | 7 | 9 | 11 | 29492 | 10 | ||
53952 | 233597 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 197 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6006526.51025 | 2110764.29313 | 37.776125353047 | -122.420921816282 | (37.776125353047, -122.420921816282) | 7 | 9 | 11 | 28852 | 10 | |||
54188 | 62277 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 143 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1985 12:00:00 AM | Permit Number 22415 | 6003782.90923868 | 2108884.50299303 | 37.7708088793685 | -122.430278523291 | (37.7708088793685, -122.430278523291) | 15 | 9 | 11 | 29492 | 10 | ||
55900 | 17783 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1670X Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/15/2014 12:00:00 AM | 3 | 3X3 | 6005360.49348 | 2115382.69892 | 37.7887405624242 | -122.425284104871 | (37.7887405624242, -122.425284104871) | 13 | 9 | 1 | 28858 | 41 | ||
60900 | 103616 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 201X Haight St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6004725 | 2109149 | 37.7715884407354 | -122.427038651796 | (37.7715884407354, -122.427038651796) | 7 | 9 | 11 | 28852 | 10 | |||||
61576 | 7964 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1845 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6005641.9445 | 2116491.16052 | 37.7918000174095 | -122.424389196528 | (37.7918000174095, -122.424389196528) | 13 | 9 | 1 | 28858 | 27 | |||
61779 | 67779 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 408 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1992 12:00:00 AM | Permit Number 31413 | 6003736.32174931 | 2109035.86372191 | 37.771221840054 | -122.430450471743 | (37.771221840054, -122.430450471743) | 15 | 9 | 11 | 29492 | 10 | ||
63935 | 132295 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1213 Lombard St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 11 | Width 3ft | 6006526.56714 | 2120062.48471 | 37.8016558891581 | -122.421582156104 | (37.8016558891581, -122.421582156104) | 13 | 9 | 1 | 28858 | 32 | |||
66091 | 100771 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 450 Hayes St | 2 | Back Yard : Yard | Tree | Private 2 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | 7 | 9 | 11 | 28852 | 10 | ||||
66653 | 63766 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 401 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1987 12:00:00 AM | Permit Number 24444 | 6003192.52222029 | 2109638.52781799 | 37.7728457879591 | -122.432374545195 | (37.7728457879591, -122.432374545195) | 15 | 9 | 11 | 29492 | 9 | ||
67766 | 9918 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1905X Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 20 | 3X3 | Permit Number 768908 | 6005198.9827241 | 2116181.2464075 | 37.7909240477297 | -122.425899774562 | (37.7909240477297, -122.425899774562) | 13 | 9 | 1 | 28858 | 27 | ||
67832 | 26156 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1801 Franklin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6005669.63899 | 2116283.45257 | 37.7912312672666 | -122.424278594289 | (37.7912312672666, -122.424278594289) | 13 | 9 | 1 | 28858 | 27 | |||
69096 | 250044 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 50 Daniel Burnham Ct | 3 | : | Tree | Private 2 | 3 | Width 3ft | 6006103.91102 | 2114728.75615 | 37.7869869690171 | -122.422665493826 | (37.7869869690171, -122.422665493826) | 13 | 9 | 1 | 28858 | 41 | |||
69454 | 98948 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 401 Grove St | 8 | Front Yard : Yard | Tree | Private 2 | 6005778.2 | 2111279 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | 7 | 9 | 11 | 28852 | 10 | |||||
70078 | 67220 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 367 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1992 12:00:00 AM | Permit Number 30679 | 6003525.51133161 | 2108607.7820018 | 37.7700344883116 | -122.431149113146 | (37.7700344883116, -122.431149113146) | 15 | 9 | 5 | 29492 | 10 | ||
75543 | 132299 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2836 Larkin St | 9 | Side Yard : Yard | Tree | Private 2 | 6 | 6006506.76363 | 2120995.98891 | 37.8042179371566 | -122.421717028328 | (37.8042179371566, -122.421717028328) | 5 | 9 | 1 | 28858 | 32 | ||||
77554 | 115072 | Undocumented 4 | Pittosporum crassifolium :: Karo Tree 95 | 65 LILY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006230 | 2110204 | 37.7745702053319 | -122.421907716929 | (37.7745702053319, -122.421907716929) | 7 | 9 | 11 | 28852 | 10 | ||||
77601 | 9924 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2000 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 7 | 3x3 | 6005199.42754 | 2116554.24063 | 37.7919482211773 | -122.425924797914 | (37.7919482211773, -122.425924797914) | 13 | 9 | 1 | 28858 | 27 | |||
77613 | 66110 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 124 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1990 12:00:00 AM | Permit Number 29164 | 6005954.05152204 | 2110038.74835026 | 37.7741008978737 | -122.422850531283 | (37.7741008978737, -122.422850531283) | 7 | 9 | 11 | 28852 | 10 | ||
78067 | 68914 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1535 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | Permit Number 32893 | 6005691.62707628 | 2118555.83678979 | 37.7974719031724 | -122.424364211095 | (37.7974719031724, -122.424364211095) | 13 | 9 | 1 | 57 | 17 | ||
79510 | 132282 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2211 Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6005491.53565 | 2117575.42824 | 37.7947686488998 | -122.424986789728 | (37.7947686488998, -122.424986789728) | 13 | 9 | 1 | 28858 | 27 | |||
82621 | 94976 | Undocumented 4 | Pittosporum crassifolium :: Karo Tree 95 | 2040@Jackson Franklin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6005619 | 2117006 | 37.7932123416077 | -122.42450522172 | (37.7932123416077, -122.42450522172) | 13 | 9 | 1 | 28858 | 27 | |||
83304 | 63735 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 550 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/1987 12:00:00 AM | Permit Number 24404 | 6003927.8122889 | 2109756.74317909 | 37.7732120443049 | -122.429839525756 | (37.7732120443049, -122.429839525756) | 7 | 9 | 11 | 29492 | 10 | ||
85445 | 26427 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1640 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6006249.54738 | 2116165.50177 | 37.7909401315329 | -122.422263740587 | (37.7909401315329, -122.422263740587) | 13 | 9 | 10 | 28858 | 21 | |||
86038 | 132247 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2219 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001204.27502 | 2119670.73676 | 37.8002787105624 | -122.439971574231 | (37.8002787105624, -122.439971574231) | 13 | 9 | 1 | 57 | 17 | |||
86876 | 132283 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2231 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6005031.55394 | 2117390.77944 | 37.7942356567023 | -122.426565235699 | (37.7942356567023, -122.426565235699) | 13 | 9 | 1 | 28858 | 27 | |||
87887 | 7973 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1955 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6005592.81541 | 2116805.41322 | 37.7926601020218 | -122.42458154712 | (37.7926601020218, -122.42458154712) | 13 | 9 | 1 | 28858 | 27 | |||
88691 | 7956 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1755 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6005681.33133 | 2116176.18238 | 37.7909373903882 | -122.424230506628 | (37.7909373903882, -122.424230506628) | 13 | 9 | 1 | 28858 | 27 | |||
91541 | 62972 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1925 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/1986 12:00:00 AM | Permit Number 23360 | 6006917.08004501 | 2117794.01940354 | 37.795449266164 | -122.420069721333 | (37.795449266164, -122.420069721333) | 13 | 9 | 10 | 28858 | 32 | ||
91757 | 56888 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 379 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/1992 12:00:00 AM | Permit Number 30734 | 6003470.66871359 | 2108600.18569561 | 37.7700105227729 | -122.431338270509 | (37.7700105227729, -122.431338270509) | 15 | 9 | 5 | 29492 | 10 | ||
92769 | 9919 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1905X Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 20 | 3X3 | Permit Number 768908 | 6005198.9827241 | 2116181.2464075 | 37.7909240477297 | -122.425899774562 | (37.7909240477297, -122.425899774562) | 13 | 9 | 1 | 28858 | 27 | ||
95809 | 9888 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1666 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005355.48435 | 2115413.01457 | 37.7888235186322 | -122.425303593892 | (37.7888235186322, -122.425303593892) | 13 | 9 | 1 | 28858 | 41 | |||
96275 | 67696 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1802 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/2002 12:00:00 AM | Permit Number 31305 | 6004401.173369 | 2118429.46678994 | 37.7970519696736 | -122.428820506832 | (37.7970519696736, -122.428820506832) | 13 | 9 | 1 | 57 | 17 | ||
96534 | 132268 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2740 Divisadero St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 4ft | 6000661.7874 | 2117770.33364 | 37.7950298093365 | -122.441712328073 | (37.7950298093365, -122.441712328073) | 13 | 9 | 1 | 57 | 27 | |||
97409 | 132267 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2740 Divisadero St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 6000663.69411 | 2117749.29227 | 37.794972143905 | -122.441704219792 | (37.794972143905, -122.441704219792) | 13 | 9 | 1 | 57 | 27 | |||
99802 | 62274 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 127 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1985 12:00:00 AM | Permit Number 22410 | 6004223.66496449 | 2109215.34758778 | 37.771742253448 | -122.428777529151 | (37.771742253448, -122.428777529151) | 7 | 9 | 11 | 29492 | 10 | ||
99910 | 9923 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2000 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6005200.36117 | 2116532.07759 | 37.791887419813 | -122.425919989211 | (37.791887419813, -122.425919989211) | 13 | 9 | 1 | 28858 | 27 | |||
100606 | 100772 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 450 Hayes St | 3 | Back Yard : Yard | Tree | Private 2 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | 7 | 9 | 11 | 28852 | 10 | ||||
101422 | 2576 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1666 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6005527.92113 | 2115186.27455 | 37.7882106874937 | -122.424690849945 | (37.7882106874937, -122.424690849945) | 13 | 9 | 1 | 28858 | 41 | |||
104123 | 7982 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2040 Franklin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6005602.68214 | 2117114.10003 | 37.7935082355629 | -122.424569375675 | (37.7935082355629, -122.424569375675) | 13 | 9 | 1 | 28858 | 27 | |||
104327 | 57698 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 112 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1985 12:00:00 AM | Permit Number 22413 | 6003845.29045586 | 2108813.17790583 | 37.770616571258 | -122.430057656537 | (37.770616571258, -122.430057656537) | 7 | 9 | 11 | 29492 | 10 | ||
108504 | 63758 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 425 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1987 12:00:00 AM | Permit Number 24434 | 6003181.69109256 | 2109716.53339488 | 37.7730593578892 | -122.432417583748 | (37.7730593578892, -122.432417583748) | 15 | 9 | 11 | 29492 | 9 | ||
109965 | 138055 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1801 Webster St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6003429.2071 | 2114921.0289 | 37.787363636105 | -122.431933094738 | (37.787363636105, -122.431933094738) | 13 | 9 | 11 | 29490 | 27 | |||
110925 | 94974 | Undocumented 4 | Pittosporum crassifolium :: Karo Tree 95 | 2040@Jackson Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6005619 | 2117006 | 37.7932123416077 | -122.42450522172 | (37.7932123416077, -122.42450522172) | 13 | 9 | 1 | 28858 | 27 | |||
113409 | 92745 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 65 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2009 12:00:00 AM | Permit Number 52969 | 6006237.3 | 2110147.2 | 37.7744146578956 | -122.42187842919 | (37.7744146578956, -122.42187842919) | 7 | 9 | 11 | 28852 | 10 | |||
115342 | 17362 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2298X Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3X3 | 6005094.42253 | 2117295.11988 | 37.7939765536908 | -122.426340889125 | (37.7939765536908, -122.426340889125) | 13 | 9 | 1 | 28858 | 27 | |||
118036 | 7723 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 175X Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006514.1274 | 2110757.9768 | 37.7761073119325 | -122.420964203399 | (37.7761073119325, -122.420964203399) | 7 | 9 | 11 | 28852 | 10 | |||
120503 | 58678 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 596 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1987 12:00:00 AM | Permit Number 24398 | 6003287.0157035 | 2109320.57844586 | 37.7719781347946 | -122.43202497289 | (37.7719781347946, -122.43202497289) | 15 | 9 | 11 | 29492 | 10 | ||
120630 | 63764 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 311 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1987 12:00:00 AM | Permit Number 24442 | 6003235.24732503 | 2109330.82245921 | 37.7720033272962 | -122.4322047752 | (37.7720033272962, -122.4322047752) | 15 | 9 | 11 | 29492 | 9 | ||
121551 | 30727 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 45 Rose St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | Permit Number 34624 | 6006303.86733164 | 2109861.47838862 | 37.7736338888904 | -122.421627862373 | (37.7736338888904, -122.421627862373) | 7 | 9 | 11 | 28852 | 10 | ||
121819 | 62608 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 410 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/28/1987 12:00:00 AM | Permit Number 22917 | 6003239.5151167 | 2109678.18176647 | 37.7729573324765 | -122.432214823883 | (37.7729573324765, -122.432214823883) | 15 | 9 | 11 | 29492 | 10 | ||
121865 | 132272 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2365 Vallejo St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 4ft | 6002269.48005 | 2117729.16258 | 37.7950082345994 | -122.436146532743 | (37.7950082345994, -122.436146532743) | 13 | 9 | 1 | 29490 | 27 | |||
121967 | 233509 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 599 Buchanan St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 6004544.20196 | 2110431.59381 | 37.7750999055671 | -122.427755444356 | (37.7750999055671, -122.427755444356) | 7 | 9 | 11 | 28852 | 10 | |||
122186 | 7958 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1800 Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6005719.63486 | 2116291.57932 | 37.7912564042045 | -122.424106187976 | (37.7912564042045, -122.424106187976) | 13 | 9 | 1 | 28858 | 27 | |||
123077 | 2683 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2100 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003416.3801 | 2114894.2482 | 37.7872893759097 | -122.431975560402 | (37.7872893759097, -122.431975560402) | 13 | 9 | 11 | 29490 | 27 | |||
125737 | 63759 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 350 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1987 12:00:00 AM | Permit Number 24436 | 6003268.61880609 | 2109468.57756707 | 37.7723834610111 | -122.432099179795 | (37.7723834610111, -122.432099179795) | 15 | 9 | 11 | 29492 | 10 | ||
126757 | 233595 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 65 Lily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6006199.44 | 2110210.42189 | 37.7745861147813 | -122.422013886425 | (37.7745861147813, -122.422013886425) | 7 | 9 | 11 | 28852 | 10 | |||
127438 | 6957 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 627 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6004338.3385 | 2110455.1046 | 37.7751528130593 | -122.428469247762 | (37.7751528130593, -122.428469247762) | 7 | 9 | 11 | 28852 | 10 | |||
128517 | 132279 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1765 Jackson St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6005717.59381 | 2117186.89144 | 37.7937145913183 | -122.424176951119 | (37.7937145913183, -122.424176951119) | 13 | 9 | 1 | 28858 | 27 | |||
128687 | 62278 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 391 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1985 12:00:00 AM | Permit Number 22416 | 6004275.31529715 | 2109405.62927883 | 37.7722676437754 | -122.428612433422 | (37.7722676437754, -122.428612433422) | 7 | 9 | 11 | 28852 | 10 | ||
130498 | 26426 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1640 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006251.83822 | 2116157.44916 | 37.7909181502895 | -122.422255241997 | (37.7909181502895, -122.422255241997) | 13 | 9 | 10 | 28858 | 21 | |||
130596 | 63731 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 510 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1987 12:00:00 AM | Permit Number 24400 | 6004110.13087942 | 2109782.11768526 | 37.7732920393038 | -122.429210671215 | (37.7732920393038, -122.429210671215) | 7 | 9 | 11 | 29492 | 10 | ||
131338 | 132298 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2836 Larkin St | 8 | Side Yard : Yard | Tree | Private 2 | 19 | 6006506.15813 | 2120992.00348 | 37.8042069600397 | -122.421718840462 | (37.8042069600397, -122.421718840462) | 5 | 9 | 1 | 28858 | 32 | ||||
132985 | 132278 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1765 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6005655.32163 | 2117179.86779 | 37.7936917899018 | -122.424391918752 | (37.7936917899018, -122.424391918752) | 13 | 9 | 1 | 28858 | 27 | |||
133164 | 132294 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2534 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6006243.11862 | 2119489.75886 | 37.8000673429019 | -122.422522299269 | (37.8000673429019, -122.422522299269) | 13 | 9 | 1 | 28858 | 32 | |||
133880 | 7983 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2040 Franklin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6005599.00069 | 2117137.84326 | 37.7935732205869 | -122.424583803523 | (37.7935732205869, -122.424583803523) | 13 | 9 | 1 | 28858 | 27 |
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) );