trees
1,914 rows where qSpecies_id = 45 sorted by TreeID
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 75042 | 100252 | DPW Maintained 1 | :: 45 | 540 Delancey St | 6 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3 | 3x3 | 6015236.96681 | 2113599.67086 | 37.784397795653 | -122.390987973742 | (37.784397795653, -122.390987973742) | 6 | 2 | 9 | 28856 | 6 | |||
| 57424 | 101476 | Significant Tree 6 | :: 45 | 541 Congo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2015 12:00:00 AM | 3 | Permit Number 775316 | 6000089 | 2095440.1 | 37.7336838892166 | -122.442090592963 | (37.7336838892166, -122.442090592963) | 9 | 7 | 4 | 63 | 40 | ||
| 80835 | 10233 | DPW Maintained 1 | :: 45 | 20 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005984.609 | 2109698.904 | 37.77316949126 | -122.422720671561 | (37.77316949126, -122.422720671561) | 7 | 9 | 11 | 28852 | 10 | |||
| 57150 | 10247 | DPW Maintained 1 | :: 45 | 112 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/1997 12:00:00 AM | 8 | 3X3 | 6005536.2501 | 2109637.4907 | 37.7729755585516 | -122.424267236647 | (37.7729755585516, -122.424267236647) | 7 | 9 | 11 | 28852 | 10 | ||
| 45444 | 10257 | DPW Maintained 1 | :: 45 | 155 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/2006 12:00:00 AM | 6 | 3X3 | 6005354.14588 | 2109555.43017 | 37.7727399559066 | -122.424891318606 | (37.7727399559066, -122.424891318606) | 7 | 9 | 11 | 28852 | 10 | ||
| 30439 | 10286 | DPW Maintained 1 | :: 45 | 412 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | 3x3 | 6004126.8809 | 2109434.3591 | 37.7723381274034 | -122.429127930043 | (37.7723381274034, -122.429127930043) | 7 | 9 | 11 | 29492 | 10 | |||
| 138927 | 10288 | DPW Maintained 1 | :: 45 | 447 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/30/2011 12:00:00 AM | 3 | 3x3 | 6003998.90174 | 2109366.95645 | 37.7721458107158 | -122.429565813827 | (37.7721458107158, -122.429565813827) | 7 | 9 | 11 | 29492 | 10 | ||
| 49325 | 10299 | DPW Maintained 1 | :: 45 | 559 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6003469.25661 | 2109295.83619 | 37.7719205287291 | -122.431392821626 | (37.7719205287291, -122.431392821626) | 15 | 9 | 11 | 29492 | 10 | |||
| 95197 | 10300 | DPW Maintained 1 | :: 45 | 548 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6003485.1293 | 2109346.6257 | 37.772060883831 | -122.43134154303 | (37.772060883831, -122.43134154303) | 15 | 9 | 11 | 29492 | 10 | |||
| 146185 | 10323 | DPW Maintained 1 | :: 45 | 774 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2009 12:00:00 AM | 3 | 3X3 | 6002445.3097 | 2109202.4042 | 37.7716059027417 | -122.43492804084 | (37.7716059027417, -122.43492804084) | 15 | 5 | 11 | 29492 | 9 | ||
| 113400 | 10343 | DPW Maintained 1 | :: 45 | 940 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6001599.8151 | 2109085.1313 | 37.7712358586189 | -122.437844249148 | (37.7712358586189, -122.437844249148) | 15 | 5 | 11 | 29492 | 9 | |||
| 185827 | 10354 | DPW Maintained 1 | :: 45 | 1016 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/28/2000 12:00:00 AM | 20 | 3X3 | 6001244.7283 | 2109040.2146 | 37.7710923306016 | -122.439069286514 | (37.7710923306016, -122.439069286514) | 15 | 5 | 11 | 29492 | 9 | ||
| 53806 | 103672 | Undocumented 4 | :: 45 | 2416 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6008103.2 | 2104332.6 | 37.7585541718373 | -122.415012265425 | (37.7585541718373, -122.415012265425) | 2 | 4 | 7 | 28859 | 19 | |||
| 179317 | 103673 | Property Tree 8 | :: 45 | 64 Henry St | Back Yard : Yard | Tree | Private 2 | 6003097 | 2107420 | 37.7667488371496 | -122.432546472662 | (37.7667488371496, -122.432546472662) | 15 | 5 | 5 | 28862 | 3 | ||||||
| 31577 | 104151 | DPW Maintained 1 | :: 45 | 525X Church St | 1 | Sidewalk: Property side : Cutout | Landscaping | SFUSD 4 | DPW | 2x58 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | 8 | 4 | 5 | 28862 | 3 | |||
| 164652 | 104152 | DPW Maintained 1 | :: 45 | 525X Church St | 2 | Sidewalk: Property side : Cutout | Landscaping | SFUSD 4 | DPW | 2x68 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | 8 | 4 | 5 | 28862 | 3 | |||
| 153628 | 104153 | DPW Maintained 1 | :: 45 | 525X Church St | 1 | Sidewalk: Curb side : Cutout | Landscaping | SFUSD 4 | DPW | 5x17 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | 8 | 4 | 5 | 28862 | 3 | |||
| 79291 | 104154 | DPW Maintained 1 | :: 45 | 525X Church St | 2 | Sidewalk: Curb side : Cutout | Landscaping | SFUSD 4 | DPW | 5x17 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | 8 | 4 | 5 | 28862 | 3 | |||
| 111419 | 104155 | DPW Maintained 1 | :: 45 | 525X Church St | 3 | Sidewalk: Curb side : Cutout | Landscaping | SFUSD 4 | DPW | 5x17 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | 8 | 4 | 5 | 28862 | 3 | |||
| 94668 | 104156 | DPW Maintained 1 | :: 45 | 525X Church St | 4 | Sidewalk: Curb side : Cutout | Landscaping | SFUSD 4 | DPW | 5x20 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | 8 | 4 | 5 | 28862 | 3 | |||
| 156692 | 104157 | DPW Maintained 1 | :: 45 | 525X Church St | 5 | Sidewalk: Curb side : Cutout | Landscaping | SFUSD 4 | DPW | 5x20 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | 8 | 4 | 5 | 28862 | 3 | |||
| 18687 | 104158 | DPW Maintained 1 | :: 45 | 525X Church St | 6 | Sidewalk: Curb side : Cutout | Landscaping | SFUSD 4 | DPW | 5x20 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | 8 | 4 | 5 | 28862 | 3 | |||
| 127241 | 104634 | DPW Maintained 1 | :: 45 | 217 Montcalm St | Front Yard : Yard | Landscaping | Private 2 | 16x16 | 6009833.3 | 2099565.6 | 37.7455621186719 | -122.408692480229 | (37.7455621186719, -122.408692480229) | 2 | 7 | 7 | 28859 | 2 | |||||
| 178111 | 104635 | DPW Maintained 1 | :: 45 | 217 Montcalm St | Front Yard : Yard | Landscaping | Private 2 | 16x16 | 6009833.3 | 2099565.6 | 37.7455621186719 | -122.408692480229 | (37.7455621186719, -122.408692480229) | 2 | 7 | 7 | 28859 | 2 | |||||
| 171517 | 104636 | DPW Maintained 1 | :: 45 | 217 Montcalm St | Front Yard : Yard | Landscaping | Private 2 | 16x16 | 6010036 | 2099691 | 37.7459177905176 | -122.408000413375 | (37.7459177905176, -122.408000413375) | 2 | 7 | 7 | 28859 | 2 | |||||
| 148544 | 104637 | DPW Maintained 1 | :: 45 | 217 Montcalm St | Front Yard : Yard | Landscaping | Private 2 | 16x16 | 6010036 | 2099691 | 37.7459177905176 | -122.408000413375 | (37.7459177905176, -122.408000413375) | 2 | 7 | 7 | 28859 | 2 | |||||
| 31000 | 104827 | Permitted Site 7 | :: 45 | 4366 26th St | : Cutout | Tree | Private 2 | 3X3 | 6001535.3 | 2100615.2 | 37.7479758185871 | -122.437460780102 | (37.7479758185871, -122.437460780102) | 2 | 4 | 5 | 28862 | 22 | |||||
| 165 | 104843 | Permitted Site 7 | :: 45 | 1320 21st Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5989622 | 2106334.7 | 37.7629955389606 | -122.479074319647 | (37.7629955389606, -122.479074319647) | 1 | 8 | 3 | 56 | 35 | ||||||
| 123101 | 104856 | DPW Maintained 1 | :: 45 | 739 27th St | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 02/12/2015 12:00:00 AM | 3 | 6001722.3 | 2099959.7 | 37.7461866004606 | -122.436767226643 | (37.7461866004606, -122.436767226643) | 2 | 7 | 5 | 63 | 22 | ||||
| 391 | 104857 | DPW Maintained 1 | :: 45 | 2555 46th Ave | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 5982069.8 | 2097707.6 | 37.7388664658919 | -122.504555139124 | (37.7388664658919, -122.504555139124) | 1 | 8 | 3 | 29491 | 35 | ||||||
| 2548 | 104858 | DPW Maintained 1 | :: 45 | 4205 24th St | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 6001816 | 2101720.7 | 37.7510272133613 | -122.436569249202 | (37.7510272133613, -122.436569249202) | 2 | 4 | 5 | 28862 | 22 | ||||||
| 104259 | 104859 | DPW Maintained 1 | :: 45 | 650 Fillmore St | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 6003597.7 | 2110555.4 | 37.775386259915 | -122.431038440447 | (37.775386259915, -122.431038440447) | 7 | 9 | 11 | 29492 | 10 | ||||||
| 104748 | 104860 | DPW Maintained 1 | :: 45 | 283 Randall St | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 6003774.7 | 2097827.3 | 37.7404479510811 | -122.429518236565 | (37.7404479510811, -122.429518236565) | 2 | 7 | 5 | 63 | 7 | ||||||
| 78434 | 104861 | DPW Maintained 1 | :: 45 | 3458A 18th St | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 6006508 | 2105569.9 | 37.7618617394874 | -122.420617027809 | (37.7618617394874, -122.420617027809) | 8 | 4 | 7 | 28859 | 19 | ||||||
| 141766 | 104864 | DPW Maintained 1 | :: 45 | 45 Hoffman Ave | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 6000629.3 | 2102650 | 37.7535113392088 | -122.440739618385 | (37.7535113392088, -122.440739618385) | 2 | 4 | 5 | 28862 | 22 | ||||||
| 57332 | 104890 | Undocumented 4 | :: 45 | 150 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | empty | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | ||||
| 152782 | 104960 | Permitted Site 7 | :: 45 | 2895 San Bruno Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6011715.1 | 2091289.8 | 37.7229437265236 | -122.401603910944 | (37.7229437265236, -122.401603910944) | 10 | 3 | 7 | 309 | 28 | ||||||
| 169238 | 105039 | DPW Maintained 1 | :: 45 | 2660 Harrison St | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 2x7 | 6008868.4 | 2102978.1 | 37.7548779915591 | -122.412270115586 | (37.7548779915591, -122.412270115586) | 2 | 4 | 7 | 28859 | 19 | ||||
| 191035 | 105040 | DPW Maintained 1 | :: 45 | 2660 Harrison St | 2 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 2x7 | 6008868.4 | 2102978.1 | 37.7548779915591 | -122.412270115586 | (37.7548779915591, -122.412270115586) | 2 | 4 | 7 | 28859 | 19 | ||||
| 171662 | 105041 | DPW Maintained 1 | :: 45 | 2660 Harrison St | 3 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 2x2 | 6008868.4 | 2102978.1 | 37.7548779915591 | -122.412270115586 | (37.7548779915591, -122.412270115586) | 2 | 4 | 7 | 28859 | 19 | ||||
| 142135 | 105042 | DPW Maintained 1 | :: 45 | 2660 Harrison St | 4 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 2x10 | 6008868.4 | 2102978.1 | 37.7548779915591 | -122.412270115586 | (37.7548779915591, -122.412270115586) | 2 | 4 | 7 | 28859 | 19 | ||||
| 17437 | 105043 | DPW Maintained 1 | :: 45 | 2660 Harrison St | 5 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 2x4 | 6008902 | 2102968 | 37.7548521445958 | -122.412153203197 | (37.7548521445958, -122.412153203197) | 2 | 4 | 7 | 28859 | 19 | ||||
| 138642 | 105046 | Permitted Site 7 | :: 45 | 268 Capitol Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5995102.1 | 2087921.7 | 37.7127547049329 | -122.458787524461 | (37.7127547049329, -122.458787524461) | 9 | 8 | 6 | 28861 | 24 | ||||||
| 187984 | 105065 | Permitted Site 7 | :: 45 | 3177 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006744 | 2099801.7 | 37.7460368842113 | -122.419391572433 | (37.7460368842113, -122.419391572433) | 2 | 7 | 7 | 28859 | 2 | ||||
| 15911 | 105081 | Significant Tree 6 | :: 45 | 344 Fulton St | 1 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
| 126537 | 105082 | Significant Tree 6 | :: 45 | 344 Fulton St | 2 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
| 167444 | 105083 | Significant Tree 6 | :: 45 | 344 Fulton St | 3 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
| 75459 | 105084 | Significant Tree 6 | :: 45 | 344 Fulton St | 4 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
| 145102 | 105085 | Significant Tree 6 | :: 45 | 344 Fulton St | 5 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
| 17108 | 105086 | Significant Tree 6 | :: 45 | 344 Fulton St | 6 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
| 154153 | 105087 | Significant Tree 6 | :: 45 | 344 Fulton St | 7 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
| 186789 | 105088 | Significant Tree 6 | :: 45 | 344 Fulton St | 8 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
| 803 | 105089 | Significant Tree 6 | :: 45 | 344 Fulton St | 9 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
| 161677 | 105090 | Significant Tree 6 | :: 45 | 344 Fulton St | 10 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
| 91093 | 105091 | Significant Tree 6 | :: 45 | 344 Fulton St | 11 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
| 37319 | 105121 | Undocumented 4 | :: 45 | 721 BEACH ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 6006739.7 | 2121813.5 | 37.8064757462399 | -122.420969011396 | (37.8064757462399, -122.420969011396) | 5 | 1 | 1 | 28858 | 32 | |||||
| 49257 | 105359 | Permitted Site 7 | :: 45 | 850 Guerrero St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12x2.75 | 6005583.5 | 2103975.8 | 37.7574325683666 | -122.423701164602 | (37.7574325683666, -122.423701164602) | 2 | 4 | 5 | 28859 | 19 | ||||
| 80379 | 105360 | Permitted Site 7 | :: 45 | 850 Guerrero St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12x2.75 | 6005583.5 | 2103975.8 | 37.7574325683666 | -122.423701164602 | (37.7574325683666, -122.423701164602) | 2 | 4 | 5 | 28859 | 19 | ||||
| 740 | 105361 | Permitted Site 7 | :: 45 | 850 Guerrero St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12x2.75 | 6005583.5 | 2103975.8 | 37.7574325683666 | -122.423701164602 | (37.7574325683666, -122.423701164602) | 2 | 4 | 5 | 28859 | 19 | ||||
| 128780 | 105437 | Undocumented 4 | :: 45 | 1116 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002483 | 2102334 | 37.7527490702591 | -122.434306541099 | (37.7527490702591, -122.434306541099) | 2 | 4 | 5 | 28862 | 22 | ||||
| 217 | 105438 | Undocumented 4 | :: 45 | 1116 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002483 | 2102334 | 37.7527490702591 | -122.434306541099 | (37.7527490702591, -122.434306541099) | 2 | 4 | 5 | 28862 | 22 | ||||
| 65959 | 105925 | Permitted Site 7 | :: 45 | 4166 20th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6002608.6 | 2104160 | 37.7577699584222 | -122.434002709079 | (37.7577699584222, -122.434002709079) | 2 | 4 | 5 | 28862 | 3 | |||||
| 149955 | 106460 | Undocumented 4 | :: 45 | 701 Cortland Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6007932 | 2097222.5 | 37.7390218122591 | -122.415101080128 | (37.7390218122591, -122.415101080128) | 2 | 7 | 7 | 28859 | 2 | |||||
| 159590 | 106461 | Undocumented 4 | :: 45 | 701 Cortland Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6007932 | 2097222.5 | 37.7390218122591 | -122.415101080128 | (37.7390218122591, -122.415101080128) | 2 | 7 | 7 | 28859 | 2 | |||||
| 98201 | 106968 | Property Tree 8 | :: 45 | 351 26th Ave | Back Yard : Yard | Tree | Private 2 | 5987720.26121 | 2113604.44601 | 37.7828456076198 | -122.486185401226 | (37.7828456076198, -122.486185401226) | 11 | 6 | 2 | 55 | 26 | ||||||
| 18457 | 107144 | DPW Maintained 1 | :: 45 | 360 Spear St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 02/12/2020 12:00:00 AM | 3 | 6015708 | 2115219 | 37.7888702311939 | -122.38947147438 | (37.7888702311939, -122.38947147438) | 6 | 2 | 9 | 28855 | 6 | |||
| 112197 | 107208 | Undocumented 4 | :: 45 | 3795 Market St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6000195.59748 | 2102713.68465 | 37.7536614933614 | -122.442244022259 | (37.7536614933614, -122.442244022259) | 2 | 4 | 5 | 63 | 38 | |||||
| 121061 | 107631 | Undocumented 4 | :: 45 | 4059 26th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003507 | 2100669 | 37.7482354401484 | -122.430646564887 | (37.7482354401484, -122.430646564887) | 2 | 4 | 5 | 63 | 22 | ||||||
| 128768 | 108370 | DPW Maintained 1 | :: 45 | 823 Euclid Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/11/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774572 | 5995757.23416 | 2113775.59974 | 37.783780682228 | -122.458393411251 | (37.783780682228, -122.458393411251) | 11 | 6 | 1 | 54 | 31 | |
| 23775 | 108576 | Property Tree 8 | :: 45 | 2479 Diamond St | 1 | Front Yard : Yard | Landscaping | Private 2 | 6002240 | 2097369 | 37.7391025518434 | -122.434791855338 | (37.7391025518434, -122.434791855338) | 2 | 7 | 5 | 63 | 7 | |||||
| 146174 | 108618 | Undocumented 4 | :: 45 | 150-198X Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6005405 | 2109611 | 37.7728954095296 | -122.424719362301 | (37.7728954095296, -122.424719362301) | 7 | 9 | 11 | 28852 | 10 | |||||
| 55800 | 108629 | Undocumented 4 | :: 45 | 82-98X Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6002862.02202 | 2108710.63631 | 37.7702792804688 | -122.433451461668 | (37.7702792804688, -122.433451461668) | 15 | 5 | 5 | 29492 | 9 | |||
| 17525 | 108731 | Undocumented 4 | :: 45 | 1822-1898X 23rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013006 | 2102886 | 37.7548564119513 | -122.39795458116 | (37.7548564119513, -122.39795458116) | 10 | 3 | 8 | 28856 | 29 | ||||
| 11756 | 108765 | Undocumented 4 | :: 45 | 500X Lathrop Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | 10 | 3 | 8 | 309 | 1 | ||||
| 142114 | 108771 | Undocumented 4 | :: 45 | 500X Lathrop Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | 10 | 3 | 8 | 309 | 1 | ||||
| 42415 | 108792 | Permitted Site 7 | :: 45 | 201-299 University St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6008053.41125 | 2093004.09823 | 37.7274458184293 | -122.414382893832 | (37.7274458184293, -122.414382893832) | 9 | 3 | 7 | 309 | 28 | ||||
| 61663 | 108793 | Permitted Site 7 | :: 45 | 201-299 University St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6008053.41125 | 2093004.09823 | 37.7274458184293 | -122.414382893832 | (37.7274458184293, -122.414382893832) | 9 | 3 | 7 | 309 | 28 | ||||
| 190627 | 108795 | Undocumented 4 | :: 45 | 501-599 University St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008503.45306 | 2091469.83252 | 37.7232583218261 | -122.412718672961 | (37.7232583218261, -122.412718672961) | 9 | 3 | 7 | 309 | 18 | |||||
| 144 | 108797 | Undocumented 4 | :: 45 | 501-599 University St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008503.45306 | 2091469.83252 | 37.7232583218261 | -122.412718672961 | (37.7232583218261, -122.412718672961) | 9 | 3 | 7 | 309 | 18 | |||||
| 176269 | 108798 | Undocumented 4 | :: 45 | 501-599 University St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008503.45306 | 2091469.83252 | 37.7232583218261 | -122.412718672961 | (37.7232583218261, -122.412718672961) | 9 | 3 | 7 | 309 | 18 | |||||
| 151586 | 108799 | Undocumented 4 | :: 45 | 501-599 University St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008503.45306 | 2091469.83252 | 37.7232583218261 | -122.412718672961 | (37.7232583218261, -122.412718672961) | 9 | 3 | 7 | 309 | 18 | |||||
| 169454 | 108800 | Undocumented 4 | :: 45 | 501-599 University St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008503.45306 | 2091469.83252 | 37.7232583218261 | -122.412718672961 | (37.7232583218261, -122.412718672961) | 9 | 3 | 7 | 309 | 18 | |||||
| 49143 | 108801 | Undocumented 4 | :: 45 | 501-599 University St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008503.45306 | 2091469.83252 | 37.7232583218261 | -122.412718672961 | (37.7232583218261, -122.412718672961) | 9 | 3 | 7 | 309 | 18 | |||||
| 54539 | 108802 | Undocumented 4 | :: 45 | 401-499 University St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008323.15237 | 2092121.01007 | 37.7250361958168 | -122.413387969207 | (37.7250361958168, -122.413387969207) | 9 | 3 | 7 | 309 | 28 | |||||
| 301 | 108803 | Undocumented 4 | :: 45 | 401-499 University St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008323.15237 | 2092121.01007 | 37.7250361958168 | -122.413387969207 | (37.7250361958168, -122.413387969207) | 9 | 3 | 7 | 309 | 28 | |||||
| 121161 | 108804 | Undocumented 4 | :: 45 | 401-499 University St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008323.15237 | 2092121.01007 | 37.7250361958168 | -122.413387969207 | (37.7250361958168, -122.413387969207) | 9 | 3 | 7 | 309 | 28 | |||||
| 11763 | 108805 | Undocumented 4 | :: 45 | 401-499 University St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008323.15237 | 2092121.01007 | 37.7250361958168 | -122.413387969207 | (37.7250361958168, -122.413387969207) | 9 | 3 | 7 | 309 | 28 | |||||
| 15900 | 108806 | Undocumented 4 | :: 45 | 401-499 University St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008323.15237 | 2092121.01007 | 37.7250361958168 | -122.413387969207 | (37.7250361958168, -122.413387969207) | 9 | 3 | 7 | 309 | 28 | |||||
| 114694 | 108807 | Undocumented 4 | :: 45 | 401-499 University St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008323.15237 | 2092121.01007 | 37.7250361958168 | -122.413387969207 | (37.7250361958168, -122.413387969207) | 9 | 3 | 7 | 309 | 28 | |||||
| 45721 | 108810 | Undocumented 4 | :: 45 | 301-399 University St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008160.40727 | 2092653.74948 | 37.7264898456848 | -122.413988233103 | (37.7264898456848, -122.413988233103) | 9 | 3 | 7 | 309 | 28 | |||||
| 392 | 108811 | Undocumented 4 | :: 45 | 301-399 University St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008160.40727 | 2092653.74948 | 37.7264898456848 | -122.413988233103 | (37.7264898456848, -122.413988233103) | 9 | 3 | 7 | 309 | 28 | |||||
| 11776 | 108812 | Undocumented 4 | :: 45 | 301-399 University St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008160.40727 | 2092653.74948 | 37.7264898456848 | -122.413988233103 | (37.7264898456848, -122.413988233103) | 9 | 3 | 7 | 309 | 28 | |||||
| 152288 | 108813 | Undocumented 4 | :: 45 | 301-399 University St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008160.40727 | 2092653.74948 | 37.7264898456848 | -122.413988233103 | (37.7264898456848, -122.413988233103) | 9 | 3 | 7 | 309 | 28 | |||||
| 110125 | 108826 | Undocumented 4 | :: 45 | 146-150X Gillette Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6013072.89275 | 2086799.91674 | 37.7106910734067 | -122.39659568235 | (37.7106910734067, -122.39659568235) | 10 | 3 | 8 | 309 | 1 | ||||
| 435 | 108949 | Permitted Site 7 | :: 45 | 254 Dublin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6003932.1 | 2088992 | 37.7161971007686 | -122.428344449747 | (37.7161971007686, -122.428344449747) | 9 | 7 | 6 | 28861 | 5 | |||
| 137408 | 108988 | Undocumented 4 | :: 45 | 2073-2099X Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999311.1 | 2121145.9 | 37.8042211586385 | -122.446628874501 | (37.8042211586385, -122.446628874501) | 13 | 9 | 1 | 57 | 17 | |||||
| 88682 | 108989 | Undocumented 4 | :: 45 | 2073-2099X Jefferson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999311.1 | 2121145.9 | 37.8042211586385 | -122.446628874501 | (37.8042211586385, -122.446628874501) | 13 | 9 | 1 | 57 | 17 | |||||
| 36178 | 108990 | Undocumented 4 | :: 45 | 2073-2099X Jefferson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999311.1 | 2121145.9 | 37.8042211586385 | -122.446628874501 | (37.8042211586385, -122.446628874501) | 13 | 9 | 1 | 57 | 17 | |||||
| 113379 | 108992 | Undocumented 4 | :: 45 | 2073-2099X Jefferson St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999311.1 | 2121145.9 | 37.8042211586385 | -122.446628874501 | (37.8042211586385, -122.446628874501) | 13 | 9 | 1 | 57 | 17 | |||||
| 180843 | 108993 | Undocumented 4 | :: 45 | 2073-2099X Jefferson St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999311.1 | 2121145.9 | 37.8042211586385 | -122.446628874501 | (37.8042211586385, -122.446628874501) | 13 | 9 | 1 | 57 | 17 |
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) );