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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
169859 | 191327 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1507 04th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015115.08625 | 2108468.00525 | 37.7703006267103 | -122.391050843517 | (37.7703006267103, -122.391050843517) | 14 | 3 | 9 | 310 | 20 | |||
169646 | 139750 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 85 CLEARY CT | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6004722.5099 | 2113632.2289 | 37.7838981456119 | -122.427366689538 | (37.7838981456119, -122.427366689538) | 7 | 9 | 11 | 28858 | 41 | |||
169259 | 129413 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2111 Webster St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003291.44456 | 2115944.18125 | 37.7901651416677 | -122.432482831414 | (37.7901651416677, -122.432482831414) | 13 | 9 | 1 | 29490 | 27 | |||
169249 | 89092 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 483 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/20/2008 12:00:00 AM | 3 | 3x3 | 5990282.36221 | 2112092.52279 | 37.7788432774658 | -122.477211174284 | (37.7788432774658, -122.477211174284) | 11 | 6 | 2 | 55 | 26 | ||
168974 | 35008 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1652 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50542 | 5999619.6658 | 2114602.5127 | 37.7862723736076 | -122.445090361129 | (37.7862723736076, -122.445090361129) | 15 | 6 | 1 | 29490 | 31 | |
168919 | 89064 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 706 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990387.44621 | 2110524.3809 | 37.7745436879542 | -122.476733050457 | (37.7745436879542, -122.476733050457) | 11 | 6 | 2 | 55 | 26 | ||
168843 | 89099 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 583 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990307.45252 | 2111413.41703 | 37.776980096273 | -122.477074739943 | (37.776980096273, -122.477074739943) | 11 | 6 | 2 | 55 | 26 | ||
168624 | 115987 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 499 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6011766.1004 | 2118039.48156 | 37.7963952562896 | -122.40330847443 | (37.7963952562896, -122.40330847443) | 3 | 1 | 10 | 28860 | 4 | |||
168044 | 191348 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1750 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015095.00919 | 2107795.26302 | 37.7684523103469 | -122.391073261843 | (37.7684523103469, -122.391073261843) | 14 | 3 | 9 | 310 | 20 | |||
167972 | 181340 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1360 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 5988678.0351 | 2106085.8063 | 37.7622572799997 | -122.482320895025 | (37.7622572799997, -122.482320895025) | 1 | 8 | 3 | 56 | 35 | |||
167903 | 35838 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 524 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1998 12:00:00 AM | 6 | Permit Number 39065 | 6001524.77874 | 2090714.46307 | 37.7207900854698 | -122.436788524592 | (37.7207900854698, -122.436788524592) | 9 | 7 | 6 | 28861 | 5 | |
167332 | 191342 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1450 04th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015064.99922 | 2108338.84414 | 37.7699431992568 | -122.391215066031 | (37.7699431992568, -122.391215066031) | 14 | 3 | 9 | 310 | 20 | |||
167266 | 227623 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1001 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6001957.40527 | 2101134.69618 | 37.7494262207603 | -122.436038328126 | (37.7494262207603, -122.436038328126) | 2 | 4 | 5 | 28862 | 22 | |||
167223 | 104724 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2747 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 770749 | 5999893.3 | 2117731.9 | 37.7948804646429 | -122.444368636719 | (37.7948804646429, -122.444368636719) | 13 | 9 | 1 | 57 | 27 | |||
166998 | 33958 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 690 Chestnut St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1997 12:00:00 AM | 15 | Permit Number 37913 | 6008590.6293 | 2120749.6774 | 37.8036589168384 | -122.414488187223 | (37.8036589168384, -122.414488187223) | 3 | 1 | 10 | 308 | 23 | ||
166949 | 1718 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 555 Battery St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 9x6 | 6012538.25649 | 2117884.3369 | 37.7960123609319 | -122.400625729299 | (37.7960123609319, -122.400625729299) | 3 | 1 | 10 | 28860 | 4 | |||
166939 | 35235 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1077 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | 6 | Permit Number 38732 | 6007771.26508 | 2119552.1201 | 37.8003246614186 | -122.417238733675 | (37.8003246614186, -122.417238733675) | 5 | 1 | 1 | 308 | 32 | |
166507 | 191258 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1901 17th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6011671.67609 | 2106498.8214 | 37.7647020133105 | -122.402823145387 | (37.7647020133105, -122.402823145387) | 8 | 3 | 8 | 28856 | 29 | |||
166455 | 4543 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 66 Cleary Ct | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/21/1994 12:00:00 AM | 12 | 3X3 | 6004823.98553 | 2113713.43923 | 37.784126867551 | -122.427021407244 | (37.784126867551, -122.427021407244) | 13 | 9 | 11 | 28858 | 41 | ||
166023 | 26205 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 750 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/20/2007 12:00:00 AM | 12 | 3X3 | 6005640.0872799 | 2098758.1364942 | 37.7431092589962 | -122.423134597972 | (37.7431092589962, -122.423134597972) | 2 | 7 | 5 | 28859 | 22 | ||
165931 | 102568 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1655X 04th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015154.2 | 2107704.9 | 37.7682074777149 | -122.390862208319 | (37.7682074777149, -122.390862208319) | 14 | 3 | 9 | 310 | 20 | ||||
165903 | 31772 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2000 Ulloa St | 5 | 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 | ||
165523 | 191360 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1780 04th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015121.96393 | 2107325.37884 | 37.7671636070317 | -122.390947182278 | (37.7671636070317, -122.390947182278) | 14 | 3 | 9 | 310 | 20 | |||
165110 | 44092 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2200 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2000 12:00:00 AM | 8 | 3x3 | Permit Number 43607 | 6004180.10381 | 2116042.60341 | 37.7904857364673 | -122.429415161181 | (37.7904857364673, -122.429415161181) | 13 | 9 | 1 | 29490 | 27 | |
164984 | 84614 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2034 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50834 | 6000478.89565 | 2121006.72285 | 37.8039056520943 | -122.442577640443 | (37.8039056520943, -122.442577640443) | 13 | 9 | 1 | 57 | 17 | |
164798 | 37466 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 115 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1998 12:00:00 AM | Permit Number 39937 | 6009086.92753477 | 2097969.49395992 | 37.7411377303504 | -122.411160606325 | (37.7411377303504, -122.411160606325) | 10 | 7 | 7 | 28859 | 2 | ||
164313 | 142575 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2201 MASON ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6008927.1192 | 2120859.172 | 37.8039784592472 | -122.413331490554 | (37.8039784592472, -122.413331490554) | 3 | 1 | 10 | 308 | 23 | |||
164304 | 142249 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 619 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6004863.0676 | 2110879.3064 | 37.7763472473304 | -122.426684306291 | (37.7763472473304, -122.426684306291) | 7 | 9 | 11 | 28852 | 10 | |||
163749 | 31765 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1850 Ulloa St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | 3 | Permit Number 35249 | 5990223.0095 | 2098395.3195 | 37.7412309773369 | -122.476415658643 | (37.7412309773369, -122.476415658643) | 1 | 8 | 3 | 29491 | 35 | ||
163532 | 48667 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 3362 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/06/2012 12:00:00 AM | 1 | Permit Number 768676 | 5998753.52645 | 2115612.95888 | 37.7889973189237 | -122.448159750376 | (37.7889973189237, -122.448159750376) | 13 | 6 | 1 | 54 | 31 | ||
163187 | 38679 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1377 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/02/1998 12:00:00 AM | Permit Number 40596 | 6001182.75800309 | 2111056.33200795 | 37.7766245566345 | -122.439428187036 | (37.7766245566345, -122.439428187036) | 15 | 5 | 11 | 29492 | 10 | ||
163120 | 89074 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 568 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990349.63369 | 2111514.5867 | 37.777260327334 | -122.476936217932 | (37.777260327334, -122.476936217932) | 11 | 6 | 2 | 55 | 26 | ||
163059 | 89066 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 656 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990372.2384 | 2110982.12204 | 37.7757996372707 | -122.476819108153 | (37.7757996372707, -122.476819108153) | 11 | 6 | 2 | 55 | 26 | ||
162945 | 53889 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1009 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/10/1972 12:00:00 AM | 6 | Permit Number 9600 | 6011157.21659 | 2090045.52637 | 37.7194960599821 | -122.403444914172 | (37.7194960599821, -122.403444914172) | 10 | 7 | 8 | 309 | 28 | ||
162746 | 94211 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 465 Missouri St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53589 | 6013546.79092 | 2104912.40006 | 37.7604505699522 | -122.396226376258 | (37.7604505699522, -122.396226376258) | 10 | 3 | 8 | 28856 | 29 | |
162732 | 227645 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 3801 21st St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003027.84051 | 2103561.52563 | 37.7561504741859 | -122.432510056589 | (37.7561504741859, -122.432510056589) | 2 | 4 | 5 | 28862 | 22 | |||
162376 | 89083 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 434 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990318.24185 | 2112394.83116 | 37.7796754141857 | -122.477109150816 | (37.7796754141857, -122.477109150816) | 11 | 6 | 2 | 55 | 26 | ||
162130 | 129409 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2199 Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003265.25593 | 2116107.39334 | 37.7906117953446 | -122.432585105024 | (37.7906117953446, -122.432585105024) | 13 | 9 | 1 | 29490 | 27 | |||
161636 | 48453 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 740 Euclid Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2002 12:00:00 AM | 5 | Permit Number 45822 | 5996008.37556 | 2113838.92432 | 37.7839689836389 | -122.457529144796 | (37.7839689836389, -122.457529144796) | 11 | 6 | 1 | 54 | 31 | ||
161594 | 191268 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 538 Delancey St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6015150.51675 | 2113731.33336 | 37.7847545135408 | -122.391296270324 | (37.7847545135408, -122.391296270324) | 6 | 2 | 9 | 28856 | 6 | ||||
161417 | 207087 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1400 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5991668.56365 | 2098444.306 | 37.7414492117217 | -122.471421062245 | (37.7414492117217, -122.471421062245) | 1 | 8 | 4 | 29491 | 40 | |||
160781 | 4550 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 85 Cleary Ct | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004735.0847094 | 2113637.0202701 | 37.7839120126984 | -122.427323526754 | (37.7839120126984, -122.427323526754) | 7 | 9 | 11 | 28858 | 41 | |||
160727 | 28934 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 260 08th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/11/2006 12:00:00 AM | 3 | 3x3 | 6009412.25627 | 2110486.96274 | 37.7755261077757 | -122.410919614063 | (37.7755261077757, -122.410919614063) | 8 | 2 | 9 | 28853 | 34 | ||
160275 | 121865 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 574 18th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5990352.37891 | 2111462.4285 | 37.7771172745488 | -122.476922909403 | (37.7771172745488, -122.476922909403) | 11 | 6 | 2 | 55 | 26 | |||
160151 | 207083 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1959 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5992235.15443 | 2102157.44312 | 37.7516772939722 | -122.469732265856 | (37.7516772939722, -122.469732265856) | 1 | 8 | 4 | 29491 | 12 | |||
159582 | 129443 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 144 Cyril Magnin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6010100.50138 | 2114305.77616 | 37.7860502369758 | -122.408808278389 | (37.7860502369758, -122.408808278389) | 14 | 10 | 10 | 28852 | 36 | |||
159355 | 129458 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 731 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6012131.08094 | 2118327.87745 | 37.7972074996935 | -122.402065841564 | (37.7972074996935, -122.402065841564) | 3 | 1 | 10 | 308 | 4 | |||
159205 | 207064 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 134 Taraval St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5993028.04996 | 2099189.22218 | 37.7435731145222 | -122.466774605159 | (37.7435731145222, -122.466774605159) | 1 | 8 | 4 | 29491 | 40 | |||
159039 | 89102 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 621 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5990317.40522 | 2111147.00842 | 37.7762491890218 | -122.477020839229 | (37.7762491890218, -122.477020839229) | 11 | 6 | 2 | 55 | 26 | ||
158830 | 1715 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 555 Battery St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 5x6 | 6012518.40757 | 2118034.67495 | 37.796424046288 | -122.400704977573 | (37.796424046288, -122.400704977573) | 3 | 1 | 10 | 28860 | 4 | |||
158521 | 89078 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 526 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990340.85231 | 2111766.58748 | 37.7779517425204 | -122.476985013525 | (37.7779517425204, -122.476985013525) | 11 | 6 | 2 | 55 | 26 | ||
158460 | 227655 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2 Belcher St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003762.03013 | 2108315.13286 | 37.7692443450787 | -122.430310116133 | (37.7692443450787, -122.430310116133) | 7 | 9 | 5 | 28862 | 3 | |||
157982 | 102560 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1755X 04th St | 7 | 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 | ||||
157815 | 7404 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1060 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/28/1992 12:00:00 AM | 24 | 3X3 | 6010543.2443 | 2111181.3457 | 37.777496075538 | -122.407056190657 | (37.777496075538, -122.407056190657) | 14 | 2 | 9 | 28853 | 34 | ||
157809 | 89067 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 630 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/19/2008 12:00:00 AM | 3 | 3x3 | 5990364.470407 | 2111075.081065 | 37.7760544265827 | -122.476852772949 | (37.7760544265827, -122.476852772949) | 11 | 6 | 2 | 55 | 26 | ||
157479 | 207076 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 230 Pacheco St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 5994497.66006 | 2100431.13069 | 37.7470677891411 | -122.461783123205 | (37.7470677891411, -122.461783123205) | 1 | 8 | 4 | 29491 | 40 | |||
157452 | 89682 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2439X Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/08/2008 12:00:00 AM | 3 | 3x3 | 5990978.92802 | 2111966.07708 | 37.7785364815441 | -122.474792270832 | (37.7785364815441, -122.474792270832) | 11 | 6 | 2 | 54 | 26 | ||
157264 | 191311 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 601 04th St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6015151.76995 | 2107799.07376 | 37.7684659233813 | -122.390877196135 | (37.7684659233813, -122.390877196135) | 14 | 3 | 9 | 310 | 20 | |||
157193 | 176953 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 79 Lois Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6012671.13481 | 2087736.78406 | 37.7132411582287 | -122.39804993877 | (37.7132411582287, -122.39804993877) | 10 | 3 | 8 | 309 | 1 | |||
156724 | 129454 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 855 Chestnut St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 6ft | 6007720.06236 | 2120575.53372 | 37.8031318169374 | -122.41748848713 | (37.8031318169374, -122.41748848713) | 5 | 1 | 1 | 308 | 32 | |||
156625 | 89425 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2444 Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/29/2008 12:00:00 AM | 3 | 3x3 | 5990997.35148 | 2112022.54755 | 37.7786926015029 | -122.474732660414 | (37.7786926015029, -122.474732660414) | 11 | 6 | 2 | 54 | 26 | ||
156448 | 227614 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 210 Holladay Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6010810.25772 | 2099834.79777 | 37.7463559469716 | -122.405333247626 | (37.7463559469716, -122.405333247626) | 2 | 7 | 7 | 28859 | 2 | |||
156291 | 119541 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 823 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5986627.47166 | 2110288.51699 | 37.773677258601 | -122.489722009434 | (37.773677258601, -122.489722009434) | 11 | 6 | 2 | 55 | 26 | |||
156046 | 89089 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 409 18th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990266.49746 | 2112545.35592 | 37.7800857113209 | -122.477299158886 | (37.7800857113209, -122.477299158886) | 11 | 6 | 2 | 55 | 26 | ||
155983 | 129437 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 715 Bush St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6010035.0094 | 2115756.16478 | 37.7900289878849 | -122.409137245009 | (37.7900289878849, -122.409137245009) | 5 | 1 | 10 | 28857 | 21 | |||
155967 | 246318 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1660 Mission St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 0ft | 6006836.8702 | 2108926.9706 | 37.7710979938489 | -122.419717800254 | (37.7710979938489, -122.419717800254) | 8 | 2 | 9 | 28853 | 19 | |||
155843 | 89424 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2444 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/29/2008 12:00:00 AM | 3 | 3x3 | 5991014.10739 | 2112022.90351 | 37.7786945497943 | -122.474674721795 | (37.7786945497943, -122.474674721795) | 11 | 6 | 2 | 54 | 26 | ||
155580 | 191299 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 601 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015177.82762 | 2107330.32237 | 37.7671802804819 | -122.390754301979 | (37.7671802804819, -122.390754301979) | 14 | 3 | 9 | 310 | 20 | |||
155485 | 89098 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 567 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990305.12783 | 2111522.32055 | 37.7772789804391 | -122.477090741641 | (37.7772789804391, -122.477090741641) | 11 | 6 | 2 | 55 | 26 | ||
155404 | 89668 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2701 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/29/2008 12:00:00 AM | 3 | 3x3 | 5990200.3423 | 2111939.74399 | 37.778419030136 | -122.477483741104 | (37.778419030136, -122.477483741104) | 11 | 6 | 2 | 55 | 26 | ||
154792 | 108296 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 55x DIVISION ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011511.3 | 2108309.6 | 37.7696650457173 | -122.40350525397 | (37.7696650457173, -122.40350525397) | 8 | 2 | 8 | 28853 | 20 | ||||
154735 | 176931 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 68 Lois Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6012597.15839 | 2087748.03583 | 37.7132679328338 | -122.398306417307 | (37.7132679328338, -122.398306417307) | 10 | 3 | 8 | 309 | 1 | |||
154682 | 4547 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 66 Cleary Ct | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6004823.98553 | 2113713.43923 | 37.784126867551 | -122.427021407244 | (37.784126867551, -122.427021407244) | 13 | 9 | 11 | 28858 | 41 | |||
154490 | 227620 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 55 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005907.97007 | 2102264.49014 | 37.7527520189138 | -122.422457421298 | (37.7527520189138, -122.422457421298) | 2 | 4 | 5 | 28859 | 19 | |||
154226 | 176937 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 18 Lois Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6012312.20962 | 2087899.37244 | 37.7136675960583 | -122.399301921852 | (37.7136675960583, -122.399301921852) | 10 | 3 | 8 | 309 | 1 | |||
154001 | 89657 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2901X Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/18/2008 12:00:00 AM | 3 | 3x3 | 5989634.12506 | 2111919.89606 | 37.7783316612556 | -122.47944102458 | (37.7783316612556, -122.47944102458) | 11 | 6 | 2 | 55 | 26 | ||
153900 | 142587 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2320 Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6008491.26 | 2120799.1265 | 37.8037891087643 | -122.414835562646 | (37.8037891087643, -122.414835562646) | 5 | 1 | 10 | 308 | 23 | |||
153525 | 207063 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 134 Taraval St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5993031.18209 | 2099190.31712 | 37.7435763017135 | -122.466763854694 | (37.7435763017135, -122.466763854694) | 1 | 8 | 4 | 29491 | 40 | |||
153462 | 108297 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 55x DIVISION ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011511.3 | 2108309.6 | 37.7696650457173 | -122.40350525397 | (37.7696650457173, -122.40350525397) | 8 | 2 | 8 | 28853 | 20 | ||||
153284 | 30569 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 248 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1995 12:00:00 AM | Permit Number 34546 | 6003788.00361454 | 2109234.47759535 | 37.771770112694 | -122.430285874486 | (37.771770112694, -122.430285874486) | 7 | 9 | 11 | 29492 | 10 | ||
152991 | 207061 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 134 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5993037.74509 | 2099188.24411 | 37.7435709885186 | -122.466741010989 | (37.7435709885186, -122.466741010989) | 1 | 8 | 4 | 29491 | 40 | |||
152933 | 12754 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1730 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2011 12:00:00 AM | 2 | 3X4 | 5990033.13163 | 2114754.17722 | 37.786136974525 | -122.478268017968 | (37.786136974525, -122.478268017968) | 11 | 6 | 1 | 55 | 33 | ||
152679 | 191278 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 659 04th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6014098.28059 | 2110942.62046 | 37.7770388897689 | -122.394741323978 | (37.7770388897689, -122.394741323978) | 6 | 2 | 9 | 28856 | 20 | |||
152651 | 27626 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2310X Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6008495.09386 | 2120769.31703 | 37.8037074748624 | -122.414820184334 | (37.8037074748624, -122.414820184334) | 5 | 1 | 10 | 308 | 23 | |||
152484 | 141665 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 5 MASONIC AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5998794.5569 | 2112395.1526 | 37.7801644097761 | -122.447786043539 | (37.7801644097761, -122.447786043539) | 15 | 6 | 2 | 54 | 16 | |||
152240 | 191334 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1108 04th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6014881.31548 | 2110022.28226 | 37.7745553516884 | -122.391968167293 | (37.7745553516884, -122.391968167293) | 14 | 3 | 9 | 310 | 20 | |||
151952 | 124124 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 61 Stanyan Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5996360.44357 | 2112557.14678 | 37.7804697796635 | -122.456218418366 | (37.7804697796635, -122.456218418366) | 11 | 6 | 2 | 54 | 16 | |||
151896 | 89108 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 663 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990326.43317 | 2110871.40415 | 37.7754929792503 | -122.4769694664 | (37.7754929792503, -122.4769694664) | 11 | 6 | 2 | 55 | 26 | ||
151784 | 89109 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 667 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2008 12:00:00 AM | 3 | 3x3 | 5990327.35593 | 2110845.92809 | 37.7754230825234 | -122.47696441245 | (37.7754230825234, -122.47696441245) | 11 | 6 | 2 | 55 | 26 | ||
151775 | 176950 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 59 Lois Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6012544.33708 | 2087727.46225 | 37.7132084993531 | -122.398487544387 | (37.7132084993531, -122.398487544387) | 10 | 3 | 8 | 309 | 1 | |||
151514 | 191290 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 720 04th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6014418.02792 | 2110488.47672 | 37.7758096856109 | -122.393603417186 | (37.7758096856109, -122.393603417186) | 6 | 2 | 9 | 310 | 20 | |||
151432 | 89686 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2435 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5991074.90155 | 2111969.03011 | 37.7785501507324 | -122.474460480761 | (37.7785501507324, -122.474460480761) | 11 | 6 | 2 | 54 | 26 | ||
151040 | 99386 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1590 Yosemite Ave | 9 | 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 | ||
150513 | 37577 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 144 Danvers St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | Permit Number 40010 | 5999933.60679892 | 2105019.65180732 | 37.759978178597 | -122.443315658152 | (37.759978178597, -122.443315658152) | 2 | 4 | 5 | 28862 | 3 | ||
150193 | 30585 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 800 Page St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/1995 12:00:00 AM | Permit Number 34556 | 6002725.87405322 | 2109589.53141465 | 37.7726847844256 | -122.433985230527 | (37.7726847844256, -122.433985230527) | 15 | 5 | 11 | 29492 | 9 | |||
148902 | 191339 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1450 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015062.12286 | 2108415.00786 | 37.7701521684295 | -122.391230340108 | (37.7701521684295, -122.391230340108) | 14 | 3 | 9 | 310 | 20 | |||
148898 | 122542 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2233 Post St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6001449.1657 | 2113870.4558 | 37.7843665840092 | -122.438708303135 | (37.7843665840092, -122.438708303135) | 15 | 6 | 11 | 29490 | 13 | |||
148558 | 176967 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 134 Craut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004019.42662 | 2094104.53584 | 37.7302399367234 | -122.428406793639 | (37.7302399367234, -122.428406793639) | 9 | 7 | 6 | 28861 | 5 | |||
148005 | 97286 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 80 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 768450 | 5993053 | 2098535 | 37.7417782258334 | -122.466640790543 | (37.7417782258334, -122.466640790543) | 1 | 8 | 4 | 59 | 40 | |||
147945 | 191333 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1108 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6014865.84277 | 2110042.35986 | 37.7746096212801 | -122.392023095184 | (37.7746096212801, -122.392023095184) | 14 | 3 | 9 | 310 | 20 |
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) );