trees
228 rows where qCaretaker_id = 2 and qSpecies_id = 59 sorted by TreeID
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 39747 | 196021 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 25 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | 6015567.39764 | 2110686.7089 | 37.7764177856004 | -122.389641269543 | (37.7764177856004, -122.389641269543) | 14 | 3 | 9 | 310 | 20 | ||||
| 68586 | 196022 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | 6015549.75144 | 2110684.1794 | 37.7764098616684 | -122.389702136539 | (37.7764098616684, -122.389702136539) | 14 | 3 | 9 | 310 | 20 | ||||
| 108842 | 196023 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1670 Owen St | 28 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 8ft | 6013858.29957 | 2107482.27299 | 37.7675242045935 | -122.395329033601 | (37.7675242045935, -122.395329033601) | 14 | 3 | 9 | 310 | 20 | |||
| 100049 | 196024 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1670 Owen St | 29 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 8ft | 6013848.21751 | 2107498.56576 | 37.7675683801977 | -122.395365047877 | (37.7675683801977, -122.395365047877) | 14 | 3 | 9 | 310 | 20 | |||
| 79693 | 196025 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2 Lane St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 10ft | 6017042.18161 | 2097072.11853 | 37.7391166482065 | -122.383591469892 | (37.7391166482065, -122.383591469892) | 10 | 3 | 8 | 58 | 1 | |||
| 136935 | 196026 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2 Lane St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 10ft | 6017039.21913 | 2097067.45785 | 37.7391036871735 | -122.383601388517 | (37.7391036871735, -122.383601388517) | 10 | 3 | 8 | 58 | 1 | |||
| 124042 | 196027 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2 Lane St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 6017034.20589 | 2097061.66689 | 37.7390875092666 | -122.383618319135 | (37.7390875092666, -122.383618319135) | 10 | 3 | 8 | 58 | 1 | |||
| 72063 | 196028 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2 Lane St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 10ft | 6017030.63637 | 2097056.65947 | 37.7390735625998 | -122.383630312507 | (37.7390735625998, -122.383630312507) | 10 | 3 | 8 | 58 | 1 | |||
| 178720 | 196029 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2 Lane St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 6017027.27121 | 2097051.6476 | 37.7390596150087 | -122.383641598974 | (37.7390596150087, -122.383641598974) | 10 | 3 | 8 | 58 | 1 | |||
| 38227 | 196030 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2 Lane St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 10ft | 6017023.70578 | 2097046.84349 | 37.739046226814 | -122.383653592346 | (37.739046226814, -122.383653592346) | 10 | 3 | 8 | 58 | 1 | |||
| 152914 | 196031 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2 Lane St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 6017021.60504 | 2097043.83814 | 37.7390378586108 | -122.383660646635 | (37.7390378586108, -122.383660646635) | 10 | 3 | 8 | 58 | 1 | |||
| 72670 | 196032 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2 Lane St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 10ft | 6017018.89253 | 2097040.84511 | 37.7390294904202 | -122.383669817022 | (37.7390294904202, -122.383669817022) | 10 | 3 | 8 | 58 | 1 | |||
| 102343 | 196033 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2 Lane St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 6017016.3348 | 2097035.41086 | 37.7390144276853 | -122.383678282325 | (37.7390144276853, -122.383678282325) | 10 | 3 | 8 | 58 | 1 | |||
| 91426 | 196034 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | Width 10ft | 6017038.23562 | 2096967.92235 | 37.7388303283508 | -122.38359786136 | (37.7388303283508, -122.38359786136) | 10 | 3 | 8 | 58 | 1 | |||
| 104734 | 196035 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 10ft | 6017042.43736 | 2096973.93304 | 37.7388470647366 | -122.383583751905 | (37.7388470647366, -122.383583751905) | 10 | 3 | 8 | 58 | 1 | |||
| 153530 | 196036 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 10ft | 6017046.41048 | 2096978.72928 | 37.738860453849 | -122.383570348389 | (37.738860453849, -122.383570348389) | 10 | 3 | 8 | 58 | 1 | |||
| 98268 | 196037 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 10ft | 6017049.14343 | 2096982.73756 | 37.7388716108342 | -122.383561177999 | (37.7388716108342, -122.383561177999) | 10 | 3 | 8 | 58 | 1 | |||
| 35055 | 196038 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 10ft | 6017052.09274 | 2096987.35134 | 37.7388844423585 | -122.38355130167 | (37.7388844423585, -122.38355130167) | 10 | 3 | 8 | 58 | 1 | |||
| 52670 | 196039 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 10ft | 6017058.78761 | 2096996.23306 | 37.7389091998064 | -122.38352877184 | (37.7389091998064, -122.38352877184) | 10 | 3 | 8 | 58 | 1 | |||
| 110153 | 196040 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 10ft | 6017061.14337 | 2096999.06361 | 37.7389171021312 | -122.383520823632 | (37.7389171021312, -122.383520823632) | 10 | 3 | 8 | 58 | 1 | |||
| 158208 | 196041 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 6017065.52556 | 2097005.97628 | 37.7389363251367 | -122.383506153 | (37.7389363251367, -122.383506153) | 10 | 3 | 8 | 58 | 1 | |||
| 144912 | 196042 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 6017068.02223 | 2097008.36414 | 37.7389430197102 | -122.383497686772 | (37.7389430197102, -122.383497686772) | 10 | 3 | 8 | 58 | 1 | |||
| 21224 | 196043 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 10ft | 6017069.89025 | 2097009.95172 | 37.7389474821301 | -122.383491338448 | (37.7389474821301, -122.383491338448) | 10 | 3 | 8 | 58 | 1 | |||
| 148904 | 196044 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 10ft | 6017074.4672 | 2097014.32935 | 37.7389597551859 | -122.383475817977 | (37.7389597551859, -122.383475817977) | 10 | 3 | 8 | 58 | 1 | |||
| 66956 | 196045 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 10ft | 6017076.58838 | 2097018.35028 | 37.7389709130863 | -122.383468763681 | (37.7389709130863, -122.383468763681) | 10 | 3 | 8 | 58 | 1 | |||
| 37731 | 196046 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 10ft | 6017076.84536 | 2097020.98628 | 37.7389781652152 | -122.383468058608 | (37.7389781652152, -122.383468058608) | 10 | 3 | 8 | 58 | 1 | |||
| 159019 | 196047 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | Width 10ft | 6017083.09876 | 2097027.5652 | 37.7389965752218 | -122.383446894874 | (37.7389965752218, -122.383446894874) | 10 | 3 | 8 | 58 | 1 | |||
| 112062 | 196048 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 25 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 10ft | 6017086.86394 | 2097032.16257 | 37.7390094067689 | -122.383434196434 | (37.7390094067689, -122.383434196434) | 10 | 3 | 8 | 58 | 1 | |||
| 164057 | 196049 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 35 | Width 10ft | 6017090.91062 | 2097040.61449 | 37.7390328376916 | -122.383420792935 | (37.7390328376916, -122.383420792935) | 10 | 3 | 8 | 58 | 1 | |||
| 97183 | 201993 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1799 Carroll Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 6013314.35101 | 2092488.44605 | 37.7263240762942 | -122.396159554816 | (37.7263240762942, -122.396159554816) | 10 | 3 | 8 | 58 | 1 | ||||
| 104890 | 201994 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1799 Carroll Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 6013316.6056 | 2092506.69666 | 37.7263743142142 | -122.396153039251 | (37.7263743142142, -122.396153039251) | 10 | 3 | 8 | 58 | 1 | ||||
| 61218 | 201995 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1799 Carroll Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 6013319.20907 | 2092521.70031 | 37.7264156560521 | -122.396145090149 | (37.7264156560521, -122.396145090149) | 10 | 3 | 8 | 58 | 1 | ||||
| 21347 | 201996 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1799 Carroll Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 6013312.67339 | 2092499.74696 | 37.7263550129554 | -122.396166145968 | (37.7263550129554, -122.396166145968) | 10 | 3 | 8 | 58 | 1 | ||||
| 169280 | 201997 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1799 Carroll Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 6013313.68951 | 2092516.98736 | 37.7264024081338 | -122.396163841002 | (37.7264024081338, -122.396163841002) | 10 | 3 | 8 | 58 | 1 | ||||
| 140069 | 212849 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1201 Ulloa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5992374.69215 | 2098410.70315 | 37.7413977704887 | -122.468977090726 | (37.7413977704887, -122.468977090726) | 1 | 8 | 4 | 59 | 40 | |||
| 109416 | 212850 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 32 Malta Dr | 32 | Sidewalk: Curb side : Yard | Tree | Private 2 | 32 | Width 3ft | 5999489.82188 | 2096117.1264 | 37.7355086796695 | -122.444210754429 | (37.7355086796695, -122.444210754429) | 9 | 7 | 4 | 63 | 40 | |||
| 16015 | 220524 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 110 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1974 12:00:00 AM | 38 | Width 3ft | Permit Number 14125 | 6003373.13767 | 2108706.4584 | 37.7702967937804 | -122.431683217203 | (37.7702967937804, -122.431683217203) | 15 | 9 | 11 | 29492 | 10 | |
| 165442 | 234871 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6010740.98958 | 2100867.24575 | 37.7491869507297 | -122.405645476962 | (37.7491869507297, -122.405645476962) | 10 | 4 | 7 | 28859 | 19 | ||||
| 24893 | 234872 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 31 | 6010732.42318 | 2100864.09022 | 37.7491778073048 | -122.405674877619 | (37.7491778073048, -122.405674877619) | 10 | 4 | 7 | 28859 | 19 | ||||
| 21087 | 234873 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 6010726.23893 | 2100862.83367 | 37.7491740112676 | -122.405696174457 | (37.7491740112676, -122.405696174457) | 10 | 4 | 7 | 28859 | 19 | ||||
| 111134 | 234874 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 33 | 6010703.27515 | 2100855.87105 | 37.7491536092595 | -122.40577509356 | (37.7491536092595, -122.40577509356) | 10 | 4 | 7 | 28859 | 19 | ||||
| 66581 | 234875 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6010693.4536 | 2100854.39807 | 37.7491490155229 | -122.405808953037 | (37.7491490155229, -122.405808953037) | 10 | 4 | 7 | 28859 | 19 | ||||
| 146008 | 234876 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 27 | 6010649.76891 | 2100846.09542 | 37.7491237751432 | -122.405959431208 | (37.7491237751432, -122.405959431208) | 10 | 4 | 7 | 28859 | 19 | ||||
| 182229 | 234877 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 38 | 6010643.54009 | 2100844.31084 | 37.7491185267072 | -122.405980844948 | (37.7491185267072, -122.405980844948) | 10 | 4 | 7 | 28859 | 19 | ||||
| 117375 | 234878 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | 6010615.53478 | 2100839.32379 | 37.7491032670092 | -122.406077336824 | (37.7491032670092, -122.406077336824) | 10 | 4 | 7 | 28859 | 19 | ||||
| 121304 | 234879 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 30 | 6010587.10266 | 2100832.95642 | 37.7490841933025 | -122.406175207346 | (37.7490841933025, -122.406175207346) | 10 | 4 | 7 | 28859 | 19 | ||||
| 114900 | 234880 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | 6010577.49101 | 2100830.77043 | 37.7490776534227 | -122.406208290698 | (37.7490776534227, -122.406208290698) | 10 | 4 | 7 | 28859 | 19 | ||||
| 115793 | 234881 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 29 | 6010567.07854 | 2100828.40228 | 37.749070568567 | -122.406244130469 | (37.749070568567, -122.406244130469) | 10 | 4 | 7 | 28859 | 19 | ||||
| 78172 | 234882 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6010551.46993 | 2100825.34606 | 37.7490613037485 | -122.406297890147 | (37.7490613037485, -122.406297890147) | 10 | 4 | 7 | 28859 | 19 | ||||
| 131745 | 234883 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | 6010542.26084 | 2100823.35069 | 37.7490553097539 | -122.406329594845 | (37.7490553097539, -122.406329594845) | 10 | 4 | 7 | 28859 | 19 | ||||
| 34861 | 234884 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | 6010535.25533 | 2100821.90556 | 37.7490509498578 | -122.406353718268 | (37.7490509498578, -122.406353718268) | 10 | 4 | 7 | 28859 | 19 | ||||
| 142091 | 234885 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6010529.65259 | 2100820.82881 | 37.7490476799194 | -122.406373016826 | (37.7490476799194, -122.406373016826) | 10 | 4 | 7 | 28859 | 19 | ||||
| 121047 | 234886 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 28 | 6010522.64734 | 2100819.38367 | 37.7490433200014 | -122.406397139344 | (37.7490433200014, -122.406397139344) | 10 | 4 | 7 | 28859 | 19 | ||||
| 110194 | 234887 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2827 Cesar Chavez St | 1 | Front Yard : Yard | Tree | Private 2 | 15 | 6010600.22161 | 2100713.10517 | 37.7487558418292 | -122.406121399085 | (37.7487558418292, -122.406121399085) | 2 | 7 | 7 | 28859 | 2 | ||||
| 52513 | 234888 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2827 Cesar Chavez St | 2 | Front Yard : Yard | Tree | Private 2 | 33 | 6010611.763 | 2100694.95228 | 37.7487066435094 | -122.406080210127 | (37.7487066435094, -122.406080210127) | 2 | 7 | 7 | 28859 | 2 | ||||
| 47166 | 234889 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2827 Cesar Chavez St | 3 | Front Yard : Yard | Tree | Private 2 | 25 | 6010620.28496 | 2100677.87035 | 37.7486602169168 | -122.406049537871 | (37.7486602169168, -122.406049537871) | 2 | 7 | 7 | 28859 | 2 | ||||
| 97525 | 234890 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2827 Cesar Chavez St | 4 | Front Yard : Yard | Tree | Private 2 | 14 | 6010623.85334 | 2100666.44158 | 37.7486290355994 | -122.406036393361 | (37.7486290355994, -122.406036393361) | 2 | 7 | 7 | 28859 | 2 | ||||
| 76548 | 234891 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2827 Cesar Chavez St | 5 | Front Yard : Yard | Tree | Private 2 | 12 | 6010619.31212 | 2100642.55964 | 37.7485632070257 | -122.406050414705 | (37.7485632070257, -122.406050414705) | 2 | 7 | 7 | 28859 | 2 | ||||
| 111007 | 234892 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2827 Cesar Chavez St | 6 | Front Yard : Yard | Tree | Private 2 | 18 | 6010653.55518 | 2100656.49907 | 37.7486033968442 | -122.40593298392 | (37.7486033968442, -122.40593298392) | 2 | 7 | 7 | 28859 | 2 | ||||
| 23378 | 234893 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2827 Cesar Chavez St | 7 | Front Yard : Yard | Tree | Private 2 | 17 | 6010664.01336 | 2100659.8191 | 37.7486130978165 | -122.405897053323 | (37.7486130978165, -122.405897053323) | 2 | 7 | 7 | 28859 | 2 | ||||
| 187174 | 234894 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2827 Cesar Chavez St | 12 | Front Yard : Yard | Tree | Private 2 | 27 | 6010729.67514 | 2100698.35511 | 37.7487225812957 | -122.405672708429 | (37.7487225812957, -122.405672708429) | 2 | 7 | 7 | 28859 | 2 | ||||
| 99978 | 234895 | Property Tree 8 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 3255x 24th St | 6 | Side Yard : Cutout | Tree | Private 2 | 40 | Width 10ft | 6007298 | 2102020 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | 2 | 4 | 7 | 28859 | 19 | |||
| 150253 | 234896 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 10ft | 6007240.7393 | 2101963.94083 | 37.7520018736867 | -122.417827151095 | (37.7520018736867, -122.417827151095) | 2 | 4 | 7 | 28859 | 19 | |||
| 3136 | 234897 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6009692.09622 | 2096449.43711 | 37.7369979030329 | -122.408960917621 | (37.7369979030329, -122.408960917621) | 10 | 7 | 7 | 28859 | 2 | ||||
| 147412 | 234898 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | 6009700.61042 | 2096445.6891 | 37.7369880887377 | -122.408931215729 | (37.7369880887377, -122.408931215729) | 10 | 7 | 7 | 28859 | 2 | ||||
| 83040 | 234899 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | 6009698.94501 | 2096439.52165 | 37.7369710609585 | -122.408936538802 | (37.7369710609585, -122.408936538802) | 10 | 7 | 7 | 28859 | 2 | ||||
| 179780 | 234900 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6009696.65795 | 2096435.22954 | 37.7369591476365 | -122.40894414348 | (37.7369591476365, -122.40894414348) | 10 | 7 | 7 | 28859 | 2 | ||||
| 122830 | 234901 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6009690.97834 | 2096436.62736 | 37.7369626675976 | -122.408963879105 | (37.7369626675976, -122.408963879105) | 10 | 7 | 7 | 28859 | 2 | ||||
| 152488 | 234902 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6009698.63441 | 2096418.94153 | 37.7369145349811 | -122.408936161078 | (37.7369145349811, -122.408936161078) | 10 | 7 | 7 | 28859 | 2 | ||||
| 19126 | 234903 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 6009692.65358 | 2096419.54828 | 37.7369158659624 | -122.408956882348 | (37.7369158659624, -122.408956882348) | 10 | 7 | 7 | 28859 | 2 | ||||
| 58340 | 234904 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6009689.76503 | 2096405.45865 | 37.7368770170648 | -122.408965875569 | (37.7368770170648, -122.408965875569) | 10 | 7 | 7 | 28859 | 2 | ||||
| 164603 | 234905 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 8ft | 6009688.58582 | 2096390.10165 | 37.736834783993 | -122.40896886942 | (37.736834783993, -122.40896886942) | 10 | 7 | 7 | 28859 | 2 | |||
| 125376 | 234906 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 8ft | 6009686.02423 | 2096384.83518 | 37.7368201799074 | -122.408977354526 | (37.7368201799074, -122.408977354526) | 10 | 7 | 7 | 28859 | 2 | |||
| 56401 | 234907 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 8ft | 6009682.36778 | 2096375.42259 | 37.7367941301369 | -122.408989332604 | (37.7367941301369, -122.408989332604) | 10 | 7 | 7 | 28859 | 2 | |||
| 125984 | 234908 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 10ft | 6009679.55053 | 2096368.23252 | 37.7367742299367 | -122.408998565949 | (37.7367742299367, -122.408998565949) | 10 | 7 | 7 | 28859 | 2 | |||
| 49707 | 234909 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 10ft | 6009677.77783 | 2096362.72232 | 37.7367590008107 | -122.409004306302 | (37.7367590008107, -122.409004306302) | 10 | 7 | 7 | 28859 | 2 | |||
| 145764 | 246917 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 845 Shrader St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 3ft | 5997637.48509 | 2107521.28402 | 37.766715824697 | -122.451437229753 | (37.766715824697, -122.451437229753) | 15 | 5 | 11 | 29492 | 9 | |||
| 74379 | 246918 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 845 Shrader St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 3ft | 5997638.10514 | 2107510.95773 | 37.7666875068428 | -122.451434340243 | (37.7666875068428, -122.451434340243) | 15 | 5 | 11 | 29492 | 9 | |||
| 111973 | 247225 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 754 Duboce Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6002109.57301 | 2108309.81574 | 37.7691360073432 | -122.4360254903 | (37.7691360073432, -122.4360254903) | 15 | 5 | 5 | 29492 | 9 | ||||
| 35297 | 248111 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 108 Brewster St | 1 | Side Yard : Yard | Tree | Private 2 | 24 | 6010383.71107 | 2099443.85944 | 37.7452586580609 | -122.406780656096 | (37.7452586580609, -122.406780656096) | 2 | 7 | 7 | 28859 | 2 | ||||
| 40536 | 248113 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 108 Brewster St | 3 | Side Yard : Yard | Tree | Private 2 | 17 | 6010385.30327 | 2099441.28079 | 37.7452516667373 | -122.406774968811 | (37.7452516667373, -122.406774968811) | 2 | 7 | 7 | 28859 | 2 | ||||
| 89186 | 248114 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 108 Brewster St | 4 | Side Yard : Yard | Tree | Private 2 | 15 | 6010381.0463 | 2099434.05906 | 37.7452315992509 | -122.406789179902 | (37.7452315992509, -122.406789179902) | 2 | 7 | 7 | 28859 | 2 | ||||
| 80514 | 248115 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 108 Brewster St | 5 | Side Yard : Yard | Tree | Private 2 | 7 | 6010382.66989 | 2099427.30215 | 37.7452131370921 | -122.406783089664 | (37.7452131370921, -122.406783089664) | 2 | 7 | 7 | 28859 | 2 | ||||
| 104444 | 248116 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 108 Brewster St | 6 | Side Yard : Yard | Tree | Private 2 | 9 | 6010379.57479 | 2099419.47211 | 37.745191464328 | -122.406793240314 | (37.745191464328, -122.406793240314) | 2 | 7 | 7 | 28859 | 2 | ||||
| 37570 | 248117 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 108 Brewster St | 7 | Side Yard : Yard | Tree | Private 2 | 6 | 6010378.29952 | 2099414.5285 | 37.7451778188963 | -122.406797301657 | (37.7451778188963, -122.406797301657) | 2 | 7 | 7 | 28859 | 2 | ||||
| 172175 | 248118 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 108 Brewster St | 8 | Side Yard : Yard | Tree | Private 2 | 6 | 6010376.97092 | 2099406.95495 | 37.7451569492381 | -122.40680136209 | (37.7451569492381, -122.40680136209) | 2 | 7 | 7 | 28859 | 2 | ||||
| 87689 | 248119 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 108 Brewster St | 9 | Side Yard : Yard | Tree | Private 2 | 18 | 6010375.35501 | 2099399.67941 | 37.7451368817742 | -122.406806436993 | (37.7451368817742, -122.406806436993) | 2 | 7 | 7 | 28859 | 2 | ||||
| 146085 | 248120 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 108 Brewster St | 10 | Side Yard : Yard | Tree | Private 2 | 12 | 6010373.21137 | 2099395.33781 | 37.745124840742 | -122.406813543437 | (37.745124840742, -122.406813543437) | 2 | 7 | 7 | 28859 | 2 | ||||
| 77949 | 248121 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 109 Brewster St | 1 | Front Yard : Yard | Tree | Private 2 | 11 | 6010387.39582 | 2099398.52057 | 37.7451343735684 | -122.406764720109 | (37.7451343735684, -122.406764720109) | 2 | 7 | 7 | 28859 | 2 | ||||
| 113044 | 248122 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 109 Brewster St | 2 | Front Yard : Yard | Tree | Private 2 | 14 | 6010390.78091 | 2099407.55033 | 37.7451593567256 | -122.406753651253 | (37.7451593567256, -122.406753651253) | 2 | 7 | 7 | 28859 | 2 | ||||
| 191905 | 248123 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 109 Brewster St | 3 | Front Yard : Yard | Tree | Private 2 | 13 | 6010392.06783 | 2099413.07866 | 37.7451746083214 | -122.406749590819 | (37.7451746083214, -122.406749590819) | 2 | 7 | 7 | 28859 | 2 | ||||
| 40830 | 248124 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 109 Brewster St | 4 | Front Yard : Yard | Tree | Private 2 | 10 | 6010394.26479 | 2099420.04988 | 37.7451938726969 | -122.406742485274 | (37.7451938726969, -122.406742485274) | 2 | 7 | 7 | 28859 | 2 | ||||
| 19786 | 248125 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 109 Brewster St | 5 | Front Yard : Yard | Tree | Private 2 | 7 | 6010397.04877 | 2099427.00914 | 37.7452131370768 | -122.406733349058 | (37.7452131370768, -122.406733349058) | 2 | 7 | 7 | 28859 | 2 | ||||
| 145571 | 248126 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 109 Brewster St | 6 | Front Yard : Yard | Tree | Private 2 | 6 | 6010387.78953 | 2099433.6295 | 37.7452307970734 | -122.406765832574 | (37.7452307970734, -122.406765832574) | 2 | 7 | 7 | 28859 | 2 | ||||
| 126542 | 248127 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 109 Brewster St | 7 | Front Yard : Yard | Tree | Private 2 | 18 | 6010399.6226 | 2099438.06548 | 37.7452436393873 | -122.406725228187 | (37.7452436393873, -122.406725228187) | 2 | 7 | 7 | 28859 | 2 | ||||
| 80814 | 248172 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 218 Esmeralda Ave | 1 | Side Yard : Yard | Tree | Private 2 | 12 | 6007302.01446 | 2098729.32454 | 37.7431237943252 | -122.417386043537 | (37.7431237943252, -122.417386043537) | 2 | 7 | 7 | 28859 | 2 | ||||
| 20810 | 248173 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 218 Esmeralda Ave | 2 | Side Yard : Yard | Tree | Private 2 | 6 | 6007303.95131 | 2098726.55555 | 37.743116300271 | -122.417379150221 | (37.743116300271, -122.417379150221) | 2 | 7 | 7 | 28859 | 2 | ||||
| 96656 | 248613 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 845 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 0ft | 5997648.1233 | 2107524.615 | 37.766725579885 | -122.451400674442 | (37.766725579885, -122.451400674442) | 15 | 5 | 11 | 29492 | 9 | |||
| 102733 | 248614 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 845 Shrader St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 5997650.5459 | 2107506.4452 | 37.7666758289672 | -122.451390984496 | (37.7666758289672, -122.451390984496) | 15 | 5 | 11 | 29492 | 9 | |||
| 12617 | 249797 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 199 Chestnut St | 5 | Front Yard : Yard | Tree | Private 2 | 13 | Width 0ft | 6010839.41961 | 2121064.72571 | 37.8046500380318 | -122.406728311085 | (37.8046500380318, -122.406728311085) | 3 | 1 | 10 | 308 | 23 |
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) );