trees
154 rows where Fire Prevention Districts = 2 and qSpecies_id = 5
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4441 | 246422 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 400 Duncan St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 6003829.35465 | 2099854.81871 | 37.7460181445246 | -122.429473817668 | (37.7460181445246, -122.429473817668) | 2 | 7 | 5 | 63 | 22 | |||
8477 | 224897 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 600 Eugenia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007276.43224 | 2097752.07019 | 37.7404390320343 | -122.417405258456 | (37.7404390320343, -122.417405258456) | 2 | 7 | 7 | 28859 | 2 | |||
9140 | 48531 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 500(REVISED) Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2002 12:00:00 AM | Permit Number 45857 | 6007225.9541014 | 2104383.62172477 | 37.7586449307205 | -122.41804980128 | (37.7586449307205, -122.41804980128) | 2 | 4 | 7 | 28859 | 19 | |||
9983 | 248199 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 55 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006933.20129 | 2099091.48631 | 37.7440974516285 | -122.41868698122 | (37.7440974516285, -122.41868698122) | 2 | 7 | 7 | 28859 | 2 | |||
12569 | 111886 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 140 LUNDYS LN | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x12 | 6006709 | 2098750 | 37.7431471814186 | -122.41943799965 | (37.7431471814186, -122.41943799965) | 2 | 7 | 7 | 28859 | 2 | |||
20489 | 225066 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 199 Franconia St | 13 | : Yard | Tree | Private 2 | 5 | Width 3ft | 6010116.17854 | 2099660.00965 | 37.7458371865343 | -122.407720980957 | (37.7458371865343, -122.407720980957) | 2 | 7 | 7 | 28859 | 2 | |||
20598 | 60264 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 2804 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/15/1984 12:00:00 AM | Permit Number 19820 | 6009362.55423892 | 2103960.83669592 | 37.7576040815568 | -122.410630580485 | (37.7576040815568, -122.410630580485) | 2 | 4 | 7 | 28859 | 19 | ||
21283 | 225084 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 3784 22nd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003185.26448 | 2103031.00379 | 37.7547027131682 | -122.431927750974 | (37.7547027131682, -122.431927750974) | 2 | 4 | 5 | 28862 | 22 | |||
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 | |||
24468 | 57556 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 57 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/08/1986 12:00:00 AM | Permit Number 23627 | 6007019.50965831 | 2099220.3784742 | 37.7444562195491 | -122.418397682663 | (37.7444562195491, -122.418397682663) | 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 | |||
28248 | 248203 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 47 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006976.18023 | 2099171.17204 | 37.7443186704674 | -122.418544018687 | (37.7443186704674, -122.418544018687) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
29632 | 102874 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 2761 21st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6009574.6 | 2103896.5 | 37.7574393136514 | -122.409892695521 | (37.7574393136514, -122.409892695521) | 2 | 4 | 7 | 28859 | 19 | ||||
30477 | 222899 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 3737 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 6ft | 6005393.47694 | 2104277.70893 | 37.7582508111316 | -122.424379813902 | (37.7582508111316, -122.424379813902) | 2 | 4 | 5 | 28859 | 19 | |||
31579 | 225050 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 500x 27th St | 24 | Median : Cutout | Tree | DPW 1 | 11 | Width 4ft | 6002949.31338 | 2100070.05084 | 37.7465592558077 | -122.432532251866 | (37.7465592558077, -122.432532251866) | 2 | 7 | 5 | 63 | 22 | |||
32130 | 5658 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1349-1349 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 3X3 | 6005239.88286 | 2100530.07402 | 37.7479520016853 | -122.42464442051 | (37.7479520016853, -122.42464442051) | 2 | 4 | 5 | 28859 | 19 | |||
32244 | 111887 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 140 LUNDYS LN | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x12 | 6006709 | 2098750 | 37.7431471814186 | -122.41943799965 | (37.7431471814186, -122.41943799965) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
33302 | 60693 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 2762 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/05/1983 12:00:00 AM | Permit Number 20336 | 6009623.17116786 | 2103391.2059206 | 37.7560546117591 | -122.409689051741 | (37.7560546117591, -122.409689051741) | 2 | 4 | 7 | 28859 | 19 | ||
34635 | 225051 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 4331 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6000881.81518 | 2102275.99981 | 37.7524988021808 | -122.439839555559 | (37.7524988021808, -122.439839555559) | 2 | 4 | 5 | 28862 | 22 | |||
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 | |||
35579 | 63232 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 53 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/13/1987 12:00:00 AM | Permit Number 23779 | 6007031.32644483 | 2099242.02691528 | 37.7445163265111 | -122.418358357204 | (37.7445163265111, -122.418358357204) | 2 | 7 | 7 | 28859 | 2 | ||
36033 | 37053 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 231 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/2015 12:00:00 AM | 3 | 6x9 | Permit Number 775674 | 6005030.06979159 | 2099868.96006137 | 37.7461248828886 | -122.425322907066 | (37.7461248828886, -122.425322907066) | 2 | 7 | 5 | 63 | 22 |
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 | ||
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 | ||
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 | |||||
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 | |||
45877 | 248276 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 137 Lundy's Ln | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006755.61156 | 2098766.6947 | 37.7431956465585 | -122.419278012984 | (37.7431956465585, -122.419278012984) | 2 | 7 | 7 | 28859 | 2 | |||
47785 | 63130 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 26 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/11/1986 12:00:00 AM | Permit Number 23644 | 6007187.15982152 | 2099399.82780325 | 37.7449583833589 | -122.417830699083 | (37.7449583833589, -122.417830699083) | 2 | 7 | 7 | 28859 | 2 | ||
48025 | 248201 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 53 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006949.2101 | 2099121.02775 | 37.7441794671077 | -122.418633720666 | (37.7441794671077, -122.418633720666) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
50898 | 49041 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 406 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2003 12:00:00 AM | Permit Number 46216 | 6004132.32350443 | 2101573.22879489 | 37.7507536483556 | -122.428548658976 | (37.7507536483556, -122.428548658976) | 2 | 4 | 5 | 28862 | 22 | ||
51291 | 225053 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 300 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6001218.80684 | 2096592.16387 | 37.7369115105593 | -122.438267032523 | (37.7369115105593, -122.438267032523) | 2 | 7 | 5 | 63 | 7 | |||
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 | ||
53125 | 248260 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 132 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6006738.11061 | 2098784.48151 | 37.7432434994904 | -122.419339788302 | (37.7432434994904, -122.419339788302) | 2 | 7 | 7 | 28859 | 2 | |||
53701 | 51842 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 34 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/09/1986 12:00:00 AM | Permit Number 48069 | 6007044.58832094 | 2099374.8552715 | 37.7448817898933 | -122.418321916232 | (37.7448817898933, -122.418321916232) | 2 | 7 | 7 | 28859 | 2 | ||
54428 | 50386 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 296 Liberty St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2003 12:00:00 AM | Permit Number 47041 | 6004379.7762802 | 2103977.8532584 | 37.7573701836913 | -122.427864268021 | (37.7573701836913, -122.427864268021) | 2 | 4 | 5 | 28862 | 3 | |||
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 | |||
59723 | 248262 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 136 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6006723.28629 | 2098755.01317 | 37.743161751109 | -122.41938895693 | (37.743161751109, -122.41938895693) | 2 | 7 | 7 | 28859 | 2 | |||
60894 | 246420 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 400 Duncan St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 6003851.19686 | 2099854.61267 | 37.7460188154337 | -122.429398275524 | (37.7460188154337, -122.429398275524) | 2 | 7 | 5 | 63 | 22 | |||
61480 | 246510 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 231 Duncan St | 1 | : | Tree | Private 2 | 1 | Width 5ft | 6004993.26159 | 2099869.66747 | 37.7461247456624 | -122.425450235552 | (37.7461247456624, -122.425450235552) | 2 | 7 | 5 | 63 | 22 | |||
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 | |||
62355 | 225056 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 354 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6001081.74278 | 2096696.02818 | 37.737188901045 | -122.438748363154 | (37.737188901045, -122.438748363154) | 2 | 7 | 5 | 63 | 7 | |||
63609 | 222900 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 3733 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6005413.47026 | 2104278.82733 | 37.7582550109751 | -122.424310747749 | (37.7582550109751, -122.424310747749) | 2 | 4 | 5 | 28859 | 19 | |||
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 | |||
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 | |||
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 | |||
64807 | 248261 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 136 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006731.57977 | 2098768.277 | 37.7431986377163 | -122.419361220966 | (37.7431986377163, -122.419361220966) | 2 | 7 | 7 | 28859 | 2 | |||
65527 | 248255 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 116 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006791.47872 | 2098879.96545 | 37.7435086825726 | -122.41916202653 | (37.7435086825726, -122.41916202653) | 2 | 7 | 7 | 28859 | 2 | |||
65585 | 248202 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 51 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006954.7875 | 2099136.48348 | 37.7442222190818 | -122.418615530989 | (37.7442222190818, -122.418615530989) | 2 | 7 | 7 | 28859 | 2 | |||
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 | ||
66277 | 222890 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2761 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6009529.18788 | 2103922.95806 | 37.757509416346 | -122.4100516172 | (37.757509416346, -122.4100516172) | 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 | |||
66852 | 222897 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2771 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009509.00989 | 2103333.02961 | 37.7558884746751 | -122.41007975427 | (37.7558884746751, -122.41007975427) | 2 | 4 | 7 | 28859 | 19 | |||
67810 | 41699 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 2 Mizpah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42149 | 6001021.55719924 | 2096664.38095079 | 37.7370985809646 | -122.438954184383 | (37.7370985809646, -122.438954184383) | 2 | 7 | 5 | 63 | 7 | ||
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 | |
69517 | 48533 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 500(REVISED) Capp St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2002 12:00:00 AM | Permit Number 45857 | 6007225.9541014 | 2104383.62172477 | 37.7586449307205 | -122.41804980128 | (37.7586449307205, -122.41804980128) | 2 | 4 | 7 | 28859 | 19 | |||
70907 | 102876 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 2761 21st St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009574.6 | 2103896.5 | 37.7574393136514 | -122.409892695521 | (37.7574393136514, -122.409892695521) | 2 | 4 | 7 | 28859 | 19 | ||||
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 | |||
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 | ||
74298 | 225086 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 3689 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003831.7176 | 2103603.4271 | 37.7563110786983 | -122.429732966312 | (37.7563110786983, -122.429732966312) | 2 | 4 | 5 | 28862 | 22 | |||
75130 | 248258 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 120 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6006769.18682 | 2098841.93634 | 37.7434030077589 | -122.419236409442 | (37.7434030077589, -122.419236409442) | 2 | 7 | 7 | 28859 | 2 | |||
77339 | 225088 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 3899 19th St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 6003725.04695 | 2104766.83601 | 37.7594994820291 | -122.430184865761 | (37.7594994820291, -122.430184865761) | 2 | 4 | 5 | 28862 | 3 | |||
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 | |||
82514 | 63116 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 115 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/08/1986 12:00:00 AM | Permit Number 23622 | 6006844.85682717 | 2098899.69149034 | 37.7435658517454 | -122.418978856767 | (37.7435658517454, -122.418978856767) | 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 | |||
84804 | 225044 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 15 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007468.43971 | 2099454.94472 | 37.7451255476034 | -122.4168619861 | (37.7451255476034, -122.4168619861) | 2 | 7 | 7 | 28859 | 2 | |||
85099 | 225087 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 3901 19th St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 6003680.66693 | 2104762.35118 | 37.7594846540097 | -122.430338033793 | (37.7594846540097, -122.430338033793) | 2 | 4 | 5 | 28862 | 3 | |||
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 | |||||
95517 | 52077 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 2959 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2005 12:00:00 AM | Permit Number 48273 | 6009147.75263717 | 2102727.30105861 | 37.7542050255745 | -122.411286316307 | (37.7542050255745, -122.411286316307) | 2 | 4 | 7 | 28859 | 19 | ||
95860 | 225078 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2844 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6009189.80262 | 2103948.11037 | 37.7575594510339 | -122.411227129126 | (37.7575594510339, -122.411227129126) | 2 | 4 | 7 | 28859 | 19 | |||
99119 | 50383 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 296 Liberty St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2003 12:00:00 AM | Permit Number 47041 | 6004379.7762802 | 2103977.8532584 | 37.7573701836913 | -122.427864268021 | (37.7573701836913, -122.427864268021) | 2 | 4 | 5 | 28862 | 3 | |||
99949 | 96852 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 1x Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6007194 | 2097789 | 37.7405357947447 | -122.417692894396 | (37.7405357947447, -122.417692894396) | 2 | 7 | 7 | 28859 | 2 | |||
101361 | 222898 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 2771 22nd St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 6ft | 6009527.7031 | 2103333.93064 | 37.7558919964247 | -122.410015170384 | (37.7558919964247, -122.410015170384) | 2 | 4 | 7 | 28859 | 19 | |||
103441 | 50384 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 296 Liberty St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2003 12:00:00 AM | Permit Number 47041 | 6004379.7762802 | 2103977.8532584 | 37.7573701836913 | -122.427864268021 | (37.7573701836913, -122.427864268021) | 2 | 4 | 5 | 28862 | 3 | |||
105802 | 248279 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 111 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006822.34586 | 2098891.67697 | 37.743542578041 | -122.419056125953 | (37.743542578041, -122.419056125953) | 2 | 7 | 7 | 28859 | 2 | |||
108761 | 225075 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 3334 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007507.05129 | 2101513.08881 | 37.750778919809 | -122.416874263658 | (37.750778919809, -122.416874263658) | 2 | 4 | 7 | 28859 | 19 | |||
110285 | 32421 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 400 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/1996 12:00:00 AM | 12 | Permit Number 36948 | 6000917.26502 | 2096711.23126 | 37.7372212865363 | -122.439318125938 | (37.7372212865363, -122.439318125938) | 2 | 7 | 5 | 63 | 7 | ||
110454 | 246421 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 400 Duncan St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 6003840.65408 | 2099855.19689 | 37.7460198226686 | -122.429434772709 | (37.7460198226686, -122.429434772709) | 2 | 7 | 5 | 63 | 22 | |||
111174 | 248263 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 140 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006717.3063 | 2098747.87418 | 37.7431418122345 | -122.419409127839 | (37.7431418122345, -122.419409127839) | 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 | |||
112219 | 60684 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 2969 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/05/1983 12:00:00 AM | Permit Number 20325 | 6009095.19054271 | 2102724.34950865 | 37.7541939732112 | -122.411467881257 | (37.7541939732112, -122.411467881257) | 2 | 4 | 7 | 28859 | 19 | ||
113265 | 59009 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 3737 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/1980 12:00:00 AM | 15 | 4x4 | Permit Number 18300 | 6005405.85335043 | 2104274.1193379 | 37.758241653827 | -122.424336755524 | (37.758241653827, -122.424336755524) | 2 | 4 | 5 | 28859 | 19 | |
114352 | 248264 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 140 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6006711.60121 | 2098736.37276 | 37.743109910586 | -122.419428038785 | (37.743109910586, -122.419428038785) | 2 | 7 | 7 | 28859 | 2 | |||
115384 | 225080 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2823 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009082.12028 | 2103902.99509 | 37.7574295349581 | -122.411596352099 | (37.7574295349581, -122.411596352099) | 2 | 4 | 7 | 28859 | 19 | |||
117653 | 205999 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 60 Chilton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6001682.52176 | 2095686.82759 | 37.7344520302196 | -122.436598984369 | (37.7344520302196, -122.436598984369) | 2 | 7 | 5 | 63 | 7 | |||
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 | |||||
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 | ||
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 | ||
123502 | 59722 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 2905 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/14/1984 12:00:00 AM | Permit Number 19154 | 6008831.83417105 | 2103879.56302809 | 37.757351153159 | -122.41246028798 | (37.757351153159, -122.41246028798) | 2 | 4 | 7 | 28859 | 19 | ||
124051 | 248207 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 39 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007026.81239 | 2099268.29908 | 37.7445882098712 | -122.418375828376 | (37.7445882098712, -122.418375828376) | 2 | 7 | 7 | 28859 | 2 | |||
124822 | 111888 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 140 LUNDYS LN | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x12 | 6006709 | 2098750 | 37.7431471814186 | -122.41943799965 | (37.7431471814186, -122.41943799965) | 2 | 7 | 7 | 28859 | 2 | ||||
127978 | 225055 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 348 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6001114.83392 | 2096694.1461 | 37.7371856158122 | -122.438633817409 | (37.7371856158122, -122.438633817409) | 2 | 7 | 5 | 63 | 7 | |||
130222 | 248198 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 57 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6006917.65895 | 2099068.87829 | 37.7440345000033 | -122.418739120308 | (37.7440345000033, -122.418739120308) | 2 | 7 | 7 | 28859 | 2 | |||
130611 | 50385 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 296 Liberty St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2003 12:00:00 AM | Permit Number 47041 | 6004379.7762802 | 2103977.8532584 | 37.7573701836913 | -122.427864268021 | (37.7573701836913, -122.427864268021) | 2 | 4 | 5 | 28862 | 3 | |||
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 | |||
131314 | 60288 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 2932 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1982 12:00:00 AM | Permit Number 19852 | 6009284.44431761 | 2102786.94037008 | 37.754376447105 | -122.410817812439 | (37.754376447105, -122.410817812439) | 2 | 4 | 7 | 28859 | 19 | ||
131488 | 225048 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2823 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009293.07164 | 2103911.54746 | 37.7574648486362 | -122.410867399417 | (37.7574648486362, -122.410867399417) | 2 | 4 | 7 | 28859 | 19 | |||
131544 | 59362 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 300 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/21/1980 12:00:00 AM | Permit Number 18713 | 6001270.92113106 | 2096540.31776103 | 37.7367721171555 | -122.4380831379 | (37.7367721171555, -122.4380831379) | 2 | 7 | 5 | 63 | 7 |
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) );