Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSiteInfo, qCaretaker, qCareAssistant, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 613 | 613 | 20019 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 10ST | ||||||||
| 1109 | 1109 | 20024 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10ST | ||||||||
| 1647 | 1647 | 20023 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10ST | ||||||||
| 3819 | 3819 | 19829 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY25 | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 60X | ||||||||
| 6492 | 6492 | 20389 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 262X Sunset Blvd | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 6746 | 6746 | 20018 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10ST | ||||||||
| 7838 | 7838 | 20021 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10ST | ||||||||
| 8001 | 8001 | 20026 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 10ST | ||||||||
| 8245 | 8245 | 20020 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 10ST | ||||||||
| 8435 | 8435 | 19808 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY23 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 8460 | 8460 | 20385 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 262X Sunset Blvd | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 11007 | 11007 | 19809 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY23 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 11209 | 11209 | 20386 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 262X Sunset Blvd | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 11240 | 11240 | 19966 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY41 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
| 11825 | 11825 | 20029 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY50 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 40ST | ||||||||
| 12211 | 12211 | 20025 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10ST | ||||||||
| 12986 | 12986 | 19789 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY19 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 50ST | ||||||||
| 15553 | 15553 | 20453 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 495X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 16079 | 16079 | 19828 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY25 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 60X | ||||||||
| 16094 | 16094 | 20027 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 10ST | ||||||||
| 16846 | 16846 | 20022 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10ST | ||||||||
| 12609 | 12609 | 774 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1500X 37th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3 | 5984689.126 | 2104618.0173 | 37.7579943042171 | -122.496008531807 | (37.7579943042171, -122.496008531807) | |||
| 110502 | 110502 | 20519 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10 | 5984732.1426283 | 2106336.4245009 | 37.7627150896217 | -122.495986533771 | (37.7627150896217, -122.495986533771) | |||
| 11295 | 11295 | 773 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1500X 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3 | 5984696.2443 | 2104420.7984 | 37.7574532129065 | -122.495969365063 | (37.7574532129065, -122.495969365063) | |||
| 115888 | 115888 | 775 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1600X 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x10 | 5984704.195086701 | 2104278.9815788995 | 37.7570642890053 | -122.495931406805 | (37.7570642890053, -122.495931406805) | |||
| 10745 | 10745 | 776 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1600X 37th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3 | 5984705.3515 | 2104090.9487 | 37.7565480706746 | -122.49591353675899 | (37.7565480706746, -122.495913536759) | |||
| 91280 | 91280 | 20611 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1403X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 5984795.0202245 | 2105623.5542948004 | 37.7607614301436 | -122.495716480052 | (37.7607614301436, -122.495716480052) | ||||
| 78097 | 78097 | 20683 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1503X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10 | 5984815.4830729 | 2104956.7094961004 | 37.758931658696106 | -122.49559652289 | (37.7589316586961, -122.49559652289) | |||
| 122635 | 122635 | 20681 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1503X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10 | 5984815.4830729 | 2104956.7094961004 | 37.758931658696106 | -122.49559652289 | (37.7589316586961, -122.49559652289) | |||
| 85770 | 85770 | 20843 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1803X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10 | 5984917.659181099 | 2102927.8209446 | 37.7533668754054 | -122.495093546212 | (37.7533668754054, -122.495093546212) | |||
| 121696 | 121696 | 20846 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1803X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 10 | 5984917.659181099 | 2102927.8209446 | 37.7533668754054 | -122.495093546212 | (37.7533668754054, -122.495093546212) | |||
| 80479 | 80479 | 20923 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1903X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10 | 5984941.4072484 | 2102249.5254402 | 37.751505852825105 | -122.49496141157199 | (37.7515058528251, -122.494961411572) | |||
| 97019 | 97019 | 21092 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2200X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10 | 5984939.7729333 | 2100224.5013029 | 37.7459455943524 | -122.494817774566 | (37.7459455943524, -122.494817774566) | |||
| 111458 | 111458 | 21090 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2200X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10 | 5984939.7729333 | 2100224.5013029 | 37.7459455943524 | -122.494817774566 | (37.7459455943524, -122.494817774566) | |||
| 90510 | 90510 | 21015 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2005X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10 | 5984974.2355899 | 2101546.5171136 | 37.7495775063784 | -122.49479606228901 | (37.7495775063784, -122.494796062289) | |||
| 79195 | 79195 | 21052 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2103X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 5984987.6230272995 | 2100889.8482373003 | 37.7477752566644 | -122.494701361992 | (37.7477752566644, -122.494701361992) | ||||
| 108679 | 108679 | 21058 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2103X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 10 | 5984987.6230272995 | 2100889.8482373003 | 37.7477752566644 | -122.494701361992 | (37.7477752566644, -122.494701361992) | |||
| 124152 | 124152 | 21123 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2203X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10 | 5985013.335853799 | 2100217.4790898 | 37.745930619038 | -122.49456289016199 | (37.745930619038, -122.494562890162) | |||
| 93273 | 93273 | 21282 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2492X Sunset Blvd | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984994.4282385 | 2098239.2478178 | 37.740497824548 | -122.494482465671 | (37.740497824548, -122.494482465671) | |||
| 87108 | 87108 | 21258 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2403X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 10 | 5985057.6849307995 | 2098850.8710983 | 37.7421808791716 | -122.49430882372101 | (37.7421808791716, -122.494308823721) | |||
| 141903 | 141903 | 21256 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2403X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10 | 5985057.6849307995 | 2098850.8710983 | 37.7421808791716 | -122.49430882372101 | (37.7421808791716, -122.494308823721) | |||
| 11420 | 11420 | 745 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2201X 36th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 6 | 5985120.8379 | 2099719.0966 | 37.7445684872167 | -122.49415444151501 | (37.7445684872167, -122.494154441515) | |||
| 83201 | 83201 | 21481 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2792X Sunset Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | 60 | 5985060.3629888 | 2096294.4798015 | 37.735161871163605 | -122.49411119238 | (37.7351618711636, -122.49411119238) | |||
| 92020 | 92020 | 21482 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2792X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | 5985060.3629888 | 2096294.4798015 | 37.735161871163605 | -122.49411119238 | (37.7351618711636, -122.49411119238) | |||
| 140921 | 140921 | 21502 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2800X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | 5985062.8642150005 | 2096221.8871717 | 37.7349626975104 | -122.494097196305 | (37.7349626975104, -122.494097196305) | |||
| 12421 | 12421 | 748 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2301X 36th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 6 | 5985137.3758 | 2099321.1031 | 37.7434766724968 | -122.49406793054101 | (37.7434766724968, -122.494067930541) | |||
| 1022 | 1022 | 186874 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2700 Sunset Blvd | 23 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | Width 0ft | 5985204.8462 | 2096382.2812 | 37.7354114037883 | -122.493618136413 | (37.7354114037883, -122.493618136413) | |||
| 1059 | 1059 | 186952 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2800 Sunset Blvd | 26 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 0ft | 5985204.8226 | 2096075.4539 | 37.734568936321295 | -122.493595616872 | (37.7345689363213, -122.493595616872) | |||
| 79387 | 79387 | 3431 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 7050X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5985752.92206 | 2113916.9124 | 37.7835886933669 | -122.493014498456 | (37.7835886933669, -122.493014498456) | |||
| 141992 | 141992 | 89458 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3500X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2008 12:00:00 AM | 3 | 3x3 | 5987773.9063 | 2111900.8711599996 | 37.7781711994801 | -122.48587473348199 | (37.7781711994801, -122.485874733482) | ||
| 116672 | 116672 | 12832 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2235 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 5988502.58806 | 2114642.48988 | 37.7857413464655 | -122.48355503729601 | (37.7857413464655, -122.483555037296) | |||
| 81565 | 81565 | 443 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 700x 23rd Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5988815.988030001 | 2110428.99683 | 37.774190512498706 | -122.482161976658 | (37.7741905124987, -122.482161976658) | ||||
| 83214 | 83214 | 448 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 700x 23rd Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5988818.05287 | 2110350.21953 | 37.773974331987795 | -122.482149061597 | (37.7739743319878, -122.482149061597) | ||||
| 101608 | 101608 | 12762 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1751 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 6x6 | 5989957.85733 | 2114699.21061 | 37.7859816817318 | -122.47852442318998 | (37.7859816817318, -122.47852442319) | |||
| 89238 | 89238 | 12750 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1720 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 5990071.960109999 | 2114756.1152 | 37.7861445495756 | -122.47813382493601 | (37.7861445495756, -122.478133824936) | |||
| 87295 | 87295 | 12751 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1727 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 5990092.02527 | 2114693.69814 | 37.785974334529904 | -122.47805984057301 | (37.7859743345299, -122.478059840573) | |||
| 114471 | 114471 | 12744 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1650 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 4x25 | 5990276.45859 | 2114764.20795 | 37.7861786381279 | -122.477426913666 | (37.7861786381279, -122.477426913666) | |||
| 126395 | 126395 | 12739 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1637 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5990329.442419999 | 2114713.68905 | 37.7860430016299 | -122.477239912272 | (37.7860430016299, -122.477239912272) | |||
| 125152 | 125152 | 12736 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1625 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 5990372.3863 | 2114714.93418 | 37.786048911894795 | -122.477091430633 | (37.7860489118948, -122.477091430633) | |||
| 100426 | 100426 | 199 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1621X Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 5990403.2095800005 | 2114714.97277 | 37.7860508060194 | -122.476984794344 | (37.7860508060194, -122.476984794344) | |||
| 87328 | 87328 | 12735 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1621 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | 4X4PL | 5990407.540990001 | 2114714.05082 | 37.7860485258756 | -122.47696974160101 | (37.7860485258756, -122.476969741601) | |||
| 143064 | 143064 | 12729 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1600 Lake St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 5990435.001209999 | 2114760.85795 | 37.786178638116 | -122.47687815891899 | (37.786178638116, -122.476878158919) | |||
| 117156 | 117156 | 29742 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1600 Lake St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 5990444.69382 | 2114760.65318 | 37.786178638127204 | -122.47684461043 | (37.7861786381272, -122.47684461043) | ||||
| 125837 | 125837 | 12727 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1600 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 4X4 | 5990457.1993 | 2114785.86556 | 37.7862485896694 | -122.476803188002 | (37.7862485896694, -122.476803188002) | |||
| 88164 | 88164 | 12734 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1600 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/23/2015 12:00:00 AM | 3 | 3X3 | 5990479.84568 | 2114768.877 | 37.7862032574553 | -122.476723596597 | (37.7862032574553, -122.476723596597) | ||
| 82334 | 82334 | 294 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3451X 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 2X2 | 5990184.74118 | 2092923.50312 | 37.7262045448252 | -122.476148412917 | (37.7262045448252, -122.476148412917) | |||
| 85625 | 85625 | 382 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3721X 19th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 2 | 5990351.3309 | 2090950.31436 | 37.72079632016629 | -122.475428522866 | (37.7207963201663, -122.475428522866) | |||
| 854 | 854 | 203901 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3794 19th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 12 | Width 3ft | 5990470.121669999 | 2090714.3108400002 | 37.720155198286 | -122.475000685058 | (37.720155198286, -122.475000685058) | |||
| 85780 | 85780 | 396 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3790X 19th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 2 | 5990481.42225 | 2090722.77019 | 37.7201790804753 | -122.474962240321 | (37.7201790804753, -122.474962240321) | |||
| 45609 | 45609 | 369 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3690X 19th Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 25 | 2 | 5990489.74295 | 2091103.38095 | 37.7212246253626 | -122.474961247113 | (37.7212246253626, -122.474961247113) | ||
| 98662 | 98662 | 358 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3690X 19th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 2 | 5990489.74295 | 2091103.38095 | 37.7212246253626 | -122.474961247113 | (37.7212246253626, -122.474961247113) | |||
| 142135 | 142135 | 339 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3590X 19th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 2 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | |||
| 128477 | 128477 | 324 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3470X 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/23/2008 12:00:00 AM | 20 | 2 | 5990579.05408 | 2092494.4249099998 | 37.725049260991604 | -122.474754004974 | (37.7250492609916, -122.474754004974) | ||
| 4446 | 4446 | 253627 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 44 Stonecrest Dr | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3x3 | 5991061.0 | 2093828.0 | 37.7287388406121 | -122.4731851996 | (37.7287388406121, -122.4731851996) | ||||
| 9667 | 9667 | 11795 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200X Junipero Serra Blvd | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 5991118.2706518 | 2089586.5464946998 | 37.7170961765154 | -122.472678089933 | (37.7170961765154, -122.472678089933) | ||||
| 99816 | 99816 | 11794 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200X Junipero Serra Blvd | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 2 | 5991118.2706518 | 2089586.5464946998 | 37.7170961765154 | -122.472678089933 | (37.7170961765154, -122.472678089933) | |||
| 114205 | 114205 | 114109 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200X Junipero Serra Blvd | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 5991118.2706518 | 2089586.5464946998 | 37.7170961765154 | -122.472678089933 | (37.7170961765154, -122.472678089933) | ||||
| 120454 | 120454 | 11793 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200X Junipero Serra Blvd | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2 | 5991118.2706518 | 2089586.5464946998 | 37.7170961765154 | -122.472678089933 | (37.7170961765154, -122.472678089933) | |||
| 109591 | 109591 | 115677 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200x Junipero Serra Blvd | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 5991123.2 | 2089585.5 | 37.717093588438 | -122.472660975441 | (37.717093588438, -122.472660975441) | ||||
| 18211 | 18211 | 11709 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 700X Junipero Serra Blvd | 26 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 6X6 | 5991284.83406 | 2092750.4086799999 | 37.7257930014245 | -122.472332875878 | (37.7257930014245, -122.472332875878) | ||
| 115881 | 115881 | 11755 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 901X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X4 | 5991288.1161497 | 2091224.4470027 | 37.7216032788517 | -122.472210346501 | (37.7216032788517, -122.472210346501) | |||
| 21068 | 21068 | 29972 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 500X Junipero Serra Blvd | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/2007 12:00:00 AM | 3 | 3x3 | 5991341.172 | 2093706.68724 | 37.7284219643784 | -122.47220779725299 | (37.7284219643784, -122.472207797253) | ||
| 21937 | 21937 | 29584 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 500X Junipero Serra Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/12/2016 12:00:00 AM | 3 | 3X3 | 5991345.88941 | 2093701.3780900002 | 37.728407659786 | -122.47219110225299 | (37.728407659786, -122.472191102253) | ||
| 126877 | 126877 | 11850 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1401X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3 | 5991539.129622 | 2088082.4465586997 | 37.712990637147605 | -122.471113878415 | (37.7129906371476, -122.471113878415) | |||
| 139321 | 139321 | 11851 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1401X Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3 | 5991539.129622 | 2088082.4465586997 | 37.712990637147605 | -122.471113878415 | (37.7129906371476, -122.471113878415) | |||
| 88947 | 88947 | 4806 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 260 Corona St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 35 | 5992988.2755218 | 2092740.8940691003 | 37.7258653179999 | -122.46644356219299 | (37.7258653179999, -122.466443562193) | |||
| 91586 | 91586 | 4807 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 260 Corona St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 35 | 5992988.2755218 | 2092740.8940691003 | 37.7258653179999 | -122.46644356219299 | (37.7258653179999, -122.466443562193) | |||
| 108562 | 108562 | 4809 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 260 Corona St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 35 | 5992988.2755218 | 2092740.8940691003 | 37.7258653179999 | -122.46644356219299 | (37.7258653179999, -122.466443562193) | |||
| 111013 | 111013 | 4808 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 260 Corona St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 35 | 5992988.2755218 | 2092740.8940691003 | 37.7258653179999 | -122.46644356219299 | (37.7258653179999, -122.466443562193) | |||
| 73683 | 73683 | 203961 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 200x Dorantes Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 38 | Width 3ft | 5993559.03115 | 2099734.05216 | 37.745099710091296 | -122.4649781788 | (37.7450997100913, -122.4649781788) | |||
| 133316 | 133316 | 203782 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 66x Santa Monica Way | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 5993630.457230001 | 2097428.51442 | 37.7387734012664 | -122.46456382517599 | (37.7387734012664, -122.464563825176) | ||||
| 126758 | 126758 | 203783 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 198x San Anselmo Ave | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 5993617.28141 | 2096303.72288 | 37.735684244431795 | -122.464527731782 | (37.7356842444318, -122.464527731782) | ||||
| 165803 | 165803 | 203827 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 200x Terrace Dr | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 5993824.2375 | 2096507.58297 | 37.7362559218691 | -122.463827002518 | (37.7362559218691, -122.463827002518) | ||||
| 174842 | 174842 | 203828 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 200x Terrace Dr | 32 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 5993850.84574 | 2096478.66288 | 37.7361780477826 | -122.463732909161 | (37.7361780477826, -122.463732909161) | ||||
| 30436 | 30436 | 203829 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 200x Terrace Dr | 41 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 5993865.8273 | 2096513.9581 | 37.7362758229773 | -122.463683673072 | (37.7362758229773, -122.463683673072) | ||||
| 133432 | 133432 | 203808 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 335x Pacheco St | 30 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 8ft | 5994148.64523 | 2101441.5060099997 | 37.7498219260394 | -122.46306327486 | (37.7498219260394, -122.46306327486) | |||
| 133052 | 133052 | 203807 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 335x Pacheco St | 20 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 8ft | 5994179.6676199995 | 2101287.15386 | 37.7493999011887 | -122.46294480178699 | (37.7493999011887, -122.462944801787) | |||
| 90438 | 90438 | 11451 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 30 ARGUELLO BLVD | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X12 | 5995510.0 | 2115730.0 | 37.789132728017 | -122.45939032806801 | (37.789132728017, -122.459390328068) | |||
| 114004 | 114004 | 11450 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 30X ARGUELLO BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X12 | 5995510.0 | 2115730.0 | 37.789132728017 | -122.45939032806801 | (37.789132728017, -122.459390328068) | |||
| 101463 | 101463 | 11447 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2X Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3 | 5995514.85453 | 2115936.98374 | 37.789701328403794 | -122.459388527967 | (37.7897013284038, -122.459388527967) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");