trees
655 rows where Zip Codes = 28859 and qSpecies_id = 50 sorted by DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||||
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 | ||||
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 | ||
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 | ||||
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 | |||
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 | |||
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 | ||||
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 | |||
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 | ||||
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 | ||
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 | ||
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 | ||
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 | |
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 | ||
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 | ||
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 | ||||
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 | ||
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 | ||
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 | |||
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 | ||
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 | ||
48641 | 39193 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 862 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40846 | 6009896.76562705 | 2104189.54699772 | 37.758262004919 | -122.408799187601 | (37.758262004919, -122.408799187601) | 2 | 4 | 7 | 28859 | 19 | ||
49291 | 35310 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3620 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1998 12:00:00 AM | Permit Number 38778 | 6005440.34891977 | 2105498.91525501 | 37.7616066031849 | -122.424304565555 | (37.7616066031849, -122.424304565555) | 8 | 4 | 5 | 28859 | 19 | ||
49552 | 35556 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 121 Fair Oaks St | 1 | 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 | ||
50375 | 52627 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 642@ 18th ST Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/2006 12:00:00 AM | Permit Number 48710 | 6010085.91969508 | 2105298.86686021 | 37.7613185401792 | -122.408223245875 | (37.7613185401792, -122.408223245875) | 2 | 4 | 8 | 28859 | 19 | |||
51327 | 111062 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1851 Bryant St | 11 | 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 | ||||
51672 | 111057 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1851 Bryant St | 6 | 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 | ||||
52832 | 37699 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 590 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/2004 12:00:00 AM | 3x3 | Permit Number 40081 | 6007854.26822666 | 2104498.62498081 | 37.7589960467021 | -122.41588494267 | (37.7589960467021, -122.41588494267) | 2 | 4 | 7 | 28859 | 19 | |
52895 | 121751 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 14 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
53978 | 34556 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2 Nebraska St | 1 | 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 | ||
55105 | 39192 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1081 Treat Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/1998 12:00:00 AM | Permit Number 40845 | 6008661.50268126 | 2102262.13718449 | 37.7529005072206 | -122.412935008702 | (37.7529005072206, -122.412935008702) | 2 | 4 | 7 | 28859 | 19 | |||
55486 | 37153 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 170 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1998 12:00:00 AM | Permit Number 39733 | 6005417.81804662 | 2100232.85413732 | 37.7471459516063 | -122.42400799468 | (37.7471459516063, -122.42400799468) | 2 | 7 | 5 | 28859 | 22 | |||
56577 | 35969 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 176 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39127 | 6006023.56999156 | 2096341.44627535 | 37.7364952030819 | -122.421637006977 | (37.7364952030819, -122.421637006977) | 2 | 7 | 7 | 28859 | 2 | ||
56791 | 42908 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2728 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/03/2008 12:00:00 AM | 3x3 | Permit Number 51144 | 6009776.67669238 | 2103983.6124683 | 37.7576898279618 | -122.409199977722 | (37.7576898279618, -122.409199977722) | 2 | 4 | 7 | 28859 | 19 | ||
56905 | 34792 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1171 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38428 | 6008691.00817577 | 2101734.24862099 | 37.7514527000041 | -122.412795655117 | (37.7514527000041, -122.412795655117) | 2 | 4 | 7 | 28859 | 19 | ||
56991 | 35544 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 110 Bartlett St | 5 | 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 | ||
57222 | 95619 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3246 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767387 | 6007152 | 2106175 | 37.7635594768753 | -122.418432588523 | (37.7635594768753, -122.418432588523) | 8 | 4 | 7 | 28859 | 19 | |
57918 | 69428 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 689 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/10/1994 12:00:00 AM | Permit Number 33534 | 6009310.24317295 | 2105050.63111101 | 37.7605934769524 | -122.410888462342 | (37.7605934769524, -122.410888462342) | 2 | 4 | 7 | 28859 | 19 | ||
59383 | 34753 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 667 Shotwell St | 2 | 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 | ||
60196 | 121738 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 1 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
61102 | 68472 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2753 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | Permit Number 32338 | 6009679.35333294 | 2103342.23929983 | 37.7559233085758 | -122.409491298475 | (37.7559233085758, -122.409491298475) | 2 | 4 | 7 | 28859 | 19 | ||
61242 | 37731 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1266 Florida St | 11 | 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 | ||
61584 | 40245 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3494 21st St | 1 | 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 | ||
61704 | 121736 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 Vermont St | 11 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011430 | 2102074 | 37.7525389392772 | -122.403347738299 | (37.7525389392772, -122.403347738299) | 10 | 4 | 8 | 28859 | 19 | ||||
61958 | 34774 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1139 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/1999 12:00:00 AM | Permit Number 38415 | 6008083.82317224 | 2101294.64403942 | 37.750211545435 | -122.414864270544 | (37.750211545435, -122.414864270544) | 2 | 4 | 7 | 28859 | 19 | ||
62540 | 35320 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 266 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/1998 12:00:00 AM | 3x3 | Permit Number 49714 | 6006478.26782541 | 2104557.18271924 | 37.7590793783837 | -122.420647965923 | (37.7590793783837, -122.420647965923) | 2 | 4 | 7 | 28859 | 19 | ||
63482 | 88536 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1306 York St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52223 | 6010027.5 | 2101589.4 | 37.7511299031436 | -122.40816367022 | (37.7511299031436, -122.40816367022) | 2 | 4 | 7 | 28859 | 19 | |||
64355 | 36539 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3770 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39412 | 6008405.93467714 | 2097334.19751076 | 37.7393551313718 | -122.413470323165 | (37.7393551313718, -122.413470323165) | 2 | 7 | 7 | 28859 | 2 | ||
66452 | 35577 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 267 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38946 | 6006724.71096873 | 2104570.58669243 | 37.7591300688749 | -122.419796597864 | (37.7591300688749, -122.419796597864) | 2 | 4 | 7 | 28859 | 19 | ||
66845 | 121803 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 21 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
67944 | 34742 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2901 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38391 | 6008387.19520521 | 2101524.63770013 | 37.7508600981217 | -122.413831454694 | (37.7508600981217, -122.413831454694) | 2 | 4 | 7 | 28859 | 19 | ||
69087 | 35795 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 230 Lexington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/1998 12:00:00 AM | Permit Number 779148 | 6006467.16362039 | 2104758.98191383 | 37.7596328461688 | -122.42070069541 | (37.7596328461688, -122.42070069541) | 2 | 4 | 7 | 28859 | 19 | ||
69251 | 36608 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1457 Florida St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1998 12:00:00 AM | Permit Number 39460 | 6009593.56099734 | 2100772.83589567 | 37.7488634920028 | -122.409606655966 | (37.7488634920028, -122.409606655966) | 2 | 4 | 7 | 28859 | 19 | ||
70598 | 40721 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 58 Bronte St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/12/1999 12:00:00 AM | Permit Number 41700 | 6009320.76573459 | 2097115.38530681 | 37.7388056449049 | -122.410291784296 | (37.7388056449049, -122.410291784296) | 10 | 7 | 7 | 28859 | 2 |
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) );