trees
353 rows where qCaretaker_id = 2 and qSpecies_id = 47 sorted by Longitude
This data as json, CSV (advanced)
These facets timed out: qCaretaker_id
| 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 76454 | 227670 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 403 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6005513.92482 | 2101330.09926 | 37.7501641603604 | -122.423753669923 | (37.7501641603604, -122.423753669923) | 2 | 4 | 5 | 28859 | 19 | |||
| 141197 | 227672 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1000 San Jose Ave | 62 | Front Yard : Yard | Tree | Private 2 | 15 | 6005095.2123 | 2097053.48648 | 37.7383979127325 | -122.424897379118 | (37.7383979127325, -122.424897379118) | 2 | 7 | 5 | 28859 | 7 | ||||
| 118985 | 227671 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1000 San Jose Ave | 60 | Front Yard : Yard | Tree | Private 2 | 10 | 6005087.18528 | 2097058.71456 | 37.7384118144577 | -122.424925504521 | (37.7384118144577, -122.424925504521) | 2 | 7 | 5 | 63 | 7 | ||||
| 181040 | 227673 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1000 San Jose Ave | 64 | Front Yard : Yard | Tree | Private 2 | 12 | 6005078.09924 | 2097049.53511 | 37.7383860965292 | -122.424956266738 | (37.7383860965292, -122.424956266738) | 2 | 7 | 5 | 63 | 7 | ||||
| 121679 | 227674 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1000 San Jose Ave | 83 | Front Yard : Yard | Tree | Private 2 | 15 | 6005065.10158 | 2097012.05309 | 37.7382824451638 | -122.424998540269 | (37.7382824451638, -122.424998540269) | 2 | 7 | 5 | 63 | 7 | ||||
| 156310 | 227675 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1000 San Jose Ave | 104 | Front Yard : Yard | Tree | Private 2 | 27 | 6005040.40727 | 2096975.56438 | 37.7381808604543 | -122.425081325568 | (37.7381808604543, -122.425081325568) | 2 | 7 | 5 | 63 | 7 | ||||
| 148893 | 42597 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1950 Clay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | 7 | Permit Number 42667 | 6005420.67346 | 2116544.61332 | 37.7919342879744 | -122.425158599805 | (37.7919342879744, -122.425158599805) | 13 | 9 | 1 | 28858 | 27 | ||
| 30568 | 129464 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1974 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6005282.18317 | 2116523.47353 | 37.7918684189526 | -122.425636272008 | (37.7918684189526, -122.425636272008) | 13 | 9 | 1 | 28858 | 27 | |||
| 122863 | 129465 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1974 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6005261.30695 | 2116522.05783 | 37.791863352156 | -122.425708403014 | (37.791863352156, -122.425708403014) | 13 | 9 | 1 | 28858 | 27 | |||
| 105151 | 129466 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1974 Clay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6005243.67184 | 2116520.57545 | 37.7918582853821 | -122.425769315008 | (37.7918582853821, -122.425769315008) | 13 | 9 | 1 | 28858 | 27 | |||
| 139898 | 105256 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 162 Prague St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2014 12:00:00 AM | 3x3 | Permit Number 771043 | 6004383.3 | 2090213.9 | 37.7195776934466 | -122.42687185684 | (37.7195776934466, -122.42687185684) | 9 | 7 | 6 | 28861 | 5 | ||
| 73352 | 34348 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 330 Arlington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38106 | 6004294.50938701 | 2096370.47715627 | 37.7364772644099 | -122.427617172202 | (37.7364772644099, -122.427617172202) | 2 | 7 | 5 | 63 | 7 | ||
| 67862 | 37850 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 211 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/1998 12:00:00 AM | Permit Number 40141 | 6003943.02561838 | 2092441.0681197 | 37.7256681018117 | -122.428552395212 | (37.7256681018117, -122.428552395212) | 9 | 7 | 6 | 28861 | 5 | ||
| 56832 | 227680 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1541 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6003988.60954 | 2099295.31119 | 37.7444908816604 | -122.428883253577 | (37.7444908816604, -122.428883253577) | 2 | 7 | 5 | 63 | 22 | |||
| 22890 | 50289 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 300 Valley St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2003 12:00:00 AM | 3x3 | 6003944.88624926 | 2099274.1797934 | 37.7444303848395 | -122.42903293346 | (37.7444303848395, -122.42903293346) | 2 | 7 | 5 | 63 | 22 | ||
| 84280 | 50293 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 300 Valley St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2003 12:00:00 AM | 3x3 | 6003944.88624926 | 2099274.1797934 | 37.7444303848395 | -122.42903293346 | (37.7444303848395, -122.42903293346) | 2 | 7 | 5 | 63 | 22 | ||
| 89527 | 50288 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 300 Valley St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2003 12:00:00 AM | 3x3 | 6003944.88624926 | 2099274.1797934 | 37.7444303848395 | -122.42903293346 | (37.7444303848395, -122.42903293346) | 2 | 7 | 5 | 63 | 22 | ||
| 112832 | 50290 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 300 Valley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2003 12:00:00 AM | 3x3 | Permit Number 47005 | 6003944.88624926 | 2099274.1797934 | 37.7444303848395 | -122.42903293346 | (37.7444303848395, -122.42903293346) | 2 | 7 | 5 | 63 | 22 | |
| 113972 | 50292 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 300 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2003 12:00:00 AM | 3x3 | Permit Number 47005 | 6003944.88624926 | 2099274.1797934 | 37.7444303848395 | -122.42903293346 | (37.7444303848395, -122.42903293346) | 2 | 7 | 5 | 63 | 22 | |
| 193338 | 50291 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 300 Valley St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2003 12:00:00 AM | 3x3 | 6003944.88624926 | 2099274.1797934 | 37.7444303848395 | -122.42903293346 | (37.7444303848395, -122.42903293346) | 2 | 7 | 5 | 63 | 22 | ||
| 123108 | 227677 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 300 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6003907.02908 | 2099270.15617 | 37.7444171939021 | -122.429163548878 | (37.7444171939021, -122.429163548878) | 2 | 7 | 5 | 63 | 22 | |||
| 176307 | 227678 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 300 Valley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6003889.89165 | 2099268.52237 | 37.7444117377113 | -122.429222690078 | (37.7444117377113, -122.429222690078) | 2 | 7 | 5 | 63 | 22 | |||
| 182837 | 890 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1146 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 4X4 | 6003547.94647 | 2094400.70663 | 37.7310264639915 | -122.430057882374 | (37.7310264639915, -122.430057882374) | 9 | 7 | 5 | 28861 | 25 | |||
| 145982 | 227697 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 109 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003800.52049 | 2108768.8119 | 37.7704922173631 | -122.430209350707 | (37.7704922173631, -122.430209350707) | 15 | 9 | 11 | 29492 | 10 | |||
| 147419 | 227696 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 50 Belcher St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6003774.74871 | 2108065.24722 | 37.7685589402651 | -122.43024829315 | (37.7685589402651, -122.43024829315) | 7 | 9 | 5 | 28862 | 3 | |||
| 192707 | 49012 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 361 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2002 12:00:00 AM | Permit Number 46198 | 6003561.60300767 | 2099494.42119752 | 37.7450134133041 | -122.430373957908 | (37.7450134133041, -122.430373957908) | 2 | 7 | 5 | 63 | 22 | |||
| 134621 | 227679 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 361 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6003556.92712 | 2099495.03666 | 37.7450148383554 | -122.430390170187 | (37.7450148383554, -122.430390170187) | 2 | 7 | 5 | 63 | 22 | |||
| 137505 | 34621 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 370 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2016 12:00:00 AM | 3 | Permit Number 778228 | 6003497.10528776 | 2099542.95496323 | 37.7451430220882 | -122.430600441889 | (37.7451430220882, -122.430600441889) | 2 | 7 | 5 | 63 | 22 | |
| 77195 | 237551 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 102 Hancock St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779869 | 6003586.068 | 2105101.14828 | 37.7604095509682 | -122.430689380017 | (37.7604095509682, -122.430689380017) | 2 | 4 | 5 | 28862 | 3 | |
| 174441 | 889 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1136X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 6003353.03343 | 2094335.58352 | 37.7308366096666 | -122.430727084074 | (37.7308366096666, -122.430727084074) | 9 | 7 | 5 | 28861 | 25 | |||
| 65610 | 237552 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 102 Hancock St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779869 | 6003566.97457 | 2105097.88602 | 37.7603995118464 | -122.430755182518 | (37.7603995118464, -122.430755182518) | 2 | 4 | 5 | 28862 | 3 | |
| 92382 | 47550 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1681 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45414 | 6003392.60348895 | 2098449.5926945 | 37.7421349817765 | -122.430883775787 | (37.7421349817765, -122.430883775787) | 2 | 7 | 5 | 63 | 22 | ||
| 56036 | 909 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1217 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 45 | 3X3 | 6003163.68633 | 2094174.89484 | 37.7303846655151 | -122.431370220756 | (37.7303846655151, -122.431370220756) | 9 | 7 | 6 | 28861 | 25 | |||
| 63925 | 167503 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 3512 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782138 | 6003389.60758 | 2106563.82057 | 37.7644145648084 | -122.431473265088 | (37.7644145648084, -122.431473265088) | 15 | 4 | 5 | 28862 | 3 | |
| 62191 | 255989 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 3512 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782138 | 6003384.96446 | 2106555.65654 | 37.7643918851964 | -122.431488741482 | (37.7643918851964, -122.431488741482) | 15 | 4 | 5 | 28862 | 3 | |
| 50220 | 18882 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2323 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2X2 | 6003557.0695 | 2115907.13274 | 37.7900784748972 | -122.43156114415 | (37.7900784748972, -122.43156114415) | 13 | 9 | 1 | 29490 | 27 | |||
| 174016 | 167504 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 3512 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782138 | 6003358.46768 | 2106563.63668 | 37.7644122949287 | -122.431580956196 | (37.7644122949287, -122.431580956196) | 15 | 4 | 5 | 28862 | 3 | |
| 40263 | 227676 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 427 Valley St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 6003106.32375 | 2099187.31259 | 37.7441443647786 | -122.431926305762 | (37.7441443647786, -122.431926305762) | 2 | 7 | 5 | 63 | 22 | ||||
| 132662 | 176986 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 745 France Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6002864.08823 | 2089338.03726 | 37.7170867510327 | -122.432060704959 | (37.7170867510327, -122.432060704959) | 9 | 7 | 6 | 28861 | 5 | |||
| 142493 | 227693 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 337 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6002979.94012 | 2100929.17253 | 37.7489199393117 | -122.432487701248 | (37.7489199393117, -122.432487701248) | 2 | 4 | 5 | 28862 | 22 | |||
| 46607 | 176987 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1278 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | Width 5ft | 6002815.8897 | 2094148.38707 | 37.7302921639516 | -122.432570708688 | (37.7302921639516, -122.432570708688) | 9 | 7 | 5 | 28861 | 25 | |||
| 154538 | 926 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1278 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | 6002807.70183 | 2094157.47604 | 37.7303166558715 | -122.432599664217 | (37.7303166558715, -122.432599664217) | 9 | 7 | 5 | 28861 | 25 | |||
| 193986 | 68368 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 194 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1993 12:00:00 AM | Permit Number 32189 | 6002712.41508002 | 2094283.54436078 | 37.730657406687 | -122.432938086411 | (37.730657406687, -122.432938086411) | 9 | 7 | 5 | 28861 | 25 | ||
| 174228 | 227684 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2560 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6002253.36783 | 2096984.49578 | 37.7380475512412 | -122.434718147625 | (37.7380475512412, -122.434718147625) | 2 | 7 | 5 | 63 | 7 | |||
| 130752 | 1383 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2550X Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X2 | 6002248.65699 | 2096984.18535 | 37.7380464314256 | -122.434734413124 | (37.7380464314256, -122.434734413124) | 2 | 7 | 5 | 63 | 7 | |||
| 104265 | 129463 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2451 Steiner St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 6002236.13059 | 2116512.00902 | 37.7916643510872 | -122.436174782264 | (37.7916643510872, -122.436174782264) | 13 | 9 | 1 | 29490 | 27 | |||
| 99445 | 9277 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2161X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6000049.09202 | 2089751.67924 | 37.7180625213905 | -122.441820442737 | (37.7180625213905, -122.441820442737) | 9 | 7 | 6 | 28861 | 25 | |||
| 29255 | 176982 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2157 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 5999995.5387 | 2089705.60981 | 37.7179329735202 | -122.442002247903 | (37.7179329735202, -122.442002247903) | 9 | 7 | 6 | 28861 | 25 | |||
| 95742 | 176981 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2315 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 1ft | 5999571.4621 | 2089300.92693 | 37.7167976306892 | -122.443439037193 | (37.7167976306892, -122.443439037193) | 9 | 7 | 6 | 28861 | 25 | |||
| 127819 | 227694 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 239 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999877.66163 | 2104769.07166 | 37.7592869569347 | -122.443491144794 | (37.7592869569347, -122.443491144794) | 2 | 4 | 5 | 28862 | 3 | |||
| 29184 | 176980 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2315 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 2ft | 5999548.76247 | 2089280.82364 | 37.7167411370713 | -122.443516055124 | (37.7167411370713, -122.443516055124) | 9 | 7 | 6 | 28861 | 25 | |||
| 50732 | 253463 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 98X Marston Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x3 | 5998793 | 2093251 | 37.7275991927727 | -122.446413796362 | (37.7275991927727, -122.446413796362) | 9 | 7 | 4 | 28861 | 40 | ||
| 70915 | 253464 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 98X Marston Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x3 | 5998793 | 2093251 | 37.7275991927727 | -122.446413796362 | (37.7275991927727, -122.446413796362) | 9 | 7 | 4 | 28861 | 40 | ||
| 150375 | 253465 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 98X Marston Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x3 | 5998793 | 2093251 | 37.7275991927727 | -122.446413796362 | (37.7275991927727, -122.446413796362) | 9 | 7 | 4 | 28861 | 40 | ||
| 159025 | 253462 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 98X Marston Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x3 | 5998793 | 2093251 | 37.7275991927727 | -122.446413796362 | (37.7275991927727, -122.446413796362) | 9 | 7 | 4 | 28861 | 40 | ||
| 75879 | 176985 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2571 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 2ft | 5998574.33272 | 2088565.20963 | 37.7147206041402 | -122.446832699994 | (37.7147206041402, -122.446832699994) | 9 | 7 | 6 | 28861 | 25 | |||
| 69315 | 138260 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2600 GEARY BLVD | 28 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5999060.2181 | 2113180.9681 | 37.7823372358083 | -122.446923566676 | (37.7823372358083, -122.446923566676) | 15 | 5 | 1 | 54 | 16 | |||
| 47779 | 138264 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2600 GEARY BLVD | 32 | unknown : Yard | Tree | Private 2 | 1 | Width 0ft | 5999039.2359 | 2113177.9223 | 37.7823276740968 | -122.446995936272 | (37.7823276740968, -122.446995936272) | 15 | 5 | 1 | 54 | 16 | |||
| 163946 | 117519 | Undocumented 4 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1601 PAGE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998904 | 2109014 | 37.7708868872166 | -122.447164026359 | (37.7708868872166, -122.447164026359) | 15 | 5 | 11 | 29492 | 9 | ||||
| 166333 | 244098 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1601 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 5998815.2972 | 2108995.6351 | 37.7708313932465 | -122.447469528169 | (37.7708313932465, -122.447469528169) | 15 | 5 | 11 | 29492 | 9 | |||
| 5099 | 261940 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1 Verna St | 5 | Unaccepted Street : Yard | Tree | Private 2 | Width 3ft | 5998303 | 2096292 | 37.7359210601709 | -122.448326617787 | (37.7359210601709, -122.448326617787) | 9 | 7 | 4 | 59 | 40 | ||||
| 37655 | 207106 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 100 Tara St | 2 | : | Tree | Private 2 | 20 | Width 0ft | 5998100.60654 | 2090923.0946 | 37.7211677377768 | -122.448639805789 | (37.7211677377768, -122.448639805789) | 9 | 8 | 6 | 28861 | 24 | |||
| 121491 | 31546 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 220 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/10/1995 12:00:00 AM | 6 | Permit Number 35095 | 5998394.38199367 | 2112672.66987383 | 37.7809035197163 | -122.449190424029 | (37.7809035197163, -122.449190424029) | 15 | 6 | 2 | 54 | 16 | |
| 118542 | 138270 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 218 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5998383.8821 | 2112677.2272 | 37.7809154323836 | -122.449227076582 | (37.7809154323836, -122.449227076582) | 15 | 6 | 2 | 54 | 16 | |||
| 174440 | 246123 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 35 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/06/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 779621 | 5998184.8878 | 2108385.4066 | 37.7691198159889 | -122.449606139087 | (37.7691198159889, -122.449606139087) | 15 | 5 | 11 | 29492 | 9 | |
| 49514 | 227681 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 145 Alma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5997959.25406 | 2106183.43699 | 37.7630608557823 | -122.450227846644 | (37.7630608557823, -122.450227846644) | 15 | 5 | 11 | 29492 | 9 | |||
| 86130 | 52103 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 641 Rockdale Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/2005 12:00:00 AM | Permit Number 48295 | 5997742.5728031 | 2098061.02519693 | 37.7407463206184 | -122.450391713191 | (37.7407463206184, -122.450391713191) | 9 | 7 | 4 | 59 | 40 | ||
| 43157 | 227687 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1003 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5997630.84664 | 2107024.34604 | 37.7653509793933 | -122.451424345184 | (37.7653509793933, -122.451424345184) | 15 | 5 | 11 | 29492 | 9 | |||
| 62642 | 227686 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1001 Shrader St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5997629.48637 | 2107046.84316 | 37.7654126728718 | -122.451430672783 | (37.7654126728718, -122.451430672783) | 15 | 5 | 11 | 29492 | 9 | |||
| 4749 | 227685 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1001 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5997626.03081 | 2107071.20572 | 37.765479368391 | -122.451444382046 | (37.765479368391, -122.451444382046) | 15 | 5 | 11 | 29492 | 9 | |||
| 59472 | 52106 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 727 Rockdale Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/2005 12:00:00 AM | Permit Number 48298 | 5997405.05193713 | 2098248.96190456 | 37.741243026323 | -122.451572279627 | (37.741243026323, -122.451572279627) | 9 | 7 | 4 | 59 | 40 | ||
| 161455 | 40483 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 165 Margaret Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1999 12:00:00 AM | Permit Number 41562 | 5996732.70371963 | 2089259.1130924 | 37.7165205210888 | -122.453248158457 | (37.7165205210888, -122.453248158457) | 9 | 8 | 6 | 28861 | 24 | ||
| 184865 | 47963 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 558 Melrose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2002 12:00:00 AM | Permit Number 45693 | 5996827.75466141 | 2095403.22069376 | 37.7333962339357 | -122.453362951949 | (37.7333962339357, -122.453362951949) | 9 | 7 | 4 | 59 | 40 | ||
| 81378 | 50428 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 11 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/2003 12:00:00 AM | Permit Number 47081 | 5996479.47890892 | 2089951.8399169 | 37.7184080697361 | -122.454173429085 | (37.7184080697361, -122.454173429085) | 9 | 8 | 6 | 28861 | 24 | ||
| 61805 | 47082 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 175 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2002 12:00:00 AM | 5 | Permit Number 45068 | 5996827.60082146 | 2111762.20695793 | 37.7783138890322 | -122.45454486672 | (37.7783138890322, -122.45454486672) | 15 | 6 | 2 | 54 | 16 | |
| 105029 | 43632 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1001 Portola Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50556 | 5996213.47474732 | 2098545.79305022 | 37.7419897418411 | -122.455713757113 | (37.7419897418411, -122.455713757113) | 9 | 7 | 4 | 59 | 40 | ||
| 181261 | 36317 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 208 Colon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/01/2008 12:00:00 AM | 3x3 | Permit Number 51552 | 5996115.78800404 | 2094224.07875239 | 37.7301177594719 | -122.455739200241 | (37.7301177594719, -122.455739200241) | 9 | 7 | 4 | 28861 | 40 | ||
| 167551 | 207139 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 208 Colon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5996097.00713 | 2094250.77954 | 37.7301899955731 | -122.455806057116 | (37.7301899955731, -122.455806057116) | 9 | 7 | 4 | 28861 | 40 | |||
| 137534 | 50423 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 75 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/2003 12:00:00 AM | Permit Number 47076 | 5995600.08487961 | 2090390.5729412 | 37.7195622602365 | -122.457244829317 | (37.7195622602365, -122.457244829317) | 9 | 8 | 6 | 28861 | 24 | ||
| 152407 | 36328 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 40 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/22/1998 12:00:00 AM | Permit Number 39300 | 5995640.5044713 | 2092769.77027097 | 37.7260972907371 | -122.457277138944 | (37.7260972907371, -122.457277138944) | 9 | 7 | 4 | 28861 | 40 | ||
| 114789 | 207103 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 40 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5995614.83933 | 2092751.51074 | 37.7260456803487 | -122.457364540844 | (37.7260456803487, -122.457364540844) | 9 | 7 | 4 | 28861 | 40 | |||
| 158626 | 50817 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/18/2004 12:00:00 AM | Permit Number 47340 | 5995605.94135709 | 2094497.43585496 | 37.7308390591092 | -122.457521563876 | (37.7308390591092, -122.457521563876) | 9 | 7 | 4 | 28861 | 40 | ||||
| 108126 | 50490 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 242 Miramar Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/2003 12:00:00 AM | Permit Number 47126 | 5995378.87438655 | 2091597.86421043 | 37.722864487352 | -122.458096796728 | (37.722864487352, -122.458096796728) | 9 | 8 | 4 | 28861 | 24 | ||
| 121895 | 50489 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 242 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/2003 12:00:00 AM | Permit Number 47126 | 5995378.87438655 | 2091597.86421043 | 37.722864487352 | -122.458096796728 | (37.722864487352, -122.458096796728) | 9 | 8 | 4 | 28861 | 24 | ||
| 24427 | 207105 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 242 Miramar Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5995373.14858 | 2091601.55002 | 37.7228742787075 | -122.458116856135 | (37.7228742787075, -122.458116856135) | 9 | 8 | 4 | 28861 | 24 | |||
| 146162 | 207104 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 242 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5995372.52306 | 2091590.05793 | 37.7228426882306 | -122.458118187099 | (37.7228426882306, -122.458118187099) | 9 | 8 | 4 | 28861 | 24 | |||
| 56247 | 35417 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 221 Crestmont Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/1998 12:00:00 AM | Permit Number 38870 | 5995170.62655697 | 2103759.11614599 | 37.7562443131302 | -122.459697089533 | (37.7562443131302, -122.459697089533) | 1 | 5 | 4 | 63 | 12 | |||
| 136204 | 35418 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 221 Crestmont Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/1998 12:00:00 AM | Permit Number 38870 | 5995170.62655697 | 2103759.11614599 | 37.7562443131302 | -122.459697089533 | (37.7562443131302, -122.459697089533) | 1 | 5 | 4 | 63 | 12 | |||
| 185884 | 35419 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 221 Crestmont Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/1998 12:00:00 AM | Permit Number 38870 | 5995170.62655697 | 2103759.11614599 | 37.7562443131302 | -122.459697089533 | (37.7562443131302, -122.459697089533) | 1 | 5 | 4 | 63 | 12 | |||
| 76135 | 98307 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 701 04th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2019 12:00:00 AM | 3 | Permit Number 768498 | 5994707.05848 | 2110712.18551 | 37.7753089605415 | -122.461804398804 | (37.7753089605415, -122.461804398804) | 11 | 6 | 2 | 54 | 11 | ||
| 99585 | 59481 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 701 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2019 12:00:00 AM | 3 | Permit Number 768498 | 5994707.05513 | 2110730.54303 | 37.7753593652253 | -122.461805741777 | (37.7753593652253, -122.461805741777) | 11 | 6 | 2 | 54 | 11 | ||
| 99619 | 67131 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1439 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/1992 12:00:00 AM | Permit Number 30551 | 5994253.6761319 | 2105720.38065143 | 37.7615766669983 | -122.463010486718 | (37.7615766669983, -122.463010486718) | 1 | 5 | 11 | 56 | 12 | ||
| 13250 | 45430 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 851 Head St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/2001 12:00:00 AM | Permit Number 44219 | 5993920.58856776 | 2091576.5612161 | 37.7227220958318 | -122.463136201451 | (37.7227220958318, -122.463136201451) | 9 | 8 | 4 | 59 | 40 | ||
| 116625 | 45431 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 851 Head St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/2001 12:00:00 AM | Permit Number 44219 | 5993920.58856776 | 2091576.5612161 | 37.7227220958318 | -122.463136201451 | (37.7227220958318, -122.463136201451) | 9 | 8 | 4 | 59 | 40 | ||
| 129636 | 45429 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 851 Head St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/2001 12:00:00 AM | Permit Number 44219 | 5993920.58856776 | 2091576.5612161 | 37.7227220958318 | -122.463136201451 | (37.7227220958318, -122.463136201451) | 9 | 8 | 4 | 59 | 40 | ||
| 57475 | 45437 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 50 Urbano Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/2001 12:00:00 AM | Permit Number 44224 | 5993813.83621392 | 2092411.23769418 | 37.7250077648019 | -122.463565764966 | (37.7250077648019, -122.463565764966) | 9 | 8 | 4 | 59 | 40 | ||
| 107523 | 123588 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 50 05th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 5994278.22027 | 2115268.89087 | 37.7877957491728 | -122.463618619297 | (37.7877957491728, -122.463618619297) | 11 | 6 | 1 | 54 | 11 | |||
| 53088 | 33391 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 129 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | Permit Number 37510 | 5993545.21642202 | 2093774.31911417 | 37.7287349718633 | -122.464593277929 | (37.7287349718633, -122.464593277929) | 9 | 8 | 4 | 59 | 40 | ||
| 123096 | 45360 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 458 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46747 | 5993277.37926203 | 2090218.01876098 | 37.7189547935486 | -122.46526098645 | (37.7189547935486, -122.46526098645) | 9 | 8 | 6 | 64 | 24 | ||
| 13174 | 68069 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 239 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1993 12:00:00 AM | Permit Number 31806 | 5993313.66059206 | 2103207.09024288 | 37.7546216328473 | -122.466078949095 | (37.7546216328473, -122.466078949095) | 1 | 8 | 4 | 56 | 12 |
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) );