trees
563 rows where qSpecies_id = 52 sorted by rowid 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 160162 | 33220 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 130 Vasquez Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1996 12:00:00 AM | Permit Number 37412 | 5995037.97859853 | 2099619.33373801 | 37.7448698872964 | -122.459855964981 | (37.7448698872964, -122.459855964981) | 1 | 8 | 4 | 59 | 40 | ||
| 159561 | 11323 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1223 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6017540.6929483 | 2093936.3628532 | 37.7305340258377 | -122.381649801703 | (37.7305340258377, -122.381649801703) | 10 | 3 | 8 | 58 | 1 | |||
| 159523 | 218793 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 616 Joost Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | Width 10ft | 5998053.08406 | 2095010.86684 | 37.7323890825862 | -122.449098408785 | (37.7323890825862, -122.449098408785) | 9 | 7 | 4 | 59 | 40 | |||
| 159428 | 11277 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1176X Ingalls St | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3x3 | 6017716.362196 | 2093961.1645628 | 37.7306118245585 | -122.381044204671 | (37.7306118245585, -122.381044204671) | 10 | 3 | 8 | 58 | 1 | |||
| 158878 | 69022 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 2094 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1994 12:00:00 AM | Permit Number 33026 | 5981407.07152231 | 2100831.13487358 | 37.7474038185251 | -122.507078153918 | (37.7474038185251, -122.507078153918) | 1 | 8 | 3 | 29491 | 35 | ||
| 158313 | 30787 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 488 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/1995 12:00:00 AM | 3x3 | Permit Number 51964 | 6013865.01842582 | 2112595.14259648 | 37.7815633679001 | -122.395664068446 | (37.7815633679001, -122.395664068446) | 6 | 2 | 9 | 28856 | 6 | ||
| 157949 | 91085 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 4055 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2009 12:00:00 AM | 3x3 | Permit Number 51980 | 6002824 | 2101802 | 37.7513076735554 | -122.433089295463 | (37.7513076735554, -122.433089295463) | 2 | 4 | 5 | 28862 | 22 | ||
| 157768 | 115772 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1204 Egbert Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 775363 | 6015358.9 | 2090410.1 | 37.7207308974409 | -122.388946547811 | (37.7207308974409, -122.388946547811) | 10 | 3 | 8 | 58 | 1 | ||
| 157517 | 112488 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 1275 Columbus Ave | 8 | Front Yard : Yard | Tree | Private 2 | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | 5 | 1 | 1 | 308 | 32 | |||||
| 157396 | 107712 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 1798X 31st Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5986575.46002 | 2103344.33269 | 37.7546074174257 | -122.489391225039 | (37.7546074174257, -122.489391225039) | 1 | 8 | 3 | 56 | 35 | ||||
| 156878 | 63136 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 75 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/11/1986 12:00:00 AM | Permit Number 23653 | 6007261.8048924 | 2099033.40342516 | 37.7439564645667 | -122.417546624418 | (37.7439564645667, -122.417546624418) | 2 | 7 | 7 | 28859 | 2 | ||
| 156558 | 68317 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1999X 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32130 | 5981353.71840295 | 2101490.23529545 | 37.7492103807501 | -122.507311533808 | (37.7492103807501, -122.507311533808) | 1 | 8 | 3 | 29491 | 35 | ||
| 155411 | 11362 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1351X Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6017270.42563 | 2093912.097264 | 37.730452470679 | -122.38258247713 | (37.730452470679, -122.38258247713) | 10 | 3 | 8 | 58 | 1 | |||
| 154893 | 62017 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 53 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1986 12:00:00 AM | Permit Number 22088 | 6004287.33949957 | 2108757.29100043 | 37.7704881450556 | -122.428524619186 | (37.7704881450556, -122.428524619186) | 7 | 9 | 11 | 29492 | 10 | ||
| 154879 | 94599 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1709 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5997540 | 2108126 | 37.7683706375079 | -122.451818041345 | (37.7683706375079, -122.451818041345) | 15 | 5 | 11 | 29492 | 9 | |||||
| 154498 | 97394 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 907 Diamond St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/2011 12:00:00 AM | 23 | 4x4 | Permit Number 768003 | 6001936 | 2101462 | 37.7503237031932 | -122.436135767062 | (37.7503237031932, -122.436135767062) | 2 | 4 | 5 | 28862 | 22 | |
| 154295 | 187031 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 2501 Sunset Blvd | 50 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | Width 0ft | 5984966.2618 | 2097842.7948 | 37.7394076227298 | -122.494550633787 | (37.7394076227298, -122.494550633787) | 1 | 8 | 3 | 29491 | 35 | |||
| 154210 | 94386 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1001 Potrero Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | 10 | 4 | 8 | 28859 | 19 | ||||
| 153948 | 104993 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 669X NOE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6003139 | 2104447 | 37.7585880783392 | -122.432188863302 | (37.7585880783392, -122.432188863302) | 2 | 4 | 5 | 28862 | 3 | |||
| 153721 | 17255 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 17 Osceola Ln | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6017331.5843984 | 2094252.3198967 | 37.7313900334691 | -122.382394702172 | (37.7313900334691, -122.382394702172) | 10 | 3 | 8 | 58 | 1 | |||
| 153608 | 117546 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 24X KEMPTON AVE | 1 | Side Yard : Yard | Tree | DPW 1 | 30x30 | 5992274 | 2087683 | 37.7119363308651 | -122.468544900416 | (37.7119363308651, -122.468544900416) | 9 | 8 | 4 | 64 | 24 | ||||
| 153526 | 63705 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1679 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1987 12:00:00 AM | Permit Number 24365 | 5994000.03328261 | 2104083.32941502 | 37.757067134665 | -122.463768902449 | (37.757067134665, -122.463768902449) | 1 | 5 | 4 | 56 | 12 | ||
| 153238 | 224215 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1000 San Jose Ave | 14 | Front Yard : Yard | Tree | Private 2 | 26 | 6005165.86979 | 2097298.42463 | 37.739074448424 | -122.424670499065 | (37.739074448424, -122.424670499065) | 2 | 7 | 5 | 28859 | 7 | ||||
| 153115 | 199401 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 299x Cashmere St | 18 | Median : Yard | Tree | DPW 1 | 30 | 6016684.16305 | 2095970.28806 | 37.7360714484387 | -122.384752612468 | (37.7360714484387, -122.384752612468) | 10 | 3 | 8 | 58 | 1 | ||||
| 153065 | 254084 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 170x Kensington Way | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5994883 | 2098695 | 37.7423229834884 | -122.460324888843 | (37.7423229834884, -122.460324888843) | 1 | 8 | 4 | 59 | 40 | ||||
| 152575 | 6105 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 500X 08th St | 7 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3 | 18 | 6010526.8124541 | 2109340.6023904 | 37.7724409020578 | -122.406983260044 | (37.7724409020578, -122.406983260044) | 14 | 2 | 9 | 28853 | 34 | |||
| 152370 | 69180 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1310 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1994 12:00:00 AM | 8 | Permit Number 33219 | 5982156.72464205 | 2106168.22486515 | 37.7621020835294 | -122.504881372035 | (37.7621020835294, -122.504881372035) | 1 | 8 | 3 | 56 | 35 | |
| 152049 | 11353 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1339 Ingalls St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6017292.9099838 | 2093920.0801467 | 37.7304756321775 | -122.382505299944 | (37.7304756321775, -122.382505299944) | 10 | 3 | 8 | 58 | 1 | |||
| 151453 | 111293 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 3500X MISSION ST | 1 | Median : Cutout | Tree | DPW 1 | 30 | 6005565 | 2097823 | 37.7405373480538 | -122.423327767767 | (37.7405373480538, -122.423327767767) | 2 | 7 | 7 | 28859 | 2 | ||||
| 151322 | 94377 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1001 Potrero Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | 10 | 4 | 8 | 28859 | 19 | ||||
| 151085 | 106464 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 3500X MISSION ST | 5 | Median : Cutout | Tree | DPW 1 | 28 | 6005565.6 | 2097823.9 | 37.7405398531137 | -122.42332575716 | (37.7405398531137, -122.42332575716) | 2 | 7 | 7 | 28859 | 2 | ||||
| 151055 | 11352 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1339 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6017292.9099838 | 2093920.0801467 | 37.7304756321775 | -122.382505299944 | (37.7304756321775, -122.382505299944) | 10 | 3 | 8 | 58 | 1 | |||
| 150919 | 224210 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1001 San Jose Ave | 72 | Front Yard : Yard | Tree | Private 2 | 37 | 6005362.14637 | 2097481.1402 | 37.7395872274562 | -122.424004853264 | (37.7395872274562, -122.424004853264) | 2 | 7 | 5 | 28859 | 2 | ||||
| 150229 | 87675 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 770 Golden Gate Ave | 11 | Front Yard : Cutout | Tree | Private 2 | 05/22/2008 12:00:00 AM | 3x3 | Permit Number 50396 | 6005860.1 | 2112469.5 | 37.7807698496384 | -122.423348359154 | (37.7807698496384, -122.423348359154) | 7 | 9 | 11 | 28852 | 41 | ||
| 149539 | 176333 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 12x Canyon Dr | 12 | Median : Cutout | Tree | DPW 1 | 12 | Width 0ft | 6002752.1139 | 2086168.71447 | 37.7083781345093 | -122.432221533399 | (37.7083781345093, -122.432221533399) | 9 | 7 | 6 | 28861 | 5 | |||
| 149348 | 65614 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 901 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1990 12:00:00 AM | 3x3 | Permit Number 28521 | 6001429.80797007 | 2088950.28994853 | 37.7159406631737 | -122.436990572562 | (37.7159406631737, -122.436990572562) | 9 | 7 | 6 | 28861 | 5 | |
| 149269 | 187038 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 2501 Sunset Blvd | 57 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984961.8902 | 2097789.6624 | 37.7392614795793 | -122.494561832752 | (37.7392614795793, -122.494561832752) | 1 | 8 | 3 | 29491 | 35 | |||
| 148903 | 12079 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1241X La Salle Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6017245.0743814 | 2094442.9323579 | 37.7319086387255 | -122.382707045529 | (37.7319086387255, -122.382707045529) | 10 | 3 | 8 | 58 | 1 | |||
| 148359 | 10846 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1139X Hudson Ave | 53 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/02/1990 12:00:00 AM | 12 | 3X4 | 6018074.11801 | 2094612.24201 | 37.7324192966959 | -122.379852595874 | (37.7324192966959, -122.379852595874) | 10 | 3 | 8 | 58 | 1 | ||
| 148069 | 66850 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1880 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/15/1991 12:00:00 AM | Permit Number 30155 | 5998816.45099957 | 2110433.37978637 | 37.7747791387742 | -122.447569047166 | (37.7747791387742, -122.447569047166) | 15 | 5 | 11 | 29492 | 16 | ||
| 146973 | 12108 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1281X La Salle Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/04/1992 12:00:00 AM | 20 | 3X3 | 6017033.141006 | 2094557.4754692 | 37.7322114406026 | -122.383447721977 | (37.7322114406026, -122.383447721977) | 10 | 3 | 8 | 58 | 1 | ||
| 146690 | 199400 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 299 Cashmere St | 16 | : | Tree | Private 2 | 38 | 6016698.52819 | 2095954.85127 | 37.7360298565815 | -122.384701870897 | (37.7360298565815, -122.384701870897) | 10 | 3 | 8 | 58 | 1 | ||||
| 146575 | 122380 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 557 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6005149 | 2111246 | 37.777370259808 | -122.425721291473 | (37.777370259808, -122.425721291473) | 7 | 9 | 11 | 28852 | 10 | |||
| 146550 | 32724 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1082 Post St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37114 | 6006978.17320306 | 2114692.47231461 | 37.7869366280698 | -122.419638162258 | (37.7869366280698, -122.419638162258) | 13 | 9 | 10 | 28858 | 21 | ||
| 146044 | 19366 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 500X Lake St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 125 | 3X3 | 5993786.07945 | 2114905.65207 | 37.7867700254284 | -122.465294925074 | (37.7867700254284, -122.465294925074) | 11 | 6 | 1 | 54 | 11 | |||
| 145650 | 176329 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 700x Mansell St | 33 | Median : Cutout | Tree | DPW 1 | 11 | Width 0ft | 6009197.90265 | 2089964.97601 | 37.719165253359 | -122.410211888084 | (37.719165253359, -122.410211888084) | 9 | 3 | 8 | 309 | 18 | |||
| 145339 | 67105 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1205 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1992 12:00:00 AM | Permit Number 30520 | 5992960.34916512 | 2107265.37958459 | 37.765744243823 | -122.467595898952 | (37.765744243823, -122.467595898952) | 11 | 8 | 11 | 56 | 12 | ||
| 145233 | 54757 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 330 Lathrop Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/1972 12:00:00 AM | 14 | Permit Number 10606 | 6012426.81669 | 2086731.57127 | 37.7104674323033 | -122.398823887208 | (37.7104674323033, -122.398823887208) | 10 | 3 | 8 | 309 | 1 | ||
| 144698 | 199406 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 301x Cashmere St | 6 | Median : Yard | Tree | DPW 1 | 22 | 6016219.39095 | 2096203.76694 | 37.7366868185504 | -122.386375806006 | (37.7366868185504, -122.386375806006) | 10 | 3 | 8 | 58 | 1 | ||||
| 144569 | 117548 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 24X KEMPTON AVE | 2 | Side Yard : Yard | Tree | DPW 1 | 30x30 | 5992274 | 2087683 | 37.7119363308651 | -122.468544900416 | (37.7119363308651, -122.468544900416) | 9 | 8 | 4 | 64 | 24 | ||||
| 143783 | 106577 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1001X SAN JOSE AVE | 1 | Median : Cutout | Tree | DPW 1 | 10 | 6004855 | 2096548 | 37.7369963898236 | -122.425691948858 | (37.7369963898236, -122.425691948858) | 2 | 7 | 5 | 28859 | 2 | ||||
| 141466 | 224206 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1001 San Jose Ave | 59 | Front Yard : Yard | Tree | Private 2 | 24 | 6005333.6743 | 2097319.76234 | 37.7391425127264 | -122.424091823995 | (37.7391425127264, -122.424091823995) | 2 | 7 | 5 | 28859 | 2 | ||||
| 141199 | 176304 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 200x Mansell St | 17 | Median : Cutout | Tree | DPW 1 | 12 | Width 0ft | 6011109.46654 | 2090529.17456 | 37.7208213917675 | -122.403643980895 | (37.7208213917675, -122.403643980895) | 10 | 7 | 7 | 309 | 28 | |||
| 140823 | 98951 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 401 Grove St | 11 | Front Yard : Yard | Tree | Private 2 | 6005778.2 | 2111279 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | 7 | 9 | 11 | 28852 | 10 | |||||
| 140238 | 6100 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 500X 08th St | 2 | Median : Cutout | Tree | DPW 1 | 24 | 18 | 6010526.8124541 | 2109340.6023904 | 37.7724409020578 | -122.406983260044 | (37.7724409020578, -122.406983260044) | 14 | 2 | 9 | 28853 | 34 | |||
| 139874 | 97392 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 907 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/2011 12:00:00 AM | 23 | 4x4 | Permit Number 768003 | 6001936 | 2101462 | 37.7503237031932 | -122.436135767062 | (37.7503237031932, -122.436135767062) | 2 | 4 | 5 | 28862 | 22 | |
| 139377 | 63106 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 67 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1986 12:00:00 AM | Permit Number 23602 | 6006857.2853572 | 2099318.42969221 | 37.744716312649 | -122.418965575221 | (37.744716312649, -122.418965575221) | 2 | 7 | 7 | 28859 | 2 | ||
| 138784 | 199409 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 822 Mendell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 4ft | 6015943.97928 | 2096692.65499 | 37.738013957089 | -122.387362125771 | (37.738013957089, -122.387362125771) | 10 | 3 | 8 | 58 | 1 | |||
| 138456 | 176300 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 10x Mansell St | 8 | Median : Cutout | Tree | DPW 1 | 22 | Width 0ft | 6011702.06583 | 2090731.87272 | 37.7214110448664 | -122.401609772869 | (37.7214110448664, -122.401609772869) | 10 | 3 | 8 | 309 | 28 | |||
| 138384 | 187029 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 2501 Sunset Blvd | 48 | Sidewalk: Property side : Yard | Tree | Private 2 | 38 | Width 0ft | 5984947.4301 | 2097843.1311 | 37.7394074439231 | -122.49461576934 | (37.7394074439231, -122.49461576934) | 1 | 8 | 3 | 29491 | 35 | |||
| 137993 | 110179 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 321 Fair Oaks St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005492.60818902 | 2101839.04635751 | 37.7515604083348 | -122.423863569693 | (37.7515604083348, -122.423863569693) | 2 | 4 | 5 | 28859 | 19 | ||||
| 137830 | 199403 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 299x Cashmere St | 22 | Median : Yard | Tree | DPW 1 | 15 | 6016641.57283 | 2096000.10584 | 37.7361509664773 | -122.384901942178 | (37.7361509664773, -122.384901942178) | 10 | 3 | 8 | 58 | 1 | ||||
| 137795 | 176310 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 500x Mansell St | 8 | Median : Cutout | Tree | DPW 1 | 29 | Width 0ft | 6010469.51848 | 2090335.25755 | 37.7202531668397 | -122.405842444672 | (37.7202531668397, -122.405842444672) | 10 | 7 | 8 | 309 | 28 | |||
| 137503 | 60551 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 539 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1982 12:00:00 AM | Permit Number 20161 | 5985003.93496372 | 2112200.51497155 | 37.7788321315722 | -122.495479035088 | (37.7788321315722, -122.495479035088) | 11 | 6 | 2 | 55 | 26 | ||
| 137412 | 91083 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 4055 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2009 12:00:00 AM | 3x3 | Permit Number 51980 | 6002824 | 2101802 | 37.7513076735554 | -122.433089295463 | (37.7513076735554, -122.433089295463) | 2 | 4 | 5 | 28862 | 22 | ||
| 137140 | 112418 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 268X Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x3 | 6005334.87738 | 2110100.0463 | 37.7742342515583 | -122.424996726643 | (37.7742342515583, -122.424996726643) | 7 | 9 | 11 | 28852 | 10 | ||||
| 136784 | 12103 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1281X La Salle Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6017033.141006 | 2094557.4754692 | 37.7322114406026 | -122.383447721977 | (37.7322114406026, -122.383447721977) | 10 | 3 | 8 | 58 | 1 | |||
| 136242 | 181588 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1227 37th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5984569.5881 | 2106811.9615 | 37.7640112583591 | -122.496583837339 | (37.7640112583591, -122.496583837339) | 1 | 8 | 3 | 56 | 35 | |||
| 136060 | 176328 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 700x Mansell St | 32 | Median : Cutout | Tree | DPW 1 | 11 | Width 0ft | 6009200.77281 | 2089956.05158 | 37.7191409096134 | -122.410201337249 | (37.7191409096134, -122.410201337249) | 9 | 3 | 8 | 309 | 18 | |||
| 135169 | 106597 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1001X SAN JOSE AVE | 10 | Median : Yard | Tree | DPW 1 | 19 | 6004855 | 2096548 | 37.7369963898236 | -122.425691948858 | (37.7369963898236, -122.425691948858) | 2 | 7 | 5 | 28859 | 2 | ||||
| 134755 | 50874 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1160 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2004 12:00:00 AM | Permit Number 47384 | 6007625.30066101 | 2102900.0062832 | 37.7545937308752 | -122.41656358052 | (37.7545937308752, -122.41656358052) | 2 | 4 | 7 | 28859 | 19 | ||
| 134558 | 176305 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 300x Mansell St | 3 | Median : Cutout | Tree | DPW 1 | 28 | Width 0ft | 6010925.66518 | 2090483.18833 | 37.7206848540134 | -122.404276094583 | (37.7206848540134, -122.404276094583) | 10 | 7 | 7 | 309 | 28 | |||
| 134254 | 11262 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1176X Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3x3 | 6017716.362196 | 2093961.1645628 | 37.7306118245585 | -122.381044204671 | (37.7306118245585, -122.381044204671) | 10 | 3 | 8 | 58 | 1 | |||
| 133966 | 187652 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 46 Cragmont Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992908 | 2101735 | 37.7505562410762 | -122.467374782979 | (37.7505562410762, -122.467374782979) | 1 | 8 | 4 | 29491 | 12 | ||||
| 133408 | 102296 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1500 Michigan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6016449 | 2101073.5 | 37.7500708170088 | -122.385921283567 | (37.7500708170088, -122.385921283567) | 10 | 3 | 8 | 58 | 1 | ||||
| 132930 | 11365 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1351X Ingalls St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6017270.42563 | 2093912.097264 | 37.730452470679 | -122.38258247713 | (37.730452470679, -122.38258247713) | 10 | 3 | 8 | 58 | 1 | |||
| 132405 | 109849 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 3250x 22ND ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x3 | 6006518 | 2103190 | 37.7553276504831 | -122.420413510616 | (37.7553276504831, -122.420413510616) | 2 | 4 | 7 | 28859 | 19 | |||
| 132040 | 176314 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 500x Mansell St | 19 | Median : Cutout | Tree | DPW 1 | 35 | Width 0ft | 6010185.66613 | 2090251.18564 | 37.7200064441173 | -122.406817710885 | (37.7200064441173, -122.406817710885) | 10 | 7 | 8 | 309 | 28 | |||
| 131970 | 92011 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1900 Geary Blvd | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 52162 | 6002138.3 | 2113859.7 | 37.7843762313587 | -122.436323371803 | (37.7843762313587, -122.436323371803) | 13 | 6 | 11 | 29490 | 13 | ||||
| 131448 | 112486 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1275 Columbus Ave | 6 | Front Yard : Yard | Tree | Private 2 | 08/03/2015 12:00:00 AM | Permit Number 774532 | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | 5 | 1 | 1 | 308 | 32 | |||
| 130907 | 65395 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1199 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/17/1990 12:00:00 AM | Permit Number 28618 | 6006415.64200439 | 2102619.79399643 | 37.7537562275815 | -122.420727018296 | (37.7537562275815, -122.420727018296) | 2 | 4 | 7 | 28859 | 19 | ||
| 130862 | 24059 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 21X Whitfield Ct | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6017547.7495644 | 2094131.2536992 | 37.7310695474783 | -122.381638954529 | (37.7310695474783, -122.381638954529) | 10 | 3 | 8 | 58 | 1 | |||
| 130215 | 63183 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1335 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1986 12:00:00 AM | Permit Number 23722 | 6002224.85030351 | 2113085.27883033 | 37.7822547845521 | -122.435968505977 | (37.7822547845521, -122.435968505977) | 15 | 5 | 11 | 29490 | 41 | ||
| 130043 | 17280 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 75 Osceola Dr | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6017053.17764 | 2094406.15972 | 37.7317970648608 | -122.38336792075 | (37.7317970648608, -122.38336792075) | 10 | 3 | 8 | 58 | 1 | |||
| 130009 | 107550 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 198X Jennings St | 3 | Front Yard : Yard | Tree | DPW 1 | 6018784.70414 | 2097136.12526 | 37.7393885572332 | -122.377570991407 | (37.7393885572332, -122.377570991407) | 10 | 3 | 8 | 58 | 1 | |||||
| 129135 | 113327 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 237 Fairmount St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 775932 | 6004215.8 | 2097159.4 | 37.7386390150291 | -122.427945503988 | (37.7386390150291, -122.427945503988) | 2 | 7 | 5 | 63 | 7 | |||
| 128798 | 99751 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 500x Clipper St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3x3 | 1046 Diamond St | 6001860.7 | 2100931.8 | 37.7488636216299 | -122.436358217698 | (37.7488636216299, -122.436358217698) | 2 | 4 | 5 | 28862 | 22 | ||
| 128188 | 94201 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1227 Pierce St | 2 | Sidewalk: Property side : | Tree | Private 2 | 06/22/2010 12:00:00 AM | Permit Number 53604 | 6002086 | 2112766.6 | 37.7813718842821 | -122.436426049876 | (37.7813718842821, -122.436426049876) | 15 | 5 | 11 | 29490 | 41 | |||
| 128038 | 63102 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 151 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1996 12:00:00 AM | Permit Number 37593 | 6006585.95318508 | 2098816.77496864 | 37.74332359922 | -122.41986820091 | (37.74332359922, -122.41986820091) | 2 | 7 | 7 | 28859 | 2 | ||
| 127698 | 257930 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1000X Hudson Ave | Unaccepted Street : Cutout | Tree | DPW 1 | 3x3 | 6018755 | 2095128 | 37.7338730033489 | -122.377534379141 | (37.7338730033489, -122.377534379141) | 10 | 3 | 8 | 58 | 1 | |||||
| 127674 | 11214 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1001X Ingalls St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 12 | 3X4 | 6018170.9910099 | 2094117.1281791 | 37.7310651541831 | -122.379483297777 | (37.7310651541831, -122.379483297777) | 10 | 3 | 8 | 58 | 1 | ||
| 127318 | 12042 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1250X La Salle Ave | 24 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6017218.4556902 | 2094518.641349 | 37.7321150500381 | -122.382804339533 | (37.7321150500381, -122.382804339533) | 10 | 3 | 8 | 58 | 1 | |||
| 127142 | 65482 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 519 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1989 12:00:00 AM | Permit Number 28366 | 5994743.29707293 | 2091977.51972285 | 37.7238703903851 | -122.460321333166 | (37.7238703903851, -122.460321333166) | 9 | 8 | 4 | 28861 | 24 | ||
| 126368 | 224202 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1300 San Jose Ave | 27 | Front Yard : Yard | Tree | Private 2 | 14 | 6003508.62731 | 2095617.8291 | 37.7343661800531 | -122.430280617458 | (37.7343661800531, -122.430280617458) | 2 | 7 | 5 | 63 | 7 | ||||
| 125954 | 105666 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 317X DORADO TER | 3 | unknown : Yard | Tree | Private 2 | 22 | 5994307.4 | 2093021.4 | 37.7267115488018 | -122.461903806308 | (37.7267115488018, -122.461903806308) | 9 | 8 | 4 | 28861 | 40 | ||||
| 125898 | 110145 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 64 WOODLAND AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 36 | 3x15 | 5997139.6 | 2106104.1 | 37.7627960760002 | -122.453057009148 | (37.7627960760002, -122.453057009148) | 15 | 5 | 11 | 29492 | 12 | |||
| 124698 | 11213 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1001X Ingalls St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 12 | 3X4 | 6018170.9910099 | 2094117.1281791 | 37.7310651541831 | -122.379483297777 | (37.7310651541831, -122.379483297777) | 10 | 3 | 8 | 58 | 1 | ||
| 124647 | 6173 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1075 Ellis St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005893.15301 | 2113273.27935 | 37.782978696051 | -122.423291166859 | (37.782978696051, -122.423291166859) | 7 | 9 | 11 | 28858 | 41 | |||
| 124032 | 24062 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 21X Whitfield Ct | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6017547.7495644 | 2094131.2536992 | 37.7310695474783 | -122.381638954529 | (37.7310695474783, -122.381638954529) | 10 | 3 | 8 | 58 | 1 | |||
| 123800 | 12070 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1225X La Salle Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6017323.1868972 | 2094393.2571117 | 37.7317765554235 | -122.382433536417 | (37.7317765554235, -122.382433536417) | 10 | 3 | 8 | 58 | 1 |
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) );