trees
861 rows where qSpecies_id = 18 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
194392 | 162798 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 107 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 4x6 | 5996432.70685 | 2090525.92628 | 37.7199816938867 | -122.454376546047 | (37.7199816938867, -122.454376546047) | 9 | 8 | 6 | 28861 | 24 | ||
194388 | 162793 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 201 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 4x6 | 5996142.86432 | 2090531.62526 | 37.7199807154151 | -122.455378837768 | (37.7199807154151, -122.455378837768) | 9 | 8 | 6 | 28861 | 24 | ||
194237 | 31775 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2000 Ulloa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | Permit Number 35250 | 5989839.49734774 | 2098377.72398218 | 37.7411604150808 | -122.477740406961 | (37.7411604150808, -122.477740406961) | 1 | 8 | 3 | 29491 | 35 | ||
194062 | 96627 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 145 Sutro Heights Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/10/2011 12:00:00 AM | Permit Number 767986 | 5981103.1 | 2111247.3 | 37.7759857009664 | -122.50890252539 | (37.7759857009664, -122.50890252539) | 11 | 6 | 2 | 55 | 26 | |||
193848 | 207090 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1400 Ulloa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5991605.432 | 2098443.60055 | 37.7414436224199 | -122.47163929621 | (37.7414436224199, -122.47163929621) | 1 | 8 | 4 | 29491 | 40 | |||
193551 | 207093 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2469 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992014.45058 | 2098646.31177 | 37.742023871309 | -122.470239822518 | (37.742023871309, -122.470239822518) | 1 | 8 | 4 | 29491 | 40 | |||
193451 | 207096 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 447 Lansdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5996040.3151 | 2096410.52388 | 37.7361168767915 | -122.456158138087 | (37.7361168767915, -122.456158138087) | 9 | 7 | 4 | 59 | 40 | |||
192991 | 114221 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 28 Lois Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6012377.24762 | 2087856.00195 | 37.7135521339029 | -122.399074083116 | (37.7135521339029, -122.399074083116) | 10 | 3 | 8 | 309 | 1 | |||
192933 | 191260 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1058 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6012165.085 | 2103460.39568 | 37.7563867072014 | -122.400903071241 | (37.7563867072014, -122.400903071241) | 10 | 3 | 8 | 28856 | 29 | |||
192764 | 106106 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 708 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 6011765.54028 | 2117816.6633 | 37.7957834196109 | -122.403294730072 | (37.7957834196109, -122.403294730072) | 3 | 1 | 10 | 28860 | 4 | ||||
192751 | 64085 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 850 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2010 12:00:00 AM | Permit Number 54033 | 5990603.92265969 | 2099084.38866457 | 37.7431450674581 | -122.475148901667 | (37.7431450674581, -122.475148901667) | 1 | 8 | 4 | 29491 | 40 | |||
192681 | 102558 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1755X 04th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015173.7 | 2107354.9 | 37.7672475362702 | -122.390770296702 | (37.7672475362702, -122.390770296702) | 14 | 3 | 9 | 310 | 20 | ||||
191961 | 227654 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 210 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004930.05045 | 2104005.07306 | 37.7574760371124 | -122.425963138682 | (37.7574760371124, -122.425963138682) | 2 | 4 | 5 | 28862 | 3 | |||
191951 | 176948 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 43 Lois Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6012470.82697 | 2087771.09267 | 37.7133242043273 | -122.398744682131 | (37.7133242043273, -122.398744682131) | 10 | 3 | 8 | 309 | 1 | |||
191886 | 129392 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 31 Casa Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001624.74168 | 2121508.73342 | 37.8053492888098 | -122.438648369353 | (37.8053492888098, -122.438648369353) | 13 | 9 | 1 | 57 | 17 | |||
191762 | 227619 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1193 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008092.35309 | 2100991.6752 | 37.7493801403813 | -122.414813334067 | (37.7493801403813, -122.414813334067) | 2 | 4 | 7 | 28859 | 19 | |||
191686 | 89060 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 744 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990392.548057 | 2110303.85357 | 37.7739384762903 | -122.476699287319 | (37.7739384762903, -122.476699287319) | 11 | 6 | 2 | 55 | 26 | ||
191557 | 207082 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1963 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5992234.50744 | 2102126.7079 | 37.7515928656239 | -122.469732265838 | (37.7515928656239, -122.469732265838) | 1 | 8 | 4 | 29491 | 12 | |||
191047 | 99399 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1590 Yosemite Ave | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | ||
191003 | 207066 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 71 Wawona St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5993124.54928 | 2098622.04482 | 37.7420213577054 | -122.466399723691 | (37.7420213577054, -122.466399723691) | 1 | 8 | 4 | 59 | 40 | |||
190961 | 187585 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 748 University St | 1 | Front Yard : Yard | Tree | Private 2 | 19 | 6008708.47344 | 2090752.442 | 37.7213000235466 | -122.411959282496 | (37.7213000235466, -122.411959282496) | 9 | 7 | 7 | 309 | 18 | ||||
190849 | 25182 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 3226 Market St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/18/1996 12:00:00 AM | 3 | 3X3 | 5999429.9273 | 2104670.84771 | 37.7589917140099 | -122.4450325603 | (37.7589917140099, -122.4450325603) | 2 | 4 | 5 | 28862 | 3 | ||
190811 | 207059 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2454 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5992059.72364 | 2098724.92514 | 37.7422423409243 | -122.470089007101 | (37.7422423409243, -122.470089007101) | 1 | 8 | 4 | 29491 | 40 | |||
190708 | 129438 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 715 Bush St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6010041.47641 | 2115755.35321 | 37.7900271217973 | -122.409114812309 | (37.7900271217973, -122.409114812309) | 5 | 1 | 10 | 28857 | 21 | |||
190301 | 227657 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 117 States St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6001570.04877 | 2106180.8326 | 37.7632596788053 | -122.437739171852 | (37.7632596788053, -122.437739171852) | 15 | 5 | 5 | 28862 | 3 | |||
189800 | 191249 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2300 18th St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 10ft | 6010915.57021 | 2105542.63703 | 37.7620342994705 | -122.405370986778 | (37.7620342994705, -122.405370986778) | 8 | 3 | 8 | 28856 | 29 | |||
189467 | 176976 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 100 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6002487.99329 | 2086859.86644 | 37.7102609083974 | -122.433183714473 | (37.7102609083974, -122.433183714473) | 9 | 7 | 6 | 28861 | 5 | |||
189316 | 191272 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 659 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6014208.1321 | 2110827.64494 | 37.7767292999414 | -122.394353258399 | (37.7767292999414, -122.394353258399) | 6 | 2 | 9 | 28856 | 20 | |||
188836 | 207073 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 230 Pacheco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 5994505.45248 | 2100370.55426 | 37.746901910105 | -122.461751786336 | (37.746901910105, -122.461751786336) | 1 | 8 | 4 | 29491 | 40 | |||
188829 | 102556 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1755X 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015173.7 | 2107354.9 | 37.7672475362702 | -122.390770296702 | (37.7672475362702, -122.390770296702) | 14 | 3 | 9 | 310 | 20 | ||||
188798 | 227662 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 32 Harry St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 6003182.99622 | 2097643.55659 | 37.7399099141156 | -122.431551000691 | (37.7399099141156, -122.431551000691) | 2 | 7 | 5 | 63 | 7 | |||
188438 | 89104 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 627 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990323.547333 | 2111099.7078 | 37.7761196708607 | -122.476996135109 | (37.7761196708607, -122.476996135109) | 11 | 6 | 2 | 55 | 26 | ||
188409 | 31770 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1850 Ulloa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | 2 | Permit Number 35249 | 5990241.9611 | 2098396.6732 | 37.7412357933409 | -122.476350230302 | (37.7412357933409, -122.476350230302) | 1 | 8 | 3 | 29491 | 35 | ||
188316 | 246314 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1660 Mission St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 0ft | 6006868.6018 | 2109014.4469 | 37.7713399704187 | -122.419614246796 | (37.7713399704187, -122.419614246796) | 8 | 2 | 9 | 28853 | 19 | |||
187695 | 49756 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1171 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | 1 | Permit Number 46552 | 6011373.3818 | 2089351.75942 | 37.7176031885257 | -122.402648943989 | (37.7176031885257, -122.402648943989) | 10 | 7 | 8 | 309 | 39 | |
187084 | 89082 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 466 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990324.88294 | 2112207.2474 | 37.7791607464072 | -122.477072465426 | (37.7791607464072, -122.477072465426) | 11 | 6 | 2 | 55 | 26 | ||
187023 | 18862 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2200 Sacramento St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3X3PL | 6004143.20725 | 2116038.00121 | 37.7904710109775 | -122.429542492602 | (37.7904710109775, -122.429542492602) | 13 | 9 | 1 | 29490 | 27 | |||
187013 | 200105 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1528 Yosemite Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6014949.7328 | 2092444.2049 | 37.7262934578304 | -122.390502982758 | (37.7262934578304, -122.390502982758) | 10 | 3 | 8 | 58 | 1 | |||
186370 | 227636 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 3232 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008200.59079 | 2100972.6589 | 37.7493340069794 | -122.414437698959 | (37.7493340069794, -122.414437698959) | 2 | 4 | 7 | 28859 | 19 | |||
185996 | 50456 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 993 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2003 12:00:00 AM | 6 | Permit Number 47101 | 6015538.43851 | 2104592.1377 | 37.7596818177679 | -122.38931576171 | (37.7596818177679, -122.38931576171) | 10 | 3 | 8 | 28856 | 29 | ||
185564 | 117943 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 6300 Fulton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5983766.08421 | 2109717.40456 | 37.7719416683068 | -122.499577617773 | (37.7719416683068, -122.499577617773) | 11 | 6 | 2 | 55 | 26 | |||
184935 | 92050 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2323 Cesar Chavez St | Front Yard : Cutout | Tree | DPW 1 | 05/16/2009 12:00:00 AM | 6012395.863444 | 2100936.77011 | 37.7494702500338 | -122.399927744224 | (37.7494702500338, -122.399927744224) | 10 | 3 | 8 | 58 | 1 | |||||
184748 | 102567 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1655X 04th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2013 12:00:00 AM | 3x3 | Permit Number 769962 | 6015154.2 | 2107704.9 | 37.7682074777149 | -122.390862208319 | (37.7682074777149, -122.390862208319) | 14 | 3 | 9 | 310 | 20 | ||
184555 | 57079 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 627 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/22/1974 12:00:00 AM | 2 | Permit Number 14346 | 5990318.78395 | 2111097.03664 | 37.7761120602541 | -122.477012417523 | (37.7761120602541, -122.477012417523) | 11 | 6 | 2 | 55 | 26 | ||
183963 | 200098 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1528 Yosemite Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6015053.9581 | 2092365.0208 | 37.7260818154372 | -122.390137148672 | (37.7260818154372, -122.390137148672) | 10 | 3 | 8 | 58 | 1 | |||
183807 | 102256 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1933 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/2013 12:00:00 AM | 1 | 3x3 | Permit Number 58594 | 6000840.6 | 2115080.7 | 37.7876549629941 | -122.440900572101 | (37.7876549629941, -122.440900572101) | 13 | 6 | 1 | 29490 | 27 | |
183685 | 142580 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 650 CHESTNUT ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6008660.8 | 2120758.6253 | 37.8036874273397 | -122.414245990591 | (37.8036874273397, -122.414245990591) | 3 | 1 | 10 | 308 | 23 | |||
183529 | 89683 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2439X Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/08/2008 12:00:00 AM | 3 | 3x3 | 5991013.77238 | 2111967.73884 | 37.7785430633696 | -122.474671853461 | (37.7785430633696, -122.474671853461) | 11 | 6 | 2 | 54 | 26 | ||
183420 | 187582 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 747 University St | 3 | Side Yard : Yard | Tree | Private 2 | 12 | 6008739.08909 | 2090759.61849 | 37.7213214463175 | -122.411853959308 | (37.7213214463175, -122.411853959308) | 9 | 3 | 7 | 309 | 28 | ||||
183411 | 191347 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1750 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6015093.18746 | 2107823.28717 | 37.7685291574227 | -122.391081522115 | (37.7685291574227, -122.391081522115) | 14 | 3 | 9 | 310 | 20 | |||
182587 | 4551 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 85 Cleary Ct | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/11/1991 12:00:00 AM | 24 | 3X3 | 6004735.0847094 | 2113637.0202701 | 37.7839120126984 | -122.427323526754 | (37.7839120126984, -122.427323526754) | 7 | 9 | 11 | 28858 | 41 | ||
182404 | 176938 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 10 Lois Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6012264.96042 | 2087928.82829 | 37.7137458424772 | -122.399467299971 | (37.7137458424772, -122.399467299971) | 10 | 3 | 8 | 309 | 1 | |||
182318 | 207068 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 539 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5991225.79939 | 2097692.69128 | 37.7393598464762 | -122.472897178881 | (37.7393598464762, -122.472897178881) | 1 | 8 | 4 | 29491 | 40 | |||
181301 | 108995 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 55 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/20/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772985 | 5993924.20809 | 2115202.12337 | 37.7875920194037 | -122.464838574554 | (37.7875920194037, -122.464838574554) | 11 | 6 | 1 | 54 | 11 |
181193 | 176929 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 110 Hester Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6012755.76956 | 2087791.93581 | 37.7133973075252 | -122.397761276185 | (37.7133973075252, -122.397761276185) | 10 | 3 | 8 | 309 | 1 | |||
181058 | 183580 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2614 26th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 0ft | 5988349.2799 | 2097484.0905 | 37.7386201346216 | -122.482827506776 | (37.7386201346216, -122.482827506776) | 1 | 8 | 3 | 29491 | 35 | |||
181056 | 191300 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 601 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015176.683 | 2107358.12451 | 37.767256555574 | -122.390760204217 | (37.767256555574, -122.390760204217) | 14 | 3 | 9 | 310 | 20 | |||
180619 | 99381 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1590 Yosemite Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | ||
180384 | 4517 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 20X Cleary Ct | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6004999.51904 | 2113885.82273 | 37.7846101140023 | -122.426426402111 | (37.7846101140023, -122.426426402111) | 13 | 9 | 11 | 28858 | 41 | |||
180251 | 129430 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2201 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6004093.9756 | 2116304.66162 | 37.7912004052335 | -122.429731858334 | (37.7912004052335, -122.429731858334) | 13 | 9 | 1 | 29490 | 27 | |||
180161 | 34271 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 118 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38073 | 5987121.09736721 | 2115203.94287654 | 37.7872024288867 | -122.488375816661 | (37.7872024288867, -122.488375816661) | 11 | 6 | 1 | 55 | 33 | ||
179951 | 109857 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 521 CLIPPER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 3x6 | 6001683.3 | 2100835.6 | 37.748589397757 | -122.436964779583 | (37.748589397757, -122.436964779583) | 2 | 4 | 5 | 28862 | 22 | |||
179884 | 94214 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 465 Missouri St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53589 | 6013545.01697 | 2104957.62874 | 37.7605746593094 | -122.396235681545 | (37.7605746593094, -122.396235681545) | 10 | 3 | 8 | 28856 | 29 | |
179526 | 207086 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2167 18th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5990677.28316 | 2100628.1103 | 37.7473879783661 | -122.475007906598 | (37.7473879783661, -122.475007906598) | 1 | 8 | 4 | 29491 | 40 | |||
178669 | 89689 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2405 Anza St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/08/2008 12:00:00 AM | 3 | 3x3 | 5991196.08416 | 2111975.00544 | 37.7785735776786 | -122.474041704171 | (37.7785735776786, -122.474041704171) | 11 | 6 | 2 | 54 | 26 | ||
178443 | 89076 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 550 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990345.59029 | 2111614.5302 | 37.7775345100567 | -122.476957509799 | (37.7775345100567, -122.476957509799) | 11 | 6 | 2 | 55 | 26 | ||
178429 | 207051 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1264 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5992092.81688 | 2106815.43538 | 37.764458690039 | -122.470563705269 | (37.764458690039, -122.470563705269) | 11 | 8 | 11 | 56 | 12 | |||
178232 | 191253 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 654 Minnesota St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 6015148.44265 | 2105367.15882 | 37.7617882296504 | -122.390718735586 | (37.7617882296504, -122.390718735586) | 10 | 3 | 8 | 28856 | 29 | |||
177615 | 191317 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1505 04th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015134.8576 | 2108090.59219 | 37.7692654305833 | -122.390956072084 | (37.7692654305833, -122.390956072084) | 14 | 3 | 9 | 310 | 20 | |||
177567 | 89690 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2351 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5991335.21973 | 2111978.62727 | 37.7785915807726 | -122.473560650038 | (37.7785915807726, -122.473560650038) | 11 | 6 | 2 | 54 | 26 | ||
177495 | 42710 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1600 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/15/2010 12:00:00 AM | 10 | 3x3 | Permit Number 53744 | 6005271.11771 | 2118900.89126 | 37.7983955805457 | -122.42584385893 | (37.7983955805457, -122.42584385893) | 13 | 9 | 1 | 57 | 17 |
176982 | 191363 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 955 Key Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 6013550.52728 | 2089583.75311 | 37.7183615103672 | -122.395139727222 | (37.7183615103672, -122.395139727222) | 10 | 3 | 8 | 58 | 1 | ||||
176725 | 191284 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 751 04th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6014408.26812 | 2110636.4725 | 37.7762155064684 | -122.393647539722 | (37.7762155064684, -122.393647539722) | 6 | 2 | 9 | 28856 | 20 | |||
176678 | 207079 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 59 Ralston St | 3 | Back Yard : Yard | Tree | Private 2 | 12 | 5992173.18035 | 2088300.45859 | 37.7136258989769 | -122.468938264287 | (37.7136258989769, -122.468938264287) | 9 | 8 | 6 | 64 | 24 | ||||
176325 | 89422 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2400X Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/29/2008 12:00:00 AM | 3 | 3x3 | 5991198.49136 | 2112030.01361 | 37.7787247544447 | -122.474037391358 | (37.7787247544447, -122.474037391358) | 11 | 6 | 2 | 54 | 26 | ||
176225 | 227663 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 6 Unnamed 011 | 1 | Back Yard : Yard | Tree | Private 2 | 13 | Width 10ft | 6002739.4908 | 2096074.90228 | 37.7355776028169 | -122.432972414242 | (37.7355776028169, -122.432972414242) | 2 | 7 | 5 | 63 | 7 | |||
175891 | 176939 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 8 Lois Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6012245.82216 | 2087941.31791 | 37.7137790697309 | -122.399534325569 | (37.7137790697309, -122.399534325569) | 10 | 3 | 8 | 309 | 1 | |||
175651 | 129401 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 5 Dicha Aly | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 5998309.94171 | 2113772.92465 | 37.7839197016653 | -122.449561847418 | (37.7839197016653, -122.449561847418) | 15 | 6 | 1 | 54 | 31 | |||
175436 | 227601 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1100 San Jose Ave | 48 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 6004769.19859 | 2096667.0685 | 37.7373184762576 | -122.425997076417 | (37.7373184762576, -122.425997076417) | 2 | 7 | 5 | 63 | 7 | ||||
174473 | 254175 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1089 Chestnut St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/2018 12:00:00 AM | 3 | 3x3 | 6006628.18877 | 2120429.73547 | 37.8026699959528 | -122.421256591898 | (37.8026699959528, -122.421256591898) | 5 | 1 | 1 | 28858 | 32 | ||
174472 | 227626 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1455 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6003318.57968 | 2099748.35087 | 37.7456968761174 | -122.431232410466 | (37.7456968761174, -122.431232410466) | 2 | 7 | 5 | 63 | 22 | |||
174282 | 89688 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2405 Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/08/2008 12:00:00 AM | 3 | 3x3 | 5991173.67465 | 2111973.9047 | 37.7785692572369 | -122.474119146124 | (37.7785692572369, -122.474119146124) | 11 | 6 | 2 | 54 | 26 | ||
173534 | 176968 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 134 Craut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004019.9865 | 2094083.37147 | 37.7301818557853 | -122.428403350153 | (37.7301818557853, -122.428403350153) | 9 | 7 | 6 | 28861 | 5 | |||
173385 | 129410 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2199 Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003271.2174 | 2116075.89812 | 37.7905256555748 | -122.432562228073 | (37.7905256555748, -122.432562228073) | 13 | 9 | 1 | 29490 | 27 | |||
172750 | 89434 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2750X Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/29/2008 12:00:00 AM | 3 | 3x3 | 5990083.37165 | 2111991.81654 | 37.7785552188238 | -122.47789218978 | (37.7785552188238, -122.47789218978) | 11 | 6 | 2 | 55 | 26 | ||
172719 | 191297 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 740 04th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6014617.26494 | 2110308.92783 | 37.7753277532976 | -122.392901635701 | (37.7753277532976, -122.392901635701) | 6 | 2 | 9 | 310 | 20 | |||
172712 | 191251 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 654 Minnesota St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 6015148.84129 | 2105378.48456 | 37.7618193498029 | -122.390718148336 | (37.7618193498029, -122.390718148336) | 10 | 3 | 8 | 28856 | 29 | |||
172622 | 129446 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1329 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6008344.2402 | 2117236.00141 | 37.7939973921104 | -122.415091973713 | (37.7939973921104, -122.415091973713) | 5 | 1 | 10 | 28858 | 21 | |||
172563 | 129418 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2129 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6003255.2303 | 2117874.11084 | 37.7954621799809 | -122.432746053085 | (37.7954621799809, -122.432746053085) | 13 | 9 | 1 | 29490 | 27 | |||
172538 | 176954 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 95 Lois Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6012699.50978 | 2087739.26695 | 37.7132495561051 | -122.397952038554 | (37.7132495561051, -122.397952038554) | 10 | 3 | 8 | 309 | 1 | |||
172453 | 176956 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 99 Lois Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6012750.52308 | 2087747.4076 | 37.7132747497136 | -122.397776288548 | (37.7132747497136, -122.397776288548) | 10 | 3 | 8 | 309 | 1 | |||
171921 | 99379 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1590 Yosemite Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | |
171672 | 176933 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 56 Lois Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6012542.43425 | 2087752.49307 | 37.7132771230101 | -122.398495876584 | (37.7132771230101, -122.398495876584) | 10 | 3 | 8 | 309 | 1 | |||
171650 | 129402 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 3000 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5999090.32735 | 2119096.86414 | 37.7985824452762 | -122.44724531075 | (37.7985824452762, -122.44724531075) | 13 | 9 | 1 | 57 | 17 | |||
171588 | 176940 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 15 Lois Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6012273.46712 | 2087900.15525 | 37.7136675861685 | -122.399435885762 | (37.7136675861685, -122.399435885762) | 10 | 3 | 8 | 309 | 1 | |||
170972 | 139749 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 85 CLEARY CT | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6004687.008 | 2113628.2842 | 37.7838853065296 | -122.427489231919 | (37.7838853065296, -122.427489231919) | 7 | 9 | 11 | 28858 | 41 | |||
170885 | 109806 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1264 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775061 | 5992117.2 | 2106823.9 | 37.764483341532 | -122.470479988054 | (37.764483341532, -122.470479988054) | 11 | 8 | 11 | 56 | 12 |
170850 | 227592 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 501 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6005300.21046 | 2107796.96547 | 37.7679085883379 | -122.424952753964 | (37.7679085883379, -122.424952753964) | 8 | 4 | 5 | 28853 | 19 | |||
170603 | 200097 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1528 Yosemite Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6015067.4938 | 2092354.869 | 37.7260546913573 | -122.390089647295 | (37.7260546913573, -122.390089647295) | 10 | 3 | 8 | 58 | 1 | |||
170331 | 36895 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 4118 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/27/1998 12:00:00 AM | Permit Number 39548 | 6001738.91463484 | 2103541.42716619 | 37.7560221127265 | -122.436966152078 | (37.7560221127265, -122.436966152078) | 2 | 4 | 5 | 28862 | 3 |
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) );