trees
8,758 rows where qSpecies_id = 16 sorted by DBH descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
53247 | 69025 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3724 Quintara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1994 12:00:00 AM | 9 | Permit Number 33029 | 5981863.1449 | 2100828.4031 | 37.7474231678559 | -122.50550090803 | (37.7474231678559, -122.50550090803) | 1 | 8 | 3 | 29491 | 35 | |
53838 | 209956 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1100 Ulloa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5992697.14577 | 2098474.94007 | 37.7415927740888 | -122.467866838986 | (37.7415927740888, -122.467866838986) | 1 | 8 | 4 | 59 | 40 | |||
54189 | 183997 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1600 Sunset Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 0ft | 5984891.3901 | 2103804.6096 | 37.7557727569146 | -122.495249042937 | (37.7557727569146, -122.495249042937) | 1 | 8 | 3 | 56 | 35 | |||
55403 | 31703 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 424 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 9 | Permit Number 35205 | 5997816.4962 | 2107515.2273 | 37.7667094435038 | -122.450817626911 | (37.7667094435038, -122.450817626911) | 15 | 5 | 11 | 29492 | 9 | |
55666 | 177637 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 211 Curtis St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 2ft | 6000833.77764 | 2087370.24547 | 37.7115683175965 | -122.438937560743 | (37.7115683175965, -122.438937560743) | 9 | 7 | 6 | 28861 | 5 | |||
55673 | 131345 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3540 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5997316.31721 | 2116070.63227 | 37.7901717031104 | -122.453165331014 | (37.7901717031104, -122.453165331014) | 11 | 6 | 1 | 54 | 31 | |||
56786 | 231409 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 941 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008011.10745 | 2102429.56712 | 37.7533237017365 | -122.415196054962 | (37.7533237017365, -122.415196054962) | 2 | 4 | 7 | 28859 | 19 | |||
57211 | 68291 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2026 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1994 12:00:00 AM | 9 | Permit Number 32996 | 5981388.6776 | 2101267.3361 | 37.748600421328 | -122.507174112674 | (37.748600421328, -122.507174112674) | 1 | 8 | 3 | 29491 | 35 | |
57480 | 9240 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 6438 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/1993 12:00:00 AM | 9 | 3X3 | 5987048.85288 | 2112606.68579 | 37.7800668885317 | -122.488434809874 | (37.7800668885317, -122.488434809874) | 11 | 6 | 2 | 55 | 26 | ||
57666 | 131334 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3611 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003107.87441 | 2120753.09698 | 37.8033587689415 | -122.433461767746 | (37.8033587689415, -122.433461767746) | 13 | 9 | 1 | 57 | 17 | |||
58590 | 140963 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 161 PARKER AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5996885.6888 | 2113310.076 | 37.7825672610675 | -122.454455763644 | (37.7825672610675, -122.454455763644) | 11 | 6 | 1 | 54 | 31 | |||
59359 | 122956 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 201 09th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5993083.80397 | 2114053.87378 | 37.7843907511895 | -122.46766264245 | (37.7843907511895, -122.46766264245) | 11 | 6 | 2 | 54 | 11 | |||
59798 | 232819 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3424 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004049.27796 | 2106603.95524 | 37.7645621309592 | -122.429194509838 | (37.7645621309592, -122.429194509838) | 8 | 4 | 5 | 28862 | 3 | |||
59909 | 182883 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3401 Wawona St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5982308.1696 | 2096702.7029 | 37.7361213118023 | -122.50365658341 | (37.7361213118023, -122.50365658341) | 1 | 8 | 3 | 29491 | 35 | |||
60180 | 250701 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 80 McLaren Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 5986750.74884 | 2114900.38911 | 37.7863473423952 | -122.489634794236 | (37.7863473423952, -122.489634794236) | 11 | 6 | 1 | 55 | 33 | ||||
61936 | 183090 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2603 42nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5983340.9125 | 2097367.5212 | 37.7380073885609 | -122.500135160335 | (37.7380073885609, -122.500135160335) | 1 | 8 | 3 | 29491 | 35 | |||
62141 | 24103 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 105X Whitney Young Cir | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6016397.2233978 | 2096041.081358 | 37.7362499588234 | -122.385749620885 | (37.7362499588234, -122.385749620885) | 10 | 3 | 8 | 58 | 1 | |||
62181 | 68248 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3520 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 9 | Permit Number 32049 | 6001233.22938 | 2120683.51189 | 37.803061170692 | -122.439944038802 | (37.803061170692, -122.439944038802) | 13 | 9 | 1 | 57 | 17 | |
62350 | 182852 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2650 Noriega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5985710.8579 | 2103014.4562 | 37.7536511568713 | -122.49235691731 | (37.7536511568713, -122.49235691731) | 1 | 8 | 3 | 56 | 35 | |||
62650 | 251073 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5950 Geary Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5988478.7871 | 2112656.9627 | 37.7802882647701 | -122.483491767945 | (37.7802882647701, -122.483491767945) | 11 | 6 | 2 | 55 | 26 | |||
63779 | 141054 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 182 JORDAN AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5996267.7305 | 2113088.0713 | 37.7819222352183 | -122.456577560088 | (37.7819222352183, -122.456577560088) | 11 | 6 | 1 | 54 | 31 | |||
63996 | 141207 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 507 Presidio Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5999124.4336 | 2114808.0155 | 37.7868083520785 | -122.446818522107 | (37.7868083520785, -122.446818522107) | 15 | 6 | 1 | 54 | 31 | |||
64348 | 31196 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2850 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/1995 12:00:00 AM | 9 | Permit Number 34889 | 6000551.12743 | 2116522.04666 | 37.7915960349868 | -122.442005584417 | (37.7915960349868, -122.442005584417) | 13 | 6 | 1 | 29490 | 27 | ||
64746 | 122041 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 455 18th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5990274.11642 | 2112347.49183 | 37.7795428734376 | -122.477258337643 | (37.7795428734376, -122.477258337643) | 11 | 6 | 2 | 55 | 26 | |||
64873 | 118965 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4200 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5982527.34843 | 2110358.29833 | 37.7736286158531 | -122.503909900416 | (37.7736286158531, -122.503909900416) | 11 | 6 | 2 | 55 | 26 | |||
65362 | 250041 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 12 Daniel Burnham Ct | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6006178.42994 | 2114740.45377 | 37.7870232917354 | -122.422408506263 | (37.7870232917354, -122.422408506263) | 13 | 9 | 1 | 28858 | 41 | |||
66437 | 193930 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 102 Whitney Young Cir | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6016666.74671 | 2095388.93979 | 37.7344742192077 | -122.384772342665 | (37.7344742192077, -122.384772342665) | 10 | 3 | 8 | 58 | 1 | |||
67344 | 184253 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3801 Kirkham St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 0ft | 5983040.9906 | 2104896.6867 | 37.758662782026 | -122.501729007539 | (37.758662782026, -122.501729007539) | 1 | 8 | 3 | 56 | 35 | |||
67888 | 102993 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 633 Cabrillo St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 5993560.89928 | 2110699.78339 | 37.7752088603815 | -122.465768294056 | (37.7752088603815, -122.465768294056) | 11 | 6 | 2 | 54 | 11 | |||
67981 | 68990 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1878 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1994 12:00:00 AM | 9 | Permit Number 32983 | 5981356.0199 | 2102290.7237 | 37.7514084318433 | -122.507362958083 | (37.7514084318433, -122.507362958083) | 1 | 8 | 3 | 56 | 35 | |
68461 | 193772 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1509 11th St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6008849.49911 | 2108690.5122 | 37.770561904027 | -122.412739303188 | (37.770561904027, -122.412739303188) | 8 | 2 | 9 | 28853 | 19 | |||
68611 | 177635 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1150 Naples St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001299.26955 | 2087763.80738 | 37.7126754253012 | -122.43735686374 | (37.7126754253012, -122.43735686374) | 9 | 7 | 6 | 28861 | 5 | |||
69060 | 193875 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 669 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6012583.43161 | 2113915.28124 | 37.7851167892527 | -122.400190518577 | (37.7851167892527, -122.400190518577) | 6 | 2 | 9 | 28853 | 6 | |||
69358 | 184583 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1727 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5983756.4457 | 2103394.8248 | 37.7545810879519 | -122.499143705952 | (37.7545810879519, -122.499143705952) | 1 | 8 | 3 | 56 | 35 | |||
69672 | 34819 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 410 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1998 12:00:00 AM | 9 | Permit Number 38708 | 5982848.75903 | 2112994.92222 | 37.7808869096475 | -122.502993342165 | (37.7808869096475, -122.502993342165) | 11 | 6 | 2 | 55 | 26 | |
69823 | 131326 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3615 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5999135.58402 | 2121250.56661 | 37.8044985175422 | -122.44724379627 | (37.8044985175422, -122.44724379627) | 13 | 9 | 1 | 57 | 17 | |||
70283 | 119155 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 801 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5981355.12045 | 2110215.32961 | 37.7731670665249 | -122.507954131119 | (37.7731670665249, -122.507954131119) | 11 | 6 | 2 | 55 | 26 | |||
70294 | 209826 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1280 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5994580.14248 | 2106746.45295 | 37.7644127949494 | -122.461955789455 | (37.7644127949494, -122.461955789455) | 15 | 5 | 11 | 56 | 12 | |||
70356 | 106222 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 940 Elizabeth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6000384 | 2101992 | 37.7516906579726 | -122.441540701476 | (37.7516906579726, -122.441540701476) | 2 | 4 | 5 | 28862 | 22 | |||
71969 | 184526 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1951 48th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5981337.4067 | 2101560.071 | 37.7494011691345 | -122.507373119597 | (37.7494011691345, -122.507373119597) | 1 | 8 | 3 | 29491 | 35 | |||
72604 | 250777 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 260 32nd Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5985911.46226 | 2114170.84002 | 37.7842951758189 | -122.492484724217 | (37.7842951758189, -122.492484724217) | 11 | 6 | 1 | 55 | 33 | |||
73777 | 96474 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1300 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2011 12:00:00 AM | 9 | 3x3 | Permit Number 767969 | 5989923.5422 | 2103151.3142 | 37.7542723197964 | -122.477798680667 | (37.7542723197964, -122.477798680667) | 1 | 8 | 3 | 56 | 35 | |
74253 | 2761 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 150 Cabrillo St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/1998 12:00:00 AM | 9 | 3X3 | 5995092.18502 | 2110809.76975 | 37.7755990639679 | -122.460479239153 | (37.7755990639679, -122.460479239153) | 11 | 6 | 2 | 54 | 11 | ||
76845 | 251077 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5524 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5989829.1581 | 2112705.6659 | 37.7805004932121 | -122.478823825166 | (37.7805004932121, -122.478823825166) | 11 | 6 | 2 | 55 | 26 | |||
77175 | 118967 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4232 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5982440.1485 | 2110355.12154 | 37.773614765391 | -122.504211297791 | (37.773614765391, -122.504211297791) | 11 | 6 | 2 | 55 | 26 | |||
77252 | 68994 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1907 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1994 12:00:00 AM | 9 | Permit Number 32987 | 5981319.8087 | 2102052.4747 | 37.7507521343141 | -122.507470502944 | (37.7507521343141, -122.507470502944) | 1 | 8 | 3 | 29491 | 35 | |
77283 | 231802 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 128 Roosevelt Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001393.65786 | 2107482.835 | 37.7668246255709 | -122.438442537016 | (37.7668246255709, -122.438442537016) | 15 | 5 | 5 | 28862 | 3 | |||
77370 | 209960 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 170 Wawona St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5992752.60751 | 2098040.57043 | 37.7404033073569 | -122.467643490557 | (37.7404033073569, -122.467643490557) | 1 | 8 | 4 | 59 | 40 | |||
78266 | 139061 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2737 SUTTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5999469.5879 | 2113945.446 | 37.78445967257 | -122.44556232351 | (37.78445967257, -122.44556232351) | 15 | 6 | 11 | 29490 | 31 | |||
78975 | 131248 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2900 Divisadero St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6000566.6356 | 2118365.98432 | 37.7966598871931 | -122.442084343421 | (37.7966598871931, -122.442084343421) | 13 | 9 | 1 | 57 | 17 | |||
79619 | 124192 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Rossi Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5996288.20718 | 2112097.2031 | 37.7792027490858 | -122.45643504799 | (37.7792027490858, -122.45643504799) | 11 | 6 | 2 | 54 | 16 | |||
79781 | 66295 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2101 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/1990 12:00:00 AM | 9 | Permit Number 29406 | 5986495.0816 | 2097061.7763 | 37.7373525128537 | -122.489207312631 | (37.7373525128537, -122.489207312631) | 1 | 8 | 3 | 64 | 35 | ||
81148 | 193806 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 51 Madera St | 4 | : | Tree | Private 2 | 9 | Width 3ft | 6012889.21828 | 2103238.73501 | 37.755818440888 | -122.39838319603 | (37.755818440888, -122.39838319603) | 10 | 3 | 8 | 28856 | 29 | |||
81453 | 209888 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1955 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5991576.16284 | 2102122.4694 | 37.7515431538097 | -122.472008574048 | (37.7515431538097, -122.472008574048) | 1 | 8 | 4 | 29491 | 12 | |||
82952 | 213277 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1400 Holloway Ave | 9 | : | Tree | Private 2 | 9 | Width 0ft | 5991091.24453 | 2091195.38436 | 37.7215120845989 | -122.472888754009 | (37.7215120845989, -122.472888754009) | 9 | 8 | 4 | 64 | 40 | |||
82992 | 184969 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2701 Sunset Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5985054.0437 | 2096596.7357 | 37.7359914154416 | -122.494155310705 | (37.7359914154416, -122.494155310705) | 1 | 8 | 3 | 29491 | 35 | |||
83245 | 131636 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 John Maher St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6012488.72872 | 2119699.54646 | 37.8009937282283 | -122.400924705329 | (37.8009937282283, -122.400924705329) | 3 | 1 | 10 | 28860 | 6 | |||
83666 | 140716 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1119 Hayes St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6002518.01 | 2110555.1842 | 37.7753244286337 | -122.434773320806 | (37.7753244286337, -122.434773320806) | 15 | 5 | 11 | 29492 | 10 | |||
84079 | 183234 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2001 37th Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5984771.0343 | 2100862.7529 | 37.7476881804874 | -122.495448305532 | (37.7476881804874, -122.495448305532) | 1 | 8 | 3 | 29491 | 35 | |||
84212 | 251018 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5000 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5991502.3956 | 2112766.628 | 37.780764894466 | -122.473039809999 | (37.780764894466, -122.473039809999) | 11 | 6 | 2 | 54 | 26 | |||
84265 | 250032 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Daniel Burnham Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6006018.87581 | 2114696.26596 | 37.7868929610919 | -122.422957386799 | (37.7868929610919, -122.422957386799) | 13 | 9 | 1 | 28858 | 41 | |||
84394 | 177737 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 123 Santa Ysabel Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 6000610.73468 | 2093300.56234 | 37.7278389330103 | -122.44013343693 | (37.7278389330103, -122.44013343693) | 9 | 7 | 6 | 28861 | 25 | |||
84403 | 183200 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3840 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5984040.0473 | 2098180.2019 | 37.740279798369 | -122.497777933308 | (37.740279798369, -122.497777933308) | 1 | 8 | 3 | 29491 | 35 | |||
85277 | 182764 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1212 Noriega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5990213.4758 | 2103159.8679 | 37.7543126283639 | -122.476796653052 | (37.7543126283639, -122.476796653052) | 1 | 8 | 3 | 56 | 35 | |||
87742 | 118912 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 787 La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5980724.35298 | 2110402.47948 | 37.7736437394687 | -122.510149905624 | (37.7736437394687, -122.510149905624) | 11 | 6 | 2 | 55 | 26 | |||
88842 | 131633 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 John Maher St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6012478.4844 | 2119690.22702 | 37.8009675678597 | -122.400959500108 | (37.8009675678597, -122.400959500108) | 3 | 1 | 10 | 28860 | 6 | |||
88986 | 131605 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 982 Green St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 6008358.64628 | 2118966.19584 | 37.7987488873077 | -122.415164657846 | (37.7987488873077, -122.415164657846) | 5 | 1 | 10 | 308 | 32 | ||||
89161 | 140797 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 81 COMMONWEALTH AVE | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 0ft | 5996499.7187 | 2113990.1346 | 37.7844123778956 | -122.455840222027 | (37.7844123778956, -122.455840222027) | 11 | 6 | 1 | 54 | 31 | |||
90359 | 5029 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5320 Diamond Heights Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/04/1992 12:00:00 AM | 9 | 9x3 | 6001770.6321 | 2098671.0518 | 37.7426510225206 | -122.436507882156 | (37.7426510225206, -122.436507882156) | 2 | 7 | 5 | 63 | 7 | ||
91682 | 34591 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3090 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 9 | Permit Number 38287 | 5999399.75701 | 2116686.65889 | 37.7919823378628 | -122.446001143641 | (37.7919823378628, -122.446001143641) | 13 | 6 | 1 | 29490 | 27 | |
92059 | 137951 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1615 SUTTER ST | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004970.504 | 2114707.5117 | 37.7868646270127 | -122.426585315267 | (37.7868646270127, -122.426585315267) | 13 | 9 | 11 | 28858 | 13 | |||
92065 | 251105 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 6304 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5987422.1962 | 2112616.8857 | 37.7801166713422 | -122.487144012663 | (37.7801166713422, -122.487144012663) | 11 | 6 | 2 | 55 | 26 | |||
92483 | 184593 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1734 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5983803.4863 | 2103347.4457 | 37.7544537575455 | -122.498977529313 | (37.7544537575455, -122.498977529313) | 1 | 8 | 3 | 56 | 35 | |||
92880 | 131043 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1860 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6005791.04061 | 2116920.26883 | 37.7929866593525 | -122.423903850404 | (37.7929866593525, -122.423903850404) | 13 | 9 | 1 | 28858 | 27 | |||
93029 | 142804 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 401 Larkin St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6007611.6893 | 2112827.727 | 37.7818521556351 | -122.417314140113 | (37.7818521556351, -122.417314140113) | 7 | 9 | 9 | 28852 | 36 | |||
93469 | 251062 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5200 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 5990839.4471 | 2112742.2283 | 37.7806594950794 | -122.47533146456 | (37.7806594950794, -122.47533146456) | 11 | 6 | 2 | 54 | 26 | |||
94751 | 210022 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 671 Rockdale Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5997638.40233 | 2098157.8739 | 37.7410062812267 | -122.450758874739 | (37.7410062812267, -122.450758874739) | 9 | 7 | 4 | 59 | 40 | |||
95276 | 231421 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2291 Harrison St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008819.79091 | 2105170.59256 | 37.7608953503479 | -122.412593200224 | (37.7608953503479, -122.412593200224) | 2 | 4 | 7 | 28859 | 19 | |||
96382 | 42532 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 551 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2000 12:00:00 AM | 9 | Permit Number 42639 | 6014113.73762 | 2112237.82426 | 37.7805960852718 | -122.394778581086 | (37.7805960852718, -122.394778581086) | 6 | 2 | 9 | 28856 | 6 | ||
96390 | 38668 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 917 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/01/1998 12:00:00 AM | 9 | Permit Number 40587 | 6000931.2676 | 2111861.7153 | 37.7788216194249 | -122.44035593667 | (37.7788216194249, -122.44035593667) | 15 | 5 | 11 | 29490 | 41 | |
96898 | 245902 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 132 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6001329.5899 | 2109317.4651 | 37.7718584195301 | -122.438795618701 | (37.7718584195301, -122.438795618701) | 15 | 5 | 11 | 29492 | 9 | |||
97471 | 232260 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 173 Addison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6002565.78434 | 2097591.06825 | 37.7397307907517 | -122.433681309348 | (37.7397307907517, -122.433681309348) | 2 | 7 | 5 | 63 | 7 | |||
97550 | 140876 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 48 Wood St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5998420.5162 | 2113424.5472 | 37.7829694734183 | -122.449154195959 | (37.7829694734183, -122.449154195959) | 15 | 6 | 1 | 54 | 31 | |||
98150 | 232691 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 51 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6005633.83102 | 2099612.43348 | 37.7454546113522 | -122.42321694373 | (37.7454546113522, -122.42321694373) | 2 | 7 | 5 | 28859 | 22 | |||
98785 | 98021 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1600 Taraval St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 5988202.6314 | 2099008.2014 | 37.7427964094941 | -122.483446241685 | (37.7427964094941, -122.483446241685) | 1 | 8 | 3 | 29491 | 35 | |||
98790 | 231263 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100 Alemany Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009515.94764 | 2096021.31203 | 37.7358124949589 | -122.40953973747 | (37.7358124949589, -122.40953973747) | 10 | 7 | 7 | 28859 | 2 | |||
100116 | 131344 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3540 Jackson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5997301.2731 | 2116067.27988 | 37.7901616361086 | -122.453217140077 | (37.7901616361086, -122.453217140077) | 11 | 6 | 1 | 54 | 31 | |||
100756 | 68033 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1558 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/1993 12:00:00 AM | 9 | Permit Number 31767 | 5981280.1279 | 2104451.8685 | 37.757337851095 | -122.507785755945 | (37.757337851095, -122.507785755945) | 1 | 8 | 3 | 56 | 35 | ||
100881 | 118970 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4300 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5982213.34677 | 2110346.19195 | 37.7735769063152 | -122.504995164124 | (37.7735769063152, -122.504995164124) | 11 | 6 | 2 | 55 | 26 | |||
102576 | 131656 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 47 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6011704.33953 | 2115648.65277 | 37.7898271620367 | -122.403353903679 | (37.7898271620367, -122.403353903679) | 4 | 1 | 10 | 28854 | 6 | |||
103108 | 213158 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 735 Holloway Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5994547.17011 | 2091221.80948 | 37.7217841079221 | -122.460944561138 | (37.7217841079221, -122.460944561138) | 9 | 8 | 6 | 28861 | 24 | |||
103715 | 193877 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 669 Howard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6012620.25862 | 2113949.06657 | 37.7852116092632 | -122.400065481331 | (37.7852116092632, -122.400065481331) | 6 | 2 | 9 | 28853 | 6 | |||
103801 | 200006 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1435 Griffith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6017639.2874 | 2092216.5923 | 37.7258173144878 | -122.381189412568 | (37.7258173144878, -122.381189412568) | 10 | 3 | 8 | 58 | 1 | |||
103990 | 193878 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 669 Howard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6012633.7101 | 2113963.35576 | 37.7852515940314 | -122.400019946889 | (37.7852515940314, -122.400019946889) | 6 | 2 | 9 | 28853 | 6 | |||
104570 | 39235 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 Golden Gate Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1998 12:00:00 AM | 9 | Permit Number 40872 | 6007429.24766 | 2112675.63731 | 37.781424288039 | -122.417934520279 | (37.781424288039, -122.417934520279) | 7 | 9 | 9 | 28852 | 36 | ||
104667 | 67057 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 813 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/1992 12:00:00 AM | 9 | Permit Number 30438 | 5981358.92091 | 2110168.61709 | 37.7730390315612 | -122.507937517673 | (37.7730390315612, -122.507937517673) | 11 | 6 | 2 | 55 | 26 | ||
105145 | 177582 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 617 Morse St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5999225.92078 | 2087392.71996 | 37.7115384151318 | -122.444496335044 | (37.7115384151318, -122.444496335044) | 9 | 7 | 6 | 28861 | 5 | |||
105510 | 193950 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1333 Hudson Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6017943.23791 | 2094595.88908 | 37.732367174196 | -122.380303947776 | (37.732367174196, -122.380303947776) | 10 | 3 | 8 | 58 | 1 | |||
105522 | 231276 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2750 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009682.29634 | 2105036.12382 | 37.7605744983285 | -122.409600670138 | (37.7605744983285, -122.409600670138) | 2 | 4 | 8 | 28859 | 19 | |||
105530 | 119223 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 735 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5981025.6499 | 2110691.86737 | 37.7744560808806 | -122.509129185905 | (37.7744560808806, -122.509129185905) | 11 | 6 | 2 | 55 | 26 |
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) );