trees
668 rows where qLegalStatus_id = 1 and qSpecies_id = 5 sorted by SiteOrder
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
62764 | 16626 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 138 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/02/2001 12:00:00 AM | 21 | 3X3 | 6002836.08721 | 2107485.6498 | 37.7669142960875 | -122.43345361721 | (37.7669142960875, -122.43345361721) | 15 | 5 | 5 | 28862 | 3 | ||
62825 | 246517 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 41 Waller St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6005417.73549 | 2109222.56247 | 37.7718295731126 | -122.424647671566 | (37.7718295731126, -122.424647671566) | 7 | 9 | 5 | 28852 | 10 | |||
62929 | 57320 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2728 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/31/1976 12:00:00 AM | 15 | Permit Number 16145 | 5999531.6355 | 2114001.5838 | 37.7846173544843 | -122.445351698652 | (37.7846173544843, -122.445351698652) | 15 | 6 | 1 | 29490 | 31 | ||
63208 | 206021 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 42 Stanford Heights Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5997867.55836 | 2095818.65061 | 37.7345964514605 | -122.449798003996 | (37.7345964514605, -122.449798003996) | 9 | 7 | 4 | 59 | 40 | |||
63547 | 57317 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2706 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/31/1976 12:00:00 AM | 13 | Permit Number 16141 | 5999606.4685 | 2114016.4513 | 37.7846624482509 | -122.445093871748 | (37.7846624482509, -122.445093871748) | 15 | 6 | 1 | 29490 | 31 | ||
63557 | 17398 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1734X Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6014174.38954 | 2095813.0161 | 37.7355004859498 | -122.393418978825 | (37.7355004859498, -122.393418978825) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
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 | |||
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 | |||
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 | |||
66656 | 16644 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 170 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6002849.24717 | 2107272.65524 | 37.7663302115978 | -122.433392876987 | (37.7663302115978, -122.433392876987) | 15 | 5 | 5 | 28862 | 3 | |||
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 | |||
66893 | 199696 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1337 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6016147.0349 | 2092868.9416 | 37.7275260488519 | -122.386393532075 | (37.7275260488519, -122.386393532075) | 10 | 3 | 8 | 58 | 1 | |||
67228 | 206013 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 130 San Benito Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5992845.13508 | 2095810.81929 | 37.7342863121439 | -122.467161490835 | (37.7342863121439, -122.467161490835) | 9 | 8 | 4 | 59 | 40 | |||
67860 | 57316 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1515 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/31/1976 12:00:00 AM | 13 | Permit Number 16140 | 5999629.2653 | 2114178.0114 | 37.7851073514303 | -122.445026621162 | (37.7851073514303, -122.445026621162) | 15 | 6 | 1 | 29490 | 31 | ||
69631 | 189954 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 145 Main St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6014570.20304 | 2115942.2831 | 37.7907930492013 | -122.393458763924 | (37.7907930492013, -122.393458763924) | 12 | 2 | 9 | 28855 | 6 | |||
70301 | 2533 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1575 Burke Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016180.33193 | 2099126.30756 | 37.7447093575531 | -122.386714591425 | (37.7447093575531, -122.386714591425) | 10 | 3 | 8 | 58 | 1 | |||
71054 | 21785 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2585 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6008161.90241 | 2121549.79462 | 37.8058317424248 | -122.41602851934 | (37.8058317424248, -122.41602851934) | 5 | 1 | 10 | 308 | 23 | |||
71557 | 125966 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2198 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6002473.45784 | 2118854.30827 | 37.7981091788388 | -122.435521270088 | (37.7981091788388, -122.435521270088) | 13 | 9 | 1 | 57 | 17 | |||
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 | |||
72504 | 225095 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 231 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004583.37564 | 2109107.4182 | 37.7714662577942 | -122.427525575841 | (37.7714662577942, -122.427525575841) | 7 | 9 | 11 | 28852 | 10 | |||
73221 | 189956 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 572 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6011467.9689 | 2109652.48068 | 37.7733498689462 | -122.403749639528 | (37.7733498689462, -122.403749639528) | 14 | 2 | 9 | 28853 | 34 | |||
74084 | 124322 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 115 Jordan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5996192.87314 | 2113669.73604 | 37.7835150337529 | -122.456878613619 | (37.7835150337529, -122.456878613619) | 11 | 6 | 1 | 54 | 31 | |||
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 | |||
75171 | 206004 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 10 Lomita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991469.80126 | 2104851.05791 | 37.7590289864229 | -122.472575296214 | (37.7590289864229, -122.472575296214) | 1 | 8 | 4 | 56 | 12 | |||
75395 | 125996 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2510 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6007913.10752 | 2121457.27998 | 37.8055637294392 | -122.41688295558 | (37.8055637294392, -122.41688295558) | 5 | 1 | 10 | 308 | 23 | |||
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 | |||
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 | |||
78514 | 222913 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 112 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004271.62218 | 2109232.31503 | 37.771791556066 | -122.428612851729 | (37.771791556066, -122.428612851729) | 7 | 9 | 11 | 28852 | 10 | |||
80491 | 17417 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1836 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6013526.86611 | 2096296.97727 | 37.7367933450374 | -122.395691626761 | (37.7367933450374, -122.395691626761) | 10 | 3 | 8 | 58 | 1 | |||
80577 | 189839 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 101 Newhall St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6017074.26086 | 2098217.41845 | 37.7422631836031 | -122.383560265197 | (37.7422631836031, -122.383560265197) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
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 | |||
85699 | 11179 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2750X Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 3x3 | 6006893.59102 | 2121789.4662 | 37.8064184289444 | -122.4204347354 | (37.8064184289444, -122.4204347354) | 5 | 1 | 1 | 28858 | 32 | |||
86068 | 188467 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 255 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 6008105.35323 | 2108904.54782 | 37.77110780062 | -122.415328472924 | (37.77110780062, -122.415328472924) | 8 | 2 | 9 | 28853 | 19 | |||
88181 | 85254 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 45 Fremont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Permit Number 49553 | 6013520.55509 | 2116003.76772 | 37.7909034958536 | -122.397094833572 | (37.7909034958536, -122.397094833572) | 12 | 2 | 9 | 28855 | 6 | |||
93710 | 40183 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 298X Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/1999 12:00:00 AM | 11 | Permit Number 41371 | 6013446.24914 | 2105734.66956 | 37.7627027466551 | -122.39663174926 | (37.7627027466551, -122.39663174926) | 14 | 3 | 8 | 28856 | 29 | ||
93841 | 17432 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1899 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6013304.38665 | 2096386.76437 | 37.7370275033033 | -122.396467132869 | (37.7370275033033, -122.396467132869) | 10 | 3 | 8 | 58 | 1 | |||
95691 | 225059 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 245 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 5997024.32382 | 2107012.23049 | 37.7652829636624 | -122.453521279988 | (37.7652829636624, -122.453521279988) | 15 | 5 | 11 | 29492 | 12 | |||
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 | |||
99086 | 7417 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1090 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/23/2003 12:00:00 AM | 6 | 3X3 | 6010360.059 | 2111002.9309 | 37.7769959373466 | -122.407677309481 | (37.7769959373466, -122.407677309481) | 14 | 2 | 9 | 28853 | 34 | ||
99094 | 21776 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2500X Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6008409.45282 | 2121407.87429 | 37.8054559800011 | -122.415161778523 | (37.8054559800011, -122.415161778523) | 5 | 1 | 10 | 308 | 23 | |||
99121 | 125970 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2301 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6003734.22562 | 2115934.13704 | 37.7901626613254 | -122.430950126753 | (37.7901626613254, -122.430950126753) | 13 | 9 | 1 | 29490 | 27 | |||
100997 | 173732 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1690x Galvez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015419 | 2098106 | 37.7418656239974 | -122.389275919147 | (37.7418656239974, -122.389275919147) | 10 | 3 | 8 | 58 | 1 | ||||
102986 | 17458 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1999 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 55 | 3x3 | 6012778.88075 | 2096779.84322 | 37.7380775571329 | -122.398311626199 | (37.7380775571329, -122.398311626199) | 10 | 3 | 8 | 58 | 1 | |||
103062 | 107151 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 215 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4x4 | 6013483.16907 | 2106058.28155 | 37.7635933686511 | -122.396526740817 | (37.7635933686511, -122.396526740817) | 14 | 3 | 8 | 28856 | 29 | |||
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 | |||
104983 | 244452 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 411 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6003668.1352 | 2109738.0991 | 37.7731461435953 | -122.430736452264 | (37.7731461435953, -122.430736452264) | 15 | 9 | 11 | 29492 | 10 | |||
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 | |||
105990 | 18859 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2212 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/13/1992 12:00:00 AM | 12 | 3X3 | 6004082.46062 | 2116030.31556 | 37.7904464684691 | -122.429752123658 | (37.7904464684691, -122.429752123658) | 13 | 9 | 1 | 29490 | 27 | ||
107061 | 47237 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1200X Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 9 | 3x3 | Permit Number 45189 | 6014656.8506 | 2090563.7281 | 37.721113790544 | -122.391384069594 | (37.721113790544, -122.391384069594) | 10 | 3 | 8 | 58 | 1 |
107783 | 17444 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1950 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3X3 | 6013023.36347 | 2096670.73663 | 37.7377915889102 | -122.397458672302 | (37.7377915889102, -122.397458672302) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
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 | |||
110010 | 222924 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1025 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5998822.08068 | 2106365.67219 | 37.763610567293 | -122.447256751019 | (37.763610567293, -122.447256751019) | 15 | 5 | 11 | 29492 | 9 | |||
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 | ||
111120 | 225061 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1289 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 5997502.5049 | 2105021.09629 | 37.7598432128005 | -122.451723726786 | (37.7598432128005, -122.451723726786) | 15 | 5 | 11 | 29492 | 12 | |||
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 | |||
111186 | 189933 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 28 Fremont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6013208.14765 | 2116234.45684 | 37.7915195179644 | -122.398191948892 | (37.7915195179644, -122.398191948892) | 12 | 2 | 9 | 28855 | 6 | |||
111387 | 222904 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 363 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6004715.38798 | 2109818.79814 | 37.7734270001802 | -122.427119616485 | (37.7734270001802, -122.427119616485) | 7 | 9 | 11 | 28852 | 10 | |||
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 | |||
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 | |||
113408 | 139006 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1504 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5999695.1779 | 2114053.1244 | 37.7847682058679 | -122.444789604899 | (37.7847682058679, -122.444789604899) | 15 | 6 | 1 | 29490 | 31 | |||
113575 | 17433 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1900 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6013265.7394 | 2096489.52235 | 37.7373075045406 | -122.396607955902 | (37.7373075045406, -122.396607955902) | 10 | 3 | 8 | 58 | 1 | |||
114437 | 206015 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 351 Montecito Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | Width 3ft | 5995922.8819 | 2094068.30815 | 37.7296789783055 | -122.456394837862 | (37.7296789783055, -122.456394837862) | 9 | 7 | 4 | 28861 | 40 | |||
114865 | 201371 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1 Hare St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 6018297.03999 | 2095334.93444 | 37.7344159629251 | -122.379132069983 | (37.7344159629251, -122.379132069983) | 10 | 3 | 8 | 58 | 1 | ||||
115285 | 222894 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 3080 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/1989 12:00:00 AM | 14 | Width 3ft | Permit Number 27054 | 6006296.82054 | 2106727.45524 | 37.765028210007 | -122.421429624803 | (37.765028210007, -122.421429624803) | 8 | 4 | 7 | 28853 | 19 | |
115453 | 222918 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 140 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5997702.83236 | 2107152.93734 | 37.7657081802151 | -122.451184638974 | (37.7657081802151, -122.451184638974) | 15 | 5 | 11 | 29492 | 9 | |||
117059 | 222915 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 100 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6004287.81752 | 2109130.32918 | 37.7715124442731 | -122.42854956012 | (37.7715124442731, -122.42854956012) | 7 | 9 | 11 | 28852 | 10 | |||
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 | |||
117722 | 2513 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1555 Burke Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016387.51247 | 2098972.29453 | 37.7442979375022 | -122.385987460765 | (37.7442979375022, -122.385987460765) | 10 | 3 | 8 | 58 | 1 | |||
118207 | 225062 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 139 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5998883.5307 | 2107364.06639 | 37.7663554177878 | -122.447116070946 | (37.7663554177878, -122.447116070946) | 15 | 5 | 11 | 29492 | 9 | |||
118594 | 199693 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1341 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6016099.111 | 2092907.501 | 37.7276292724139 | -122.386561894416 | (37.7276292724139, -122.386561894416) | 10 | 3 | 8 | 58 | 1 | |||
119313 | 65609 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 259 Maynard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1990 12:00:00 AM | 12 | Permit Number 28514 | 6005079.93888 | 2093817.02687 | 37.7295104552453 | -122.424720013038 | (37.7295104552453, -122.424720013038) | 9 | 7 | 6 | 28861 | 5 | |
120839 | 206020 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 146 Castenada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994480.54768 | 2101060.81011 | 37.7487957447457 | -122.461887948175 | (37.7487957447457, -122.461887948175) | 1 | 8 | 4 | 29491 | 40 | |||
121999 | 18922 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2620 SACRAMENTO ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6002038.8 | 2115762.8 | 37.7895960030005 | -122.436803887406 | (37.7895960030005, -122.436803887406) | 13 | 6 | 1 | 29490 | 27 | |||
122285 | 107150 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 219 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 5x5 | 6013483.53646 | 2106027.96623 | 37.7635101499066 | -122.396523344982 | (37.7635101499066, -122.396523344982) | 14 | 3 | 8 | 28856 | 29 | |||
122504 | 18864 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2230 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6003886.2489 | 2116004.41909 | 37.7903642506674 | -122.430429154879 | (37.7903642506674, -122.430429154879) | 13 | 9 | 1 | 29490 | 27 | |||
123100 | 56925 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 120 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1974 12:00:00 AM | 12 | Permit Number 14168 | 6014784.53223 | 2116103.90747 | 37.7912487383869 | -122.392728500917 | (37.7912487383869, -122.392728500917) | 12 | 2 | 9 | 28855 | 6 | ||
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 | |||
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 | |||
129074 | 189916 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1771 Palou Ave | 1 | : | Tree | Private 2 | 15 | Width 4ft | 6013954.80906 | 2095907.81376 | 37.7357485783226 | -122.394184791988 | (37.7357485783226, -122.394184791988) | 10 | 3 | 8 | 58 | 1 | |||
129163 | 205988 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1469 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5993333.43827 | 2105504.18267 | 37.7609299931406 | -122.466177475131 | (37.7609299931406, -122.466177475131) | 1 | 8 | 4 | 56 | 12 | |||
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 | |||
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 | |||
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 | |||
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 | |||
132763 | 17464 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2043 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6012526.80505 | 2096970.93797 | 37.7385882182703 | -122.399196593253 | (37.7385882182703, -122.399196593253) | 10 | 3 | 8 | 58 | 1 | |||
133710 | 222919 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 121 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5997880.24105 | 2107132.61559 | 37.7656625378249 | -122.450569558437 | (37.7656625378249, -122.450569558437) | 15 | 5 | 11 | 29492 | 9 | |||
134432 | 32473 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 144 Lower Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/10/1996 12:00:00 AM | 9 | Permit Number 36981 | 6000263.91054 | 2106227.11632 | 37.7633124078752 | -122.442259981907 | (37.7633124078752, -122.442259981907) | 15 | 5 | 5 | 28862 | 3 | |
135227 | 21781 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2550X Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/12/2011 12:00:00 AM | 3 | 4x4 | 6008458.56586 | 2121488.77145 | 37.8056808631332 | -122.41499754514 | (37.8056808631332, -122.41499754514) | 3 | 1 | 10 | 308 | 23 | ||
136362 | 189853 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 102 Newhall St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6017352.03209 | 2098141.27696 | 37.7420694633311 | -122.382594511142 | (37.7420694633311, -122.382594511142) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
137377 | 225077 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2862 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 3ft | 6009020.65891 | 2103938.13075 | 37.7575225617285 | -122.411811393486 | (37.7575225617285, -122.411811393486) | 2 | 4 | 7 | 28859 | 19 | |||
138379 | 222901 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2500 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6010350.92768 | 2105070.60578 | 37.7607066222297 | -122.407290598708 | (37.7607066222297, -122.407290598708) | 10 | 4 | 8 | 28859 | 19 |
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) );