trees
192 rows where PlotSize = "" and qSpecies_id = 47
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 53088 | 33391 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 129 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | Permit Number 37510 | 5993545.21642202 | 2093774.31911417 | 37.7287349718633 | -122.464593277929 | (37.7287349718633, -122.464593277929) | 9 | 8 | 4 | 59 | 40 | ||
| 53776 | 191401 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2100 Alameda St | 7 | Front Yard : Yard | Tree | Private 2 | 8 | 6010711.19096 | 2107913.74245 | 37.7685333878424 | -122.406244924566 | (37.7685333878424, -122.406244924566) | 8 | 4 | 8 | 28853 | 19 | ||||
| 54058 | 129472 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 11 Filbert St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6012528.94679 | 2120206.6635 | 37.8023883923599 | -122.400821180758 | (37.8023883923599, -122.400821180758) | 3 | 1 | 10 | 28860 | 6 | ||||
| 54078 | 52269 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 403 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/2005 12:00:00 AM | Permit Number 48434 | 6005520.49766263 | 2101354.49181367 | 37.7502315077339 | -122.423732674774 | (37.7502315077339, -122.423732674774) | 2 | 4 | 5 | 28859 | 19 | ||
| 54154 | 129479 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 12 Filbert St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 6012506.13221 | 2120230.97584 | 37.8024538756 | -122.400901840066 | (37.8024538756, -122.400901840066) | 3 | 1 | 10 | 28860 | 6 | ||||
| 54666 | 31185 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 720 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34883 | 5992147.8527206 | 2089880.99524616 | 37.7179642061069 | -122.469140766842 | (37.7179642061069, -122.469140766842) | 9 | 8 | 6 | 64 | 24 | ||
| 55583 | 191391 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 845 Vermont St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6011306.2123 | 2104378.54497 | 37.7588597960547 | -122.403937978273 | (37.7588597960547, -122.403937978273) | 10 | 3 | 8 | 28856 | 29 | ||||
| 56247 | 35417 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 221 Crestmont Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/1998 12:00:00 AM | Permit Number 38870 | 5995170.62655697 | 2103759.11614599 | 37.7562443131302 | -122.459697089533 | (37.7562443131302, -122.459697089533) | 1 | 5 | 4 | 63 | 12 | |||
| 56934 | 191400 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2100 Alameda St | 6 | Front Yard : Yard | Tree | Private 2 | 18 | 6010721.65743 | 2107914.21049 | 37.7685352584272 | -122.406208754734 | (37.7685352584272, -122.406208754734) | 8 | 4 | 8 | 28853 | 19 | ||||
| 57475 | 45437 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 50 Urbano Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/2001 12:00:00 AM | Permit Number 44224 | 5993813.83621392 | 2092411.23769418 | 37.7250077648019 | -122.463565764966 | (37.7250077648019, -122.463565764966) | 9 | 8 | 4 | 59 | 40 | ||
| 58452 | 101254 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 3700X Cesar Chavez St | 1 | Front Yard : Yard | Tree | DPW 1 | 6005840.6 | 2100555.6 | 37.7480559984104 | -122.422568977073 | (37.7480559984104, -122.422568977073) | 2 | 4 | 5 | 28859 | 19 | |||||
| 59472 | 52106 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 727 Rockdale Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/2005 12:00:00 AM | Permit Number 48298 | 5997405.05193713 | 2098248.96190456 | 37.741243026323 | -122.451572279627 | (37.741243026323, -122.451572279627) | 9 | 7 | 4 | 59 | 40 | ||
| 61805 | 47082 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 175 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2002 12:00:00 AM | 5 | Permit Number 45068 | 5996827.60082146 | 2111762.20695793 | 37.7783138890322 | -122.45454486672 | (37.7783138890322, -122.45454486672) | 15 | 6 | 2 | 54 | 16 | |
| 63156 | 191394 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 845 Vermont St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 6011327.58138 | 2104381.4608 | 37.7588689961229 | -122.403864278838 | (37.7588689961229, -122.403864278838) | 10 | 3 | 8 | 28856 | 29 | ||||
| 63319 | 207110 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 59 Ralston St | 1 | Back Yard : Yard | Tree | Private 2 | 7 | 5992170.63195 | 2088310.84387 | 37.7136542672107 | -122.468947827707 | (37.7136542672107, -122.468947827707) | 9 | 8 | 6 | 64 | 24 | ||||
| 63902 | 46390 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2447 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/05/2002 12:00:00 AM | 7 | Permit Number 44623 | 5982678.99712077 | 2098464.70885711 | 37.7409810943186 | -122.502504874921 | (37.7409810943186, -122.502504874921) | 1 | 8 | 3 | 29491 | 35 | |
| 64604 | 207109 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 75 Ralston St | 2 | Back Yard : Yard | Tree | Private 2 | 14 | 5992170.77084 | 2088338.0326 | 37.7137289289241 | -122.468949325066 | (37.7137289289241, -122.468949325066) | 9 | 8 | 6 | 64 | 24 | ||||
| 66446 | 191396 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2100 Alameda St | 2 | Front Yard : Yard | Tree | Private 2 | 6 | 6010761.04996 | 2107917.30957 | 37.7685459711594 | -122.406072716988 | (37.7685459711594, -122.406072716988) | 8 | 4 | 8 | 28853 | 19 | ||||
| 66800 | 49718 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1195 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2003 12:00:00 AM | Permit Number 46529 | 6014698.72785663 | 2090465.4227663 | 37.7208461876659 | -122.391232442758 | (37.7208461876659, -122.391232442758) | 10 | 3 | 8 | 58 | 1 | |||
| 67862 | 37850 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 211 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/1998 12:00:00 AM | Permit Number 40141 | 6003943.02561838 | 2092441.0681197 | 37.7256681018117 | -122.428552395212 | (37.7256681018117, -122.428552395212) | 9 | 7 | 6 | 28861 | 5 | ||
| 68109 | 50881 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2040 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2004 12:00:00 AM | Permit Number 47391 | 5991642.80129947 | 2101534.85210656 | 37.7499335653235 | -122.471735313093 | (37.7499335653235, -122.471735313093) | 1 | 8 | 4 | 29491 | 12 | ||
| 69319 | 129481 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 11 Greenwich St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6012317.54236 | 2120532.77652 | 37.8032720257522 | -122.401575682271 | (37.8032720257522, -122.401575682271) | 3 | 1 | 10 | 28860 | 6 | ||||
| 69496 | 191376 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 19 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6011285.44743 | 2104312.53247 | 37.7586773802801 | -122.404005147727 | (37.7586773802801, -122.404005147727) | 10 | 3 | 8 | 28856 | 29 | ||||
| 71117 | 52492 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 390ON GATES Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48601 | 6008184.68107457 | 2096494.82661811 | 37.7370379770988 | -122.414175953506 | (37.7370379770988, -122.414175953506) | 2 | 7 | 7 | 28859 | 2 | ||
| 73341 | 47451 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 5049 Anza St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45359 | 5983034.2663237 | 2111680.83899779 | 37.7772897229163 | -122.502254315782 | (37.7772897229163, -122.502254315782) | 11 | 6 | 2 | 55 | 26 | ||
| 73352 | 34348 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 330 Arlington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38106 | 6004294.50938701 | 2096370.47715627 | 37.7364772644099 | -122.427617172202 | (37.7364772644099, -122.427617172202) | 2 | 7 | 5 | 63 | 7 | ||
| 75050 | 49654 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 81 Alpha St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/16/2003 12:00:00 AM | Permit Number 46507 | 6011171.19956943 | 2088331.01703059 | 37.7147891465513 | -122.403276034448 | (37.7147891465513, -122.403276034448) | 10 | 7 | 8 | 309 | 39 | ||
| 76135 | 98307 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 701 04th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2019 12:00:00 AM | 3 | Permit Number 768498 | 5994707.05848 | 2110712.18551 | 37.7753089605415 | -122.461804398804 | (37.7753089605415, -122.461804398804) | 11 | 6 | 2 | 54 | 11 | ||
| 76430 | 30765 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1593 Underwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | Permit Number 34646 | 6014616.43299999 | 2093667.83534348 | 37.7296348056211 | -122.391740711397 | (37.7296348056211, -122.391740711397) | 10 | 3 | 8 | 58 | 1 | ||
| 77625 | 32594 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1379 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/1996 12:00:00 AM | 1 | Permit Number 37062 | 5985531.05347187 | 2105840.85496484 | 37.7614011533067 | -122.49318691517 | (37.7614011533067, -122.49318691517) | 1 | 8 | 3 | 56 | 35 | |
| 77823 | 31942 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1300 La Playa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39715 | 5980916.9213303 | 2106151.77480086 | 37.761983899941 | -122.50916807627 | (37.761983899941, -122.50916807627) | 1 | 8 | 3 | 56 | 35 | ||
| 78182 | 113478 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 100x ESMERALDA AVE | 5 | Unaccepted Street : Yard | Tree | DPW 1 | 8 | 6006917 | 2098966 | 37.7437519821991 | -122.418734104398 | (37.7437519821991, -122.418734104398) | 2 | 7 | 7 | 28859 | 2 | ||||
| 80039 | 129480 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 11 Greenwich St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | 6012320.77236 | 2120522.45554 | 37.8032438670795 | -122.401563778859 | (37.8032438670795, -122.401563778859) | 3 | 1 | 10 | 28860 | 6 | ||||
| 80079 | 129470 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 45 MacOndray Ln | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6008463.14234 | 2119145.61201 | 37.7992473914164 | -122.414815771241 | (37.7992473914164, -122.414815771241) | 5 | 1 | 10 | 308 | 32 | ||||
| 80406 | 247869 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 394 Mayflower St | 1 | Side Yard : Yard | Tree | Private 2 | 9 | 6009720.84865 | 2098403.35069 | 37.7423645372013 | -122.408999330354 | (37.7423645372013, -122.408999330354) | 10 | 7 | 7 | 28859 | 2 | ||||
| 81378 | 50428 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 11 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/2003 12:00:00 AM | Permit Number 47081 | 5996479.47890892 | 2089951.8399169 | 37.7184080697361 | -122.454173429085 | (37.7184080697361, -122.454173429085) | 9 | 8 | 6 | 28861 | 24 | ||
| 82654 | 116655 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 199x Esmeralda Ave | 9 | Unaccepted Street : Yard | Tree | DPW 1 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | 2 | 7 | 7 | 28859 | 2 | |||||
| 83035 | 33301 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1120 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | Permit Number 37453 | 6009052.27411403 | 2116787.86536385 | 37.7928066833324 | -122.412610401728 | (37.7928066833324, -122.412610401728) | 3 | 1 | 10 | 28857 | 21 | ||
| 83616 | 68575 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 7633 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | Permit Number 32467 | 5983299.26193695 | 2112364.72668983 | 37.7791830450299 | -122.501388226383 | (37.7791830450299, -122.501388226383) | 11 | 6 | 2 | 55 | 26 | ||
| 84877 | 31600 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1631 Ortega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/10/1995 12:00:00 AM | Permit Number 35126 | 5988991.64827869 | 2102380.23074862 | 37.7521010026968 | -122.480964913447 | (37.7521010026968, -122.480964913447) | 1 | 8 | 3 | 29491 | 35 | ||
| 86130 | 52103 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 641 Rockdale Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/2005 12:00:00 AM | Permit Number 48295 | 5997742.5728031 | 2098061.02519693 | 37.7407463206184 | -122.450391713191 | (37.7407463206184, -122.450391713191) | 9 | 7 | 4 | 59 | 40 | ||
| 87869 | 116654 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 199x Esmeralda Ave | 9 | Unaccepted Street : Yard | Tree | DPW 1 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | 2 | 7 | 7 | 28859 | 2 | |||||
| 88904 | 116681 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 100 Esmeralda Ave | 20 | Unaccepted Street : Yard | Tree | DPW 1 | 6006917.38983 | 2098966.37493 | 37.7437530336215 | -122.41873278304 | (37.7437530336215, -122.41873278304) | 2 | 7 | 7 | 28859 | 2 | |||||
| 89095 | 46395 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2091 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/05/2002 12:00:00 AM | 9 | Permit Number 44627 | 5981974.76389525 | 2100876.77542895 | 37.7475625528023 | -122.505118527994 | (37.7475625528023, -122.505118527994) | 1 | 8 | 3 | 29491 | 35 | |
| 89540 | 33402 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 377 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1996 12:00:00 AM | Permit Number 37520 | 5992522.58969687 | 2094276.01733921 | 37.730053504422 | -122.468165013068 | (37.730053504422, -122.468165013068) | 9 | 8 | 4 | 59 | 40 | ||
| 90219 | 41465 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 3445 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2000 12:00:00 AM | 24 | Permit Number 42050 | 5983633.32729372 | 2103553.20607522 | 37.755008735539 | -122.499581179885 | (37.755008735539, -122.499581179885) | 1 | 8 | 3 | 56 | 35 | ||
| 90709 | 218280 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1 Woodacre Dr | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 30 | 5991369.16642 | 2095649.34471 | 37.7337576340075 | -122.472252572693 | (37.7337576340075, -122.472252572693) | 1 | 8 | 4 | 64 | 40 | ||||
| 90861 | 31375 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 630 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1995 12:00:00 AM | Permit Number 34977 | 5991276.37232485 | 2099107.33925567 | 37.7432470351435 | -122.472825445815 | (37.7432470351435, -122.472825445815) | 1 | 8 | 4 | 29491 | 40 | ||
| 92382 | 47550 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1681 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45414 | 6003392.60348895 | 2098449.5926945 | 37.7421349817765 | -122.430883775787 | (37.7421349817765, -122.430883775787) | 2 | 7 | 5 | 63 | 22 | ||
| 93238 | 129477 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 12 Filbert St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 6012514.7758 | 2120236.23138 | 37.8024687881724 | -122.400872298239 | (37.8024687881724, -122.400872298239) | 3 | 1 | 10 | 28860 | 6 | ||||
| 95937 | 191368 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 900x Carolina St | 60 | Median : Yard | Tree | DPW 1 | 25 | 6012502.16132 | 2102909.31056 | 37.7548923442165 | -122.399698643387 | (37.7548923442165, -122.399698643387) | 10 | 3 | 8 | 28856 | 29 | ||||
| 95984 | 191373 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 6011285.49599 | 2104337.84522 | 37.7587468861739 | -122.40400676112 | (37.7587468861739, -122.40400676112) | 10 | 3 | 8 | 28856 | 29 | ||||
| 98199 | 191377 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 27 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | 6011285.82751 | 2104250.98235 | 37.7585083985743 | -122.403999501776 | (37.7585083985743, -122.403999501776) | 10 | 3 | 8 | 28856 | 29 | ||||
| 98776 | 129484 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 12 Greenwich St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 6012303.28877 | 2120555.11364 | 37.8033325627054 | -122.401626578498 | (37.8033325627054, -122.401626578498) | 3 | 1 | 10 | 28860 | 6 | ||||
| 99467 | 191408 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2 Tulare St | 5 | Front Yard : Yard | Tree | Private 2 | 3 | 6016232.34971 | 2100308.61772 | 37.7479586171136 | -122.38661714986 | (37.7479586171136, -122.38661714986) | 3 | 8 | 58 | 1 | |||||
| 99585 | 59481 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 701 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2019 12:00:00 AM | 3 | Permit Number 768498 | 5994707.05513 | 2110730.54303 | 37.7753593652253 | -122.461805741777 | (37.7753593652253, -122.461805741777) | 11 | 6 | 2 | 54 | 11 | ||
| 99619 | 67131 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1439 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/1992 12:00:00 AM | Permit Number 30551 | 5994253.6761319 | 2105720.38065143 | 37.7615766669983 | -122.463010486718 | (37.7615766669983, -122.463010486718) | 1 | 5 | 11 | 56 | 12 | ||
| 100650 | 78557 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2234 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2016 12:00:00 AM | 3 | Permit Number 771299 | 5981748.2661 | 2099861.5988 | 37.7447618317919 | -122.505826480334 | (37.7447618317919, -122.505826480334) | 1 | 8 | 3 | 29491 | 35 | |
| 104777 | 47604 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 645 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/2002 12:00:00 AM | Permit Number 45440 | 6008713.69382569 | 2095849.48701302 | 37.7352957148385 | -122.412301312985 | (37.7352957148385, -122.412301312985) | 10 | 7 | 7 | 28859 | 2 | ||
| 105324 | 32605 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1370 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | Permit Number 37071 | 5984960.54583105 | 2105873.44387063 | 37.7614572492102 | -122.49516243722 | (37.7614572492102, -122.49516243722) | 1 | 8 | 3 | 56 | 35 | ||
| 107383 | 54526 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 4530 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/01/2016 12:00:00 AM | 3 | Permit Number 777496 | 5981479.33824 | 2110998.92324 | 37.7753259029383 | -122.507582607669 | (37.7753259029383, -122.507582607669) | 11 | 6 | 2 | 55 | 26 | ||
| 108126 | 50490 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 242 Miramar Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/2003 12:00:00 AM | Permit Number 47126 | 5995378.87438655 | 2091597.86421043 | 37.722864487352 | -122.458096796728 | (37.722864487352, -122.458096796728) | 9 | 8 | 4 | 28861 | 24 | ||
| 108342 | 35388 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 753 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 7 | Permit Number 38842 | 6011306.15832 | 2104840.46729 | 37.7601281288176 | -122.403970671318 | (37.7601281288176, -122.403970671318) | 10 | 3 | 8 | 28856 | 29 | |
| 109823 | 52980 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 531 Arch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/2006 12:00:00 AM | Permit Number 49067 | 5992711.66457877 | 2090721.03501475 | 37.7203033137371 | -122.467252978798 | (37.7203033137371, -122.467252978798) | 9 | 8 | 6 | 64 | 24 | ||
| 111648 | 46761 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 343 Gambier St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2002 12:00:00 AM | Permit Number 44859 | 6006106.65621717 | 2092210.20384218 | 37.7251564045519 | -122.421056498489 | (37.7251564045519, -122.421056498489) | 9 | 7 | 7 | 309 | 5 | |||
| 112053 | 129476 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1077 Front St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | 6012591.30532 | 2120127.94056 | 37.8021757161919 | -122.4005998549 | (37.8021757161919, -122.4005998549) | 3 | 1 | 10 | 28860 | 6 | ||||
| 112785 | 191378 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 28 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6011285.84337 | 2104240.29901 | 37.7584790653842 | -122.40399869511 | (37.7584790653842, -122.40399869511) | 10 | 3 | 8 | 28856 | 29 | ||||
| 113543 | 191379 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 29 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6011295.70989 | 2104243.81406 | 37.758489268176 | -122.403964819445 | (37.758489268176, -122.403964819445) | 10 | 3 | 8 | 28856 | 29 | ||||
| 113634 | 47351 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 246 Monticello St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/2002 12:00:00 AM | Permit Number 45277 | 5991716.56988019 | 2090163.16086716 | 37.7187140338834 | -122.470652049529 | (37.7187140338834, -122.470652049529) | 9 | 8 | 6 | 64 | 24 | ||
| 113892 | 191398 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2100 Alameda St | 4 | Front Yard : Yard | Tree | Private 2 | 14 | 6010740.07849 | 2107915.77093 | 37.7685405734149 | -122.406145147482 | (37.7685405734149, -122.406145147482) | 8 | 4 | 8 | 28853 | 19 | ||||
| 116625 | 45431 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 851 Head St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/2001 12:00:00 AM | Permit Number 44219 | 5993920.58856776 | 2091576.5612161 | 37.7227220958318 | -122.463136201451 | (37.7227220958318, -122.463136201451) | 9 | 8 | 4 | 59 | 40 | ||
| 117562 | 217831 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2 Cranleigh Dr | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | 5991381.66969 | 2095739.82508 | 37.734006793868 | -122.472215938837 | (37.734006793868, -122.472215938837) | 1 | 8 | 4 | 64 | 40 | ||||
| 118845 | 47453 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 5049 Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45359 | 5983034.2663237 | 2111680.83899779 | 37.7772897229163 | -122.502254315782 | (37.7772897229163, -122.502254315782) | 11 | 6 | 2 | 55 | 26 | ||
| 118985 | 227671 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1000 San Jose Ave | 60 | Front Yard : Yard | Tree | Private 2 | 10 | 6005087.18528 | 2097058.71456 | 37.7384118144577 | -122.424925504521 | (37.7384118144577, -122.424925504521) | 2 | 7 | 5 | 63 | 7 | ||||
| 121491 | 31546 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 220 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/10/1995 12:00:00 AM | 6 | Permit Number 35095 | 5998394.38199367 | 2112672.66987383 | 37.7809035197163 | -122.449190424029 | (37.7809035197163, -122.449190424029) | 15 | 6 | 2 | 54 | 16 | |
| 121679 | 227674 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1000 San Jose Ave | 83 | Front Yard : Yard | Tree | Private 2 | 15 | 6005065.10158 | 2097012.05309 | 37.7382824451638 | -122.424998540269 | (37.7382824451638, -122.424998540269) | 2 | 7 | 5 | 63 | 7 | ||||
| 121895 | 50489 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 242 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/2003 12:00:00 AM | Permit Number 47126 | 5995378.87438655 | 2091597.86421043 | 37.722864487352 | -122.458096796728 | (37.722864487352, -122.458096796728) | 9 | 8 | 4 | 28861 | 24 | ||
| 122107 | 46973 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1783 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/2002 12:00:00 AM | 7 | Permit Number 44992 | 5982214.0178657 | 2102979.50871383 | 37.7533501437558 | -122.504446973742 | (37.7533501437558, -122.504446973742) | 1 | 8 | 3 | 56 | 35 | |
| 122548 | 191380 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 30 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 6011289.9844 | 2104226.04846 | 37.7584401679041 | -122.403983370659 | (37.7584401679041, -122.403983370659) | 10 | 3 | 8 | 28856 | 29 | ||||
| 123096 | 45360 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 458 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46747 | 5993277.37926203 | 2090218.01876098 | 37.7189547935486 | -122.46526098645 | (37.7189547935486, -122.46526098645) | 9 | 8 | 6 | 64 | 24 | ||
| 128532 | 52554 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1719 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/12/2006 12:00:00 AM | 8 | Permit Number 48649 | 5984370.92860727 | 2103469.2332855 | 37.754821420905 | -122.497024185091 | (37.754821420905, -122.497024185091) | 1 | 8 | 3 | 56 | 35 | |
| 129532 | 52497 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 371 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48606 | 6007135.79724675 | 2096038.97616324 | 37.7357273409345 | -122.417770123047 | (37.7357273409345, -122.417770123047) | 2 | 7 | 7 | 28859 | 2 | ||
| 129636 | 45429 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 851 Head St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/2001 12:00:00 AM | Permit Number 44219 | 5993920.58856776 | 2091576.5612161 | 37.7227220958318 | -122.463136201451 | (37.7227220958318, -122.463136201451) | 9 | 8 | 4 | 59 | 40 | ||
| 131273 | 207113 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 53 Ralston St | 1 | Back Yard : Yard | Tree | Private 2 | 5 | 5992170.39113 | 2088282.95309 | 37.7135776719473 | -122.468946631596 | (37.7135776719473, -122.468946631596) | 9 | 8 | 6 | 64 | 24 | ||||
| 134216 | 68097 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 49 Bessie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/1993 12:00:00 AM | Permit Number 31842 | 6008240.85722104 | 2100065.07433688 | 37.7468442446896 | -122.414234251858 | (37.7468442446896, -122.414234251858) | 2 | 7 | 7 | 28859 | 2 | ||
| 135265 | 218293 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1 Woodacre Dr | 17 | Sidewalk: Curb side : Yard | Tree | Private 2 | 22 | 5991192.67429 | 2095369.91493 | 37.7329801745819 | -122.472842384068 | (37.7329801745819, -122.472842384068) | 1 | 8 | 4 | 64 | 40 | ||||
| 135665 | 191404 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2 Tulare St | 14 | Front Yard : Yard | Tree | Private 2 | 20 | 6016173.59275 | 2100299.3088 | 37.7479298037296 | -122.3868196817 | (37.7479298037296, -122.3868196817) | 3 | 8 | 58 | 1 | |||||
| 136204 | 35418 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 221 Crestmont Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/1998 12:00:00 AM | Permit Number 38870 | 5995170.62655697 | 2103759.11614599 | 37.7562443131302 | -122.459697089533 | (37.7562443131302, -122.459697089533) | 1 | 5 | 4 | 63 | 12 | |||
| 136897 | 102790 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 3445 Moraga St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Permit Number 42050 | 5983633 | 2103554 | 37.7550108962308 | -122.499582370415 | (37.7550108962308, -122.499582370415) | 1 | 8 | 3 | 56 | 35 | |||
| 137363 | 84886 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 3138 Santiago St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2007 12:00:00 AM | Permit No. 49329 | 5983290 | 2099514 | 37.7438980447125 | -122.500469849117 | (37.7438980447125, -122.500469849117) | 1 | 8 | 3 | 29491 | 35 | |||
| 137505 | 34621 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 370 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2016 12:00:00 AM | 3 | Permit Number 778228 | 6003497.10528776 | 2099542.95496323 | 37.7451430220882 | -122.430600441889 | (37.7451430220882, -122.430600441889) | 2 | 7 | 5 | 63 | 22 | |
| 137534 | 50423 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 75 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/2003 12:00:00 AM | Permit Number 47076 | 5995600.08487961 | 2090390.5729412 | 37.7195622602365 | -122.457244829317 | (37.7195622602365, -122.457244829317) | 9 | 8 | 6 | 28861 | 24 | ||
| 138353 | 129473 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 11 Filbert St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 6012532.2991 | 2120205.04389 | 37.8023841322847 | -122.400809466192 | (37.8023841322847, -122.400809466192) | 3 | 1 | 10 | 28860 | 6 | ||||
| 138561 | 36089 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1706 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/2002 12:00:00 AM | Permit Number 44997 | 5981032.08177403 | 2103436.82774177 | 37.7545362217712 | -122.508568229446 | (37.7545362217712, -122.508568229446) | 1 | 8 | 3 | 56 | 35 | ||
| 139775 | 51442 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 775 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2004 12:00:00 AM | Permit Number 47761 | 6007380.25742092 | 2095203.71769531 | 37.7334476580973 | -122.416865768693 | (37.7334476580973, -122.416865768693) | 2 | 7 | 7 | 28859 | 2 | ||
| 141197 | 227672 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1000 San Jose Ave | 62 | Front Yard : Yard | Tree | Private 2 | 15 | 6005095.2123 | 2097053.48648 | 37.7383979127325 | -122.424897379118 | (37.7383979127325, -122.424897379118) | 2 | 7 | 5 | 28859 | 7 | ||||
| 142860 | 207111 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 59 Ralston St | 2 | Back Yard : Yard | Tree | Private 2 | 11 | 5992171.5605 | 2088305.6585 | 37.713640083085 | -122.468944241206 | (37.713640083085, -122.468944241206) | 9 | 8 | 6 | 64 | 24 | ||||
| 145003 | 129486 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 12 Greenwich St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 6012297.60436 | 2120565.6201 | 37.803361093695 | -122.401646988622 | (37.803361093695, -122.401646988622) | 3 | 1 | 10 | 28860 | 6 | ||||
| 145811 | 129483 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 12 Greenwich St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | 6012307.75016 | 2120551.40866 | 37.8033226386787 | -122.401610879045 | (37.8033226386787, -122.401610879045) | 3 | 1 | 10 | 28860 | 6 | ||||
| 145902 | 31168 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 570 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34869 | 5993027.58275469 | 2090995.29108117 | 37.7210745862886 | -122.466180882741 | (37.7210745862886, -122.466180882741) | 9 | 8 | 6 | 64 | 24 |
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) );