trees
8,659 rows where qSpecies_id = 11 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
192587 | 5276 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1335 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4x3 | 6001258.2677 | 2113021.233 | 37.7820239734046 | -122.439307851029 | (37.7820239734046, -122.439307851029) | 15 | 5 | 11 | 29490 | 41 | |||
192583 | 48841 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/08/2002 12:00:00 AM | Permit Number 46057 | 5993902.71442412 | 2107430.11074384 | 37.7662509163514 | -122.464348446646 | (37.7662509163514, -122.464348446646) | 11 | 6 | 11 | 29492 | 8 | ||||
192505 | 10577 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1005X Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/22/2014 12:00:00 AM | 3 | 3x3 | 6011389.65552 | 2111033.79852 | 37.7771382742741 | -122.404117770342 | (37.7771382742741, -122.404117770342) | 14 | 2 | 9 | 28853 | 34 | ||
192379 | 41536 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 775X 02nd St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/20/2000 12:00:00 AM | 6 | 3x3 | Permit Number 42068 | 6015692.30699351 | 2111981.66601878 | 37.7799803743496 | -122.389299616981 | (37.7799803743496, -122.389299616981) | 6 | 2 | 9 | 28856 | 20 | |
192350 | 138393 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2445 PINE ST | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6002260.0048 | 2115027.6125 | 37.7875899357719 | -122.435985914831 | (37.7875899357719, -122.435985914831) | 13 | 6 | 11 | 29490 | 27 | |||
192332 | 29299 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1000X Portola Dr | 2 | Median : Cutout | Tree | DPW 1 | 10/27/2016 01:24:00 PM | 3 | 3X3 | 5995989.04111 | 2098439.8270093 | 37.7416859027703 | -122.456482111076 | (37.7416859027703, -122.456482111076) | 1 | 7 | 4 | 59 | 40 | ||
192303 | 97456 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2833 03rd St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6015982.07607 | 2102420.27087 | 37.7537429168085 | -122.387629897505 | (37.7537429168085, -122.387629897505) | 10 | 3 | 8 | 28856 | 29 | |||||
192292 | 228666 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 4045 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002730.83753 | 2104717.96111 | 37.7593089219873 | -122.433619837083 | (37.7593089219873, -122.433619837083) | 2 | 4 | 5 | 28862 | 3 | |||
192287 | 22270 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 4704 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/24/2015 03:01:00 PM | 3 | 3x3 | 6014985.2816 | 2095785.5021 | 37.7354699584644 | -122.39061347315 | (37.7354699584644, -122.39061347315) | 10 | 3 | 8 | 58 | 1 | ||
192286 | 202607 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 701 Division St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6011603.02447 | 2108394.17668 | 37.7699023970199 | -122.403193930453 | (37.7699023970199, -122.403193930453) | 14 | 2 | 8 | 28853 | 20 | |||
192264 | 112167 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 838X MISSION ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011020 | 2113508 | 37.7839111917985 | -122.405570835545 | (37.7839111917985, -122.405570835545) | 12 | 2 | 9 | 28853 | 34 | ||||
192260 | 38185 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 143 Dwight St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | Permit Number 40316 | 6011173.37926749 | 2091539.09555351 | 37.7235979973868 | -122.403494068776 | (37.7235979973868, -122.403494068776) | 10 | 3 | 7 | 309 | 28 | ||
192255 | 202799 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 700 Mission Bay Blvd North | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6014283.15114 | 2108697.13408 | 37.7708835636684 | -122.393944568698 | (37.7708835636684, -122.393944568698) | 14 | 3 | 9 | 310 | 20 | |||
192227 | 56793 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1284 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1989 12:00:00 AM | Permit Number 25783 | 6000421.78044647 | 2109269.7505474 | 37.7716757187634 | -122.441932360781 | (37.7716757187634, -122.441932360781) | 15 | 5 | 11 | 29492 | 9 | ||
192221 | 229091 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 281 Bradford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6009527.64638 | 2096946.80909 | 37.7383543657622 | -122.409564590228 | (37.7383543657622, -122.409564590228) | 10 | 7 | 7 | 28859 | 2 | |||
192211 | 229114 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1035 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007641.11749 | 2103627.02672 | 37.7565908524017 | -122.416560378678 | (37.7565908524017, -122.416560378678) | 2 | 4 | 7 | 28859 | 19 | |||
192191 | 23080 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1299X Valencia St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/02/1992 12:00:00 AM | 30 | 3X3 | 6006435.33711 | 2102036.08991 | 37.7521546202746 | -122.420617475407 | (37.7521546202746, -122.420617475407) | 2 | 4 | 7 | 28859 | 19 | ||
192190 | 129961 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1051 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6007315.70471 | 2114981.16786 | 37.7877483224762 | -122.418490856165 | (37.7877483224762, -122.418490856165) | 13 | 9 | 10 | 28858 | 21 | |||
192162 | 208466 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 474 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5998950.1982 | 2094726.27135 | 37.7316589194042 | -122.445976425769 | (37.7316589194042, -122.445976425769) | 9 | 7 | 4 | 59 | 40 | |||
192156 | 33956 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 430 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51049 | 6007993.74077 | 2113910.29629 | 37.7848461166869 | -122.416069106029 | (37.7848461166869, -122.416069106029) | 7 | 10 | 9 | 28858 | 36 | |
192143 | 47577 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 301 Folsom St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2002 12:00:00 AM | Permit Number 45427 | 6014780.11094225 | 2115147.42860331 | 37.7886222227295 | -122.392676859355 | (37.7886222227295, -122.392676859355) | 6 | 2 | 9 | 28855 | 6 | |||
192142 | 108288 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1 HENRY ADAMS ST | 13 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6011517.4 | 2108140.5 | 37.7692010762684 | -122.403472255644 | (37.7692010762684, -122.403472255644) | 8 | 2 | 8 | 28853 | 20 | ||||
192131 | 28901 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 270X 05th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/11/2006 12:00:00 AM | 3 | 3x3 | 6011477.37679 | 2112270.24711 | 37.7805381761312 | -122.403901342593 | (37.7805381761312, -122.403901342593) | 14 | 2 | 9 | 28853 | 34 | ||
192111 | 177227 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1447 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 6002363.53651 | 2093672.33483 | 37.7289593695666 | -122.43410053551 | (37.7289593695666, -122.43410053551) | 9 | 7 | 6 | 28861 | 25 | |||
192093 | 116988 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 300x BRODERICK ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6001353 | 2109892 | 37.7734372805127 | -122.438755818588 | (37.7734372805127, -122.438755818588) | 15 | 5 | 11 | 29492 | 10 | ||||
192076 | 202788 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 55 Long Bridge St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6014945.32247 | 2109519.05309 | 37.7731771496294 | -122.391711560153 | (37.7731771496294, -122.391711560153) | 14 | 3 | 9 | 310 | 20 | |||
192052 | 110717 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 201x OGDEN AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6007843 | 2096159 | 37.7360966727045 | -122.415333535238 | (37.7360966727045, -122.415333535238) | 2 | 7 | 7 | 28859 | 2 | ||||
192038 | 156908 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3267 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6006989.20662 | 2106119.2349 | 37.7633971932589 | -122.418991685038 | (37.7633971932589, -122.418991685038) | 8 | 4 | 7 | 28859 | 19 | |||
192035 | 208242 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 56 Santa Monica Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 5993655.56825 | 2097379.16721 | 37.7386393537243 | -122.464473421732 | (37.7386393537243, -122.464473421732) | 1 | 8 | 4 | 59 | 40 | |||
192006 | 87650 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2148 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/23/2008 12:00:00 AM | 3 | 6011790.09435 | 2087616.19351 | 37.7128609302491 | -122.40108666691 | (37.7128609302491, -122.40108666691) | 10 | 7 | 8 | 309 | 39 | |||
191972 | 208363 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 4986 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 3ft | 5990650.177 | 2093775.54023 | 37.7285710036319 | -122.47460159919 | (37.7285710036319, -122.47460159919) | 9 | 8 | 4 | 64 | 40 | |||
191956 | 130352 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1700 Montgomery St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6011277.60651 | 2121335.96977 | 37.8054193145122 | -122.405231027083 | (37.8054193145122, -122.405231027083) | 3 | 1 | 10 | 308 | 23 | |||
191952 | 29729 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1250 Columbus Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/19/2006 12:00:00 AM | 8 | 4x4 | 6007719.65165 | 2121534.55679 | 37.8057650284682 | -122.417557918763 | (37.8057650284682, -122.417557918763) | 5 | 1 | 10 | 308 | 23 | ||
191942 | 65424 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 721 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/28/1989 12:00:00 AM | Permit Number 28282 | 6010035.07923765 | 2115761.19865665 | 37.7900428136106 | -122.40913735873 | (37.7900428136106, -122.40913735873) | 5 | 1 | 10 | 28857 | 21 | ||
191842 | 30515 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 340 Eddy St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/09/1995 12:00:00 AM | 11 | Permit Number 34525 | 6008720.06565 | 2113541.76357 | 37.7838750251578 | -122.413530175976 | (37.7838750251578, -122.413530175976) | 7 | 10 | 9 | 28852 | 36 | ||
191723 | 65662 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 156 Marietta Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1991 12:00:00 AM | Permit Number 28582 | 5998605.16099259 | 2097914.71068201 | 37.7403939061802 | -122.447398692916 | (37.7403939061802, -122.447398692916) | 9 | 7 | 4 | 59 | 40 | ||
191697 | 229052 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3531 22nd St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6004859.68135 | 2103081.74723 | 37.7549368237929 | -122.426140771891 | (37.7549368237929, -122.426140771891) | 2 | 4 | 5 | 28862 | 22 | |||
191688 | 62414 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 669 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/17/1986 12:00:00 AM | 10 | Permit Number 22727 | 5991605.76052 | 2110886.32738 | 37.7756080871839 | -122.472545098313 | (37.7756080871839, -122.472545098313) | 11 | 6 | 2 | 54 | 26 | |
191652 | 32653 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 245 05th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | 10 | Permit Number 37086 | 6011396.32164 | 2112453.55594 | 37.7810369707226 | -122.404194657383 | (37.7810369707226, -122.404194657383) | 6 | 2 | 9 | 28853 | 34 | |
191645 | 6974 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 735 Fell St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/04/1992 12:00:00 AM | 6 | 3X3 | 6003867.74104 | 2110395.47322 | 37.7749624382409 | -122.430092894199 | (37.7749624382409, -122.430092894199) | 7 | 9 | 11 | 29492 | 10 | ||
191636 | 67544 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 489 Molimo Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | Permit Number 31084 | 5997441.75466233 | 2097519.40134952 | 37.7392419317435 | -122.451392768616 | (37.7392419317435, -122.451392768616) | 9 | 7 | 4 | 59 | 40 | ||
191632 | 96612 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3652 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2011 12:00:00 AM | 4 | Permit Number 767972 | 5997357.22496 | 2115417.4717 | 37.788380643004 | -122.45297662718 | (37.788380643004, -122.45297662718) | 11 | 6 | 1 | 54 | 31 | ||
191630 | 208321 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 590 Faxon Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5994795.45764 | 2092193.31851 | 37.7244659222618 | -122.460156650735 | (37.7244659222618, -122.460156650735) | 9 | 8 | 4 | 28861 | 24 | |||
191583 | 47065 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 608 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2008 12:00:00 AM | 7 | Permit Number 45052 | 6004036.92026 | 2110896.92583 | 37.7763488840161 | -122.429543436897 | (37.7763488840161, -122.429543436897) | 7 | 9 | 11 | 28852 | 10 | |
191577 | 130092 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 70 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6008660.2813 | 2112596.15191 | 37.7812752452008 | -122.4136701024 | (37.7812752452008, -122.4136701024) | 7 | 10 | 9 | 28852 | 36 | |||
191573 | 130028 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 421 Leavenworth St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6008426.22774 | 2113928.79883 | 37.7849212271699 | -122.414574146802 | (37.7849212271699, -122.414574146802) | 7 | 10 | 9 | 28858 | 36 | |||
191568 | 49890 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 190 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/2005 12:00:00 AM | Permit Number 48320 | 6004362.86360721 | 2108776.26099442 | 37.7705445057003 | -122.428264732992 | (37.7705445057003, -122.428264732992) | 7 | 9 | 11 | 28852 | 10 | ||
191539 | 1785 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2001X Bay Shore Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/01/1997 12:00:00 AM | 3 | 3X3 | 6012442.8362111 | 2088493.874497 | 37.7153072596479 | -122.398892125343 | (37.7153072596479, -122.398892125343) | 10 | 3 | 8 | 309 | 1 | ||
191531 | 24029 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 39 Westbrook Ct | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 3 | 3X4 | 6017387.6973076 | 2095530.7497873 | 37.7349034485609 | -122.382289615761 | (37.7349034485609, -122.382289615761) | 10 | 3 | 8 | 58 | 1 | ||
191529 | 191570 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1620 Innes Ave | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6015123.65498 | 2097551.23042 | 37.7403259629798 | -122.390258384333 | (37.7403259629798, -122.390258384333) | 10 | 3 | 8 | 58 | 1 | |||
191434 | 208452 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 149 Dorado Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/24/1990 12:00:00 AM | 13 | Width 3ft | Permit Number 28889 | 5994430.87116 | 2093042.27236 | 37.7267759667116 | -122.461478485951 | (37.7267759667116, -122.461478485951) | 9 | 8 | 4 | 28861 | 40 | |
191401 | 24516 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1695X Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/20/1995 12:00:00 AM | 18 | 3X3 | 6005299.54679 | 2115457.97004 | 37.788943794726 | -122.425500330831 | (37.788943794726, -122.425500330831) | 13 | 9 | 11 | 28858 | 27 | ||
191376 | 202346 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300 Folsom St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6014550.86088 | 2115005.0697 | 37.7882186031649 | -122.393460069724 | (37.7882186031649, -122.393460069724) | 6 | 2 | 9 | 28855 | 6 | |||
191228 | 177190 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2049 Bay Shore Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012412.28529 | 2088308.43763 | 37.7147963846335 | -122.398984715668 | (37.7147963846335, -122.398984715668) | 10 | 3 | 8 | 309 | 1 | |||
191223 | 191578 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 750 Phelps St | 26 | : | Tree | Private 2 | 10 | Width 4ft | 6015266.28931 | 2098006.88214 | 37.7415849994611 | -122.389797025813 | (37.7415849994611, -122.389797025813) | 10 | 3 | 8 | 58 | 1 | |||
191219 | 130222 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1661 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006135.83723 | 2117250.12096 | 37.7939118099247 | -122.422734285658 | (37.7939118099247, -122.422734285658) | 13 | 9 | 10 | 28858 | 32 | |||
191187 | 24471 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3240 03rd St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 6015972.49692 | 2100334.93813 | 37.7480164983628 | -122.387517553803 | (37.7480164983628, -122.387517553803) | 3 | 8 | 58 | 1 | |||||
191141 | 166 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 185X Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/01/1990 12:00:00 AM | 12 | 3X3 | 6002923.96517 | 2107137.15069 | 37.7659623878091 | -122.43312475899 | (37.7659623878091, -122.43312475899) | 15 | 5 | 5 | 28862 | 3 | ||
191081 | 87407 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2410X Van Ness Ave | 1 | Median : Cutout | Tree | DPW 1 | 04/18/2008 12:00:00 AM | 3 | 3x3 | 6005882.603719 | 2118643.950181 | 37.7977246224394 | -122.423709649159 | (37.7977246224394, -122.423709649159) | 13 | 9 | 1 | 28858 | 32 | ||
191060 | 177237 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 569 Sweeny St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008006.19131 | 2094278.60096 | 37.7309426759501 | -122.414636287248 | (37.7309426759501, -122.414636287248) | 9 | 3 | 7 | 309 | 28 | |||
191055 | 39086 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3140102 21st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1998 12:00:00 AM | Permit Number 40782 | 6007340.78433039 | 2103849.3427132 | 37.7571843859015 | -122.417614797616 | (37.7571843859015, -122.417614797616) | 2 | 4 | 7 | 28859 | 19 | ||
190967 | 22504 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 6405X 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 3 | 3X3 | 6013162.06927 | 2090252.1617 | 37.7201752163939 | -122.396529301048 | (37.7201752163939, -122.396529301048) | 10 | 3 | 8 | 58 | 1 | ||
190960 | 37045 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 135 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 52533 | 6004283.5298939 | 2100995.32888166 | 37.749175425502 | -122.427984597658 | (37.749175425502, -122.427984597658) | 2 | 4 | 5 | 28862 | 22 | ||
190940 | 14644 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 601 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4x4 | 6006263.6652094 | 2112113.7657972 | 37.7798158584752 | -122.421926952026 | (37.7798158584752, -122.421926952026) | 7 | 9 | 11 | 28852 | 10 | |||
190905 | 228646 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 576 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6004229.54601 | 2105541.38322 | 37.7616547657783 | -122.428495267161 | (37.7616547657783, -122.428495267161) | 8 | 4 | 5 | 28862 | 3 | |||
190881 | 208228 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2 Santa Monica Way | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 5993354.70023 | 2097384.89357 | 37.7386377286364 | -122.465514087506 | (37.7386377286364, -122.465514087506) | 1 | 8 | 4 | 59 | 40 | |||
190877 | 101463 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 102 Henry Adams St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6011376.92788 | 2107636.49255 | 37.767809339149 | -122.403922671802 | (37.767809339149, -122.403922671802) | 8 | 2 | 8 | 28853 | 20 | |||
190857 | 98955 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 401 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6005778.2 | 2111279 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | 7 | 9 | 11 | 28852 | 10 | |||||
190856 | 130302 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 815 Battery St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6012391.65637 | 2118926.10793 | 37.7988646372427 | -122.401206238992 | (37.7988646372427, -122.401206238992) | 3 | 1 | 10 | 28860 | 6 | |||
190847 | 3525 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 201X Cargo Way | 35 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6018249.90262 | 2097930.34785 | 37.7415398543705 | -122.379475276478 | (37.7415398543705, -122.379475276478) | 10 | 3 | 8 | 58 | 1 | ||
190844 | 11340 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1279 Ingalls St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6017412.9471167 | 2093950.7223454 | 37.7305663998171 | -122.382092440811 | (37.7305663998171, -122.382092440811) | 10 | 3 | 8 | 58 | 1 | |||
190838 | 228973 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3401 17th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006106.24268 | 2106067.77735 | 37.7632061430626 | -122.422041920108 | (37.7632061430626, -122.422041920108) | 8 | 4 | 5 | 28859 | 19 | |||
190826 | 201586 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020998.06283 | 2093403.93478 | 37.7292623727458 | -122.369660233928 | (37.7292623727458, -122.369660233928) | 10 | 3 | 8 | 58 | 1 | |
190822 | 208238 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 40 Santa Monica Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 5993582.08345 | 2097417.10318 | 37.738739280083 | -122.464730249215 | (37.738739280083, -122.464730249215) | 1 | 8 | 4 | 59 | 40 | |||
190781 | 92575 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2733 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2009 12:00:00 AM | 3x3 | Permit Number 52911 | 5991772.9 | 2096917.9 | 37.7372641239993 | -122.470949138342 | (37.7372641239993, -122.470949138342) | 1 | 8 | 4 | 29491 | 40 | ||
190778 | 208244 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 75 San Lorenzo Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5993706.62967 | 2097419.51827 | 37.738753090981 | -122.464299805789 | (37.738753090981, -122.464299805789) | 1 | 8 | 4 | 59 | 40 | |||
190754 | 82964 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 260 08th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52433 | 6009478.10005611 | 2110435.649232 | 37.7753889048037 | -122.410688219063 | (37.7753889048037, -122.410688219063) | 8 | 2 | 9 | 28853 | 34 | ||
190744 | 27469 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3201 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/10/1999 12:00:00 AM | 3 | 3X3 | 6016045.2641 | 2100630.70669 | 37.7488326475194 | -122.387286553937 | (37.7488326475194, -122.387286553937) | 10 | 3 | 8 | 58 | 1 | ||
190733 | 28963 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 121 09th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/2006 12:00:00 AM | 7 | 3x3 | 6008448.40249 | 2110677.71105 | 37.7759957634284 | -122.414267325993 | (37.7759957634284, -122.414267325993) | 8 | 2 | 9 | 28853 | 34 | ||
190712 | 201014 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2300 03rd St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6015730.13308 | 2104712.71054 | 37.7600235106925 | -122.388661196452 | (37.7600235106925, -122.388661196452) | 10 | 3 | 8 | 28856 | 29 | |||
190633 | 200480 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2751 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6015945.87227 | 2102739.10999 | 37.7546163764472 | -122.387777344555 | (37.7546163764472, -122.387777344555) | 10 | 3 | 8 | 28856 | 29 | |||
190609 | 16143 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 370 Monterey Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5999725.6798 | 2094714.29372 | 37.731670283252 | -122.443294579995 | (37.731670283252, -122.443294579995) | 9 | 7 | 4 | 63 | 40 | |||
190569 | 39468 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300 Clay St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1998 12:00:00 AM | 8 | Permit Number 40935 | 6012943.2025 | 2117604.70886 | 37.7952671449218 | -122.399204889495 | (37.7952671449218, -122.399204889495) | 3 | 1 | 10 | 28860 | 6 | ||
190563 | 228773 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 201 Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6006414.99756 | 2110745.52232 | 37.7760675266398 | -122.421306236009 | (37.7760675266398, -122.421306236009) | 7 | 9 | 11 | 28852 | 10 | |||
190500 | 23152 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 50 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 10/03/2000 12:00:00 AM | 12 | 6007026.70172 | 2110556.798269 | 37.7755838036152 | -122.419176794071 | (37.7755838036152, -122.419176794071) | 7 | 9 | 9 | 28852 | 36 | |||
190491 | 68493 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1761 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | Permit Number 32369 | 5993399.91019058 | 2103504.83654878 | 37.7554441428866 | -122.465802309449 | (37.7554441428866, -122.465802309449) | 1 | 8 | 4 | 56 | 12 | ||
190482 | 130003 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 799 Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6007128.97276 | 2113616.17341 | 37.783989867682 | -122.419040059556 | (37.783989867682, -122.419040059556) | 7 | 9 | 9 | 28858 | 36 | |||
190467 | 23121 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1500 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/23/1994 12:00:00 AM | 15 | 3X3 | 6006461.80511 | 2100675.6061 | 37.7484205340866 | -122.420429386222 | (37.7484205340866, -122.420429386222) | 2 | 4 | 5 | 28859 | 19 | ||
190465 | 202774 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 77 Long Bridge St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6014681.56251 | 2109267.27014 | 37.7724711647512 | -122.392606331635 | (37.7724711647512, -122.392606331635) | 14 | 3 | 9 | 310 | 20 | |||
190460 | 41507 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1475 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/2004 12:00:00 AM | Permit Number 47570 | 6007725.96622091 | 2110155.42070503 | 37.7745210713046 | -122.4167294201 | (37.7745210713046, -122.4167294201) | 8 | 2 | 9 | 28853 | 34 | |||
190455 | 22428 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 5919 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/1995 12:00:00 AM | 3 | 3x3 | 6013843.47241 | 2091704.16796 | 37.7242000332728 | -122.394275508112 | (37.7242000332728, -122.394275508112) | 10 | 3 | 8 | 58 | 1 | ||
190431 | 192649 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 299 Cashmere St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 6016531.22661 | 2096040.23416 | 37.7362550468308 | -122.38528625306 | (37.7362550468308, -122.38528625306) | 10 | 3 | 8 | 58 | 1 | |||
190373 | 22964 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 495X Valencia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/26/1994 12:00:00 AM | 3 | 3x3 | 6006187.02515 | 2106725.06433 | 37.7650154540134 | -122.421809210572 | (37.7650154540134, -122.421809210572) | 8 | 4 | 7 | 28853 | 19 | ||
190363 | 53065 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 522@ GEARY BL Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 12:00:00 AM | 3 | Permit Number 774292 | 6007941.09879 | 2114272.57834 | 37.7858378953488 | -122.416276898884 | (37.7858378953488, -122.416276898884) | 13 | 10 | 9 | 28858 | 36 | ||
190359 | 251134 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1x Somerset St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/10/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779273 | 6009558 | 2094169 | 37.7307287985177 | -122.409263672815 | (37.7307287985177, -122.409263672815) | 10 | 3 | 7 | 309 | 28 | |
190355 | 121534 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 201 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6015114 | 2115064 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | 6 | 2 | 9 | 28855 | 6 | ||||
190339 | 93879 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 638 19th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2010 12:00:00 AM | 7 | Permit Number 53372 | 6015617.24487 | 2105365.96333 | 37.7618109456485 | -122.389097238153 | (37.7618109456485, -122.389097238153) | 10 | 3 | 8 | 28856 | 29 | ||
190295 | 201039 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2192 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6015691.63216 | 2105462.16495 | 37.7620792178926 | -122.388846676252 | (37.7620792178926, -122.388846676252) | 10 | 3 | 8 | 28856 | 29 | |||
190280 | 16071 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 258 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6000394.2301 | 2094704.2539 | 37.7316808170159 | -122.440982554295 | (37.7316808170159, -122.440982554295) | 9 | 7 | 4 | 63 | 40 | |||
190268 | 46511 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 675 Minna St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/2002 12:00:00 AM | 1 | Permit Number 44677 | 6009121.12253 | 2111194.963 | 37.7774537803158 | -122.411976763533 | (37.7774537803158, -122.411976763533) | 8 | 2 | 9 | 28853 | 34 |
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) );