trees
301 rows where qLegalStatus_id = 1 and qSpecies_id = 47 sorted by rowid descending
This data as json, CSV (advanced)
| rowid ▲ | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 192536 | 191375 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 16 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | 6011300.32576 | 2104333.131 | 37.7587347705187 | -122.403955140934 | (37.7587347705187, -122.403955140934) | 10 | 3 | 8 | 28856 | 29 | ||||
| 192203 | 186749 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1200 Sunset Blvd | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 0ft | 5984860.385 | 2106678.2761 | 37.7636612284897 | -122.495568210877 | (37.7636612284897, -122.495568210877) | 1 | 8 | 3 | 56 | 35 | |||
| 192189 | 217850 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1 Woodacre Dr | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | 5991375.86862 | 2095660.38148 | 37.7337883260711 | -122.47223020567 | (37.7337883260711, -122.47223020567) | 1 | 8 | 4 | 64 | 40 | ||||
| 187087 | 207108 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 89 Ralston St | 3 | Back Yard : Yard | Tree | Private 2 | 13 | 5992168.92954 | 2088415.82729 | 37.7139424279717 | -122.468961347182 | (37.7139424279717, -122.468961347182) | 9 | 8 | 6 | 64 | 24 | ||||
| 186347 | 207117 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 41 Ralston St | 9 | Back Yard : Yard | Tree | Private 2 | 19 | 5992170.67066 | 2088214.06867 | 37.7133885481037 | -122.468940655584 | (37.7133885481037, -122.468940655584) | 9 | 8 | 6 | 64 | 24 | ||||
| 185713 | 186760 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1200 Sunset Blvd | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5984860.8701 | 2106711.7495 | 37.7637531654529 | -122.495569002148 | (37.7637531654529, -122.495569002148) | 1 | 8 | 3 | 56 | 35 | |||
| 184163 | 184574 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1706 Lower Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5981029.903 | 2103411.5484 | 37.7544666834786 | -122.508573887519 | (37.7544666834786, -122.508573887519) | 1 | 8 | 3 | 56 | 35 | |||
| 183941 | 207125 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2 Cranleigh Dr | 4 | Front Yard : Yard | Tree | DPW 1 | 08/18/2016 09:56:00 AM | 13 | Width 0ft | 5991332.89244 | 2095658.50101 | 37.7337806755214 | -122.47237864866 | (37.7337806755214, -122.47237864866) | 1 | 8 | 4 | 64 | 40 | ||
| 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 | |||
| 182552 | 129482 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 11 Greenwich St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6012315.37501 | 2120537.75286 | 37.803285568636 | -122.401583532467 | (37.803285568636, -122.401583532467) | 3 | 1 | 10 | 28860 | 6 | ||||
| 182337 | 191386 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 38 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 4ft | 6011275.59142 | 2104157.94605 | 37.7582523696726 | -122.404028355649 | (37.7582523696726, -122.404028355649) | 10 | 3 | 8 | 28856 | 29 | |||
| 181949 | 218284 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 50x Junipero Serra Frontage West | 0 | Median : Yard | Tree | DPW 1 | 28 | 5991438.8932 | 2095398.77837 | 37.7330736770928 | -122.4719932523 | (37.7330736770928, -122.4719932523) | 1 | 8 | 4 | 64 | 40 | ||||
| 181786 | 176983 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2935x Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | Width 3ft | 5996985 | 2087493 | 37.71168564061 | -122.45224873895 | (37.71168564061, -122.45224873895) | 9 | 7 | 6 | 28861 | 25 | |||
| 181779 | 191403 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2100 Alameda St | 9 | Front Yard : Yard | Tree | Private 2 | 5 | 6010692.20162 | 2107913.0668 | 37.7685304704432 | -122.406310559796 | (37.7685304704432, -122.406310559796) | 8 | 4 | 8 | 28853 | 19 | ||||
| 181516 | 182942 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2671 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5982115.1 | 2096931.8144 | 37.7367390358824 | -122.504341059874 | (37.7367390358824, -122.504341059874) | 1 | 8 | 3 | 29491 | 35 | |||
| 181108 | 191382 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 33 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011269.01089 | 2104184.59965 | 37.7583251868659 | -122.404052989848 | (37.7583251868659, -122.404052989848) | 10 | 3 | 8 | 28856 | 29 | |||
| 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 | ||||
| 180157 | 24738 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 7700 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/09/1996 12:00:00 AM | 3 | 3X3 | 5983089.13202 | 2112566.68135 | 37.7797252106941 | -122.502130088809 | (37.7797252106941, -122.502130088809) | 11 | 6 | 2 | 55 | 26 | ||
| 179733 | 191387 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 39 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 4ft | 6011279.1597 | 2104155.21456 | 37.7582450689735 | -122.404015822688 | (37.7582450689735, -122.404015822688) | 10 | 3 | 8 | 28856 | 29 | |||
| 179306 | 191395 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2100 Alameda St | 1 | Front Yard : Yard | Tree | Private 2 | 22 | 6010771.29847 | 2107917.19939 | 37.7685462418407 | -122.406037260315 | (37.7685462418407, -122.406037260315) | 8 | 4 | 8 | 28853 | 19 | ||||
| 177935 | 121420 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1155x Prague St | 1 | Median : Cutout | Tree | DPW 1 | 3x3 | 6000780 | 2086820 | 37.7100544057225 | -122.439084019343 | (37.7100544057225, -122.439084019343) | 9 | 7 | 6 | 28861 | 5 | ||||
| 177777 | 16566 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2305X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3X3 | 5999574.07501 | 2089304.05837 | 37.7168063779221 | -122.443430230482 | (37.7168063779221, -122.443430230482) | 9 | 7 | 6 | 28861 | 25 | |||
| 177625 | 207115 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 47 Ralston St | 8 | Back Yard : Yard | Tree | Private 2 | 8 | 5992168.43399 | 2088239.25639 | 37.7134575782774 | -122.468950218099 | (37.7134575782774, -122.468950218099) | 9 | 8 | 6 | 64 | 24 | ||||
| 177187 | 31580 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1841 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/10/1995 12:00:00 AM | Permit Number 35119 | 5989049.89925793 | 2102807.07383274 | 37.7532763860102 | -122.48079472189 | (37.7532763860102, -122.48079472189) | 1 | 8 | 3 | 56 | 35 | ||
| 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 | |||
| 175565 | 248189 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 216 Esmeralda Ave | 8 | Side Yard : Yard | Tree | Private 2 | 11 | 6007400.67054 | 2098728.2959 | 37.7431265201804 | -122.417044843446 | (37.7431265201804, -122.417044843446) | 2 | 7 | 7 | 28859 | 2 | ||||
| 174988 | 29627 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 900X Junipero Serra Blvd | 36 | Median : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 12 | 3X3 | 5991152.87782 | 2090760.03066 | 37.7203202787275 | -122.472643981031 | (37.7203202787275, -122.472643981031) | 9 | 8 | 4 | 64 | 40 | ||
| 174774 | 249938 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 339 Filbert St | 3 | Front Yard : Yard | Tree | Private 2 | 8 | Width 0ft | 6011244.68883 | 2120032.52194 | 37.8018385261831 | -122.405253098256 | (37.8018385261831, -122.405253098256) | 3 | 1 | 10 | 308 | 23 | |||
| 174502 | 16565 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2305X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 5999593.35864 | 2089327.05238 | 37.7168706139428 | -122.443365227339 | (37.7168706139428, -122.443365227339) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | |
| 174244 | 207112 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 59 Ralston St | 4 | Back Yard : Yard | Tree | Private 2 | 12 | 5992171.74672 | 2088295.87352 | 37.7136132266511 | -122.468942885919 | (37.7136132266511, -122.468942885919) | 9 | 8 | 6 | 64 | 24 | ||||
| 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 | |||
| 174148 | 186310 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1800 Sunset Blvd | 48 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 0ft | 5984966.7705 | 2102775.9332 | 37.7529527085207 | -122.494912513249 | (37.7529527085207, -122.494912513249) | 1 | 8 | 3 | 56 | 35 | |||
| 173649 | 186041 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1900 Sunset Blvd | 36 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 0ft | 5984992.0482 | 2102149.6578 | 37.7512346080754 | -122.494778929254 | (37.7512346080754, -122.494778929254) | 1 | 8 | 3 | 29491 | 35 | |||
| 173115 | 191406 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2 Tulare St | 8 | Front Yard : Yard | Tree | Private 2 | 5 | 6016222.17813 | 2100305.95006 | 37.7479507291578 | -122.386652137081 | (37.7479507291578, -122.386652137081) | 3 | 8 | 58 | 1 | |||||
| 172448 | 46969 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1658 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/2002 12:00:00 AM | 7 | Permit Number 44989 | 5982547.49278996 | 2103828.23178681 | 37.7557001072445 | -122.503356606053 | (37.7557001072445, -122.503356606053) | 1 | 8 | 3 | 56 | 35 | |
| 172236 | 207126 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2 Cranleigh Dr | 3 | Front Yard : Yard | Tree | DPW 1 | 08/18/2016 09:59:00 AM | 13 | Width 0ft | 5991329.52565 | 2095655.77453 | 37.7337729944342 | -122.472390089849 | (37.7337729944342, -122.472390089849) | 1 | 8 | 4 | 64 | 40 | ||
| 169833 | 2477 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2307X Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x4 | 6003648.68016 | 2115921.80581 | 37.7901239554137 | -122.43124522669 | (37.7901239554137, -122.43124522669) | 13 | 9 | 1 | 29490 | 27 | |||
| 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 | |||
| 167360 | 191381 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 32 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 6011271.17001 | 2104191.36243 | 37.7583438765916 | -122.404045998546 | (37.7583438765916, -122.404045998546) | 10 | 3 | 8 | 28856 | 29 | |||
| 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 | |||
| 165906 | 84133 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 23 Tucker Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50705 | 6011012.12355 | 2088466.51247 | 37.7151523039101 | -122.403835398892 | (37.7151523039101, -122.403835398892) | 9 | 7 | 8 | 309 | 39 | |
| 165804 | 186059 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1901 Sunset Blvd | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5984803.9529 | 2102180.8195 | 37.7513091577006 | -122.495431671777 | (37.7513091577006, -122.495431671777) | 1 | 8 | 3 | 29491 | 35 | |||
| 165614 | 183438 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2506 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5988326.6233 | 2098215.7152 | 37.7406276663345 | -122.482959448414 | (37.7406276663345, -122.482959448414) | 1 | 8 | 3 | 29491 | 35 | |||
| 165316 | 191374 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 15 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 6011292.66605 | 2104334.91271 | 37.7587392347502 | -122.403981757255 | (37.7587392347502, -122.403981757255) | 10 | 3 | 8 | 28856 | 29 | ||||
| 165308 | 83228 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 4234 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50748 | 5982916.47531802 | 2098139.9083931 | 37.7401032328077 | -122.50165975231 | (37.7401032328077, -122.50165975231) | 1 | 8 | 3 | 29491 | 35 | |
| 164867 | 118789 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 718 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 5981995.4955 | 2110847.43445 | 37.7749403522663 | -122.505785898051 | (37.7749403522663, -122.505785898051) | 11 | 6 | 2 | 55 | 26 | |||
| 163899 | 191389 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 43 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 9ft | 6011309.9548 | 2104119.65272 | 37.7581491445771 | -122.403906816767 | (37.7581491445771, -122.403906816767) | 10 | 3 | 8 | 28856 | 29 | |||
| 162214 | 207122 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2 Cranleigh Dr | 7 | Front Yard : Yard | Tree | Private 2 | 12 | Width 0ft | 5991343.33969 | 2095670.4637 | 37.7338141267018 | -122.472343401524 | (37.7338141267018, -122.472343401524) | 1 | 8 | 4 | 64 | 40 | |||
| 161986 | 122182 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2 14th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 5991497.78568 | 2114857.01928 | 37.7865042639669 | -122.473208256238 | (37.7865042639669, -122.473208256238) | 11 | 6 | 1 | 54 | 33 | ||||
| 161260 | 26830 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 3590X 19th Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/1999 12:00:00 AM | 8 | 3x18 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | 9 | 8 | 4 | 64 | 40 | ||
| 160576 | 186058 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1901 Sunset Blvd | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5984794.5256 | 2102183.7824 | 37.7513167410032 | -122.495464490464 | (37.7513167410032, -122.495464490464) | 1 | 8 | 3 | 29491 | 35 | |||
| 159820 | 29601 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 900X Junipero Serra Blvd | 10 | Median : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991172.09001 | 2091066.888 | 37.7211639453471 | -122.472599932234 | (37.7211639453471, -122.472599932234) | 9 | 8 | 4 | 64 | 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 | ||
| 158350 | 37082 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1268 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2002 12:00:00 AM | 6 | Permit Number 44549 | 5982146.28824129 | 2106471.58463776 | 37.7629344086854 | -122.504939947841 | (37.7629344086854, -122.504939947841) | 1 | 8 | 3 | 56 | 35 | |
| 157961 | 207119 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2 Cranleigh Dr | 10 | Front Yard : Yard | Tree | Private 2 | 25 | Width 0ft | 5991353.65823 | 2095688.25461 | 37.7338635732432 | -122.472309024061 | (37.7338635732432, -122.472309024061) | 1 | 8 | 4 | 64 | 40 | |||
| 157835 | 186754 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1200 Sunset Blvd | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 0ft | 5984863.7808 | 2106693.8 | 37.763704051609 | -122.495557611102 | (37.763704051609, -122.495557611102) | 1 | 8 | 3 | 56 | 35 | |||
| 156877 | 184169 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 3734 Lawton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5982587.082 | 2104253.9424 | 37.7568713157118 | -122.503251214898 | (37.7568713157118, -122.503251214898) | 1 | 8 | 3 | 56 | 35 | |||
| 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 | ||||
| 156277 | 129475 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1077 Front St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | 6012586.09993 | 2120128.51859 | 37.8021770130129 | -122.4006179088 | (37.8021770130129, -122.4006179088) | 3 | 1 | 10 | 28860 | 6 | ||||
| 155190 | 227690 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 307 Bocana St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 6006885.1558 | 2097215.40267 | 37.7389434396991 | -122.418720092463 | (37.7389434396991, -122.418720092463) | 2 | 7 | 7 | 28859 | 2 | |||
| 155046 | 129469 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1085 Vallejo St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6008359.28826 | 2118585.88506 | 37.7977046844857 | -122.415135501808 | (37.7977046844857, -122.415135501808) | 5 | 1 | 10 | 308 | 21 | |||
| 154411 | 191399 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2100 Alameda St | 5 | Front Yard : Yard | Tree | Private 2 | 5 | 6010727.66479 | 2107914.72417 | 37.7685370048986 | -122.406188011877 | (37.7685370048986, -122.406188011877) | 8 | 4 | 8 | 28853 | 19 | ||||
| 154236 | 247871 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 394 Mayflower St | 3 | Side Yard : Yard | Tree | Private 2 | 18 | 6009746.3542 | 2098404.30325 | 37.7423685814537 | -122.408911206692 | (37.7423685814537, -122.408911206692) | 10 | 7 | 7 | 28859 | 2 | ||||
| 152884 | 129478 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 12 Filbert St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | 6012509.68294 | 2120230.66756 | 37.8024532271953 | -122.400889531035 | (37.8024532271953, -122.400889531035) | 3 | 1 | 10 | 28860 | 6 | ||||
| 150862 | 234 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2994 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 2X3 | 5990616.60068 | 2095284.10448 | 37.7327111945568 | -122.474827739114 | (37.7327111945568, -122.474827739114) | 1 | 8 | 4 | 64 | 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 | ||
| 149988 | 186750 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1200 Sunset Blvd | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5984851.1676 | 2106678.2761 | 37.7636606887382 | -122.495600090514 | (37.7636606887382, -122.495600090514) | 1 | 8 | 3 | 56 | 35 | |||
| 149652 | 183373 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2728 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5985578.5174 | 2096788.4906 | 37.7365485996681 | -122.492356136884 | (37.7365485996681, -122.492356136884) | 1 | 8 | 3 | 29491 | 35 | |||
| 149118 | 186513 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1400 Lower Great Hwy | 14 | unknown : Yard | Tree | Private 2 | 5 | Width 0ft | 5980894.1374 | 2105147.1675 | 37.759224194224 | -122.509172270667 | (37.759224194224, -122.509172270667) | 1 | 8 | 3 | 56 | 35 | |||
| 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 | ||
| 148733 | 24276 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 350X Winding Way | 14 | Median : Cutout | Tree | DPW 1 | 6 | 8 | 6000825.35085 | 2086800.6303 | 37.7100038012068 | -122.438925891137 | (37.7100038012068, -122.438925891137) | 9 | 7 | 6 | 28861 | 5 | |||
| 148288 | 30756 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1547 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | 1 | Permit Number 34637 | 6015015.9888 | 2093715.5638 | 37.7297880302088 | -122.390362726863 | (37.7297880302088, -122.390362726863) | 10 | 3 | 8 | 58 | 1 | |
| 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 | |||
| 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 | |||
| 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 | |||
| 145811 | 129483 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 12 Greenwich St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | 6012307.75016 | 2120551.40866 | 37.8033226386787 | -122.401610879045 | (37.8033226386787, -122.401610879045) | 3 | 1 | 10 | 28860 | 6 | ||||
| 145003 | 129486 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 12 Greenwich St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 6012297.60436 | 2120565.6201 | 37.803361093695 | -122.401646988622 | (37.803361093695, -122.401646988622) | 3 | 1 | 10 | 28860 | 6 | ||||
| 142860 | 207111 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 59 Ralston St | 2 | Back Yard : Yard | Tree | Private 2 | 11 | 5992171.5605 | 2088305.6585 | 37.713640083085 | -122.468944241206 | (37.713640083085, -122.468944241206) | 9 | 8 | 6 | 64 | 24 | ||||
| 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 | |||
| 141612 | 183278 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1255 42nd Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 0ft | 5983028.2339 | 2106536.9311 | 37.7631656789881 | -122.501894487796 | (37.7631656789881, -122.501894487796) | 1 | 8 | 3 | 56 | 35 | |||
| 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 | ||||
| 138353 | 129473 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 11 Filbert St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 6012532.2991 | 2120205.04389 | 37.8023841322847 | -122.400809466192 | (37.8023841322847, -122.400809466192) | 3 | 1 | 10 | 28860 | 6 | ||||
| 138219 | 186752 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1200 Sunset Blvd | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5984851.1676 | 2106688.9488 | 37.7636899929755 | -122.495600877764 | (37.7636899929755, -122.495600877764) | 1 | 8 | 3 | 56 | 35 | |||
| 137873 | 227692 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 75 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006684.36987 | 2096973.81613 | 37.7382687898828 | -122.419397184857 | (37.7382687898828, -122.419397184857) | 2 | 7 | 7 | 28859 | 2 | |||
| 137267 | 207138 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 700 Junipero Serra Blvd | 123 | : | Tree | Private 2 | 8 | Width 0ft | 5991217.22752 | 2091775.34767 | 37.7231118130309 | -122.472495529957 | (37.7231118130309, -122.472495529957) | 9 | 8 | 4 | 64 | 40 | |||
| 136968 | 29586 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 500X Junipero Serra Blvd | 21 | Median : Cutout | Tree | DPW 1 | 9 | 3X3 | 5991342.7865 | 2093687.81781 | 37.7283702470744 | -122.472200841009 | (37.7283702470744, -122.472200841009) | 9 | 8 | 4 | 64 | 40 | |||
| 136897 | 102790 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 3445 Moraga St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Permit Number 42050 | 5983633 | 2103554 | 37.7550108962308 | -122.499582370415 | (37.7550108962308, -122.499582370415) | 1 | 8 | 3 | 56 | 35 | |||
| 136029 | 186000 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1883 47th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5981612.0444 | 2102288.7145 | 37.7514179925848 | -122.506477461595 | (37.7514179925848, -122.506477461595) | 1 | 8 | 3 | 56 | 35 | |||
| 136020 | 186747 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1200 Sunset Blvd | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5984869.1172 | 2106666.6331 | 37.7636297714118 | -122.495537150576 | (37.7636297714118, -122.495537150576) | 1 | 8 | 3 | 56 | 35 | |||
| 135665 | 191404 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2 Tulare St | 14 | Front Yard : Yard | Tree | Private 2 | 20 | 6016173.59275 | 2100299.3088 | 37.7479298037296 | -122.3868196817 | (37.7479298037296, -122.3868196817) | 3 | 8 | 58 | 1 | |||||
| 135265 | 218293 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1 Woodacre Dr | 17 | Sidewalk: Curb side : Yard | Tree | Private 2 | 22 | 5991192.67429 | 2095369.91493 | 37.7329801745819 | -122.472842384068 | (37.7329801745819, -122.472842384068) | 1 | 8 | 4 | 64 | 40 | ||||
| 134954 | 207131 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 500 Junipero Serra Blvd | 23 | : | Tree | Private 2 | 14 | Width 0ft | 5991341.74557 | 2093676.61882 | 37.7283394372056 | -122.472203623519 | (37.7283394372056, -122.472203623519) | 9 | 8 | 4 | 64 | 40 | |||
| 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 | |||
| 134083 | 24808 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 7117 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/22/1996 12:00:00 AM | 3 | 3X3 | 5984967.23631 | 2112432.54215 | 37.7794670623637 | -122.495623106999 | (37.7794670623637, -122.495623106999) | 11 | 6 | 2 | 55 | 26 | ||
| 133839 | 79951 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 4332 Pacheco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50745 | 5981564.36989544 | 2101497.47247657 | 37.7492426575827 | -122.50658364702 | (37.7492426575827, -122.50658364702) | 1 | 8 | 3 | 29491 | 35 | |
| 133496 | 191385 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 37 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 6011271.65755 | 2104161.44484 | 37.7582617567794 | -122.404042206986 | (37.7582617567794, -122.404042206986) | 10 | 3 | 8 | 28856 | 29 | |||
| 133352 | 186762 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1200 Sunset Blvd | 28 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 0ft | 5984853.5932 | 2106716.1156 | 37.7637647274179 | -122.495594492387 | (37.7637647274179, -122.495594492387) | 1 | 8 | 3 | 56 | 35 | |||
| 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 | |||
| 131273 | 207113 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 53 Ralston St | 1 | Back Yard : Yard | Tree | Private 2 | 5 | 5992170.39113 | 2088282.95309 | 37.7135776719473 | -122.468946631596 | (37.7135776719473, -122.468946631596) | 9 | 8 | 6 | 64 | 24 |
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) );