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

View and edit SQL

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant ▲ PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
14210 85214 - 12 Jacaranda mimosifolia :: Jacaranda 50 2889 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1 Private 04/13/2007 12:00:00 AM 3 3x3 under 3yr maintenance agreement. ends on 4/13/2007 6009588.01504 2102148.81833 37.7526413233918 -122.409722943913 (37.7526413233918, -122.409722943913) 2 4 7 28859 19
175730 254646 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 67 Saint Charles Ave 31 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 Private     3x3   5992096 2088072 37.7129941473192 -122.469188407447 (37.7129941473192, -122.469188407447) 9 8 6 64 24
104 260590 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 3099x Jennings St 3 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 08/20/2020 12:00:00 AM 3                        
779 69766 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1725 Newcomb Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6014547.15395 2096165.56329 37.7364892123042 -122.392154828809 (37.7364892123042, -122.392154828809) 10 3 8 58 1
852 108444 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1 Sycamore St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/22/2014 12:00:00 AM 2 3x2.5   6014877 2117007 37.7937335561349 -122.392471758503 (37.7937335561349, -122.392471758503) 12 2 9 28855 6
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
1622 78494 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 2131 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     6012056.35315 2102319.00627 37.7532466361332 -122.401198904113 (37.7532466361332, -122.401198904113) 10 3 8 28856 29
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
3571 102167 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 677 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/31/2012 12:00:00 AM 4 3x3 Permit Number 769761 6002448.6 2104297.1 37.7581373205651 -122.4345658575 (37.7581373205651, -122.4345658575) 2 4 5 28862 3
3601 32960 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 934 Minnesota St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/01/1996 12:00:00 AM 16 6x12 Permit Number 37274 6015218.03519 2104239.88822 37.7586968478982 -122.390399274809 (37.7586968478982, -122.390399274809) 10 3 8 28856 29
3966 249038 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 22 Carr St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/19/2019 12:00:00 AM 3 4x6   6013079.09197 2090984.85367 37.7221824230653 -122.396867469658 (37.7221824230653, -122.396867469658) 10 3 8 58 1
4309 69898 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1019 Rhode Island St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     6011946.5334 2103437.3528 37.756311243277 -122.401657284058 (37.756311243277, -122.401657284058) 10 3 8 28856 29
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
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
6650 41645 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 146 Blake St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/05/2000 12:00:00 AM 3 3x3 Permit Number 42118 5997898.0776 2112825.6252 37.7812950956289 -122.450918408743 (37.7812950956289, -122.450918408743) 15 6 2 54 16
7992 249041 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 21 Carr St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/19/2019 12:00:00 AM 3 4x6   6013113.97722 2090973.86381 37.7221541888428 -122.396746108866 (37.7221541888428, -122.396746108866) 10 3 8 58 1
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
9700 261108 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1324 Fitzgerald Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/19/2019 12:00:00 AM 3 4x6   6014006 2091032 37.7223634274326 -122.393666646077 (37.7223634274326, -122.393666646077) 10 3 8 58 1
9747 261106 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 85 Carr St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/19/2019 12:00:00 AM 3 4x6   6013023 2090614 37.7211610112065 -122.397035377595 (37.7211610112065, -122.397035377595) 10 3 8 58 1
10372 260929 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 925 Cole St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 09/21/2019 12:00:00 AM 3     5998050.49977 2107087.50026 37.7655484062222 -122.449977421621 (37.7655484062222, -122.449977421621) 15 5 11 29492 9
10488 260919 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 630 Cole St   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 09/21/2019 12:00:00 AM 3     5997903.7812 2108434.36371 37.7692381539002 -122.450581995995 (37.7692381539002, -122.450581995995) 15 5 11 29492 9
10612 78436 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1379 Rhode Island St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6012015.72942 2101977.35144 37.7523062600388 -122.401315382525 (37.7523062600388, -122.401315382525) 10 3 8 28856 29
10911 78495 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1300 Rhode Island St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6011953.72275 2102256.16538 37.7530683626141 -122.401549406774 (37.7530683626141, -122.401549406774) 10 3 8 28856 29
10948 261107 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1324 Fitzgerald Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/19/2019 12:00:00 AM 3 4x6   6014006 2091032 37.7223634274326 -122.393666646077 (37.7223634274326, -122.393666646077) 10 3 8 58 1
11458 35362 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 979 Rhode Island St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/23/1998 12:00:00 AM 6   Permit Number 38824 6011922.43629 2103880.66513 37.75752713659 -122.401771780343 (37.75752713659, -122.401771780343) 10 3 8 28856 29
11549 70665 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 550 Utah St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10     6010647.04803 2105639.57925 37.7622854639243 -122.406306536234 (37.7622854639243, -122.406306536234) 8 4 8 28859 19
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
11826 43301 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 515 Texas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/31/2005 12:00:00 AM 6   Permit Number 48334 6013838.69916 2104687.66336 37.7598497302126 -122.395201050183 (37.7598497302126, -122.395201050183) 10 3 8 28856 29
12120 70682 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 414 Utah St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6010606.08274 2106339.87511 37.7642060264098 -122.406497569303 (37.7642060264098, -122.406497569303) 8 4 8 28859 19
12203 260589 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 3099x Jennings St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 08/20/2020 12:00:00 AM 3                        
12212 72455 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 548 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     6010352.2868 2119601.9151 37.8006062535339 -122.408310850279 (37.8006062535339, -122.408310850279) 3 1 10 308 23
12527 260588 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 3099x Jennings St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 08/20/2020 12:00:00 AM 3                        
12628 259370 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1466 Shafter Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 04/27/2019 12:00:00 AM 3     6015644.90497 2093658.91441 37.7296673488753 -122.388184521919 (37.7296673488753, -122.388184521919) 10 3 8 58 1
13205 69888 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1094 De Haro St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10     6012175.72633 2103309.76161 37.7559736926594 -122.400855686861 (37.7559736926594, -122.400855686861) 10 3 8 28856 29
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
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
13967 84622 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 382 Texas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     6013742.24361 2105343.88141 37.761646197043 -122.395580621644 (37.761646197043, -122.395580621644) 10 3 8 28856 29
14099 38381 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1464 Rhode Island St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/17/2005 12:00:00 AM 5   Permit Number 48279 6011990.10357 2101552.61207 37.7511385883967 -122.401374155011 (37.7511385883967, -122.401374155011) 10 3 8 28856 29
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
14471 70661 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 460 Utah St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10     6010614.613 2106160.28585 37.7637133921776 -122.40645540999 (37.7637133921776, -122.40645540999) 8 4 8 28859 19
14592 259355 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1924 Jennings St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 05/25/2019 12:00:00 AM 3     6015758.71756 2093108.46198 37.728162221452 -122.387752664752 (37.728162221452, -122.387752664752) 10 3 8 58 1
14660 78429 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 744 Rhode Island St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4 3x3   6011805.9335 2104893.37298 37.7603013058687 -122.402245896623 (37.7603013058687, -122.402245896623) 10 3 8 28856 29
15198 70134 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 342-344 Utah St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6010584.92199 2106684.72003 37.7651517084965 -122.406595061225 (37.7651517084965, -122.406595061225) 8 4 8 28853 19
16507 260930 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 515 Shrader St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 09/21/2019 12:00:00 AM 3     5997474.23163 2108775.61542 37.7701505477721 -122.452092402813 (37.7701505477721, -122.452092402813) 15 5 11 29492 9
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
17748 78435 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 2036 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     6011985.6646 2103761.39443 37.7572031738156 -122.401544727608 (37.7572031738156, -122.401544727608) 10 3 8 28856 29
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
20229 37987 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 613 Texas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/08/1998 12:00:00 AM 8   Permit Number 40209 6013866.01576 2104192.39502 37.7584913501141 -122.39507188416 (37.7584913501141, -122.39507188416) 10 3 8 28856 29
20654 37663 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 3236 18th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/29/1998 12:00:00 AM 12 6x6 Permit Number 40069 6007902.47556564 2105636.26552701 37.7621224556474 -122.415798773861 (37.7621224556474, -122.415798773861) 8 4 7 28859 19
21580 39574 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 863 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/1998 12:00:00 AM 7   Permit Number 40991 6011617.31177 2104338.8923 37.7587682945481 -122.402859256767 (37.7587682945481, -122.402859256767) 10 3 8 28856 29
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
22460 65976 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 59 & 1/2 Manchester St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/26/1993 12:00:00 AM 8 6x6 Permit Number 31847 6008257.4720065 2099681.55363989 37.7457921155362 -122.414149670347 (37.7457921155362, -122.414149670347) 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
24397 47676 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 434 Pennsylvania Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/21/2002 12:00:00 AM 6   Permit Number 45460 6014318.70228 2105083.22351 37.7609625351244 -122.393568625994 (37.7609625351244, -122.393568625994) 10 3 8 28856 29
24742 37969 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 601 Missouri St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/08/1998 12:00:00 AM 8   Permit Number 40199 6013584.10507 2104296.87899 37.7587625595637 -122.396054186654 (37.7587625595637, -122.396054186654) 10 3 8 28856 29
24801 35349 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1162 De Haro St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/23/1998 12:00:00 AM 12   Permit Number 38812 6012188.57169 2103037.28239 37.7552262409021 -122.400792120955 (37.7552262409021, -122.400792120955) 10 3 8 28856 29
24866 255162 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 598 Moultrie St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/16/2018 12:00:00 AM 3 3x3 Permit Number 779511 6007652.9891 2096583.60222 37.7372518561065 -122.416020541778 (37.7372518561065, -122.416020541778) 2 7 7 28859 2
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
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
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
26909 35338 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 738 Arkansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/23/1998 12:00:00 AM 4   Permit Number 38803 6013013.2913 2103555.40384 37.7566948554054 -122.397976322051 (37.7566948554054, -122.397976322051) 10 3 8 28856 29
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
28887 37673 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 8 0x0 Permit Number 40071 6008076 2104474 37.758940895326 -122.415116344354 (37.758940895326, -122.415116344354) 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
29492 94652 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 463 Arlington St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/27/2017 12:00:00 AM 3 3x3 Permit Number 779226 6003847 2095961 37.735327609986 -122.429135213798 (37.735327609986, -122.429135213798) 2 7 5 63 7
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
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
35141 32262 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 10 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/22/1995 12:00:00 AM 3   Permit Number 35561 6005748.8799 2099664.71545 37.7456046578383 -122.422822837406 (37.7456046578383, -122.422822837406) 2 7 5 28859 22
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
35536 34771 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1112 Shotwell St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM 11   Permit Number 38413 6008023.83866277 2101437.17080746 37.7505995211504 -122.415081788574 (37.7505995211504, -122.415081788574) 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
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
39204 108736 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1351 Minna St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/05/2015 12:00:00 AM 3 3x3   6006994.99302 2107616.27188 37.76750803134 -122.419077863332 (37.76750803134, -122.419077863332) 8 4 7 28853 19
39242 49995 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 908@ 20TH ST Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/2003 12:00:00 AM 7   Permit Number 46738 6011567.97706 2104146.58896 37.7582375173758 -122.403016353927 (37.7582375173758, -122.403016353927) 10 3 8 28856 29
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
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
40910 50150 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 541@ 20TH ST Mississippi St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/07/2003 12:00:00 AM 6   Permit Number 46869 6014129.22762 2104572.8122 37.7595505266559 -122.394188205843 (37.7595505266559, -122.394188205843) 10 3 8 28856 29
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
41443 108489 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 131 08th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/23/2014 12:00:00 AM 3 3x3 Permit Number 773695 6008906.91703 2111099.40816 37.7771793890601 -122.412711016861 (37.7771793890601, -122.412711016861) 8 2 9 28853 34
42211 37964 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 422 Missouri St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/08/1998 12:00:00 AM 6   Permit Number 40195 6013476.64244 2105094.41315 37.760946434546 -122.396481747729 (37.760946434546, -122.396481747729) 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

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