trees
3,965 rows where qSpecies_id = 70 sorted by qCaretaker_id 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
31471 | 6631 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1415 Evans Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 02/15/2001 12:00:00 AM | 18 | 3x3 | 6016617.7688071 | 2097746.8662364 | 37.740945901362 | -122.385105911093 | (37.740945901362, -122.385105911093) | 10 | 3 | 8 | 58 | 1 | ||
41490 | 6632 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1415 Evans Ave | 15 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 18 | 3x3 | 6016617.7688071 | 2097746.8662364 | 37.740945901362 | -122.385105911093 | (37.740945901362, -122.385105911093) | 10 | 3 | 8 | 58 | 1 | |||
56232 | 6621 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1415 Evans Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 18 | 3x3 | 6016617.7688071 | 2097746.8662364 | 37.740945901362 | -122.385105911093 | (37.740945901362, -122.385105911093) | 10 | 3 | 8 | 58 | 1 | |||
155772 | 6824 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1450X Fairfax Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 18 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.386179680893 | (37.740834465841, -122.386179680893) | 10 | 3 | 8 | 58 | 1 | |||
24943 | 98739 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1150 Scott St | 3 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | DPW for City Agency | 20 | 4X4 | 6002360 | 2112467 | 37.7805648236525 | -122.435456706153 | (37.7805648236525, -122.435456706153) | 15 | 5 | 11 | 29490 | 41 | ||
29904 | 98737 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1150 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | DPW for City Agency | 24 | 4X4 | 6002360 | 2112467 | 37.7805648236525 | -122.435456706153 | (37.7805648236525, -122.435456706153) | 15 | 5 | 11 | 29490 | 41 | ||
38215 | 95363 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 775X Broadway | 6 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | DPW for City Agency | 20 | 3x3 | 6009884 | 2118395.5 | 37.7972675002992 | -122.409846113399 | (37.7972675002992, -122.409846113399) | 3 | 1 | 10 | 308 | 4 | ||
112086 | 95360 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 775X Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | DPW for City Agency | 12 | 3x3 | Permit Number 778058 | 6009884 | 2118395.5 | 37.7972675002992 | -122.409846113399 | (37.7972675002992, -122.409846113399) | 3 | 1 | 10 | 308 | 4 | |
140018 | 98738 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1150 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | DPW for City Agency | 3 | 4X4 | 6001885.6171 | 2112431.4484 | 37.7804402546102 | -122.437095273073 | (37.7804402546102, -122.437095273073) | 15 | 5 | 11 | 29490 | 41 | ||
141758 | 95359 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 775X Broadway | 5 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | DPW for City Agency | 12 | 3x3 | Permit Number 778058 | 6009884 | 2118395.5 | 37.7972675002992 | -122.409846113399 | (37.7972675002992, -122.409846113399) | 3 | 1 | 10 | 308 | 4 | |
142765 | 95361 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 775X Broadway | 4 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | DPW for City Agency | 10 | 3x3 | Permit Number 778058 | 6009884 | 2118395.5 | 37.7972675002992 | -122.409846113399 | (37.7972675002992, -122.409846113399) | 3 | 1 | 10 | 308 | 4 | |
148106 | 98740 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1150 Scott St | 4 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | DPW for City Agency | 20 | 4X4 | 6002360 | 2112467 | 37.7805648236525 | -122.435456706153 | (37.7805648236525, -122.435456706153) | 15 | 5 | 11 | 29490 | 41 | ||
148170 | 95362 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 775X Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | DPW for City Agency | 3x3 | Permit Number 778058 | 6009884 | 2118395.5 | 37.7972675002992 | -122.409846113399 | (37.7972675002992, -122.409846113399) | 3 | 1 | 10 | 308 | 4 | ||
157769 | 95358 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 775X Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | DPW for City Agency | 25 | 3x3 | Permit Number 778058 | 6009884 | 2118395.5 | 37.7972675002992 | -122.409846113399 | (37.7972675002992, -122.409846113399) | 3 | 1 | 10 | 308 | 4 | |
40162 | 95366 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3101X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 14 | 3x3 | 6005504.90819 | 2120981.97244 | 37.8041229057048 | -122.425183031522 | (37.8041229057048, -122.425183031522) | 13 | 9 | 1 | 28858 | 17 | ||
100260 | 49664 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3630 Divisadero St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 04/18/2011 12:00:00 AM | 26 | Permit Number 46510 | 6000238.4271 | 2120737.06693 | 37.8031515390838 | -122.443390413534 | (37.8031515390838, -122.443390413534) | 13 | 9 | 1 | 57 | 17 | ||
49681 | 116977 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 100x CARGO WAY | 117 | Front Yard : Yard | Tree | PUC 8 | DPW for City Agency | 6019010 | 2097405 | 37.7401392444118 | -122.376810655394 | (37.7401392444118, -122.376810655394) | 10 | 3 | 8 | 58 | 1 | ||||
55364 | 11774 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1199X Junipero Serra Blvd | 19 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 2x3 | 5991174.5545657 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | 9 | 8 | 6 | 64 | 24 | |||
61387 | 114840 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 2455x HYDE ST | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 3x3 | 6006980 | 2120877 | 37.8039178984324 | -122.420070904619 | (37.8039178984324, -122.420070904619) | 5 | 1 | 1 | 28858 | 32 | ||||
76918 | 11791 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1199X Junipero Serra Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 30 | 3x4 | 5991174.5545657 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | 9 | 8 | 6 | 64 | 24 | |||
79561 | 11788 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1199X Junipero Serra Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 3x4 | 5991174.5545657 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | 9 | 8 | 6 | 64 | 24 | |||
83487 | 11823 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1299X Junipero Serra Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 24 | 3 | 5991432.1718154 | 2088660.0347764 | 37.7145703669544 | -122.471525618465 | (37.7145703669544, -122.471525618465) | 9 | 8 | 6 | 64 | 24 | |||
100294 | 11789 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1199X Junipero Serra Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 24 | 3x4 | 5991174.5545657 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | 9 | 8 | 6 | 64 | 24 | |||
134245 | 11817 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 3X3 | 5991184.5559808 | 2089595.7938425 | 37.7171254042551 | -122.472449649239 | (37.7171254042551, -122.472449649239) | 9 | 8 | 6 | 64 | 24 | |||
145746 | 11787 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1199X Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 3x4 | 5991174.5545657 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | 9 | 8 | 6 | 64 | 24 | |||
152891 | 11815 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 6 | 3X3 | 5991184.5559808 | 2089595.7938425 | 37.7171254042551 | -122.472449649239 | (37.7171254042551, -122.472449649239) | 9 | 8 | 6 | 64 | 24 | |||
152984 | 11820 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1299X Junipero Serra Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 3 | 5991432.1718154 | 2088660.0347764 | 37.7145703669544 | -122.471525618465 | (37.7145703669544, -122.471525618465) | 9 | 8 | 6 | 64 | 24 | |||
167696 | 11773 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1199X Junipero Serra Blvd | 18 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 3x4 | 5991174.5545657 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | 9 | 8 | 6 | 64 | 24 | |||
35108 | 3688 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 200X Cargo Way | 2 | Median : Cutout | Tree | Port 6 | 18 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.383105675332 | (37.7440206368399, -122.383105675332) | 10 | 3 | 8 | 58 | 1 | |||
35347 | 3691 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 200X Cargo Way | 5 | Median : Cutout | Tree | Port 6 | 12 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.383105675332 | (37.7440206368399, -122.383105675332) | 10 | 3 | 8 | 58 | 1 | |||
35762 | 3690 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 200X Cargo Way | 4 | Median : Cutout | Tree | Port 6 | 12 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.383105675332 | (37.7440206368399, -122.383105675332) | 10 | 3 | 8 | 58 | 1 | |||
104325 | 3689 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 200X Cargo Way | 3 | Median : Cutout | Tree | Port 6 | 12 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.383105675332 | (37.7440206368399, -122.383105675332) | 10 | 3 | 8 | 58 | 1 | |||
105726 | 3685 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100X Cargo Way | 121 | Sidewalk: Property side : Cutout | Tree | Port 6 | 8 | 3x3 | 6016762.06772 | 2099192.87656 | 37.744924332395 | -122.38470767872 | (37.744924332395, -122.38470767872) | 10 | 3 | 8 | 58 | 1 | |||
158492 | 3686 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 100X Cargo Way | 1 | Median : Cutout | Tree | Port 6 | 12 | 8 | 6018980.3390981 | 2097500.2540781 | 37.7403991596993 | -122.376919818221 | (37.7403991596993, -122.376919818221) | 10 | 3 | 8 | 58 | 1 | |||
179402 | 3687 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 200X Cargo Way | 1 | Median : Cutout | Tree | Port 6 | 12 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.383105675332 | (37.7440206368399, -122.383105675332) | 10 | 3 | 8 | 58 | 1 | |||
23390 | 22618 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1001 Turk St | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 3x5 | 6005224.1346872 | 2112659.8569034 | 37.7812566094766 | -122.425562024881 | (37.7812566094766, -122.425562024881) | 7 | 9 | 11 | 28852 | 41 | |||
36156 | 22614 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1001 Turk St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 3x5 | 6005426.7391 | 2112695.1691 | 37.7813650138202 | -122.424863625752 | (37.7813650138202, -122.424863625752) | 7 | 9 | 11 | 28852 | 41 | |||
48323 | 24932 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2099X Post St | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 02/22/1996 12:00:00 AM | 18 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | 13 | 6 | 11 | 29490 | 13 | ||
50787 | 24935 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2099X Post St | 12 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | 13 | 6 | 11 | 29490 | 13 | |||
56308 | 20477 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1203X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6 | 40 | 5984781.3005655 | 2107242.2257009 | 37.7652050441375 | -122.495883339617 | (37.7652050441375, -122.495883339617) | 11 | 6 | 2 | 55 | 8 | |||
56373 | 24927 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2099X Post St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 36 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | 13 | 6 | 11 | 29490 | 13 | |||
65882 | 22610 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1001 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 30 | 3X5 | 6005224.1346872 | 2112659.8569034 | 37.7812566094766 | -122.425562024881 | (37.7812566094766, -122.425562024881) | 7 | 9 | 11 | 28852 | 41 | |||
68608 | 20475 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1203X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 40 | 5984781.3005655 | 2107242.2257009 | 37.7652050441375 | -122.495883339617 | (37.7652050441375, -122.495883339617) | 11 | 6 | 2 | 55 | 8 | |||
68698 | 104451 | Private 9 | Acacia melanoxylon :: Blackwood Acacia 70 | 2490X Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6008214.39649 | 2104163.75253 | 37.7580968032353 | -122.41461574816 | (37.7580968032353, -122.41461574816) | 2 | 4 | 7 | 28859 | 19 | ||||
69907 | 22615 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1001 Turk St | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 3x5 | 6005224.1346872 | 2112659.8569034 | 37.7812566094766 | -122.425562024881 | (37.7812566094766, -122.425562024881) | 7 | 9 | 11 | 28852 | 41 | |||
74199 | 764 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200X 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 3 | 5984614.2914 | 2106873.7688 | 37.7641835827447 | -122.496433785178 | (37.7641835827447, -122.496433785178) | 1 | 8 | 3 | 56 | 35 | |||
78544 | 24934 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2099X Post St | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 09/28/1999 12:00:00 AM | 24 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | 13 | 6 | 11 | 29490 | 13 | ||
78581 | 5467 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 600X Dolores St | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 48 | 6004918.8923427 | 2104703.9652182 | 37.7593943997498 | -122.426051479658 | (37.7593943997498, -122.426051479658) | 2 | 4 | 5 | 28862 | 3 | ||||
90007 | 113799 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 695x SHOTWELL ST | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 4x4 | 6008062 | 2103972 | 37.757561731467 | -122.415129229314 | (37.757561731467, -122.415129229314) | 2 | 4 | 7 | 28859 | 19 | ||||
91676 | 104449 | Private 9 | Acacia melanoxylon :: Blackwood Acacia 70 | 2490X Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6008214.39649 | 2104163.75253 | 37.7580968032353 | -122.41461574816 | (37.7580968032353, -122.41461574816) | 2 | 4 | 7 | 28859 | 19 | ||||
103217 | 125218 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2101 Washington St | 21 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 13 | Width 4ft | 6005090.35688 | 2116771.11072 | 37.7925375271472 | -122.426317630775 | (37.7925375271472, -122.426317630775) | 13 | 9 | 1 | 28858 | 27 | |||
108084 | 113797 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 695x SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 4x4 | 6008062 | 2103972 | 37.757561731467 | -122.415129229314 | (37.757561731467, -122.415129229314) | 2 | 4 | 7 | 28859 | 19 | ||||
108199 | 22617 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1001 Turk St | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 03/25/1997 12:00:00 AM | 6 | 3x5 | 6005634.7978 | 2112724.8918 | 37.7814583745998 | -122.424145957729 | (37.7814583745998, -122.424145957729) | 7 | 9 | 11 | 28852 | 41 | ||
117038 | 24929 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2099X Post St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | 13 | 6 | 11 | 29490 | 13 | |||
137055 | 20510 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1211X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 18 | 60 | 5984783.6901595 | 2107169.3790132 | 37.7650051676015 | -122.495869700491 | (37.7650051676015, -122.495869700491) | 11 | 6 | 2 | 55 | 8 | |||
141970 | 24924 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2199X Post St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 3X3 | 6001667.0796215 | 2113903.324382 | 37.7844692272317 | -122.437956753313 | (37.7844692272317, -122.437956753313) | 13 | 6 | 11 | 29490 | 13 | |||
153894 | 113798 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 695x SHOTWELL ST | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 4x4 | 6008062 | 2103972 | 37.757561731467 | -122.415129229314 | (37.757561731467, -122.415129229314) | 2 | 4 | 7 | 28859 | 19 | ||||
162752 | 5435 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 500X Dolores St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 90 | 6 | 6004896.4850005 | 2105439.5076575 | 37.7614127588524 | -122.426181340905 | (37.7614127588524, -122.426181340905) | 2 | 4 | 5 | 28862 | 3 | |||
165495 | 105909 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1864X 14TH AVE | 1 | Median : Yard | Tree | Rec/Park 5 | 14 | 5991829 | 2102804 | 37.7534290869332 | -122.47118388852 | (37.7534290869332, -122.47118388852) | 1 | 8 | 4 | 56 | 12 | ||||
169179 | 22613 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1001 Turk St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 3x5 | 6005358.7073 | 2112686.5825 | 37.7813375942673 | -122.42509837168 | (37.7813375942673, -122.42509837168) | 7 | 9 | 11 | 28852 | 41 | |||
181281 | 113800 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 695x SHOTWELL ST | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 4x4 | 6008062 | 2103972 | 37.757561731467 | -122.415129229314 | (37.757561731467, -122.415129229314) | 2 | 4 | 7 | 28859 | 19 | ||||
189327 | 24933 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2099X Post St | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | 13 | 6 | 11 | 29490 | 13 | |||
7677 | 258687 | Property Tree 8 | Acacia melanoxylon :: Blackwood Acacia 70 | 100x Whitney Young Cir | 9 | Sidewalk: Curb side : Yard | Tree | SFUSD 4 | 3x3 | 6016360 | 2096059 | 37.7362970999571 | -122.385879567348 | (37.7362970999571, -122.385879567348) | 10 | 3 | 8 | 58 | 1 | ||||
7851 | 220311 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 4235 19th St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 18 | Width 3ft | 6001938.02984 | 2104676.35813 | 37.7591496745354 | -122.436358769151 | (37.7591496745354, -122.436358769151) | 2 | 4 | 5 | 28862 | 3 | |||
8962 | 116061 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2100x 19th St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 16 | 3x3 | 6011385.89017 | 2105128.48272 | 37.7609234092204 | -122.403715181115 | (37.7609234092204, -122.403715181115) | 10 | 3 | 8 | 28856 | 29 | ||
12066 | 258686 | Property Tree 8 | Acacia melanoxylon :: Blackwood Acacia 70 | 100x Whitney Young Cir | 8 | Sidewalk: Curb side : Yard | Tree | SFUSD 4 | 3x3 | 6016360 | 2096059 | 37.7362970999571 | -122.385879567348 | (37.7362970999571, -122.385879567348) | 10 | 3 | 8 | 58 | 1 | ||||
12179 | 220312 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 4235 19th St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 15 | Width 3ft | 6002007.42492 | 2104678.29116 | 37.7591589249724 | -122.436118906483 | (37.7591589249724, -122.436118906483) | 2 | 4 | 5 | 28862 | 3 | |||
22336 | 98569 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 301X Francisco St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |||
30715 | 73286 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1600X GREEN ST | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/20/1999 12:00:00 AM | 8 | 3x3 | 6005364 | 2118556 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | 13 | 9 | 1 | 57 | 17 | |
37806 | 71177 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 4235 19th St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 08/05/1995 12:00:00 AM | 12 | 4x4 | 6001944.69626247 | 2104668.40530987 | 37.7591282168027 | -122.436335144342 | (37.7591282168027, -122.436335144342) | 2 | 4 | 5 | 28862 | 3 | |
45359 | 96211 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 201X Diamond St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 14 | 4x4 | 6001762.6 | 2104666.8 | 37.759113460692 | -122.436964804087 | (37.759113460692, -122.436964804087) | 2 | 4 | 5 | 28862 | 3 | ||
46043 | 96215 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 200X Collingwood St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 26 | 4x4 | 6002035.7 | 2104682 | 37.7591707149085 | -122.436021383266 | (37.7591707149085, -122.436021383266) | 2 | 4 | 5 | 28862 | 3 | ||
52590 | 73289 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1600X GREEN ST | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/20/1999 12:00:00 AM | 10 | 3x3 | 6005364 | 2118556 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | 13 | 9 | 1 | 57 | 17 | |
65057 | 142547 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 301 FRANCISCO ST | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 20 | Width 0ft | 6009612.5597 | 2121193.6724 | 37.8049353736756 | -122.410983109438 | (37.8049353736756, -122.410983109438) | 3 | 1 | 10 | 308 | 23 | |||
66275 | 142545 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 301 FRANCISCO ST | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 20 | Width 0ft | 6009562.3577 | 2121186.5007 | 37.8049128667558 | -122.411156332795 | (37.8049128667558, -122.411156332795) | 3 | 1 | 10 | 308 | 23 | |||
68625 | 96214 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 200X Collingwood St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 20 | 3x3 | 6002035.7 | 2104682 | 37.7591707149085 | -122.436021383266 | (37.7591707149085, -122.436021383266) | 2 | 4 | 5 | 28862 | 3 | ||
69126 | 102186 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 3999X Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 6008408 | 2096514 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | 10 | 7 | 7 | 28859 | 2 | ||
74212 | 93121 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 151X Palm Ave | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 9 | 3x3 | 5995892.67419 | 2113127.59534 | 37.7820092173573 | -122.457877934554 | (37.7820092173573, -122.457877934554) | 11 | 6 | 1 | 54 | 31 | ||
82737 | 42644 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1600X GREEN ST | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/26/2000 12:00:00 AM | 10 | 3x3 | 6005364 | 2118556 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | 13 | 9 | 1 | 57 | 17 | |
95651 | 73287 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1600X GREEN ST | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/20/1999 12:00:00 AM | 8 | 3x3 | 6005364 | 2118556 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | 13 | 9 | 1 | 57 | 17 | |
98383 | 96212 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 201X Diamond St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 14 | 4x4 | 6001762.6 | 2104666.8 | 37.759113460692 | -122.436964804087 | (37.759113460692, -122.436964804087) | 2 | 4 | 5 | 28862 | 3 | ||
112205 | 74759 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 250 Foerster St | 13 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/15/1999 12:00:00 AM | 30 | 5x7 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 | |
121802 | 96216 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 200X Collingwood St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 4x4 | 6002035.7 | 2104682 | 37.7591707149085 | -122.436021383266 | (37.7591707149085, -122.436021383266) | 2 | 4 | 5 | 28862 | 3 | ||
130847 | 98743 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 155 Masonic Ave | 5 | Sidewalk: Property side : | Tree | SFUSD 4 | DPW for City Agency | 5998843.8 | 2112455 | 37.7803315496091 | -122.447619999218 | (37.7803315496091, -122.447619999218) | 15 | 6 | 2 | 54 | 16 | ||||
132313 | 73528 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 4235 19th St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 08/05/1995 12:00:00 AM | 12 | 4x4 | 6001944.69626247 | 2104668.40530987 | 37.7591282168027 | -122.436335144342 | (37.7591282168027, -122.436335144342) | 2 | 4 | 5 | 28862 | 3 | |
137680 | 98571 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 301X Francisco St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |||
160561 | 102187 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 3999X Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 6008408 | 2096514 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | 10 | 7 | 7 | 28859 | 2 | ||
176204 | 73285 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1600X GREEN ST | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/20/1999 12:00:00 AM | 13 | 3x3 | 6005364 | 2118556 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | 13 | 9 | 1 | 57 | 17 | |
180518 | 42642 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1600X GREEN ST | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/26/2000 12:00:00 AM | 5 | 3x3 | 6005364 | 2118556 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | 13 | 9 | 1 | 57 | 17 | |
183898 | 73288 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1600X GREEN ST | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/20/1999 12:00:00 AM | 8 | 3x3 | 6005364 | 2118556 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | 13 | 9 | 1 | 57 | 17 | |
189331 | 92957 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 300 Seneca Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 12/23/2009 12:00:00 AM | 20 | 3x3 | Permit Number 53118 | 5999177.1 | 2091098.3 | 37.7217103076746 | -122.444931280306 | (37.7217103076746, -122.444931280306) | 9 | 7 | 6 | 28861 | 25 | |
190901 | 92956 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 300 Seneca Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 12/23/2009 12:00:00 AM | 20 | 3x3 | Permit Number 53118 | 5999177.1 | 2091098.3 | 37.7217103076746 | -122.444931280306 | (37.7217103076746, -122.444931280306) | 9 | 7 | 6 | 28861 | 25 | |
177 | 253253 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 99X Lopez Ave | 4 | Front Yard : Yard | Tree | Private 2 | 10x10 | 5994049 | 2100330 | 37.746764271907 | -122.463327202712 | (37.746764271907, -122.463327202712) | 1 | 8 | 4 | 29491 | 40 | ||||
385 | 138469 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1701 PIERCE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6002045.7135 | 2114397.2192 | 37.7858468609583 | -122.43668217767 | (37.7858468609583, -122.43668217767) | 13 | 6 | 1 | 29490 | 27 | |||
458 | 125288 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 943 Green St | 11 | Side Yard : Yard | Tree | Private 2 | 1 | 6008674.79926 | 2118995.08989 | 37.7988459853112 | -122.414072708211 | (37.7988459853112, -122.414072708211) | 5 | 1 | 10 | 308 | 21 | ||||
553 | 12808 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2112 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 5 | 5988878.34651 | 2114712.3148 | 37.7859549296707 | -122.482260152644 | (37.7859549296707, -122.482260152644) | 11 | 6 | 1 | 55 | 33 | |||
609 | 203926 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1799X 12th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 3ft | 5992472.81762 | 2103516.18857 | 37.7554217903919 | -122.469009276583 | (37.7554217903919, -122.469009276583) | 1 | 8 | 4 | 56 | 12 | |||
717 | 124802 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2720 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 5999891.10935 | 2118493.83248 | 37.7969724043147 | -122.444431001117 | (37.7969724043147, -122.444431001117) | 13 | 9 | 1 | 57 | 17 | |||
729 | 203987 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1520 Portola Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5992392.5651 | 2096889.45083 | 37.7372218288298 | -122.46880462056 | (37.7372218288298, -122.46880462056) | 1 | 8 | 4 | 59 | 40 | |||
756 | 124716 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2195 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 |
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) );