trees
1,626 rows where qSpecies_id = 53 sorted by qCareAssistant 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7742 | 21626 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1610 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004833.69671 | 2114745.44523 | 37.7869610478907 | -122.427061339905 | (37.7869610478907, -122.427061339905) | 13 | 9 | 11 | 28858 | 27 | |||
| 8209 | 103628 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1450X Stevenson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 777592 | 6006328.29748 | 2108087.53462 | 37.7687644406503 | -122.421417350008 | (37.7687644406503, -122.421417350008) | 8 | 4 | 7 | 28853 | 19 | ||
| 8269 | 99967 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2270 Folsom St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007986.9 | 2105322.2 | 37.7612648499102 | -122.415484545241 | (37.7612648499102, -122.415484545241) | 2 | 4 | 7 | 28859 | 19 | |||||
| 8384 | 104821 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2173 15TH ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 6003063.7 | 2107068.1 | 37.7657807169148 | -122.432636512343 | (37.7657807169148, -122.432636512343) | 15 | 5 | 5 | 28862 | 3 | |||||
| 8496 | 115992 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 438 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2016 12:00:00 AM | 3 | Permit Number 778644 | 5989723.9 | 2112354.3 | 37.7795296278249 | -122.479162248453 | (37.7795296278249, -122.479162248453) | 11 | 6 | 2 | 55 | 26 | ||
| 8565 | 105233 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1508 WALLER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 5998474.1 | 2108297 | 37.7688936152058 | -122.448599407064 | (37.7688936152058, -122.448599407064) | 15 | 5 | 11 | 29492 | 9 | |||
| 8874 | 15149 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 895X Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 12 | 4x4 | 6010810.7123748 | 2113108.5528643 | 37.7828026992214 | -122.406266743907 | (37.7828026992214, -122.406266743907) | 12 | 2 | 9 | 28853 | 34 | |||
| 8959 | 113224 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 4244 23RD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001623 | 2102374 | 37.7528100494278 | -122.437283434624 | (37.7528100494278, -122.437283434624) | 2 | 4 | 5 | 28862 | 22 | ||||
| 9194 | 260391 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 550 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6005467 | 2111269 | 37.7774513766157 | -122.424622861078 | (37.7774513766157, -122.424622861078) | 7 | 9 | 11 | 28852 | 10 | ||||
| 9205 | 96542 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 100 Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 767720 | 6013094 | 2116579 | 37.7924591936564 | -122.398611089295 | (37.7924591936564, -122.398611089295) | 4 | 1 | 10 | 28860 | 6 | ||||
| 9438 | 115058 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 499X BRANNAN ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013762 | 2111312 | 37.7780344196247 | -122.395930522096 | (37.7780344196247, -122.395930522096) | 6 | 2 | 9 | 28856 | 34 | ||||
| 9626 | 258963 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 398x Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014405 | 2113268 | 37.7834409032593 | -122.393843088876 | (37.7834409032593, -122.393843088876) | 6 | 2 | 9 | 28856 | 6 | ||||
| 9664 | 258964 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 398x Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014405 | 2113268 | 37.7834409032593 | -122.393843088876 | (37.7834409032593, -122.393843088876) | 6 | 2 | 9 | 28856 | 6 | ||||
| 10154 | 258967 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 398x Bryant St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014405 | 2113268 | 37.7834409032593 | -122.393843088876 | (37.7834409032593, -122.393843088876) | 6 | 2 | 9 | 28856 | 6 | ||||
| 10358 | 120965 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1145x Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003243 | 2101623 | 37.7508399403415 | -122.43162756863 | (37.7508399403415, -122.43162756863) | 2 | 4 | 5 | 28862 | 22 | ||||
| 10459 | 16731 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 19X Hollis St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 4X4 | 6003892.01293 | 2113485.99196 | 37.7834496108007 | -122.4302294651 | (37.7834496108007, -122.4302294651) | 7 | 9 | 11 | 29490 | 41 | |||
| 10644 | 260392 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 550 Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6005467 | 2111269 | 37.7774513766157 | -122.424622861078 | (37.7774513766157, -122.424622861078) | 7 | 9 | 11 | 28852 | 10 | ||||
| 10859 | 102456 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3365 20th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6007790 | 2104415 | 37.7587628183764 | -122.416101290754 | (37.7587628183764, -122.416101290754) | 2 | 4 | 7 | 28859 | 19 | |||
| 11093 | 95037 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 8 | Sidewalk: Property side : Cutout | Tree | Dept of Real Estate 7 | 10 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | |||
| 11207 | 108105 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2390X Green St | 7 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6001806.63782 | 2118043.59498 | 37.7958452773357 | -122.437770563269 | (37.7958452773357, -122.437770563269) | 13 | 9 | 1 | 57 | 17 | |||||
| 11231 | 57646 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 666 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/1981 12:00:00 AM | 16 | 7x7 | Permit Number 19439 | 6005402.5793 | 2111576.4092 | 37.7782918087921 | -122.424867589608 | (37.7782918087921, -122.424867589608) | 7 | 9 | 11 | 28852 | 10 | |
| 11284 | 117186 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 201x GREENWICH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6011833 | 2120374 | 37.8028090150843 | -122.40324129087 | (37.8028090150843, -122.40324129087) | 3 | 1 | 10 | 308 | 23 | ||||
| 11335 | 112269 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1X Geary St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
| 11487 | 260838 | Significant Tree 6 | Ficus nitida :: Laurel Fig 53 | 399 Laurel St | 1 | Side Yard : Cutout | Tree | Private 2 | 3x3 | 5998076 | 2115238 | 37.7879290262693 | -122.45047684944 | (37.7879290262693, -122.45047684944) | 11 | 6 | 1 | 54 | 31 | ||||
| 11514 | 258968 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 398x Bryant St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014405 | 2113268 | 37.7834409032593 | -122.393843088876 | (37.7834409032593, -122.393843088876) | 6 | 2 | 9 | 28856 | 6 | ||||
| 11744 | 56147 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2311 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/1973 12:00:00 AM | 16 | Permit Number 12254 | 6001277.58181 | 2116437.20889 | 37.7914044631939 | -122.439485981699 | (37.7914044631939, -122.439485981699) | 13 | 6 | 1 | 29490 | 27 | ||
| 11809 | 7237 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1065 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003359.4574 | 2111944.18191 | 37.7791860077197 | -122.431961766737 | (37.7791860077197, -122.431961766737) | 15 | 9 | 11 | 29490 | 41 | |||
| 11874 | 110985 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 245x North Point St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009556.06624176 | 2121873.83782792 | 37.8067997698403 | -122.41122668881 | (37.8067997698403, -122.41122668881) | 3 | 1 | 10 | 308 | 23 | |||||
| 11986 | 95043 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 4 | Sidewalk: Property side : Cutout | Tree | DPW for City Agency 14 | 9 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | |||
| 12493 | 140066 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 614 Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6005423.0428 | 2111393.287 | 37.7777901557735 | -122.424783767818 | (37.7777901557735, -122.424783767818) | 7 | 9 | 11 | 28852 | 10 | |||
| 12511 | 260840 | Significant Tree 6 | Ficus nitida :: Laurel Fig 53 | 399 Laurel St | 3 | Side Yard : Cutout | Tree | Private 2 | 3x3 | 5998076 | 2115238 | 37.7879290262693 | -122.45047684944 | (37.7879290262693, -122.45047684944) | 11 | 6 | 1 | 54 | 31 | ||||
| 12765 | 117400 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 75x BEACH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009846 | 2122112 | 37.8074699595292 | -122.410240137563 | (37.8074699595292, -122.410240137563) | 3 | 1 | 10 | 308 | 23 | ||||
| 13077 | 34262 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3618 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | 14 | 3x3 | Permit Number 38067 | 6002793.22003166 | 2106527.80070587 | 37.7642818435653 | -122.433533428216 | (37.7642818435653, -122.433533428216) | 15 | 5 | 5 | 28862 | 3 | |
| 13161 | 4609 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 316 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2015 12:00:00 AM | 3 | 3X3 | Permit Number 774670 | 6010771.0363 | 2118706.95943 | 37.7981723635161 | -122.406798689949 | (37.7981723635161, -122.406798689949) | 3 | 1 | 10 | 308 | 23 | |
| 13231 | 248334 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1569 Waller St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5998104.0324 | 2108202.8007 | 37.7686138007777 | -122.449872650062 | (37.7686138007777, -122.449872650062) | 15 | 5 | 11 | 29492 | 9 | |||
| 13236 | 92386 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2810 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/2015 12:00:00 AM | 3 | 4x4 | Permit Number 774470 | 6001269 | 2116290 | 37.7909997773984 | -122.439505117215 | (37.7909997773984, -122.439505117215) | 13 | 6 | 1 | 29490 | 27 | |
| 13581 | 113413 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 16X LEROY PL | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 1x1 | 6008359 | 2116497 | 37.7919691052865 | -122.414988572568 | (37.7919691052865, -122.414988572568) | 5 | 1 | 10 | 28858 | 21 | |||
| 13713 | 9943 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 601X Green St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 6x5 | 6010129.67767 | 2119173.05666 | 37.7994162456962 | -122.409050895178 | (37.7994162456962, -122.409050895178) | 3 | 1 | 10 | 308 | 4 | |||
| 13855 | 260394 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 550 Octavia St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6005467 | 2111269 | 37.7774513766157 | -122.424622861078 | (37.7774513766157, -122.424622861078) | 7 | 9 | 11 | 28852 | 10 | ||||
| 14128 | 16935 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 542 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6004164.66828 | 2110140.85762 | 37.7742801386068 | -122.429047601533 | (37.7742801386068, -122.429047601533) | 7 | 9 | 11 | 28852 | 10 | |||
| 14200 | 33719 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 27 Germania St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1996 12:00:00 AM | 13 | Permit Number 37787 | 6004127.51235208 | 2108864.68166901 | 37.7707739677449 | -122.429085120408 | (37.7707739677449, -122.429085120408) | 7 | 9 | 11 | 29492 | 10 | ||
| 14328 | 104230 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 409 Walnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14x8 | 5998587.6 | 2115205.6 | 37.787869332154 | -122.448704479556 | (37.787869332154, -122.448704479556) | 13 | 6 | 1 | 54 | 31 | ||||
| 14444 | 7238 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1085 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 4X4 | 6003353.84267 | 2112023.38614 | 37.7794031644909 | -122.431986847688 | (37.7794031644909, -122.431986847688) | 15 | 9 | 11 | 29490 | 41 | |||
| 14581 | 4695 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 850X Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 125 | 4x8 | 6008940.69941 | 2120350.97779 | 37.802583847399 | -122.4132485365 | (37.802583847399, -122.4132485365) | 3 | 1 | 10 | 308 | 23 | |||
| 14591 | 17106 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1777 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 5998507.83576 | 2109285.1679 | 37.7716088013494 | -122.448553894841 | (37.7716088013494, -122.448553894841) | 15 | 5 | 11 | 29492 | 9 | |||
| 14802 | 11429 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 810X Mendell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6016007.44377 | 2096780.42114 | 37.7382584597776 | -122.387148815626 | (37.7382584597776, -122.387148815626) | 10 | 3 | 8 | 58 | 1 | |||
| 14874 | 6756 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1215 Fairfax Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | Permit Number 769095 | 6017521.0990665 | 2096743.3718322 | 37.7382404347673 | -122.381912713319 | (37.7382404347673, -122.381912713319) | 10 | 3 | 8 | 58 | 1 | ||
| 14899 | 110708 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2999X Turk St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996638 | 2111487 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | 15 | 6 | 2 | 54 | 16 | ||||
| 14920 | 255508 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1290X Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6003415.08005 | 2112113.96459 | 37.7796553418115 | -122.431781470984 | (37.7796553418115, -122.431781470984) | 15 | 9 | 11 | 29490 | 41 | ||||
| 15062 | 102786 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3345 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4.5x6 | Permit Number 772480 | 6003174.4 | 2119873.2 | 37.8009465759098 | -122.433168646536 | (37.8009465759098, -122.433168646536) | 13 | 9 | 1 | 57 | 17 | ||
| 15375 | 57511 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 636 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/1976 12:00:00 AM | 17 | Permit Number 16364 | 6005408.351 | 2111510.821 | 37.7781120456222 | -122.424842955768 | (37.7781120456222, -122.424842955768) | 7 | 9 | 11 | 28852 | 10 | ||
| 15896 | 140067 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 616 Octavia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6005420.4192 | 2111411.6517 | 37.7778404325738 | -122.424794150591 | (37.7778404325738, -122.424794150591) | 7 | 9 | 11 | 28852 | 10 | |||
| 15941 | 85313 | Significant Tree 6 | Ficus nitida :: Laurel Fig 53 | 610 Brannan St | 1 | unknown : Cutout | Tree | Private 2 | Permit Number 49594 | 6012704.2 | 2110820.8 | 37.7766267904106 | -122.399555358584 | (37.7766267904106, -122.399555358584) | 14 | 2 | 9 | 28856 | 34 | ||||
| 16842 | 261242 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 840 El Camino Del Mar | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/2020 12:00:00 AM | 3 | Width 4ft | 5985843 | 2115056 | 37.786721565729 | -122.492786794237 | (37.786721565729, -122.492786794237) | 11 | 6 | 1 | 55 | 33 | ||
| 16900 | 485 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2706 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6010468.2249 | 2102315.41281 | 37.7531480416193 | -122.406690748371 | (37.7531480416193, -122.406690748371) | 10 | 4 | 7 | 28859 | 19 | |||
| 16987 | 17305 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 51X Otis St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6006870.5020453 | 2109341.6908091 | 37.7722386113234 | -122.419630895813 | (37.7722386113234, -122.419630895813) | 8 | 2 | 9 | 28853 | 19 | |||
| 17055 | 104825 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 45 Prosper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003350 | 2106266 | 37.7635945765505 | -122.431588992909 | (37.7635945765505, -122.431588992909) | 15 | 4 | 5 | 28862 | 3 | |||
| 17682 | 258962 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 398x Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014405 | 2113268 | 37.7834409032593 | -122.393843088876 | (37.7834409032593, -122.393843088876) | 6 | 2 | 9 | 28856 | 6 | ||||
| 18087 | 4603 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 270 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 6010933.33158 | 2118545.7793 | 37.7977388815556 | -122.406225735505 | (37.7977388815556, -122.406225735505) | 3 | 1 | 10 | 308 | 23 | |||
| 18243 | 96948 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 900X Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 6x6 | 6007359.7 | 2102053.2 | 37.7522536530624 | -122.417422091759 | (37.7522536530624, -122.417422091759) | 2 | 4 | 7 | 28859 | 19 | |||
| 18271 | 139433 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 539 OCTAVIA ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6005406.0306 | 2111183.3028 | 37.7772126295238 | -122.424827676313 | (37.7772126295238, -122.424827676313) | 7 | 9 | 11 | 28852 | 10 | |||
| 18422 | 112268 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1X Geary St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
| 18544 | 258969 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 398x Bryant St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014405 | 2113268 | 37.7834409032593 | -122.393843088876 | (37.7834409032593, -122.393843088876) | 6 | 2 | 9 | 28856 | 6 | ||||
| 18607 | 139432 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 539 OCTAVIA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6005403.0601 | 2111196.299 | 37.77724814614 | -122.424838877048 | (37.77724814614, -122.424838877048) | 7 | 9 | 11 | 28852 | 10 | |||
| 18675 | 101715 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 560 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012536 | 2104936 | 37.760459075101 | -122.399723915341 | (37.760459075101, -122.399723915341) | 10 | 3 | 8 | 28856 | 29 | |||||
| 18772 | 115057 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 499X BRANNAN ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013762 | 2111312 | 37.7780344196247 | -122.395930522096 | (37.7780344196247, -122.395930522096) | 6 | 2 | 9 | 28856 | 34 | ||||
| 18979 | 110983 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 245x North Point St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009556.06624176 | 2121873.83782792 | 37.8067997698403 | -122.41122668881 | (37.8067997698403, -122.41122668881) | 3 | 1 | 10 | 308 | 23 | |||||
| 19070 | 15154 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 895X Mission St | 8 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 18 | 4x4 | 6010810.7123748 | 2113108.5528643 | 37.7828026992214 | -122.406266743907 | (37.7828026992214, -122.406266743907) | 12 | 2 | 9 | 28853 | 34 | |||
| 19076 | 99594 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1855X Evans Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6014349.8 | 2099426.2 | 37.7454312840379 | -122.393065244865 | (37.7454312840379, -122.393065244865) | 10 | 3 | 8 | 58 | 1 | |||
| 19494 | 20113 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 800X OAK ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6002934 | 2109937 | 37.7736506563952 | -122.433290134136 | (37.7736506563952, -122.433290134136) | 15 | 5 | 11 | 29492 | 9 | |||
| 19705 | 95415 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 49X South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | Created record for this tree on 2/28/2011 although tree is approxmiately 20 years old. | 6007102.30356 | 2110018.85993 | 37.7741110108752 | -122.418877107651 | (37.7741110108752, -122.418877107651) | 8 | 2 | 9 | 28853 | 19 | ||
| 19799 | 661 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3290X 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6007123.820387 | 2102082.126741 | 37.7523198047665 | -122.418239853186 | (37.7523198047665, -122.418239853186) | 2 | 4 | 7 | 28859 | 19 | |||
| 19867 | 48735 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 36 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1969 12:00:00 AM | Permit Number 46015 | 6001979.18448022 | 2107865.24554965 | 37.7679079189757 | -122.436444672891 | (37.7679079189757, -122.436444672891) | 15 | 5 | 5 | 29492 | 3 | |||
| 20084 | 115908 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 500x WALLER ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2016 12:00:00 AM | 3 | 4x4 | 6003255 | 2109006 | 37.7711125644946 | -122.432113248928 | (37.7711125644946, -122.432113248928) | 15 | 5 | 11 | 29492 | 9 | ||
| 20131 | 113298 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700X DAVIS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013208 | 2119104 | 37.7993985951424 | -122.398393892143 | (37.7993985951424, -122.398393892143) | 3 | 1 | 10 | 28860 | 6 | ||||
| 20147 | 103506 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1348 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6008356 | 2116660 | 37.7924164947138 | -122.415010494885 | (37.7924164947138, -122.415010494885) | 5 | 1 | 10 | 28858 | 21 | |||
| 20262 | 253597 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 269 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010453 | 2107072 | 37.7662077096315 | -122.407078650031 | (37.7662077096315, -122.407078650031) | 8 | 4 | 8 | 28853 | 19 | ||||
| 20310 | 112288 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 895x PAGE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002361 | 2109458 | 37.7723029182135 | -122.435237957834 | (37.7723029182135, -122.435237957834) | 15 | 5 | 11 | 29492 | 9 | ||||
| 20324 | 4630 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 427 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6010279.42625 | 2119026.32466 | 37.7990217431564 | -122.408522353672 | (37.7990217431564, -122.408522353672) | 3 | 1 | 10 | 308 | 4 | |||
| 20364 | 516 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2800 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6010023.971 | 2102231.13329 | 37.7528917628192 | -122.408221130018 | (37.7528917628192, -122.408221130018) | 2 | 4 | 7 | 28859 | 19 | |||
| 20388 | 6375 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 309X Elm St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6006152.1987649 | 2112618.7866796 | 37.7811962356475 | -122.422348456516 | (37.7811962356475, -122.422348456516) | 7 | 9 | 11 | 28852 | 41 | |||
| 20430 | 647 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3244X 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6007408.30918 | 2102098.45375 | 37.7523806444342 | -122.417257199664 | (37.7523806444342, -122.417257199664) | 2 | 4 | 7 | 28859 | 19 | |||
| 20552 | 15171 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 941 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6010472.08374 | 2112774.72891 | 37.7818671496492 | -122.407414720255 | (37.7818671496492, -122.407414720255) | 14 | 2 | 9 | 28853 | 34 | |||
| 20606 | 15650 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3718 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3X3 | 6005292.79028 | 2096596.92241 | 37.7371554485093 | -122.42418178869 | (37.7371554485093, -122.42418178869) | 2 | 7 | 5 | 28859 | 2 | |||
| 20638 | 21644 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1657 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004676.7022509 | 2114666.9735246 | 37.7867367053745 | -122.427598912468 | (37.7867367053745, -122.427598912468) | 13 | 9 | 11 | 28858 | 13 | |||
| 20699 | 17025 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1109 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6001571.2304 | 2109724.9634 | 37.7729910525637 | -122.43798896281 | (37.7729910525637, -122.43798896281) | 15 | 5 | 11 | 29492 | 9 | |||
| 20709 | 109328 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1349 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/2015 12:00:00 AM | 3 | 3x3 | 5999000.5 | 2104870.1 | 37.7595142924854 | -122.446532051538 | (37.7595142924854, -122.446532051538) | 15 | 5 | 5 | 28862 | 12 | ||
| 20820 | 111597 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 398X BRYANT ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014483 | 2113360 | 37.7836978486164 | -122.393579678281 | (37.7836978486164, -122.393579678281) | 6 | 2 | 9 | 28856 | 6 | ||||
| 20994 | 100049 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3233X Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | Permit Number 768990 | 6003300 | 2119605 | 37.8002172925371 | -122.432714848025 | (37.8002172925371, -122.432714848025) | 13 | 9 | 1 | 57 | 17 | ||
| 21029 | 102504 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 290X Hermann St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6003881.1 | 2108703.5 | 37.7703174504719 | -122.429925966233 | (37.7703174504719, -122.429925966233) | 7 | 9 | 11 | 29492 | 10 | ||||
| 21080 | 11033 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1503 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3x3 | 6007448.9758793 | 2117473.8836265 | 37.7946002066648 | -122.418206559463 | (37.7946002066648, -122.418206559463) | 5 | 1 | 10 | 28858 | 32 | |||
| 21287 | 23131 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 610X Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/1999 12:00:00 AM | 3 | 4x4 | 6010622.64357 | 2118948.98987 | 37.7988286159864 | -122.407329246317 | (37.7988286159864, -122.407329246317) | 3 | 1 | 10 | 308 | 23 | ||
| 21359 | 87146 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2405 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 3x3 | Permit Number 50131 | 6008226 | 2104427 | 37.7588202724984 | -122.414594246502 | (37.7588202724984, -122.414594246502) | 2 | 4 | 7 | 28859 | 19 | ||
| 21498 | 98979 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 38 MILEY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 778225 | 5999656 | 2118689 | 37.7974948649915 | -122.4452585722 | (37.7974948649915, -122.4452585722) | 13 | 9 | 1 | 57 | 17 | ||
| 21570 | 7202 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 926 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6003476.58431 | 2111463.23602 | 37.7778720892035 | -122.431522232661 | (37.7778720892035, -122.431522232661) | 15 | 9 | 11 | 29492 | 41 | |||
| 21841 | 111225 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3150x 19TH ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008324 | 2105048 | 37.7605309015758 | -122.41429925401 | (37.7605309015758, -122.41429925401) | 2 | 4 | 7 | 28859 | 19 | |||
| 22585 | 23704 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2119X Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3X3 | 6005103.6033 | 2116867.23334 | 37.7928022043515 | -122.426278644375 | (37.7928022043515, -122.426278644375) | 13 | 9 | 1 | 28858 | 27 | |||
| 22613 | 7891 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1187 Franklin St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6005998.65959 | 2113925.10155 | 37.7847743933389 | -122.422972499839 | (37.7847743933389, -122.422972499839) | 13 | 9 | 11 | 28858 | 41 | |||
| 23258 | 4604 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 270 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 26 | 3x3 | 6010907.72336 | 2118541.73775 | 37.7977263519913 | -122.406314062528 | (37.7977263519913, -122.406314062528) | 3 | 1 | 10 | 308 | 23 | |||
| 23368 | 512 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2790 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6010086.59475 | 2102267.66488 | 37.7529955768562 | -122.408007140426 | (37.7529955768562, -122.408007140426) | 2 | 4 | 7 | 28859 | 19 |
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) );