trees
856 rows where qSpecies_id = 5 sorted by qAddress
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40094 | 2518 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1555 Burke Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016498.61775 | 2098890.19219 | 37.7440786495081 | -122.385597557904 | (37.7440786495081, -122.385597557904) | 10 | 3 | 8 | 58 | 1 | |||
41334 | 2516 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1555 Burke Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016465.84234 | 2098914.75953 | 37.7441442928392 | -122.38571260096 | (37.7441442928392, -122.38571260096) | 10 | 3 | 8 | 58 | 1 | |||
83022 | 2522 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1555 Burke Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016344.0270005 | 2099019.0971083 | 37.7444240410894 | -122.386141087772 | (37.7444240410894, -122.386141087772) | 10 | 3 | 8 | 58 | 1 | |||
84076 | 2520 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1555 Burke Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016533.26 | 2098864.45764 | 37.744009904432 | -122.385475978555 | (37.744009904432, -122.385475978555) | 10 | 3 | 8 | 58 | 1 | |||
117722 | 2513 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1555 Burke Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016387.51247 | 2098972.29453 | 37.7442979375022 | -122.385987460765 | (37.7442979375022, -122.385987460765) | 10 | 3 | 8 | 58 | 1 | |||
120474 | 2514 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1555 Burke Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6016429.25086 | 2098939.95078 | 37.7442114380124 | -122.385840882964 | (37.7442114380124, -122.385840882964) | 10 | 3 | 8 | 58 | 1 | |||
122418 | 2519 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1555 Burke Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016516.51157 | 2098877.59586 | 37.7440450526322 | -122.385534806811 | (37.7440450526322, -122.385534806811) | 10 | 3 | 8 | 58 | 1 | |||
123783 | 2521 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1555 Burke Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016567.75907 | 2098840.98498 | 37.7439473619958 | -122.385355052105 | (37.7439473619958, -122.385355052105) | 10 | 3 | 8 | 58 | 1 | |||
149727 | 2515 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1555 Burke Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016446.65639 | 2098928.8879 | 37.7441820247861 | -122.385779926925 | (37.7441820247861, -122.385779926925) | 10 | 3 | 8 | 58 | 1 | |||
32911 | 248271 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 157 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006700.68835 | 2098666.52237 | 37.7429175024299 | -122.419460818167 | (37.7429175024299, -122.419460818167) | 2 | 7 | 7 | 28859 | 2 | |||
64038 | 248270 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 157 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006694.18006 | 2098651.40644 | 37.7428756308979 | -122.419482249905 | (37.7428756308979, -122.419482249905) | 2 | 7 | 7 | 28859 | 2 | |||
79778 | 2524 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1570 BURKE AVE | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/2016 12:00:00 AM | 12 | 3X3 | 6016449 | 2099041 | 37.7444899913278 | -122.385779635787 | (37.7444899913278, -122.385779635787) | 10 | 3 | 8 | 58 | 1 | ||
49970 | 2531 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1570 Burke Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6016273.7509883 | 2099134.0637751 | 37.7447358261247 | -122.386392104106 | (37.7447358261247, -122.386392104106) | 10 | 3 | 8 | 58 | 1 | |||
71087 | 189833 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1570 Burke Ave | 2 | : | Tree | DPW 1 | 02/12/2016 12:00:00 AM | 14 | Width 3ft | 6016585.78665 | 2098909.19771 | 37.7441356575455 | -122.385297468507 | (37.7441356575455, -122.385297468507) | 10 | 3 | 8 | 58 | 1 | ||
129151 | 188481 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1570 Burke Ave | 10 | : | Tree | Private 2 | 08/24/2017 12:00:00 AM | 3 | Width 3ft | 6016299.33242 | 2099120.87091 | 37.7447010172388 | -122.386302728 | (37.7447010172388, -122.386302728) | 10 | 3 | 8 | 58 | 1 | ||
179562 | 2526 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1570 Burke Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3X3 | 6016552.46567 | 2098935.10176 | 37.744204941317 | -122.385414490998 | (37.744204941317, -122.385414490998) | 10 | 3 | 8 | 58 | 1 | |||
190873 | 2530 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1570 Burke Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6016273.7509883 | 2099134.0637751 | 37.7447358261247 | -122.386392104106 | (37.7447358261247, -122.386392104106) | 10 | 3 | 8 | 58 | 1 | |||
70301 | 2533 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1575 Burke Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016180.33193 | 2099126.30756 | 37.7447093575531 | -122.386714591425 | (37.7447093575531, -122.386714591425) | 10 | 3 | 8 | 58 | 1 | |||
81257 | 2540 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1575 Burke Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016367.14673 | 2098986.82897 | 37.7443367189812 | -122.386058894813 | (37.7443367189812, -122.386058894813) | 10 | 3 | 8 | 58 | 1 | |||
85869 | 2534 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1575 Burke Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016196.15475 | 2099115.85615 | 37.7446815361299 | -122.386659150015 | (37.7446815361299, -122.386659150015) | 10 | 3 | 8 | 58 | 1 | |||
106760 | 2535 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1575 Burke Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016210.73833 | 2099105.12284 | 37.7446528720358 | -122.386607974081 | (37.7446528720358, -122.386607974081) | 10 | 3 | 8 | 58 | 1 | |||
139429 | 2541 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1575 Burke Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016218.6051359 | 2099112.8628025 | 37.7446745598911 | -122.386581311559 | (37.7446745598911, -122.386581311559) | 10 | 3 | 8 | 58 | 1 | |||
155081 | 2536 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1575 Burke Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016262.66893 | 2099065.69559 | 37.744547487686 | -122.38642565812 | (37.744547487686, -122.38642565812) | 10 | 3 | 8 | 58 | 1 | |||
18931 | 16634 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 158 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6002846.26234 | 2107315.61995 | 37.7664480128774 | -122.433406271499 | (37.7664480128774, -122.433406271499) | 15 | 5 | 5 | 28862 | 3 | |||
168339 | 2544 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 1580 BURKE AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3X3 | 6016440 | 2099034 | 37.7444702727306 | -122.385810268433 | (37.7444702727306, -122.385810268433) | 10 | 3 | 8 | 58 | 1 | |||
50667 | 2542 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 1580 Burke Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6016211.040056 | 2099180.9466222 | 37.7448610852571 | -122.386612216975 | (37.7448610852571, -122.386612216975) | 10 | 3 | 8 | 58 | 1 | |||
117844 | 188482 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1580 Burke Ave | 3 | : | Tree | DPW 1 | 03/30/1990 12:00:00 AM | 9 | Width 4ft | 6016171.38717 | 2099220.37618 | 37.7449671554124 | -122.386752079638 | (37.7449671554124, -122.386752079638) | 10 | 3 | 8 | 58 | 1 | ||
33787 | 2545 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1590X Burke Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/1990 12:00:00 AM | 12 | 3X3 | 6016148.3291237 | 2099227.8294693 | 37.7449863439757 | -122.386832330586 | (37.7449863439757, -122.386832330586) | 10 | 3 | 8 | 58 | 1 | ||
109158 | 2546 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1590X Burke Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016148.3291237 | 2099227.8294693 | 37.7449863439757 | -122.386832330586 | (37.7449863439757, -122.386832330586) | 10 | 3 | 8 | 58 | 1 | |||
149591 | 206002 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1593 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5991725.37276 | 2104496.31776 | 37.7580697533422 | -122.471665566332 | (37.7580697533422, -122.471665566332) | 1 | 8 | 4 | 56 | 12 | |||
191561 | 206003 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1593 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5991725.49788 | 2104502.2556 | 37.7580860643266 | -122.471665566325 | (37.7580860643266, -122.471665566325) | 1 | 8 | 4 | 56 | 12 | |||
37802 | 119741 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 15X Fremont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013411 | 2116073 | 37.7910874921548 | -122.39747874957 | (37.7910874921548, -122.39747874957) | 12 | 2 | 9 | 28855 | 6 | ||||
44569 | 119744 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 15X Fremont St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013411 | 2116073 | 37.7910874921548 | -122.39747874957 | (37.7910874921548, -122.39747874957) | 12 | 2 | 9 | 28855 | 6 | ||||
89068 | 119742 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 15X Fremont St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013411 | 2116073 | 37.7910874921548 | -122.39747874957 | (37.7910874921548, -122.39747874957) | 12 | 2 | 9 | 28855 | 6 | ||||
101550 | 119745 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 15X Fremont St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013411 | 2116073 | 37.7910874921548 | -122.39747874957 | (37.7910874921548, -122.39747874957) | 12 | 2 | 9 | 28855 | 6 | ||||
163468 | 119743 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 15X Fremont St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013411 | 2116073 | 37.7910874921548 | -122.39747874957 | (37.7910874921548, -122.39747874957) | 12 | 2 | 9 | 28855 | 6 | ||||
173505 | 119746 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 15X Fremont St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013411 | 2116073 | 37.7910874921548 | -122.39747874957 | (37.7910874921548, -122.39747874957) | 12 | 2 | 9 | 28855 | 6 | ||||
1800 | 189943 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 160 Spear St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6014663.90287 | 2116268.03372 | 37.7916926905231 | -122.393157367813 | (37.7916926905231, -122.393157367813) | 12 | 2 | 9 | 28855 | 6 | |||
178073 | 189942 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 160 Spear St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6014651.73587 | 2116280.65037 | 37.7917266570015 | -122.393200349112 | (37.7917266570015, -122.393200349112) | 12 | 2 | 9 | 28855 | 6 | |||
117426 | 17378 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1600 Palou Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6014792.92868 | 2095354.29337 | 37.7342752738796 | -122.391248382303 | (37.7342752738796, -122.391248382303) | 10 | 3 | 8 | 58 | 1 | |||
9688 | 52724 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 160@ HOWARD Spear St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/2006 12:00:00 AM | 7 | Permit Number 48777 | 6014638.31432 | 2116297.63809 | 37.791772555711 | -122.393247977227 | (37.791772555711, -122.393247977227) | 12 | 2 | 9 | 28855 | 6 | ||
134226 | 16641 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 161 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6002897.9493228 | 2107328.6416625 | 37.7664866995789 | -122.433228426337 | (37.7664866995789, -122.433228426337) | 15 | 5 | 5 | 28862 | 3 | |||
6962 | 189948 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 162 Spear St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 1ft | 6014781.22378 | 2116142.62721 | 37.7913548700732 | -122.392742658052 | (37.7913548700732, -122.392742658052) | 12 | 2 | 9 | 28855 | 6 | |||
138761 | 189947 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 162 Spear St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 1ft | 6014726.02618 | 2116202.25149 | 37.7915155186799 | -122.392937815425 | (37.7915155186799, -122.392937815425) | 12 | 2 | 9 | 28855 | 6 | |||
159299 | 189945 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 162 Spear St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 1ft | 6014694.61322 | 2116242.67208 | 37.7916247593304 | -122.393049334066 | (37.7916247593304, -122.393049334066) | 12 | 2 | 9 | 28855 | 6 | |||
161983 | 189946 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 162 Spear St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 1ft | 6014709.04159 | 2116225.6637 | 37.7915788597386 | -122.392998221109 | (37.7915788597386, -122.392998221109) | 12 | 2 | 9 | 28855 | 6 | |||
192269 | 189944 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 162 Spear St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6014676.15778 | 2116259.76194 | 37.7916706589171 | -122.393114386531 | (37.7916706589171, -122.393114386531) | 12 | 2 | 9 | 28855 | 6 | |||
239 | 205987 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1639 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5990866.8027 | 2104246.93654 | 37.7573353075836 | -122.474616638541 | (37.7573353075836, -122.474616638541) | 1 | 8 | 4 | 56 | 12 | |||
190273 | 222903 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 164 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009951.59256 | 2100103.15651 | 37.7470447557132 | -122.408321349458 | (37.7470447557132, -122.408321349458) | 2 | 7 | 7 | 28859 | 2 | |||
165394 | 17387 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1657 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6014551.02447 | 2095461.01119 | 37.7345548713079 | -122.392092190109 | (37.7345548713079, -122.392092190109) | 10 | 3 | 8 | 58 | 1 | |||
48301 | 225091 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 169 Lower Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6000007.70524 | 2106202.33536 | 37.7632297601708 | -122.443144329371 | (37.7632297601708, -122.443144329371) | 15 | 5 | 5 | 28862 | 3 | |||
100997 | 173732 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1690x Galvez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015419 | 2098106 | 37.7418656239974 | -122.389275919147 | (37.7418656239974, -122.389275919147) | 10 | 3 | 8 | 58 | 1 | ||||
15607 | 189834 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1698 Galvez Ave | 4 | : | Tree | Private 2 | 14 | Width 4ft | 6015429.09406 | 2098017.0802 | 37.7416220281222 | -122.389234809264 | (37.7416220281222, -122.389234809264) | 10 | 3 | 8 | 58 | 1 | |||
120516 | 189836 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1698 Galvez Ave | 9 | : | Tree | Private 2 | 13 | Width 4ft | 6015406.79125 | 2098034.46628 | 37.7416685302756 | -122.389313139314 | (37.7416685302756, -122.389313139314) | 10 | 3 | 8 | 58 | 1 | |||
173944 | 189837 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1698 Galvez Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 8ft | 6015387.45837 | 2098059.88528 | 37.7417372537812 | -122.389381761177 | (37.7417372537812, -122.389381761177) | 10 | 3 | 8 | 58 | 1 | |||
189953 | 189835 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1698 Galvez Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 6015422.83464 | 2098030.46357 | 37.7416584290923 | -122.389257386733 | (37.7416584290923, -122.389257386733) | 10 | 3 | 8 | 58 | 1 | |||
66656 | 16644 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 170 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6002849.24717 | 2107272.65524 | 37.7663302115978 | -122.433392876987 | (37.7663302115978, -122.433392876987) | 15 | 5 | 5 | 28862 | 3 | |||
63557 | 17398 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1734X Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6014174.38954 | 2095813.0161 | 37.7355004859498 | -122.393418978825 | (37.7355004859498, -122.393418978825) | 10 | 3 | 8 | 58 | 1 | |||
20031 | 17400 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1740 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6014126.91093 | 2095851.18558 | 37.7356026534403 | -122.393585802156 | (37.7356026534403, -122.393585802156) | 10 | 3 | 8 | 58 | 1 | |||
181866 | 68375 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 175 Alma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32198 | 5997884.42699251 | 2106160.35589629 | 37.7629931985038 | -122.45048498279 | (37.7629931985038, -122.45048498279) | 15 | 5 | 11 | 29492 | 9 | ||
129074 | 189916 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1771 Palou Ave | 1 | : | Tree | Private 2 | 15 | Width 4ft | 6013954.80906 | 2095907.81376 | 37.7357485783226 | -122.394184791988 | (37.7357485783226, -122.394184791988) | 10 | 3 | 8 | 58 | 1 | |||
118720 | 17403 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 1775 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 55 | 3x3 | 6013944.43098 | 2095916.733 | 37.7357724918668 | -122.394221297579 | (37.7357724918668, -122.394221297579) | 10 | 3 | 8 | 58 | 1 | |||
47329 | 16647 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 178 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/04/2015 12:00:00 AM | 14 | 4x4 | 6002850.60519 | 2107244.6681 | 37.7662534427777 | -122.433386179722 | (37.7662534427777, -122.433386179722) | 15 | 5 | 5 | 28862 | 3 | ||
18873 | 61724 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 18 Ceres St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1984 12:00:00 AM | 8 | Permit Number 21726 | 6013883.84127 | 2094072.5147 | 37.7307052783181 | -122.394301699376 | (37.7307052783181, -122.394301699376) | 10 | 3 | 8 | 58 | 1 | |
53007 | 106030 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 180 Howard St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6014615.46906 | 2115943.46238 | 37.790798802166 | -122.393302227016 | (37.790798802166, -122.393302227016) | 12 | 2 | 9 | 28855 | 6 | |||
54786 | 106031 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 180 Howard St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014640.7 | 2115990 | 37.7909279854042 | -122.39321818634 | (37.7909279854042, -122.39321818634) | 12 | 2 | 9 | 28855 | 6 | ||||
80077 | 106029 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 180 Howard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2015 12:00:00 AM | 14 | 3x3 | Permit Number 770222 | 6014636.89755 | 2115962.51686 | 37.7908523118267 | -122.393229418798 | (37.7908523118267, -122.393229418798) | 12 | 2 | 9 | 28855 | 6 | |
131100 | 106027 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 180 Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2015 12:00:00 AM | 11 | 3x3 | Permit Number 770222 | 6014665.81921 | 2115987.91534 | 37.7909236568574 | -122.393131128317 | (37.7909236568574, -122.393131128317) | 12 | 2 | 9 | 28855 | 6 | |
146708 | 116858 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 180 NOE ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3x3 | 6002788 | 2107242 | 37.7662425648461 | -122.433602528192 | (37.7662425648461, -122.433602528192) | 15 | 5 | 5 | 28862 | 3 | |||
135947 | 225081 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 181 College Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6004907.37106 | 2095955.144 | 37.7353714997996 | -122.425468699532 | (37.7353714997996, -122.425468699532) | 2 | 7 | 5 | 28861 | 2 | |||
172971 | 96123 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 181 College Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767774 | 6004920.8 | 2095965.5 | 37.7354006937902 | -122.425423007406 | (37.7354006937902, -122.425423007406) | 2 | 7 | 5 | 28861 | 2 | |
8282 | 80561 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1820X Palou Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15 | 6013651.87309 | 2096197.81138 | 37.7365280090438 | -122.395252475224 | (37.7365280090438, -122.395252475224) | 10 | 3 | 8 | 58 | 1 | |||
52927 | 17415 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1820X Palou Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6013619.40586 | 2096223.80848 | 37.7365975859977 | -122.395366549732 | (37.7365975859977, -122.395366549732) | 10 | 3 | 8 | 58 | 1 | |||
63725 | 96756 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1820X Palou Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6013661.38712 | 2096183.48051 | 37.736489188553 | -122.395218577377 | (37.736489188553, -122.395218577377) | 10 | 3 | 8 | 58 | 1 | |||
158939 | 17414 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1820X Palou Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6013664.43707 | 2096187.44321 | 37.7365002389252 | -122.395208309826 | (37.7365002389252, -122.395208309826) | 10 | 3 | 8 | 58 | 1 | |||
80491 | 17417 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1836 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6013526.86611 | 2096296.97727 | 37.7367933450374 | -122.395691626761 | (37.7367933450374, -122.395691626761) | 10 | 3 | 8 | 58 | 1 | |||
32220 | 17420 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1844 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6013467.77602 | 2096339.40457 | 37.7369065543995 | -122.395898900707 | (37.7369065543995, -122.395898900707) | 10 | 3 | 8 | 58 | 1 | |||
154516 | 189965 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 185 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6009800.49683 | 2111495.15523 | 37.7783161303187 | -122.409647766737 | (37.7783161303187, -122.409647766737) | 14 | 2 | 9 | 28853 | 34 | |||
54510 | 225090 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 188 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6002851.63466 | 2107200.77986 | 37.7661329947706 | -122.433379482476 | (37.7661329947706, -122.433379482476) | 15 | 5 | 5 | 28862 | 3 | |||
93841 | 17432 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1899 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6013304.38665 | 2096386.76437 | 37.7370275033033 | -122.396467132869 | (37.7370275033033, -122.396467132869) | 10 | 3 | 8 | 58 | 1 | |||
74388 | 16650 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 190 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6002855.60879 | 2107200.17785 | 37.7661315672606 | -122.433365693732 | (37.7661315672606, -122.433365693732) | 15 | 5 | 5 | 28862 | 3 | |||
113575 | 17433 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1900 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6013265.7394 | 2096489.52235 | 37.7373075045406 | -122.396607955902 | (37.7373075045406, -122.396607955902) | 10 | 3 | 8 | 58 | 1 | |||
52265 | 95955 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 190X Spear St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/18/2011 12:00:00 AM | 3x3 | Permit Number 767637 | 6014675 | 2116143.7 | 37.791351915434 | -122.393110267966 | (37.791351915434, -122.393110267966) | 12 | 2 | 9 | 28855 | 6 | ||
146541 | 17437 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1919 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6013108.75457 | 2096537.612 | 37.7374308105776 | -122.397154099803 | (37.7374308105776, -122.397154099803) | 10 | 3 | 8 | 58 | 1 | |||
107783 | 17444 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1950 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3X3 | 6013023.36347 | 2096670.73663 | 37.7377915889102 | -122.397458672302 | (37.7377915889102, -122.397458672302) | 10 | 3 | 8 | 58 | 1 | |||
5594 | 106035 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 195X Main St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014366.74772 | 2116104.57878 | 37.7912273690908 | -122.394174082061 | (37.7912273690908, -122.394174082061) | 12 | 2 | 9 | 28855 | 6 | ||||
105981 | 106036 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 195X Main St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2015 12:00:00 AM | 3x3 | Permit Number 770222 | 6014366.74772 | 2116104.57878 | 37.7912273690908 | -122.394174082061 | (37.7912273690908, -122.394174082061) | 12 | 2 | 9 | 28855 | 6 | ||
147008 | 106033 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 195X Main St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014366.74772 | 2116104.57878 | 37.7912273690908 | -122.394174082061 | (37.7912273690908, -122.394174082061) | 12 | 2 | 9 | 28855 | 6 | ||||
194245 | 106032 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 195X Main St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014366.74772 | 2116104.57878 | 37.7912273690908 | -122.394174082061 | (37.7912273690908, -122.394174082061) | 12 | 2 | 9 | 28855 | 6 | ||||
23738 | 4926 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 195X Newhall St | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6017015.0972074 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | 10 | 3 | 8 | 58 | 1 | |||
34404 | 4917 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 195X Newhall St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/26/2015 05:50:00 AM | 3 | 3X3 | 6017015.0972074 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | 10 | 3 | 8 | 58 | 1 | ||
35125 | 4920 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 195X Newhall St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/26/2015 05:54:00 AM | 3 | 3X3 | 6017015.0972074 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | 10 | 3 | 8 | 58 | 1 | ||
54072 | 4915 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 195X Newhall St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6017015.0972074 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | 10 | 3 | 8 | 58 | 1 | |||
55882 | 4925 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 195X Newhall St | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6017015.0972074 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | 10 | 3 | 8 | 58 | 1 | |||
62069 | 4912 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 195X Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/2016 12:00:00 AM | 12 | 3X3 | 6017015.0972074 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | 10 | 3 | 8 | 58 | 1 | ||
95486 | 4922 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 195X Newhall St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6017015.0972074 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | 10 | 3 | 8 | 58 | 1 | |||
143134 | 4923 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 195X Newhall St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6017015.0972074 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | 10 | 3 | 8 | 58 | 1 | |||
164425 | 4913 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 195X Newhall St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6017015.0972074 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | 10 | 3 | 8 | 58 | 1 | |||
165477 | 4918 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 195X Newhall St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6017015.0972074 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | 10 | 3 | 8 | 58 | 1 | |||
183470 | 4916 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 195X Newhall St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/26/2015 05:46:00 AM | 3 | 3X3 | 6017015.0972074 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | 10 | 3 | 8 | 58 | 1 |
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) );