1,194 rows where qSpecies_id = 50 sorted by rowid descending

View and edit SQL

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)
175959 37023 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 402 27th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/1998 12:00:00 AM     Permit Number 39634 6003883.04118176 2100148.50226599 37.7468275709653 -122.429309115245 (37.7468275709653, -122.429309115245) 2 7 5 63 22
175900 229803 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1 Sycamore St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6006754.85376 2105853.73018 37.7626549800545 -122.419783396906 (37.7626549800545, -122.419783396906) 8 4 7 28859 19
175750 226331 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 155 Lexington St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   6006477.52748 2105222.5882 37.7609063850338 -122.420697763712 (37.7609063850338, -122.420697763712) 2 4 7 28859 19
175730 254646 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 67 Saint Charles Ave 31 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 Private     3x3   5992096 2088072 37.7129941473192 -122.469188407447 (37.7129941473192, -122.469188407447) 9 8 6 64 24
175485 94191 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 529 Texas St   Sidewalk: Curb side : Cutout Tree Private 2   06/22/2010 12:00:00 AM   3x3 Permit Number 53584 6013839 2104639 37.7597161279512 -122.395196600917 (37.7597161279512, -122.395196600917) 10 3 8 28856 29
175462 196543 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 975 De Haro St 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/29/2018 12:00:00 AM 5 Width 3ft   6012204.60388 2103877.56611 37.7575343698359 -122.400795707451 (37.7575343698359, -122.400795707451) 10 3 8 28856 29
175338 226824 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 463 Arlington St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6003840.68463 2095954.97206 37.7353107011233 -122.429156618694 (37.7353107011233, -122.429156618694) 2 7 5 63 7
175279 190729 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 100 Utah St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6010522.64899 2107794.80164 37.7681962553765 -122.406888694378 (37.7681962553765, -122.406888694378) 8 4 8 28853 19
175061 228532 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1000 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6009375.26414 2107362.10106 37.7669438900682 -122.410826835502 (37.7669438900682, -122.410826835502) 8 4 7 28853 19
174953 226307 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 303 Bennington St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6007092.99842 2096727.14909 37.7376145033994 -122.417966864376 (37.7376145033994, -122.417966864376) 2 7 7 28859 2
174816 96091 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 116 Drake St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/25/2011 12:00:00 AM   3x3 Permit Number 56922 6001481 2086737 37.7098663684689 -122.436655293893 (37.7098663684689, -122.436655293893) 9 7 6 28861 5
174657 121750 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1201x Vermont St 13 Front Yard : Yard Tree DPW 1       3x3   6011405 2102539 37.7538143308772 -122.403466904543 (37.7538143308772, -122.403466904543) 10 4 8 28859 19
174641 67525 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1237 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/22/1992 12:00:00 AM 5   Permit Number 31063 6013863.96904 2105222.10332 37.7613185911004 -122.395151089252 (37.7613185911004, -122.395151089252) 10 3 8 28856 29
174174 95221 Undocumented 4 Jacaranda mimosifolia :: Jacaranda 50 299 on 16th St Dolores St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/01/2015 12:00:00 AM   3x3 Permit Number 774713 6004880 2106610 37.7646257206218 -122.426321695151 (37.7646257206218, -122.426321695151) 8 4 5 28859 19
173888 51288 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1143 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/26/2004 12:00:00 AM     Permit Number 47660 6009497.00762937 2102519.03673443 37.7536527600356 -122.410063798952 (37.7536527600356, -122.410063798952) 2 4 7 28859 19
173427 68130 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 636 Texas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/20/1993 12:00:00 AM     Permit Number 31881 6013816.64959872 2104131.08746025 37.75832026754 -122.395238321176 (37.75832026754, -122.395238321176) 10 3 8 28856 29
172836 37451 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 444 Franconia St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/1998 12:00:00 AM     Permit Number 39924 6009949.70212209 2098546.33795552 37.7427699663381 -122.408218103257 (37.7427699663381, -122.408218103257) 10 7 7 28859 2
172142 255773 Planning Code 138.1 required 2 Jacaranda mimosifolia :: Jacaranda 50 450 Toland St 4 Sidewalk: Curb side : Cutout Tree Private 2   07/10/2018 12:00:00 AM 3   Permit Number 779472 6012768.71675 2099101.44192 37.7444516111373 -122.398509629682 (37.7444516111373, -122.398509629682) 10 3 8 58 1
172125 111063 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1851 Bryant St 12 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6009528.24804625 2106163.95855958 37.7636626423221 -122.410213085123 (37.7636626423221, -122.410213085123) 8 4 8 28859 19
172051 35555 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 121 Fair Oaks St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/1998 12:00:00 AM     Permit Number 38929 6005429.10148231 2103004.04163022 37.7547556297845 -122.424166028327 (37.7547556297845, -122.424166028327) 2 4 5 28859 19
171733 190694 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 99 Missouri St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6013445.19565 2106684.95045 37.7653119497171 -122.396702014197 (37.7653119497171, -122.396702014197) 14 3 8 28856 20
171679 110370 Undocumented 4 Jacaranda mimosifolia :: Jacaranda 50 2299x ALAMEDA ST 3 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6010419 2107687 37.7678944564601 -122.407239607329 (37.7678944564601, -122.407239607329) 8 4 8 28853 19
171578 226306 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 92 Santa Marina St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6006186.62899 2097537.37358 37.7397881459032 -122.421158135656 (37.7397881459032, -122.421158135656) 2 7 7 28859 2
170851 129103 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1306x Montgomery St 29 Median : Yard Tree DPW 1     2 Width 8ft   6011435.37643 2120050.37627 37.8018982087863 -122.404594484269 (37.8018982087863, -122.404594484269) 3 1 10 308 23
170353 68103 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 67 Manchester St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/26/1993 12:00:00 AM 8 3x3 Permit Number 31849 6008260.07157656 2099634.80152159 37.7456638906333 -122.414137374358 (37.7456638906333, -122.414137374358) 2 7 7 28859 2
170230 229874 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 3570 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6004568.82488 2103108.44768 37.7549936933086 -122.42714853777 (37.7549936933086, -122.42714853777) 2 4 5 28862 22
170166 226315 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1045 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6007642.72664 2103585.2825 37.756476322828 -122.416551856705 (37.756476322828, -122.416551856705) 2 4 7 28859 19
170113 35796 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 230 Lexington St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/22/1998 12:00:00 AM     Permit Number 39044 6006467.16362039 2104758.98191383 37.7596328461688 -122.42070069541 (37.7596328461688, -122.42070069541) 2 4 7 28859 19
170096 229769 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1201 Vermont St 39 Sidewalk: Property side : Yard Tree Private 2     3 Width 4ft   6011449.91996 2102448.35306 37.7535679432079 -122.403305183785 (37.7535679432079, -122.403305183785) 10 4 8 28859 19
169650 42663 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 205 Bartlett St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2000 12:00:00 AM     Permit Number 42694 6006739.09438078 2102580.17039633 37.7536656552896 -122.419605633092 (37.7536656552896, -122.419605633092) 2 4 7 28859 19
169649 190741 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1786 Quesada Ave 1 : Tree Private 2     6 Width 3ft   6014282.60323 2095390.34812 37.7343459381091 -122.393015276746 (37.7343459381091, -122.393015276746) 10 3 8 58 1
169574 121581 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 199X Texas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   2 3x3   6013754.46885 2106222.83027 37.764060277784 -122.395599922908 (37.764060277784, -122.395599922908) 14 3 8 28856 29
169196 226795 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 677 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6002427.79388 2104301.04841 37.7581469808114 -122.434638096272 (37.7581469808114, -122.434638096272) 2 4 5 28862 3
168986 190710 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 715 Wisconsin St 2 : Tree Private 2     11 Width 3ft   6012743.45877 2104190.05175 37.7584224278606 -122.398954049707 (37.7584224278606, -122.398954049707) 10 3 8 28856 29
168980 226358 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 603 San Jose Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6006078.34429 2099888.6136 37.7462380152724 -122.421699497839 (37.7462380152724, -122.421699497839) 2 7 5 28859 2
168892 226441 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 507 Bartlett St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6006831.87915 2100767.2588 37.7486930394633 -122.419156175534 (37.7486930394633, -122.419156175534) 2 4 7 28859 19
168519 229779 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1201 Vermont St 49 Sidewalk: Property side : Yard Tree Private 2     4 Width 4ft   6011439.17328 2102646.69218 37.75411193863 -122.403356300366 (37.75411193863, -122.403356300366) 10 4 8 28859 19
168405 37760 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1349 York St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/29/2001 12:00:00 AM     Permit Number 43826 6010106.85455823 2101350.26433307 37.7504777324538 -122.407872391397 (37.7504777324538, -122.407872391397) 2 4 7 28859 19
168394 34557 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 2 Nebraska St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/1997 12:00:00 AM     Permit Number 38265 6009291.02762051 2098031.45158376 37.7413192965243 -122.410459272722 (37.7413192965243, -122.410459272722) 10 7 7 28859 2
168291 229850 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 86 Fair Oaks St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6005369.98342 2103227.02308 37.7553645467641 -122.424386333963 (37.7553645467641, -122.424386333963) 2 4 5 28859 19
167994 229785 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1366 Utah St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6010846.06079 2101951.02013 37.7521686322761 -122.405358450228 (37.7521686322761, -122.405358450228) 10 4 8 28859 19
167928 226763 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 162 Duncan St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6005498.11754 2099940.99775 37.7463491139326 -122.423709577049 (37.7463491139326, -122.423709577049) 2 7 5 28859 22
167891 226319 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1363 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   6009300.51192 2101248.84299 37.7501540762619 -122.410653634171 (37.7501540762619, -122.410653634171) 2 4 7 28859 19
167786 121742 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1201x Vermont St 5 Front Yard : Yard Tree DPW 1       3x3   6011405 2102539 37.7538143308772 -122.403466904543 (37.7538143308772, -122.403466904543) 10 4 8 28859 19
167135 34334 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50   12 Sidewalk: Curb side : Cutout Tree Private 2   07/14/1997 12:00:00 AM     Permit Number 38095 6011565.66175485 2101164.33215433 37.7500487659499 -122.402814623369 (37.7500487659499, -122.402814623369) 10 3 8 28856 29
166927 226338 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 41 Bartlett St 5 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6006684.19647 2103512.2186 37.7562217526516 -122.41986161543 (37.7562217526516, -122.41986161543) 2 4 7 28859 19
166899 229893 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 57 Manchester St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6008237.21282 2099854.86207 37.7462668439462 -122.414231983545 (37.7462668439462, -122.414231983545) 2 7 7 28859 2
166588 37015 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 3027 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/29/1998 12:00:00 AM     Permit Number 39628 6009057.00887193 2100861.48300975 37.7490768167034 -122.411468322066 (37.7490768167034, -122.411468322066) 2 4 7 28859 19
166585 226406 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1417 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6008014.49827 2099882.17848 37.7463293360461 -122.415004038921 (37.7463293360461, -122.415004038921) 2 7 7 28859 2
166424 229855 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 354 Fair Oaks St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6005458.16704 2101659.72097 37.7510660778443 -122.42396992087 (37.7510660778443, -122.42396992087) 2 4 5 28859 19
166276 95624 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 3548 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/04/2011 12:00:00 AM   3x3 Permit Number 767391 6005934 2105520 37.761692359374 -122.422598723522 (37.761692359374, -122.422598723522) 8 4 5 28859 19
166181 37741 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1266 Florida St 9 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/01/1998 12:00:00 AM     Permit Number 40095 6009484.78268632 2101799.61949938 37.751676715706 -122.410055290726 (37.751676715706, -122.410055290726) 2 4 7 28859 19
165980 35552 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 86 Fair Oaks St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/1998 12:00:00 AM     Permit Number 38926 6005365.24269409 2103216.6337934 37.7553357524994 -122.424401989918 (37.7553357524994, -122.424401989918) 2 4 5 28859 19
165791 229757 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1201 Vermont St 26 Sidewalk: Property side : Yard Tree Private 2     5 Width 4ft   6011461.99954 2102213.77594 37.752924520553 -122.403246909533 (37.752924520553, -122.403246909533) 10 4 8 28859 19
165341 34325 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50   1 Sidewalk: Curb side : Cutout Tree Private 2   07/14/1997 12:00:00 AM     Permit Number 38095 6011565.66175485 2101164.33215433 37.7500487659499 -122.402814623369 (37.7500487659499, -122.402814623369) 10 3 8 28856 29
165178 226466 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 7 28th St 4 Sidewalk: Curb side : Pot Tree Private 2     3 Width 3ft   6005836.7555 2099627.17961 37.7455065507954 -122.422516309799 (37.7455065507954, -122.422516309799) 2 7 5 28859 22
164964 108456 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 980 Minnesota St 4 Sidewalk: Curb side : Cutout Tree Private 2     8     6015231.85708 2103981.85157 37.7579891012316 -122.390333443542 (37.7579891012316, -122.390333443542) 10 3 8 28856 29
164840 229738 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1498 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6009552.90198 2100679.56843 37.748605121741 -122.409740673009 (37.748605121741, -122.409740673009) 2 4 7 28859 19
164689 229863 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1511 York St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6010172.47865 2100425.75688 37.7479429122343 -122.407580282 (37.7479429122343, -122.407580282) 2 7 7 28859 2
164441 226451 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 3070 23rd St 5 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6008441.9337 2102736.37343 37.7541903253234 -122.413727863145 (37.7541903253234, -122.413727863145) 2 4 7 28859 19
164341 229751 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1201 Vermont St 18 Sidewalk: Property side : Yard Tree Private 2     6 Width 4ft   6011465.75975 2102083.13702 37.7525660247145 -122.40322471697 (37.7525660247145, -122.40322471697) 10 4 8 28859 19
164001 229816 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 990 Treat Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6008580.21051 2102912.84819 37.7546826492875 -122.413262144753 (37.7546826492875, -122.413262144753) 2 4 7 28859 19
163887 34330 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50   8 Sidewalk: Curb side : Cutout Tree Private 2   07/14/1997 12:00:00 AM     Permit Number 38095 6011565.66175485 2101164.33215433 37.7500487659499 -122.402814623369 (37.7500487659499, -122.402814623369) 10 3 8 28856 29
163736 226783 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 579 Noe St 3 Sidewalk: Curb side : Yard Tree Private 2     3 Width 3ft   6003034.17518 2104887.2525 37.7597909621971 -122.432582841439 (37.7597909621971, -122.432582841439) 2 4 5 28862 3
163566 37677 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 3330 20TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/29/1998 12:00:00 AM 8 0x0 Permit Number 40072 6008031 2104525 37.7590784006599 -122.415275586184 (37.7590784006599, -122.415275586184) 2 4 7 28859 19
163174 63722 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 282 Precita Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/22/1987 12:00:00 AM     Permit Number 24387 6008301.23026628 2100182.88719283 37.7471711235701 -122.414033820067 (37.7471711235701, -122.414033820067) 2 7 7 28859 2
162863 226421 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 3354 Shotwell St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6007857.16487 2104491.21664 37.7589758679475 -122.415874400085 (37.7589758679475, -122.415874400085) 2 4 7 28859 19
162785 34322 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50   27 Sidewalk: Curb side : Cutout Tree Private 2   07/14/1997 12:00:00 AM     Permit Number 38095 6011565.66175485 2101164.33215433 37.7500487659499 -122.402814623369 (37.7500487659499, -122.402814623369) 10 3 8 28856 29
162653 251225 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1 Yukon St 1 Sidewalk: Curb side : Cutout Tree Private 2       12x2.5   6000238 2104757 37.7592743544717 -122.442244057145 (37.7592743544717, -122.442244057145) 2 4 5 28862 3
162205 36596 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1325 Florida St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/20/1998 12:00:00 AM     Permit Number 39450 6009555.90279082 2101454.80149403 37.7507339080729 -122.409785009854 (37.7507339080729, -122.409785009854) 2 4 7 28859 19
162120 58905 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 655 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/31/2012 12:00:00 AM     Permit Number 769760 6002418.15212939 2104399.4018004 37.7584164881822 -122.434678474426 (37.7584164881822, -122.434678474426) 2 4 5 28862 3
161840 148099 Planning Code 138.1 required 2 Jacaranda mimosifolia :: Jacaranda 50 509 Holyoke St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/19/2018 12:00:00 AM 3 4x4 Permit Number 782106 6009909.13224 2092063.05855 37.7249659929773 -122.40790129952 (37.7249659929773, -122.40790129952) 10 3 7 309 28
161547 68190 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1625 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/29/1993 12:00:00 AM 9   Permit Number 31967 6012798.25639 2105161.94327 37.761094081638 -122.398832742859 (37.761094081638, -122.398832742859) 10 3 8 28856 29
161520 41430 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 514 Connecticut St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/29/2018 12:00:00 AM 5   Permit Number 43060 6013229.56642 2104526.4373 37.7593731443828 -122.397296450777 (37.7593731443828, -122.397296450777) 10 3 8 28856 29
161348 44333 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 2516 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/05/2001 12:00:00 AM     Permit Number 43718 6011390.61929335 2101865.00809081 37.7519628937204 -122.403469222223 (37.7519628937204, -122.403469222223) 10 4 8 28859 19
161158 36061 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1401 Bryant St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/28/1998 12:00:00 AM     Permit Number 39185 6009421.20140012 2108121.84074464 37.7690325354797 -122.410721604896 (37.7690325354797, -122.410721604896) 8 4 8 28853 19
160502 190735 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 128 Utah St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6010531.76595 2107657.21316 37.7678189790021 -122.406847461368 (37.7678189790021, -122.406847461368) 8 4 8 28853 19
160328 34333 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50   11 Sidewalk: Curb side : Cutout Tree Private 2   07/14/1997 12:00:00 AM     Permit Number 38095 6011565.66175485 2101164.33215433 37.7500487659499 -122.402814623369 (37.7500487659499, -122.402814623369) 10 3 8 28856 29
160150 52222 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 351 Shotwell St 5 Sidewalk: Curb side : Cutout Tree Private 2   11/16/2005 12:00:00 AM     Permit Number 48402 6007831.77869094 2105893.38398739 37.7628244688066 -122.416061497544 (37.7628244688066, -122.416061497544) 8 4 7 28859 19
159876 121752 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1201x Vermont St 15 Front Yard : Yard Tree DPW 1       3x3   6011405 2102539 37.7538143308772 -122.403466904543 (37.7538143308772, -122.403466904543) 10 4 8 28859 19
159856 229762 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1201 Vermont St 32 Sidewalk: Property side : Yard Tree Private 2     4 Width 4ft   6011454.29465 2102314.61303 37.7532009667707 -122.403280647606 (37.7532009667707, -122.403280647606) 10 4 8 28859 19
159303 45811 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 71 Caselli Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/04/2001 12:00:00 AM     Permit Number 44439 6000723.05882095 2104884.41992047 37.7596518513768 -122.440575632448 (37.7596518513768, -122.440575632448) 2 4 5 28862 3
159162 87811 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 3631 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/02/2008 12:00:00 AM   3x3 Permit Number 50591 6005544 2102537 37.7534797286848 -122.423735471432 (37.7534797286848, -122.423735471432) 2 4 5 28859 19
159081 100089 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 2034 Filbert St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6003188.20593 2118955.0281 37.7984262977915 -122.433055234626 (37.7984262977915, -122.433055234626) 13 9 1 57 17
159008 190714 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 375 Texas St 2 : Tree Private 2     4 Width 5ft   6013800.48111 2105372.99908 37.7617293870175 -122.395381240171 (37.7617293870175, -122.395381240171) 10 3 8 28856 29
158970 95223 Undocumented 4 Jacaranda mimosifolia :: Jacaranda 50 299 on 16th St Dolores St 5 Sidewalk: Curb side : Cutout Tree Private 2   12/01/2015 12:00:00 AM 3 3x3 Permit Number 774713 6004880 2106610 37.7646257206218 -122.426321695151 (37.7646257206218, -122.426321695151) 8 4 5 28859 19
158779 226356 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 2793 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6008207.55 2106773.70397 37.7652627442076 -122.414824138541 (37.7652627442076, -122.414824138541) 8 4 7 28859 19
158762 229744 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1 27th St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6006129.97006 2100227.10081 37.7471703352582 -122.421545017711 (37.7471703352582, -122.421545017711) 2 7 5 28859 22
158659 229827 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1450 York St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 6ft   6010090.15715 2100798.67472 37.7489622542237 -122.407891240603 (37.7489622542237, -122.407891240603) 2 4 7 28859 19
158632 142077 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 36 ATALAYA TER 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5998850.2457 2110939.7307 37.7761713796539 -122.447488599832 (37.7761713796539, -122.447488599832) 15 6 2 29492 16
158524 229801 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 232 Lexington St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6006479.77522 2104722.77918 37.7595341526843 -122.4206545081 (37.7595341526843, -122.4206545081) 2 4 7 28859 19
158498 35323 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 209 San Carlos St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/22/2002 12:00:00 AM     Permit Number 45862 6006709.88986016 2104895.8779561 37.76002240815 -122.419870939027 (37.76002240815, -122.419870939027) 2 4 7 28859 19
158091 129102 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 701 Buchanan St 5 : Tree Private 2     5 Width 6ft   6004465.70248 2110959.4385 37.7765447968535 -122.428064615105 (37.7765447968535, -122.428064615105) 7 9 11 28852 10
158000 35547 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 110 Bartlett St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/1998 12:00:00 AM     Permit Number 38923 6006656.9527086 2103125.85221235 37.7551593447884 -122.419928417644 (37.7551593447884, -122.419928417644) 2 4 7 28859 19
157884 32980 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 553 Texas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/01/1996 12:00:00 AM 12   Permit Number 37293 6013848.61872 2104519.06137 37.7593873374867 -122.395154932952 (37.7593873374867, -122.395154932952) 10 3 8 28856 29
157876 111096 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 67 SAINT CHARLES AVE 31 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 DPW   15     5992079 2088073 37.7129959107362 -122.469247237289 (37.7129959107362, -122.469247237289) 9 8 6 64 24
157868 226819 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 70 Potomac St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6003113.42277 2108740.53818 37.7703756436569 -122.432584004272 (37.7703756436569, -122.432584004272) 15 5 5 29492 9
157854 226806 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 190 Storrie St 8 Front Yard : Yard Tree Private 2     3 Width 3ft   6000773.9022 2105295.69732 37.7607840134024 -122.440429287805 (37.7607840134024, -122.440429287805) 15 4 5 28862 3
157820 226386 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 354 Coleridge St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6006131.45892 2098074.37938 37.7412595329921 -122.421387016722 (37.7412595329921, -122.421387016722) 2 7 7 28859 2
157772 34316 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50   26 Sidewalk: Curb side : Cutout Tree Private 2   07/14/1997 12:00:00 AM     Permit Number 38095 6011565.66175485 2101164.33215433 37.7500487659499 -122.402814623369 (37.7500487659499, -122.402814623369) 10 3 8 28856 29

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