856 rows where qSpecies_id = 5 sorted by PlantDate descending

View and edit SQL

These facets timed out: Police Districts

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)
18873 61724 DPW Maintained 1 Ceratonia siliqua :: Carob 5 18 Ceres St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/17/1984 12:00:00 AM 8   Permit Number 21726 6013883.84127 2094072.5147 37.7307052783181 -122.394301699376 (37.7307052783181, -122.394301699376) 10 3 8 58 1
194344 124321 DPW Maintained 1 Ceratonia siliqua :: Carob 5 115 Jordan Ave 2 Sidewalk: Curb side : Yard Tree Private 2   12/16/2020 12:00:00 AM 3 Width 3ft   5996193.40211 2113658.22839 37.7834834671867 -122.456875951009 (37.7834834671867, -122.456875951009) 11 6 1 54 31
64750 21777 Permitted Site 7 Ceratonia siliqua :: Carob 5 2500X Taylor St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/15/1992 12:00:00 AM 3 3x3   6008409.45282 2121407.87429 37.8054559800011 -122.415161778523 (37.8054559800011, -122.415161778523) 5 1 10 308 23
14153 61726 DPW Maintained 1 Ceratonia siliqua :: Carob 5 28 Ceres St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/14/1984 12:00:00 AM 9   Permit Number 21728 6013869.02725 2093995.24936 37.7304922999628 -122.39434750634 (37.7304922999628, -122.39434750634) 10 3 8 58 1
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
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
163554 63121 Permitted Site 7 Ceratonia siliqua :: Carob 5 42 Prospect Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/09/1986 12:00:00 AM     Permit Number 23632 6007120.53987433 2099276.08223849 37.7446148564174 -122.418052288309 (37.7446148564174, -122.418052288309) 2 7 7 28859 2
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
183488 63120 Permitted Site 7 Ceratonia siliqua :: Carob 5 46 Lundy's Ln 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/09/1986 12:00:00 AM     Permit Number 23631 6007008.06371762 2099307.94192573 37.7446960047915 -122.418443468102 (37.7446960047915, -122.418443468102) 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
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
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
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
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
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
29498 225099 DPW Maintained 1 Ceratonia siliqua :: Carob 5 109 Germania St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/04/1996 12:00:00 AM 14 Width 3ft Permit Number 37779 6003663.75485 2108815.27117 37.7706120358534 -122.430685739554 (37.7706120358534, -122.430685739554) 15 9 11 29492 10
177869 33711 Permitted Site 7 Ceratonia siliqua :: Carob 5 109 Germania St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/04/1996 12:00:00 AM     Permit Number 37779 6003691.57039211 2108804.29883955 37.7705834843276 -122.430588742236 (37.7705834843276, -122.430588742236) 15 9 11 29492 10
132813 16493 DPW Maintained 1 Ceratonia siliqua :: Carob 5 325 Newhall St 6 Sidewalk: Curb side : Cutout Tree DPW 1   12/03/1992 12:00:00 AM 3 3X3   6016616 2098292 37.7424426300051 -122.385150000825 (37.7424426300051, -122.385150000825) 10 3 8 58 1
183957 16509 DPW Maintained 1 Ceratonia siliqua :: Carob 5 325 Newhall St 11 Sidewalk: Curb side : Cutout Tree DPW 1   12/03/1992 12:00:00 AM 3 3X3   6016661.92107 2098301.48789 37.742471221974 -122.384991878867 (37.742471221974, -122.384991878867) 10 3 8 58 1
4137 61685 DPW Maintained 1 Ceratonia siliqua :: Carob 5 34 Ceres St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/29/1984 12:00:00 AM 11   Permit Number 21682 6013864.09066 2093969.56082 37.7304214900476 -122.394362775032 (37.7304214900476, -122.394362775032) 10 3 8 58 1
82714 94895 DPW Maintained 1 Ceratonia siliqua :: Carob 5 43 Flora St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/23/2010 12:00:00 AM 3 3x3 Permit Number 53954 6014036.5 2094589.2 37.7321324754711 -122.393810082896 (37.7321324754711, -122.393810082896) 10 3 8 58 1
84292 94894 DPW Maintained 1 Ceratonia siliqua :: Carob 5 43 Flora St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/23/2010 12:00:00 AM 3 3x3 Permit Number 53954 6014036.5 2094589.2 37.7321324754711 -122.393810082896 (37.7321324754711, -122.393810082896) 10 3 8 58 1
132285 94893 DPW Maintained 1 Ceratonia siliqua :: Carob 5 43 Flora St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/23/2010 12:00:00 AM 3 3x3 Permit Number 53954 6014036.5 2094589.2 37.7321324754711 -122.393810082896 (37.7321324754711, -122.393810082896) 10 3 8 58 1
167565 94892 DPW Maintained 1 Ceratonia siliqua :: Carob 5 43 Flora St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/23/2010 12:00:00 AM 3 3x3 Permit Number 53954 6014036.5 2094589.2 37.7321324754711 -122.393810082896 (37.7321324754711, -122.393810082896) 10 3 8 58 1
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
120772 51301 Permitted Site 7 Ceratonia siliqua :: Carob 5 101 Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/20/2004 12:00:00 AM     Permit Number 47670 6008105.70875607 2112751.56982087 37.7816708281319 -122.415599663608 (37.7816708281319, -122.415599663608) 7 10 9 28852 36
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
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
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
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
17663 101489 Undocumented 4 Ceratonia siliqua :: Carob 5 59X Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/26/2012 12:00:00 AM 1 3x3 Permit Number 769087 6005416.7 2109221 37.7718252244657 -122.424651142233 (37.7718252244657, -122.424651142233) 7 9 5 28852 10
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
6377 82142 Permitted Site 7 Ceratonia siliqua :: Carob 5 30 Molimo Dr 2 Sidewalk: Curb side : Cutout Tree Private 2   10/25/2007 12:00:00 AM   3x3 Permit Number 49838 5998889.06181671 2096571.98929044 37.736723332936 -122.446320512355 (37.736723332936, -122.446320512355) 9 7 4 59 40
37929 82121 Permitted Site 7 Ceratonia siliqua :: Carob 5 44 Molimo Dr 1 Sidewalk: Curb side : Cutout Tree Private 2   10/25/2007 12:00:00 AM   3x3 Permit Number 49840 5998809.17063994 2096527.78133102 37.7365973852663 -122.446593550118 (37.7365973852663, -122.446593550118) 9 7 4 59 40
115939 82092 Permitted Site 7 Ceratonia siliqua :: Carob 5 30 Molimo Dr 4 Sidewalk: Curb side : Cutout Tree Private 2   10/25/2007 12:00:00 AM   3x3 Permit Number 49838 5998889.06181671 2096571.98929044 37.736723332936 -122.446320512355 (37.736723332936, -122.446320512355) 9 7 4 59 40
146949 82141 Permitted Site 7 Ceratonia siliqua :: Carob 5 30 Molimo Dr 3 Sidewalk: Curb side : Cutout Tree Private 2   10/25/2007 12:00:00 AM   3x3 Permit Number 49838 5998889.06181671 2096571.98929044 37.736723332936 -122.446320512355 (37.736723332936, -122.446320512355) 9 7 4 59 40
150580 82143 Permitted Site 7 Ceratonia siliqua :: Carob 5 30 Molimo Dr 1 Sidewalk: Curb side : Cutout Tree Private 2   10/25/2007 12:00:00 AM   3x3 Permit Number 49838 5998889.06181671 2096571.98929044 37.736723332936 -122.446320512355 (37.736723332936, -122.446320512355) 9 7 4 59 40
142864 32581 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1314 33rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/22/1996 12:00:00 AM 4   Permit Number 37055 5985876.1437 2106257.7648 37.7625660493627 -122.492024105228 (37.7625660493627, -122.492024105228) 1 8 3 56 35
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
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
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
26541 62275 Permitted Site 7 Ceratonia siliqua :: Carob 5 141 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/09/1985 12:00:00 AM     Permit Number 22411 6004215.98521889 2109270.59348358 37.771893510559 -122.428808033039 (37.771893510559, -122.428808033039) 7 9 11 29492 10
62864 62271 Permitted Site 7 Ceratonia siliqua :: Carob 5 108 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/09/1985 12:00:00 AM     Permit Number 22405 6004283.36290773 2109163.56782991 37.7716034574246 -122.428567338549 (37.7716034574246, -122.428567338549) 7 9 11 28852 10
102569 62273 Permitted Site 7 Ceratonia siliqua :: Carob 5 123 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/09/1985 12:00:00 AM     Permit Number 22409 6004226.44756002 2109195.3304156 37.7716874486567 -122.428766476737 (37.7716874486567, -122.428766476737) 7 9 11 29492 10
112903 62270 Permitted Site 7 Ceratonia siliqua :: Carob 5 102 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/09/1985 12:00:00 AM     Permit Number 22404 6004290.78316217 2109110.18870614 37.7714573112605 -122.42853786595 (37.7714573112605, -122.42853786595) 7 9 11 28852 10
131347 62272 Permitted Site 7 Ceratonia siliqua :: Carob 5 113 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/09/1985 12:00:00 AM     Permit Number 22406 6004233.40404883 2109145.28748516 37.7715504366717 -122.428738845772 (37.7715504366717, -122.428738845772) 7 9 11 29492 10
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
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
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
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
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
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
131762 50388 Permitted Site 7 Ceratonia siliqua :: Carob 5 296 Liberty St 3 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
191816 115841 DPW Maintained 1 Ceratonia siliqua :: Carob 5 3501 Laguna St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/19/2017 12:00:00 AM 3 3x3   6003584.99572 2120815.79777 37.8035579867804 -122.431815152253 (37.8035579867804, -122.431815152253) 13 9 1 57 17
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
143674 60260 Permitted Site 7 Ceratonia siliqua :: Carob 5 2844 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/15/1984 12:00:00 AM     Permit Number 19815 6009158.9675903 2103949.64001782 37.757561921733 -122.411333877594 (37.757561921733, -122.411333877594) 2 4 7 28859 19
192516 60263 Permitted Site 7 Ceratonia siliqua :: Carob 5 2781 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/15/1984 12:00:00 AM     Permit Number 19819 6009497.44754454 2103916.17692673 37.7574890178355 -122.410160909746 (37.7574890178355, -122.410160909746) 2 4 7 28859 19
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
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
162327 60271 Permitted Site 7 Ceratonia siliqua :: Carob 5 2761 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/10/1982 12:00:00 AM 12 3x3 Permit Number 19827 6009603.81924648 2103922.02713572 37.7575110429284 -122.409793445145 (37.7575110429284, -122.409793445145) 2 4 7 28859 19
172971 96123 Permitted Site 7 Ceratonia siliqua :: Carob 5 181 College Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/08/2011 12:00:00 AM   3x3 Permit Number 767774 6004920.8 2095965.5 37.7354006937902 -122.425423007406 (37.7354006937902, -122.425423007406) 2 7 5 28861 2
75940 51298 DPW Maintained 1 Ceratonia siliqua :: Carob 5 300X Golden Gate Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/07/2004 12:00:00 AM 7   Permit Number 47670 6008009.38054 2112753.19289 37.7816698695126 -122.415933029587 (37.7816698695126, -122.415933029587) 7 10 9 28852 36
153705 51299 DPW Maintained 1 Ceratonia siliqua :: Carob 5 300X Golden Gate Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/07/2004 12:00:00 AM 10   Permit Number 47670 6008033.00976 2112757.64367 37.7816834187084 -122.415851598691 (37.7816834187084, -122.415851598691) 7 10 9 28852 36
167516 51302 DPW Maintained 1 Ceratonia siliqua :: Carob 5 300X Golden Gate Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/07/2004 12:00:00 AM 12   Permit Number 47670 6008052.8861 2112760.32075 37.7816918867218 -122.415783025366 (37.7816918867218, -122.415783025366) 7 10 9 28852 36
47329 16647 DPW Maintained 1 Ceratonia siliqua :: Carob 5 178 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/04/2015 12:00:00 AM 14 4x4   6002850.60519 2107244.6681 37.7662534427777 -122.433386179722 (37.7662534427777, -122.433386179722) 15 5 5 28862 3
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
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
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
161614 63122 Permitted Site 7 Ceratonia siliqua :: Carob 5 42 Lundy's Ln 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/26/1993 12:00:00 AM     Permit Number 32290 6007020.23858667 2099330.24637666 37.7447579331798 -122.418402950875 (37.7447579331798, -122.418402950875) 2 7 7 28859 2
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
129151 188481 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1570 Burke Ave 10 : Tree Private 2   08/24/2017 12:00:00 AM 3 Width 3ft   6016299.33242 2099120.87091 37.7447010172388 -122.386302728 (37.7447010172388, -122.386302728) 10 3 8 58 1
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
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
185043 48532 Permitted Site 7 Ceratonia siliqua :: Carob 5 500(REVISED) Capp St 2 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
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
107743 54886 Permitted Site 7 Ceratonia siliqua :: Carob 5 140 Carl St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/16/1972 12:00:00 AM   3x4 Permit Number 10751 5997750.13061777 2107162.33224107 37.7657366841835 -122.451021722872 (37.7657366841835, -122.451021722872) 15 5 11 29492 9
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
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
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
181866 68375 Permitted Site 7 Ceratonia siliqua :: Carob 5 175 Alma St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/09/1993 12:00:00 AM     Permit Number 32198 5997884.42699251 2106160.35589629 37.7629931985038 -122.45048498279 (37.7629931985038, -122.45048498279) 15 5 11 29492 9
53679 56848 Permitted Site 7 Ceratonia siliqua :: Carob 5 1025 Clayton St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/02/1974 12:00:00 AM   6x5 Permit Number 14082 5998817.86133668 2106377.94605096 37.7636440271414 -122.447272227776 (37.7636440271414, -122.447272227776) 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
187600 56853 DPW Maintained 1 Ceratonia siliqua :: Carob 5 245 Vienna St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/01/1974 12:00:00 AM 10   Permit Number 14088 6004257.88058 2091960.10063 37.7243652845164 -122.427429718013 (37.7243652845164, -122.427429718013) 9 7 6 28861 5
43480 65221 Permitted Site 7 Ceratonia siliqua :: Carob 5 411 Paris St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/29/1989 12:00:00 AM     Permit Number 28008 6002203.13463286 2091195.37244375 37.7221490848593 -122.434478026037 (37.7221490848593, -122.434478026037) 9 7 6 28861 5
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
50010 85052 Permitted Site 7 Ceratonia siliqua :: Carob 5 355x Page St 2 Sidewalk: Curb side : Cutout Tree Rec/Park 5   06/27/2007 12:00:00 AM     Permit Number 49332 6004826.8 2109751.4 37.7732482408903 -122.426729425627 (37.7732482408903, -122.426729425627) 7 9 11 28852 10
138479 85051 Permitted Site 7 Ceratonia siliqua :: Carob 5 355x Page St 1 Sidewalk: Curb side : Cutout Tree Rec/Park 5   06/27/2007 12:00:00 AM     Permit Number 49332 6004826.8 2109751.4 37.7732482408903 -122.426729425627 (37.7732482408903, -122.426729425627) 7 9 11 28852 10
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
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
168615 4389 DPW Maintained 1 Ceratonia siliqua :: Carob 5 56 Chilton Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   06/09/2008 12:00:00 AM 30 3x3   6001657.8215553 2095631.9001159 37.7342998083721 -122.436680450501 (37.7342998083721, -122.436680450501) 2 7 5 63 7
122812 23566 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2958 Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/09/2005 12:00:00 AM 6     6005632.06356 2120580.68582 37.8030282582004 -122.424714436346 (37.8030282582004, -122.424714436346) 5 9 1 28858 32
20304 49779 Permitted Site 7 Ceratonia siliqua :: Carob 5 241@ BLANKEN Tocoloma Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/09/2003 12:00:00 AM     Permit Number 46565 6012711.25696991 2087289.78103258 37.7120160109599 -122.397879925295 (37.7120160109599, -122.397879925295) 10 3 8 309 1
166428 65950 Permitted Site 7 Ceratonia siliqua :: Carob 5 120 Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1990 12:00:00 AM     Permit Number 28971 6008148.07854497 2112823.994523 37.7818720705068 -122.415458212735 (37.7818720705068, -122.415458212735) 7 10 9 28852 36
46225 3611 DPW Maintained 1 Ceratonia siliqua :: Carob 5 100X Cargo Way 47 Sidewalk: Curb side : Cutout Tree Port 6   05/31/1996 12:00:00 AM 3 3X3   6018038.29611 2098194.83807 37.7422544187983 -122.380225323637 (37.7422544187983, -122.380225323637) 10 3 8 58 1
177221 61796 Permitted Site 7 Ceratonia siliqua :: Carob 5 60 Pierce St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/25/1985 12:00:00 AM     Permit Number 21819 6002883.06164476 2108748.24537279 37.7703837393735 -122.433381373664 (37.7703837393735, -122.433381373664) 15 5 5 29492 9
34503 21789 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2585 Taylor St 4 Sidewalk: Curb side : Cutout Tree DPW 1   05/20/2015 12:00:00 AM 3 4X4   6008161.90241 2121549.79462 37.8058317424248 -122.41602851934 (37.8058317424248, -122.41602851934) 5 1 10 308 23
60751 64436 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2445 Larkin St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/16/1988 12:00:00 AM 12   Permit Number 25292 6006658.75135 2119650.10198 37.8005310432266 -122.421095439396 (37.8005310432266, -122.421095439396) 5 9 1 28858 32
62069 4912 Permitted Site 7 Ceratonia siliqua :: Carob 5 195X Newhall St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/11/2016 12:00:00 AM 12 3X3   6017015.0972074 2098230.5166868 37.742295878473 -122.383765748687 (37.742295878473, -122.383765748687) 10 3 8 58 1
185290 4919 DPW Maintained 1 Ceratonia siliqua :: Carob 5 195X Newhall St 8 Sidewalk: Curb side : Cutout Tree DPW 1   05/11/2016 12:00:00 AM 12 3X3   6017015.0972074 2098230.5166868 37.742295878473 -122.383765748687 (37.742295878473, -122.383765748687) 10 3 8 58 1
25806 47316 Permitted Site 7 Ceratonia siliqua :: Carob 5 2524 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/10/2002 12:00:00 AM     Permit Number 45245 6010338.92838604 2105074.55283943 37.7607167883884 -122.407332377331 (37.7607167883884, -122.407332377331) 10 4 8 28859 19

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);