trees

1,194 rows where qSpecies_id = 50 sorted by DBH

✎ View and edit SQL

This data as json, CSV (advanced)

Neighborhoods (old) ✖

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)
571 91075 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 576 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/19/2008 12:00:00 AM   3x3 Permit Number 51977 6007858 2104570 37.7591922359052 -122.415877090614 (37.7591922359052, -122.415877090614) 2 4 7 28859 19
991 38251 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1475 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/27/1998 12:00:00 AM     Permit Number 40361 6007534.04468586 2107333.12590687 37.7667609198383 -122.417193284079 (37.7667609198383, -122.417193284079) 8 4 7 28853 19
1529 36010 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 190 Tiffany Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/27/1998 12:00:00 AM     Permit Number 39158 6005991.6913929 2099142.23667474 37.7441837468315 -122.421946122617 (37.7441837468315, -122.421946122617) 2 7 5 28859 2
2118 73083 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 3246 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/18/1999 12:00:00 AM   3x3   6007158.13725384 2106179.72119915 37.7635727856768 -122.418411696436 (37.7635727856768, -122.418411696436) 8 4 7 28859 19
2399 121749 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1201x Vermont St 12 Front Yard : Yard Tree DPW 1       3x3   6011405 2102539 37.7538143308772 -122.403466904543 (37.7538143308772, -122.403466904543) 10 4 8 28859 19
4647 36593 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1325 Florida St 6 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
4736 121804 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1201x Vermont St 22 Front Yard : Yard Tree DPW 1       3x3   6011405 2102539 37.7538143308772 -122.403466904543 (37.7538143308772, -122.403466904543) 10 4 8 28859 19
5495 260381 Undocumented 4 Jacaranda mimosifolia :: Jacaranda 50 1924 Jennings St 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6015697 2093053 37.7280065148754 -122.387962157958 (37.7280065148754, -122.387962157958) 10 3 8 58 1
6402 94573 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 3978 18th St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/20/2010 12:00:00 AM   3x3 Permit Number 53752 6003116 2105363 37.761101890414 -122.432333828196 (37.761101890414, -122.432333828196) 15 4 5 28862 3
6465 261249 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 23 Porter St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007038 2095471 37.7341622992343 -122.418067993983 (37.7341622992343, -122.418067993983) 2 7 7 28859 2
6953 34058 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50   1 Sidewalk: Curb side : Cutout Tree Private 2   07/05/1997 12:00:00 AM     Permit Number 37960                    
8083 261467 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 810 14th St 4 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6003376.13457 2107738.85817 37.7676401694851 -122.431603760325 (37.7676401694851, -122.431603760325) 15 5 5 28862 3
8559 264797 Undocumented 4 Jacaranda mimosifolia :: Jacaranda 50 685 Dwight St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009656 2091058 37.7221921373886 -122.40870548174 (37.7221921373886, -122.40870548174) 10 3 7 309 28
8650 46584 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 2790 York St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/05/2002 12:00:00 AM     Permit Number 44712                    
8746 37676 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 3330 20TH ST 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/29/1998 12:00:00 AM     Permit Number 40072 6008031 2104525 37.7590784006599 -122.415275586184 (37.7590784006599, -122.415275586184) 2 4 7 28859 19
9084 52119 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 700 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/26/2005 12:00:00 AM   3x3 Permit Number 48306 6004489.25693114 2110876.3075584 37.7763178722928 -122.427977208208 (37.7763178722928, -122.427977208208) 7 9 11 28852 10
9095 256124 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1250X Florida St 9 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6009290 2101816 37.7517107736785 -122.410730034064 (37.7517107736785, -122.410730034064) 2 4 7 28859 19
9289 260836 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1536 McKinnon Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6015652 2095724 37.7353380520345 -122.388304065218 (37.7353380520345, -122.388304065218) 10 3 8 58 1
10242 52219 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 351 Shotwell St 4 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
11283 96093 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 116 Drake St 3 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
11638 95638 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 62 Landers St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/04/2011 12:00:00 AM   3x3 Permit Number 767404 6004462 2107407 37.7667904546556 -122.427824239372 (37.7667904546556, -122.427824239372) 8 4 5 28862 3
12676 251651 Significant Tree 6 Jacaranda mimosifolia :: Jacaranda 50 3237 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 782183 6009049 2099828 37.7462386522881 -122.411423013741 (37.7462386522881, -122.411423013741) 2 7 7 28859 2
12919 262245 Undocumented 4 Jacaranda mimosifolia :: Jacaranda 50 1045 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004464 2102825 37.7542094840672 -122.427490860103 (37.7542094840672, -122.427490860103) 2 4 5 28862 22
13018 121737 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1301 Vermont St 12 Front Yard : Yard Tree DPW 1       3x3   6011430 2102074 37.7525389392772 -122.403347738299 (37.7525389392772, -122.403347738299) 10 4 8 28859 19
13157 253697 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 865 14th St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003091 2107654 37.7673910038901 -122.432583941874 (37.7673910038901, -122.432583941874) 15 5 5 28862 3
13239 35575 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 99 Hill St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/1998 12:00:00 AM   7X6 Permit Number 38943 6005733.52150857 2103415.89933022 37.7559036789868 -122.423142532595 (37.7559036789868, -122.423142532595) 2 4 5 28859 19
13570 34057 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1718 Bryant St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/1997 12:00:00 AM     Permit Number 37959 6009442.90556489 2106775.8067624 37.7653378532253 -122.410551467879 (37.7653378532253, -122.410551467879) 8 4 7 28859 19
13796 46609 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1078 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/12/2002 12:00:00 AM     Permit Number 44732 6010490.67134457 2102955.14321265 37.7549058552549 -122.406658202843 (37.7549058552549, -122.406658202843) 10 4 7 28859 19
13806 36597 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1325 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/08/2002 12:00:00 AM     Permit Number 39450 6009555.90279082 2101454.80149403 37.7507339080729 -122.409785009854 (37.7507339080729, -122.409785009854) 2 4 7 28859 19
14306 35546 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 110 Bartlett St 1 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
14333 68480 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1218 Hampshire St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/18/1993 12:00:00 AM     Permit Number 32350 6010273.43286101 2102111.66598921 37.7525776974999 -122.407350018785 (37.7525776974999, -122.407350018785) 2 4 7 28859 19
14521 259145 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 115 Wool St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007403 2097606 37.7400450761075 -122.416957288885 (37.7400450761075, -122.416957288885) 2 7 7 28859 2
14868 93885 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 61@ San Jose Duncan St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/15/2010 12:00:00 AM     Permit Number 53373 6006171 2099937 37.7463760977894 -122.421382540818 (37.7463760977894, -122.421382540818) 2 7 5 28859 2
15490 264795 Undocumented 4 Jacaranda mimosifolia :: Jacaranda 50 685 Dwight St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009656 2091058 37.7221921373886 -122.40870548174 (37.7221921373886, -122.40870548174) 10 3 7 309 28
15582 34308 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50   17 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
15956 121747 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1201x Vermont St 10 Front Yard : Yard Tree DPW 1       3x3   6011405 2102539 37.7538143308772 -122.403466904543 (37.7538143308772, -122.403466904543) 10 4 8 28859 19
17028 264796 Undocumented 4 Jacaranda mimosifolia :: Jacaranda 50 685 Dwight St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009656 2091058 37.7221921373886 -122.40870548174 (37.7221921373886, -122.40870548174) 10 3 7 309 28
17101 36665 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1361 York St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/20/1998 12:00:00 AM     Permit Number 39471 6010110.56144118 2101283.13510395 37.750293617943 -122.407854839546 (37.750293617943, -122.407854839546) 2 4 7 28859 19
19118 34336 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50   13 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
19632 121745 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1201x Vermont St 8 Front Yard : Yard Tree DPW 1       3x3   6011405 2102539 37.7538143308772 -122.403466904543 (37.7538143308772, -122.403466904543) 10 4 8 28859 19
19970 42662 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 205 Bartlett St 1 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
21656 255546 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 209 San Carlos St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006712 2104859 37.7599212687364 -122.419861024185 (37.7599212687364, -122.419861024185) 2 4 7 28859 19
21766 36029 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 57 Manchester St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/27/1998 12:00:00 AM     Permit Number 39176 6008256.82211369 2099693.24167493 37.7458241717762 -122.414152744353 (37.7458241717762, -122.414152744353) 2 7 7 28859 2
21984 105306 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 4365 26th St   Sidewalk: Curb side : Cutout Tree Private 2   01/14/2014 12:00:00 AM   3x3 Permit Number 771671 6001537.2 2100535.2 37.7477562656077 -122.437448482105 (37.7477562656077, -122.437448482105) 2 4 5 63 22
22913 96092 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 116 Drake St 2 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
23163 35804 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 233 San Carlos St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/22/1998 12:00:00 AM     Permit Number 39048 6006716.02273257 2104761.27467675 37.7596531643404 -122.41984017695 (37.7596531643404, -122.41984017695) 2 4 7 28859 19
23830 34752 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 667 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/19/2000 12:00:00 AM     Permit Number 38399 6007930.97034241 2104052.78354238 37.7577761801817 -122.415588103657 (37.7577761801817, -122.415588103657) 2 4 7 28859 19
23886 37758 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1301 York St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2009 12:00:00 AM   3x3 Permit Number 52226 6010092.02702876 2101618.78120771 37.7512141902983 -122.40794259966 (37.7512141902983, -122.40794259966) 2 4 7 28859 19
24874 37335 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 822 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/20/2010 12:00:00 AM   3x3 Permit Number 53759 6003062.69037898 2103433.56920909 37.7558011125208 -122.432380395486 (37.7558011125208, -122.432380395486) 2 4 5 28862 22
25134 34329 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50   7 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
25503 94663 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1883 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/22/2010 12:00:00 AM   3x3 Permit Number 53800 6004614 2097695 37.7401321706185 -122.426606846161 (37.7401321706185, -122.426606846161) 2 7 5 63 7
25581 36604 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1449 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/20/1998 12:00:00 AM     Permit Number 39457 6009591.69172547 2100806.68710724 37.748956335196 -122.409615508849 (37.748956335196, -122.409615508849) 2 4 7 28859 19
25857 43125 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 28 Eugenia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/11/2000 12:00:00 AM     Permit Number 42943 6006014.62206932 2098348.860336 37.7420066078017 -122.421810489884 (37.7420066078017, -122.421810489884) 2 7 7 28859 2
25889 52052 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 84 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/29/2005 12:00:00 AM     Permit Number 48254 6005362.31259493 2099645.76538508 37.7455308063117 -122.424158182307 (37.7455308063117, -122.424158182307) 2 7 5 28859 22
26785 33029 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 3428 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/05/1996 12:00:00 AM     Permit Number 37311 6006888.9310023 2100900.56738488 37.7490622873512 -122.418968344047 (37.7490622873512, -122.418968344047) 2 4 7 28859 19
26900 35554 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 117 Fair Oaks St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/1998 12:00:00 AM     Permit Number 38928 6005427.85924462 2103026.46196551 37.754817120668 -122.424171918741 (37.754817120668, -122.424171918741) 2 4 5 28859 19
26942 37739 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1266 Florida St 18 Sidewalk: Curb side : Cutout Tree Private 2   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
27597 34735 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 3246 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM     Permit Number 38385 6008060.11038004 2101550.08300487 37.7509115908716 -122.41496434851 (37.7509115908716, -122.41496434851) 2 4 7 28859 19
28096 35326 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 239 San Carlos St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/20/1998 12:00:00 AM     Permit Number 38793 6006717.55595043 2104727.62386215 37.7595608533974 -122.41983248648 (37.7595608533974, -122.41983248648) 2 4 7 28859 19
28782 81873 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1312 York St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2009 12:00:00 AM   3x3 Permit Number 52224 6010043.81301103 2101548.7849116 37.7510192965024 -122.408104393789 (37.7510192965024, -122.408104393789) 2 4 7 28859 19
29003 40334 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1359 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/17/1999 12:00:00 AM   3x3 Permit Number 41465 6007740.61181979 2101748.78645974 37.7514392269717 -122.416083278537 (37.7514392269717, -122.416083278537) 2 4 7 28859 19
29366 36052 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1401 Bryant St 12 Sidewalk: Curb side : Cutout Tree Private 2   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
29877 39158 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 69 Lapidge St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/19/1998 12:00:00 AM     Permit Number 40827 6006035.82025068 2105107.15671694 37.7605645323651 -122.422217235752 (37.7605645323651, -122.422217235752) 2 4 5 28859 19
30569 44068 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 304 Winfield St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/02/2003 12:00:00 AM     Permit Number 43592 6006646.88740951 2098034.91768842 37.741180227012 -122.419602044821 (37.741180227012, -122.419602044821) 2 7 7 28859 2
30844 36599 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1423 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/20/1998 12:00:00 AM     Permit Number 39452 6009585.61659215 2100916.70354088 37.7492580755485 -122.409644280871 (37.7492580755485, -122.409644280871) 2 4 7 28859 19
31441 50614 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 474 Day St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/08/2003 12:00:00 AM     Permit Number 47214 6002793.31412073 2098675.69251057 37.7427218255103 -122.432972078444 (37.7427218255103, -122.432972078444) 2 7 5 63 22
31864 121730 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1301 Vermont St 5 Front Yard : Yard Tree DPW 1       3x3   6011430 2102074 37.7525389392772 -122.403347738299 (37.7525389392772, -122.403347738299) 10 4 8 28859 19
31962 33030 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 3428 26th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/05/1996 12:00:00 AM     Permit Number 37311 6006888.9310023 2100900.56738488 37.7490622873512 -122.418968344047 (37.7490622873512, -122.418968344047) 2 4 7 28859 19
32241 59724 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 706 Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/1999 12:00:00 AM     Permit Number 19156 6001209.48230507 2102271.53927268 37.7525052007973 -122.438706110204 (37.7525052007973, -122.438706110204) 2 4 5 28862 22
32997 40317 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 999 Valencia St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/13/1999 12:00:00 AM     Permit Number 41459 6006351.75417313 2103777.48351974 37.7569313744996 -122.421030150349 (37.7569313744996, -122.421030150349) 2 4 7 28859 19
34062 121740 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1201x Vermont St 3 Front Yard : Yard Tree DPW 1       3x3   6011405 2102539 37.7538143308772 -122.403466904543 (37.7538143308772, -122.403466904543) 10 4 8 28859 19
34391 121731 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1301 Vermont St 6 Front Yard : Yard Tree DPW 1       3x3   6011430 2102074 37.7525389392772 -122.403347738299 (37.7525389392772, -122.403347738299) 10 4 8 28859 19
34493 34309 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50   18 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
34711 44001 Planning Code 138.1 required 2 Jacaranda mimosifolia :: Jacaranda 50 2701X 17th St 5 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2016 12:00:00 AM   3x3 Permit Number 775718 6009464.30573862 2106385.10315991 37.7642662704227 -122.410449858863 (37.7642662704227, -122.410449858863) 8 4 7 28859 19
35048 46554 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 2169 Folsom St 5 Sidewalk: Curb side : Cutout Tree Private 2   04/02/2002 12:00:00 AM     Permit Number 44694 6008148.92674441 2105809.63139765 37.7626123299985 -122.414958662117 (37.7626123299985, -122.414958662117) 8 4 7 28859 19
35462 50281 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 2890 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/28/2003 12:00:00 AM     Permit Number 46985 6009507.79940806 2102799.18720578 37.7544225953783 -122.410046254665 (37.7544225953783, -122.410046254665) 2 4 7 28859 19
35623 52402 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 92@ MISSION Santa Marina St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/15/2005 12:00:00 AM     Permit Number 48522 6006139.57045617 2097557.41563242 37.7398405238756 -122.421322267329 (37.7398405238756, -122.421322267329) 2 7 7 28859 2
35810 34056 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1718 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/1997 12:00:00 AM     Permit Number 37959 6009442.90556489 2106775.8067624 37.7653378532253 -122.410551467879 (37.7653378532253, -122.410551467879) 8 4 7 28859 19
35946 68105 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 78 Manchester St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/26/1993 12:00:00 AM     Permit Number 31851 6008211.91573535 2099564.22145596 37.7454673885178 -122.414298897694 (37.7454673885178, -122.414298897694) 2 7 7 28859 2
36827 37740 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1266 Florida St 1 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
37084 71739 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1467 Shotwell St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/04/1995 12:00:00 AM   3x3 Permit Number 56975 6008043.26276721 2099626.05915094 37.7456277058322 -122.41488645052 (37.7456277058322, -122.41488645052) 2 7 7 28859 2
37180 44003 Planning Code 138.1 required 2 Jacaranda mimosifolia :: Jacaranda 50 2701X 17th St 9 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2016 12:00:00 AM   3x3 Permit Number 775718 6009464.30573862 2106385.10315991 37.7642662704227 -122.410449858863 (37.7642662704227, -122.410449858863) 8 4 7 28859 19
37473 37697 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 590 Shotwell St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/29/1998 12:00:00 AM     Permit Number 40081 6007854.26822666 2104498.62498081 37.7589960467021 -122.41588494267 (37.7589960467021, -122.41588494267) 2 4 7 28859 19
39039 35325 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 226 San Carlos St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/20/1998 12:00:00 AM     Permit Number 38792 6006662.54340548 2104792.55869269 37.7597360500369 -122.42002735576 (37.7597360500369, -122.42002735576) 2 4 7 28859 19
39458 67919 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 18 Marsily St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/22/1993 12:00:00 AM     Permit Number 31630 6004275.26721169 2095614.00906402 37.734399085455 -122.427629821288 (37.734399085455, -122.427629821288) 2 7 5 28861 25
39886 37737 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1266 Florida St 6 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
40238 46344 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 365 Fair Oaks St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/13/2002 12:00:00 AM     Permit Number 44590 6005506.87362767 2101591.77673747 37.7508822683578 -122.423796657689 (37.7508822683578, -122.423796657689) 2 4 5 28859 19
40292 82604 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1306 York St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2009 12:00:00 AM   3x3 Permit Number 52223 6010041.95956984 2101582.34952093 37.7511113537145 -122.408113170097 (37.7511113537145, -122.408113170097) 2 4 7 28859 19
40413 40242 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 3494 21st St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/13/1999 12:00:00 AM     Permit Number 41413 6005060.66345882 2103723.48995015 37.7567102567185 -122.425491387148 (37.7567102567185, -122.425491387148) 2 4 5 28859 19
41290 36062 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1401 Bryant St 1 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
41565 81287 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 3145 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/02/2008 12:00:00 AM   3x3 Permit Number 50544 6008016.04178081 2102664.62636249 37.7539693984201 -122.415195628809 (37.7539693984201, -122.415195628809) 2 4 7 28859 19
42122 93487 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 643 San Jose Ave   Sidewalk: Curb side : Cutout Tree Private 2   03/05/2010 12:00:00 AM   3x3 Permit Number 53236 6005997.4 2099554.6 37.745316324998 -122.421955670553 (37.745316324998, -122.421955670553) 2 7 5 28859 2
42631 89008 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 707 Carolina St   Sidewalk: Curb side : Cutout Tree Private 2   07/16/2009 12:00:00 AM   3x3 Permit Number 52629 6012436 2104662 37.7597011565358 -122.400050528825 (37.7597011565358, -122.400050528825) 10 3 8 28856 29
42787 39159 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 69 Lapidge St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/19/1998 12:00:00 AM     Permit Number 40827 6006035.82025068 2105107.15671694 37.7605645323651 -122.422217235752 (37.7605645323651, -122.422217235752) 2 4 5 28859 19
43209 39079 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 2280X Alameda St 5 Sidewalk: Curb side : Cutout Tree Private 2   11/18/1998 12:00:00 AM     Permit Number 40778 6010277.76687759 2108009.04739866 37.7687708195348 -122.40775082962 (37.7687708195348, -122.40775082962) 8 4 8 28853 19
45805 34314 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50   24 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
46326 94953 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 763 Brannan St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/09/2010 12:00:00 AM   3x3 Permit Number 53984 6011909 2109793 37.7737603305178 -122.402233924084 (37.7737603305178, -122.402233924084) 14 2 9 28853 34
46591 37747 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1266 Florida St 10 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
47921 35543 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 110 Bartlett St 6 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
48255 50560 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 4175 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/13/2003 12:00:00 AM     Permit Number 47183 6002030.50619515 2102333.72789299 37.7527226291178 -122.435871324431 (37.7527226291178, -122.435871324431) 2 4 5 28862 22

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