trees
861 rows where qSpecies_id = 18 sorted by Neighborhoods (old)
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) ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
76581 | 7147 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 685X Oak St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003730.75372 | 2110025.58578 | 37.7739390589029 | -122.430540363958 | (37.7739390589029, -122.430540363958) | 7 | 9 | 11 | 29492 | 10 | |||
77639 | 16894 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 361 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2008 12:00:00 AM | 3 | 3X3 | 6005282.37962 | 2110221.51905 | 37.7745648206797 | -122.425186971324 | (37.7745648206797, -122.425186971324) | 7 | 9 | 11 | 28852 | 10 | ||
106621 | 244199 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 697 Oak St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6003772.3734 | 2110028.492 | 37.7739493963127 | -122.430396601984 | (37.7739493963127, -122.430396601984) | 7 | 9 | 11 | 29492 | 10 | |||
106623 | 27608 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1377 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6001149.4313 | 2111053.53 | 37.7766149663433 | -122.439543272646 | (37.7766149663433, -122.439543272646) | 15 | 5 | 11 | 29492 | 10 | |||
140138 | 6925 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 460 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005200.4571 | 2110629.3361 | 37.7756799587692 | -122.425499387051 | (37.7756799587692, -122.425499387051) | 7 | 9 | 11 | 28852 | 10 | |||
147379 | 16905 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 441 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2009 12:00:00 AM | 3 | 3X3 | 6004878.06154 | 2110135.30859 | 37.774305258574 | -122.426579447402 | (37.774305258574, -122.426579447402) | 7 | 9 | 11 | 28852 | 10 | ||
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 | ||
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 | ||
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 | |||
62109 | 39858 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 514 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | 5 | Permit Number 41164 | 5992538.39814 | 2111929.42262 | 37.7785260826754 | -122.469394849438 | (37.7785260826754, -122.469394849438) | 11 | 6 | 2 | 54 | 11 | |
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 |
20425 | 44213 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1601 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/11/2006 12:00:00 AM | Permit Number 43660 | 5993363.56248215 | 2104576.56937915 | 37.7583847466967 | -122.466005883185 | (37.7583847466967, -122.466005883185) | 1 | 8 | 4 | 56 | 12 | ||
26392 | 207081 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1967 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5992237.02413 | 2102091.85973 | 37.7514973270376 | -122.469721026126 | (37.7514973270376, -122.469721026126) | 1 | 8 | 4 | 29491 | 12 | |||
34923 | 207085 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2091 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5993168.90781 | 2101284.15218 | 37.7493333873359 | -122.466439786693 | (37.7493333873359, -122.466439786693) | 1 | 8 | 4 | 29491 | 12 | |||
37381 | 207050 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1287 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5990781.88485 | 2106644.27108 | 37.7639128285243 | -122.475085316637 | (37.7639128285243, -122.475085316637) | 11 | 8 | 3 | 56 | 12 | |||
73982 | 207055 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1950 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5992276.06738 | 2102166.8288 | 37.7517054292832 | -122.469591467999 | (37.7517054292832, -122.469591467999) | 1 | 8 | 4 | 29491 | 12 | |||
79840 | 207070 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1927 08th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 6ft | 5993749.21516 | 2102356.41341 | 37.7523110111603 | -122.464510933358 | (37.7523110111603, -122.464510933358) | 1 | 8 | 4 | 29491 | 12 | |||
83215 | 32892 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1235 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/01/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778801 | 5993897.25914467 | 2107077.09548698 | 37.7652813146396 | -122.464341682773 | (37.7652813146396, -122.464341682773) | 11 | 5 | 11 | 56 | 12 |
111323 | 207069 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1927 08th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 6ft | 5993748.4844 | 2102370.47272 | 37.7523495722986 | -122.46451448117 | (37.7523495722986, -122.46451448117) | 1 | 8 | 4 | 29491 | 12 | |||
111828 | 207080 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1648 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992494.37113 | 2104224.85002 | 37.7573688352182 | -122.468986308793 | (37.7573688352182, -122.468986308793) | 1 | 8 | 4 | 56 | 12 | |||
114585 | 207071 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1927 08th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 6ft | 5993749.48127 | 2102344.6615 | 37.7522787587656 | -122.464509159894 | (37.7522787587656, -122.464509159894) | 1 | 8 | 4 | 29491 | 12 | |||
120589 | 207084 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2093 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5993169.37219 | 2101262.29203 | 37.7492733917544 | -122.466436592271 | (37.7492733917544, -122.466436592271) | 1 | 8 | 4 | 29491 | 12 | |||
144937 | 93854 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1109 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/2010 12:00:00 AM | 3x3 | Permit Number 53359 | 5990875 | 2103807 | 37.7561278331456 | -122.474556183246 | (37.7561278331456, -122.474556183246) | 1 | 8 | 4 | 56 | 12 | ||
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 | |||
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 |
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 | |||
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 | |||
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 | |||
8667 | 54838 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 215 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1972 12:00:00 AM | 6 | Permit Number 10692 | 5998766.6122 | 2109946.2443 | 37.7734387411862 | -122.447706373612 | (37.7734387411862, -122.447706373612) | 15 | 5 | 11 | 29492 | 16 | ||
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 | |||
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 | |||
4194 | 143382 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1600 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6005275.1713 | 2118900.2974 | 37.7983941790308 | -122.425829789965 | (37.7983941790308, -122.425829789965) | 13 | 9 | 1 | 57 | 17 | |||
62830 | 129391 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1851 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004117.78483 | 2119036.12679 | 37.7987016585207 | -122.429844394124 | (37.7987016585207, -122.429844394124) | 13 | 9 | 1 | 57 | 17 | |||
77228 | 129405 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 3545 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6000706.97602 | 2120551.39476 | 37.8026684412687 | -122.441755658294 | (37.8026684412687, -122.441755658294) | 13 | 9 | 1 | 57 | 17 | |||
80856 | 97675 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2562 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 6000810.80569 | 2117928.44871 | 37.7954724412642 | -122.441208053918 | (37.7954724412642, -122.441208053918) | 13 | 9 | 1 | 57 | 17 | ||||
104428 | 129406 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 3545 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6000708.23072 | 2120533.57312 | 37.8026195792908 | -122.441750036631 | (37.8026195792908, -122.441750036631) | 13 | 9 | 1 | 57 | 17 | |||
105798 | 84613 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2029-22031 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50833 | 6000517.35978 | 2120966.99196 | 37.8037987541811 | -122.442441679147 | (37.8037987541811, -122.442441679147) | 13 | 9 | 1 | 57 | 17 | |
112382 | 97676 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2562 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 6000785.23545 | 2117926.05562 | 37.7954644138979 | -122.441296359259 | (37.7954644138979, -122.441296359259) | 13 | 9 | 1 | 57 | 17 | ||||
119638 | 129403 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2844 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6000067.16914 | 2118384.00921 | 37.7966809025571 | -122.443813899808 | (37.7966809025571, -122.443813899808) | 13 | 9 | 1 | 57 | 17 | |||
133856 | 129404 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2844 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6000064.89028 | 2118400.48534 | 37.7967260116595 | -122.443822969478 | (37.7967260116595, -122.443822969478) | 13 | 9 | 1 | 57 | 17 | |||
137277 | 87873 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2341 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50845 | 6000097.31037 | 2119864.70248 | 37.8007482115146 | -122.443816038389 | (37.8007482115146, -122.443816038389) | 13 | 9 | 1 | 57 | 17 | |
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 | |
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 | |||
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 |
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 | |||
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 | ||||
14062 | 227597 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 501 14th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6005381.2036 | 2107800.12984 | 37.7679218515506 | -122.424672832791 | (37.7679218515506, -122.424672832791) | 8 | 4 | 5 | 28853 | 19 | |||
16225 | 227612 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1299 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6010076.05716 | 2101688.52056 | 37.7514047850101 | -122.408002743036 | (37.7514047850101, -122.408002743036) | 2 | 4 | 7 | 28859 | 19 | |||
20284 | 227665 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 46 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006330.78292 | 2109566.87483 | 37.7728264958779 | -122.421513830121 | (37.7728264958779, -122.421513830121) | 8 | 2 | 9 | 28853 | 19 | |||
20925 | 15425 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2101 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2X2 | 6006866.3108 | 2106096.3931 | 37.7633275539022 | -122.419415122194 | (37.7633275539022, -122.419415122194) | 8 | 4 | 7 | 28859 | 19 | |||
28569 | 227599 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 3542 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6005268.27661 | 2106072.00608 | 37.7631704570704 | -122.424940469222 | (37.7631704570704, -122.424940469222) | 8 | 4 | 5 | 28859 | 19 | |||
31466 | 45705 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2919 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/2002 12:00:00 AM | Permit Number 44379 | 6009358.73784624 | 2102738.93586586 | 37.754248802934 | -122.410557495705 | (37.754248802934, -122.410557495705) | 2 | 4 | 7 | 28859 | 19 | ||
31563 | 227640 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 3300X 22nd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006270.9018 | 2103197.69782 | 37.7553348592182 | -122.421268598461 | (37.7553348592182, -122.421268598461) | 2 | 4 | 5 | 28859 | 19 | |||
32476 | 227594 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 501 14th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6005345.94103 | 2107798.56704 | 37.7679155688764 | -122.424794690941 | (37.7679155688764, -122.424794690941) | 8 | 4 | 5 | 28853 | 19 | |||
36949 | 227666 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 46 Gough St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006306.62249 | 2109592.20963 | 37.7728946968577 | -122.421599203664 | (37.7728946968577, -122.421599203664) | 8 | 2 | 9 | 28853 | 19 | |||
45106 | 246316 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1660 Mission St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 0ft | 6006848.8767 | 2108962.1326 | 37.7711952166815 | -122.41967876451 | (37.7711952166815, -122.41967876451) | 8 | 2 | 9 | 28853 | 19 | |||
50918 | 227611 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 66 Balmy St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 3ft | 6008811.16325 | 2101739.45031 | 37.751473726132 | -122.412380510571 | (37.751473726132, -122.412380510571) | 2 | 4 | 7 | 28859 | 19 | |||
64244 | 227638 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 326 San Jose Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6006175.20644 | 2101155.72627 | 37.7497226795546 | -122.421454532416 | (37.7497226795546, -122.421454532416) | 2 | 4 | 5 | 28859 | 19 | |||
65023 | 227633 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 3240 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008124.7966 | 2100966.18492 | 37.7493119726844 | -122.414699339617 | (37.7493119726844, -122.414699339617) | 2 | 4 | 7 | 28859 | 19 | |||
70866 | 224462 | Planning Code 138.1 required 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2810 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/2017 12:00:00 AM | 3 | 3x3 | Permit Number 775960 | 6010311.37562 | 2101086.64633 | 37.7497653433983 | -122.407146558773 | (37.7497653433983, -122.407146558773) | 2 | 4 | 7 | 28859 | 19 | |
72292 | 227593 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 501 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6005330.86399 | 2107797.8602 | 37.7679127764864 | -122.424846790463 | (37.7679127764864, -122.424846790463) | 8 | 4 | 5 | 28853 | 19 | |||
77695 | 227635 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 3234 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008177.73099 | 2100971.34354 | 37.7493291110692 | -122.414516655822 | (37.7493291110692, -122.414516655822) | 2 | 4 | 7 | 28859 | 19 | |||
81001 | 246317 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1660 Mission St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 0ft | 6006842.0158 | 2108939.8347 | 37.7711336054687 | -122.419700914309 | (37.7711336054687, -122.419700914309) | 8 | 2 | 9 | 28853 | 19 | |||
81548 | 227664 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 46 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6006352.61358 | 2109543.15644 | 37.7727626017523 | -122.421436630498 | (37.7727626017523, -122.421436630498) | 8 | 2 | 9 | 28853 | 19 | |||
83129 | 227600 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 308 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 4ft | 6006510.89149 | 2104242.1298 | 37.7582161548565 | -122.420512774045 | (37.7582161548565, -122.420512774045) | 2 | 4 | 7 | 28859 | 19 | |||
93076 | 227595 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 501 14th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6005359.22331 | 2107799.65504 | 37.7679193064505 | -122.424748826411 | (37.7679193064505, -122.424748826411) | 8 | 4 | 5 | 28853 | 19 | |||
106988 | 227598 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 501 14th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6005393.4683 | 2107800.64006 | 37.7679239451627 | -122.424630446843 | (37.7679239451627, -122.424630446843) | 8 | 4 | 5 | 28853 | 19 | |||
110399 | 227596 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 501 14th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6005369.47041 | 2107799.69843 | 37.7679200043356 | -122.424713385909 | (37.7679200043356, -122.424713385909) | 8 | 4 | 5 | 28853 | 19 | |||
114599 | 240686 | Planning Code 138.1 required 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2810 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/2017 12:00:00 AM | 3 | 3x3 | Permit Number 775960 | 6010325.27315 | 2101087.17666 | 37.7497675773096 | -122.407098537685 | (37.7497675773096, -122.407098537685) | 2 | 4 | 7 | 28859 | 19 | |
126976 | 227634 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 3238 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008149.92124 | 2100968.79152 | 37.7493205414166 | -122.414612642259 | (37.7493205414166, -122.414612642259) | 2 | 4 | 7 | 28859 | 19 | |||
139715 | 227639 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 326 San Jose Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6006173.90943 | 2101141.69074 | 37.7496840680694 | -122.42145802088 | (37.7496840680694, -122.42145802088) | 2 | 4 | 5 | 28859 | 19 | |||
140002 | 45704 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2923 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/2002 12:00:00 AM | Permit Number 44378 | 6009338.32453862 | 2102737.8165792 | 37.7542445851646 | -122.410628011277 | (37.7542445851646, -122.410628011277) | 2 | 4 | 7 | 28859 | 19 | ||
144752 | 246315 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1660 Mission St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 0ft | 6006857.4528 | 2108984.4305 | 37.7712569245067 | -122.419650681714 | (37.7712569245067, -122.419650681714) | 8 | 2 | 9 | 28853 | 19 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
2463 | 227603 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1201 San Jose Ave | 55 | Front Yard : Yard | Tree | Private 2 | 2 | 6004504.07862 | 2096101.18791 | 37.7357497087738 | -122.42687342979 | (37.7357497087738, -122.42687342979) | 2 | 7 | 5 | 28861 | 2 | ||||
27188 | 227606 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1201 San Jose Ave | 60 | Front Yard : Yard | Tree | Private 2 | 3 | 6004509.90475 | 2096122.13365 | 37.7358075504724 | -122.426854777822 | (37.7358075504724, -122.426854777822) | 2 | 7 | 5 | 28861 | 2 | ||||
43158 | 227617 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 115 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6009080.60999 | 2097991.13845 | 37.7411968070922 | -122.411183978775 | (37.7411968070922, -122.411183978775) | 10 | 7 | 7 | 28859 | 2 | |||
43906 | 227618 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 119 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6009077.39378 | 2097965.31988 | 37.7411257345706 | -122.411193275964 | (37.7411257345706, -122.411193275964) | 10 | 7 | 7 | 28859 | 2 | |||
50767 | 227610 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 400 Prospect Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 25 | 6006250.04952 | 2097648.94567 | 37.7400980729811 | -122.420946773391 | (37.7400980729811, -122.420946773391) | 2 | 7 | 7 | 28859 | 2 | ||||
56859 | 227608 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1201 San Jose Ave | 73 | Front Yard : Yard | Tree | Private 2 | 3 | 6004572.06439 | 2096162.43718 | 37.7359217292935 | -122.426642736581 | (37.7359217292935, -122.426642736581) | 2 | 7 | 5 | 28861 | 2 | ||||
62609 | 52479 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 119POWHATTAN Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48589 | 6009084.88956475 | 2097947.60140706 | 37.7410775038925 | -122.411166106845 | (37.7410775038925, -122.411166106845) | 10 | 7 | 7 | 28859 | 2 | ||
71944 | 247957 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 8 Joy St | 1 | Front Yard : Yard | Tree | Private 2 | 41 | 6010434.99272 | 2098878.7541 | 37.743709870826 | -122.406563517506 | (37.743709870826, -122.406563517506) | 2 | 7 | 7 | 28859 | 2 | ||||
81506 | 227602 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1201 San Jose Ave | 54 | Front Yard : Yard | Tree | Private 2 | 1 | 6004494.61967 | 2096104.27773 | 37.735757657888 | -122.426906353066 | (37.735757657888, -122.426906353066) | 2 | 7 | 5 | 28861 | 2 | ||||
92397 | 248214 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 67 Fair Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 6ft | 6006956.2223 | 2099478.83098 | 37.7451623091856 | -122.41863484214 | (37.7451623091856, -122.41863484214) | 2 | 7 | 7 | 28859 | 2 | |||
93391 | 227607 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1201 San Jose Ave | 61 | Front Yard : Yard | Tree | Private 2 | 2 | 6004513.17713 | 2096122.0643 | 37.7358075450783 | -122.426843458979 | (37.7358075450783, -122.426843458979) | 2 | 7 | 5 | 28861 | 2 | ||||
97150 | 227604 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1201 San Jose Ave | 57 | Front Yard : Yard | Tree | Private 2 | 4 | 6004502.9106 | 2096117.99556 | 37.7357957927473 | -122.426878664735 | (37.7357957927473, -122.426878664735) | 2 | 7 | 5 | 28861 | 2 | ||||
98350 | 227609 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 400 Prospect Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 33 | 6006260.17283 | 2097644.39448 | 37.740086147061 | -122.420911448013 | (37.740086147061, -122.420911448013) | 2 | 7 | 7 | 28859 | 2 | ||||
101466 | 227605 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1201 San Jose Ave | 58 | Front Yard : Yard | Tree | Private 2 | 2 | 6004504.61589 | 2096121.06345 | 37.7358043129022 | -122.426872987299 | (37.7358043129022, -122.426872987299) | 2 | 7 | 5 | 28861 | 2 | ||||
126007 | 246778 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 392 Franconia St | 2 | Back Yard : Yard | Tree | Private 2 | 12 | 6009934.46977 | 2098852.71045 | 37.7436103455484 | -122.408292376913 | (37.7436103455484, -122.408292376913) | 2 | 7 | 7 | 28859 | 2 | ||||
126238 | 227613 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 210 Holladay Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6010812.41233 | 2099853.77151 | 37.7464081651998 | -122.405327133143 | (37.7464081651998, -122.405327133143) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
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 | ||
7029 | 191358 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1780 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015118.78707 | 2107382.75466 | 37.7673209722044 | -122.390962181167 | (37.7673209722044, -122.390962181167) | 14 | 3 | 9 | 310 | 20 | |||
18052 | 197677 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 410 China Basin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/09/2020 12:00:00 AM | 3 | Width 5ft | Permit Number 784444 | 6015989.40646 | 2109125.42769 | 37.7721542427634 | -122.388072430121 | (37.7721542427634, -122.388072430121) | 14 | 3 | 9 | 310 | 20 | |
19841 | 191318 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1505 04th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015134.48609 | 2108114.99928 | 37.7693324264746 | -122.390959063205 | (37.7693324264746, -122.390959063205) | 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) );