trees
162 rows where Zip Codes = 29492 and qSpecies_id = 53 sorted by qAddress
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
92694 | 112578 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 660x Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999086 | 2108401 | 37.7692141419233 | -122.446490377962 | (37.7692141419233, -122.446490377962) | 15 | 5 | 11 | 29492 | 9 | ||||
70605 | 7148 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 670X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6003788.041 | 2110084.01472 | 37.7741027355458 | -122.430346367315 | (37.7741027355458, -122.430346367315) | 7 | 9 | 11 | 29492 | 10 | |||
148453 | 52589 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 675 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/27/2006 12:00:00 AM | Permit Number 774039 | 5997878.20498734 | 2108284.16023065 | 37.7688242695831 | -122.450659631577 | (37.7688242695831, -122.450659631577) | 15 | 5 | 11 | 29492 | 9 | |||
93569 | 7144 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 685X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003730.75372 | 2110025.58578 | 37.7739390589029 | -122.430540363958 | (37.7739390589029, -122.430540363958) | 7 | 9 | 11 | 29492 | 10 | |||
38742 | 113004 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
43330 | 113005 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
49558 | 113001 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
105584 | 113009 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
107825 | 113010 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
118914 | 113002 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
162574 | 113000 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
173238 | 113007 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
173558 | 113006 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
176974 | 113008 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
184217 | 113003 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
65399 | 7150 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 701 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003528.61787 | 2110726.18593 | 37.7758512811844 | -122.431289605258 | (37.7758512811844, -122.431289605258) | 15 | 9 | 11 | 29492 | 10 | |||
38510 | 19240 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 701 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 8x6 | 6002037.68577 | 2110909.98609 | 37.7762713444054 | -122.436460270394 | (37.7762713444054, -122.436460270394) | 15 | 5 | 11 | 29492 | 10 | |||
29407 | 16958 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 705 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x5 | 6003566.56897 | 2110004.67754 | 37.7738723476787 | -122.431106813505 | (37.7738723476787, -122.431106813505) | 15 | 9 | 11 | 29492 | 10 | |||
140971 | 16959 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 705 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003588.88104 | 2109980.45883 | 37.7738071133695 | -122.431027903554 | (37.7738071133695, -122.431027903554) | 15 | 9 | 11 | 29492 | 10 | |||
35689 | 7151 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 708 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003574.54383 | 2110759.08622 | 37.775944219835 | -122.431133084506 | (37.775944219835, -122.431133084506) | 7 | 9 | 11 | 29492 | 10 | |||
64713 | 7152 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 708 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003574.54383 | 2110759.08622 | 37.775944219835 | -122.431133084506 | (37.775944219835, -122.431133084506) | 7 | 9 | 11 | 29492 | 10 | |||
111324 | 7153 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 708 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6003550.62034 | 2110877.34065 | 37.7762675615733 | -122.431224284875 | (37.7762675615733, -122.431224284875) | 7 | 9 | 11 | 29492 | 10 | |||
51714 | 7156 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 712 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6003631.55189 | 2110917.37527 | 37.7763820727629 | -122.430947178384 | (37.7763820727629, -122.430947178384) | 7 | 9 | 11 | 29492 | 10 | |||
124076 | 7165 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 735 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003427.15007 | 2110890.32808 | 37.776296224072 | -122.431652329724 | (37.776296224072, -122.431652329724) | 15 | 9 | 11 | 29492 | 10 | |||
140272 | 93200 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 756 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x6 | 5998607 | 2107901 | 37.7678138979087 | -122.448111199872 | (37.7678138979087, -122.448111199872) | 15 | 5 | 11 | 29492 | 9 | ||||
50094 | 253202 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 800 Oak St | 4 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 6x6 | 6003064 | 2109976 | 37.77376511482 | -122.432843231253 | (37.77376511482, -122.432843231253) | 15 | 5 | 11 | 29492 | 10 | |||
19494 | 20113 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 800X OAK ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6002934 | 2109937 | 37.7736506563952 | -122.433290134136 | (37.7736506563952, -122.433290134136) | 15 | 5 | 11 | 29492 | 9 | |||
62158 | 20114 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 800X OAK ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6002934 | 2109937 | 37.7736506563952 | -122.433290134136 | (37.7736506563952, -122.433290134136) | 15 | 5 | 11 | 29492 | 9 | |||
87820 | 20116 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 800X OAK ST | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002934 | 2109937 | 37.7736506563952 | -122.433290134136 | (37.7736506563952, -122.433290134136) | 15 | 5 | 11 | 29492 | 9 | |||
129832 | 20115 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 800X OAK ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6002934 | 2109937 | 37.7736506563952 | -122.433290134136 | (37.7736506563952, -122.433290134136) | 15 | 5 | 11 | 29492 | 9 | |||
162520 | 10628 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 805 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/02/1990 12:00:00 AM | 6 | 3X4 | 6003942.23141 | 2110755.32974 | 37.775954734286 | -122.429860889744 | (37.775954734286, -122.429860889744) | 7 | 9 | 11 | 29492 | 10 | ||
67556 | 9975 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 812X Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003525.87553 | 2111110.58272 | 37.7769065842705 | -122.431326537326 | (37.7769065842705, -122.431326537326) | 7 | 9 | 11 | 29492 | 10 | |||
168672 | 9974 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 812X Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6003525.87553 | 2111110.58272 | 37.7769065842705 | -122.431326537326 | (37.7769065842705, -122.431326537326) | 7 | 9 | 11 | 29492 | 10 | |||
124574 | 16977 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 815 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6003104.00504 | 2109876.24546 | 37.7734934823641 | -122.432697720336 | (37.7734934823641, -122.432697720336) | 15 | 5 | 11 | 29492 | 9 | |||
161897 | 253634 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 830 Oak St | 1 | Sidewalk: Property side : Cutout | tree | DPW 1 | 6003018.63904 | 2109969.70237 | 37.7737452502421 | -122.432999691851 | (37.7737452502421, -122.432999691851) | 15 | 5 | 11 | 29492 | 10 | |||||
77397 | 16979 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 830X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x6 | 6003018.00984 | 2109974.66323 | 37.7737588358485 | -122.43300222285 | (37.7737588358485, -122.43300222285) | 15 | 5 | 11 | 29492 | 10 | |||
115162 | 7181 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 847 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6003442.40326 | 2111287.35095 | 37.7773872150711 | -122.431627916454 | (37.7773872150711, -122.431627916454) | 15 | 9 | 11 | 29492 | 10 | |||
160258 | 6989 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 848 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15x3.5 | 6003368.38608 | 2110385.91832 | 37.7749079085756 | -122.431819586637 | (37.7749079085756, -122.431819586637) | 15 | 9 | 11 | 29492 | 10 | |||
28315 | 6990 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 855 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003337.33996 | 2110322.66362 | 37.7747324668328 | -122.431922464006 | (37.7747324668328, -122.431922464006) | 15 | 9 | 11 | 29492 | 10 | |||
31660 | 7182 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 857 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6003432.47617 | 2111314.05853 | 37.7774599847744 | -122.43166416476 | (37.7774599847744, -122.43166416476) | 15 | 9 | 11 | 29492 | 10 | |||
50875 | 7183 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 857 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6003432.47617 | 2111314.05853 | 37.7774599847744 | -122.43166416476 | (37.7774599847744, -122.43166416476) | 15 | 9 | 11 | 29492 | 10 | |||
132184 | 7184 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 857 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6003432.47617 | 2111314.05853 | 37.7774599847744 | -122.43166416476 | (37.7774599847744, -122.43166416476) | 15 | 9 | 11 | 29492 | 10 | |||
50755 | 7185 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 865 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003457.39592 | 2111275.80383 | 37.7773563593355 | -122.431575227386 | (37.7773563593355, -122.431575227386) | 15 | 9 | 11 | 29492 | 10 | |||
182974 | 16988 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 879 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002804.94816 | 2109899.79468 | 37.773541177823 | -122.433733884114 | (37.773541177823, -122.433733884114) | 15 | 5 | 11 | 29492 | 9 | |||
20310 | 112288 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 895x PAGE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002361 | 2109458 | 37.7723029182135 | -122.435237957834 | (37.7723029182135, -122.435237957834) | 15 | 5 | 11 | 29492 | 9 | ||||
69091 | 7190 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 896 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 5X5 | 6003496.10413 | 2111301.12929 | 37.7774280906657 | -122.431443131507 | (37.7774280906657, -122.431443131507) | 7 | 9 | 11 | 29492 | 10 | |||
83917 | 7189 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 896 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5X5 | 6003518.08132 | 2111313.80886 | 37.7774641511736 | -122.43136801056 | (37.7774641511736, -122.43136801056) | 7 | 9 | 11 | 29492 | 10 | |||
115819 | 7191 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 896 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 5X5 | 6003494.59692 | 2111314.73243 | 37.7774653560924 | -122.431449316775 | (37.7774653560924, -122.431449316775) | 7 | 9 | 11 | 29492 | 10 | |||
32968 | 16997 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 903 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3X3 | 6002604.56537 | 2109869.28932 | 37.7734460452794 | -122.43442485558 | (37.7734460452794, -122.43442485558) | 15 | 5 | 11 | 29492 | 9 | |||
134874 | 16999 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 903 Oak St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3X3 | 6002647.07822 | 2109875.66562 | 37.7734659661022 | -122.434278253633 | (37.7734659661022, -122.434278253633) | 15 | 5 | 11 | 29492 | 9 | |||
193656 | 16998 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 903 Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3X3 | 6002629.22495 | 2109872.04506 | 37.7734550115897 | -122.434339751705 | (37.7734550115897, -122.434339751705) | 15 | 5 | 11 | 29492 | 9 | |||
172277 | 10647 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 913 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/02/1991 12:00:00 AM | 12 | 3X3 | 6003471.55966 | 2110689.4075 | 37.775747062973 | -122.431484357932 | (37.775747062973, -122.431484357932) | 15 | 9 | 11 | 29492 | 10 | ||
39074 | 20124 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 924X Fell St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002999.41967 | 2110319.25168 | 37.7747039360019 | -122.433091154251 | (37.7747039360019, -122.433091154251) | 15 | 5 | 11 | 29492 | 10 | |||
80201 | 20122 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 924X Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002999.41967 | 2110319.25168 | 37.7747039360019 | -122.433091154251 | (37.7747039360019, -122.433091154251) | 15 | 5 | 11 | 29492 | 10 | |||
21570 | 7202 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 926 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6003476.58431 | 2111463.23602 | 37.7778720892035 | -122.431522232661 | (37.7778720892035, -122.431522232661) | 15 | 9 | 11 | 29492 | 41 | |||
66963 | 45334 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 946 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44166 | 6002468.75387281 | 2109900.46778234 | 37.7735239435411 | -122.434896876631 | (37.7735239435411, -122.434896876631) | 15 | 5 | 11 | 29492 | 10 | ||||
2723 | 140583 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 949 FILLMORE ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 6003424.6737 | 2111485.9504 | 37.7779315149131 | -122.431703431668 | (37.7779315149131, -122.431703431668) | 15 | 9 | 11 | 29492 | 41 | |||
53228 | 7198 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 949 Fillmore St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003395.68163 | 2111577.87165 | 37.7781822644093 | -122.431810290332 | (37.7781822644093, -122.431810290332) | 15 | 9 | 11 | 29492 | 41 | |||
175601 | 7197 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 949 Fillmore St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003395.68163 | 2111577.87165 | 37.7781822644093 | -122.431810290332 | (37.7781822644093, -122.431810290332) | 15 | 9 | 11 | 29492 | 41 | |||
183075 | 17003 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 985 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 5x9 | 6002297.8184 | 2109825.1269 | 37.7733073694664 | -122.435482776108 | (37.7733073694664, -122.435482776108) | 15 | 5 | 11 | 29492 | 9 | |||
106301 | 98984 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 993 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | Permit Number 19087 | 6002920 | 2111648 | 37.7783478430736 | -122.433460857601 | (37.7783478430736, -122.433460857601) | 15 | 9 | 11 | 29492 | 41 | ||
178705 | 59665 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 993 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1981 12:00:00 AM | 12 | 2x2 | Permit Number 19087 | 6002914.43276984 | 2111641.44659541 | 37.7783295332017 | -122.433479648258 | (37.7783295332017, -122.433479648258) | 15 | 9 | 11 | 29492 | 41 |
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) );