177 rows where Supervisor Districts = 11 and qSpecies_id = 95 sorted by qSpecies_id

View and edit SQL

Supervisor Districts

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)
118036 7723 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 175X Fell St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6006514.1274 2110757.9768 37.7761073119325 -122.420964203399 (37.7761073119325, -122.420964203399) 7 9 11 28852 10
119091 67481 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1598 McAllister St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/08/1992 12:00:00 AM     Permit Number 31004 6001509.57860385 2111503.53144301 37.777871047567 -122.438329667297 (37.777871047567, -122.438329667297) 15 5 11 29490 41
119117 63752 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 722 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/22/1988 12:00:00 AM     Permit Number 24425 6003101.35751437 2109641.71994707 37.772849383001 -122.432690122287 (37.772849383001, -122.432690122287) 15 5 11 29492 9
119472 139075 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 2215 POST ST 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6001525.5995 2113880.0202 37.7843971933507 -122.43844455479 (37.7843971933507, -122.43844455479) 15 6 11 29490 13
119875 68377 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 25 Carmel St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/09/1993 12:00:00 AM     Permit Number 32201 5998862.2729582 2105376.5533863 37.7608969909824 -122.447046553817 (37.7608969909824, -122.447046553817) 15 5 11 29492 12
120503 58678 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 596 Haight St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/22/1987 12:00:00 AM     Permit Number 24398 6003287.0157035 2109320.57844586 37.7719781347946 -122.43202497289 (37.7719781347946, -122.43202497289) 15 9 11 29492 10
120630 63764 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 311 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/09/1987 12:00:00 AM     Permit Number 24442 6003235.24732503 2109330.82245921 37.7720033272962 -122.4322047752 (37.7720033272962, -122.4322047752) 15 9 11 29492 9
121525 211327 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1205 Lincoln Way 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5991921.7773 2107243.49687 37.7656241412693 -122.471186467795 (37.7656241412693, -122.471186467795) 11 8 11 56 12
121551 30727 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 45 Rose St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/31/1995 12:00:00 AM     Permit Number 34624 6006303.86733164 2109861.47838862 37.7736338888904 -122.421627862373 (37.7736338888904, -122.421627862373) 7 9 11 28852 10
121819 62608 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 410 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/28/1987 12:00:00 AM     Permit Number 22917 6003239.5151167 2109678.18176647 37.7729573324765 -122.432214823883 (37.7729573324765, -122.432214823883) 15 9 11 29492 10
121967 233509 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 599 Buchanan St 3 Sidewalk: Curb side : Yard Tree Private 2     2 Width 6ft   6004544.20196 2110431.59381 37.7750999055671 -122.427755444356 (37.7750999055671, -122.427755444356) 7 9 11 28852 10
122595 2220 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1200X Broderick St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 4X4   6000834.479 2112894.4094 37.7816516227539 -122.440764862478 (37.7816516227539, -122.440764862478) 15 5 11 29490 41
123077 2683 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 2100 Bush St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6003416.3801 2114894.2482 37.7872893759097 -122.431975560402 (37.7872893759097, -122.431975560402) 13 9 11 29490 27
123195 67196 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 635 Belvedere St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/06/1992 12:00:00 AM     Permit Number 30648 5998644.57725532 2105576.2122968 37.7614327642251 -122.447813838506 (37.7614327642251, -122.447813838506) 15 5 11 29492 12
125737 63759 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 350 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/09/1987 12:00:00 AM     Permit Number 24436 6003268.61880609 2109468.57756707 37.7723834610111 -122.432099179795 (37.7723834610111, -122.432099179795) 15 9 11 29492 10
126757 233595 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 65 Lily St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6006199.44 2110210.42189 37.7745861147813 -122.422013886425 (37.7745861147813, -122.422013886425) 7 9 11 28852 10
127438 6957 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 627 Fell St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6004338.3385 2110455.1046 37.7751528130593 -122.428469247762 (37.7751528130593, -122.428469247762) 7 9 11 28852 10
128239 63190 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1940 Ellis St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/18/1986 12:00:00 AM     Permit Number 23729 6001603.1859091 2112901.47419307 37.7817147682428 -122.438106012539 (37.7817147682428, -122.438106012539) 15 5 11 29490 41
128687 62278 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 391 Haight St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/09/1985 12:00:00 AM     Permit Number 22416 6004275.31529715 2109405.62927883 37.7722676437754 -122.428612433422 (37.7722676437754, -122.428612433422) 7 9 11 28852 10
129098 54345 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1360 04th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/30/1992 12:00:00 AM     Permit Number 30561 5994905.98112793 2106327.13892445 37.7632802209212 -122.460798420916 (37.7632802209212, -122.460798420916) 15 5 11 56 12
129504 233525 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 144 Grattan St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   5997911.36831 2106517.58465 37.7639756003107 -122.450417555923 (37.7639756003107, -122.450417555923) 15 5 11 29492 9
129961 114638 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 2201 Post St 6 Sidewalk: Curb side : Cutout Tree Private 2       2x2   6001638.4767595 2113898.3843624 37.7844540366015 -122.43805535523 (37.7844540366015, -122.43805535523) 15 6 11 29490 13
130319 62809 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1521 Golden Gate Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/08/1986 12:00:00 AM     Permit Number 23168 6002309.47676222 2111908.47942413 37.7790283971732 -122.435591521295 (37.7790283971732, -122.435591521295) 15 5 11 29490 41
130596 63731 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 510 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/22/1987 12:00:00 AM     Permit Number 24400 6004110.13087942 2109782.11768526 37.7732920393038 -122.429210671215 (37.7732920393038, -122.429210671215) 7 9 11 29492 10
131737 63271 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1800 Turk St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/26/1987 12:00:00 AM     Permit Number 23830 6001386.26443426 2112180.71364321 37.7797234038821 -122.438804791999 (37.7797234038821, -122.438804791999) 15 5 11 29490 41
132618 60496 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1321 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/04/1982 12:00:00 AM     Permit Number 20094 6001757.67360022 2112974.28718106 37.7819234789346 -122.437576774938 (37.7819234789346, -122.437576774938) 15 5 11 29490 41
133959 67749 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1278 04th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/04/1992 12:00:00 AM     Permit Number 31373 5994888.54131742 2106834.07089825 37.7646711211609 -122.460895481422 (37.7646711211609, -122.460895481422) 15 5 11 56 12
138178 2224 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1200X Broderick St 7 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6000821.2805 2112988.1523 37.7819082651248 -122.440817249491 (37.7819082651248, -122.440817249491) 15 5 11 29490 41
140254 233526 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 22 Parnassus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   5998549.32409 2106920.03267 37.7651171124773 -122.448240047256 (37.7651171124773, -122.448240047256) 15 5 11 29492 9
142369 69300 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1680 Fulton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/14/1994 12:00:00 AM     Permit Number 33375 5999724.98067163 2110906.29768043 37.7761295304752 -122.444460261753 (37.7761295304752, -122.444460261753) 15 5 11 29492 16
143084 137698 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 726 LYON ST 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6000067.2767 2111422.2746 37.7775657963039 -122.443313240617 (37.7775657963039, -122.443313240617) 15 5 11 29490 16
147643 100770 Significant Tree 6 Pittosporum crassifolium :: Karo Tree 95 450 Hayes St 1 Back Yard : Yard Tree Private 2         Permit Number 768934 6005678.7 2111113.4 37.7770360905223 -122.423879452899 (37.7770360905223, -122.423879452899) 7 9 11 28852 10
149176 63737 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 573 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/23/1987 12:00:00 AM     Permit Number 24406 6003834.70515324 2109691.28362316 37.7730270354143 -122.43015692487 (37.7730270354143, -122.43015692487) 7 9 11 29492 10
149233 139069 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 2211 Post St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6001584 2113871 37.7843757479057 -122.438241863273 (37.7843757479057, -122.438241863273) 15 6 11 29490 13
149703 139652 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1004 Broderick St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6000931.7752 2112195.3992 37.7797378594663 -122.440378118045 (37.7797378594663, -122.440378118045) 15 5 11 29490 41
149896 67108 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1285 02nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/28/1992 12:00:00 AM     Permit Number 30525 5995458.01605947 2106809.73569122 37.7646370541731 -122.458924070061 (37.7646370541731, -122.458924070061) 15 5 11 56 12
151497 63643 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 615 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/22/1987 12:00:00 AM     Permit Number 24290 6001076.3999006 2110778.3153622 37.7758551396753 -122.439776172675 (37.7758551396753, -122.439776172675) 15 5 11 29492 10
152270 251676 Undocumented 4 Pittosporum crassifolium :: Karo Tree 95 2201 Post St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001586 2113871 37.784375861656 -122.438234943981 (37.784375861656, -122.438234943981) 15 6 11 29490 13
153732 139082 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 2245 POST ST 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   6001400.8747 2113864.8114 37.7843483385873 -122.438874968219 (37.7843483385873, -122.438874968219) 15 6 11 29490 13
155916 139548 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 2086 Ellis St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6000870.6055 2112799.3975 37.7813928016707 -122.440633065246 (37.7813928016707, -122.440633065246) 15 5 11 29490 41
155970 62264 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 372 Hermann St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/07/1985 12:00:00 AM     Permit Number 22390 6003490.95554643 2108655.49209319 37.7701635303226 -122.431272047126 (37.7701635303226, -122.431272047126) 15 9 11 29492 10
156894 5232 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1060 Divisadero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 2X3   6001447.2358 2112106.5793 37.7795233183444 -122.43858855259 (37.7795233183444, -122.43858855259) 15 5 11 29490 41
157594 63187 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 2043 Ellis St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/17/1986 12:00:00 AM     Permit Number 23726 6001104.49990341 2112782.16109976 37.7813587913625 -122.439822670066 (37.7813587913625, -122.439822670066) 15 5 11 29490 41
158702 16839 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 97X Oak St 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/17/1999 12:00:00 AM 75 3X3   6006555.51402 2110416.39536 37.7751717443167 -122.420796779971 (37.7751717443167, -122.420796779971) 7 9 11 28852 10
159370 27856 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 350 Masonic Ave 5 Sidewalk: Curb side : Cutout Tree DPW 1     45 3X3   5999054.4459 2111673.3239 37.7781973051578 -122.446835017559 (37.7781973051578, -122.446835017559) 15 5 11 54 16
159717 139072 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 2201 Post St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6001586 2113871 37.784375861656 -122.438234943981 (37.784375861656, -122.438234943981) 15 6 11 29490 13
161739 10346 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 959 Haight St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6001539.009 2109027.09783 37.7710730553048 -122.438050421808 (37.7710730553048, -122.438050421808) 15 5 11 29492 9
163143 60903 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1425 05th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/18/1983 12:00:00 AM     Permit Number 20693 5994560.57108256 2105822.18766278 37.7618738757344 -122.461956453095 (37.7618738757344, -122.461956453095) 1 5 11 56 12
163553 51787 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 2201 Post St 7 Sidewalk: Curb side : Cutout Tree Private 2   06/30/2005 12:00:00 AM   2x2 Permit Number 48036 6001638.4767595 2113898.3843624 37.7844540366015 -122.43805535523 (37.7844540366015, -122.43805535523) 15 6 11 29490 13
166127 233524 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 144 Grattan St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   5997927.77763 2106520.29588 37.7639839837988 -122.450360996685 (37.7639839837988, -122.450360996685) 15 5 11 29492 9
166249 139080 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 2245 POST ST 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6001422.198 2113866.0657 37.784352995716 -122.438801287103 (37.784352995716, -122.438801287103) 15 6 11 29490 13
166459 2181 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1006 Broderick St 1 Sidewalk: Curb side : Cutout Tree DPW 1     8 4X4   6000928.0526 2112222.8113 37.7798129141573 -122.440392962604 (37.7798129141573, -122.440392962604) 15 5 11 29490 41
166868 10321 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 759 Haight St 1 Sidewalk: Curb side : Cutout Tree Private 2     30 3X3   6002536.32245 2109085.56364 37.7712902545388 -122.434604866834 (37.7712902545388, -122.434604866834) 15 5 11 29492 9
166941 66373 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 430 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/04/1991 12:00:00 AM     Permit Number 29497 6003708.35294884 2109810.61822809 37.7733475417865 -122.430602509574 (37.7733475417865, -122.430602509574) 7 9 11 29492 10
168128 63755 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 832 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/09/1987 12:00:00 AM     Permit Number 24429 6002579.84478406 2109569.92728925 37.7726226680298 -122.434488959034 (37.7726226680298, -122.434488959034) 15 5 11 29492 9
168877 63763 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 326 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/09/1987 12:00:00 AM   4x4 Permit Number 24441 6003279.4994369 2109390.21547957 37.7721689148553 -122.432055945851 (37.7721689148553, -122.432055945851) 15 9 11 29492 10
169471 10350 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 981 Haight St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6001468.92612 2109016.3918 37.7710396733632 -122.438292073219 (37.7710396733632, -122.438292073219) 15 5 11 29492 9
172794 62840 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 3 Seymour St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/14/1986 12:00:00 AM     Permit Number 23207 6001668.62546357 2111862.95878807 37.7788669893558 -122.437805219223 (37.7788669893558, -122.437805219223) 15 5 11 29490 41
173643 138247 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1599 Scott St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6001634.7269 2113859.0317 37.7843457709869 -122.438065508553 (37.7843457709869, -122.438065508553) 15 6 11 29490 13
174116 60904 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1427 05th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/18/1983 12:00:00 AM     Permit Number 20694 5994561.02104765 2105809.15842746 37.7618381267347 -122.461953952005 (37.7618381267347, -122.461953952005) 1 5 11 56 12
174246 211326 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1251 Lincoln Way 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5991824.97784 2107240.45094 37.7656101784027 -122.471521050653 (37.7656101784027, -122.471521050653) 11 8 11 56 12
174374 62623 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 300 Carl St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/23/2001 12:00:00 AM     Permit Number 22937 5996744.75965336 2107022.23361266 37.7652944000367 -122.454488943604 (37.7652944000367, -122.454488943604) 15 5 11 29492 12
174388 63732 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 529 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/22/1987 12:00:00 AM     Permit Number 24401 6004035.25561517 2109719.19558167 37.7731150315991 -122.429465186856 (37.7731150315991, -122.429465186856) 7 9 11 29492 10
179896 63641 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 701 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/05/1992 12:00:00 AM     Permit Number 31106 6001035.54169923 2111072.80974441 37.7766614211292 -122.43993863172 (37.7766614211292, -122.43993863172) 15 5 11 29492 41
180227 10333 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 849 Haight St 1 Sidewalk: Curb side : Cutout Tree DPW 1     50 3X3   6002068.30214 2109102.87346 37.7713112029881 -122.436225005803 (37.7713112029881, -122.436225005803) 15 5 11 29492 9
180483 211328 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1205 Lincoln Way 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5991946.9444 2107243.56347 37.7656257798199 -122.471099426011 (37.7656257798199, -122.471099426011) 11 8 11 56 12
183655 138053 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1801 Webster St 3 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6003423.5383 2114956.5878 37.7874609504744 -122.43195524769 (37.7874609504744, -122.43195524769) 13 9 11 29490 27
184207 67721 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 130 Judah St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/04/1992 12:00:00 AM     Permit Number 31339 5994171.17810275 2106011.82451063 37.7623721436591 -122.463316960916 (37.7623721436591, -122.463316960916) 1 5 11 56 12
185926 54350 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1382 04th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/28/1992 12:00:00 AM     Permit Number 30523 5994910.33164599 2106200.68051144 37.7629332491802 -122.460774208888 (37.7629332491802, -122.460774208888) 15 5 11 56 12
186526 233510 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 757 Haight St 2 : Tree Private 2     10 Width 3ft   6002532.75447 2109164.64815 37.7715071985232 -122.434622864475 (37.7715071985232, -122.434622864475) 15 5 11 29492 9
186699 139070 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 2211 Post St 4 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   6001584 2113871 37.7843757479057 -122.438241863273 (37.7843757479057, -122.438241863273) 15 6 11 29490 13
186970 225283 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 101 Rivoli St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5998142.22071 2105955.37376 37.7624451205691 -122.449578595475 (37.7624451205691, -122.449578595475) 15 5 11 29492 9
189945 62263 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 388 Hermann St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/07/1985 12:00:00 AM     Permit Number 22389 6003417.83204435 2108645.36368336 37.7701315759363 -122.431524257341 (37.7701315759363, -122.431524257341) 15 9 11 29492 10
193560 139079 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 2245 POST ST 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6001410.9091 2113865.4385 37.7843506313341 -122.438840297721 (37.7843506313341, -122.438840297721) 15 6 11 29490 13
193819 62622 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 183 Carl St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/22/1986 12:00:00 AM     Permit Number 22936 5997384.53937268 2107058.88452992 37.7654317060994 -122.452278752633 (37.7654317060994, -122.452278752633) 15 5 11 29492 9
194007 22791 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1008X Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6000922.6378 2112256.3151 37.7799045987504 -122.44041409826 (37.7799045987504, -122.44041409826) 15 5 11 29490 41
194210 67740 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1412 07th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/04/1992 12:00:00 AM     Permit Number 31359 5993990.22084457 2105880.95703345 37.7620023888233 -122.463933320103 (37.7620023888233, -122.463933320103) 1 5 11 56 12

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