trees
856 rows where qSpecies_id = 5 sorted by qAddress 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11562 | 206018 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 99 Merced Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5994828.29695 | 2099714.01169 | 37.7451177882671 | -122.460587859436 | (37.7451177882671, -122.460587859436) | 1 | 8 | 4 | 59 | 40 | |||
111983 | 206019 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 99 Merced Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5994816.51833 | 2099704.78199 | 37.7450917681756 | -122.460627918846 | (37.7450917681756, -122.460627918846) | 1 | 8 | 4 | 59 | 40 | |||
22673 | 248195 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 99 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006895.3062 | 2099022.51404 | 37.7439059356157 | -122.418813123741 | (37.7439059356157, -122.418813123741) | 2 | 7 | 7 | 28859 | 2 | |||
83815 | 248196 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 99 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006902.26536 | 2099037.70953 | 37.7439480508589 | -122.418790137961 | (37.7439480508589, -122.418790137961) | 2 | 7 | 7 | 28859 | 2 | |||
20659 | 59670 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 98X PARNASSUS AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 15 | 3x3 | Permit Number 32228 | 5998297 | 2106864 | 37.7649488326227 | -122.449108733904 | (37.7649488326227, -122.449108733904) | 15 | 5 | 11 | 29492 | 9 |
112170 | 56845 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 980 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/02/1974 12:00:00 AM | 4x4 | Permit Number 14078 | 5998833.42862215 | 2106621.08669964 | 37.7643125198309 | -122.447235885769 | (37.7643125198309, -122.447235885769) | 15 | 5 | 11 | 29492 | 9 | ||
132144 | 222926 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 980 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5998842.04298 | 2106555.36385 | 37.7641325536076 | -122.447201360861 | (37.7641325536076, -122.447201360861) | 15 | 5 | 11 | 29492 | 9 | |||
16205 | 222929 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 979 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/1979 12:00:00 AM | 10 | Width 4ft | Permit Number 17592 | 5999199.8898 | 2106672.6396 | 37.7644750037296 | -122.445972112616 | (37.7644750037296, -122.445972112616) | 15 | 5 | 11 | 29492 | 9 | |
171993 | 225042 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 979 Ashbury St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5999193.16537 | 2106656.55415 | 37.7644304531311 | -122.445994213458 | (37.7644304531311, -122.445994213458) | 15 | 5 | 11 | 29492 | 9 | |||
72128 | 225047 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 971 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6009431.36633 | 2103539.27108 | 37.7564504151646 | -122.410362833886 | (37.7564504151646, -122.410362833886) | 2 | 4 | 7 | 28859 | 19 | |||
117938 | 105930 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 971 Florida St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009455 | 2103552.4 | 37.7564877890416 | -122.410282026926 | (37.7564877890416, -122.410282026926) | 2 | 4 | 7 | 28859 | 19 | |||||
98842 | 22886 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 95X Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6006042.93395 | 2109155.55847 | 37.7716808854236 | -122.422480302267 | (37.7716808854236, -122.422480302267) | 8 | 2 | 9 | 28853 | 19 | |||
136547 | 22889 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 95X Valencia St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 6006042.93395 | 2109155.55847 | 37.7716808854236 | -122.422480302267 | (37.7716808854236, -122.422480302267) | 8 | 2 | 9 | 28853 | 19 | |||
32299 | 222920 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 957 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 5998076.5165 | 2106905.97838 | 37.765051481758 | -122.449874352843 | (37.765051481758, -122.449874352843) | 15 | 5 | 11 | 29492 | 9 | |||
69905 | 222921 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 957 Cole St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 5998078.46928 | 2106885.24351 | 37.7649946607859 | -122.449866104246 | (37.7649946607859, -122.449866104246) | 15 | 5 | 11 | 29492 | 9 | |||
57482 | 140579 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 949 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6003399.7999 | 2111643.4846 | 37.7783626547096 | -122.431800729752 | (37.7783626547096, -122.431800729752) | 15 | 9 | 11 | 29492 | 41 | |||
108294 | 140580 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 949 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6003403.4849 | 2111618.6108 | 37.7782945663272 | -122.43178620552 | (37.7782945663272, -122.43178620552) | 15 | 9 | 11 | 29492 | 41 | |||
139016 | 140578 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 949 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6003397.0361 | 2111670.2009 | 37.7784358543561 | -122.431812198827 | (37.7784358543561, -122.431812198827) | 15 | 9 | 11 | 29492 | 41 | |||
24686 | 20125 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 924X Fell St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6002999.41967 | 2110319.25168 | 37.7747039360019 | -122.433091154251 | (37.7747039360019, -122.433091154251) | 15 | 5 | 11 | 29492 | 10 | |||
26621 | 222916 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 92 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6004301.92294 | 2109033.13825 | 37.7712463798496 | -122.428493839936 | (37.7712463798496, -122.428493839936) | 7 | 9 | 11 | 28852 | 10 | |||
18852 | 222928 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 912 Clayton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5998758.16977 | 2106859.07637 | 37.7649616790718 | -122.447513315894 | (37.7649616790718, -122.447513315894) | 15 | 5 | 11 | 29492 | 9 | |||
69587 | 67184 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 912 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1992 12:00:00 AM | Permit Number 30631 | 5998760.11857013 | 2106856.81248154 | 37.7649555743728 | -122.447506412542 | (37.7649555743728, -122.447506412542) | 15 | 5 | 11 | 29492 | 9 | ||
111673 | 222927 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 912 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5998760.52748 | 2106841.60616 | 37.764913845009 | -122.44750390358 | (37.764913845009, -122.44750390358) | 15 | 5 | 11 | 29492 | 9 | |||
66042 | 60257 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 911 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/10/1982 12:00:00 AM | Permit Number 19811 | 6009422.17813465 | 2103864.55146626 | 37.757343046708 | -122.410417577389 | (37.757343046708, -122.410417577389) | 2 | 4 | 7 | 28859 | 19 | ||
172639 | 56842 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 910 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/1992 12:00:00 AM | 3 | Permit Number 30536 | 5998759.08975741 | 2106864.1829233 | 37.7649757529568 | -122.447510501506 | (37.7649757529568, -122.447510501506) | 15 | 5 | 11 | 29492 | 9 | |
82304 | 225073 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 904 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009377.25257 | 2103854.78979 | 37.7573137247548 | -122.410572259011 | (37.7573137247548, -122.410572259011) | 2 | 4 | 7 | 28859 | 19 | |||
106329 | 142100 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 904 Fell St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6002972.7027 | 2110318.8393 | 37.7747012881718 | -122.433183544102 | (37.7747012881718, -122.433183544102) | 15 | 5 | 11 | 29492 | 10 | |||
29270 | 103687 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 903 SHOTWELL ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6008052 | 2102672 | 37.7539916655216 | -122.415071798268 | (37.7539916655216, -122.415071798268) | 2 | 4 | 7 | 28859 | 19 | |||
66742 | 225072 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 902 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6009377.02442 | 2103868.3997 | 37.7573510817046 | -122.410574009103 | (37.7573510817046, -122.410574009103) | 2 | 4 | 7 | 28859 | 19 | |||
184994 | 225046 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 901 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6009412.50008 | 2103884.66728 | 37.7573977376442 | -122.41045246843 | (37.7573977376442, -122.41045246843) | 2 | 4 | 7 | 28859 | 19 | |||
119539 | 60259 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 900 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1989 12:00:00 AM | Permit Number 28050 | 6009367.15001104 | 2103917.51160129 | 37.7574853782949 | -122.410611626923 | (37.7574853782949, -122.410611626923) | 2 | 4 | 7 | 28859 | 19 | ||
165457 | 225071 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 900 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009374.80383 | 2103883.56216 | 37.7573925899019 | -122.410582759505 | (37.7573925899019, -122.410582759505) | 2 | 4 | 7 | 28859 | 19 | |||
35456 | 225068 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 900 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6009114.1902 | 2103856.87983 | 37.7573047117606 | -122.411482183163 | (37.7573047117606, -122.411482183163) | 2 | 4 | 7 | 28859 | 19 | |||
159275 | 225067 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 900 Alabama St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6009115.2795 | 2103823.24781 | 37.7572124269416 | -122.411476039894 | (37.7572124269416, -122.411476039894) | 2 | 4 | 7 | 28859 | 19 | |||
62291 | 5529 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 895 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 4X4 | 6005093.86648 | 2103161.82188 | 37.7551699235695 | -122.425336590916 | (37.7551699235695, -122.425336590916) | 2 | 4 | 5 | 28859 | 19 | |||
164614 | 225069 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 892 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6009108.56559 | 2103972.85995 | 37.7576228514299 | -122.41150982923 | (37.7576228514299, -122.41150982923) | 2 | 4 | 7 | 28859 | 19 | |||
43272 | 105450 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 890 Alabama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009082.7 | 2103985.1 | 37.7576550089679 | -122.411600148106 | (37.7576550089679, -122.411600148106) | 2 | 4 | 7 | 28859 | 19 | |||||
56324 | 225070 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 890 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6009108.93583 | 2103990.98377 | 37.757672636103 | -122.411509829221 | (37.757672636103, -122.411509829221) | 2 | 4 | 7 | 28859 | 19 | |||
86582 | 105449 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 890 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009082.7 | 2103985.1 | 37.7576550089679 | -122.411600148106 | (37.7576550089679, -122.411600148106) | 2 | 4 | 7 | 28859 | 19 | |||||
64795 | 225045 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 881 Alabama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6009145.12233 | 2103987.25914 | 37.7576644387915 | -122.411384417877 | (37.7576644387915, -122.411384417877) | 2 | 4 | 7 | 28859 | 19 | |||
41601 | 222917 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 88 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6004303.69708 | 2109018.65394 | 37.7712067098536 | -122.428486670528 | (37.7712067098536, -122.428486670528) | 7 | 9 | 11 | 28852 | 10 | |||
145445 | 222923 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 88 Parnassus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5998162.74598 | 2106870.63901 | 37.7649593821837 | -122.449573561064 | (37.7649593821837, -122.449573561064) | 15 | 5 | 11 | 29492 | 9 | |||
68290 | 57557 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 88 LUNDYS LN | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1976 12:00:00 AM | 8 | 3x3 | Permit Number 16422 | 6006885 | 2099070 | 37.7440357411005 | -122.418852127392 | (37.7440357411005, -122.418852127392) | 2 | 7 | 7 | 28859 | 2 | |
149886 | 5523 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 865 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 6005084.41522 | 2103351.40166 | 37.7556899313628 | -122.425382766602 | (37.7556899313628, -122.425382766602) | 2 | 4 | 5 | 28859 | 19 | |||
72277 | 58315 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 86 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/08/1986 12:00:00 AM | Permit Number 23623 | 6006886.31504247 | 2099084.89744452 | 37.7440767201845 | -122.418848636603 | (37.7440767201845, -122.418848636603) | 2 | 7 | 7 | 28859 | 2 | ||
111400 | 248232 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 86 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6006910.04538 | 2099108.75258 | 37.7441435571799 | -122.418768273649 | (37.7441435571799, -122.418768273649) | 2 | 7 | 7 | 28859 | 2 | |||
63652 | 104633 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 850 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6009360 | 2104224 | 37.7583265252915 | -122.410657998143 | (37.7583265252915, -122.410657998143) | 2 | 4 | 7 | 28859 | 19 | |||
35932 | 222922 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 848 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5998725.13711 | 2107078.63003 | 37.7655626303238 | -122.44764337315 | (37.7655626303238, -122.44764337315) | 15 | 5 | 11 | 29492 | 9 | |||
164599 | 51670 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 848 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47948 | 5998713.82301338 | 2107188.47532501 | 37.765863591183 | -122.447690414133 | (37.765863591183, -122.447690414133) | 15 | 5 | 11 | 29492 | 9 | ||||
48763 | 225089 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 838 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6004316.16009 | 2104019.9015 | 37.7574820391842 | -122.428087274435 | (37.7574820391842, -122.428087274435) | 2 | 4 | 5 | 28862 | 3 | |||
71727 | 65411 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 81 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/1989 12:00:00 AM | Permit Number 28262 | 6004263.16526256 | 2108931.19399052 | 37.7709642723528 | -122.428620636268 | (37.7709642723528, -122.428620636268) | 7 | 9 | 11 | 29492 | 10 | |||
104673 | 222889 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 81 Webster St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 4ft | 6004268.74767 | 2108942.84192 | 37.7709965706599 | -122.428602156987 | (37.7709965706599, -122.428602156987) | 7 | 9 | 11 | 29492 | 10 | |||
180926 | 63125 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 80 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/09/1986 12:00:00 AM | Permit Number 23639 | 6007006.19001516 | 2099063.67894521 | 37.744025207978 | -122.418432630519 | (37.744025207978, -122.418432630519) | 2 | 7 | 7 | 28859 | 2 | ||
153227 | 248231 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 80 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006921.48329 | 2099128.86154 | 37.7441994158673 | -122.418730149576 | (37.7441994158673, -122.418730149576) | 2 | 7 | 7 | 28859 | 2 | |||
27880 | 438 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 792X Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 6 | 6004975.0011312 | 2103729.1085203 | 37.7567208435744 | -122.425788038834 | (37.7567208435744, -122.425788038834) | 2 | 4 | 5 | 28862 | 3 | |||
15625 | 27616 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 775 McAllister St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4x4 | 6005483.48508 | 2112000.60744 | 37.7794611228941 | -122.424617889559 | (37.7794611228941, -122.424617889559) | 7 | 9 | 11 | 28852 | 41 | |||
25251 | 14688 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 775 McAllister St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 26 | 4x4 | 6005346.74925 | 2111820.94662 | 37.7789600951073 | -122.425078130411 | (37.7789600951073, -122.425078130411) | 7 | 9 | 11 | 28852 | 41 | |||
36977 | 14687 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 775 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4x4 | 6005346.74925 | 2111820.94662 | 37.7789600951073 | -122.425078130411 | (37.7789600951073, -122.425078130411) | 7 | 9 | 11 | 28852 | 41 | |||
55304 | 14686 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 775 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 4X4 | 6005447.7824 | 2111997.5051 | 37.7794505882327 | -122.424741179621 | (37.7794505882327, -122.424741179621) | 7 | 9 | 11 | 28852 | 41 | |||
24753 | 140022 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 775 MCALLISTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6005467.685 | 2112000.1843 | 37.7794590687234 | -122.424672518677 | (37.7794590687234, -122.424672518677) | 7 | 9 | 11 | 28852 | 41 | |||
77005 | 140023 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 775 MCALLISTER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6005484.9085 | 2112001.3325 | 37.7794631941198 | -122.424613016933 | (37.7794631941198, -122.424613016933) | 7 | 9 | 11 | 28852 | 41 | |||
41267 | 63222 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 76 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1987 12:00:00 AM | Permit Number 23766 | 6007018.22684623 | 2099086.03719365 | 37.7440872763149 | -122.418392594768 | (37.7440872763149, -122.418392594768) | 2 | 7 | 7 | 28859 | 2 | ||
76472 | 225100 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 75 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 5ft | 6006056.75092 | 2109200.3154 | 37.7718045566698 | -122.422435689168 | (37.7718045566698, -122.422435689168) | 8 | 2 | 9 | 28853 | 19 | |||
107019 | 225101 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 75 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 5ft | 6006050.3801 | 2109334.27291 | 37.7721720124675 | -122.422467246366 | (37.7721720124675, -122.422467246366) | 8 | 2 | 9 | 28853 | 19 | |||
37593 | 63223 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 74 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/08/1986 12:00:00 AM | Permit Number 23767 | 6007024.24525419 | 2099097.21630379 | 37.7441183104389 | -122.418372576893 | (37.7441183104389, -122.418372576893) | 2 | 7 | 7 | 28859 | 2 | ||
136796 | 248230 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 74 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006935.57349 | 2099151.82262 | 37.7442632551522 | -122.418683056597 | (37.7442632551522, -122.418683056597) | 2 | 7 | 7 | 28859 | 2 | |||
44357 | 248229 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 72 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006943.33301 | 2099166.51729 | 37.7443040402894 | -122.418657267644 | (37.7443040402894, -122.418657267644) | 2 | 7 | 7 | 28859 | 2 | |||
52185 | 63117 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 72 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/08/1986 12:00:00 AM | Permit Number 23624 | 6006928.92708318 | 2099162.96302102 | 37.7442934699851 | -122.418706828381 | (37.7442934699851, -122.418706828381) | 2 | 7 | 7 | 28859 | 2 | ||
159417 | 57469 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 71 Cerritos Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/08/1987 12:00:00 AM | Permit Number 24965 | 5992451.26080169 | 2092911.00734917 | 37.7263014049972 | -122.468312338233 | (37.7263014049972, -122.468312338233) | 9 | 8 | 4 | 59 | 40 | ||
120856 | 63118 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 70 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/08/1986 12:00:00 AM | Permit Number 23625 | 6006935.01451866 | 2099174.11524824 | 37.7443244342333 | -122.418686569992 | (37.7443244342333, -122.418686569992) | 2 | 7 | 7 | 28859 | 2 | ||
149944 | 248228 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 70 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006955.04848 | 2099184.3603 | 37.744353692776 | -122.418618023005 | (37.744353692776, -122.418618023005) | 2 | 7 | 7 | 28859 | 2 | |||
110855 | 114592 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 70 LOMITA AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5991433 | 2104626 | 37.7584089066312 | -122.472686161822 | (37.7584089066312, -122.472686161822) | 1 | 8 | 4 | 56 | 12 | |||
131158 | 5479 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 695 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 8 | 6005031.79334 | 2104320.15384 | 37.758346924379 | -122.425633695438 | (37.758346924379, -122.425633695438) | 2 | 4 | 5 | 28859 | 19 | |||
89492 | 63739 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 665 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/1988 12:00:00 AM | Permit Number 24410 | 6003393.73641512 | 2109629.91106527 | 37.7728335359212 | -122.431677907074 | (37.7728335359212, -122.431677907074) | 15 | 9 | 11 | 29492 | 10 | ||
176339 | 244469 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 665 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003415.8306 | 2109638.093 | 37.7728572538387 | -122.431602065027 | (37.7728572538387, -122.431602065027) | 15 | 9 | 11 | 29492 | 10 | |||
113085 | 58721 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 66 Carmelita St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/1981 12:00:00 AM | Permit Number 19065 | 6002629.53182761 | 2108749.25499909 | 37.7703721248343 | -122.434258404788 | (37.7703721248343, -122.434258404788) | 15 | 5 | 5 | 29492 | 9 | |||
124058 | 225092 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 66 Carmelita St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6002638.75231 | 2108633.09345 | 37.7700536971488 | -122.434218205527 | (37.7700536971488, -122.434218205527) | 15 | 5 | 5 | 29492 | 9 | |||
154326 | 175840 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 658 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6002330.91523 | 2089965.9471 | 37.7187806097236 | -122.433948484453 | (37.7187806097236, -122.433948484453) | 9 | 7 | 6 | 28861 | 5 | |||
35427 | 35826 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 658 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/2003 12:00:00 AM | Permit Number 47147 | 6002331.25520589 | 2089974.9119099 | 37.7188052443929 | -122.433947949751 | (37.7188052443929, -122.433947949751) | 9 | 7 | 6 | 28861 | 5 | ||
129067 | 51546 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 655 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/01/2005 12:00:00 AM | Permit Number 47845 | 6007074.31830792 | 2121880.33708987 | 37.8066781199827 | -122.419815746942 | (37.8066781199827, -122.419815746942) | 5 | 1 | 1 | 28858 | 32 | |||
139674 | 101042 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 655 Beach St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47845 | 6006837 | 2121873 | 37.8066446021589 | -122.420636512845 | (37.8066446021589, -122.420636512845) | 5 | 1 | 1 | 28858 | 32 | ||||
145716 | 101044 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 655 Beach St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47845 | 6006837 | 2121873 | 37.8066446021589 | -122.420636512845 | (37.8066446021589, -122.420636512845) | 5 | 1 | 1 | 28858 | 32 | ||||
156506 | 101043 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 655 Beach St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47845 | 6006837 | 2121873 | 37.8066446021589 | -122.420636512845 | (37.8066446021589, -122.420636512845) | 5 | 1 | 1 | 28858 | 32 | ||||
161042 | 101045 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 655 Beach St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47845 | 6006837 | 2121873 | 37.8066446021589 | -122.420636512845 | (37.8066446021589, -122.420636512845) | 5 | 1 | 1 | 28858 | 32 | ||||
145696 | 206010 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 650 Vicente St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5990906.39798 | 2097737.17838 | 37.7394635005399 | -122.474004761412 | (37.7394635005399, -122.474004761412) | 1 | 8 | 4 | 29491 | 40 | |||
164831 | 206009 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 650 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5990946.44352 | 2097737.21302 | 37.7394659152092 | -122.47386630538 | (37.7394659152092, -122.47386630538) | 1 | 8 | 4 | 29491 | 40 | |||
176911 | 206011 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 650 Vicente St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5990881.65673 | 2097736.82059 | 37.7394610849722 | -122.474090278863 | (37.7394610849722, -122.474090278863) | 1 | 8 | 4 | 29491 | 40 | |||
182568 | 206012 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 650 Vicente St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5990870.16608 | 2097736.47672 | 37.7394594751618 | -122.474129983014 | (37.7394594751618, -122.474129983014) | 1 | 8 | 4 | 29491 | 40 | |||
108284 | 225093 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 635 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002682.06353 | 2108837.51126 | 37.770617436283 | -122.434083007749 | (37.770617436283, -122.434083007749) | 15 | 5 | 5 | 29492 | 9 | |||
49612 | 125976 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 633 Beach St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007074.37921 | 2121877.42075 | 37.8066701158897 | -122.419815329109 | (37.8066701158897, -122.419815329109) | 5 | 1 | 1 | 28858 | 32 | |||
77396 | 125972 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 633 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6006913.21617 | 2121857.59743 | 37.8066066057793 | -122.420371657826 | (37.8066066057793, -122.420371657826) | 5 | 1 | 1 | 28858 | 32 | |||
84314 | 125975 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 633 Beach St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007035.47478 | 2121873.14157 | 37.8066561746197 | -122.419949661756 | (37.8066561746197, -122.419949661756) | 5 | 1 | 1 | 28858 | 32 | |||
146048 | 125974 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 633 Beach St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6007013.05823 | 2121870.81717 | 37.8066485294743 | -122.420027073604 | (37.8066485294743, -122.420027073604) | 5 | 1 | 1 | 28858 | 32 | |||
167066 | 125973 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 633 Beach St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6006932.43872 | 2121860.17562 | 37.8066147680158 | -122.420305317544 | (37.8066147680158, -122.420305317544) | 5 | 1 | 1 | 28858 | 32 | |||
22540 | 225094 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 621 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/09/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780775 | 6002723.2165 | 2108842.98565 | 37.7706348030957 | -122.433941050651 | (37.7706348030957, -122.433941050651) | 15 | 5 | 5 | 29492 | 9 | |
169246 | 14640 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 600X McAllister St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6006169.26455 | 2112150.7692 | 37.779912136471 | -122.422256155719 | (37.779912136471, -122.422256155719) | 7 | 9 | 11 | 28852 | 41 | |||
21860 | 206006 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 600 Vicente St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5991049.3393 | 2097743.54574 | 37.7394892625221 | -122.473511002145 | (37.7394892625221, -122.473511002145) | 1 | 8 | 4 | 29491 | 40 | |||
33818 | 206007 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 600 Vicente St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5991032.21326 | 2097741.26802 | 37.7394820166929 | -122.473570049822 | (37.7394820166929, -122.473570049822) | 1 | 8 | 4 | 29491 | 40 | |||
50124 | 206005 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 600 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5991064.94409 | 2097743.51009 | 37.7394900683054 | -122.47345704553 | (37.7394900683054, -122.47345704553) | 1 | 8 | 4 | 29491 | 40 | |||
170609 | 206008 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 600 Vicente St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5990990.06403 | 2097739.22497 | 37.7394739659536 | -122.473715632987 | (37.7394739659536, -122.473715632987) | 1 | 8 | 4 | 29491 | 40 |
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) );