8,659 rows where qSpecies_id = 11 sorted by qLegalStatus_id 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)
29768 87422 - 12 Lophostemon confertus :: Brisbane Box 11 45X Jones St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/22/2008 12:00:00 AM       6009092.517834 2112687.614007 37.7815506408215 -122.412181237011 (37.7815506408215, -122.412181237011) 7 10 9 28852 36
63001 85312 - 12 Lophostemon confertus :: Brisbane Box 11 1366 Turk St 2 Sidewalk: Curb side : Cutout Tree DPW 1     9 3x3   6003535.85294 2112477.60862 37.7806606630436 -122.431389631549 (37.7806606630436, -122.431389631549) 15 9 11 29490 41
127776 87423 - 12 Lophostemon confertus :: Brisbane Box 11 45X Jones St 2 Sidewalk: Curb side : Cutout Tree DPW 1   04/22/2008 12:00:00 AM 3 3x3   6009092.517834 2112687.614007 37.7815506408215 -122.412181237011 (37.7815506408215, -122.412181237011) 7 10 9 28852 36
161715 85436 - 12 Lophostemon confertus :: Brisbane Box 11 1397X Buchanan St 7 Sidewalk: Curb side : Cutout Tree DPW 1 Private 08/17/2007 12:00:00 AM 3 3x3 Maintenance agreement ends 8/17/2010 6004184.830731 2113056.513958 37.782286952179 -122.429185796304 (37.782286952179, -122.429185796304) 7 9 11 29490 41
176108 87410 - 12 Lophostemon confertus :: Brisbane Box 11 898X Ellis St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/22/2008 12:00:00 AM 3 3x3   6006570.640875 2113589.260791 37.7838845156579 -122.420969775985 (37.7838845156579, -122.420969775985) 7 9 9 28858 36
963 109935 Section 143 10 Lophostemon confertus :: Brisbane Box 11 260 05th St 4 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011302 2112245.5 37.7804604268654 -122.404506314811 (37.7804604268654, -122.404506314811) 14 2 9 28853 34
12295 108536 Section 143 10 Lophostemon confertus :: Brisbane Box 11 1036X Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009831.24398 2112235.16984 37.7803497589148 -122.409593644194 (37.7803497589148, -122.409593644194) 14 2 9 28853 34
23173 109936 Section 143 10 Lophostemon confertus :: Brisbane Box 11 260 05th St 5 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011302 2112245.5 37.7804604268654 -122.404506314811 (37.7804604268654, -122.404506314811) 14 2 9 28853 34
26043 100060 Section 143 10 Lophostemon confertus :: Brisbane Box 11 260 05th St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011435 2112345 37.7807410625565 -122.404053207068 (37.7807410625565, -122.404053207068) 14 2 9 28853 34
52698 118340 Section 143 10 Lophostemon confertus :: Brisbane Box 11 1 Franklin St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006507 2110162 37.7744705012603 -122.420946535292 (37.7744705012603, -122.420946535292) 7 9 11 28852 10
102447 100059 Section 143 10 Lophostemon confertus :: Brisbane Box 11 260 05th St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011435 2112345 37.7807410625565 -122.404053207068 (37.7807410625565, -122.404053207068) 14 2 9 28853 34
148956 32654 Section 143 10 Lophostemon confertus :: Brisbane Box 11 260 05th St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011426.1069309 2112339.71009356 37.7807260408269 -122.40408360027 (37.7807260408269, -122.40408360027) 14 2 9 28853 34
168085 118341 Section 143 10 Lophostemon confertus :: Brisbane Box 11 1 Franklin St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006507 2110162 37.7744705012603 -122.420946535292 (37.7744705012603, -122.420946535292) 7 9 11 28852 10
51620 26198 Private 9 Lophostemon confertus :: Brisbane Box 11 3830 03rd St 3 Sidewalk: Curb side : Cutout Tree Private 2     1 3x4   6015747.5106038 2098323.3315623 37.742480578689 -122.388155190044 (37.742480578689, -122.388155190044) 10 3 8 58 1
132854 25212 Private 9 Lophostemon confertus :: Brisbane Box 11 215X Fell St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 3X3   6006420.22763 2110742.05634 37.7760583047566 -122.421287897592 (37.7760583047566, -122.421287897592) 7 9 11 28852 10
80950 255115 Property Tree 8 Lophostemon confertus :: Brisbane Box 11 301X Chester Ave 2 Sidewalk: Property side : Cutout Tree Private 2       10x10   5991786 2087190 37.7105544703116 -122.470195673297 (37.7105544703116, -122.470195673297) 9 8 4 64 24
236 27345 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 664 Fell St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/01/2008 12:00:00 AM 4 4x4   6004282.41706 2110648.93551 37.7756818605142 -122.428676512776 (37.7756818605142, -122.428676512776) 7 9 11 28852 10
633 9792 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 997X Gough St 3 Sidewalk: Curb side : Cutout Tree Rec/Park 5     36 3x3   6005630.9126204 2113075.2727517 37.7824202152127 -122.424184324881 (37.7824202152127, -122.424184324881) 7 9 11 28852 41
843 38804 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   2 Sidewalk: Curb side : Cutout Tree Private 2   10/23/1998 12:00:00 AM     Permit Number 40645                    
958 36868 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   2 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
1017 46142 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   3 Sidewalk: Curb side : Cutout Tree Private 2   12/27/2001 12:00:00 AM     Permit Number 44490                    
1036 82363 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1455 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/21/2007 12:00:00 AM   3x3 Permit Number 49901 6007633.52614619 2107338.64546667 37.7667816713746 -122.416849584537 (37.7667816713746, -122.416849584537) 8 4 7 28853 19
1183 47616 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1209 Houston St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/20/2002 12:00:00 AM     Permit Number 45446                    
1472 2091 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 943 Bosworth St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/08/1992 12:00:00 AM 6 2X2   6001433.65825 2095553.49813 37.7340717929056 -122.437449841319 (37.7340717929056, -122.437449841319) 9 7 5 63 40
1602 45381 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   4 Sidewalk: Curb side : Cutout Tree Private 2   07/06/2001 12:00:00 AM     Permit Number 44200 5989322.60767277 2117225.76237725 37.7928819736725 -122.480907237859 (37.7928819736725, -122.480907237859) 11   1 61 30
1665 47611 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1201 Houston St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/01/1994 12:00:00 AM     Permit Number 45444                    
1676 84541 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 838 31st Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   10/08/2008 12:00:00 AM   3x3 Permit Number 51852 5986369.18358167 2110196.92433931 37.7734106873115 -122.49060871536 (37.7734106873115, -122.49060871536) 11 6 2 55 26
2157 66537 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 17 Hattie St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/16/1995 12:00:00 AM     Permit Number 29712 6000633.94026001 2105546.19436908 37.76146384633 -122.440931323073 (37.76146384633, -122.440931323073) 15 5 5 28862 3
2283 49626 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 152211th/10th Houston St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/13/2003 12:00:00 AM     Permit Number 46481                    
2296 32307 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1097 Houston St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/19/1996 12:00:00 AM     Permit Number 36882                    
2310 91800 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 530X Harrison St 4 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2017 12:00:00 AM 3 3x3 Permit Number 778971 6014458 2114030 37.785536126129 -122.39371308036 (37.785536126129, -122.39371308036) 6 2 9 28855 6
2315 87492 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 2085 03rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/11/2010 12:00:00 AM 3 3x3   6015789.87829 2105903.76161 37.7632971922443 -122.388537703233 (37.7632971922443, -122.388537703233) 14 3 8 28856 29
2403 60302 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1200 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/1982 12:00:00 AM   3x3 Permit Number 19869 5992068.87064248 2106619.25975245 37.7639186591654 -122.470632238353 (37.7639186591654, -122.470632238353) 11 8 11 56 12
2484 20118 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 875X Fell St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/06/1992 12:00:00 AM 12 2X2   6003233.15229 2110304.12624 37.774675660821 -122.432281545934 (37.774675660821, -122.432281545934) 15 9 11 29492 10
2552 42536 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 95 Brady St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2000 12:00:00 AM     Permit Number 42642 6006853.97359683 2109407.99798814 37.7724197439799 -122.419692774816 (37.7724197439799, -122.419692774816) 8 2 9 28853 19
2611 52930 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 36 Havelock St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/03/2006 12:00:00 AM     Permit Number 48915 5999971.05699015 2092944.44477133 37.7268246780096 -122.442319255194 (37.7268246780096, -122.442319255194) 9 7 6 28861 25
2630 47383 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1515 Vallejo St 4 Sidewalk: Curb side : Cutout Tree Private 2   03/25/2003 12:00:00 AM     Permit Number 46367 6006307.07862293 2118296.63950756 37.7967949468883 -122.422216159163 (37.7967949468883, -122.422216159163) 13 9 10 28858 32
2996 38797 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   5 Sidewalk: Curb side : Cutout Tree Private 2   10/23/1998 12:00:00 AM     Permit Number 40645                    
3059 68742 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 3926 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/16/1993 12:00:00 AM     Permit Number 32663 6003444.16925552 2105388.01634751 37.7611891817503 -122.431200618374 (37.7611891817503, -122.431200618374) 15 4 5 28862 3
3240 23833 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1302X Webster St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/21/2008 12:00:00 AM 3 3X3   6003750.8656173 2113176.0104319 37.7825904834742 -122.43069565207 (37.7825904834742, -122.43069565207) 7 9 11 29490 41
3437 79 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 899 14th St 1 Sidewalk: Curb side : Cutout Tree Private 2     26 3X3   6002864.3199934 2107660.1796498 37.7673951141913 -122.433368437593 (37.7673951141913, -122.433368437593) 15 5 5 28862 3
3528 38666 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 850 Brewster St 3 Sidewalk: Curb side : Cutout Tree Private 2   10/01/1998 12:00:00 AM     Permit Number 40586                    
3783 47477 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   3 Sidewalk: Curb side : Cutout Tree Private 2   05/14/2002 12:00:00 AM     Permit Number 45375                    
3835 42802 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 3700 17th St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/28/2000 12:00:00 AM     Permit Number 42757 6004214.17005009 2106015.94399708 37.7629569261619 -122.42858227503 (37.7629569261619, -122.42858227503) 8 4 5 28862 3
3958 29691 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 235X Hahn St 5 Sidewalk: Curb side : Cutout Tree Private 2   03/17/2006 12:00:00 AM 3 3X3   6007408.6946 2087074.91278 37.7111292927788 -122.416191939068 (37.7111292927788, -122.416191939068) 9 7 8 309 39
4046 43411 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 536 Liberty St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/2000 12:00:00 AM     Permit Number 43154 6002822.07551999 2103890.28570644 37.7570415002259 -122.433245151224 (37.7570415002259, -122.433245151224) 2 4 5 28862 3
4118 60587 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1596 Fulton St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/28/2008 12:00:00 AM   3x3 Permit Number 50372 6000129.25218727 2110962.46444115 37.7763068086663 -122.443065816912 (37.7763068086663, -122.443065816912) 15 5 11 29492 16
4247 41540 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 775X 02nd St 6 Sidewalk: Curb side : Cutout Tree Private 2   04/20/2000 12:00:00 AM 6 3x3 Permit Number 42068 6015692.30699351 2111981.66601878 37.7799803743496 -122.389299616981 (37.7799803743496, -122.389299616981) 6 2 9 28856 20
4330 68743 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 3929 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/16/1993 12:00:00 AM     Permit Number 32664 6003434.71793969 2105335.41306872 37.761044210169 -122.431229551523 (37.761044210169, -122.431229551523) 2 4 5 28862 3
4428 66790 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 2150 Larkin St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/13/2010 12:00:00 AM   3x3 Permit Number 53367 6006860.21214417 2118575.27175394 37.79759118503 -122.420321971868 (37.79759118503, -122.420321971868) 5 9 10 28858 32
5074 22216 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 4250X 03rd St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/18/2008 12:00:00 AM 3 3X3   6015384.98643 2097123.18461 37.7391651289337 -122.389324913037 (37.7391651289337, -122.389324913037) 10 3 8 58 1
5351 108330 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 86 11TH ST 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007396 2110315 37.7749406737789 -122.417882154347 (37.7749406737789, -122.417882154347) 8 2 9 28853 19
5589 39428 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 290 Webster St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/21/1998 12:00:00 AM   3x3 Permit Number 40930 6004202.2780492 2109746.86965534 37.7732004728874 -122.428889408135 (37.7732004728874, -122.428889408135) 7 9 11 28852 10
5660 24445 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 2251X 03rd St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1995 12:00:00 AM 3 3X3   6015765.11922 2105348.0588 37.7617699797552 -122.388584545263 (37.7617699797552, -122.388584545263) 10 3 8 28856 29
5759 47617 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1209 Houston St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/20/2002 12:00:00 AM     Permit Number 45446                    
5896 68729 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 8 Turquoise Way 1 Sidewalk: Curb side : Cutout Tree Private 2   11/01/1993 12:00:00 AM     Permit Number 32645 5998785.51386128 2099959.35584866 37.7460183133905 -122.446922200801 (37.7460183133905, -122.446922200801) 2 7 5 63 7
6184 64799 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 450 27th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/05/1989 12:00:00 AM     Permit Number 25798 6003587.23896685 2100132.28558533 37.7467662928737 -122.430330814023 (37.7467662928737, -122.430330814023) 2 7 5 63 22
6231 46141 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   4 Sidewalk: Curb side : Cutout Tree Private 2   12/27/2001 12:00:00 AM     Permit Number 44490                    
7036 38800 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   8 Sidewalk: Curb side : Cutout Tree Private 2   10/23/1998 12:00:00 AM     Permit Number 40645                    
7053 93534 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 325 China Basin St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/08/2010 12:00:00 AM   3x3 Permit Number 53240 6016190.6 2109941.9 37.774407241214 -122.387433446454 (37.774407241214, -122.387433446454) 14 3 9 310 20
7363 35440 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 757 Peninsula Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1998 12:00:00 AM     Permit Number 38882                    
7573 64140 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 408 30th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/05/1987 12:00:00 AM     Permit Number 24912 6003905.86029931 2098394.49493183 37.7420127636574 -122.429105167098 (37.7420127636574, -122.429105167098) 2 7 5 63 22
7597 9777 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 897X Gough St 5 Sidewalk: Curb side : Cutout Tree Rec/Park 5     30 3X3   6005678.151576 2112736.5747486 37.7814929008439 -122.42399680549 (37.7814929008439, -122.42399680549) 7 9 11 28852 41
7619 35441 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 757 Peninsula Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1998 12:00:00 AM     Permit Number 38882                    
7771 49688 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 2235 NOTES) Hayes St 12 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2003 12:00:00 AM     Permit Number 46511 5997175.15188937 2109805.23760487 37.7729604879505 -122.453201252207 (37.7729604879505, -122.453201252207) 15 5 11 29492 16
7899 42795 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 3700 17th St 18 Sidewalk: Curb side : Cutout Tree Private 2   06/28/2000 12:00:00 AM     Permit Number 42757 6004214.17005009 2106015.94399708 37.7629569261619 -122.42858227503 (37.7629569261619, -122.42858227503) 8 4 5 28862 3
7977 63890 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 165 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/22/1987 12:00:00 AM     Permit Number 24599 6005777.74997654 2109961.71011831 37.7738794203064 -122.423454911884 (37.7738794203064, -122.423454911884) 7 9 11 28852 10
8397 38801 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   6 Sidewalk: Curb side : Cutout Tree Private 2   10/23/1998 12:00:00 AM     Permit Number 40645                    
8418 64139 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 523 30th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/05/1987 12:00:00 AM     Permit Number 24910 6003239.38144538 2098311.93722578 37.7417483289476 -122.431403744863 (37.7417483289476, -122.431403744863) 2 7 5 63 7
8544 256668 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1835 Hyde St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/19/2018 12:00:00 AM 3 3x3 Permit Number 782601                    
8691 47618 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1209 Houston St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/20/2002 12:00:00 AM     Permit Number 45446                    
8945 38806 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   7 Sidewalk: Curb side : Cutout Tree Private 2   10/23/1998 12:00:00 AM     Permit Number 40645                    
9026 23835 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1302X Webster St 4 Sidewalk: Curb side : Cutout Tree Private 2   04/10/1990 12:00:00 AM 20 3X3   6003750.8656173 2113176.0104319 37.7825904834742 -122.43069565207 (37.7825904834742, -122.43069565207) 7 9 11 29490 41
9193 32309 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1097 Houston St 3 Sidewalk: Curb side : Cutout Tree Private 2   08/19/1996 12:00:00 AM     Permit Number 36882                    
9292 46150 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   2 Sidewalk: Curb side : Cutout Tree Private 2   12/27/2001 12:00:00 AM     Permit Number 44491                    
9367 83358 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1160 Stanyan St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/16/2008 12:00:00 AM   3x3 Permit Number 50875 5997390.75214654 2106213.86032098 37.7631118403797 -122.452196286828 (37.7631118403797, -122.452196286828) 15 5 11 29492 9
9413 35439 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 757 Peninsula Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1998 12:00:00 AM     Permit Number 38882                    
9458 84830 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 939 Fell St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/07/2007 12:00:00 AM     Permit No. 49222 6002944 2110261 37.7745408475216 -122.433278698665 (37.7745408475216, -122.433278698665) 15 5 11 29492 10
9832 46143 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   2 Sidewalk: Curb side : Cutout Tree Private 2   12/27/2001 12:00:00 AM     Permit Number 44490                    
10086 47615 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1209 Houston St 5 Sidewalk: Curb side : Cutout Tree Private 2   05/20/2002 12:00:00 AM     Permit Number 45446                    
10223 7769 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 490X Franklin St 1 Sidewalk: Curb side : Cutout Tree War Memorial 17     12 3X3   6006335.7213615 2111871.61132 37.7791550246023 -122.421660473625 (37.7791550246023, -122.421660473625) 7 9 11 28852 10
10415 43967 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 627 Turk St 7 Sidewalk: Curb side : Cutout Tree Private 2   08/24/2000 12:00:00 AM     Permit Number 43534 6006999.24602912 2112908.87547401 37.7820404937398 -122.419438672428 (37.7820404937398, -122.419438672428) 7 9 9 28852 36
10531 84036 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 45 Romain St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/29/2008 12:00:00 AM   3x3 Permit Number 50462 6001133.37697683 2103651.61212773 37.7562902176876 -122.439068194619 (37.7562902176876, -122.439068194619) 2 4 5 28862 38
10617 49671 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 2235 NOTES) Hayes St 4 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2003 12:00:00 AM     Permit Number 46511 5997175.15188937 2109805.23760487 37.7729604879505 -122.453201252207 (37.7729604879505, -122.453201252207) 15 5 11 29492 16
10657 29740 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 629 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/09/2015 12:00:00 AM 3 3x3 Permit Number 775746 6009949.88308 2119458.12885 37.8001889103038 -122.409693183014 (37.8001889103038, -122.409693183014) 3 1 10 308 23
10777 35244 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 2999X Polk St 3 Sidewalk: Curb side : Cutout Tree Private 2   02/17/1998 12:00:00 AM     Permit Number 38736 6005802.2 2120854.7 37.8037902383764 -122.424145173625 (37.8037902383764, -122.424145173625) 5 9 1 28858 32
10962 39426 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 395Bldg #9 Buchanan St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/21/1998 12:00:00 AM     Permit Number 40929 6004623.83107143 2109808.7893301 37.7733943405421 -122.42743561187 (37.7733943405421, -122.42743561187) 7 9 11 28852 10
11164 64419 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 111 Laidley St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/11/1988 12:00:00 AM     Permit Number 25267 6003583.64860345 2097735.92139782 37.740186227283 -122.430172299864 (37.740186227283, -122.430172299864) 2 7 5 63 7
11177 47475 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   1 Sidewalk: Curb side : Cutout Tree Private 2   05/14/2002 12:00:00 AM     Permit Number 45375                    
11510 470 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 2490 Bryant St 5 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6009704.8170941 2102845.113501 37.7545597392567 -122.409368154592 (37.7545597392567, -122.409368154592) 2 4 7 28859 19
11524 64282 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 411 30th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/18/1988 12:00:00 AM     Permit Number 25086 6003895.1200055 2098341.81687307 37.7418675138214 -122.429138548404 (37.7418675138214, -122.429138548404) 2 7 5 63 7
11762 62725 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 109 Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/07/1986 12:00:00 AM     Permit Number 23071 6001085.93774818 2105743.30332199 37.7620307920739 -122.439382183867 (37.7620307920739, -122.439382183867) 15 5 5 28862 3
11779 44518 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 100X TOWNSEND ST 2 Sidewalk: Curb side : Cutout Tree Private 2   03/27/2001 12:00:00 AM 9 3x3 Permit Number 43820 6015218.7 2112179.2 37.7804964903429 -122.390951859139 (37.7804964903429, -122.390951859139) 6 2 9 28856 6
11945 47610 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1201 Houston St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/01/1994 12:00:00 AM     Permit Number 45444                    
12038 50316 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1055 Ellis St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/22/2003 12:00:00 AM     Permit Number 47021 6005825.34130744 2113438.50468071 37.7834285368624 -122.42353751819 (37.7834285368624, -122.42353751819) 7 9 11 28858 41
12394 47612 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1201 Houston St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/01/1994 12:00:00 AM     Permit Number 45444                    
12402 67521 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 424 Staples Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/22/1992 12:00:00 AM     Permit Number 31057 5997342.043029 2093839.69948247 37.7291326429008 -122.451472187982 (37.7291326429008, -122.451472187982) 9 7 4 28861 40
12508 62227 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 228 Capistrano Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/30/1985 12:00:00 AM     Permit Number 22352 6001110.06412505 2093217.52334826 37.7276393417973 -122.438401301148 (37.7276393417973, -122.438401301148) 9 7 6 28861 25
12650 92885 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1366 Mission St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/18/2009 12:00:00 AM   3x3 Permit Number 53100 6008075 2110545 37.7756103885853 -122.415549628976 (37.7756103885853, -122.415549628976) 8 2 9 28853 34
12744 35438 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 757 Peninsula Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1998 12:00:00 AM     Permit Number 38882                    

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